Category: remote dba support

Solutions Associated With Oracle Backup and Recovery

Solutions Associated With Oracle Backup and Recovery

April 4, 2013 | By | Add a Comment

RMAN is only option for OMF and Oracle ASM as Backup and Recovery Tool In the field of Oracle backup and recovery, there exist many solutions that are used for applying various strategies. In this article we will introduce some of these solutions to make you familiar with the terms.   Recovery Manager (RMAN) There […]

Read More

Tuning of gc current block 3-way wait in RAC Oracle Database

Tuning of gc current block 3-way wait in RAC Oracle Database

November 30, 2010 | By | 1 Comment

Hi Friends, What is the gc current block 3-way wait or gc current block 2-way wait event. Following article is explaining the more detail of gc current block 3-way wait secret with performance tuning of wait event in RAC Oracle Database. So many times oracle rac database wait event gc current block 3-way wait logs […]

Read More

Oracle DBA Scripts- PGA management and pga_aggregate_target

Oracle DBA Scripts- PGA management and pga_aggregate_target

November 10, 2010 | By | Add a Comment

Hi Friends, Here you can find out some useful and important Oracle DBA scripts for managing and administrating Database very easily. Oracle DBA Scripts-1: How to check hidden PGA parameter setting from Oracle hidden parameters. Following scripts are very useful to get hidden pga parameters. Kindly execute with SYSDBA privilege. select a.ksppinm name, b.ksppstvl value […]

Read More

Save Oracle Licensing cost using Smart Computing

Save Oracle Licensing cost using Smart Computing

October 13, 2010 | By | 1 Comment

Save Oracle Licensing cost using Smart Computing. Unfortunately installation takes placed by non-specialists of Oracle software, installation done with analysis of client needs and application structure details. Due to this reason client has to spend more charges of Oracle licensing cost when it doesn’t require Oracle Enterprise Edition.

Read More

Delete archives using RMAN in Oracle

Delete archives using RMAN in Oracle

October 11, 2010 | By | 1 Comment

Hi friends, Today we see how to delete archive forcefully using RMAN. When some of archives are being deleted from disk and RMAN still consider those archives due to retention period. Then we can delete those archives from rman metadata using following command. RMAN>delete unavailable; If we are getting some specific archive related error or […]

Read More

Hidden parameter checking script for Oracle

Hidden parameter checking script for Oracle

October 1, 2010 | By | Add a Comment

Hi friends, So many times we need to check hidden parameters of Oracle. Sometime we forgot script of data dictionary views for writing sql script. Here I am providing you SQL script for check hidden parameters of Oracle. For executing this script you should need to login as SYSDBA. Because only X$ tables are providing […]

Read More