Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> USING COST BASED OPTIMISATION ON A MULTI-PROCESSOR,MULTI-DISK DRIVE SERVER
Hello!! In our company we are currently using a Production Environment which
is Multi-cpu ( 4 processors ), Multi-disk drive ( Meaning the DataBase Table
Data are spread across multi-disk drives) and the Oracle Version is 8.0.3. We
are enforcing Cost Based and Rule based Hints in the Application SQL . The
DataBase Load Average in Production shoots up very high immediately as soon
as Statistics are added and the code containing hints are applied whereas on
Test Machines which have half the RAM, HAlf the no of processors, Single disk
drive, we don't see such abnormal Load Average shoot-up. I would definitely
very much appreciate it if somebody could provide some suggestions as to what
could be causing the Problem in Production and how to go about detecting it.
Does adding Statistics on a Production Environment like the one mentioned
above, create problems??? Reply to sudha_at_altasoft.com THANKS IN ADVANCE!!
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 16:14:08 CST