-
show parameter
My oracle database version is IS 7.3.4 if i give show parameter doesnot give any information shows error message given below but samething iam able to get in ver 8.1.7
OPS3 SQL> show parameter db_block_size
unknown SHOW option "parameter"
unknown SHOW option beginning "db_block_s..."
OPS3 SQL> show sga
unknown SHOW option "sga"
OPS3 SQL> show parameter db_block_buffers
unknown SHOW option "parameter"
unknown SHOW option beginning "db_block_b..."
J Gangadhar
-
Hi
well i dont have a 7.3 database now..maybe its because in 7.3 that show parameter feature wasnt available :-)
regards
Hrishy
-
Show parameter is not available in Oracle 7.3.x
Corrado
Corrado Mascioli
-
Hi
Try SHOW PARAMETER in svrmgrl. It works
-
possible to get the list of parameters to " show parameter"
like
1) show parameter archive
2) show parameter writer
and etc..
thanks
-
hi ..
show parameter is not there in oracle 7.3 ..
try "select * from v$parameter;".
thanks
sarav
saravana kumar
-
that will list all the parameters ..
what i meant is groups of values in a parameter value.
example, show parameter archives, shows those parameters with archives related information
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|