Database Scripts

Welcome everyone get the dba erros & solutions here

CPU intensive SQL statements executed between 9.00 AM and 11.00 AM

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

shiva ram

Nov 2, 20241 min read

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

shiva ram

Nov 2, 20241 min read

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

shiva ram

Oct 12, 20245 min read

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

shiva ram

Oct 12, 20241 min read