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 Miscellaneous

//DBA Miscellaneous

Managing a Standby Database – Commands

By | December 16th, 2013|Database, DBA Miscellaneous, Oracle DBA|

ALTER DATABASE ACTIVATE [PHYSICAL] STANDBY DATABASE [SKIP [STANDBY LOGFILE]]   Changes the state of a standby database to an active database and prepares it to become the primary database.  ALTER DATABASE ADD [STANDBY] LOGFILE [THREAD integer] [GROUP integer]filespec Adds one or more redo log file groups to the specified thread, making them available to the instance assigned [...]

Graceful Switchover and Switchback for Oracle 9i Physical Standby Database

By | March 11th, 2013|DBA Miscellaneous, Oracle DBA|

Description  When activating a standby database with the documented procedures using the alter database activate standby database command, Oracle does an implicit resetlogs operation. This operation is required when recovering from a standby controlfile, backup controlfile, creating a new controlfile with the resetlogs operation, or when executing point in time recovery. The resetlogs operation helps [...]

Oracle Database 10g Release 2 Automatic Storage Management – understanding

By | March 11th, 2013|DBA Miscellaneous, Oracle DBA|

Understanding Automatic Storage Management (ASM) Introduction             One of the biggest and best enhancements in Oracle 10g release is the Automatic Storage Management (ASM) feature. ASM is a cluster file system that can be used either in a standalone Oracle instances or with Oracle Real Application Cluster (RAC) to provide a vertically integrated subsystem encapsulating [...]

Script to identify Long Running Statements in Database

By | September 15th, 2012|DBA Miscellaneous, Oracle DBA|

rem LONGOPS.SQL  rem Long Running Statements  rem Helmut Pfau, Oracle Deutschland GmbH  set linesize 120  col opname format a20  col target format a15  col units format a10  col time_remaining format 99990 heading Remaining[s]  col bps format 9990.99 heading [Units/s]  col fertig format 90.99 heading "complete[%]"  <<<<< select sid,         opname,         target,         sofar,         [...]

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-594d9796c2202756756496/] [crayon-594d9796c2215306014758/] [crayon-594d9796c221a239916883/] The only [...]

Temporary segment cleanup in Oracle

By | April 29th, 2012|DBA Miscellaneous, Oracle DBA|

  When does SMON cleanup temporary segments?        o. Typically a user process allocates a temporary segment (multiple          extents) and then dies before cleaning them up, or the user process          receives an error causing the statement to fail. SMON is posted to do          the cleanup. SMON also might [...]

Oracle database Script for Monitoring CPU Resource Manager

By | September 28th, 2011|DBA Miscellaneous, Oracle DBA|

Script: set echo on #####  Monitor Current Resource Plan  ##### select name, cpu_managed from v$rsrc_plan where is_top_plan = 'TRUE'; #####  Describe Current Resource Plan  #####  select group_or_subplan, mgmt_p1, mgmt_p2, mgmt_p3, mgmt_p4, mgmt_p5, mgmt_p6, mgmt_p7, mgmt_p8, max_utilization_limit from dba_rsrc_plan_directives where plan = (select name from v$rsrc_plan where is_top_plan = 'TRUE'); #####  Monitor CPU Usage and Waits [...]

Data Block Corruption Alert in Oracle Database

By | June 3rd, 2011|DBA Miscellaneous, Oracle DBA|

The Purpose of the article is to mail the DBA on the alert message about block corruption, before the block is accessed. It contains shell script that alerts the DBA on this message. Description: The following command helps you prevent this error message received by the end user. This SQL command will return the maximum [...]