Restrict the access of using any application in Oracle
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…
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…