Threat to Fast exports
Please have a look at following note: 223399.1 having title ALERT: EXPORT with large BUFFER can silently produce a dump file with corrupted data. Looks like all major versions on all platforms are affected. Really scary one.. Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rajesh Dayal 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: [Q]terminating instance due to error 601
Dennis,Tim - here are the trace files. Hmmm, the problem seems to be ORA-27303 //*Cause: OS system call error // *Action: contact Oracle Support :-O Thanks ! Regards, Teenu _pmon_1222.trc__ *** SESSION ID:(1.1) 2003-03-02 22:37:41.250 *** 2003-03-02 22:37:41.360 Load Indicator not supported by OS ! *** 2003-03-03 03:15:53.581 error 601 detected in background process __ora_3274.trc__ Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production ORACLE_HOME = /aux/oracle System name:Linux Node name: j21 Release:2.5.6 Version:#1 Tue Feb 25 18:55:04 IST 2003 Machine:i686 Instance name: tj1 Redo thread mounted by this instance: 1 Oracle process number: 0 3274 OPIRIP: Uncaught error -1. Error stack: ORA--0001: Message -1 not found; product=RDBMS; facility=ORA ORA-27302: failure occurred at: skgpwinit4 ORA-27303: additional information: attach to invalid skgp shared ctx _ On Sun, 2 Mar 2003, DENNIS WILLIAMS wrote: > Teenu > > Here is the text from oerr. > > 00601, 0, "cleanup lock conflict" > // *Cause: PMON process runs into lock conflict trying to recovery > processes > // *Action: This is trapped internally, no action necessary > > Was a trace file produced in bdump or udump? > > Dennis Williams > DBA, 40%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Sunday, March 02, 2003 4:04 PM > To: Multiple recipients of list ORACLE-L > > > Hi folks , > whats the meaning of error 601. The Database crashed with the following > message in alert log --> > > Mon Mar 3 03:15:53 2003 > PMON: terminating instance due to error 601 > Instance terminated by PMON, pid = 1222 > > Platform Details--> > OS -> RH 7.1 > Oracle -> 8.1.6 > > TIA > > Tc > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Teenu 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: multiple oracle homes
Alex, Thanks for that idea :) - Kirti -Original Message- Sent: Sunday, March 02, 2003 8:04 PM To: Multiple recipients of list ORACLE-L Kirti, The next enhancement would be to execute script (from .profile) which will generate all aliases based on oratab. I use something like alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT' and /usr/local/bin/oracle_setup.ksh will source oraenv and do some additional customization. Alex. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 7:14 PM Better yet, have one single generic .profile with aliases defined for each instance running on the server. Want to change env for another instance? Just type it's name. It is that simple. We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w. The .profile file sources the alias' file as .local.aliases. This file has entries as below: #Add Database name here using the following format alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK="NO";. oraenv;' alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK="NO";. oraenv;' alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/VP1D;' alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK="NO";. oraenv;' alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK="NO";. oraenv;' alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK="NO";. oraenv;' alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK="NO";. oraenv;' alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK="NO";. oraenv;' alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK="NO";. oraenv;' PRMT --> IWVT are the instances running on the server. And finally, do change the UNIX prompt to include current ORACLE_SID, among other things !! HTH, - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein 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: Deshpande, Kirti 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: What to check?
David, Have you checked the most obvious... The number of rows in the table? Also, you say "three different Solaris8 machines"... How "different" are they? Are the disk subsystems the same on all three? How identical are their configurations? How similar are the init.ora files on all three machines (perhaps sort_area_size or something similar depending on the query to dump the table)? Unfortunately there's a lot of possibilities about what might cause the slow down. The other suggestions of wait events and execution plans are valid ideas. Hopefully one of these will give a hint about where to look for the cause. Regards, Mark. "Nguyen, David M" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: What to check? Sent by: [EMAIL PROTECTED] om 01/03/2003 08:09 Please respond to ORACLE-L Someone writes a SQL script to dump a table on three different database on three different Solaris8 machines, he complaines one of machines took 6 hours to dump a table while other two's only take one hour. He asks me to investigate why. I log into the machine in question to check I/O statistic, memory, CPU usage and found no problem. What else should I check here? Regards, David <<>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. <<<> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard 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 Mag Bio
Thanks for the compliments, Jared. Much appreciated. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 8:23 PM > > Congrats to Arup Nanda, whose bio appears > in the latest issue of Oracle Mag. > > Jared > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Jared Still > 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).
Re: multiple oracle homes
Kirti, The next enhancement would be to execute script (from .profile) which will generate all aliases based on oratab. I use something like alias PRMT='. /usr/local/bin/oracle_setup.ksh PRMT' and /usr/local/bin/oracle_setup.ksh will source oraenv and do some additional customization. Alex. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 28, 2003 7:14 PM Better yet, have one single generic .profile with aliases defined for each instance running on the server. Want to change env for another instance? Just type it's name. It is that simple. We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w. The .profile file sources the alias' file as .local.aliases. This file has entries as below: #Add Database name here using the following format alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK="NO";. oraenv;' alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK="NO";. oraenv;' alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/VP1D;' alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK="NO";. oraenv;' alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK="NO";. oraenv;' alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK="NO";. oraenv;' alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK="NO";. oraenv;' alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK="NO";. oraenv;' alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK="NO";. oraenv;' PRMT --> IWVT are the instances running on the server. And finally, do change the UNIX prompt to include current ORACLE_SID, among other things !! HTH, - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Alex Feinstein 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).
Oracle Mag Bio
Congrats to Arup Nanda, whose bio appears in the latest issue of Oracle Mag. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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: [Q]terminating instance due to error 601
Teenu Here is the text from oerr. 00601, 0, "cleanup lock conflict" // *Cause: PMON process runs into lock conflict trying to recovery processes // *Action: This is trapped internally, no action necessary Was a trace file produced in bdump or udump? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, March 02, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Hi folks , whats the meaning of error 601. The Database crashed with the following message in alert log --> Mon Mar 3 03:15:53 2003 PMON: terminating instance due to error 601 Instance terminated by PMON, pid = 1222 Platform Details--> OS -> RH 7.1 Oracle -> 8.1.6 TIA Tc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Teenu 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).
Re: [Q]terminating instance due to error 601
...take a look at the latest "pmon_*.trc" file in the BACKGROUND_DUMP_DEST... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 3:03 PM > Hi folks , > whats the meaning of error 601. The Database crashed with the following > message in alert log --> > > Mon Mar 3 03:15:53 2003 > PMON: terminating instance due to error 601 > Instance terminated by PMON, pid = 1222 > > Platform Details--> > OS -> RH 7.1 > Oracle -> 8.1.6 > > TIA > > Tc > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Teenu > 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: 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).
[Q]terminating instance due to error 601
Hi folks , whats the meaning of error 601. The Database crashed with the following message in alert log --> Mon Mar 3 03:15:53 2003 PMON: terminating instance due to error 601 Instance terminated by PMON, pid = 1222 Platform Details--> OS -> RH 7.1 Oracle -> 8.1.6 TIA Tc -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Teenu 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: V$ARCHIVED_LOG question
The ACTIVATION# and ARCHIVAL_THREAD# columns are apparently used by Data Guard "fetch archive log" (FAL) processes to manage any logfile transfer gaps using the FAL_CLIENT and FAL_SERVER parameters on the primary and standby databases. Metalink note #150214.1 ("Synchronization of primary and standby database due to log transfer gap") mentions the values in these columns, though not the column names themselves. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 9:48 AM > Murali, > > I can offer some insight into the activation# column because I was > interested in that too earlier. When a database starts, a new "database > instantiation id" is given to that instance, presumably for the RMAN > backups. This id can be seen from v$database under column activation#. So > when you create another incarnation of the database using RMAN cloning, the > archived logs are either used or not depending on the value of this > activation# associated with them. > > Hope someone else can shed some light into the other columns - particularly > archival_thread# and why it's different from the thread#. > > Arup Nanda > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, March 02, 2003 9:58 AM > > > > Oracle 9i has quite a few new columns added to the V$ARCHIVED_LOG > dictionary > > view,however there is no documentation. > > > > For example, END_OF_REDO, ARCHIVAL_THREAD#,ACTIVATION# > > > > Any clues on what these columns mean. > > > > Thanks > > > > Murali > > > >DEST_IDTHREAD# SEQUENCE# END BACKUP_COUNT ARCHIVAL_THREAD# > > ACTIVATION# > > -- -- -- --- > > --- > > 1 2 48 NO 12 > > 3612293975 > > 1 1116 NO 11 > > 3612293975 > > 1 2 49 NO 12 > > 3612293975 > > 1 1117 NO 01 > > 3612293975 > > 1 2 50 NO 02 > > 3612293975 > > 1 1118 NO 02 > > 3612293975 > > 1 2 51 NO 02 > > 3612293975 > > 1 1119 NO 02 > > 3612293975 > > 1 2 52 NO 02 > > 3612293975 > > > > > > > > > > Murali Vallath > > > > > > > > > > > > > > _ > > Add photos to your messages with MSN 8. Get 2 months FREE*. > > http://join.msn.com/?page=features/featuredemail > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Murali Vallath > > 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). > -- 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).
RE: Datafile Resize Question
Thanks John. Actually it turns out there are a couple of small tables left in the tablespace that I missed in my query. After moving those outta there, I was able to shrink. Thanks Dennis -Original Message- Sent: Sunday, March 02, 2003 1:49 PM To: Multiple recipients of list ORACLE-L Apologies - when I use MS Web Outlook, I can't change the mail format from rich text to plan text, so it attaches the winmail.dat garbage. Are your tablespaces, by any chance, locally managed with a large uniform extent size? I don't believe you can shrink the size of a datafile smaller than the uniform extent size of the tablespace when it's locally managed. If the size of your files, after moving all segments elsewhere, is about equal to the uniform extent size of the tablespace, this could be your answer. -Original Message- Dennis Sent: Sunday, March 02, 2003 1:44 PM To: Multiple recipients of list ORACLE-L John - Your E-mail came to me as unreadable. If you have an answer to this, can you send plain text ? Thanks! Dennis -Original Message- Sent: Sunday, March 02, 2003 11:59 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis 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: John Clarke 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: Meng, Dennis 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: Datafile Resize Question
Apologies - when I use MS Web Outlook, I can't change the mail format from rich text to plan text, so it attaches the winmail.dat garbage. Are your tablespaces, by any chance, locally managed with a large uniform extent size? I don't believe you can shrink the size of a datafile smaller than the uniform extent size of the tablespace when it's locally managed. If the size of your files, after moving all segments elsewhere, is about equal to the uniform extent size of the tablespace, this could be your answer. -Original Message- Dennis Sent: Sunday, March 02, 2003 1:44 PM To: Multiple recipients of list ORACLE-L John - Your E-mail came to me as unreadable. If you have an answer to this, can you send plain text ? Thanks! Dennis -Original Message- Sent: Sunday, March 02, 2003 11:59 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis 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: John Clarke 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: Datafile Resize Question
John - Your E-mail came to me as unreadable. If you have an answer to this, can you send plain text ? Thanks! Dennis -Original Message- Sent: Sunday, March 02, 2003 11:59 AM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Meng, Dennis 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: Datafile Resize Question
The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. <>
Datafile Resize Question
Hi all - I am trying to resize a datafile and have the following puzzler - I used the following query to get the list of tables that use this datafile and then use 'alter table ... move tablespace ' to move the tables to another tablespace. Now the datafile should be empty as indicated by the query and OEM. But I looked at the file and the high water mark for the file is still pretty high ( it is lower than before though) and I can't resize it to the size I wanted. My questions is - since I moved EVERYTHIG from the datafile, what could be in it that is holding me back? select distinct a.object_name, a.object_type, a.table_space, a.ts_size from reorg_table_map a, dba_extents b where upper(rtrim(a.object_name)) = upper(b.segment_name ) and b.file_id = 111 TIA Dennis 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: Meng, Dennis 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: DeadLock: session wait on itself with no rows.
chao_ping, Read MetaLink Doc Id 166924.1. It offer some insights into this kind of "Self Deadlocks". Here is an excerpt. 1. Self Deadlocks It occur when one session tries to get a lock on a resource that he already has in some way. Normally, the Oracle engine should detect those situations and should avoid the signalling of the ORA-04020 to the end-users. When a self deadlock detection occurs, Oracle generates a trace file in the user_dump_dest. It is only considered as a bug if an ORA-04020 is signalled to the end-user. HTH. Arup - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 8:13 AM > hi, friends: > > >>>select count(*) into :b0 from USERCONFIRMINFO where USER_ID=:b1 > >>>The following deadlock is not an ORACLE error. It is a > >>>deadlock due to user error in the design of an application > >>>or from issuing incorrect ad-hoc SQL. The following > >>>information may aid in determining the deadlock: > >>> > >>>Deadlock graph: > >>>-Blocker(s) -Waiter(s)- > >>>Resource Name process session holds waits process session holds waits > >>>TX-000e005d-00037cfa 306 484 X 306 484 S > >>>session 484: DID 0001-0165-00010802 session 484: DID 0001-0165-00010802 > >>>Rows waited on: > >>>Session 484: no row > > Another trace file like: > >>>*** 2003-03-02 16:50:22.447 > >>>DEADLOCK DETECTED > >>>Current SQL statement for this session: > >>>select USER_ID ,USER_EMAIL into :b0,:b1 from USERPRIVATEINFO where USER_ACCOUNT=:b2 > >>>The following deadlock is not an ORACLE error. It is a > >>>deadlock due to user error in the design of an application > >>>or from issuing incorrect ad-hoc SQL. The following > >>>information may aid in determining the deadlock: > >>>Deadlock graph: > >> -Blocker(s) -Waiter(s) - > >>>Resource Name process session holds waits process session holds waits > >>>TX-0012004a-000374f8 293 263 X306 512 S > >>>session 263: DID 0001-0165-0004EC65 session 512: DID 0001-0165-0004EC65 > >>>Rows waited on: > >>>Session 512: no row > > > > I ever saw message talking about two session deadlock with no rows waited on, maybe it is because of pctfree/initrans, How about session wait on itself then? And how can it happen? > > > > Regards > zhu chao > msn:[EMAIL PROTECTED] > www.happyit.net > www.cnoug.org(China Oracle User Group) > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: chao_ping > 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).
Re: V$ARCHIVED_LOG question
Murali, I can offer some insight into the activation# column because I was interested in that too earlier. When a database starts, a new "database instantiation id" is given to that instance, presumably for the RMAN backups. This id can be seen from v$database under column activation#. So when you create another incarnation of the database using RMAN cloning, the archived logs are either used or not depending on the value of this activation# associated with them. Hope someone else can shed some light into the other columns - particularly archival_thread# and why it's different from the thread#. Arup Nanda - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Sunday, March 02, 2003 9:58 AM > Oracle 9i has quite a few new columns added to the V$ARCHIVED_LOG dictionary > view,however there is no documentation. > > For example, END_OF_REDO, ARCHIVAL_THREAD#,ACTIVATION# > > Any clues on what these columns mean. > > Thanks > > Murali > >DEST_IDTHREAD# SEQUENCE# END BACKUP_COUNT ARCHIVAL_THREAD# > ACTIVATION# > -- -- -- --- > --- > 1 2 48 NO 12 > 3612293975 > 1 1116 NO 11 > 3612293975 > 1 2 49 NO 12 > 3612293975 > 1 1117 NO 01 > 3612293975 > 1 2 50 NO 02 > 3612293975 > 1 1118 NO 02 > 3612293975 > 1 2 51 NO 02 > 3612293975 > 1 1119 NO 02 > 3612293975 > 1 2 52 NO 02 > 3612293975 > > > > > Murali Vallath > > > > > > > _ > Add photos to your messages with MSN 8. Get 2 months FREE*. > http://join.msn.com/?page=features/featuredemail > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Murali Vallath > 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).
V$ARCHIVED_LOG question
Oracle 9i has quite a few new columns added to the V$ARCHIVED_LOG dictionary view,however there is no documentation. For example, END_OF_REDO, ARCHIVAL_THREAD#,ACTIVATION# Any clues on what these columns mean. Thanks Murali DEST_IDTHREAD# SEQUENCE# END BACKUP_COUNT ARCHIVAL_THREAD# ACTIVATION# -- -- -- --- --- 1 2 48 NO 12 3612293975 1 1116 NO 11 3612293975 1 2 49 NO 12 3612293975 1 1117 NO 01 3612293975 1 2 50 NO 02 3612293975 1 1118 NO 02 3612293975 1 2 51 NO 02 3612293975 1 1119 NO 02 3612293975 1 2 52 NO 02 3612293975 Murali Vallath _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Murali Vallath 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: multiple oracle homes
We do something similar to this, we created a series of scripts that use the oratab file to create a menu for the oracle id. this same proc is called when running batch jobs against the DB's by sending the DB name as a parm. -Original Message- Kirti Sent: Friday, February 28, 2003 10:15 PM To: Multiple recipients of list ORACLE-L Better yet, have one single generic .profile with aliases defined for each instance running on the server. Want to change env for another instance? Just type it's name. It is that simple. We do this on all our servers, some with 20+ instances running under 7.3.4, 8.0.x, 8.1.x and 9.2.x. We use only one id for all versions of Oracle s/w. The .profile file sources the alias' file as .local.aliases. This file has entries as below: #Add Database name here using the following format alias PRMT='export ORACLE_SID=PRMT; export ORAENV_ASK="NO";. oraenv;' alias PRMX='export ORACLE_SID=PRMX; export ORAENV_ASK="NO";. oraenv;' alias VP1D='export ORACLE_SID=VP1D; export ORAENV_ASK="NO";. oraenv; cd /u01/home/oracle/admin/VP1D;' alias SDSD='export ORACLE_SID=SDSD; export ORAENV_ASK="NO";. oraenv;' alias SDST='export ORACLE_SID=SDST; export ORAENV_ASK="NO";. oraenv;' alias SVRP='export ORACLE_SID=SVRP; export ORAENV_ASK="NO";. oraenv;' alias SVRT='export ORACLE_SID=SVRT; export ORAENV_ASK="NO";. oraenv;' alias IDSU='export ORACLE_SID=IDSU; export ORAENV_ASK="NO";. oraenv;' alias IWVT='export ORACLE_SID=IWVT; export ORAENV_ASK="NO";. oraenv;' PRMT --> IWVT are the instances running on the server. And finally, do change the UNIX prompt to include current ORACLE_SID, among other things !! HTH, - Kirti -Original Message- Sent: Friday, February 28, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Using something other than oracle makes it more complicated - I think. Have a different .profile - can name it something that makes sense. -Original Message- Sent: Friday, February 07, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had a bad experience :-) Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 07, 2003 8:24 AM To: Multiple recipients of list ORACLE-L On Thu, Feb 06, 2003 at 05:08:55AM -0800, Ray Stell wrote: > > Where is it well documented how to install multiple server versions, > 8i and 9i, on the same unix server? -- Thanks for you replies. I've never tried this before and it seems like there are two different approaches on the surface: 1. use two different userids, ora817 and ora920, to do the install. This seems stupid, since it replicates the product directory structure and oraInventory stuff under different ownership. This might be safer since it is like running one version in that everything is seperate, but maybe there are operational issues to not using the oracle userid. Seems like there may be a gotcha waiting in the wings. Like maybe you can't run the same listener for both, or worse. 2. use the same oracle userid for both installs and change the environment vars as needed. Seems like you could damage the first install if you made a mistake. Also, it seems like in a stressful failure situation you don't want to have to think about who's on first? I don't know, third base. Are both paths valid? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: John Blake 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).
DeadLock: session wait on itself with no rows.
hi, friends: >>>select count(*) into :b0 from USERCONFIRMINFO where USER_ID=:b1 >>>The following deadlock is not an ORACLE error. It is a >>>deadlock due to user error in the design of an application >>>or from issuing incorrect ad-hoc SQL. The following >>>information may aid in determining the deadlock: >>> >>>Deadlock graph: >>>-Blocker(s) -Waiter(s)- >>>Resource Name process session holds waits process session holds waits >>>TX-000e005d-00037cfa 306 484 X 306 484 S >>>session 484: DID 0001-0165-00010802 session 484: DID 0001-0165-00010802 >>>Rows waited on: >>>Session 484: no row Another trace file like: >>>*** 2003-03-02 16:50:22.447 >>>DEADLOCK DETECTED >>>Current SQL statement for this session: >>>select USER_ID ,USER_EMAIL into :b0,:b1 from USERPRIVATEINFO where USER_ACCOUNT=:b2 >>>The following deadlock is not an ORACLE error. It is a >>>deadlock due to user error in the design of an application >>>or from issuing incorrect ad-hoc SQL. The following >>>information may aid in determining the deadlock: >>>Deadlock graph: >>> -Blocker(s) -Waiter(s)- >>>Resource Name process session holds waits process session holds waits >>>TX-0012004a-000374f8 293 263 X306 512 S >>>session 263: DID 0001-0165-0004EC65 session 512: DID 0001-0165-0004EC65 >>>Rows waited on: >>>Session 512: no row I ever saw message talking about two session deadlock with no rows waited on, maybe it is because of pctfree/initrans, How about session wait on itself then? And how can it happen? Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping 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 Magazine excels itself
I agree wholeheartedly, the reason being (to share my own experiences), that some months ago I sent some feedback on an (unrelated) article in Oracle magazine because I thought much of it was incorrect. I got a reply from the author of the article basically agreeing with my points. Of course, *that* reply came offline, not in the magazine! Cheers Connor --- Jonathan Lewis <[EMAIL PROTECTED]> wrote: > > > I think it was only a few weeks ago that > I posted a list of errors in an article about > statspack that Oracle Magazine published > in January. > > You may be interested to see that another reader > sent a letter to the editor about the same article, > which has been published, with a response, in > the March issue. > > <> > > I found an error in "Advanced Tuning with > Statspack" in your > January/February 2003 issue. Rich Niemiec writes > that in > the event of a wait on a segment header to > increase the > Freelist groups. Freelist groups only apply to > Oracle9i RAC > systems, and have nothing to do buffer busy > waits on > non-RAC systems. > > <> > > << my comment>> > > It is, of course, unfortunate that this 'correction' > is actually > wrong. Although the manuals have persistently > stated, until > very recently, that freelist groups were relevant > only to OPS, > they have been effective in single instance Oracle > for a long > time - possibly as far back as 7.2.3 > > <> > > <> > > Freelist groups do, in fact, have some benefits > apart from > Oracle9i RAC. MetaLink says that Freelist groups > can > have a positive impact in an exclusive > environment > (non-RAC) by helping reduce contention on the > segment > header. However, I should point out that segment > header > block contention can be addressed without > multiple Freelist > groups, for example, by increasing the > pctfree/pctused gap > or by partitioning the segment. > > <> > > > <> > > Surely the point of a 'readers comments' section is > to get feedback from the readers, add value to the > article by including readers' experiences or extra > observations, allow expression of readers' attitudes > and feelings (without an aggressive editorial > response), > and, if an actual error does get noted, allow a > correction > to be published. > > > So why publish this erroneous correction ? It did > not > add value to the article, it didn't even expose the > need > for clarification of a point. It merely elicited a > repetition > of some material that had already been stated in the > article (which originally said: "... If this is the > case, increase > the freelist groups or increase the pctused to > pctfree gap"...) > plus the claim that the author had to be right > because the > comment was taken from Metalink. > > > It would, quite arguably, have been valid to reply > with > something like: "Your comments do, indeed reflect > a well-known, and often documented, misconception > about freelist groups. However, the behaviour > changed in > Oracle 7.X.X, and single-instance Oracle will take > advantage of multiple free list groups. Be careful, > however, that you set FREELISTS and FREELIST > GROUPS to relatively co-prime numbers, or you > will lose some of the benefits etc." > > > So what has the dialogue achieved: > > a) It hasn't improved the knowledge of the > readers. > > b) It has told readers that they had better not > write in if they think that there is an error in > one of the articles unless they want to run > the risk of looking stupid in public. > > c) It has given Rich Niemiec the chance to > say "I'm right, you're wrong - yah, boo, sucks". > > > I'm not impressed.. > > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Coming soon one-day tutorials: > Cost Based Optimisation > Trouble-shooting and Tuning > Indexing Strategies > (see http://www.jlcomp.demon.co.uk/tutorial.html ) > > UK___March 19th > UK___April 8th > UK___April 22nd > > USA_(FL)_May 2nd > > > Next Seminar dates: > (see http://www.jlcomp.demon.co.uk/seminar.html ) > > USA_(CA, TX)_August > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > > -- > 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). > = Connor McDonald w
Re: bulk load of data
certainly sqlldr direct is the way to do until you could look at external tables in ver 9. The only advice I would add is that if you do go the external table route in v9, try get more benefit than just replacing sqlldr with some sql. I've seen a few places where they adopted external tables but they still just loaded the data from the external into staging tables and then did some processing, where I think the aim should be to use the external table and possibly some pipelining to streamline the process. hth connor --- John Dunn <[EMAIL PROTECTED]> wrote: > Age old question I guess, but looking for the up to > date answer. > > > We have requirement to process up to 500,000 records > of data currently held > in > a text file. > > Currently we process these through external C > procedures and only totals are > > loaded into the database, Now we have a functional > requirement which > probably > means we need to load all the records into a > database table. > > Is sqlloader still the quickest option? > > What other options are there? We know that utl_file > is too slow. External > tables? > > Platform is 8.1.7 on AIX moving soon to 9i release 2 > > If there any up to date documents or discussion > threads you can point me at > please do so. > > John > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: John Dunn > 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). > = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: Statistics on SYS?
The cynic in me would think that this is tantamount to Oracle asking us to beta-test their cbo-enabled dictionary in preparation for ver 10 :-) I think they're pretty much there though - bucketloads of the recursive sql seems to be hinted nowadays, presumably to get it cbo ready. cheers connor --- Freeman Robert - IL <[EMAIL PROTECTED]> wrote: > There is actually now a comment in the 9iR2 doc's > that it's ok to start > generating stats on the SYSTEM tablespace (in prep > for the removal of RBO in > 10i). Has anyone actually done that in 9iR2, and > what is your experience? > > RF > > > -Original Message- > To: Multiple recipients of list ORACLE-L > Sent: 2/28/2003 2:23 PM > > > I remember it was noted here that > dbms_stats.gather_database_stats > was busted in 8i, it went about attacking system ts. > Is that fixed in > 9.2.0.2? > > > > > > > On Fri, Feb 28, 2003 at 11:16:17AM -0800, DENNIS > WILLIAMS wrote: > > Chuck - Don't do it man! People have had very bad > problems due to > this. > > > > Dennis Williams > > DBA, 40%OCP, 100% DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Friday, February 28, 2003 11:09 AM > > To: Multiple recipients of list ORACLE-L > > > > > > What's the current recommendation for gathering > statistics on system > schema > > objects like SYS, and OUTLN? Are they still saying > not to do it? I am > on > > 8.1.7. > > > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > > -- > > Author: Chuck Hamilton > > 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). > > -- > === > Ray Stell [EMAIL PROTECTED] (540) 231-4109 > KE4TJC28^D > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Ray Stell > 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: Freeman Robert - IL > 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). > = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PRO
Re: How to load pictures/documents in oracle
asktom.oracle.com has a number of plsql examples to do so. hth connor --- Gene Sais <[EMAIL PROTECTED]> wrote: > I don't have much experience developing applications > using blobs but > here is a link to help get you started. > http://developer.iplanet.com/appserver/samples/database/docs/blob.html > Gene > > >>> [EMAIL PROTECTED] 02/28/03 10:04AM >>> > Hi, > > > I have never had to insert pictures/documents in the > oracle database > before > and would like to give it a go. Does anybody have > some scripts that I > can > tear apart to look at how to do it (examples I find > more usefull than > books). I tried finding useful info on the net but > did not find any > concrete > answers. > > > TIA > > > Jack > > > Jacob A. van Zanen > Oracle DBA > Quant Systems Europe b.v. > Tel : +31 (0) 251 - 268 268 > Mobile: +31 (0) 6 51308813 > Fax: +31 (0) 251 - 268 269 > E-mail: mailto:[EMAIL PROTECTED] > Visit our web site at http://www.quantsystems.nl/ > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jack van Zanen > 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). > = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).