| different plan output [message #65361] |
Thu, 19 August 2004 05:12  |
Dawn
Messages: 10
Registered: April 2001
|
Junior Member |
|
|
My development server is on LINUX and my production server is on UNIX. Both similar spec eg both 6Gb RAM, both 2CPU, both RAID 5 disks with same directory structure etc. The database is static and was imported onto the production server using import. Indexes were freshly rebuilt. Why when the same queries are executed on both servers does the card= value and bytes = value in the explain plans are always alot larger (3-4 times) on the UNIX machine than Linux, hence the UNIX machine is 3-4 times slower.
Any ideas ? Thanks
|
|
|
|
| Re: different plan output [message #65362 is a reply to message #65361] |
Thu, 19 August 2004 05:27  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi,
Maybe you don't have object statistics, or they might be out of date. Have you recently ANALYZED all your tables, indexes and partitions?
Best regards.
Frank
|
|
|
|
| Re: different plan output [message #65363 is a reply to message #65362] |
Thu, 19 August 2004 07:01 |
Dawn
Messages: 10
Registered: April 2001
|
Junior Member |
|
|
|
Yes I analyzed them all using dms_stats and I gathered system stats. Would it be wise to copy the stats from the test server onto production?
|
|
|
|
| Re: different plan output [message #65364 is a reply to message #65363] |
Mon, 23 August 2004 04:12 |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi Dawn,
Why not? Just remember to save your production stats before doing so (using DBMS_STATS.EXPORT_*_STATS). Also, don't forget to update us on the outcome!
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
