Home » RDBMS Server » Performance Tuning » Performance of Oracle 9i in Unix machine (merged 3)
Performance of Oracle 9i in Unix machine (merged 3) [message #270658] Thu, 27 September 2007 13:47 Go to next message
oraprobs
Messages: 9
Registered: September 2007
Location: lowell
Junior Member
hi,
I have upgraded oracle 8i machine to oracle 9i in an unix machine.After the upgradation the queries are taking much long time to execute.The query that used to take 20 secs in oracle 8i, is taking 10 mins to execute now.How might be the reason for this.Please help me.

thanks in advance,
Brad
Re: Oracle 9i performance in Unix [message #270667 is a reply to message #270658] Thu, 27 September 2007 13:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this a real question or are you just testing how to post?

Regards
Michel
Re: Oracle 9i performance in Unix [message #270674 is a reply to message #270667] Thu, 27 September 2007 14:13 Go to previous messageGo to next message
oraprobs
Messages: 9
Registered: September 2007
Location: lowell
Junior Member
This is a real question.Have i done any mistake?
Performance of Oracle 9i in Unix machine [message #270677 is a reply to message #270658] Thu, 27 September 2007 14:15 Go to previous messageGo to next message
oraprobs
Messages: 9
Registered: September 2007
Location: lowell
Junior Member
hi,
I have upgraded oracle 8i machine to oracle 9i in an unix machine.After the upgradation the queries are taking much long time to execute.The query that used to take 20 secs in oracle 8i, is taking 10 mins to execute now.How might be the reason for this?Please help me.

thanks in advance,
Brad
Re: Performance of Oracle 9i in Unix machine [message #270678 is a reply to message #270677] Thu, 27 September 2007 14:17 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/

is the SEARCH function on this forum broken for you?
Re: Oracle 9i performance in Unix [message #270684 is a reply to message #270674] Thu, 27 September 2007 14:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to post in Performances Tuning forum AFTER having read the sticky at the top of this forum.

Regards
Michel
Re: Oracle 9i performance in Unix [message #270699 is a reply to message #270684] Thu, 27 September 2007 15:44 Go to previous messageGo to next message
oraprobs
Messages: 9
Registered: September 2007
Location: lowell
Junior Member
Thanks a lot...
Oracle 9i in unix and Oracle 9i in Windows [message #270712 is a reply to message #270658] Thu, 27 September 2007 16:57 Go to previous messageGo to next message
oraprobs
Messages: 9
Registered: September 2007
Location: lowell
Junior Member
Is there any performance difference between Oracle 9i in unix and oracle 9i in windows.My application uses both oracle 8i and oracle 9i.Initially i had my application setup(inslatted in windows machine) with oracle 8i database installed in an unix machine.then i upgraded it to oracle 9i.My application has became very slow.I did the same in Windows i.e. I installed oracle 8i in windows machine,my application was running fine with it.then i upgrade the database to oracle 9i.now also my application is runinng fine.So why only the database performane degraded for upgrading the database in the unix machine?Please help me.

thanks in advance,
Brad
Re: Oracle 9i in unix and Oracle 9i in Windows [message #270713 is a reply to message #270712] Thu, 27 September 2007 17:07 Go to previous messageGo to next message
pablolee
Messages: 2834
Registered: May 2007
Location: Scotland
Senior Member
another merge?

http://www.orafaq.com/forum/t/90086/105378/
icon7.gif  Re: Oracle 9i in unix and Oracle 9i in Windows [message #270714 is a reply to message #270713] Thu, 27 September 2007 17:15 Go to previous messageGo to next message
oraprobs
Messages: 9
Registered: September 2007
Location: lowell
Junior Member
Yes...The problems are the same....

[Updated on: Thu, 27 September 2007 17:15]

Report message to a moderator

Re: Oracle 9i in unix and Oracle 9i in Windows [message #271005 is a reply to message #270713] Fri, 28 September 2007 13:18 Go to previous messageGo to next message
oraprobs
Messages: 9
Registered: September 2007
Location: lowell
Junior Member
Hi,
This link doesn't work...
Re: Oracle 9i in unix and Oracle 9i in Windows [message #271007 is a reply to message #271005] Fri, 28 September 2007 13:31 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The link no more works because the topic was merged to this one.
So you find the posts here.

Regards
Michel
Re: Performance of Oracle 9i in Unix machine (merged 3) [message #271009 is a reply to message #270658] Fri, 28 September 2007 13:32 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>This link doesn't work...
Which link does not work?
We are NOT mind readers!

If "tuning" was easy to do, it would be done automagically by a program.

1. Read Concepts manual.
2. Understand that most performance issues come from application issues.
For example, if some silly SQL reads an entire table to get a few rows,
you wil likely have a lot of unnecessary I/O that won't fill up the SGA.
3. Read the Performance manual.
4. Understand the optimizer. It can only use the information it is given.
If the statistics it uses are wrong, non-existent, or skewed in a manner the
optimizer doesn't know about, it can choose a silly plan for accessing the data.
Sometimes a full table scan is not silly.
5. Understand what plans are and how to use them to understand 4.
6. Understand what statspack can tell you.
7. Understand when, how and why to use tracing.
8. Understand what waits are and how to evaluate them.
9. Read and work through books and articles by Jonathan Lewis, Tom Kyte, and Cary Milsap.
10. Understand why rules of thumb can be a bad idea for improving the database of customers.
11. Understand that tools based strictly on Oracle can be a bit misleading from a systems
standpoint, and systems tools can be misleading from Oracle's viewpoint. Simply knowing
you have a lot of reads does not mean anything is wrong, after all, what is a database
going to be used for? A proper tuning methodology will figure out what critical
bottlenecks are, and what to do about them.
12. Understand the basics. For example, if you have sequential write-intensive
archive writing interfering with random reads and writes for undo and everything
else, thrashing a SAN cache, you probably have a configuration problem. If you
have multiple users accessing data, you need to understand how Oracle handles
the issues involved.
13. Create clear metrics for performance improvement.
14. Read Concepts manual.
15. Go to #1 above
Re: Performance of Oracle 9i in Unix machine (merged 3) [message #271010 is a reply to message #271009] Fri, 28 September 2007 13:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Wow! Pretty good! ./fa/1581/0/
Can we add it to the Performance Tuning sticky?

Regards
Michel
Re: Performance of Oracle 9i in Unix machine (merged 3) [message #271012 is a reply to message #270658] Fri, 28 September 2007 13:41 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
OK by me but I lifted it from a very recent post from USENET CDOS
Re: Performance of Oracle 9i in Unix machine (merged 3) [message #271014 is a reply to message #271012] Fri, 28 September 2007 13:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh! I didn't see it.
I will try to find it on Google and ask the author if we can post it here.

Regards
Michel
Re: Performance of Oracle 9i in Unix machine (merged 3) [message #271015 is a reply to message #270658] Fri, 28 September 2007 13:55 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Author is/was joel garry
Re: Performance of Oracle 9i in Unix machine (merged 3) [message #271030 is a reply to message #271015] Fri, 28 September 2007 14:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I found the thread. It seems to have not reached my news provider.
I updated the sticky, if you can have a look and correct my introduction.
I'll contact Joel Garry as soon as the thread will reach my far country. Smile

Regards
Michel

[Updated on: Fri, 28 September 2007 14:54]

Report message to a moderator

Re: Performance of Oracle 9i in Unix machine (merged 3) [message #271033 is a reply to message #270658] Fri, 28 September 2007 14:31 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
The updated STICKY look Great!
Previous Topic: ORA-12560:TNS protocol adapter Error while upgrading oracle 8i to Oracle 9i
Next Topic: Slow update with Bulk collect and Forall
Goto Forum:
  


Current Time: Tue Dec 06 08:19:07 CST 2016

Total time taken to generate the page: 0.11315 seconds