DBA ERRORS

select * from ( select SQL_ID, sum(CPU_TIME_DELTA), sum(DISK_READS_DELTA), count(*) from DBA_HIST_SQLSTAT a, dba_hist_snapshot s where...

select open_mode from v$database; spool rp.st select 'alter tablespace ' || tablespace_name || ' add tempfile ' || '''' || file_name...

Steps to configure 11G Physical Standby Database Oracle rdbms software is installed with one database(proddb) following is details...

alter table INCMS.CIN_T_CCN_CDR drop partition TKT_2014_FEB26 update global indexes; alter table INCMS.CIN_T_CCN_CDR drop partition...

Below query will help you in providing sessions causing lock in the database. col session_id head 'Sid' form 9999 col object_name head...

Use below query to check all the space related details of tablespaces. set feedback off set pagesize 70; set linesize 2000 set head on...