Oracle

 Find the Session/ program / module / SQL Query using high temp tablespace usages Find the session using high temporary tablespace: col inst_id format 999 col sid format 99999 col …

Run the preupgrade utility from command shell for upgrade 12c to 19c Set the new Oracle Home which installed for Oracle 19c SET ORACLE_HOME=D:\Software\WINDOWS.X64_193000_db_home SET PATH=%ORACLE_HOME%/bin;%PATH% Run the preupgrade command …

💡 Check stuck job with resume time or error detail with dba_resumable view DBA_RESUMABLE view will help to see the all suspended session and cause of error. If we will fixed …

 What is database response time in Oracle Basic definition of Database Response Time means Service Time plus Wait time. Response Time = Service Time(execution time) + Wait Time Service time is the …

Script to find the Username which causing bottleneck of CPU in Oracle select * from ( SELECT se.username, ROUND (value/100) “CPU Usage” FROM v$session se, v$sesstat ss, v$statname st WHERE …

 Tune log buffer space or log file sequential read waits in Oracle In AWR report, we are getting waits for log event. Event Waits TotalWaitTime(s) Avg wait Waits/txn %bgtime log …

 In Oracle 12cR2, we can convert non partitioned table to partitioned online using alter table command. First identified the column on which we will make non-partition table to partition table. …

 For create a job in DBMS Scheduler, exact method is first create a schedule, then create a program and then a job. Create a schedule BEGIN DBMS_SCHEDULER.CREATE_SCHEDULE ( Schedule_name => …

In Flashback recovery, you can create restore point before any upgrade, patching and application testing activity. We can create restore point in two ways: Norman Restore Point: Its age out with …

 Find the query taking long time to execute in Oracle Select module,parsing_schema_name,inst_id,sql_id,CHILD_NUMBER,sql_plan_baseline,sql_profile,plan_hash_value,sql_fulltext, to_char(last_active_time,’DD/MM/YY HH24:MI:SS’ ),executions, elapsed_time/executions/1000/1000, rows_processed,sql_plan_baseline from gv$sql where executions <> 0 order by elapsed_time/executions desc Find the highest …