What Bonnie's benchmark should we expect for RAID 0+1
Hello, We have a Compaq AlphaServer 8400 with 8 GB RAM, 8 dual 625mhz CPUs and two HSZ70 Array Controllers. Each Controller is connected to 24 36GB 10K rpm Ultr SCSI disk divers. In the system, some volums are configured as RAID 1, and the others are configured as RAID 0+1 with 3 striping. However, we can't see significant performance improvement in RAID 0+1 volums except random seek. The following are the Bonnie's benchmarks for two kinds of volums: For RAID 1: ---Sequential Output ---Sequential Input-- --Random-- -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- MachineMB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU RAID11024 9029 55.1 9108 14.3 8956 15.6 15700 89.4 115531 99.9 2535.2 65.9 For RAID 0+1: ---Sequential Output ---Sequential Input-- --Random-- -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- MachineMB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU RAID01 1024 9780 58.8 9872 17.1 14067 25.7 15990 89.7 56037 59.5 5374.3 169.9 Is there something wrong? What Bonnie's benchmark should we expect for RAID 0+1? Thanks, Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to re-trace a session
Hello, I successfully traced a long running session by using dbms_system.set_ev procedure, and moved the trace file to somewhere else. However, when I used the same command to re-trace the same session, I can't see the trace file again. There was no error message. I tried to use oradebug and dbms_system.set_sql_trace_in_session to trace the same session. No matter what method I used, I still can't see the trace file. Then, I tried to trace other sessions using all available methods, but all failed. Even though there was no error message, I can't see trace files. Can someone tell me what is wrong and how can I re-enable the sql trace? Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-trace a session
Jared, Tim and Anjo, Thanks for your help. In fact, I stopped the tracing first, then cp the trace file to other directory and rm it. Also I can't trace other sessions now. Tom -Original Message- Sent: Tuesday, October 08, 2002 12:41 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Importance: High Tom, The problem is that you moved the file. Oracle will use the same file name, when you stop/restart tracing, and in fact leaves the file handle open until the session disconnects. Moving the file disables the output. Jared Xie, Tom [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/08/2002 11:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to re-trace a session Hello, I successfully traced a long running session by using dbms_system.set_ev procedure, and moved the trace file to somewhere else. However, when I used the same command to re-trace the same session, I can't see the trace file again. There was no error message. I tried to use oradebug and dbms_system.set_sql_trace_in_session to trace the same session. No matter what method I used, I still can't see the trace file. Then, I tried to trace other sessions using all available methods, but all failed. Even though there was no error message, I can't see trace files. Can someone tell me what is wrong and how can I re-enable the sql trace? Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to re-trace a session
I made a mistake. In fact, I can trace other sessions. But I can't re-trace the session of which trace file had been removed. Is there any way that I can re-trace the session without restarting the session? Tom -Original Message- Sent: Tuesday, October 08, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Jared, Tim and Anjo, Thanks for your help. In fact, I stopped the tracing first, then cp the trace file to other directory and rm it. Also I can't trace other sessions now. Tom -Original Message- Sent: Tuesday, October 08, 2002 12:41 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Importance: High Tom, The problem is that you moved the file. Oracle will use the same file name, when you stop/restart tracing, and in fact leaves the file handle open until the session disconnects. Moving the file disables the output. Jared Xie, Tom [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/08/2002 11:03 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to re-trace a session Hello, I successfully traced a long running session by using dbms_system.set_ev procedure, and moved the trace file to somewhere else. However, when I used the same command to re-trace the same session, I can't see the trace file again. There was no error message. I tried to use oradebug and dbms_system.set_sql_trace_in_session to trace the same session. No matter what method I used, I still can't see the trace file. Then, I tried to trace other sessions using all available methods, but all failed. Even though there was no error message, I can't see trace files. Can someone tell me what is wrong and how can I re-enable the sql trace? Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile from a tablespace quickly
Thanks, Winnie! It works.
I have a further quetion. If the archivelogs from time when the file was
created to current were lost, do we still have someway to bring the file
online?
Tom
-Original Message-
Sent: Wednesday, May 15, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
Umm.. Try this:
1) ALTER DATABASE DATAFILE 'filename' OFFLINE;
2) get rid of the offended datafile from OS
3) ALTER DATABASE CREATE DATAFILE 'filename(same as 1)';
4) RECOVER DATAFILE 'filename';
5) ALTER DATABASE DATAFILE 'filename' ONLINE;
Winnie
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Xie, Tom
[EMAIL PROTECTED]To:
'[EMAIL PROTECTED]' [EMAIL PROTECTED]
om cc:
'[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: How to drop a
datafile from a tablespace quickly
05/15/02 09:32 AM
Since there is no data in the file, can we make a datafile to replace it?
Tom Xie
-Original Message-
Sent: Wednesday, May 15, 2002 11:25 AM
To: [EMAIL PROTECTED]
There is absolutely NO WAY to drop a datafile from a tablespace at all.
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Xie, Tom
[EMAIL PROTECTED]To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
om cc:
Sent by: Subject: How to drop a
datafile from a tablespace quickly
[EMAIL PROTECTED]
05/15/02 09:58 AM
Please respond to
ORACLE-L
Dear gurus:
I just added a data file to a big tablespace (11GB) that has only one
table. Unfortunately, when it was being backed up, the file head head
corrupted. I don't have any backup of this file. I found that there is
no data in this file yet. So I want to drop the file from the
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.
Is there anyway I can quickly drop a data file from a tablespace?
Don't tell me using alter database datafile '...' offline drop command.
It won't work.
I am working on Oracle 7.3.4.
Thanks,
Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you
How to drop a datafile from a tablespace quickly
Dear gurus: I just added a data file to a big tablespace (11GB) that has only one table. Unfortunately, when it was being backed up, the file head head corrupted. I don't have any backup of this file. I found that there is no data in this file yet. So I want to drop the file from the tablespace. As I know, to drop a data file, I have to export the data, drop the tablespace and recreate it, and then import data back to the tablespace. However, since our users can't stop using the table, I won't have enough down time to do that. Is there anyway I can quickly drop a data file from a tablespace? Don't tell me using alter database datafile '...' offline drop command. It won't work. I am working on Oracle 7.3.4. Thanks, Tom Xie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to drop a datafile from a tablespace quickly
Since there is no data in the file, can we make a datafile to replace it?
Tom Xie
-Original Message-
Sent: Wednesday, May 15, 2002 11:25 AM
To: [EMAIL PROTECTED]
There is absolutely NO WAY to drop a datafile from a tablespace at all.
--
\ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~
(@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~
/ V \ Oracle Database Administrator`~`~
o--m-m--o Infonet Services Corporation `~`~
# mailto:[EMAIL PROTECTED]`~`~
~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~
Xie, Tom
[EMAIL PROTECTED]To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
om cc:
Sent by: Subject: How to drop a
datafile from a tablespace quickly
[EMAIL PROTECTED]
05/15/02 09:58 AM
Please respond to
ORACLE-L
Dear gurus:
I just added a data file to a big tablespace (11GB) that has only one
table. Unfortunately, when it was being backed up, the file head head
corrupted. I don't have any backup of this file. I found that there is
no data in this file yet. So I want to drop the file from the
tablespace. As I know, to drop a data file, I have to export the data,
drop the tablespace and recreate it, and then import data back to
the tablespace. However, since our users can't stop using the table,
I won't have enough down time to do that.
Is there anyway I can quickly drop a data file from a tablespace?
Don't tell me using alter database datafile '...' offline drop command.
It won't work.
I am working on Oracle 7.3.4.
Thanks,
Tom Xie
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Xie, Tom
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
