-
Oracle9i(9.2) is slower than Oracle 8i(8.1.7)
I have couple of Stored Procedures. Which I run on Oracle 8.1.7(32 bit) Sun Solaris 2.8. It has 1.2 GB of SGA.
In the same machine I removed Oracle 8.1.7, installed Oracle 9i(9.2 64 bit, created the database. Kept TEMP space same as earlier also UNDO tablespace also same as earlier. Imported the data. The SGA I kept is 3.5 GB. The taotal RAM in the machine is 12 GB.
Now I run the same stored procedure in Oracle 9i. One of the stored procedures take 6 minutes more and other 10 minutes more.
Any idea..?
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
|