Tag: blogs

Windows network tuning for oracle dba

Windows network tuning for oracle dba

March 8, 2010 | By | Add a Comment

Hi friends, Oracle database server is accepting and sending client requests using network. If we are able to boost performance of network then it will directly hit performance of client requests. For improving performance of network using TCP/IP protocol we have some tips. Problem: Every Oracle DBA has some confusion for tuning of network of […]

Read More

How to kill session in Oracle

How to kill session in Oracle

March 4, 2010 | By | Add a Comment

Hi friends, In various critical situations Oracle DBA has to decide to kill existing session or kill the background process of Oracle. Then question is raised that in which type of situation remote dba should need to kill session and process. We are explaining those situations and incidences here. When blocking lock occurs and other […]

Read More

srvctl command utility of Oracle RAC

srvctl command utility of Oracle RAC

February 12, 2010 | By | Add a Comment

Hi Friends, Server Control utility is available for Oracle RAC management. We are using srvctl utility to perform configuration on cluster environment for storing configuration data in the server management configuration repository. SRVCTL uses SQL*Plus to perform stop and start activities on each node. Server Management configuration repository stores all components like SRVCTL,GSD (Global Services […]

Read More

OSAUTH_PREFIX_DOMAIN for Oracle

OSAUTH_PREFIX_DOMAIN for Oracle

February 8, 2010 | By | Add a Comment

Hi friends, How to set OSAUTH_PREFIX_DOMAIN in Oracle database for windows security of Oracle databases. Yes, we can set OSAUTH_PREFIX_DOMAIN parameter in windows registry as follows. Go to following windows registry of Oracle software HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME# And add entry of OSAUTH_PREFIX_DOMAIN=true This entry forces external user to use domain name in login. After enabling this entry […]

Read More

Oracle 8i Hidden Parameters

Oracle 8i Hidden Parameters

November 9, 2009 | By | Add a Comment

Hello friends, As per our promise we are providing Oracle tips and technical papers for about some internals of Oracle database.It is very important for every advance Oracle DBA. http://www.dbametrix.com/resource_database.html Day by day in new version of Oracle we found hidden parameters are being increased.Oracle 8i is having 555 hidden parameters. Hidden parameters called as […]

Read More

New Oracle DBA forums

New Oracle DBA forums

October 21, 2009 | By | 2 Comments

Hi friends, Great news from Dbametrix that, new Oracle DBA Forum has been initiated as follows. It is totally FREE. http://oracledba.forumotion.net/ For sharing knowledge,news,tips,scripts,problems for Oracle DBA you can take benefit of same Oracle DBA forums. http://oracledba.forumotion.net/ This Oracle DBA forums is helping you to download OCP exam preparation study materials, Searching for Oracle DBA […]

Read More