Tag: Oracle hidden parameters

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 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

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 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