Oracle Broken Read

1. Set the Sql*plus prompt

Sql> set Sqlprompt "_user ' @ ' _connect_identifier>"

[Email protected]>

In order to automatically set sqlprompt for all Sql*plus sessions, place the above command in the Glogin.sql file in the Oracle_home/sqlplus/admin directory

2. View the system permissions granted by the role resource

Sql> SELECT * from Dba_sys_privs where grantee= ' RESOURCE ';

GRANTEE PRIVILEGE ADM
------------------------------   --------------------------------------- ---
RESOURCE CREATE TRIGGER NO
RESOURCE CREATE SEQUENCE NO
RESOURCE CREATE TYPE NO
RESOURCE CREATE PROCEDURE NO
RESOURCE CREATE CLUSTER NO
RESOURCE CREATE OPERATOR NO
RESOURCE CREATE Indextype NO
RESOURCE CREATE TABLE NO

3. View System Timestamp

Sql> select Systimestamp from dual;

4. View the size of the PGA and SGA in the case of automatic Memory management

Sql> select sum (value) from V$sesstat natural join V$statname where name= ' session PGA Memory ';

sql> select sum (bytes) from V$sgastat;

5. Identify all invalid objects in the database

Sql> Select Owner,object_name,object_type from dba_objects where status= ' INVALID ';