SYS>create tablespace perf_ts
datafile '/u01/app/oracle/venu1/perf_ts01.dbf'
size 10m autoextend on;
SYS>select * from all_users;
SYS>@$ORACLE_HOME/rdbms/admin/spcreate.sql
enter password :
enter tablespace :
enter temp tablespace :
perfstat>select count(*) from tab;
perfstat>select * from tab;
perfstat>desc stats$database_instance;
perfstat>select dbid,instance_number,startup_time,snap_id,db_name from stats$database_instance;
perfstat>save perf.sql
perfstat>conn / as sysdba
SYS>execute statspack.snap;
perfstat>@perf.sql
perfstat>conn scott/tiger
scott>insert into salgrade select * from salgrade;
SYS>execute statspack.snap;
perfstat>desc stats$snapshot;
perfstat>select snap_id,dbid,instance_number,startup_time from stats$snapshot;
SYS>@$ORACLE_HOME/rdbms/admin/spreport.sql
enter value for begin snap id : 1
enter value for end snap id : 2
enter value for report name : sprpt.sql
SYS>!pwd
oracle@venu1>ls
oracle@venu1>vi sprpt.sql
