Login or Register to Ask a Question and Join Our Community


UNIX for Advanced & Expert Users

raid 0+1 +oracle getting slow data reads.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums UNIX for Advanced & Expert Users raid 0+1 +oracle getting slow data reads.
# 15  
Old 05-19-2003
Quote:
also oracle 7 and solaris 8 have issues according to oracle helpdesk
What are the issues that the Oracle helpdesk mentioned.
# 16  
Old 05-19-2003
Quote:
Originally posted by thehoghunter
What are the issues that the Oracle helpdesk mentioned.

have no clue. i didnt talk to them. the oracle dba did.
# 17  
Old 05-27-2003
I looked at the init.ora parameters. I dont think that the init.ora is set optimally. It seems that the DBA is bluffing because these parms are out of the box....

he needs to do some performance tuning on his side...

Jigar
Oracle DBA
# 18  
Old 06-18-2003
Hi there,

I would definately try to turn off all the traces the DBA has turned on. They will kill performance and should only be used when absolutely needed.

Do you still need help?

Regards...Michael
# 19  
Old 06-18-2003
naw. this issue is closed. we ended up useing NT for the solution.


i did all i could (as a sys admin) short of becomeing a DBA.
# 20  
Old 07-11-2003
dbinit.ora
Have you ever tried to set the ASYNC_WRITE=TRUE and
ASYNC_READ=TRUE parameters in your init.ora file?
On solaris it is supported on both Filesystems and RAW devices.

check it
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Red Hat

RAID Configuration for IBM Serveraid-7k SCSI RAID Controller

Hello, I want to delete a RAID configuration an old server has. Since i haven't the chance to work with the specific raid controller in the past can you please help me how to perform the configuraiton? I downloaded IBM ServeRAID Support CD but i wasn't able to configure the video card so i... (0 Replies)
Discussion started by: @dagio
0 Replies

2. UNIX for Dummies Questions & Answers

Difference between buffered disk reads and cached reads?

I was analyzing the Disk read using hdparm utility. This is what i got as a result. # hdparm -t /dev/sda /dev/sda: Timing buffered disk reads: 108 MB in 3.04 seconds = 35.51 MB/sec # hdparm -T /dev/sda /dev/sda: Timing cached reads: 3496 MB in 1.99 seconds = 1756.56 MB/sec... (1 Reply)
Discussion started by: pinga123
1 Replies

3. AIX

SCSI PCI - X RAID Controller card RAID 5 AIX Disks disappeared

Hello, I have a scsi pci x raid controller card on which I had created a disk array of 3 disks when I type lspv ; I used to see 3 physical disks ( two local disks and one raid 5 disk ) suddenly the raid 5 disk array disappeared ; so the hardware engineer thought the problem was with SCSI... (0 Replies)
Discussion started by: filosophizer
0 Replies

4. AIX

ORACLE Database running slow on AIX ( nmon / topas )

Hello, How can I know if ORACLE Database is running slow due to Memory or due to processing power ? I have only Oracle Database running on a P4 with 4GB RAM. Could anyone suggest any tools which can help me determine exactly if it is memory issue or processor issue. (43 Replies)
Discussion started by: filosophizer
43 Replies

5. Red Hat

Recover RAID data

Hello, Given a scenario, I have 2 HDD which were used on the server with software RAID. Now, the original server crashed and I have attached these 2 HDD to the new server. Any possible chances to recover the data from any of this HDD ? I want to mount /dev/sdb3 on some folder.. Output of... (3 Replies)
Discussion started by: chinmay
3 Replies

6. Shell Programming and Scripting

Get data from 3 differrnt oracle DB & then compare data

Hi All, I have a requirement to write a shell script for the following... we have 3 different database.... lets say A, B, C From these 3 DBs, i need to get data.. all have 3 different table...a,b, c A.a => Emp_code, count(*) B.b => emp_code, count(*) C.c => emp_code, copunt(*) Once get this... (4 Replies)
Discussion started by: Amit.Sagpariya
4 Replies

7. UNIX for Dummies Questions & Answers

Howto capture data from rs232port andpull data into oracle database-9i automatically

Hi, i willbe very much grateful to u if u help me out.. if i simply connect pbx machine to printer by serial port RS232 then we find this view: But i want to capture this data into database automatically when the pbx is running.The table in database will contain similar to this view inthe... (1 Reply)
Discussion started by: boss
1 Replies
Login or Register to Ask a Question