DBA ERRORS

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...

Use below script to get the details about undo tablespace usage. select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB - USAGEMB) FREEMB...

Run the below scripts to get the temp tablespace usage. select a.tablespace_name tablespace, d.TEMP_TOTAL_MB, sum (a.used_blocks *...

Use below query to get the size of a database. col "Database Size" format a20 col "Free space" format a20 col "Used space" format a20...

Use below script to get the current running sql details. select sesion.sid, sesion.username, optimizer_mode, hash_value, address,...

Below query will display the the list of sessions using lot of temps including their usage. SELECT b.TABLESPACE , b.segfile# ,...

Use below script to find active sessions in oracle database. set echo off set linesize 95 set head on set feedback on col sid head "Sid"...