This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

This Is A Custom Widget

This Sliding Bar can be switched on or off in theme options, and can take any widget you throw at it or even fill it with your custom HTML Code. Its perfect for grabbing the attention of your viewers. Choose between 1, 2, 3 or 4 columns, set the background color, widget divider color, activate transparency, a top border or fully disable it on desktop and mobile.

DBA Issues

/Tag:DBA Issues

SCRIPT TO MONITOR MEMORY USAGE BY DATABASE SESSIONS

By | December 26th, 2010|DBA Issues, Oracle DBA|

============================================================================= SCRIPT TO MONITOR MEMORY USAGE BY DATABASE SESSIONS ============================================================================= REM Created: 29/June/2010 REM Last update: 29/June/2010 REM REM NAME REM ==== REM MEMORY.sql REM REM REM DISCLAIMER REM ========== REM This script is provided for educational purposes only. It is NOT supported by REM Oracle World Wide Technical Support. The script has been tested [...]

Detailed Lock Scripts in Oracle

By | December 26th, 2010|DBA Issues, Oracle DBA|

################################################################################ prompt "Identify the blocking session" prompt "=================================================" select * from v$lock ; prompt "" prompt "" prompt "" prompt "Note the BLOCK column. If a session holds a lock that's blocking another session, BLOCK=1." prompt "Further, you can tell which session is being blocked by comparing the values in ID1 and ID2." prompt "The [...]

Locked Query Script in Oracle 9i

By | December 26th, 2010|DBA Issues, Oracle DBA|

################################################################################ SELECT OBJECT_NAME, SID, OSUSER, SCHEMANAME, RECURSIVE, LAST_CALL_ET/(60) MINUTES, (case type when 'TM' then 'DML/TABLE LOCK' when 'TX' then 'TRANSACTION LOCK' when 'MR' then 'MEDIA RECOVERY' when 'ST' then 'DISK SPACE TRANSACTION' when 'UL' then 'USER SUPPLIED' else 'LOCKED' end) LOCK_TYPE, decode(lmode,0,'NONE',1,'NULL',2,'ROW S',3,'ROW X',4,'TABLE S',5,'SHARED ROW X',6,'TABLE X',NULL) LOCK_MODE, decode(REQUEST,0,'NONE',1,'NULL',2,'ROW S',3,'ROW X',4,'TABLE S',5,'SHARED ROW X',6,'TABLE [...]

Locked Query Script in Oracle 10g

By | December 26th, 2010|DBA Issues, Oracle DBA|

############################################################################## SELECT OBJECT_NAME, SQL_TEXT,SID, OSUSER, SCHEMANAME, RECURSIVE, LAST_CALL_ET/(60) MINUTES, (case type when 'TM' then 'DML/TABLE LOCK' when 'TX' then 'TRANSACTION LOCK' when 'MR' then 'MEDIA RECOVERY' when 'ST' then 'DISK SPACE TRANSACTION' when 'UL' then 'USER SUPPLIED' else 'LOCKED' end) LOCK_TYPE, decode(lmode,0,'NONE',1,'NULL',2,'ROW S',3,'ROW X',4,'TABLE S',5,'SHARED ROW X',6,'TABLE X',NULL) LOCK_MODE, decode(REQUEST,0,'NONE',1,'NULL',2,'ROW S',3,'ROW X',4,'TABLE S',5,'SHARED ROW X',6,'TABLE [...]