Home » RDBMS Server » Performance Tuning » HELP ON STATSPACK
HELP ON STATSPACK [message #122378] Mon, 06 June 2005 04:57 Go to next message
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.....



  • Attachment: MYREP4.LST
    (Size: 29.65KB, Downloaded 361 times)
Re: HELP ON STATSPACK [message #122497 is a reply to message #122378] Mon, 06 June 2005 15:01 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
You should trace the session. Statspack scans the complete database whereas you only seem to be interested in your session.

hth
Re: HELP ON STATSPACK [message #123648 is a reply to message #122497] Tue, 14 June 2005 04:33 Go to previous message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

ThankQ

Mr Frank...u did great help
Previous Topic: who is the user executing query which is using more disk space?
Next Topic: FTS even there is an index on table.
Goto Forum:
  


Current Time: Tue Jan 19 22:41:44 CST 2021