Category: oracle internals

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

Hidden parameter _TRACE_FILES_PUBLIC in Oracle

Hidden parameter _TRACE_FILES_PUBLIC in Oracle

July 24, 2010 | By | Add a Comment

Article explains How to change default permission of trace files in Oracle.

Read More

Oracle version number detail explaination

Oracle version number detail explaination

December 22, 2009 | By | Add a Comment

Article explains detail of How to check installed Oracle version? and How to understand Oracle version numbers?

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

Oracle 9i Hidden Parameters

Oracle 9i Hidden Parameters

October 5, 2009 | By | Add a Comment

Oracle 9i hidden and undocumented parameters with default values and description dowload from following link
http://www.dbametrix.com/download_info.php

Read More

Oracle 10g Hidden Parameters

Oracle 10g Hidden Parameters

October 5, 2009 | By | Add a Comment

Oracle 10g hidden parameters with default value and description download from following link.
http://www.dbametrix.com/download_info.php

Read More