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
No comments:
Post a Comment