RAC Wait event gc buffer busy acquire indicates that the session experiencing this event is waiting on another session on the same instance to release the block. Basically the waiting session is not able to pin a block, and will wait on this event until it can pin the block. (gc buffer busy release means […]
When a SQL runs, the time it takes to run is basically come from the CPU time needed plus the time for waits. The following SQL looks into gv$active_session_history and finds the time the SQL spends on each wait event or CPU The Script — — — sqlwaits.sql — Parameters – none — — Purpose: […]
Package calls are very common. It will be helpful if we can find out the top SQLs from such a call The following script is written for that purpose. It basically looks into the AWR and pulls all SQLs that were run as part of a package call. Please note: The script assumes a package […]
It is useful to be able to see all SQLs that are running along with how long it has been running, and the number of parallel sessions opened by the session running it etc. The following script can do the job. Some of the columns are self explanatory. For other columns , a brief explanation is […]
Often, to evaluate a SQL, we need to examine how it performed in the past. Few things are important here: 1. Average elapsed time 2. Buffer gets per execution 3. Frequency of execution (how many times it executes on an hourly/daily basis) The following script can be used to generate this information from AWR. The script […]
Theme Layout
Color Scheme