select username, tablespace ,sql_id from v$tempseg_usage; (or) select S.sid,S.username,U.tablespace,S.sql_hash_value ||’/’|| U.sqlhash hash_value, U.segtype,u.contents,U.blocks from v$session S, v$tempseg_usage U where S.saddr=U.session_addr order by U.blocks; (or) select S.sid, S.username “DB_USER”, P.username “OS_USER”…
Read MoreIf you are using local naming (TNSNAMES.ORA file): Make sure that “TNSNAMES” is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA) Verify…
Read MoreTable_Exists_Action used in impdp if table is already exists in the database where you want to import. TABLE_EXISTS_ACTION = SKIP Table_Exists_Action =Skip: skip is for skipping the table which are…
Read MoreNote: Tables containing ‘$’ SYMBOL and when ever we use tables like v$session,v$log,v$logfile etc shell script take ‘$’ SYMBOL as shell variables and then while reading script it gives error…
Read MoreselectSQL_ID, PLAN_HASH_VALUE, sum(EXECUTIONS_DELTA) EXECUTIONS, sum(ROWS_PROCESSED_DELTA) CROWS, trunc(sum(CPU_TIME_DELTA)/1000000/60) CPU_MINS, trunc(sum(ELAPSED_TIME_DELTA)/1000000/60) ELA_MINSfrom DBA_HIST_SQLSTATwhere SQL_ID in (‘&sqlid’)group by SQL_ID , PLAN_HASH_VALUEorder by SQL_ID, CPU_MINS/
Read Moreset pages 50000 lines 32767col username format a12col sid format 9999col state format a15col event format a50col wait_time format 99999999set pagesize 100set linesize 120 select s.sid, s.username, se.event, se.state, se.wait_timefrom…
Read Morecol PHYRDS format 99,999,999 col PHYWRTS format 99,999,999 ttitle “Disk Balancing Report” col READTIM format 99,999,999 col WRITETIM format 99,999,999 col name format a30 select name, phyrds, phywrts, readtim, writetim…
Read Moreset serveroutput on set serveroutput on size 1000000 declare sql_string varchar2(2000); CURSOR OBJ IS select owner,table_name from dba_tables where last_analyzed is null –and OWNER=’&owner’ ; begin for REC1 IN OBJ…
Read MoreACCEPT user_namen CHAR PROMPT 'Schema Owner: ' set feed off; set pagesize 10000; set wrap off; set linesize 200; set heading on; set tab on; set scan on; set verify…
Read MoreOUI-67076: opatch lsinventory Error Faced an issue with command ‘opatch lsinventory’ and reports below error in log file. Cause: OUI-67076:OracleHomeInventory was not able to create a lock file, probably due…
Read More