We have discussed on How Optimizer works in our previous article. Please find the article here Performance Tuning – Part4 Now we will discuss about the SQL Tuning. SQL TUNING Before going into how to perform SQL Tuning, let us begin with Thumb Rules… Read More
Till now in my previous articles we have discussed about the tools that are used in the performance tuning. Please find the previous article here. Performance Tuning in Oracle – Part3 Before we go in depth of the Performance tuning, it is important to… Read More
Performance Tuning Tools This is the continuation to the previous article about the Tools used in the performance Tuning. Please find the previous article here. Performance Tuning in Oracle – Part2 In this article we will discuss about Oracle SQL Tuning advisor and baseline.… Read More
Performance Tuning Tools We have discussed the tools that are being used for Performance Tuning in our previous article. Please find the article here Performance Tuning in Oracle – Part1 In this article we will be discussing the additional tools which are used in… Read More
Introduction of Performance Tuning: Performance tuning plays an important role in the DBA life. Performance tuning refers in the following areas: 1. Instance tuning 2. SQL tuning 3. Memory, Storage (I/O) 4. Network tuning 5. OS tuning For OS Tuning and Network tuning DBAs… Read More
Check existing retention and current snapshot interval. set linesize 300 select extract( day from snap_interval) *24*60+extract( hour from snap_interval) *60+extract( minute from snap_interval ) snapshot_interval, extract( day from retention) *24*60+extract( hour from retention) *60+extract( minute from retention ) retention_interval, topnsql from dba_hist_wr_control; Below query is… Read More
AWR Difference Report for NON RAC: @?/rdbms/admin/awrddrpt.sql AWR Difference Report for RAC : @?/rdbms/admin/awrddrpi.sql AWR Report for Non RAC : @?/rdbms/admin/awrrpt AWR Report for RAC : @?/rdbms/admin/awrrpti Global AWR RAC Report : @?/rdbms/admin/awrgrpt.sql ASH Report : @?/rdbms/admin/ashrpt.sql GLOBAL AWR RAC Differenct Report : @?/rdbms/admin/awrgdrpt.sql AWR… Read More
1. EXPLAIN PLAN FOR SELECT <STATEMENT> set linesize 300SELECT * FROM TABLE(dbms_xplan.display); 2. FROM MEMORY – Get the execution plan which is generated by CBO Use DBMS_XPLAN package:select * from table (dbms_xplan.display_cursor (‘&sqlid’) ) ; For the above, you need to have SQL ID. To… Read More
Ask DB details and query details before start working on it. When did this query last took 2 hours?What is the change in volume of data?How many times this query runs each day?Start and end time of this query execution for past 1 month.Any DDL changes… Read More
