Topic: Performance & Tuning >> Statpack help
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| SreenivasaRao |
Posted: Jun 06, 2005 04:46:10 AM |
Total Post: 8
Joined: Apr, 2005
|
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.....
|
|
|
 Vigyan |
| Posted: Jun 15, 2005 09:07:30 AM |  |
|
Total Post: 386
Joined: May, 2001
|
Hi Sreenivas,
If you are running Statspack against oracle db then it should get only oracle related sql.
Query V$SQLAREA and see what kind of sql you have on Oracle db.
Vigyan
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 814 |
| Mohammed Taj | 694 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| positive fanatic | 361 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 239 |
| neeraj sharma | 228 |
| Ramesh Jois | 226 |
| snehalatha p | 169 |
|
|
