Initialization parameters for Oracle 10g can be obtained from v$parameter;
sample script to get values:
set pagesize 1000
set linesize 150
column name format a40
column value format a40
column description format a40
select name, value, description from v$parameter order by name;
useful links:
http://www.dba-oracle.com/t_oracle10g_initialization_parms.htm
Repository of Database Related Information, Assets and Knowledge Base covering Oracle, SQLs, Scripts, Performance Tuning etc
Subscribe to:
Post Comments (Atom)
Labels
oracle SQL
oracle database
oracle 10g
SQL
Optimizer
user
v$session
parameter
sid
sqlplus;database name
userid
username
SET
SPOOL
SQL Faq
SQL Tutorial
column
imp
import
initialization
optimization
oracle DBA
oracle hints
process
rename
rename table
sizing
sql hints
statistics
status
system tables
table
table locks
tablespace
temp tablespace
user name
v$lock
v$parameter
v$process
v$sessmetric
v$sql
No comments:
Post a Comment