-
Oracle 9i is slower then Oracle 8i over the same network
Two weeks ago we moved our database from 8i to 9i. The two databases are sitting on different machines but same location. Now 3 out of 9 sites are getting slow performance in the 9i database. When they connect to the 8i database there is no problem. They are using the same network connection and the same tnsnames file to connect to the two databases. It is just that 9i's perfomance is half of 8i for the 3 sites.
I think it is an Oracle networking setup issue that the 8i does not care about. The tnsnames and sqlnet files for all the sites are the same.
I would really appriciate if someone can help me on this one.
Thanks,
Syed
-
Have you measured ping and tnsping times? Do the listener setups differ at all?
-
Yes the listener setup is the same and tnsping for the two databases is the same as well.
By the way it may not be a networking issue.
Last edited by Syed Mohammad; 12-21-2004 at 07:46 PM.
-
Before moving to 9i did u tested ur application on 9i.If u have statistics available on 8i compare them by obtaining the statistics on 9i.Check ur STATSPACK report 9i may be it will lead u to someware.
-
Have you copied the parameters across from 8i to open your 9i database? i.e. Are you using *_AREA_SIZE instead of PGA_AGGREGATE_TARGET?
-
Do you see SQL is performing slow?
Or network issue?
Tamil
-
It seems like this is not a network issue.
Yes the sql performance is slow. The query that use to return data in 4 seconds is now taking 9 seconds.
Any help would be appriciated.
-
Implement statspack and take reports and see for top SQLs. It's likely that the queries may be going for different execution plan now. Check the init parameters. Especially *sort_area_size, optimizer* and cursor_sharing parameters.
-nagarjuna
-
I ran a tkprof on both databases for the same query. Both cpu and elapsed are better in the new database, but the data is taking 4 more seconds to populate in the new database.
This tells me that there is a network problem. What do you think.
One question I have about net8-9. Is this only to make a connection or does it also have an affect on the speed of the transmission of the data.
Also in the sqlnet file does it matter if you are using the
NAMES.DEFAULT_DOMAIN parameter or not.
Your help would be very much appriciated.
Thanks.
-
Did u run STATSPACK on 9i?.What is the result?Compare them with 8i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|