Disk Enclosures
1748134 Members
3605 Online
108758 Solutions
New Discussion

Oracle Database Performance

 
Janice_4
Occasional Contributor

Oracle Database Performance

Hi

Can anyone help me to understand the hardware kit and tell me what questions I should ask the system administrator with regards to Database (8i) performance and how the system should be tuned?

From what I understand we have a HP9000 (L200 series)64bit with HP-UX 11i. We have an external disk array called a SureStore Virtual Array 7100/7400 with 12 36Gb disk (cnfigured in luns 246Gb). Two controllers(512Mb per controller),etc,etc, ZZZZZZZZZZZZZzzzzzzzzzz!!!!
don't know
1 REPLY 1
Alexander M. Ermes
Honored Contributor

Re: Oracle Database Performance

Hi there.
Get the Install and Upgrade Guide from Oracle.
Then go through the system parts of it like kernel config, io distibution etc.
There is also a part in the Oracle documentation( database tuning ), which tells you, how to minimize i/o bottlenecks.
Get these docs from Oracle Technet or Metalink and discuss it with your sysadmin.
Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"