Xavier Morera

16 Flips | 1 Magazine | 14 Followers | @xavimorera | Keep up with Xavier Morera on Flipboard, a place to see the stories, photos, and updates that matter to you. Flipboard creates a personalized magazine full of everything, from world news to life’s great moments. Download Flipboard for free and search for “Xavier Morera”

Archivo de portadas

<b>30 julio 2015</b> Comprar portada impresa Comprar ejemplar Descargar portada<p>Síguenos en<p>Ibex 9.980,60 0,56<p>Cac 5.520,50 0,68<p>FTSE 7.520,36 0,15<p>S&P 2.632,81 …

Finding the slowest SQL execution of the same query

When running the same query multiple times, several questions come to mind:<p>Does the query always execute in the same amount of time?<br>• If some …

Warp Speed with Temp Tablespace Groups

The introduction of the temp tablespace was a crucial step in the RDBMS to separating the “work area” for sorting and specific join operations from …

Tool to Add Range Partitions Automatically to a Table

Continuing on my earlier posts on partitioning, here are is another tool on this topic. If you have been using partitioned tables, you might have …

Oracle CPU Time

Image from Bertrand Drouvot<p>UPDATE: thanks to a discussion in the comments it’s come to my attention that there should be some more clarification on …

Databases

YASTS: Yet Another SQL Tuning Script

Having SQLTXPLAIN and SQLHC available, WHY do I need yet another way to display execution plans?<p>New script planx.sql reports execution plans for one …

Diagnosing buffer busy waits with the ash_wait_chains.sql script (v0.2)

In my previous post ( Advanced Oracle Troubleshooting Guide – Part 11: Complex Wait Chain Signature Analysis with ash_wait_chains.sql ) I introduced …

Oracle “Physical I/O” ? not always physical

A customer called and wanted to know why the development database was so much slower than production when both databases were on the same type of …

Databases

Comment on Reverse Key by jgarry

It seems proxy pdb’s address this issue by using the link only for creation, then normal network protocols for actual communication: …

Meaning of "Disk Reads" values in DBA_HIST_SQLSTAT

I created a new AWR snapshot and enabled tracing for my session. I made sure the db_file_multiblock_read_count parameter was set to a high value and …

Databases

Drill down to sql_id execution details in ASH

Some times ago I explained how we can link a huge PGA or TEMP consumption to a sql_id over a period of time into this blog post.<p>Now I need to extract …

High Performance Tuning Tools

Obligatory Melodrama<p>No matter how much time goes by I still remember it. The day my database was crippled beyond reckoning. That moment when I saw my …

Databases

Mining the AWR to Identify Performance Trends

Sometimes it’s useful to check how performance of a SQL statement changes over time. The diagnostic pack features provide some really useful …

Comment on dbms_space usage by Simple scripts | Oracle Scratchpad

[…] Hakan Factor: A procedure – owned by SYS – that reports the Hakan factor for an object. Segment Space: A script to report on space usage within …

Multiple Database Block Sizes and the Buffer Cache

In oracle 10g we can have multiple block sizes at the same time. When a tablespace is created we can assign a block size for the objects that will be …