Oracle Demo Build

create user scott identified by tiger
default tablespace users
temporary tablespace temp;

grant connect,resource to scott;

connect scott/tiger;

@$ORACLE_HOME/sqlplus/demo/demobld.sql

--@$ORACLE_HOME/sqlplus/demo/demodrop.sql

@$ORACLE_HOME/rdbms/admin/utlxplan.sql

ALTER SESSION SET SQL_TRACE = TRUE;

ALTER SESSION SET Timed_Statistics = TRUE;

$ tkprof ora_11651.trc ora_11651.prf explain=scott/tiger sys=no