B) Tip :- How do I determine
what options are installed on my server ?
Answer A)
Determine obsoleted/desupported parameters :-
Connect with sys and query the x$KSPPO will tell you Desupported/Obsoleted parameter of your instance
SQL :> select kspponm
"DESUPPORTED/OBSOLETED " from x$ksppo;
For underscore parameters query
as
SQL :> SELECT ksppinm
"UNSERSCORE PARAMETERS"FROM
x$ksppi WHERE
SUBSTR(ksppinm,1,1) = '_' order by ksppinm;
Answer B)
Determine options installed
on your server
Connect with sys and query
as
SQL> select * from
v$option;
PARAMETER VALUE
----------------------------------------------------------------
--------
Partitioning
TRUE
Objects TRUE
Parallel Server FALSE
Advanced replication
TRUE
Bit-mapped indexes
TRUE
Connection multiplexing TRUE
Connection pooling
TRUE
Database queuing TRUE
Incremental backup and recovery TRUE
Instead-of triggers TRUE
Parallel backup and recovery TRUE
Parallel execution TRUE
Parallel load TRUE
Point-in-time tablespace recovery TRUE
Fine-grained access control TRUE
N-Tier authentication/authorization TRUE
Function-based indexes TRUE
Plan Stability TRUE
Online Index Build TRUE
Coalesce Index TRUE
Managed Standby TRUE
Materialized view rewrite TRUE
Materialized view warehouse refresh TRUE
Database resource manager TRUE
Spatial
TRUE
Visual Information Retrieval TRUE
Export transportable tablespaces TRUE
Transparent Application Failover TRUE
Fast-Start Fault Recovery TRUE
Sample Scan TRUE
Duplexed backups TRUE
Java FALSE
OLAP Window Functions TRUE
33 rows selected.
End of Tip
|
Welcome
to send comments or feedback at Wadhwa_s@Hotmail.com |
|
Sameer Wadhwa |
Copyright © Oracle Techniques All Rights Reserved |