Home » RDBMS Server » Performance Tuning » Instance profiling (10g Enterprise Edition Release 10.2.0.4.0 - 64bi)
Instance profiling [message #437586] Tue, 05 January 2010 02:39 Go to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
All,

How we can perform the instance profiling same as SQL server database profiling in oracle.


Thanks in advance.

-Rahul

Re: Instance profiling [message #437587 is a reply to message #437586] Tue, 05 January 2010 02:49 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
DBMS_PROFILER

If i understood you properly...Please Have a look at this..

sriram Smile
Re: Instance profiling [message #437590 is a reply to message #437587] Tue, 05 January 2010 03:05 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Sriram,
if I am not wrong DBMS_PROFILER does not give the out put like SQL server profiler Smile so I have explicitly specified similar to MS SQL profile.

BTW I presume that you have already used MS SQL, so considering that what MS SQL does is : - it give Very precise visual Snapshot of current scenario of server

what SQL objects are ruining
a)With parameter values.
b)Total time taken.
c)Total # no of hits between time a to b.
d)we can save this data as file and import into database table.

so on same lines i am looking for oracle tool.


-Rahul
Re: Instance profiling [message #437592 is a reply to message #437586] Tue, 05 January 2010 03:14 Go to previous messageGo to next message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Sriram,

Some more info.

Intro to MS SQL Profiler, we can reply all the trace on server to get the exact scenario at specific porint of time.

-Rahul
Re: Instance profiling [message #437601 is a reply to message #437592] Tue, 05 January 2010 03:22 Go to previous messageGo to next message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
For You


Tool Dump

sriram Smile
Re: Instance profiling [message #437602 is a reply to message #437601] Tue, 05 January 2010 03:25 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Thanks buddy Cool
Previous Topic: write as a single statement
Next Topic: How to tune this sql?
Goto Forum:
  


Current Time: Fri Dec 02 14:31:03 CST 2016

Total time taken to generate the page: 0.07224 seconds