DBA ERRORS

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

While importing in an Oracle 12c database, got the below error: ERROR: impdp dumpfile=teset2.dmp logfile=imp_teset2.lod...

PROBLEM: While granting sysdba privilege to an user, got below error. SQL> grant sysdba to MONITUSER; *ERROR at line 1:ORA-28017: The...