OraFAQ Forum: Performance Tuning » Production Performance Issue

Home » RDBMS Server » Performance Tuning » Production Performance Issue (Oracle 10.2.0.3 + Sun Solaris 5.9)

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

Production Performance Issue [message #363273]

Fri, 05 December 2008 11:46

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello,

Recently we are upgraded our production database 9.2.0.6 to 10.2.0.3.

Our development database clone of production (after upgraded prod. database).

Recently; I'm facing one issues; One of my developer running one request in development it's takes only 8 min; but the same request in production it's not completed.

I have generated trace; as per trace generated tkprof (using trace analyzer tool).

Please let us know; what's the exact problem in production.

Thank You in advance.

Babu

Ps: I'm not able to upload html & zip files; That's the reason upload txt file (html file converted to txt). Please find my upload file & try to save as HTML format;

Attachment: trcanlzr_16216_Production.txt
(Size: 1.83MB, Downloaded 2524 times)

Report message to a moderator

Re: Production Performance Issue [message #363275 is a reply to message #363273]

Fri, 05 December 2008 11:48

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Hello Again,

Please find my development trace file.

Ps: I'm not able to upload html & zip files; That's the reason upload txt file (html file converted to txt). Please find my upload file & try to save as HTML format;

Babu

Attachment: trcanlzr_72850_Development.txt
(Size: 780.90KB, Downloaded 1629 times)

Report message to a moderator

Re: Production Performance Issue [message #363292 is a reply to message #363273]

Fri, 05 December 2008 12:59

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

May be my eyes are deceiving me.
I do not see the same offensive sql in both traces.
Try to isolate the sql and post it.
When was the last time statistics was updated in production?
The dev database might be a clone. Is the environment too?

Report message to a moderator

Re: Production Performance Issue [message #363293 is a reply to message #363292]

Fri, 05 December 2008 13:23

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>I do not see the same offensive sql in both traces.

I'll double check SQL & let you know

>>When was the last time statistics was updated in production?

statistics daily happen in prod.

>>The dev database might be a clone. Is the environment too?

Yes; Dev database clone from pro. & env. also same (I mean both are running in sun 5.9)

Babu

Report message to a moderator

Re: Production Performance Issue [message #363295 is a reply to message #363293]

Fri, 05 December 2008 13:36

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>statistics daily happen in prod.
Are you sure?
The trace file you posted say that (atlest for the objects that were reported) the object were analyzed sometime in Nov.
Also, Unless the data is very volatile, statistics does not need to be updated daily.

Report message to a moderator

Re: Production Performance Issue [message #363300 is a reply to message #363295]

Fri, 05 December 2008 13:56

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Thanks for catching.

Yes; Daily statistics happen. same time trace file gnerated at Nov (1 week before)

>ls -lrt *16216*
-rw-r--r--   1 oracle   dba       865737 Nov 26 05:52 trcanlzr_16216.txt
-rw-r--r--   1 oracle   dba      1918986 Nov 26 05:59 trcanlzr_16216.html
-rw-r--r--   1 oracle   dba        15632 Nov 26 06:00 trcanlzr_16216.log

I already sent request to develper; Once again i'm tracing & come back to you.

thank you in advance.

Babu

Report message to a moderator

Previous Topic:	how to improve
Next Topic:	Help with SQL Optimization (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 29 04:07:25 CDT 2024