Database Administrator

http://www.toadworld.com/Experts/GuyHarrisonsImprovingOraclePerformance/ResolvingOracleContention/tabid/257/Default.aspx http://www.dba-or...

 http://www.oracleangels.com/2011/05/useful-tracing-commands-oradebug-oracle.html -- There is an option that is helpful when the databse i...

set serverout on size 1000000 declare top5 number; text1 varchar2(4000); x number; len1 number; Cursor c1 is select buffer_gets,sub...

If you noticed that a session is using too much CPU, you can identify the actions performed by that session using top and Explain Plan. So...

– Listing of temp segments.– SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used, ...

-- Top 30 I/O Intensive SQL Statements Identification : top30iosql.sql set linesize 80 set pagesize 58 set heading on set serveroutput ...

Redo logs are extremely write intensive, and high bandwidth storage such as SSD are ideas for relieving I/O bottlenecks.  Also, online redo...

Is it possible to issue an INSERT statement or an UPDATE statement without generating Redo Logs and Undo? This UNDO information itself ge...

exec  DBMS_SCHEDULER.drop_job ('analyze'); BEGIN   DBMS_SCHEDULER.create_job (     job_name        => 'analyze',  ...

alter system set SESSION_CACHED_CURSORS=500 scope=spfile; If an application repeatedly issues parse calls on the same set of SQL stateme...

Following Steps to perform. SYSAUX tablespace SELECT *  FROM dba_jobs WHERE SCHEMA_USER='SYSMAN'; SELECT *  FROM SYSMAN.mgmt_m...

Resolving common Oracle Wait Events Wait Event Possible Causes Actions Remarks db file sequential reads Use of an unsel...