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 …
-
-
STATS of table is STALE after gathering stats in Oracle I tried to gather the stats of the table but after that gather still its in STALE state. Solution To …
-
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 …
-
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 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. …
-
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 …