Wich tables has users information and options installed in oracle

[isonlyme]

Hey guys!

I need to know wich tables i should query to know wich options are installed in oracle (partitioning, performce pack, etc) and users!!!

Thanks in advance

 

[Turkbear]

Hi,
Select username from all_users;

Select * from v$option;

column parameter format a45
column value format a7
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

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

PARAMETER                                VALUE
---------------------------------------- -------
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                                     TRUE

32 rows selected.

hope it helps..

 

[isonlyme]

Perfect! Thanks a lot turkbear!!!
Great people, great site!...