statspack

SQL> @C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\spcreate

or

SQL> CONNECT / AS SYSDBA
SQL> define default_tablespace='ESASBRANCH'
SQL> define temporary_tablespace='TEMP'
SQL> define perfstat_password='SYS'
SQL> @C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\spcreate
**********************


SQL> CONNECT perfstat/SYS
SQL> EXECUTE statspack.snap;

or

variable snap number;
begin :snap := statspack.snap;
end;
/

SQL> print snap
SNAP
----------
12


select name,snap_id,to_char(snap_time,'DD.MM.YYYY:HH24:MI:SS')
"Date/Time" from stats$snapshot,v$database;


SAat basi statspack almasi icin:
@C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\spauto

desc user_jobs;

SELECT job
FROM user_jobs;

exec dbms_job.remove(1);

yarim saatde bir almasi icin:
EXECUTE DBMS_JOB.INTERVAL(job_number,'SYSDATE+(1/48)');


To remove a specified job:
EXECUTE DBMS_JOB.REMOVE(job_number);
---------------

report:

connect perfstat/sys

@C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\spreport

OR
connect perfstat/my_perfstat_password
define begin_snap=1
define end_snap=2
define report_name=batch_run
@C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\spreport


Truncating All Statspack Data
@C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\sptrunc

or

purge(SPPURGE.SQL deletes all snapshots ranging between the lower and upper bound snapshot IDs )
@C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\sppurge

or
drop

@C:\esas\oracle\app\oracle\product\10.2.0\server\RDBMS\ADMIN\spdrop

************************************

Generate Execution Plan for given SQL statement

sqlplus perfstat/perfstat
SQL> @?/rdbms/admin/sprepsql.sql
Enter the Hash Value, in this example: 1279400914