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

/Tag:DBA Miscellaneous

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

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

DBA Example Checklist

By | January 4th, 2011|DBA Miscellaneous, Oracle DBA|

Each system differs on what types of checks that need to be performed.  The following lists are not to be used as definitive checks, but rather a spring board for you to create your own task lists. 1.1             Daily Procedures Many of these procedures can be automated using shell scripts and a scheduler like cron [...]

Role of a Database Administrator

By | January 4th, 2011|DBA Miscellaneous, Oracle DBA|

1) Oracle DBA Responsibilities: Install and upgrade Oracle products Creates and maintains all databases required for development, testing, education and production. Works in conjunction with System Administrators (SAs) to plan and allocate disk storage for each system.  The process can often depend on the type of disk storage system and how it is integrated into [...]

Performance Shared pool Script in Oracle

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

############################################################################### select 'Ratio Should be < 15%' from dual; select sum(getmisses), sum(gets) , (sum(getmisses) * 100)/sum(gets) "Misses To Gets Ratio" from v$rowcache select parameter, getmisses, gets from v$rowcache; select sum(pins), sum(reloads) , sum(reloads) / sum(pins) * 100 "Reload Ratio" from v$librarycache select 'GETHITRATIO should be high > 90%' from dual select sum(pinhits)/sum(pins) "lib cache hit [...]

Password Encrypt Query in Oracle

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

################################################################################ CREATE OR REPLACE PACKAGE ENCRY_PASS AS FUNCTION encrypt( Str VARCHAR2 ) RETURN RAW; FUNCTION decrypt( xCrypt VARCHAR2 ) RETURN VARCHAR2; END ENCRY_PASS; / CREATE OR REPLACE PACKAGE BODY ENCRY_PASS AS crypt_raw RAW(2000); crypt_str VARCHAR(2000); -- Encrypt the string -- FUNCTION encrypt( Str VARCHAR2 ) RETURN RAW AS l INTEGER := LENGTH(str); i INTEGER; padblock [...]