RE: max 5% of pga_aggregate_target for a single serial session
select BELNR,count(*) from sapr3.bsis group by BELNR order by BELNR This was the SQL running at that time. -Original Message- Sent: Tuesday, December 30, 2003 5:44 PM To: Multiple recipients of list ORACLE-L It is possible for a single session to require more than one sort or hash area at a time. For example a 4 table hash could require 3 in-memory hash tables (and therefore use 3 x hash_area_size in the days before pga_agg_target). Possibly your session used 150MB, but had multiple areas open at once, of which the largest was 90MB.- are the definitions of the columns completely unambiguous, or is there room for error in interpreting their use ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___November The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 8:59 PM Hi, First of all, thank you to all answered my last question. Now I have another question related to my last one. In my system, pga_aggregate_target is set to 3GB and I think a session would have approximately 150MB work area before temp space is needed (5% of 3GB). But I did a test, it only used 90MB max. Anyone has a explanation? Thanks, Roger Xu SQL 1 select sid 2 ,ACTIVE_TIME 3 ,WORK_AREA_SIZE 4 ,EXPECTED_SIZE expected 5 ,ACTUAL_MEM_USED actual 6 ,MAX_MEM_USED max 7 ,NUMBER_PASSES pass 8 ,TEMPSEG_SIZE tempsize 9 from v$sql_workarea_active; SID ACTIVE_TIME WORK_AREA_SIZE EXPECTED ACTUALMAX PASS TEMPSIZE -- --- -- -- -- -- --- --- -- 13 1644005675 29966336 29966336 24232960 91504640 1 470712320 SQL select * from v$pgastat; NAME VALUE UNIT -- aggregate PGA target parameter 3221225472 bytes aggregate PGA auto target2861061120 bytes global memory bound 104857600 bytes total PGA inuse62332928 bytes total PGA allocated 188590080 bytes maximum PGA allocated 188590080 bytes total freeable PGA memory 81330176 bytes PGA memory freed back to OS 1677459456 bytes total PGA used for auto workareas 20333568 bytes maximum PGA used for auto workareas91521024 bytes total PGA used for manual workareas 0 bytes maximum PGA used for manual workareas 0 bytes over allocation count 0 bytes processed 3.4667E+10 bytes extra bytes read/written 0 bytes cache hit percentage100 percent 16 rows selected. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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.net -- Author: Jonathan Lewis 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257
max 5% of pga_aggregate_target for a single serial session
Hi, First of all, thank you to all answered my last question. Now I have another question related to my last one. In my system, pga_aggregate_target is set to 3GB and I think a session would have approximately 150MB work area before temp space is needed (5% of 3GB). But I did a test, it only used 90MB max. Anyone has a explanation? Thanks, Roger Xu SQL 1 select sid 2 ,ACTIVE_TIME 3 ,WORK_AREA_SIZE 4 ,EXPECTED_SIZE expected 5 ,ACTUAL_MEM_USED actual 6 ,MAX_MEM_USED max 7 ,NUMBER_PASSES pass 8 ,TEMPSEG_SIZE tempsize 9 from v$sql_workarea_active; SID ACTIVE_TIME WORK_AREA_SIZE EXPECTED ACTUALMAX PASS TEMPSIZE -- --- -- -- -- -- -- -- 13 1644005675 29966336 29966336 24232960 91504640 1 470712320 SQL select * from v$pgastat; NAME VALUE UNIT -- aggregate PGA target parameter 3221225472 bytes aggregate PGA auto target2861061120 bytes global memory bound 104857600 bytes total PGA inuse62332928 bytes total PGA allocated 188590080 bytes maximum PGA allocated 188590080 bytes total freeable PGA memory 81330176 bytes PGA memory freed back to OS 1677459456 bytes total PGA used for auto workareas 20333568 bytes maximum PGA used for auto workareas91521024 bytes total PGA used for manual workareas 0 bytes maximum PGA used for manual workareas 0 bytes over allocation count 0 bytes processed 3.4667E+10 bytes extra bytes read/written 0 bytes cache hit percentage100 percent 16 rows selected. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: max 5% of pga_aggregate_target for a single serial session
no. it used 800 MB of tempspace in the end. (also see the tempsize column output from the query of the v$sql_workarea_active view) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Tuesday, December 30, 2003 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: Re: max 5% of pga_aggregate_target for a single serial session90 Meg was all it needed? "Roger Xu" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/30/2003 12:59 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:max 5% of pga_aggregate_target for a single serial sessionHi,First of all, thank you to all answered my last question.Now I have another question related to my last one.In my system, pga_aggregate_target is set to 3GB and Ithink a session would have approximately 150MB work areabefore temp space is needed (5% of 3GB).But I did a test, it only used 90MB max. Anyone has a explanation?Thanks,Roger XuSQL 1 select sid2 ,ACTIVE_TIME3 ,WORK_AREA_SIZE4 ,EXPECTED_SIZE expected5 ,ACTUAL_MEM_USED actual6 ,MAX_MEM_USED max7 ,NUMBER_PASSES pass8 ,TEMPSEG_SIZE tempsize9 from v$sql_workarea_active; SID ACTIVE_TIME WORK_AREA_SIZE EXPECTED ACTUAL MAXPASS TEMPSIZE-- --- -- -- -- -- -- -- 13 1644005675 29966336 29966336 24232960 91504640 1 470712320SQL select * from v$pgastat;NAME VALUE UNIT -- aggregate PGA target parameter 3221225472 bytesaggregate PGA auto target 2861061120 bytesglobal memory bound 104857600 bytestotal PGA inuse 62332928 bytestotal PGA allocated 188590080 bytesmaximum PGA allocated 188590080 bytestotal freeable PGA memory 81330176 bytesPGA memory freed back to OS 1677459456 bytestotal PGA used for auto workareas 20333568 bytesmaximum PGA used for auto workareas91521024 bytestotal PGA used for manual workareas0 bytesmaximum PGA used for manual workareas 0 bytesover allocation count 0bytes processed 3.4667E+10 bytesextra bytes read/written 0 bytescache hit percentage 100 percent16 rows selected.This email has been scanned for all viruses by the MessageLabs EmailSecurity System. For more information on a proactive email securityservice working around the clock, around the globe, visithttp://www.messagelabs.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Roger XuINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com
RE: rman restore question
I think you can do CONFIGURE CONTROLFILE AUTOBACKUP ON, which enables RMAN to automatically backup controlfile to a default location. Then you can restore the controlfile before you restore other database files. -Original Message- Sent: Tuesday, December 30, 2003 3:34 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have a question about rman restore. Right now, I configured RETENTION POLICY TO REDUNDANCY=1 and deleted the obsolete backupset on the disk after a new rman full backup is done. The old backupset will be backup-ed to tape by system group. In case of the newly backupset on disk is corrupted and need to restore the 2 days old backupset from tape. Is there any way or command to restore the database using a already deleted obsoleted backupset? (from rman catalog point of view) I could find any command and example to restore a obsoleted backupset. Any comments will be appreciated. Many many thanks! Joan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
any single serial session will never get more than 5% of pga_aggregate_target
Is there any way to give say 75% of pga_aggregate_target to a single session? The reason I am asking this is - sometimes we need to build an index as soon as possible and the index creating is the only thing running and other applications are stopped waiting for the index. Thanks, Roger -Original Message- Bobak, Mark Sent: Friday, December 26, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Jeffrey, If you are simply looking at a conversion from 8i to 9iR2, and you're not going to be implementing a bunch of new 9i features (that could affect PGA usage), then it's probably reasonably straightforward. You can look at 'session pga memory' and 'session pga memory max' statistics in V$SESSTAT to get an idea of current PGA memory consumption in 8i. The 'max' statistic is probably more interesting in terms of total aggregate memory consumption. Also, consider that any single serial session will never get more than 5% of pga_aggregate_target. For parallel operations, total is limited to 30%. So, if you have lots of sessions, each with modest requirements, that will not be a factor. If, on the other hand, your database supports just a few connections, and each has significant PGA memory requirements, then you may need to consider that limitation. Hope that helps, -Mark -Original Message- From: Jeffrey Beckstrom [mailto:[EMAIL PROTECTED] Sent: Fri 12/26/2003 2:34 PM To: Multiple recipients of list ORACLE-L Cc: Subject:pga_aggregate_target Starting an upgrade project for 8i to 9i R2. How can I come up with a reasonable starting value for the pga_aggregate_target parameter? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
undo and insert
An undo segment is used to save the old value of data. For insert operation, there is no old data to be saved. So, there should be no undo generated. Right? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
questions regarding nologging
Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: questions regarding nologging
So how do I turn logging to YES on the index? -Original Message- Sent: Wednesday, October 22, 2003 4:29 PM To: Multiple recipients of list ORACLE-L In addition to operations provided in Mladen's explanation, all partitioning operations such as exchange/split.. partition, etc. do not generate data related redo for segments marked nologging. HTH. Arup - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 4:54 PM That's because nologging attribute only affects the direct operations, i.e. the the operations that prebuild blocks and add them below the flood watermark. That includes sqlloader with direct=y, inserts with /*+ append */ hint and CTAS. Normal SQL based operations are not affected. On 10/22/2003 04:39:34 PM, Roger Xu wrote: Hi Gurus, I have a couple of questions regarding nologging. 1) alter table tabname move tablespace tbsname nologging; How come this sql still generated same amount of redo logs equal to the size of the table? 2) alter index idxname rebuild tablespace tbsname nologging; This sql only generate minimum redo logs. But the index ends up LOGGING=NO in dba_indexes view. How do I turn the logging on for this index? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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.net -- Author: Arup Nanda 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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
How do I match something like %abc
How come the following does not work select * from mytable where mycol like '\%%' Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 do I match something like %abc
thank a million to everyone replied this. -Original Message- Sent: Monday, October 20, 2003 4:45 PM To: Multiple recipients of list ORACLE-L select * from mytable where mycol like '\%%' escape '\' -Original Message- Roger Xu Sent: Monday, October 20, 2003 4:29 PM To: Multiple recipients of list ORACLE-L How come the following does not work select * from mytable where mycol like '\%%' Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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.net -- Author: Norris, Gregory T [ITS] 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: Oracle 9204 on Sun Solaris stable?
so far so good with 64-bit 9204 on Solaris9 -Original Message- Sent: Thursday, October 16, 2003 4:00 PM To: Multiple recipients of list ORACLE-L Hi, I installed Oracle 9201 on Sun Solaris9 and it has been giving me lots of trace files in udump directory. Checking with Metalink confirmed that it was due to a oracle bug. Metalink says the bug is fixed in 9203. Now I found the latest patchset is 9204 (out about one and half month ago). Has anyone applied that patchset on Sun OS and what is your experience of 9204? TIA. Guang -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
SGA PGA
I can use ipcs -am to see the sga at os level. but I do not see any pga? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: Archivelog - Disk space issue.
With RMAN, can I use 'copy archivelog all delete input' to copy each archive redo logfile to a single file? -Original Message- Sent: Wednesday, October 15, 2003 9:20 AM To: Multiple recipients of list ORACLE-L Your backup script should be deleting archive logs after they are backed up. With RMAN, you could do the following, just to backup and delete your archivelogs: run { allocate channel ch1 type disk format '/bkup4/oracle/%d/arc_s%s_p%p_%t'; set limit channel ch1 kbytes=100; # Limit sets to 1 Gb. backup archivelog all delete input; } If you're not using RMAN, delete the logs that have been backed up by your script. If you're not backing them up, you're going to have recovery issues. Jay [EMAIL PROTECTED] 10/15/03 09:44AM Hello Gurus, Have some disk space issues, so looking for ways to cleanup. Please confirm that my thinking is correct. I run the command and example output below:- SQL archive log list Database log mode Archive Mode Automatic archival Enabled Archive destinationC:\Oracle\oracle. Oldest online log sequence 2334 Next log sequence to archive 2338 Current log sequence 2338 I can write a script (Perl) to remove all archive files 2334? Much appreciate any input or confirmation. Regards Denham Eva Oracle DBA Linux like TeePee... No Windows, No Gates and Apache inside! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denham Eva 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) **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Hostetter 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
continuously copy archive redo logfiles to tape
Hello, How do I continuously copy archive redo logfiles to tape ? Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
Bad header found during backing up datafile
In our development box, when RMAN is running, I see the following messages only in the alert.log quite often. And it seems to me always happens in the index tablespace. I ran dbverify and validate structure of the whole database with no corruption reported. Any comments? *** Corrupt block relative dba: 0x13c2c44c (file 79, block 181324) Bad header found during backing up datafile Data in bad block - type: 48 format: 1 rdba: 0x3939390a last change scn: 0x3537.31333031 seq: 0x34 flg: 0x38 consistency value in tail: 0x791b0602 check value in block header: 0x3431, block checksum disabled spare1: 0x4, spare2: 0x31, spare3: 0x330 *** Reread of blocknum=181324, file=/oracle/DV2/sapdata3/btabi_15/btabi.data15. found valid data Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: NEXT_EXTENT and PCT_INCREASE
First of all, thank you all for replying. Jared is right, extent_id 0 is the first extent and it is 64M. And the tablespace is locally-managed and auto-allocate. The size of the table is 9652 MB. And it has 250 extents. extent_id size - - 0 64 MB 1-113 8 MB 114-24964 MB I just do not under stand the way Oracle allocate extents. Specially when the table was created with initial_extent=1700MB. Another question: Is it hurting performance with so many extents? -Original Message- Sent: Tuesday, August 26, 2003 9:09 PM To: Multiple recipients of list ORACLE-L Try executing SELECT EXTENT_MANAGEMENT, ALLOCATION_TYPE FROM DBA_TABLESPACES WHERE TABLESPACE_NAME = 'tablespace-name'... You should probably see the responses LOCAL and SYSTEM, indicating that the tablespace is locally-managed and auto-allocate... on 8/26/03 4:44 PM, Roger Xu at [EMAIL PROTECTED] wrote: Why the table was created with initial extent as 1700M, but dba_extents says the first extent is 8M only? SQL select initial_extent from dba_tables where table_name='BSIS'; 1782579200 SQL select bytes from dba_extents where segment_name='BSIS' and extent_id=1; 8388608 SQL select bytes,count(*) from dba_extents where segment_name='BSIS' group by bytes; 8388608113 67108864137 -Original Message- Sent: Tuesday, August 26, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Roger, 1. Space management can be specified for a tablespace, not a segment. Create ASSM tablespace and alter table ... move there. 2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and PCT_INCREASE then. HTH Vadim -Original Message- Sent: Tuesday, August 26, 2003 3:59 PM To: Multiple recipients of list ORACLE-L Hi, I have the following output when I querying dba_tables. Question 1: This table is created using manual management method, right? What do I do in order to turn it to Automatic segment-space management? Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE? Thanks, Roger Xu PCT_FREE PCT_USED INI_TRANS MAX_TRANS -- -- -- -- 10 40 1255 INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE -- --- --- --- 527491072 1 2147483645 FREELISTS FREELIST_GROUPS -- --- 1 1 LOGGING BACKED_UP NUM_ROWS --- - -- YES N 216122635 BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT -- -- -- 7651115 4307319 0 AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS --- - --- 254 4496 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: perl/shell script for alert log
When I grep something from the alert log, it never tell me the date and time of the error. Is there a setting for appending a timestamp on each error? -Original Message- Sent: Wednesday, August 27, 2003 1:35 PM To: Multiple recipients of list ORACLE-L HTH #!/bin/sh # This Script search for Oracle error messages in last 100 lines in the alert log file , # keep log to a file. # You should pass name of ORACLE_SID as a parameter. #!/usr/bin/sh # # Comments: Script checks last 100 lines of # the alert log for specific # Oracle errors, e-mails depending on the error. # Parameter: ORACLE_SID # --- # # DIR=/u01/app/oracle/admin ORACLE_SID=$1 export ORACLE_SID ORACLE_HOME=/u01/app/oracle/product/8.1.7 export ORACLE_HOME ALERT_DEST=/u01/app/oracle/admin/${ORACLE_SID}/bdump LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export LD_LIBRARY_PATH PATH=$PATH:$ORACLE_HOME/bin export PATH COLLECTOR=`tail -100 $ALERT_DEST/alert_${ORACLE_SID}.log |grep ORA-` if [ $COLLECTOR ] then echo echo Errors found in: $ALERT_DEST/alert_${ORACLE_SID}.log echo echo $COLLECTOR echo fi; --- AK [EMAIL PROTECTED] wrote: I am sure you guys might have some nice perl/shell script to analyze alert log for errors or potential problem . Can you share it with me /list . Ohh thanks in advance guys . -ak __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
NEXT_EXTENT and PCT_INCREASE
Hi, I have the following output when I querying dba_tables. Question 1: This table is created using manual management method, right? What do I do in order to turn it to Automatic segment-space management? Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE? Thanks, Roger Xu PCT_FREE PCT_USED INI_TRANS MAX_TRANS -- -- -- -- 10 40 1255 INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE -- --- --- --- 527491072 1 2147483645 FREELISTS FREELIST_GROUPS -- --- 1 1 LOGGING BACKED_UP NUM_ROWS --- - -- YES N 216122635 BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT -- -- -- 7651115 4307319 0 AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS --- - --- 254 4496 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: NEXT_EXTENT and PCT_INCREASE
Why the table was created with initial extent as 1700M, but dba_extents says the first extent is 8M only? SQL select initial_extent from dba_tables where table_name='BSIS'; 1782579200 SQL select bytes from dba_extents where segment_name='BSIS' and extent_id=1; 8388608 SQL select bytes,count(*) from dba_extents where segment_name='BSIS' group by bytes; 8388608113 67108864137 -Original Message- Sent: Tuesday, August 26, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Roger, 1. Space management can be specified for a tablespace, not a segment. Create ASSM tablespace and alter table ... move there. 2. Locally managed tablespace, I guess. Oracle doesn't need NEXT_EXTENT and PCT_INCREASE then. HTH Vadim -Original Message- Sent: Tuesday, August 26, 2003 3:59 PM To: Multiple recipients of list ORACLE-L Hi, I have the following output when I querying dba_tables. Question 1: This table is created using manual management method, right? What do I do in order to turn it to Automatic segment-space management? Question 2: How come there are no values for NEXT_EXTENT and PCT_INCREASE? Thanks, Roger Xu PCT_FREE PCT_USED INI_TRANS MAX_TRANS -- -- -- -- 10 40 1255 INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE -- --- --- --- 527491072 1 2147483645 FREELISTS FREELIST_GROUPS -- --- 1 1 LOGGING BACKED_UP NUM_ROWS --- - -- YES N 216122635 BLOCKS EMPTY_BLOCKS AVG_SPACE CHAIN_CNT -- -- -- 7651115 4307319 0 AVG_ROW_LEN AVG_SPACE_FREELIST_BLOCKS NUM_FREELIST_BLOCKS --- - --- 254 4496 2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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.net -- Author: Gorbounov,Vadim 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: stripe size
We are running Solaris with Veritas Volume Manager (not vxfs, but ufs) 8k block size. For better performance, how bigthe stripe size should be? 8k? -Original Message-From: Matthew Zito [mailto:[EMAIL PROTECTED]Sent: Monday, August 18, 2003 11:19 PMTo: Multiple recipients of list ORACLE-LSubject: Re: stripe size As long as you're using software RAID and not hardware, you can use vxprint to give you that information. I believe a functional syntax that includes the stripe size is vxprint -hrt -g (diskgroup) . If you're using hardware RAID, you're going to need whatever array management tools your vendor cheerfully provided you. Hope this helps, Matt - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Monday, August 18, 2003 11:29 PM Subject: stripe size Is there any command on hp-ux which can tell me on what disks particular file is striped on and stripe size . Hp-ux ( 11 ) Thanks, akFor technical support please email [EMAIL PROTECTED] or you cancall (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System.
RE: ORA-1652: unable to extend temp segment by 8091 in tablespace
Thanks all. The replies have been really helpful. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 6:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1652: unable to extend temp segment by 8091 in tablespaceRaju is right, it's late on a Friday, I had a brain fart. This will tell you if you have other objects in your system tablespace.select owner, 'TABLE' object_type, table_name from dba_tables where owner not in ('SYS','MDSYS','OUTLN','WMSYS','SYSTEM','ORDSYS') and tablespace_name = 'SYSTEM' union select owner, 'INDEX' object_type, index_name from dba_indexes where owner not in ('SYS','MDSYS','OUTLN','WMSYS','SYSTEM','ORDSYS') and tablespace_name = 'SYSTEM'; If you find other owners objects in SYSTEM, particularly SAPR3 objects, they should be moved to the proper tablespace. HTH jared raju pa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2003 04:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEMEven if the default tablespace for user is other than 'SYSTEM' question is : Where does the data from anlyze go? To some catalog table? What you can do is : 1) Check if 'SYSTEM' has any other user non-system/sys user objects. Move them away. I do not know if moving system objects out of 'system' tablespace is advisable. Maybe not. 2) Check and add space for 'SYSTEM' tablespace to be safe.Roger Xu [EMAIL PROTECTED] wrote: USERNAME DEFAULT_TABLESP TEMPORARY_TABLE--- --- ---SAPR3 PSAPUSER1D PSAPTEMPOPS$ORAQA2 SYSTEM PSAPTEMPOPS$QA2ADM SYSTEM PSAPTEMP -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 4:28 PMTo: [EMAIL PROTECTED]Cc: Roger XuSubject: Re: ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEMImportance: HighWhat does this query return? select username, default_tablespace, temporary_tablespace from dba_users where username like 'OPS$%' or username = 'SAPR3' Jared "Roger Xu" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2003 12:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEMHello,While user OPS$ORAQA2 running:ANALYZE TABLE "SAPR3"."BSIS" COMPUTE STATISTICS FOR TABLE FOR ALL INDEXED COLUMNS SIZE 1 FOR ALL INDEXESI had the following error:SQL error -1652 at location stats_tab_collect-4ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEMA default temporary tablespace w! as assigned to the user OPS$ORAQA2.Thanks,Roger XuDatabase AdministratorDr Pepper Bottling Company of Texas(972)721-8337-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Roger XuINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).For technical support please email [EMAIL PROTECTED] or you cancall (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month! For technical support please email [EMAIL PROTECTED] or you cancall (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System.
ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM
Hello, While user OPS$ORAQA2 running: ANALYZE TABLE SAPR3.BSIS COMPUTE STATISTICS FOR TABLE FOR ALL INDEXED COLUMNS SIZE 1 FOR ALL INDEXES I had the following error: SQL error -1652 at location stats_tab_collect-4 ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM A default temporary tablespace was assigned to the user OPS$ORAQA2. Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEM
USERNAME DEFAULT_TABLESP TEMPORARY_TABLE--- --- ---SAPR3 PSAPUSER1D PSAPTEMPOPS$ORAQA2 SYSTEM PSAPTEMPOPS$QA2ADM SYSTEM PSAPTEMP -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 15, 2003 4:28 PMTo: [EMAIL PROTECTED]Cc: Roger XuSubject: Re: ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEMImportance: HighWhat does this query return? select username, default_tablespace, temporary_tablespace from dba_users where username like 'OPS$%' or username = 'SAPR3' Jared "Roger Xu" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/15/2003 12:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEMHello,While user OPS$ORAQA2 running:ANALYZE TABLE "SAPR3"."BSIS" COMPUTE STATISTICS FOR TABLE FOR ALL INDEXED COLUMNS SIZE 1 FOR ALL INDEXESI had the following error:SQL error -1652 at location stats_tab_collect-4ORA-1652: unable to extend temp segment by 8091 in tablespace SYSTEMA default temporary tablespace was assigned to the user OPS$ORAQA2.Thanks,Roger XuDatabase AdministratorDr Pepper Bottling Company of Texas(972)721-8337-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Roger XuINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).For technical support please email [EMAIL PROTECTED] or you cancall (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System.
How do I find out the size of a index
Hi, I can use select blocks*8 from dba_tables where table_name='ABC' to find out the size of a table. How do I find out the size of a index? I do not see a column BLOCK in dba_indexes. Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: 9i - Dynamic SGA - SGA_MAX_SIZE
ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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.net -- Author: Jessica Mao 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). For technical support please email [EMAIL PROTECTED] or you can call (972)721-8257. This email has been scanned for all viruses by the MessageLabs Email Security System. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: maxsize
What is the answer? -Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 22, 2003 5:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: maxsize never mind got the answer. - Original Message - From: AK To: [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 2:26 PM Subject: maxsize is it possible to change maxsize of autoextend datafile ? how ?This email has been scanned for all viruses by the MessageLabs EmailSecurity System. For more information on a proactive email securityservice working around the clock, around the globe, visithttp://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com
RE: maxsize
-Original Message-From: AK [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 22, 2003 5:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: maxsize never mind got the answer. - Original Message - From: AK To: [EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 2:26 PM Subject: maxsize is it possible to change maxsize of autoextend datafile ? how ?This email has been scanned for all viruses by the MessageLabs EmailSecurity System. For more information on a proactive email securityservice working around the clock, around the globe, visithttp://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com
Solaris/Veritas filesystem for Oracle
Hi, After I moved all my Oracle tablespace datafiles to ufs filesystems in Veritas Volume, the database performance suffers a whole lot. I think the problem is in the way I create the volume or the way I create the filesystem. vxassist -g lst1dg make odata1 55000m layout=stripe nstripe=3 newfs -i 2 -m 1 -b 8192 -f 8192 /dev/vx/rdsk/lst1dg/odata1 Anybody has any insights? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: Solaris/Veritas filesystem for Oracle
the following 6 volumes have all my datafiles, [lostdog]root:/tmpdf -k | grep sapdata | sort /dev/vx/dsk/lst1dg/odsd1 15260136 14811592 29594499%/oracle/DV2/sapdata1 /dev/vx/dsk/lst1dg/odsd2 86474632 80075904 553398494%/oracle/DV2/sapdata2 /dev/vx/dsk/lst1dg/odsd3 55954312 53925072 146970498%/oracle/DV2/sapdata3 /dev/vx/dsk/lst1dg/odsd4 14242376 13831056 26890499%/oracle/DV2/sapdata4 /dev/vx/dsk/lst1dg/odsd5 15260136 14271616 83592095%/oracle/DV2/sapdata5 /dev/vx/dsk/lst1dg/odsd6 17294408 16187536 93392895%/oracle/DV2/sapdata6 Thanks, Roger -Original Message- Sent: Monday, July 21, 2003 12:29 PM To: Multiple recipients of list ORACLE-L Hrrrmmhard to say from just that. Would you be comfortable sending a vxprint -g lst1dg -hrt so we can see how the volumes got created? Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Xu Sent: Monday, July 21, 2003 12:04 PM To: Multiple recipients of list ORACLE-L Subject: Solaris/Veritas filesystem for Oracle Hi, After I moved all my Oracle tablespace datafiles to ufs filesystems in Veritas Volume, the database performance suffers a whole lot. I think the problem is in the way I create the volume or the way I create the filesystem. vxassist -g lst1dg make odata1 55000m layout=stripe nstripe=3 newfs -i 2 -m 1 -b 8192 -f 8192 /dev/vx/rdsk/lst1dg/odata1 Anybody has any insights? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 __ __ This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com __ __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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.net -- Author: Matthew Zito 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). This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com encoded content removed -- binaries not allowed by ListGuru
OPatch -- Can not set up OUI inventory session ???
Hi, Anyone has experience with OPatch tool? While applying a patch using OPatch, I have error saying Can not set up OUI inventory session. Any idea? Thanks. lostdog:oradv2 5% opatch apply PERL5LIB=/oracle/DV2/920_64/Apache/perl/lib/5.00503; export PERL5LIB /oracle/DV2/920_64/Apache/perl/bin/perl /oracle/DV2/920_64/OPatch/opatch.pl apply OPatch Version 1.0.0.0.39 Perl Version 5.00503 Performing pre-patch installation checks. general_options is set to 0 Using oraInst.loc to look up oui libs... Parsing /oracle/ContentsXML/comps.xml Found oracle.swd.oui version 2.2.0.12.0 on /oracle/DV2/920_64/oracle.swd.oui Found JRE version 1.3.1.0.0a on /oracle/DV2/920_64/oracle.swd.jre/bin/java Oracle Home = /oracle/DV2/920_64 inventory_location = /oracle liboraInstaller_lib= /oracle/DV2/920_64/oracle.swd.oui/bin/solaris/libor aInstaller.so path_to_java = /oracle/DV2/920_64/oracle.swd.jre/bin/java path_to_oI_loc = /var/opt/oracle/oraInst.loc oui_component_loc = /oracle/DV2/920_64/oracle.swd.oui required_jar_file under oui = lib/OraInstaller.jar Checking if this is a RAC system... /oracle/DV2/920_64/OPatch/opatch.pl version: 1.0.0.0.39 Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved. Can not set up OUI inventory session OPatch stops because of Inventory problem. lostdog:oradv2 6% exit Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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 do I find out the SQL statements for a session
Hi, From V$SESSION, I can find out all the sessions for a user. How do I find out the current SQL and previous SQL for that session? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
WHY IT DOES NOT WORK == rman target / as sysdba THANKS
bigtex:oraadm 7% rman target / as sysdba Argument Value Description - target quoted-string connect-string for target database catalog quoted-string connect-string for recovery catalog nocatalognone if specified, then no recovery catalog cmdfile quoted-string name of input command file log quoted-string name of output message log file tracequoted-string name of output debugging message log file append none if specified, log is opened in append mode debugoptional-args activate debugging msgnonone show RMAN- prefix for all messages send quoted-string send a command to the media manager pipe string building block for pipe names timeout integernumber of seconds to wait for pipe input - Both single and double quotes (' or ) are accepted for a quoted-string. Quotes are not required unless the string contains embedded white-space. RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-00552: syntax error in command line arguments RMAN-01005: syntax error: found identifier: expecting one of: append, at, auxiliary, catalog, cmd file, clone, debug, log, msglog, mask, msgno, nocatalog, pipe, rcvcat, slaxdebug, send, target, time out, trace RMAN-01008: the bad identifier was: as RMAN-01007: at line 0 column 4 file: command line arguments bigtex:oraadm 8% rman target system/manager Recovery Manager: Release 9.2.0.3.0 - 64bit Production Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved. connected to target database: DV2 (DBID=3650624848) RMAN exit Recovery Manager complete. bigtex:oraadm 9% sqlplus / as sysdba SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production SQL show user USER is SYS SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.3.0 - Production bigtex:oraadm 10% Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).
sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session?
Hi, How do I retrieve the last commands I ran in a sqlplus session? I remembe in the training class, I were able to use arrow keys in Windows platform. But in Solaris 9/UNIX platform, it does NOT work. Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: sqlplus newbie: How do I retrieve the last command I ran in a
Title: RE: sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session? How about a history of commands? Thanks. -Original Message-From: Stefick Ronald S Civ ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Friday, June 27, 2003 5:10 PMTo: Multiple recipients of list ORACLE-LSubject: RE: sqlplus newbie: How do I retrieve the last command I ran in a You can either use the "/" key to re-run the last command, or you can type "ed" and enter to edit the last command. Then when you are finished editing, save the changes, and when you return to the SQL command prompt, just hit the "/" key again. -Scott Stefick -----Original Message- From: Roger Xu [mailto:[EMAIL PROTECTED]] Sent: Friday, June 27, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: sqlplus newbie: How do I retrieve the last command I ran in a sqlplus session? Hi, How do I retrieve the last commands I ran in a sqlplus session? I remembe in the training class, I were able to use arrow keys in Windows platform. But in Solaris 9/UNIX platform, it does NOT work. Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).This email has been scanned for all viruses by the MessageLabs EmailSecurity System. For more information on a proactive email securityservice working around the clock, around the globe, visithttp://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com
backup strategy for a database over 1 TB running SAP R/3
Hi, What is the backup strategy for a database over 1 TB running SAP R/3 on Solaris? We are using Legato products and they have NetWorker Module for Oracle and NetWorker Module for SAP on Oracle. Which one is better? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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: backup strategy for a database over 1 TB running SAP R/3
Yes. In fact, I am trying to decide using RMAN or SAP BR-tools. -Original Message- Sent: Tuesday, April 01, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Roger We don't run SAP, but are you considering using RMAN as a part of your plans? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 01, 2003 1:39 PM To: Multiple recipients of list ORACLE-L Hi, What is the backup strategy for a database over 1 TB running SAP R/3 on Solaris? We are using Legato products and they have NetWorker Module for Oracle and NetWorker Module for SAP on Oracle. Which one is better? Thanks, Roger Xu Database Administrator Dr Pepper Bottling Company of Texas (972)721-8337 This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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.net -- Author: DENNIS WILLIAMS 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). This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com This email has been scanned for all viruses by the MessageLabs SkyScan service. For more information on a proactive anti-virus service working around the clock, around the globe, visit http://www.messagelabs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Roger Xu 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).