Check the session using high temporary tablespace in 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…
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…