OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » HELP ON STATSPACK

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

HELP ON STATSPACK [message #122378]

Mon, 06 June 2005 04:57

sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore

Member

Hi All

i have one more dout..ON STATSPACK

In our project we have DLL's whcih having set of SQL statements like Orcl.dll,Mssql.dll etc...(Activex DLLs)
we r sending data both in ORACLE DB well as MSSQL DB oK,
if i CLICK ON save in form, request wel go to both DLL's and excutes the proper SQL STATEMENTS..ok

Now Problem is i am getting SQLSTATEMENT which r running on MSSQL DB,but iam not getting the SQLSTAMENTS which r running on ORACLE DB,in what WAY i get this statement,

I APROCHED LIKE THIS

SQL> variable snap number;
SQL> begin :snap := statspack.snap; end;
2 /
PL/SQL procedure successfully completed.
SQL> print snap
SNAP
----------
2

by doing this it is generating report...by seeing

SQL> @?/rdbms/admin/spreport

DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
2618106428 PRD1 1 prd1
Completed Snapshots
Snap Snap
Instance DB Name Id Snap Started Level Comment
------------ ------------ ----- ----------------- ----- ----------------
prd1 PRD1 1 11 May 2000 12:07 5
2 11 May 2000 12:08 5

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 1
Begin Snapshot Id specified: 1

Enter value for end_snap: 2
End Snapshot Id specified: 2

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is myrep

in myrep.lis file iam getting some of sqlstatement...which r not belong to our project how can i get SQLSTATEMENTS

PLS HELP ME.....