Script of Logon Trigger for restrict the access of application with Oracle User. AS an example, following script show the restrict of SQLPLUS.EXE application to access for normal user. I …

 Supplemental logging is generate or add extra logging information for the change data capture process which is used for capturing the changes like insert/update/delete operation with unique identified a row …

 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 …