OraFAQ Forum: Performance Tuning » trace-strange case

Home » RDBMS Server » Performance Tuning » trace-strange case

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

trace-strange case [message #303243]

Thu, 28 February 2008 09:11

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

Report message to a moderator

Re: trace-strange case [message #303254 is a reply to message #303243]

Thu, 28 February 2008 09:29

Frank
Messages: 7901
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

Report message to a moderator

Re: trace-strange case [message #303256 is a reply to message #303254]

Thu, 28 February 2008 09:32

shlomi_bt
Messages: 16
Registered: August 2005
Location: Canada

Junior Member

thanks.

Report message to a moderator

Re: trace-strange case [message #303288 is a reply to message #303243]

Thu, 28 February 2008 12:38

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read the article by Tom Kyte: On Tuning by Tracing

Regards
Michel

Report message to a moderator

Previous Topic:	Index rebuild issue
Next Topic:	Performance Tuning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 01:47:35 CST 2024