DBMS_XPLAN (EXECUTION PLAN) from 9i
===================================

conn sys/password as sysdba
@?/rdbms/admin/utlxplan.sql
@?/sqlplus/admin/plustrce.sql

CREATE PUBLIC SYNONYM plan_table FOR sys.plan_table;
GRANT ALL ON sys.plan_table TO public;

GRANT PLUSTRACE TO USERs;

set autotrace on
select 1 from dual;


GET DDL (from 9.0.1)
====================
set pages 999
set linesize 200
desc dbms_metadata

set long 10000
select dbms_metadata.get_ddl('TABLE','TABLE_NAME','OWNER') from dual;
select dbms_metadata.get_ddl('INDEX','INDEX_NAME','OWNER') from dual;