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

//DBA Issues

What is the equivalent of Oracle's explain plan command in MySQL ?

By | August 26th, 2012|Database, DBA Issues, DBA Miscellaneous, MySql, Oracle DBA|

The Explain Plan command in Oracle generates information that details the execution plan that will be used on a particular query. It uses a pre-existing table (PLAN_TABLE) in the current schema to store information about the execution plan chosen by the optimizer. The plan table is populated using the explain plan command: [crayon-594d9751920d2113694306/] [crayon-594d9751920ea634282769/] [crayon-594d9751920f4898807141/] The only [...]

Read only access to the Oracle DBA Perfstat schema

By | April 17th, 2011|DBA Issues, Oracle DBA|

Oracle has its own user named Perfstat which is created by default at the time of Statspack installation. The below are the list of Privileges and roles granted to the Perfstat user at the time of statspack installation. ADVANTAGES OF PERFSTAT USER The Perfstat user can not see the application data. The Perfstat user cannot [...]

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 [...]