Notices
Computer & Technology Related Post here for help and discussion of computing and related technology. Internet, TVs, phones, consoles, computers, tablets and any other gadgets.

Any Oracle DBA's on here???

Thread Tools
 
Search this Thread
 
Old 12 February 2004, 10:43 AM
  #1  
Cupramax
Scooby Regular
Thread Starter
 
Cupramax's Avatar
 
Join Date: Oct 2002
Location: UK
Posts: 898
Likes: 0
Received 0 Likes on 0 Posts
Thumbs up Any Oracle DBA's on here???

Have a quick technical question, we have an Oracle 7.3.4 workgroup server running on NT4 which is starting to struggle processor performance wise. Currently twin PIII Xeon, it has no memory or disk space issues and only has about 45 users.

Can anyone give me the recommended hardware config for disk (i.e. stripe sets for O/S, index tables, data tables, logs etc etc as am looking at moving the lot on to a new faster box as a temp fix. Also how many processors can this code support? Before anyone says, I know 7.3.4 isn't supported anymore but binning it isn't an option at the moment. Need to just keep it trundling along for another 12 months.

Any help mucho appreciated
Old 12 February 2004, 10:55 AM
  #2  
TopBanana
Scooby Regular
 
TopBanana's Avatar
 
Join Date: Jan 2001
Posts: 9,781
Likes: 0
Received 0 Likes on 0 Posts
Default

Don't know how many CPU's it supports, but I've seen 7.3.something running on a quad processor box. You're better off running two very fast processors than four quite fast ones. If disk performance isn't a problem, you probably don't need to worry too much about it? Unless the disks controllers are cheap/nasty and hogging the processor?
Old 12 February 2004, 11:03 AM
  #3  
Cupramax
Scooby Regular
Thread Starter
 
Cupramax's Avatar
 
Join Date: Oct 2002
Location: UK
Posts: 898
Likes: 0
Received 0 Likes on 0 Posts
Smile

Originally Posted by jlanng
Don't know how many CPU's it supports, but I've seen 7.3.something running on a quad processor box. You're better off running two very fast processors than four quite fast ones. If disk performance isn't a problem, you probably don't need to worry too much about it? Unless the disks controllers are cheap/nasty and hogging the processor?
I wouldn't have thought so. Its running on a Proliant ML530 with with a 128mb 5304 smartarray controller.
Old 12 February 2004, 11:32 AM
  #4  
Rich B
Scooby Regular
 
Rich B's Avatar
 
Join Date: May 2002
Posts: 119
Likes: 0
Received 0 Likes on 0 Posts
Default

If you can afford a RAID 1+0 config then go for that and stick everything on it - its what Oracle recommends (SAME - stripe and mirror everything).

http://otn.oracle.com/deploy/availab...pdf/MAA_WP.pdf - have a search for SAME within the pdf

Rich
Old 16 February 2004, 08:31 AM
  #5  
Cupramax
Scooby Regular
Thread Starter
 
Cupramax's Avatar
 
Join Date: Oct 2002
Location: UK
Posts: 898
Likes: 0
Received 0 Likes on 0 Posts
Thumbs up

Originally Posted by Rich B
If you can afford a RAID 1+0 config then go for that and stick everything on it - its what Oracle recommends (SAME - stripe and mirror everything).

http://otn.oracle.com/deploy/availab...pdf/MAA_WP.pdf - have a search for SAME within the pdf

Rich
Excellent Rich, thats what I was after.
Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
psport
Subaru Parts
2
21 September 2015 01:53 PM
CC
Computer & Technology Related
4
26 March 2003 04:03 PM
Kevin Mc
Computer & Technology Related
5
29 May 2002 02:51 PM
stan
Non Scooby Related
5
20 September 2000 02:07 PM



Quick Reply: Any Oracle DBA's on here???



All times are GMT +1. The time now is 08:32 PM.