Tag: howto

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 the network. If we are able to boost the performance of the network then it will directly hit the performance of client requests. For improving the performance of the network using TCP/IP protocol we have some tips. Problem: Every Oracle DBA has some […]

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 the existing sessions or kill the background process of Oracle. Then the 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 […]

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 an entry of OSAUTH_PREFIX_DOMAIN=true This entry forces the external users to use the domain names in login. After […]

Read More

Oracle one-off patch or interim patch using opatch utility

Oracle one-off patch or interim patch using opatch utility

December 22, 2009 | By | Add a Comment

Oracle’s interim patch and one-off patch is being applied by Opatch utility. Article explains how to apply opatch with one-off interim patch of oracle.

Read More

News from Dbametrix

News from Dbametrix

October 10, 2009 | By | Add a Comment

http://www.dbametrix.com/service.html

Read More