Useful Select Statements

To view the default tablespace:

SELECT PROPERTY_NAME, PROPERTY_VALUE

FROM DATABASE_PROPERTIES

WHERE PROPERTY_NAME='DEFAULT_TEMP_TABLESPACE';

To view the database name:

SELECT NAME FROM V$DATABASE;

To view database status:

SELECT STATUS FRON V$INSTANCE;

To view session information:

SELECT sid, authentication_type, osuser

FROM V$SESSION_CONNECT_INFO;

To view the possible DBA privileges:

SELECT PRIVILEGE FROM DBA_SYS_PRIVS;

To view the possible USER privileges:

SELECT PRIVILEGE FROM USER_SYS_PRIVS;

To view Profile information:

SELECT RESOURCE_NAME, LIMIT

FROM DBA_PROFILES

WHERE PROFILE='NEWPROFILE';

To view All profile names in the databas:

SELECT DISTINCT (PROFILE) FROM DBA_PROFILES;

Regards

Mostafa Mahmoud