RE: When optimizer reevaluate SQL statement
!! Please do not post Off Topic to this List !! You mean it invalidates SQL which has references to the newly analyzed objects, not all SQL in cache - right? Also are you sure that creating index on table will invalidate SQL which references this table or view based on this table? Alex Hillman -Original Message- Sent: Friday, September 14, 2001 11:40 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! Chris list, The last time I checked, an ANALYZE also invalidates the SQL in the shared pool, to force a parse and rebuild of the execution plan, on the next execution of the SQL statement. Regards, Gaja --- Christopher Spence [EMAIL PROTECTED] wrote: !! Please do not post Off Topic to this List !! If the statement is not exactly the same, the new statement will be reparsed. If you are executing it under a different user the statement will be reparsed. If you drop/create an index, it will invalidate the explain plan if that was part of the chosen path. I believe statistics also invalidates the plans as well, but not 100% sure on that. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 13, 2001 8:11 PM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! No takers so far - anybody? Alex Hillman -Original Message- Sent: Thursday, September 06, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Let's assume that SQL statement was parsed by user X. If this or another user reexecute this same statement what are the conditions that this SQL statement will be reparsed? Let's assume that privileges are not changed and tables and/or views are not dropped and views are not changed. And optimizer parameters are not changed. First come to mind is dropping index. What about reanalizing one of the object - theoretically should also reparse. Anything else? Also is there possibility to force reparsing of SQL statement if let say index was added - short of flashing shared pool? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __ Terrorist Attacks on U.S. - How can you help? Donate cash, emergency relief information http://dailynews.yahoo.com/fc/US/Emergency_Information/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San
RE: When optimizer reevaluate SQL statement
!! Please do not post Off Topic to this List !! No takers so far - anybody? Alex Hillman -Original Message- Sent: Thursday, September 06, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Let's assume that SQL statement was parsed by user X. If this or another user reexecute this same statement what are the conditions that this SQL statement will be reparsed? Let's assume that privileges are not changed and tables and/or views are not dropped and views are not changed. And optimizer parameters are not changed. First come to mind is dropping index. What about reanalizing one of the object - theoretically should also reparse. Anything else? Also is there possibility to force reparsing of SQL statement if let say index was added - short of flashing shared pool? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Quest bought EZSQL
!! Please do not post Off Topic to this List !! Guys, go to www.ezsql.net and read about it. Quest will not sell new licences - apparently EZSQL was bought to suppress competition for TOAD and SQL Navigator. It reminds me Marks explanation about capitalizm - that capitalizm suppress innovations when they are thretening profits. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
bitmap indexes and rule based optimizer
Anybody knows whether rule based optimizer can use bitmap indexes? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: bitmap indexes and rule based optimizer
Thanks. However bitmap indexes are 7.3+ feature - why I asked. Alex Hillman -Original Message- Sent: Wednesday, September 12, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Alex: No, the rbo does not support bitmap indexes or any other Oracle8 or greater feature (such as partitioning, etc.). To use these features, you must set optimizer_mode to CHOOSE, FIRST_ROWS or ALL_ROWS, which will invoke the cbo. Jon Walthour -Original Message- Sent: Wednesday, September 12, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Anybody knows whether rule based optimizer can use bitmap indexes? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walthour, Jon (GEAE, Compaq) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Copying backups across a narrow pipe.
And where can I get that look? Alex Hillman -Original Message- Sent: Tuesday, September 11, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Hi, take a look at connect direct. It's a data transfer tool that is scriptable and can handle high volumes at a high transfer rate. Denham Eva schrieb: Hi Gurus I have a problem in that I have to copy my backups across a wan connection to a remote server. However the copy ( using xcopy) in the microsoft NT environment, keeps on dropping or times out. So the success rate is very low, the Boss is now becoming difficult about it. Does anyone know of any tools/Software which I could use to copy the file across, check the integrity and recopy if it had failed? Any suggestions will be appreciated Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denham Eva INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). - This Mail has been checked for Viruses Attention: Encrypted mails can NOT be checked! ** Diese Mail wurde auf Viren geprueft Hinweis: Verschluesselte mails koennen NICHT auf Viren geprueft werden! - -- | Regards, | | Stefan Jahnke | | BOV AG | | @:D2 Vodafone, Abt.: FBOM | | Tel.: 0211/533-4893| -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: manage oracle on SAP system
Typo. Alex Hillman -Original Message- Sent: Friday, September 07, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Alex, Are you joking or it's a typo ? but I like Iracle (Irate+Oracle ??:) SAP DBA... - Kirti -Original Message- From: Hillman, Alex [SMTP:[EMAIL PROTECTED]] Sent: Friday, September 07, 2001 3:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: manage oracle on SAP system Why don't you buy Donald Burleson book about Iracle DBA in SAP environment. Do't remember exact title but you can find it by author. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db engines VS flat files
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Please do not re-send by any reazon in any way or form any of the informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Please do not re-send by any reazon in any way or form any of the informatino here contained. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: agc INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hardware requirements when migration oracle from NT to Li
Everyday I find something new from this list. Today - that red hat cannot handle more than 1 processor :-) Alex Hillman -Original Message- Sent: Friday, September 07, 2001 9:01 AM To: Multiple recipients of list ORACLE-L Take what you have, strip out one processor since I don't think Red Hat can use more than one processor, and have fun. BTW: Your duhvelepors will probably see a 100% performance boost since Linux has a lot less overhead than NT. Dick Goulet Reply Separator Author: Schoen Volker [EMAIL PROTECTED] Date: 9/7/2001 1:45 AM Hi list, I want to migrate our developer databases from NT 4.0 (Oracle 8.1.5) to Redhat Linux 7.1 (Oracle 8.1.7). My question is, which hardware do I need for the linux machine to hit the same performance than on NT machine. Hardware NT machine: 2 * PIII 500 processor 1 GB Ram one RAID 5 TIA Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] http://www.inplan.de http://www.inplan.de !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=us-ascii META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEHardware requirements when migration oracle from NT to Linux/TITLE /HEAD BODY PFONT FACE=ArialHi list,/FONT /P PFONT FACE=ArialI want to migrate our developer databases from NT 4.0 (Oracle 8.1.5) to Redhat Linux 7.1 (Oracle 8.1.7). My question is, which hardware do I need for the linux machine to hit the same performance than on NT machine./FONT/P PFONT FACE=ArialHardware NT machine:/FONT BRFONT FACE=Arial2 * PIII 500 processor/FONT BRFONT FACE=Arial1 GB Ram/FONT BRFONT FACE=Arialone RAID 5 /FONT /P PFONT FACE=ArialTIA/FONT /P PFONT COLOR=#00 FACE=ArialVolker Schoen/FONT BRFONT COLOR=#00 FACE=ArialE-Mail:/FONTU /UA HREF=mailto:[EMAIL PROTECTED];U/UU/UUFONT COLOR=#FF FACE=Arialmailto:[EMAIL PROTECTED]/FONT/UU/U/AU/UU/U BRU/UA HREF=http://www.inplan.de;U/UU/UUFONT COLOR=#FF FACE=Arialhttp://www.inplan.de/FONT/UU/U/AU/UU/U /P BR /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: manage oracle on SAP system
Why don't you buy Donald Burleson book about Iracle DBA in SAP environment. Do't remember exact title but you can find it by author. Alex Hillman -Original Message- Sent: Wednesday, September 05, 2001 10:06 AM To: Multiple recipients of list ORACLE-L hi, list: I just be an ERP system oracle dba, and find Oracle and SAP are tightly related. Is here someone else also managing Oracle on SAP system? Give out some key point and suggestions? I am yet not familier with SAP system . Thanks. chao_ping. Oracle DBA DTT corp. _ Do You Yahoo!? µÇ¼Ãâ·ÑÑÅ»¢µçÓÊ! http://mail.yahoo.com.cn font color=#FFÎÞÁÄ£¿ÓôÃÆ£¿¸ßÐË£¿Ã»ÀíÓÉ£¿¶¼À´ÁÄÌì°É£¡/font¡ª¡ª ÑÅ»¢È«ÐÂÁÄÌìÊÒ! http://cn.chat.yahoo.com/c/roomlist.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?gb2312?q?chao=20zhu?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Max IO size - File System vs Raw
Until Solaris 2.5 it was hard coded limit of I/O size 64K. Has nothing to do with file system restriction on I/O size. Alex Hillman -Original Message- Sent: Thursday, September 06, 2001 12:47 PM To: Multiple recipients of list ORACLE-L Yeh - thats what I suspected - but no-one at Sun seems to wanna tell me that. Basically they're telling me, we can read up to maxphys - if you're not getting that, then it must be something non-Sun related Sounds like BS to me. --- Christopher Spence [EMAIL PROTECTED] wrote: A lot of file system's have a max io of much lower than raw. In the earlier Solaris's it was 64K, but as you see, it is now seems to be 256k. Under NT is 128k without using raw. To truly take advantage of MULTIBLOCK_READ_COUNT you need to use RAW file system. HP_UX I believe can do as high as 1Mb for this. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, September 06, 2001 9:11 AM To: Multiple recipients of list ORACLE-L Anyone know of any restrictions on the max physical IO (under Solaris8) that is imposed by file systems? To illustrate - Using a tablespace on a raw device under veritas vol mgr - maxphys is 512k - vxio:vol_maxio is 512k - db block size is 8k - db multi read is 64 and as expected, a level 8, 10046 trace shows me that I can get 512k max io...so far, so good If I repeat the exercise after putting a file system (vxfs or ufs) on this device, then the best I can get is 256k. Any Solaris internal people out there ? Cheers Connor = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
When optimizer reevaluate SQL statement
Let's assume that SQL statement was parsed by user X. If this or another user reexecute this same statement what are the conditions that this SQL statement will be reparsed? Let's assume that privileges are not changed and tables and/or views are not dropped and views are not changed. And optimizer parameters are not changed. First come to mind is dropping index. What about reanalizing one of the object - theoretically should also reparse. Anything else? Also is there possibility to force reparsing of SQL statement if let say index was added - short of flashing shared pool? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
what to check in alert.log
Any suggestions what to check for in alert.log besides ORA- ? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 81721 upgrade and event 10520
It is for avoiding of firing DDL triggers when running upgrade scripts. Alex Hillman -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 2:15 AM To: Multiple recipients of list ORACLE-L Hi, In the release notes for 8.1.7.2.1 there is a requirement to turn event 10520 on before running catalog.sql / catproc.sql and then turning the event off afterwards. What does this event actually do (Ixora nor Metalink explain it)? Does anyone know if this event required if you are creating a brand new 8.1.7.2.1 database? Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 81721 upgrade and event 10520
Sorry I mixed this event with undoc. parameter _system_trig_enabled=false Alex Hillman -Original Message- Sent: Wednesday, September 05, 2001 12:52 PM To: Multiple recipients of list ORACLE-L It is for avoiding of firing DDL triggers when running upgrade scripts. Alex Hillman -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 2:15 AM To: Multiple recipients of list ORACLE-L Hi, In the release notes for 8.1.7.2.1 there is a requirement to turn event 10520 on before running catalog.sql / catproc.sql and then turning the event off afterwards. What does this event actually do (Ixora nor Metalink explain it)? Does anyone know if this event required if you are creating a brand new 8.1.7.2.1 database? Thanks, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spooling output of a select statement to a file through store
Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
financial problems with fatcity.com
I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: financial problems with fatcity.com
I dont think $12 is worth even speak to management. Alex Hillman -Original Message- Sent: Wednesday, August 29, 2001 2:54 PM To: Multiple recipients of list ORACLE-L The only problem with having my damagement pay for a subscription for this list is that they may find out where I get all my answers to some very difficult problems!! ;o) Dave -Original Message- Sent: Wednesday, August 29, 2001 11:43 AM To: Multiple recipients of list ORACLE-L Whats that first part of your domain address there Alex :-) Perhaps you could help the list out !! -Original Message- Sent: 29 August 2001 16:16 To: Multiple recipients of list ORACLE-L I think that much better than voluntary contributions will be some s*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. I am sure that everybody working with Oracle and living in US or UK or other developed country can afford such fees. We will not need to charge people from developing countries - I am sure these subscription fees will generate more than $500 per month. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: MOVE Tables from One Tablespace to Another Tablespace !!
Need to add accounting for LOB indexes or simply not to add whenever SQL error ... alter index .. rebuild does not work for LOB indexes. Alex Hillman -Original Message- Sent: Tuesday, August 21, 2001 1:57 PM To: Multiple recipients of list ORACLE-L I just did this yesterday. Here are the scripts I used; sqlplus system/syspaswd set pagesize 0 set feedback off spool mv_tbls.sql select 'alter table '|| owner || '.' || segment_name || ' move tablespace new_tblspc;' from dba_segments where segment_type='TABLE' and tablespace_name='old_tblspc'; spool off; spool alter_idxs.sql select 'alter index ' || i.table_owner || '.' || i.index_name || ' rebuild;' from dba_indexes i, dba_segments s where s.segment_name=i.table_name and s.owner=i.table_owner and s.segment_type='TABLE' and s.tablespace_name='old_tblspc'; spool off; this is from memory, so check the spooled scripts before running... -Original Message- INF/MEKKAOUI Sent: Tuesday, August 21, 2001 5:41 AM To: Multiple recipients of list ORACLE-L hi, the command is : Alter table table_name move tablespace tablespace_name; But be careful from index corruption. Best Regards, Nabila Mekkaoui DBA Oracle -Message d'origine- De : Dash, Saroj (CAP,CEF) [mailto:[EMAIL PROTECTED]] Envoyé : mardi 21 août 2001 08:16 À : Multiple recipients of list ORACLE-L Objet : MOVE Tables from One Tablespace to Another Tablespace !! Hello All, Please tell me the detailed steps to move tables from one tablespace to another tablespace. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INF/MEKKAOUI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: High DML Table - Suggestions??
Also I would have high PCTFREE to lessen number of records per block - if you will have a lot of buffer busy waits. If you have enough memory - simply increase size of KEEP pool to get enough space for needed number of CR blocks. You will have to experiment with size of KEEP pool and v$buffer_pool_statistics - purpose to eliminate physical reads. Alex Hillman -Original Message- Sent: Monday, August 20, 2001 6:04 PM To: Multiple recipients of list ORACLE-L Don't put it in a buffer keep because of the amount of consistent gets the table could have. It seems to be a high volatile table. Maybe it is too late but you should look on the initrans, freelist of the table. Also if the table has foreign keys, talk with Development to leave the table without them. I should consider to partition the tablemaybe a hash one. Regards. --- Walter K [EMAIL PROTECTED] wrote: Hi, I have a table that is going to have a large amount of inserts, updates and deletes performed against it daily. Approximately 1,000,000 transactions per day (some single-record, some multi-record). The table is ~100Mb in size. I'm looking for some suggestions on what I can do to have the most optimal I/O for the table. I've been doing a little reading about buffer pools. Is assigning this table to a KEEP pool a practical approach or is that not going to buy me anything because DML is involved? Does anyone have any other suggestions? Unfortunately, I can't put the table on a dedicated disk and I am stuck with Raid-5 currently. Any suggestions would be appreciated. Thanks in advance! -w __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to find maximum number of concurrent sorts from instance star
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Using triggers for data validation
In Steve Adams sample of performance report there is a suggestion to use trigger after row update instead of before row update because it will halve the number of redo records created for row locks. Anybody has diferent opinion? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: Datafile Migration Tool
, Bangalore, INDIA. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City
RE: Re[2]: Datafile Migration Tool
exp/imp does not work(takes too much time)for large databases. How long do you think import will take for 200G database? - about 60 hours? Alex Hillman -Original Message- Sent: Tuesday, August 14, 2001 5:03 PM To: Multiple recipients of list ORACLE-L Rachel, I can see what he is proposing, but I'm not sure anyone would care. I know I can't take the datafiles from one of our HP-UX servers and use them to create a database on NT for instance. Wish I could for our Support Magic junk. In that case they do a bunch of things (like create objects) as SYS which never get included in an export. The problem that I see is that there is a toolset that currently exists, namely export import, that work cross platform with no problems. Just not at the datafile level. And although that type of tool would be interesting to me it would not be of much value since I've only the one problem. Dick Goulet Reply Separator Author: Rachel Carmichael [EMAIL PROTECTED] Date: 8/14/2001 12:41 PM it doesn't sound like an ftp type tool. If I am reading this correctly, he is proposing to provide a tool that copies datafiles directly from one OS to another. While this is an interesting trick, I'm not sure there's a large market for it. From: Scott Shafer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Datafile Migration Tool Date: Tue, 14 Aug 2001 12:00:53 -0800 Not to be a smartass, but don't most OS's already have ftp built in? What kind of value-added are you proposing? Just curious... Scott Shafer San Antonio, TX K Gopalakrishnan wrote: Hi , Will there be a market if I give a tool which migrates Oracle database from One OS to another OS. (Data file migration at Operating System Level.) i.e it will convert from Oracle data files on NT to Oracle Datafiles on Solaris and vice versa. In the target database you need to recreate the control files and you are done. You can startup the database. You don't need to export/import or CTAS over dblink.. Send your replies directly to me.. Thanks Yong..for bringing the cat out of the basket ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: OT Dorothy Parker :)
One never knows. I think worst is to be in the last wave of layoffs. IN THE FIRST WAVE PEOPLE usually get much better packages. Alex Hillman -Original Message- Sent: Thursday, August 09, 2001 6:36 PM To: Multiple recipients of list ORACLE-L Congratulations on your survival Shrek. Having more work is better than having NO work. -Original Message- Sent: Thursday, August 09, 2001 4:46 PM To: Multiple recipients of list ORACLE-L geez, is it friday yet? i hope so, cuz we just got done laying off 25% of the people here. same work + less people := get-out-of-dodge-NOW. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. MIPS: Meaningless Indicator of Processor Speed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to locate who dropped a view using log miner?
Can you elaborate a little bit more please.
Alex Hillman
-Original Message-
Sent: Wednesday, August 08, 2001 4:11 AM
To: Multiple recipients of list ORACLE-L
Life isn't made any easier by the fact that it is apparently
a deliberate decision the part of Oracle Corp to leave
the undo/redo for various dictionary tables uninterpreted,
so that SQl against TAB$ reads:
delete from UNKNOWN.objn:4
where col[1] = hextoraw('c20301') ...
I would look only at the OBJ$ code, and set up the
column search section of log miner to search for
the TYPE# column, specifying the value as per the
list in $ORACLE_HOME/rdbms/admin/sql.bsq
Jonathan Lewis
Seminars on getting the best out of Oracle
Last few places available for Sept 10th/11th
See http://www.jlcomp.demon.co.uk/seminar.html
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 08 August 2001 03:22
|and you might not find anything.
|
|I'll reiterate, logminer in 8.1.5-.7 is version 1.0, anything of
version
|1.0 is full of bugs(and logminer has its own share), and does not
have
|full functionality.
|
|here is the short version.
|
|a DDL statement like drop table, does do DML against underlying
tables
|that end in $.
|
|tab$, col$, etc.
|
|In an advanced logminer class i teach, you can SOMETIMES find when a
|table was dropped based on DML against the data dictionary but NOT
|always, why??
|
|well chained/migrated rows is only noted as operation = INTERNAL and
you
|get NO redo or undo SQL.
|
|I'm not saying logminer is hard to use, but its a bit more than,
|
|start logminer and look for undo SQL in the v$logmnr_contents view.
|
|joe
|
|--
|Joe Testa
|Performing Remote DBA Services, need some backup DBA support?
|For Sale: Oracle-dba.com domain, its not going cheap but feel free to
|ask :)
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Joe Testa
| INET: [EMAIL PROTECTED]
|
|Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California-- Public Internet access / Mailing
Lists
|
|To REMOVE yourself from this mailing list, send an E-Mail message
|to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
|the message BODY, include a line containing: UNSUB ORACLE-L
|(or the name of mailing list you want to be removed from). You may
|also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jonathan Lewis
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: How to locate who dropped a view using log miner?
Strange how Oracle can make
complicated things right and very simple things very bad. Example - the same
logminer. Looks like interface was done by brain dead people. I am not talking
about the bugs. Also database assistant. This is a task for HS student - very
simple GUI etc. and even after several reincarnations there are a lot of
bugs.
Alex
Hillman
-Original Message-From: JOE TESTA
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 2001
11:06 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: How to locate who dropped a view using log miner?
Intentional or because you didnt have an up to date dictionary
file.
I'll be the last to defend oracle corp but that was version 1 of
logminer, before that you had basically nothing or pay for a 3rd party
tool.
up thru 8.1.7 there is no support for DDL, never was and never will be in
8i.
9i thats another story, i'm working with it now and hope to check out the
DDL this evening.
joe
joe-Original Message-Sent: Wednesday, August 08, 2001
4:11 AMTo: Multiple recipients of list ORACLE-LLife isn't
made any easier by the fact that it is apparentlya deliberate decision the
part of Oracle Corp to leavethe undo/redo for various dictionary tables
uninterpreted,so that SQl against TAB$ reads:delete from
UNKNOWN.objn:4where col[1] = hextoraw('c20301') ...I would
look only at the OBJ$ code, and set up thecolumn search section of log
miner to search forthe TYPE# column, specifying the value as per
thelist in $ORACLE_HOME/rdbms/admin/sql.bsqJonathan
LewisSeminars on getting the best out of OracleLast few places
available for Sept 10th/11thSee http://www.jlcomp.demon.co.uk/seminar.html-Original
Message-To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]Date: 08 August 2001 03:22|and you
might not find anything.||I'll reiterate, logminer in 8.1.5-.7 is
version 1.0, anything ofversion|1.0 is full of bugs(and logminer has
its own share), and does nothave|full functionality.||here is
the short version.||a DDL statement like drop table, does do DML
against underlyingtables|that end in $.||tab$, col$,
etc.||In an advanced logminer class i teach, you can SOMETIMES find
when a|table was dropped based on DML against the data dictionary but
NOT|always, why??||well chained/migrated rows is only noted as
operation = INTERNAL andyou|get NO redo or undo SQL.||I'm not
saying logminer is hard to use, but its a bit more than,||start
logminer and look for undo SQL in the v$logmnr_contents
view.||joe||--|Joe Testa|Performing Remote DBA
Services, need some backup DBA support?|For Sale: Oracle-dba.com domain,
its not going cheap but feel free to|ask :)|--|Please see the
official ORACLE-L FAQ: http://www.orafaq.com|--|Author: Joe
Testa| INET: [EMAIL PROTECTED]||Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051|San
Diego, California -- Public Internet
access /
MailingLists||To
REMOVE yourself from this mailing list, send an E-Mail message|to:
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in|the
message BODY, include a line containing: UNSUB ORACLE-L|(or the name of
mailing list you want to be removed from). You may|also send the
HELP command for other information (like subscribing).-- Please
see the official ORACLE-L FAQ: http://www.orafaq.com-- Author:
Jonathan Lewis INET: [EMAIL PROTECTED]Fat City
Network Services -- (858) 538-5051 FAX: (858)
538-5051San Diego, California --
Public Internet access / Mailing
ListsTo
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).-- Please see the official
ORACLE-L FAQ: http://www.orafaq.com--
Author: Hillman, Alex INET:
[EMAIL PROTECTED]Fat City Network
Services -- (858) 538-5051 FAX: (858) 538-5051San
Diego, California -- Public Internet
access / Mailing
ListsTo
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).
RE: Timed statistics and SQL_TRACE for already running session
Do you know what does procedure WAIT_FOR_EVENT in this package is doing? Alex Hillman -Original Message- Sent: Wednesday, August 08, 2001 1:56 PM To: Multiple recipients of list ORACLE-L Which version of Oracle. From 8.1.6 onwards, dbms_system contains a call similar to set_sql_trace_in_session which is name something like: set_boll_param_in_session. Describe dbms_system to check the proper nmame and parms. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 08 August 2001 16:29 | |I used the following syntax/package to run a trace on a user's already |running |session. | |EXECUTE dbms_system.set_sql_trace_in_session(8,12,TRUE); | |I then ran tkprof on the resulting trace file. It all worked fairly well |but |I didn't get any times on any of the statements that executed. | |Is there a way to use timed_statistics with this package? |Or must I turn on timed statistics for the entire database? | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL tuning / optimization problem - IS NOT NULL - Clarify
VARCHAR2(80) DOA_CHECK_BOXNUMBER CUSTOMER_SATIS NUMBER CUSTOMER_CODEVARCHAR2(20) SERVICE_ID VARCHAR2(30) ALT_PHONEVARCHAR2(20) FORWARD_CHECKNUMBER CCLIST1 VARCHAR2(255) CCLIST2 VARCHAR2(255) KEYWORDS VARCHAR2(255) OWNERSHIP_STMP DATE MODIFY_STMP DATE DIST NUMBER ARCH_IND NUMBER IS_SUPERCASE NUMBER DEV NUMBER CASE_SOLN2WORKAROUND NUMBER(38) CASE_PREVQ2QUEUE NUMBER(38) CASE_CURRQ2QUEUE NUMBER(38) CASE_WIP2WIPBIN NUMBER(38) CASE_LOGIC2PROG_LOGICNUMBER(38) CASE_OWNER2USER NUMBER(38) CASE_STATE2CONDITION NUMBER(38) CASE_ORIGINATOR2USER NUMBER(38) CASE_EMPL2EMPLOYEE NUMBER(38) CALLTYPE2GBST_ELMNUMBER(38) RESPPRTY2GBST_ELMNUMBER(38) RESPSVRTY2GBST_ELM NUMBER(38) CASE_PROD2SITE_PART NUMBER(38) CASE_REPORTER2SITE NUMBER(38) CASE_REPORTER2CONTACTNUMBER(38) ENTITLEMENT2CONTRACT NUMBER(38) CASESTS2GBST_ELM NUMBER(38) CASE_RIP2RIPBIN NUMBER(38) COVRD_PPI2SITE_PART NUMBER(38) CASE_DISTR2SITE NUMBER(38) CASE2ADDRESS NUMBER(38) CASE_NODE2SITE_PART NUMBER(38) DE_PRODUCT2SITE_PART NUMBER(38) CASE_PRT2PART_INFO NUMBER(38) DE_PRT2PART_INFO NUMBER(38) ALT_CONTACT2CONTACT NUMBER(38) TASK2OPPORTUNITY NUMBER(38) CASE2LIFE_CYCLE NUMBER(38) CASE_VICTIM2CASE NUMBER(38) ENTITLE2CONTR_ITMNUMBER(38) X_DIAGNOSIS VARCHAR2(255) X_EXPERIENCE NUMBER X_OS VARCHAR2(30) X_PROBLEMVARCHAR2(255) X_RESOLUTION VARCHAR2(255) X_WORKGROUP VARCHAR2(30) X_FIRST_CLOSEVARCHAR2(1) X_FCLOSEDNUMBER X_FCLOSEDATE DATE Following indexes exist on the TABLE_CASE table: Index_nameColumn_name CASE_OBJINDEXOBJID IND_ALT_FIRST_NAME ALT_FIRST_NAME IND_ALT_LAST_NAME ALT_LAST_NAME IND_CASE_CREATION_TIMECREATION_TIME CASE_CASE_INDEX ID_NO IND_CASE_OWNER2USER CASE_OWNER2USER, CASE_WIP2WIPBIN IND_ENTITLEMENT2CONTRACT ENTITLEMENT2CONTRACT IND_CASE_REPORTER2CONTACT CASE_REPORTER2CONTACT IND_CASE_STATE2CONDITION CASE_STATE2CONDITION IND_CASE_PROD2SITE_PART CASE_PROD2SITE_PART IND_ENTITLE2CONTR_ITM ENTITLE2CONTR_ITM INDEX_NAME -- IND_CASE_VICTIM2CASE CASE_VICTIM2CASE IND_S_CASE_TITLE S_TITLE IND_CASE_PREVQ2QUEUE CASE_PREVQ2QUEUE IND_CASE_CURRQ2QUEUE CASE_CURRQ2QUEUE CASE_WIP2WIPBIN_INDEX CASE_WIP2WIPBIN IND_CASESTS2GBST_ELM CASESTS2GBST_ELM I hope that's everything that anyone might need to look at this problem. I'm frustrated after pounding away at it off and on the last couple of days. The users are getting frustrated and I've run out of ideas. In another day or two they are going to revolt and then I'll have my boss breathing down my neck. So if anyone has any ideas of what I might try, please let me know. Thanks, Cherie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538
RE: Recovery without backup.
Title: Recovery without backup. It existed before 8i. There is an example in Backup and Recovery book. alter database create datafile ... and then recover. Alex Hillman -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 08, 2001 3:22 PMTo: Multiple recipients of list ORACLE-LSubject: Recovery without backup. I don't know much about this feature, but someone mentioned in 8.1.7 you can recover a datafile even without a backup as long as you have a control file that knew about it and the archive logs. Anyone give this a try? I am going to attempt this weekend on my test box. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863
RE: ORA-00600 on Production DB - Need advice/Still Searching
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). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to determine checkpoint rate?
I began indiscriminantly delete OT messages. Too much. Alex Hillman -Original Message- Sent: Tuesday, August 07, 2001 6:57 PM To: Multiple recipients of list ORACLE-L One more idea, set up www.gotomypc.com on a computer and allow the client access from one of their machines. They will be able to see everything you are doing. I use it and it is excellent. It requires no software for the client and you could have it running in as little as 5-10 minutes. - Ethan Good to see Jonathan Lewis posting! Now if we can only get Steve back! Perhaps a little too much OT now and then? -Original Message- From: Post, Ethan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 2:27 PM To: Multiple recipients of list ORACLE-L Subject: How to determine checkpoint rate? I am trying to locate a stat that is incremented every time a checkpoint occurs. I see a few checkpoint related stats in V$SYSTAT but none seem high enough to match the number of checkpoints that have occurred as a result of log switches, log checkpoint timeouts. Am I mistaken on this? Is there somewhere I can determine the total number of checkpoints that have occurred since system startup? Thanks, Ethan http://www.geocities.com/epost1 -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Evaluation questions
could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want
RE: performance pl/sql for DW conclusion
I also did not find any reporting scripts. In the tables created by proftab.sql - there is only line numbers, not PL/SQL text. So I need to get text from the module using line numbers - right? Anybody have report script which join these table with dba_source? Alex Hillman -Original Message- Sent: Monday, July 30, 2001 9:45 PM To: Multiple recipients of list ORACLE-L To completely install the DBMS_PROFILER package, run: 1. $ORACLE_HOME/rdbms/admin/profload.sql - to install the package (run as SYS) 2. $ORACLE_HOME/rdbms/admin/proftab.sql - to create the appropriate tables for the package. You can either run this script in the schema of the user who is going to use DBMS_PROFILER or, as I do, run it as SYSTEM, then create the appropriate synonyms and grant the appropriate permissions to use the tables. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, July 30, 2001 7:30 PM Looks like DBMS_PROFILER is not installed using catproc. I found loadprof.sql rdbms/admin which will install it. Any other way to install it? I did not find any scripts in rdbms/admin which call profload.sql. Alex Hillman -Original Message- Sent: Monday, July 30, 2001 6:31 PM To: Multiple recipients of list ORACLE-L DBMS_PROFILER is great, if you have PL/SQL Developer, it has a great interface to it. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, July 30, 2001 5:41 PM To: Multiple recipients of list ORACLE-L Hi guys Thanx everyone, I found what was going on. A special thank-you to Raj for pointing out the dbms_profiler, what a wonderful tool. Using that tool I discover that it was my select, and not the parsing or inserts, that were causing the problem. I created a bunch of indexes for all my dimension tables, and voilà... Down to 500 rows in 5 seconds. I love that list :-) FYI: SGA is fine, hit ratio ok, on that side, server and DB are going well, it was really my coding or pl/sql the problem. Now I know I was not helping my code at all. Thanks again to everyone who helped. Merci Steph, je te répond bientôt... Daniel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel Garant INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City
RE: performance pl/sql for DW conclusion
I also did not find any reporting scripts. In the tables created by proftab.sql - there is only line numbers, not PL/SQL text. So I need to get text from the module using line numbers - right? Anybody have report script which join these table with dba_source? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter index??
It is fixed in 8.1.7.1. Alex Hillman -Original Message- Sent: Tuesday, July 31, 2001 2:47 PM To: Multiple recipients of list ORACLE-L Again, I will post that there is a bug in using 'alter index indexname rebuild online;' in 8i. Metalink Doc 125149.1 (among others, look for them all) says; The ONLINE option of ALTER INDEX .. REBUILD ONLINE was introduced in Oracle8i. This feature enables an index to be rebuilt whilst DML continues against the table. This bug can produce a corrupt index when using the REBUILD ONLINE functionality thus: Once an online rebuild has begun, any user transaction that updates the index will generate corrupt undo which is written to the rollback segment and redo log. If this corrupt undo is applied either due to process death or instance death, or following a point in time recovery, it will corrupt the index (or IOT). A user session rollback will not introduce the corruption. This problem can result in an index/table data mismatch. Eg: There may be an index entry with no matching table row. The same problem exists when performing a MOVE ONLINE of an IOT (index only table). Buyer beware. I always use 'alter index indexname rebuild;'. -Original Message- Sent: Tuesday, July 31, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Use the alter index rebuild command. It uses the existing index to build the new one rather than going to the table. -Original Message- From: Raghu Kota [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 31, 2001 11:23 AM To: Multiple recipients of list ORACLE-L Subject: alter index?? Hi Friends What is the best way of rebuilding of following Index?? Index has total size 5.8Gb But lot of deletions, may be the real data around 2.5Gb has initial extent 71M, next 197M. So How my doubt which is best way for setting initial=next or give more space for initial for putting more data in initial itself and keep next as it is??? Any ideas??? Thanks in advance Raghu. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlloader process dies
Why don't you try to divide this load in several parts. Alex Hillman -Original Message- Sent: Tuesday, July 31, 2001 6:26 PM To: Multiple recipients of list ORACLE-L Thank you Kevin. No, drive has plenty of space. Any one else has a guess? -Original Message- Sent: Tuesday, July 31, 2001 5:07 PM To: Multiple recipients of list ORACLE-L Since it can't create a log file either ... how about space ??? running out of space on the machine ?? -Original Message- Sent: Tuesday, July 31, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Hi, I am experiencing a problem with sqlloader not being able to finish a large load. It tries to load between 1 and 2 millions records. Sometime during the load it just dies. I see an attempt to create a log file but the file size remains 0 bytes. It remains 0 size until the next day when new process kicks off. The described scenario occurs day after day. It is a cron job kicked from a batch file running multiple loads simultaneously. There are two particular loads that die every day... Anyone has any idea? Thank you for your help Lyuda -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.6. on Linux installation problem
It gives only picture. Was it a joke? Alex Hillman -Original Message- Sent: Monday, July 30, 2001 2:26 AM To: Multiple recipients of list ORACLE-L Try the linux dist from www.blackthorne.org. It worked for me on SuSE 7.1 Jared On Sunday 29 July 2001 21:30, Okan CIMEN wrote: Hello When I try to install Oracle 8.1.6 for Linux, I get a message saying; Initializing Java Virtual Machine from ../stage/Components/oracle.swd.jre/1.1.8/1/DataFiles/Expanded/linux/bin/jre . Please wait... and installation does not even start. I thought that the problem's reason is my box's JRE release is 1.3.1. Any recommendations? Okan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Braindead Friday...
another user should have select privileges for underlying table directly, not thru the role. Alex Hillman -Original Message- Sent: Friday, July 27, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solution (sorta) - Re: Another Braindead Friday...
Maybe use row security option using DBMS_RLS package - if you on 8i. In this case you can give users select on the table but restrain them what data thay can see. And then create views if you need akso restrain columns that they can see. Alex Hillman -Original Message- Sent: Friday, July 27, 2001 4:41 PM To: Multiple recipients of list ORACLE-L Well, thanks to all for the excellent recomendations, but it turns out to be a moot point. Access to the data _must_ be constrained by the security requirements of the system, so I'm turning it over to any Damagers who haven't departed for the Front 9 yet. Among the suggestions: --grant select with admin option or with grant option to the view owner. --grant create view to end users. --create a stored proc to generate views on the fly in each end users schema or in the table owner's schema with the necessary grants. Thanks Again and Happy Friday, Scott Scott Shafer wrote: -Original Message- Sent: Friday, July 27, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: deletion of data from a large table
Great discussion. Reminds me of lazydba list. Alex Hillman -Original Message- Sent: Thursday, July 26, 2001 8:43 AM To: Multiple recipients of list ORACLE-L Hi folks, Rick Cale was correct in saying that a truncate would release the storage by default. The only other option is to drop and recreate the table. Oracle will only release allocated storage when it is specifically asked to. The overhead on having a process monitoring which space it can drop would be prohibitive and needless. ( Imagine an example where an interface table is constantly filled and emptied - do you really want the storage to be constantly allocated and deallocated? ). Coalescing the tablespace will group adjacent free extents together but will have no effect on allocated blocks. Regards, Mike Hately, Oracle DBA |+-- || Ramasamy, Baskar | || Baskar.Ramasamy@cal| || anais.com | || | || 07/26/01 01:17 PM | || Please respond to | || ORACLE-L| || | |+-- -| | | | To: Multiple recipients of list ORACLE-L | | [EMAIL PROTECTED]| | cc: (bcc: Mike Hately/ETECH) | | Subject: RE: deletion of data from a large table | -| Rukmini, Try to do coalesce on the tablespace on which the table is sitting in after deleting rows. alter tablespace TSNAME coalesce; Baskar -Original Message- Sent: 26 July 2001 12:41 To: Multiple recipients of list ORACLE-L Hi All, I have deleted 3 lakhs records from a large table. But there is no effect on tablespace i.e. before I delete the data freespace in TS is 100MB , after deletion also it is showing 100MB. What could be the reason ? How to get the freespace after deleting the data ? Thanks rukmini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramasamy, Baskar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT, It's all about Alex
Chris, I would post my presentation on the list and maybe somebody will be able to decipher what I tried to present :-)(hint - locally managed tablespaces, temporary tablespaces and global temporary tables) but I think it will not be appreciated by the list owner and also because it is in PP format I don't think list software will allow it - so one way is to send me e-mail (please offline - [EMAIL PROTECTED]) and I will reply with presentation or wait until it will be posted on www.maop.org -Original Message- Sent: Wednesday, July 25, 2001 4:39 PM To: Multiple recipients of list ORACLE-L Alex did great. I learned a lot...err...just not sure what I learned. (grin) Unfortunely, I had to miss his second presentation. -Original Message- Sent: Wednesday, July 25, 2001 11:47 AM To: Multiple recipients of list ORACLE-L Alex, how did the paper/present go? -Original Message- Sent: Wednesday, July 25, 2001 10:42 AM To: Multiple recipients of list ORACLE-L Maybe some spelling errors in the abstract -:) Alex Hillman -Original Message- Sent: Wednesday, July 25, 2001 9:46 AM To: Multiple recipients of list ORACLE-L What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris
need procedure to extract DDL for table
Does anybody have stored procedure or PL/SQL script to extract DDL for the table? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
catparr.sql
Is there any sense to run catparr.sql if I do not use OPS? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT, WOW really early
Maybe some spelling errors in the abstract -:) Alex Hillman -Original Message- Sent: Wednesday, July 25, 2001 9:46 AM To: Multiple recipients of list ORACLE-L What is required to submit a paper/presentation to IOUGA and get excepted. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, July 24, 2001 8:41 PM To: Multiple recipients of list ORACLE-L IOUG 2002 call for papers already. Submit your presentation via the IOUG-A Web site at http://www.ioug.org/call-m no later than FRIDAY, SEPTEMBER 14, 2001. Mini Lesson and Technical Session presenters receive complimentary registration at IOUG-A Live! 2002 when your abstract is chosen! New for 2002 - Quick Tips! Share your unique and valuable tips during these new 30-minute presentations. Quick Tips provide great experience for first time presenters and allow experienced presenters to get to the heart of the matter. This is a presentation only - papers are not required. Plus, receive a discount on the Early Bird registration rate! joe -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Locally managed tablespaces
It does not need to do it. Also SMON will coalesce only if pctincrease0 and this is not a good idea. Alex Hillman -Original Message- Sent: Friday, July 20, 2001 8:41 AM To: Multiple recipients of list ORACLE-L consider this also.. if u make a tablespace as LMT, the SMON process is not going to coalesce it automatically.. as it in the case of dictionary managed TS. if i'm wrong.. pls correct. Saurabh Sharma [EMAIL PROTECTED] http://www.geocities.com/saurabh00pc/stride.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 5:16 AM Yes, you can make any tablespace a locally-managed tablespace except SYSTEM. What they're saying, I think, is that you can't set up temporary tablespaces and shouldn't set up rollback segments with the AUTOALLOCATE allocation management. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 19, 2001 4:32 PM I was pretty sure you could use it for any TS but SYSTEM. Is this documented? Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Jul 2001 09:32:27 Hillman, Alex wrote: You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: The Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
RE: Oracle Apps customization help working with consultants
Looks like they are doing most things right. Instead of fighting with them I would try to learn as much as possible from them. Alex Hillman -Original Message- Sent: Wednesday, July 18, 2001 7:01 PM To: Multiple recipients of list ORACLE-L First some background We are running on Unix 8.1.6 with 11i Apps. I know very little about Oracle Apps and I am the first DBA hired in house who has walked into several projects mid streams that consultants are working on and they continue to exclude me from design meeting and I get little or no information about the project. A consulting group is customizing 11i Apps. Part of this involves an EDI application that will take in files load them into staging tables that then will be loaded into the appropriate 11i App table. There are various Oracle and Crystal Reports that will be extracting information from these tables as well. Why use both... go figure... they are using Crystal for some reports and Oracle Reports for others. Just like some of the screens are being done in Forms and some done in ASP. These custom EDI app tables have 10 attribute columns defined as varchar2(100) in the middle of the table. These are extra columns to that may be used in the future for what ever reason. I have asked these be removed and real column names and data types be added as needed. They refuse saying they will have to redesign the forms they have created to use with these tables. Isn't is reasonable that the Forms should also reflect real column names not Attribute 1...10? Isn't it better to add columns to tables as I need them with an appropriate name and data type? At the very least I asked that they put these columns at the end of the table. They have agreed to this. They are also using a lot of sequences for Primary Keys instead of using columns from the table that would make an intelligent primary key and would be unique. They also have many columns as NUMBER that could be defined as NUMBER(3) or NUMBER(4). Is there any pros or cons to using NUMBER without defining a data length? That is besides the obvious that NUMBER you don't have to worry about losing precision data precision. Also they use a lot of char(1) in defining what they think will only be one character fields. I was under the impression that it was better to use varchar2(1)? Any comments... This is probably a trivial issue but I would like to know people's opinions. I am just a bit brain dead from arguing with them anyway about using a consistence naming convention, including me on the database design, etc. Even with renaming a column I get We are on a tight schedule and this would put us behind. Or this is how Oracle Apps works. My point is that Oracle Apps as a generic product and this EDI application shouldn't be made generic but specific to our company needs. That is not putting in this Attribute fields into all the EDI tables, using intelligent keys not sequence numbers, defining the data length of the NUMBER Fields. I am really worried about performance since I will have to maintain this in January after they are long gone. Any help or suggestions would be appreciated. Any good books to get me quickly up to speed on how to tune Oracle Apps? Thanks very much. Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: Locally managed tablespaces
You canuse any storage parameters you like but oracle will ignore them exept for initial for LMT with autoallocate. I would personally do not use autoallocate. Also you cannot use autoallocate for temporary tablespace and shouldn't use it for rollback. Alex Hillman -Original Message- Sent: Thursday, July 19, 2001 12:43 PM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: New Listener Question
: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sort segments
Are there any circumstances when temporary tablespace can contain more than 1 sort segment? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New Listener Question
In 8i you do not need to include services in the listener. Listener itself can find out what databases are running and need it services Alex Hillman -Original Message- Sent: Tuesday, July 17, 2001 12:35 PM To: Multiple recipients of list ORACLE-L First Off, I would like to thank everyone who replied yesterday, your answers were most helpful! Today, I am facing a new puzzle. I am currently running 3 databases on a server, but only two of them are listed in the listener.ora (bdw and rcvr). If I do a 'lsnrctl status' it shows a listener for all three databases (bdw rcvr and webprod). How is this possible? I have included my current listener.ora and output from 'lsnrctl status' ... Also, people who access these databases go through VIRTUAL ip's, i.e. the box itself has IP address xxx.xxx.xxx.11 the bdw ip is xxx.xxx.xxx.31 and the webprod ip is xxx.xxx.xxx.30 The reason for the virt ip's is for the fail over we have in place, so people do not have to reconfigure their machines when we move the databases around. So by all rights I do not see how anyone can connect, but they are?!?!?!? WTH??? Thanks again guys ... # LISTENER.ORA Configuration File:/apps/oracle/product/816/network/admin/listener.ora # Generated by Oracle configuration tools. LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 1521)) ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = bdw1)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /apps/oracle/product/816) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = bdw) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = bdw) ) (SID_DESC = (GLOBAL_DBNAME = rcvr) (ORACLE_HOME = /apps/oracle/product/816) (SID_NAME = rcvr) ) ) oracle@bdw1 SID: bdw /apps/oracle/product/816/network/admin lsnrctl status LSNRCTL for Solaris: Version 8.1.6.0.0 - Production on 17-JUL-2001 09:24:30 (c) Copyright 1998, 1999, Oracle Corporation. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC))) STATUS of the LISTENER Alias LISTENER Version TNSLSNR for Solaris: Version 8.1.6.0.0 - Production Start Date10-JUL-2001 15:14:01 Uptime6 days 18 hr. 10 min. 30 sec Trace Level off Security OFF SNMP OFF Listener Parameter File /apps/oracle/product/816/network/admin/listener.ora Listener Log File /apps/oracle/product/816/network/log/listener.log Services Summary... PLSExtProchas 1 service handler(s) WEBPROD has 2 service handler(s) bdw has 1 service handler(s) bdw has 1 service handler(s) rcvr has 1 service handler(s) The command completed successfully -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Last Update
-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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Last Update
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shreepad Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
RE: Multiple Listeners
Because the more listeners you have - the better. If your damager ask you how many listeners you are running and you answer one and he/she ( no sexizm :-)) heard that someone running 2 or 3 ( from another moro... err damager) - how would you explain why you are running only one. I hope that Ross can add more reasons to run at least 2 or better 3 listeners. Alex Hillman -Original Message- Sent: Monday, July 16, 2001 6:21 PM To: Multiple recipients of list ORACLE-L It is possible to define 3 listeners on 3 different ports, each one serving another database, but why would you do dat? You have 3 little databases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit from having 3 listeners? -Original Message- From: Edward W. Carr [mailto:[EMAIL PROTECTED]] Sent: Monday, July 16, 2001 5:42 PM To: Multiple recipients of list ORACLE-L Subject: Multiple Listeners Hello All, I am currently running Oracle 816 64bit on a Solaris 8 box. I have three databases on the system with one LISTENER for all of them. Is it possible to configure multiple listeners, one for each database? We have tried in the past with no success... If there is a document on the web somebody could point me to, that would be great! I have searched for one but must not be searching correctly. TIA, -- Edward W. Carr UNIX Systems Administrator Qwest Communications Broadband Services Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: view contents of datafile
I change it a little bit.
select a.tablespace_name, a.file_name, decode(b.file_id, NULL, 'No', 'Yes')
from dba_data_files a,
(select distinct a.file_id from dba_data_files a, dba_extents b
where a.file_id = b.file_id) b
where a.file_id = b.file_id (+)
order by 1,2
Alex Hillman
-Original Message-
Sent: Wednesday, July 11, 2001 9:15 PM
To: Multiple recipients of list ORACLE-L
This seems to work for me:
select a.tablespace_name, a.file_name, nvl(b.used,'No')
from dba_data_files a,
(select distinct a.file_id FILE_ID, 'Yes' USED from dba_data_files
a, dba_extents b where a.file_id = b.file_id) b
where a.file_id = b.file_id (+)
order by 1,2
When I specify a specific set of tablespaces on my system I get :
select a.tablespace_name, a.file_name, nvl(b.used,'No')
from dba_data_files a,
(select distinct a.file_id FILE_ID, 'Yes' USED from dba_data_files
a, dba_extents b where a.file_id = b.file_id) b
where a.file_id = b.file_id (+)
and a.tablespace_name in ('XPRPI','XPRPT')
order by 1,2
XPRPI /u07/oradata/DEMO/xprpi02.dbf No
XPRPI /u08/oradata/DEMO/xprpi01.dbf Yes
XPRPT /u02/oradata/DEMO/xprpi02.dbf Yes
XPRPT /u04/oradata/DEMO/xprpt03.dbf Yes
XPRPT /u06/oradata/DEMO/xprpt02.dbf Yes
XPRPT /u07/oradata/DEMO/xprpt01.dbf Yes
This is consistant since I just added the first file.
And, yes, there are utilities to look at the datafile. Oracle's Enterprise
Manager's Performance pack had a tool that will do that
-Original Message-
Sent: Wednesday, July 11, 2001 6:45 PM
To: Multiple recipients of list ORACLE-L
If my tablespace became so big that it had 3 datafiles
and became so fragmented, then I export and import
the whole databse, how can I tell if the REORG only
used up one or two datafiles.
OR is there a utility to see contents of a datafile?
Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leyden, Joseph
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: 9i standby
spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: A danger in cloning databases
Use localhost as hostname in listener.ora and you will never have this problem. Alex Hillman -Original Message- Sent: Wednesday, July 11, 2001 11:18 AM To: Multiple recipients of list ORACLE-L Jay, Did that several months ago with our HP-MPE box. The problem was that we changed the IP address of the box and brought a new one online, with the old ones original IP. Now MPE has NO idea of what a DNS server is so one has to bury the actual IP address into things like listener.ora and tnsnames.ora. We had a pile of this smelly brown matter all over the place the next evening when the new development box ran it's nightly processes. OOPS!!! Dick Goulet Reply Separator Author: Miller; Jay [EMAIL PROTECTED] Date: 7/11/2001 6:56 AM Many of you probably know this already, but it took me by surprise (and caused no end of grief) so I thought I'd warn people. I cloned our 8.0.4 production database onto another machine for some testing we were doing (copy of entire Oracle filesystem, copied hot backup over) and started it up with no problems. What I didn't realize when I ran my shutdown script (which also stops the listener) was that I hadn't changed the hostname in listener.ora. It stopped the listener on the production box! Had you asked me before this happened I wouldn't have expected it to work that way, but a number of irate users and managers testify to the fact that it does. I restarted the listener as soon as anyone thought to notify me of the problem (it says something about the processes here that it was 45 minutes after I restarted the listener that that our Help Desk contacted me me about the problem, I first heard about it from a developer). Sigh, learn something new every day. Hope someone out there benefits from my mistake. Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Second RBS in system tablespace
Also you need rollback segment in system when creating database if your rollback tablespace is LMT. Alex Hillman -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 11, 2001 4:44 PM To: Multiple recipients of list ORACLE-L Hello, SYSTEM rbs is reserved actions against the SYSTEM tablespace. There are some mis-conceptions against this issue. Actions against the SYSTEM tablespace can use non-SYSTEM rbs, too. For example, Recursive transactions,in other words: Oracle kernel transactions by SYS users, do not always have to use SYSTEM rbs. SYSTEM rbs is the last statation if there is no available slot in rbs in which current user transaction is assigned. So, Oracle kernel does not have to compete with user transactions. hope this helps... Kevin Lange wrote: As a guess I would think it was because the system tablespace is so active with all the queries against the catalog. -Original Message- Sent: Wednesday, July 11, 2001 12:03 PM To: Multiple recipients of list ORACLE-L Hi Everybody I'm running 8.1.7 and i just read that i should have a second rollback segment in the system tablespace. Can someone tell me why this is and how big should i create it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: gzip does not want to work with files 2G
I use version 1.3 for Solaris 5.8 - it is the same version that is on www.sunfreeware.com What version do you use and for which version on Solaris? Alex Hillman -Original Message- Sent: Monday, July 09, 2001 10:46 PM To: Multiple recipients of list ORACLE-L What version of gzip are you using? I had the same problem before, just had to get the latest version. Richard Ji [EMAIL PROTECTED] 07/09/01 07:12PM I have Solaris 5.8 angzip does not want to work with files 2G - tells that file is too large. Anybody has any idea why? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db-links question
If I query table in the remote database using database link does user in the remote database which is referenced in the database link create session in the remote database and if not could somebody explain how remote query is executed. Alex Hillman P.S. I know that I could try it myself but I am layzy (sp?) and tired (fighting with Ross for access to printing presses :-) ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle support phone number
Thanks to everybody who replied. Alex Hillman -Original Message- Sent: Monday, July 09, 2001 4:05 PM To: Multiple recipients of list ORACLE-L Could somebody give me support 800 or long dist. phone number. I know that I need to log itar first but this is a damagement request and I cannot find mine. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
gzip does not want to work with files 2G
I have Solaris 5.8 angzip does not want to work with files 2G - tells that file is too large. Anybody has any idea why? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export in cron
I beleave I asked this question already but did not get any answers. If I run export from cron and somehow userid is incorrect or dump file name is incorrect ( let say somebody renamed directory) - process of export is stopped. Is it possible to catch this situation in the same script that called export and if not - how to catch it? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: export in cron
Problem is that when export is stopped it does not return control to the script. Alex Hillman -Original Message- Sent: Friday, July 06, 2001 2:52 PM To: Multiple recipients of list ORACLE-L If I understood what you want clearly, In the same shell script, immediately after export command,have some grep command to look for errors in export log file.Depending on the sucess/failure($?) of grepping, have commands to do whatever you want. hth, Suren -Original Message- Sent: Friday, July 06, 2001 2:31 PM To: Multiple recipients of list ORACLE-L I beleave I asked this question already but did not get any answers. If I run export from cron and somehow userid is incorrect or dump file name is incorrect ( let say somebody renamed directory) - process of export is stopped. Is it possible to catch this situation in the same script that called export and if not - how to catch it? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to implement and use DBMS_STATS?
He asked about DBMS_STATS - not STATSPACK. I do not know any other source except docs and metalink describing DBMS_STATS. Alex Hillman -Original Message- Sent: Friday, July 06, 2001 1:47 PM To: Multiple recipients of list ORACLE-L Don Burleson just released (via Oracle Press) and entire BOOK on using STATSPACK. From: Jesse, Rich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to implement and use DBMS_STATS? Date: Fri, 06 Jul 2001 08:20:56 -0800 OK, enough is enough. For a month now, I've been researching on how one is supposed to implement and use the DBMS_STATS package. The FMs I R'd, Oracle 8.1.7's Designing and Tuning for Performance and Supplied PL/SQL Packages Reference, give the syntax and some very weak and incomplete examples, but fail to define how a DBA is actually supposed to USE the package in day-to-day operation. And Oracle Support just keeps pointing me back to inane and unrelated articles in MetaClink. Can anyone point out a website or a good book with a chapter on using DBMS_STATS for CBO? Specifically, some good examples, some definitions (when are stats considered stale?), what is the scope of GATHER_DATABASE_STATS (does it stat SYS???), under what circumstances GATHER_TABLE, GATHER_SCHEMA, and GATHER_DATABASE are to be used, and generally how the hell one goes about implementing this. I've now got less than two weeks to figure it out! And if you know this, where did you learn it? Even my Oracle Perf Tuning Class student guide mentions the package, says to use it, but then points to the syntax-only Oracle docs for more info. sigh Frustratedly yours, Rich Jesse System/Database Administrator (wannabe?) [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SAP R3 and Locally Managed Tablespaces
Maybe in the versions that they sertified LMT bugs were not fixed yet. What DB version do you use and on what platform? Alex Hillman -Original Message- Sent: Friday, July 06, 2001 2:31 PM To: Multiple recipients of list ORACLE-L In working with our SAP consultant, I've discovered that SAP may not yet support the use of LMT's on Oracle. Yes I know that SAP should not really care about this, but SAP seems to care about a number of things that would be best left to the DBA. Does anyone have experience with SAP and LMT's? TIA Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to implement and use DBMS_STATS?
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SAP R3 and Locally Managed Tablespaces
I am working with Peoplesoft now. It is easy enough to change tablespace description in Peoplesoft DD to LMT, change tablespace assignment for specific tables etc. I am going soon to implement LMT on 8.1.7 and also move part of insexes to different index tablespace. There is no problems with future upgrade if changes made in the Peoplesoft DD. Also I think that it was done pretty smart - description of objects in Peoplesoft DD and generation of DDL and SQL statements from this DD. Alex Hillman -Original Message- Sent: Friday, July 06, 2001 4:09 PM To: Multiple recipients of list ORACLE-L Jared, I can't say that I have used LMT's with our SAP installation, however, I constantly modify storage parameters, and I really don't see a difference. That being said, I know how much of a control-freak SAP is. The problem is that SAP puts tables/indexes in certain tablespaces based on functionality. For example, the BTABD tablespace contains all transaction, heavy I/O tables, while the STABD tablespace contains all master data and transparent tables, etc. So if you organize LMT's based on size/storage characteristics, you would have to have multiple BTABD, STABD, etc. tablespaces. That would be the only thing I can see SAP being nervous about. In order to do table reorgs, I do this in the sense that I have a BTABD and a BTAB2D tablespace that I reorg the table to/from. Sorry if you already knew all this, but maybe others would benefit. Jim In working with our SAP consultant, I've discovered that SAP may not yet support the use of LMT's on Oracle. Yes I know that SAP should not really care about this, but SAP seems to care about a number of things that would be best left to the DBA. Does anyone have experience with SAP and LMT's? TIA Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Schema organization
So what your DDL triggers are doing. And if they do not allow DDL to work how you can execute DDL - disabling these triggers? Alex Hillman -Original Message- Sent: Thursday, July 05, 2001 8:00 AM To: Multiple recipients of list ORACLE-L i try to play by the same rule as you. but if i can't then i put the ddl triggers on the tables owned by the schema owner, which keeps at least the strucutures from being altered. joe paquette stephane wrote: Hi all, I'm a fan of having the processing done by a user different than the owner of the data. Am I alone ? For example, we're on a datawarehouse system where the data owner is DWH. The etl tool repository owner is TOOL_POWERMART and the reporting tool repository owner is TOOL_BOWEBI. The etl processing is done by user DWH_PM_TRTMNT and the reporting processing is done by user DWH_BO_TRTMNT. This way, nobody is connecting as the data's owner. The developpers and Informatica (Powermart) consultant would prefer working directly as DWH. What do you think ? = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Pour faire vos courses sur le Net, Yahoo! Shopping : http://fr.shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing) -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: can/do indexes chain?
Update in the index is done as delete and insert, so there is no chaining. Alex Hillman -Original Message- Sent: Thursday, July 05, 2001 5:46 PM To: Multiple recipients of list ORACLE-L I've been asked to create an index which combines two fields, date location. For reasons I don't really want to explain, we need/desire this index to be in the order of date, location. The minor gotcha is that while location will be populated at the time the record is created, the date field is not updated until a later point in time. This date is a document print date. So this date field will be going from a NULL value to a non-null value. I recognize that this can result in record chaining in the data table. In thinking about this, I realized this could have a similar affect within the index. However, I've never read anything about index chaining. Do/can indexes chain? Should I be concerned about this? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 .NET? Not yet!San Diego, CA 92131 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PFILE location in NT
Title: PFILE location in NT It was true for versions before 8.1. Beginning with 8.1 default is the same as in unix - $ORACLE_HOME/dbs Alex Hillman -Original Message-From: DEMANCHE Luc (Cetelem) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, July 03, 2001 6:20 AMTo: Multiple recipients of list ORACLE-LSubject: RE: PFILE location in NT Hi Shahid, Did you specify a PFILE parameter in your startup ? If not, on NT, the default location for the parameter file is ORACLE_HOME\database. Your database is using the file in this location. Luc -Message d'origine-De: Shahid Nasir [mailto:[EMAIL PROTECTED]]Date: Tuesday, July 03, 2001 11:30 AMÀ: Multiple recipients of list ORACLE-LObjet: PFILE location in NT Hi all, I have two parameter files in two different directories on the same machine. Is there a way I can find out which parameter file is being used by the database. One way I tried was to make the changes in one file and see if it takes effect when the database is restarted. but I have more than 52 machines and it will be time consuming to do the same for all machines especially when these machines are on remote locations. Thanks. Shahid.
RE: Select only one of three tables
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daemen, Remco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SGA, miscellaneous keeps growing...
I was told by Metalink that I do not have access to this section on Metalink. How did you searched for it? Alex Hillman -Original Message- Sent: Tuesday, July 03, 2001 3:35 PM To: Multiple recipients of list ORACLE-L I found this in the metalink today since we plan to upgrade to 8.1.7.1: Try this thread: http://metalink.oracle.com/metalink/plsql/ml2_documents.showFOR?p_id=115437. 996p_showHeader=1p_showHelp=1 -Original Message- Sent: Tuesday, July 03, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Thank you, Kimberly, I've doublechecked the bug (did you mean this one 8171 [BUG:1240484] Shared server memory leak on repeated connect/disconnect ?), it doesn't seem applicable to my case - I dont use MTS, dedicated only. Thank you anyway, I feel more confidence to iTAR now, this is very likely some bug. Have a good day, Vadim -Original Message- Sent: Tuesday, July 03, 2001 2:23 PM To: Multiple recipients of list ORACLE-L It's a bug. The bug fix is out there. It seems to come from connect/disconnect. -Original Message- Sent: Tuesday, July 03, 2001 9:57 AM To: Multiple recipients of list ORACLE-L Hello, dear listers, I've got 8.1.7.1 installation on RH6.2 here. Runs smoothly, but I noted strange trend - SGA shared pool miscellaneous permanently keeps growing, approx rate 1MB per day. No suspicious messages in alert.log, no udumps. I've to bounce database to free this memory. Fortunately, now I can schedule this every weekend, but the fact itself troubles me. Nothing on Metalink. What looks specific about this database, I've got job using UTL_HTTP many times per day ... Did anybody experience this problem? Any idea where to look at? Thank you Vadim Gorbounov Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
RE: Sql question
I am sure you can get this with one of analitical functions. Alex Hillman -Original Message- Sent: Friday, June 29, 2001 2:37 PM To: Multiple recipients of list ORACLE-L I want to get every date between two user entered date's whether or not it exists in the table and then the quantity of data for the date if any exists. My table t1 has date and quantity values (may be more than one quantity field per date) and I want 0 for all dates in the range where no data exists. Is there a sql to get this without making some kind of date table? so if the user enters 03/02/01 and 03/06/01 they get. 03/02/0110 03/03/011 03/04/010 03/05/010 03/06/018 They want to load into a spreadsheet. tia. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Wher is an error ?
Thanks to everybody who answered. I had 2 errors - first I needed to put spaces before and after = and next I named the script as test and my directory was not first in the PATH and I did not use ./test - so it picked different test - Was too tired in the end of the day (or maybe this is something different :-) ) Alex Hillman -Original Message- Sent: Wednesday, June 27, 2001 6:50 PM To: Multiple recipients of list ORACLE-L 17:17:14:oracle8i@coin-app:/u07/export8i:ORUNDEF 513- userid=xxy 17:17:26:oracle8i@coin-app:/u07/export8i:ORUNDEF 514- if [ $userid=xxx ]; then echo 'aaa'; else echo 'bbb'; fi aaa 17:17:51:oracle8i@coin-app:/u07/export8i:ORUNDEF 515- why does it print aaa instead of bbb? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: authid definer
What is authid definer? Every day something new. Alex Hillman -Original Message- Sent: Thursday, June 28, 2001 7:04 AM To: Multiple recipients of list ORACLE-L One of our app development teams started out with lots of pl/sql and role based security, and found that roles are useless cause you have to grant the table level privs anyway to get the procedures to work. We are considering switching to Authid Definer for several reasons: - Roles need only contain execute privs for the procedures (no table level grants required) - private synonyms not needed anymore (all objects are resolved in the definers schema) - No need for table level GRANTs any more (cause all procedures/funcs run as the table/proc owner) Sounds too good to be true. Any gotchas to switching to authid Definer? Is this the preferred direction for app development, rather than the role/table grants nightmare? Rgds Mark Teehan Singapore ERG Group -- The contents of this email and any attachments are confidential and may only be read by the intended recipient. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Teehan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Fragmentation Locally Managed Tablespaces
want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Number of books sold 10000
I am simply qurious - what kind of book is successful and why. Alex Hillman -Original Message- Sent: Wednesday, June 27, 2001 8:01 PM To: Multiple recipients of list ORACLE-L Hello Alex, Is there a reason you are asking this question? Are you thinking of proposing a book? Ingram (http://www.ingram.com), a large book distributor, used to have a phone number that you could dial, punch in an ISBN number, and then hear Ingram's sales figures for that book for the current month. But that's only Ingram, and I don't know the number, nor do I know whether the service is still available. Most publishers don't divulge sales figures. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://MetalDrums.org Wednesday, June 27, 2001, 4:17:07 PM, you wrote: HA I am curious if data available of number of Oracle books copies sold. Sorry HA for being incredibly rude because this is apparently another thinly vailed HA attempt to find out how much money certain authors make :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT 24 x 7 on NT - ot
Title: RE: OT 24 x 7 on NT - ot At least your memory is good :-) Alex Hillman -Original Message-From: Mohan, Ross [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 5:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT 24 x 7 on NT - ot Lisa, my fine-feathered friend, i would have no idea what to write about. Clearly not oracle. And since i'd probably self-publish, I'd likely have to go mano a mano with Alex Hillman on the printing presses. It wouldn't be pretty, and besides, I still owe him a lunch. So...that leaves not much in the hopper. I am open to suggestions that do not involve me wearing speedos, passing by mirrors, or being available while the sun is up. sigh Ah well, back to tweaking the nanokernel assembler extensions for the russian mafia. - Ross -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, June 28, 2001 4:38 PMTo: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'Subject: RE: OT 24 x 7 on NT - ot Ross, have you ever considered becoming an author? I would buy your book :) Lisa Koivu Data Bored Administrator Ft. Lauderdale, FL, USA -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Thursday, June 28, 2001 3:50 PM To: Multiple recipients of list ORACLE-L Subject: OT 24 x 7 on NT? Everything. The whole Coast Guard. Everything just turned blue and froze. Then, someone using oracle with "read consistency" was able to order a replacement ship simultaneously with the guy who was removing the last ship from inventory, but fortunately for the USCG, Oracle doesn't let "writers block readers", so the order went through but was never fulfilled. Now, they're running DB2 on VMS on realtime nanokernel OS kiosks. -Original Message- Sent: Thursday, June 28, 2001 3:20 PM To: Multiple recipients of list ORACLE-L The software or the ship? --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Thursday, June 28, 2001 12:56 PM To: Multiple recipients of list ORACLE-L On one of their newer ships they were using NT, and it froze up a couple of times. -Original Message- Sent: Thursday, June 28, 2001 1:36 PM To: Multiple recipients of list ORACLE-L The Coast guard uses Unisys, too...but i don't know where NT fits in to their front line systems. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Number of books sold 10000
I am curious if data available of number of Oracle books copies sold. Sorry for being incredibly rude because this is apparently another thinly vailed attempt to find out how much money certain authors make :-) Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT RE: 24 x 7 on NT?
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Allen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Griping about auditing (not the Oracle Kind)
extents and growing rapidly was far more likely to cause problems was rejected on the grounds of if it ain't broke don't fix it. If you say it is broke then why is it we aren't having any problems? I wasn't looking for confirmation that this is silly (I know it is) so much as just wondering if anyone else has had to deal with this level of bureaucracy. And maybe a little commiseration :) Thanks for helping me get it off my chest, Jay Miller -Original Message- Sent: Monday, June 25, 2001 11:07 AM To: Multiple recipients of list ORACLE-L One of the reasons DBA's are paid well is that they have total control over the production data. No matter what rules the auditors put in place, a DBA could manipulate the data if they wanted to. The company should trust you to do your job and not put up read blocks that prevent you from maintaining the database and making changes in a timely manner. -Original Message- Sent: Monday, June 25, 2001 9:32 AM To: Multiple recipients of list ORACLE-L We've been through an internal audit and I was just wondering if anyone else has to deal with the rather ludicrous requirements I now have. In order to add or resize a datafile I now need to fill out a form and get Senior VP approval and the alert logs must be reviewed every day by a non-DBA in order to be certain that I didn't make any database changes without such approval. The auditors were horrified to discover that not only did I do such things whenever I thought them necessary but that we didn't have a non-DBA review everything I did after an Oracle upgrade to ensure I didn't install any other software. Fortunately I managed to convince them that yes, I really did need a Unix login (they were skeptical). So, any similar horror stories? Jay Miller Sr. Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
Storage allocation for LOB and LONG datatypes
I have several questions answers for wich I couldn't find in FM (not that I tried too hard :-) ). 1. If LONG or LOB takes more than 1 block - how part of the last block left free is used? Can it be used to store part of another LONG or LOB which more thatn this free peace? I think not but not tested. 2. What happens if LONG or LOB is updated? (again longer than 1 block). Which blocks are moved? Chained or migrated? 3. How rollback and redo generated for update? And how much? 4. Anything else interesting that I did not mention? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Griping about auditing (not the Oracle Kind)
Title: RE: Griping about auditing (not the Oracle Kind) I suggest CYA as much as possible and escalate the issue and begin search foranother job. Also if you are an FTE - now is a good time to go on vacation or become sick. Because if something breaks damagement knows much better how to avoid responsibility than we (at least most of us) are. For example it can be said that you did not explained an issue well enough etc. And you will show your e-mail to the damager of the damager who knows even less about Oracle. Alex Hillman (incredibly rude and cinical) -Original Message-From: Bowes, Chris [mailto:[EMAIL PROTECTED]]Sent: Monday, June 25, 2001 5:06 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Griping about auditing (not the Oracle Kind) In a perfect world or even a sucky world, yes. But the nightmare scenerio that was laid out wouldn't allow proactivity on their part. The inconvenient time thing was due to the fact that the proactive items they wanted to to do were rejected. They had a table that was diagnosed with too small extents and they wanted a bigger extent size. They submitted paperwork and a non-tech management type said 'no'. Does he disobey the rules and risk getting fired? They made other requests for day-to-day events and possible problems. They were rejected because "you cannot do that many changes". Do they risk their jobs and do what is needed, knowing eventually someone *WILL* find out and at that point they can/will be terminated for insubordination and failure to follow process or at least slapped down big for it? In all situations I had seen until here, I would say, yes, proactivity is a must and I know that we can look at any one item and get around rules that get our way. When it becomes a corporate culture, you really need to get the policy eliminated. The way to do that is to allow the people who can make these stupid decisions suffer. He simply said "OK, if that's the way you want to play it, then I'll do what you say. I will follow your rules and not fix things I see wrong because *you say I can't*. Of course, you wouldn't know a database problem if it jumped up and bit you and said, 'Hi I am a database problem', but that's irrelevant. I will do it your way and fix it when it breaks and you're franticly signing off on the same paperwork you rejected x days/months ago. Just don't expect a friendly call at 2 am when it happens..." I agree, we need to be proactive, however, the way I read this issue, they were proactive and lots of times when they made suggestions, they were rejected and their proactivity was rendered moot by people who have no clue. When that happens, it is wise to make them feel some pain for the decisions they make. --Chris [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, June 25, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: RE: Griping about auditing (not the Oracle Kind) Kimberly, We're on the same wavelength, as I was thinking the same thing. Procrastinating on something that you know needs to be done is not an ethical way of dealing with this, IMO. Jared Kimberly Smith [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] jitsu.com cc: Sent by: Subject: RE: Griping about auditing (not the Oracle Kind) [EMAIL PROTECTED] 06/25/01 10:15 AM Please respond to ORACLE-L I say that if you wait until you database has an error you really aren't proving much except that you are not proactive in your job. Which, in my book, makes you not a very good DBA. Dealing with a dumb process is one thing (we have our fair share on this account) but I take to much pride in my work to let things fail because I need to fill in a piece of paper. -Original Message- Sent: Monday, June 25, 2001 9:43 AM To: Multiple recipients of list ORACLE-L Wahey !!! The answer I was going to provide. We started calling the manager up quite frequently at home to authorise changes - he eventually saw sense. Not quite as bad as 2am in the morning but inconvenient enough for him to put a stop to it. Best of Luck. -Original Message- Sent: 25 June 2001 17:07 To: Multiple recipients of list ORACLE-L Jay; I have had to go thru the same thing a couple times on a previous job with Auditors. Every time those kind of restrictions were placed on us it brought things to a snails pace or, in some conditions, a complete halt. Sooner or later they realized that it was unreasonable and lifted them. But it was a pain until they did it. It took them a while to realize that we HAD to work the way we did in order to keep things running smoothly. I
How to suppress export, import intractivity
I run script in the background which contain export command. If userid wrong it give me message that job stopped (bash). Process is stopped and I can see it using ps command. Apparently it waits that username be entered interactively. I need automatically to terminate the process and print message in the log. Anybody have any suggestions? Alex Hillman This is a printowt of the log. Export: Release 8.1.7.0.0 - Production on Fri Jun 22 10:43:34 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon denied Username: -- STARTED PSDEV export @ Fri Jun 22 11:00:03 EDT 2001 Export: Release 8.1.7.0.0 - Production on Fri Jun 22 11:00:03 2001 (c) Copyright 2000 Oracle Corporation. All rights reserved. EXP-00056: ORACLE error 1017 encountered ORA-01017: invalid username/password; logon denied Username: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT - interviewing your superior
This guy may be very good to work for if the pay is hourly. Immediately cut all bs. And even if there is a lot of stupid things one has to do - at least one is paid. Alex Hillman -Original Message- Sent: Wednesday, June 20, 2001 9:35 PM To: Multiple recipients of list ORACLE-L no, the DBA is god. Okay, serious thought -- ask if they follow a project or people management style. The difference? project management is mostly concerned with GETTING IT DONE, with little or no regard for how ridiculous the deadlines are or how many hours the people are working. Prime example of this (and a job I did NOT take) is an interview I went on where the boss told me he believed in working his people until they were burned out, then he'd get new ones people management is subtler -- you make sure the people are professional, you make sure they are rewarded for the work they do, that you give them a day off on occasion, and work on reasonable deadline setting. Example? I started the Monday of Thanksgiving week. My boss said to me if you can get the reports working by Wednesday, you can have the day after Thanksgiving off... worked my butt off for that woman From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT - interviewing your superior Date: Wed, 20 Jun 2001 15:11:53 -0800 1) Do you realize that I am God, and you will always bow to my will? Scott Shafer San Antonio, TX 210-581-6217 I hate the country, all those animals walking around un-cooked. -Original Message- From: Daniel Curry [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 3:36 PM To: Multiple recipients of list ORACLE-L Subject:OT - interviewing your superior I am in a position to interview candidates who will ultimately be my boss. I am the net admin in a mixed Unix/Win/Linux environment, with Oracle databases, but no DBA (very simple databases). My question is for 'example' questions to ask these guys to get a full grasp of their management styles, political abilities, technical competencies, etc. Any suggestions would be useful. Thanks. Daniel Curry Systems Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Prompt in Korn shell
Thanks everybody who answered. Alex Hillman -Original Message- Sent: Wednesday, June 20, 2001 4:26 PM To: Multiple recipients of list ORACLE-L Anybody knows how to show current working directory and in general shell variable in Korn shell that prompt change when variable changes - for current working directory and ORACLE_SID for example. I know how to do it in bash but cannot do it right in Korn. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Prompt in Korn shell
Now I have another problem.
export PS1='$LOGNAME@$HOST:$PWD:${ORACLE_SID:-ORUNDEF}\n!-' - result is:
oracle8i@coin-app:/u01/app/psoft/PSTEST/appserv:PSTESTn133-
instead of
oracle8i@coin-app:/u01/app/psoft/PSTEST/appserv:PSTEST
133-
Looks like it does not understand \n as a new line character.
Any ideas please.
Alex Hillman
-Original Message-
Sent: Wednesday, June 20, 2001 4:26 PM
To: Multiple recipients of list ORACLE-L
Anybody knows how to show current working directory and in general shell
variable in Korn shell that prompt change when variable changes - for
current working directory and ORACLE_SID for example. I know how to do it in
bash but cannot do it right in Korn.
Alex Hillman
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: What the difference between qio and direct I/O option in VxFS
How do you specify direct I/O option in /etc/vfstab? Alex Hillman -Original Message- Sent: Wednesday, June 20, 2001 4:25 AM To: Multiple recipients of list ORACLE-L VxFS Direct I/O is enabled simply be specifying in the mount options in /etc/vfstab (on Solaris). You can do it even with standard ufs volumes. As long as you have vxfs then you can also have vxfs with direct IO Quick I/O is the separately licensed bit I think - it should also outperform Direct I/O. Still - I'm a fan of raw over either... Cheers Connor --- KC [EMAIL PROTECTED] wrote: Connor, Thanks for the info. Is Direct I/O licensed with the Veritas Volume manager or the Database edition?? We want to be able to avoid double buffering, sound like Direct I/O is what we want, however our SysAdmin insisted that we need to purchase the Database edition, I thought Direct I/O came with the VxFS file system, maybe the SysAdmin confused Direct I/O to raw ,please clarify?? KC -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Wednesday, June 20, 2001 2:53 AM Direct IO is the capacity to perform operations without the data being passed through the Unix buffer cache (it goes straight to/from the disks to the Oracle buffer cache) Quick IO is Veritas's simulation of raw datafiles - it presents the file to Oracle as if it were raw. hth connor --- KC [EMAIL PROTECTED] wrote: Dear List, What the difference between qio and direct I/O option in Veritas file system VxFS?? KC = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KC INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
export of longs
Am I correct that in 7.3.4 it was not possible to do direct export for tables with LONG datatypes and there is no such restriction in 8i? I tried 8i and it worked. I checked the docs for 7.3.4 and it does not tell that you cannot export LONGs with direct option, but I remember 2 years ago I couldn't do it in 7.3.3 when I tried. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Prompt in Korn shell
Anybody knows how to show current working directory and in general shell variable in Korn shell that prompt change when variable changes - for current working directory and ORACLE_SID for example. I know how to do it in bash but cannot do it right in Korn. Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo latch contention
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo latch contention
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). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: JDeveloper Connection to Oracle DB
JDBC thin driver does not use Net8. Another JDBC driver uses Net8 - OCI calls. Alex Hillman -Original Message- Sent: Saturday, June 16, 2001 5:00 PM To: Multiple recipients of list ORACLE-L Elias, I don't know much about JDBC, but I suspect that like ODBC it sits on top of the Net8 layer. By default, Personal Oracle on Win95/98 doesn't automatically start the listener the way the TNSlistener service does on NT/Win2K, so try manually starting the listener from the command prompt: lsnrctl start You can set the listener to start up up automatically by changing the registry entry LISTENER_STARTUP to AUTO hkey_local_machine\oracle\home0 HTH, -- Anita --- Elias Mouchantaf [EMAIL PROTECTED] wrote: Hi, I have installed JDeveloper 3.0 and I am running Oracle 8i personal edition on a Windows 98 platform. I am trying to create a connection to the DB from JDeveloper. I specify the Oracle JDBC Thin as driver and I select Existing TNS Names as the connection method and I choose the service running. When I click on the Test Connection button I get an error message that reads: Io Exception: The Network adapter could not establish the connection. I tried to resolve the problem but was unable to. I would appreciate any help. Thank you, Elias S. Mouchantaf Tel. (+961) 3 740319 [EMAIL PROTECTED] www.moshnet.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Elias Mouchantaf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sort_multiblock_read_count
This is from Metalink - The sort_multiblock_read_count parameter was introduced in Oracle8i. The parameter is similiar to db_file_multiblock_read_count in that it specifies the number of blocks to read at one time, in this case from a temporary segment, when it is necessary to merge information previously written out to a temporary segment. If the information needing to be sorted does not fit into the memory allocated to SORT_AREA_SIZE, sections of data are written to temporary segments in the form of sorted runs. Once all the data has been partially sorted to these runs, the runs are merged by reading pieces of them (i.e. based on sort_multiblock_read_count) from the temporary segment into memory to produce the final sorted output. If SORT_AREA_SIZE is not large enough to merge all the runs at once (which is likely to be the case as it was not large enough to perform the entire sort in memory to begin with), subsets of the runs are merged in a number of merge passes. Increasing SORT_MULTIBLOCK_READ_COUNT forces a larger section of each run to be read into memory during a merge pass. Needless to say, this must be balanced with SORT_AREA_SIZE. This reduces the merge width, or number of runs that can be merged in one merge pass, and may increase the number of merge passes. Each merge pass produces an intermediate run on disk, a run that contains all the data that was part of the runs that were just merged. Any increase in I/O throughput obtained by increasing SORT_MULTIBLOCK_READ_COUNT needs to be balanced with a possible increase in total amount of I/O performed due to an increase in the number of merge passes. So, you would not necessarily set sort_multiblock_read_count to the number of blocks that comprise an extent. -- As usual - many words and no answer how to select the value of this parameter. What memory is used inmerge phase? How it depends on SORT_AREA_SIZE? How much memory really lost when we increase this parameter from 1 to 2 let say etc. Aybody can clarify it? Oracle performance tuning 101 recommend using 1 or 2 whithout explanation (lost during development as too complicated as also discussion of new aging algorithm for buffer cache :-) ) Alex Hillman -Original Message- Sent: Friday, June 15, 2001 8:36 AM To: Multiple recipients of list ORACLE-L Because it is very possible and likely to have a sort area size much larger than the max io of the OS. Most os can only do 64-128k in a single io, not 10-20m. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, June 14, 2001 4:57 PM To: Multiple recipients of list ORACLE-L Hi All, Reading about the SORT_MULTIBLOCK_READ_COUNT init.ora parameter, I am wondering why it should ever be anything smaller or larger than the SORT_AREA_SIZE. Has anyone changed the default setting of this parameter for the better? Johnson Job __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: Sort_multiblock_read_count
After my previous post I found good explanation in Steve Adams web site using search for SORT_MULTIBLOCK_READ_COUNT. Alex Hillman -Original Message- Sent: Friday, June 15, 2001 8:36 AM To: Multiple recipients of list ORACLE-L Because it is very possible and likely to have a sort area size much larger than the max io of the OS. Most os can only do 64-128k in a single io, not 10-20m. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, June 14, 2001 4:57 PM To: Multiple recipients of list ORACLE-L Hi All, Reading about the SORT_MULTIBLOCK_READ_COUNT init.ora parameter, I am wondering why it should ever be anything smaller or larger than the SORT_AREA_SIZE. Has anyone changed the default setting of this parameter for the better? Johnson Job __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Tuning Sorts
I would make sort_area_retained_size = your average sort size. Otherwize your sorts which are executed in memory will dump result after sorting into temp tablespace and then server process will read it from there to return rows. Sort allocate memory in chunks of 8K, so you should worry only in case when there are too many users who are doing large sorts simultaniously. Also I think memory is freed when records returned ( I am not sure). Alex Hillman -Original Message- Sent: Friday, June 15, 2001 11:57 AM To: Multiple recipients of list ORACLE-L Hi All, Regarding Sorting. In my database memory sort is 99% compared to disk sorts. But the actual number of disk sorts are nearly 500 to 600 per week. This is a Data warehouse. I have a few large fact tables ranging from (45GB to 10GB). Some users do sort on the whole table. The top waits are Top 5 Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time --- db file scattered read 3,886,044 22,739,445 65.99 db file sequential read 9,582,4336,583,891 19.11 direct path read 9,514,5542,805,0848.14 direct path write 1,250,0331,732,9385.03 SQL*Net more data to client 735,751 122,820 .36 We have a weekly load into database. but during the week days no loading is done as all data and index tablespaces are made readonly. So the direct path read and write waits are from sort write and reads in the temp tablespace which uses tempfiles. DB_BLOCK_SIZE = 16K My plan is to use IXORA's formula SQRT(48318382080*65536*2/0.81) and set the SORT_AREA_SIZE = 88423692 SORT_AREA_REATINED_SIZE = 1M SORT_MULTIBLOCK_READ_COUNT = 4 My concern is that since I have dedicated server connections the sort area size allocated in the PGA will not be returned to the OS (although it is only for the life of the session) resulting in paging and swapping if too many users start big sorts. Please shoot down whatever you think is amiss. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Reorgs in general
Reorgs needed not only for space fragmentation but also for block fragmentation. Would be interesting to know if anybody has a good automated(scripts) system to decide for which objects block reorg is needed. Alex Hillman -Original Message- Sent: Friday, June 15, 2001 4:16 PM To: Multiple recipients of list ORACLE-L All, Oracle's party line has for a while been that for the most part reorgs aren't necessary anymore, right? Assuming storage initially has been set decently? Are reorgs very common in these parts? Also, even according to those who find reorgs still necessary, they should completely go away with LMT's, right? Opinions all? Thanks, Yosi Greenfield Oracle DBA, Will work for food [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forever running Analyze
Looks like nobody offered to increase sort_area_size for the session that is doing analyze -at least to such size that it will require only one merge phase. See Steve Adams web site for formula how to calculate the size, but I think that 20M should be more than enough. Alex Hillman [Hillman, Alex] -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
RE: Forever running Analyze
Also if you are analyze table compute statistics - you can do several command in parallel in different sessions analyze table ... compute statistics for table analyze table ... compute statistics for all indexes analyze table ...compute statistics for all indexed columns analyze table ...compute statistics for col1, col2, etc - for columns with squed values Alex Hillman -Original Message-From: Hillman, Alex [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 13, 2001 11:07 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Forever running Analyze Looks like nobody offered to increase sort_area_size for the session that is doing analyze -at least to such size that it will require only one merge phase. See Steve Adams web site for formula how to calculate the size, but I think that 20M should be more than enough. Alex Hillman [Hillman, Alex] -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Tuesday, June 12, 2001 5:31 PMTo: Multiple recipients of list ORACLE-LSubject: Forever running Analyze Hi folks; We have an Analyze running that is taking forever. Here is the setup: The table is about 250 bytes wide. The table is normally100,000 rows The table has grown to over 4,000,000 rows. There is one index on 1 column. We used the Compute Statistics options Does anyone have any suggestions on how we can get this analyze to complete and still generate worthwile statistics ?? Thanks Kevin
