AWR

Read:
Transparent Data Encryption
http://www.oracle.com/technology/oramag/oracle/05-sep/o55security.html

Whats in SYSAUX?

select occupant_name, schema_name, space_usage_kbytes from v$sysaux_occupants;

For more information, go to http://tahiti.oracle.com


To generate AWR reports:

@$ORACLE_HOME/rdbms/admin/awrrpt



Explain Plan
Note: 235530.1 Recommended Methods for Obtaining a Formatted Explain Plan
@?/rdbms/admin/utlxplan
@?/rdbms/admin/utlxpls
set lines 130
set head off
alter session set cursor_sharing=EXACT;
select plan_table_output from table(dbms_xplan.display('PLAN_TABLE',null,'ALL'));

-- Plan of last executed SQL
select * from table(dbms_xplan.display_cursor(null,null, 'ALL'));

Note: 215187.1 Enhanced Explain Plan and related diagnostic info for one SQL statement