Home » RDBMS Server » Performance Tuning » trace-strange case
trace-strange case [message #303243] Thu, 28 February 2008 09:11 Go to next message
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
Junior Member

Hi colleagues,
I ran into some strange issue, i have a scenario, on my app, which is performing bad-takes a lot of time.
- when i tried to pull a trace on this session performing the scenario, everything
is working well.
- when i take the trace off, then the performance is bad again.
i'm using 10046 level 12 to trace it.

any ideas?
thanks in advance
Re: trace-strange case [message #303254 is a reply to message #303243] Thu, 28 February 2008 09:29 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Since I don't expect you will be willing to pay for any advise, I move this from Marketplace to Performance tuning
Re: trace-strange case [message #303256 is a reply to message #303254] Thu, 28 February 2008 09:32 Go to previous messageGo to next message
shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada
Junior Member

thanks.
Re: trace-strange case [message #303288 is a reply to message #303243] Thu, 28 February 2008 12:38 Go to previous message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the article by Tom Kyte: On Tuning by Tracing

Regards
Michel

Previous Topic: Index rebuild issue
Next Topic: Performance Tuning
Goto Forum:
  


Current Time: Wed Dec 07 09:05:20 CST 2016

Total time taken to generate the page: 0.17640 seconds