LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 02-09-2006, 09:37 PM   #16
ashley75
Member
 
Registered: Aug 2003
Posts: 231

Original Poster
Rep: Reputation: 30

tink,

thanks so much for your help and sorry for any inconvenience on my post that may have caused.

when you mentioned about auditing. how do you check and see if you have auditing turn on on the server??? and if it's turn on, how can you turn it off???

thanks,
 
Old 02-09-2006, 09:49 PM   #17
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,976
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Before you go to turn it off, check whether it's running in the first
place ;) Have a look in /var/log/audit.d .. if you got many (and, more
importantly, recent) huge files in there, auditing is on...


You still didn't tell us whether it's RedHat, and if it is, which
version it is ... assuming that you're using something similar to
us (AS3) for Oracle I'll give you these two commands:

Code:
service audit stop
chkconfig audit off


Cheers,
Tink
 
Old 02-10-2006, 08:33 AM   #18
ashley75
Member
 
Registered: Aug 2003
Posts: 231

Original Poster
Rep: Reputation: 30
I am only Linux Redhat 3.0 AS

thanks again and I think audit already off when I tried to shut it down and it failed and I also do the chkcconfig audit off.

are there any other services or anything on OS side I can turn them off for the database server??? this is purely database server, nothing else on there.

have a great weeekend TINK
 
Old 02-10-2006, 02:06 PM   #19
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,976
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Please post the output of
fdisk -l
and
lspci -v
here ... I *still* don't know anything about the hardware (except for the
amount of physical RAM and that it's a machine with 4 or 2 CPUs (the latter
if hyper-threading was enabled).


Cheers,
Tink
 
Old 02-10-2006, 03:56 PM   #20
ashley75
Member
 
Registered: Aug 2003
Posts: 231

Original Poster
Rep: Reputation: 30
for fdisk:
Code:
Disk /dev/sda: 146.6 GB, 146695782400 bytes
255 heads, 63 sectors/track, 17834 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot    Start       End    Blocks   Id  System
/dev/sda1             1         8     64228+  de  Dell Utility
/dev/sda2   *         9        27    152617+  83  Linux
/dev/sda3            28     16431 131765130   83  Linux
/dev/sda4         16432     17834  11269597+   f  Win95 Ext'd (LBA)
/dev/sda5         16432     17451   8193118+  83  Linux
/dev/sda6         17452     17833   3068383+  82  Linux swap

Disk /dev/sdb: 440.0 GB, 440087347200 bytes
255 heads, 63 sectors/track, 53504 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes

   Device Boot    Start       End    Blocks   Id  System
/dev/sdb1   *         1     53504 429770848+  83  Linux
for


00:00.0 Host bridge: Intel Corporation E7520 Memory Controller Hub (rev 09)
Subsystem: Dell: Unknown device 016d
Flags: bus master, fast devsel, latency 0
Capabilities: [40] #09 [4105]

00:02.0 PCI bridge: Intel Corporation E7525/E7520/E7320 PCI Express Port A (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=00, secondary=01, subordinate=03, sec-latency=0
Memory behind bridge: dfc00000-dfefffff
Prefetchable memory behind bridge: 00000000d8000000-00000000d8000000
Secondary status: SERR
Capabilities: [50] Power Management version 2
Capabilities: [58] Message Signalled Interrupts: 64bit- Queue=0/1 Enable-
Capabilities: [64] #10 [0041]

00:04.0 PCI bridge: Intel Corporation E7525/E7520 PCI Express Port B (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=00, secondary=04, subordinate=04, sec-latency=0
Capabilities: [50] Power Management version 2
Capabilities: [58] Message Signalled Interrupts: 64bit- Queue=0/1 Enable-
Capabilities: [64] #10 [0041]

00:05.0 PCI bridge: Intel Corporation E7520 PCI Express Port B1 (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=00, secondary=05, subordinate=07, sec-latency=0
I/O behind bridge: 0000d000-0000efff
Memory behind bridge: df700000-dfbfffff
Secondary status: SERR
Capabilities: [50] Power Management version 2
Capabilities: [58] Message Signalled Interrupts: 64bit- Queue=0/1 Enable-
Capabilities: [64] #10 [0041]

00:06.0 PCI bridge: Intel Corporation E7520 PCI Express Port C (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=00, secondary=08, subordinate=0a, sec-latency=0
Memory behind bridge: df600000-df6fffff
Secondary status: SERR
Capabilities: [50] Power Management version 2
Capabilities: [58] Message Signalled Interrupts: 64bit- Queue=0/1 Enable-
Capabilities: [64] #10 [0041]

00:1d.0 USB Controller: Intel Corporation 82801EB/ER (ICH5/ICH5R) USB UHCI Controller #1 (rev 02) (prog-if 00 [UHCI])
Subsystem: Dell: Unknown device 016d
Flags: bus master, medium devsel, latency 0, IRQ 16
I/O ports at bce0 [size=32]

00:1d.1 USB Controller: Intel Corporation 82801EB/ER (ICH5/ICH5R) USB UHCI Controller #2 (rev 02) (prog-if 00 [UHCI])
Subsystem: Dell: Unknown device 016d
Flags: bus master, medium devsel, latency 0, IRQ 19
I/O ports at bcc0 [size=32]

00:1d.2 USB Controller: Intel Corporation 82801EB/ER (ICH5/ICH5R) USB UHCI #3 (rev 02) (prog-if 00 [UHCI])
Subsystem: Dell: Unknown device 016d
Flags: bus master, medium devsel, latency 0, IRQ 18
I/O ports at bca0 [size=32]

00:1d.7 USB Controller: Intel Corporation 82801EB/ER (ICH5/ICH5R) USB2 EHCI Controller (rev 02) (prog-if 20 [EHCI])
Subsystem: Dell: Unknown device 016d
Flags: bus master, medium devsel, latency 0, IRQ 23
Memory at dff00000 (32-bit, non-prefetchable) [size=1K]
Capabilities: [50] Power Management version 2
Capabilities: [58] #0a [20a0]

00:1e.0 PCI bridge: Intel Corporation 82801 PCI Bridge (rev c2) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=00, secondary=0b, subordinate=0b, sec-latency=32
I/O behind bridge: 0000c000-0000cfff
Memory behind bridge: df400000-df5fffff
Prefetchable memory behind bridge: d0000000-d7ffffff

00:1f.0 ISA bridge: Intel Corporation 82801EB/ER (ICH5/ICH5R) LPC Interface Bridge (rev 02)
Flags: bus master, medium devsel, latency 0

00:1f.1 IDE interface: Intel Corporation 82801EB/ER (ICH5/ICH5R) IDE Controller (rev 02) (prog-if 8a [Master SecP PriP])
Subsystem: Dell: Unknown device 016d
Flags: bus master, medium devsel, latency 0
I/O ports at <unassigned>
I/O ports at <unassigned>
I/O ports at <unassigned>
I/O ports at <unassigned>
I/O ports at fc00 [size=16]
Memory at cffff000 (32-bit, non-prefetchable) [size=1K]

01:00.0 PCI bridge: Intel Corporation 80332 [Dobson] I/O processor (rev 06) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=01, secondary=02, subordinate=02, sec-latency=64
Memory behind bridge: dfd00000-dfefffff
Prefetchable memory behind bridge: 00000000d8000000-00000000d8000000
Capabilities: [44] #10 [0071]
Capabilities: [5c] Message Signalled Interrupts: 64bit+ Queue=0/0 Enable-
Capabilities: [6c] Power Management version 2
Capabilities: [d8] PCI-X non-bridge device.

01:00.2 PCI bridge: Intel Corporation 80332 [Dobson] I/O processor (rev 06) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=01, secondary=03, subordinate=03, sec-latency=64
Capabilities: [44] #10 [0071]
Capabilities: [5c] Message Signalled Interrupts: 64bit+ Queue=0/0 Enable-
Capabilities: [6c] Power Management version 2
Capabilities: [d8] PCI-X non-bridge device.

02:0e.0 RAID bus controller: Dell PowerEdge Expandable RAID controller 4 (rev 06)
Subsystem: Dell PowerEdge Expandable RAID Controller 4e/Di
Flags: bus master, stepping, 66Mhz, medium devsel, latency 64, IRQ 38
Memory at d80f0000 (32-bit, prefetchable) [size=64K]
Memory at dfdc0000 (32-bit, non-prefetchable) [size=256K]
Expansion ROM at dfe00000 [disabled] [size=128K]
Capabilities: [c0] Power Management version 2
Capabilities: [d0] Message Signalled Interrupts: 64bit+ Queue=0/1 Enable-
Capabilities: [e0] PCI-X non-bridge device.

05:00.0 PCI bridge: Intel Corporation 6700PXH PCI Express-to-PCI Bridge A (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=05, secondary=06, subordinate=06, sec-latency=32
I/O behind bridge: 0000e000-0000efff
Memory behind bridge: dfa00000-dfbfffff
Capabilities: [44] #10 [0071]
Capabilities: [5c] Message Signalled Interrupts: 64bit+ Queue=0/0 Enable-
Capabilities: [6c] Power Management version 2
Capabilities: [d8] PCI-X non-bridge device.

05:00.2 PCI bridge: Intel Corporation 6700PXH PCI Express-to-PCI Bridge B (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=05, secondary=07, subordinate=07, sec-latency=32
I/O behind bridge: 0000d000-0000dfff
Memory behind bridge: df800000-df9fffff
Capabilities: [44] #10 [0071]
Capabilities: [5c] Message Signalled Interrupts: 64bit+ Queue=0/0 Enable-
Capabilities: [6c] Power Management version 2
Capabilities: [d8] PCI-X non-bridge device.

06:07.0 Ethernet controller: Intel Corporation 82541GI/PI Gigabit Ethernet Controller (rev 05)
Subsystem: Dell: Unknown device 016d
Flags: bus master, 66Mhz, medium devsel, latency 32, IRQ 48
Memory at dfae0000 (32-bit, non-prefetchable) [size=128K]
I/O ports at ecc0 [size=64]
Capabilities: [dc] Power Management version 2
Capabilities: [e4] PCI-X non-bridge device.

07:08.0 Ethernet controller: Intel Corporation 82541GI/PI Gigabit Ethernet Controller (rev 05)
Subsystem: Dell: Unknown device 016d
Flags: bus master, 66Mhz, medium devsel, latency 32, IRQ 49
Memory at df8e0000 (32-bit, non-prefetchable) [size=128K]
I/O ports at dcc0 [size=64]
Capabilities: [dc] Power Management version 2
Capabilities: [e4] PCI-X non-bridge device.

08:00.0 PCI bridge: Intel Corporation 6700PXH PCI Express-to-PCI Bridge A (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=08, secondary=09, subordinate=09, sec-latency=64
Capabilities: [44] #10 [0071]
Capabilities: [5c] Message Signalled Interrupts: 64bit+ Queue=0/0 Enable-
Capabilities: [6c] Power Management version 2
Capabilities: [d8] PCI-X non-bridge device.

08:00.2 PCI bridge: Intel Corporation 6700PXH PCI Express-to-PCI Bridge B (rev 09) (prog-if 00 [Normal decode])
Flags: bus master, fast devsel, latency 0
Bus: primary=08, secondary=0a, subordinate=0a, sec-latency=64
Capabilities: [44] #10 [0071]
Capabilities: [5c] Message Signalled Interrupts: 64bit+ Queue=0/0 Enable-
Capabilities: [6c] Power Management version 2
Capabilities: [d8] PCI-X non-bridge device.

0b:0d.0 VGA compatible controller: ATI Technologies Inc Radeon RV100 QY [Radeon 7000/VE] (prog-if 00 [VGA])
Subsystem: Dell: Unknown device 016d
Flags: bus master, VGA palette snoop, stepping, medium devsel, latency 32, IRQ 18
Memory at d0000000 (32-bit, prefetchable) [size=128M]
I/O ports at cc00 [size=256]
Memory at df4f0000 (32-bit, non-prefetchable) [size=64K]
Expansion ROM at <unassigned> [disabled] [size=128K]
Capabilities: [50] Power Management version 2


about the hardware, it's Xeon processor, with 2 CPUs hyper so it likes 4 with 3Ghx processor.
 
Old 02-10-2006, 04:12 PM   #21
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,976
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Cool ... now, what can you tell me about the HDDs?
They must both (sda and sdb) be hanging off the RAID
controller? Are they on separate channels, or on
the same? And for sdb at least I assume that you're
using some RAID setup, can you give me details?



One thing I found surprising in the output of lspci
is that it says the Ethernet cards are unknown -
which kernel are you running on the machine?


Cheers,
Tink
 
Old 02-11-2006, 10:26 AM   #22
ashley75
Member
 
Registered: Aug 2003
Posts: 231

Original Poster
Rep: Reputation: 30
thanks Tink,

sda is running on RAID 1 that where I put Linux software, Oracle home and Oracle files that frequently being used.

sdb is running on RAID 5 that where all of my database datafiles.




below is my kernel info:

2.4.21-32.0.1.ELsmp


I am very new with Linux so I am affraid to mess with kernel so any advises will be greatly appreciated.
 
Old 02-11-2006, 02:08 PM   #23
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,976
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Are they on the same SCSI channel? And how many disks is the
RAID5 comprised of?

Another question I forgot to ask earlier: the gzip you were
running in that test - which filesystem did you run it on,
and how often do you use it?

In terms of layout for Oracle: RAID-5 may not be the best
solution in terms of performance, if money wasn't an issue I'd
suggest RAID-10; and it would also make sense to have the data,
the indices and the archive-logs on separate physical drives,
specially if you have many busy databases.



Cheers,
Tink
 
Old 02-11-2006, 02:19 PM   #24
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,976
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Another tuning aspect that may be quite important: what's
the data-block size you've chosen for Oracle, and which
chunk size does the RAID use? Ideally you'd want them to
be the same, I did a bit of reading up on your controller,
and it appears that it has a default of 32K which may be a
bit bigger than what your Oracle install uses.

Also: how big is the cache on the controller?


Cheers,
Tink
 
Old 02-11-2006, 09:41 PM   #25
ashley75
Member
 
Registered: Aug 2003
Posts: 231

Original Poster
Rep: Reputation: 30
Hi TInk,

All of the thing you have mentioned about the database, it's already been implemented since I am aware of those things. as far as redo, controlfiles and temp and system are on RAID 1 only database files are on RAID 5 and samething for indexes since I don't have much options here. RAID 5 is the way company will go so I have to live with it.


you ask: Ideally you'd want them to be the same, I did a bit of reading up on your controller, and it appears that it has a default of 32K which may be a bit bigger than what your Oracle install uses.

Answer: sorry I don't know what are you looking for.


Are they on the same SCSI channel? And how many disks is the RAID5 comprised of?

Answer: yes and I think it had 7-8 disks
 
Old 02-11-2006, 11:41 PM   #26
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 22,976
Blog Entries: 11

Rep: Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879Reputation: 879
Quote:
Originally Posted by ashley75
Hi TInk,

All of the thing you have mentioned about the database, it's already been implemented since I am aware of those things. as far as redo, controlfiles and temp and system are on RAID 1 only database files are on RAID 5 and samething for indexes since I don't have much options here. RAID 5 is the way company will go so I have to live with it.
Bummer :} ...

Quote:
Originally Posted by ashley75
you ask: Ideally you'd want them to be the same, I did a bit of reading up on your controller, and it appears that it has a default of 32K which may be a bit bigger than what your Oracle install uses.

Answer: sorry I don't know what are you looking for.
If you have any utilities to monitor/configure the RAID card,
have a look as to what size its smallest allocation unit is. If
it's e.g. 4 times the size of the DBs block size that may slow
things down quite significantly.


Quote:
Originally Posted by ashley75
Are they on the same SCSI channel? And how many disks is the RAID5 comprised of?

Answer: yes and I think it had 7-8 disks
Oh well ... can they be separated? The channels, I mean.
Looks like all disk I/O is going over one pipe. As for the
number - not too shabby. Do you have a chance to run
bonnie against the both sda and sdb at a time when the
DB is idle?


Cheers,
Tink
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
high iowait in RHES sklam Red Hat 20 12-14-2006 12:35 PM
CPUs in high IOwait state despite of lack of load kvsraju Linux - Enterprise 3 11-03-2005 03:34 PM


All times are GMT -5. The time now is 09:51 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration