Home » RDBMS Server » Performance Tuning » Production Performance Issue (Oracle 10.2.0.3 + Sun Solaris 5.9)
Production Performance Issue [message #363273] Fri, 05 December 2008 11:46 Go to next message
babuknb
Messages: 1734
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;
Re: Production Performance Issue [message #363275 is a reply to message #363273] Fri, 05 December 2008 11:48 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Production Performance Issue [message #363292 is a reply to message #363273] Fri, 05 December 2008 12:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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?

Re: Production Performance Issue [message #363293 is a reply to message #363292] Fri, 05 December 2008 13:23 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Production Performance Issue [message #363295 is a reply to message #363293] Fri, 05 December 2008 13:36 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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.
Re: Production Performance Issue [message #363300 is a reply to message #363295] Fri, 05 December 2008 13:56 Go to previous message
babuknb
Messages: 1734
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
Previous Topic: how to improve
Next Topic: Help with SQL Optimization (merged)
Goto Forum:
  


Current Time: Sun Dec 04 10:43:57 CST 2016

Total time taken to generate the page: 0.10219 seconds