Hi, today we are going to create script which automatically kill inactive sessions in oracle database. Here i’m going to kill 15 minutes old inactive sessions. Related Keywords: oracle inactive sessions …
Category:
Performance Tuning
-
-
-
Find active transactions in oracle database Script can be used to find the active transactions. col name format a10 col username format a8 col osuser format a8 col start_time format a17 …
-
How to find the maximum user doing commit operation or transaction in Oracle DB Script helpful in tracking the number of transactions in the database. Note: It used the AWR …
-
-
Monitor parallel queries running in Oracle Database Query to monitor currently running queries with parallel option: select s.inst_id, decode(px.qcinst_id,NULL,s.username, ‘ – ‘||lower(substr(s.program,length(s.program)-4,4) ) ) “Username”, decode(px.qcinst_id,NULL, ‘QC’, ‘(Slave)’) “QC/Slave” , …
-
Check execution time and plan for SQL ID from the history table in Oracle dba_hist_active_sess_history table is used to fetch the information about SQL id set linesize 150 col exec_start …
-
Check the Memory usage used by Oracle from Operating System Check the SGA_TARGET and PGA_TARGET size : SQL> select sum(value)/1024/1024/1024 from v$parameter where name in (‘sga_target’,’pga_aggregate_target’); SUM(VALUE)/1024/1024/1024 ————————- 1.5 If …
-
Check maximum query duration in Oracle for undo retention setting Check the maximum query duration in Oracle: SQL> select max(maxquerylen) from v$UNDOSTAT; SQL> select max(maxquerylen) from DBA_HIST_UNDOSTAT; Set the undo …
-