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 >
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).
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).
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).
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: 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: db engines VS flat files
nication 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: 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). > > > > 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: 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: 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') a
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 ÎÞÁÄ£¿ÓôÃÆ£¿¸ßÐË£¿Ã»ÀíÓÉ£¿¶¼À´ÁÄÌì°É£¡¡ª¡ª ÑÅ»¢È«ÐÂÁÄÌìÊÒ! 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: 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> Hardware requirements when migration oracle from NT to Linux 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 -- 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).
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).
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: 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).
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: Spooling output of a select statement to a file through store
fiq 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: 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).
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: 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).
RE: Please Help - ora error
I knew that this was incorrect answer - and instead of pointing that I asked if he was sure. Alex Hillman -Original Message- Sent: Saturday, August 18, 2001 1:06 PM To: Multiple recipients of list ORACLE-L Alex: This is a fallacy that's been around since Oracle 6. In actuality, one wants to set the initial and next extents of a temporary tablespace to the same size as the size of the average sort in memory to ensure that most disk sorts can be accommodated within a single temporary tablespace extent. This avoids the unnecessary overhead of extent allocation. You can determine the size of the average disk sort with the following query: SELECT DECODE(disk_sorts, NULL, 0, 0, 0, ROUND((blocks_written * block_size) / disk_sorts, 0)) AS avg_sort_size FROM (SELECT VALUE AS disk_sorts FROM sys.v_$sysstat WHERE name = 'sorts (disk)') , (SELECT NVL(SUM(fs.phyblkwrt), 0) AS blocks_written FROM dba_data_files df , sys.v_$filestat fs , dba_tablespaces ts WHERE df.file_id = fs.file# AND df.tablespace_name = ts.tablespace_name AND ts.contents = 'TEMPORARY') , (SELECT TO_NUMBER(VALUE) AS block_size FROM sys.v_$parameter WHERE name LIKE 'db_block_size'); For example, I just ran this query against one of our production systems and it said the average disk sort was 61,349,888 bytes. Now, if I set sort_area_size to just 1M (1,048,576), then Oracle would have to do an additional 58 extent allocations, if the extents are not already present in a temporary tablespace, and would possibly increase the number of multiblock reads necessary to fetch the data in merging together the sorted result set. For more information on this topic, take a look at Steve Adams' website http://www.ixora.com.au. Jon Walthour -Original Message- Alex Sent: Friday, August 17, 2001 11:52 AM To: Multiple recipients of list ORACLE-L Are you sure enough to post an answer? Alex Hillman -Original Message- Sent: Friday, August 17, 2001 2:45 AM To: Multiple recipients of list ORACLE-L Hi In case of Temporary Tablespace the Initital segemnt and next segment should be equal to the sort_area_size parameter. bye G.Subrahmanyam -Original Message- Sent: Thursday, August 16, 2001 8:28 PM To: Multiple recipients of list ORACLE-L Hello all, I have a strage error. 'ORA-01658: unable to create INITIAL extent for segment in tablespace TEMP'. The clients TEMP tablespace is 200M. The sql is:- SELECT a.username, length(sql_text), substr(sql_text,1,100) as "SQL TEXT", substr(sql_text,101,250) as "Second TEXT", substr(sql_text,351,250) as "Third TEXT", substr(sql_text,601,250) as "Fourth TEXT", substr(sql_text,851,250) as "Fifth TEXT", substr(sql_text,1101,250) as "Sixth TEXT" FROM sys.dba_users a, v$session, v$sqlarea WHERE parsing_user_id=user_id AND address=sql_address(+) ORDER BY executions desc / Can you please explain why I am getting this error and cannot run the simple SQL statement? Rgds, raja 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: Viraj Luthra 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: G, Subrahmanyam (CAP) 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
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).
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).
RE: Please Help - ora error
Are you sure enough to post an answer? Alex Hillman -Original Message- Sent: Friday, August 17, 2001 2:45 AM To: Multiple recipients of list ORACLE-L Hi In case of Temporary Tablespace the Initital segemnt and next segment should be equal to the sort_area_size parameter. bye G.Subrahmanyam -Original Message- Sent: Thursday, August 16, 2001 8:28 PM To: Multiple recipients of list ORACLE-L Hello all, I have a strage error. 'ORA-01658: unable to create INITIAL extent for segment in tablespace TEMP'. The clients TEMP tablespace is 200M. The sql is:- SELECT a.username, length(sql_text), substr(sql_text,1,100) as "SQL TEXT", substr(sql_text,101,250) as "Second TEXT", substr(sql_text,351,250) as "Third TEXT", substr(sql_text,601,250) as "Fourth TEXT", substr(sql_text,851,250) as "Fifth TEXT", substr(sql_text,1101,250) as "Sixth TEXT" FROM sys.dba_users a, v$session, v$sqlarea WHERE parsing_user_id=user_id AND address=sql_address(+) ORDER BY executions desc / Can you please explain why I am getting this error and cannot run the simple SQL statement? Rgds, raja 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: Viraj Luthra 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: G, Subrahmanyam (CAP) 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[2]: Datafile Migration Tool
ate 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 PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
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 fr
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: 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: SQL tuning / optimization problem - IS NOT NULL - Clarify
AYMENT_METHOD VARCHAR2(30) REF_NUMBER 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,
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: 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: 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 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: ORA-00600 on Production DB - Need advice/Still Searching
limit > > 4194303 > > > > Any suggestions? > > > > David A. Barbour > > Oracle DBA, OCP > > AISD > > 512-414-1002 > > _ > 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: > 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!? 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: Evaluation questions
tage where I'm compiling a list of specific tasks I'd like to take the > > >contenders through and score them on same. > > >E.G. > > >Can package alert if Oracle DB goes down? > > >Can package alert if Control File extends? > > > > > >I'd appreciate your feedback on what you think the monitor package >should > > >be > > >able to do, ya know those things you want to know about before anyone > >else > > >does!. I'm particularly fishing for events that might be a bit more > > >obscure > > >yet still useful to monitor. > > > > > > > > >Sean :) > > > > > >Rookie Data Base Administrator > > >Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K > > >[0%] OCP Oracle8i DBA > > >[0%] OCP Oracle9i DBA > > > > > >Organon (Ireland) Ltd. > > >E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > > > > >Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > > > > >"Nobody loves me but my mother... and she 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)
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: 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: 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: 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.
RE: performance pl/sql for DW conclusion
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).
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: 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: 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).
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).
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).
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
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" | ||| || | || 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 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, 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 pctincrease>0 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] >
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: 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') an
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: RE: New Listener Question
y 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: 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).
RE: Last Update
is mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (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). = 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 EXA
RE: Last Update
ttp://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). = 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: 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: 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: private/public rollbacks
snippet from FM - part of alter rollback segment offline - can be done for privete and public rollback segments. OFFLINE Specify OFFLINE to take the rollback segment offline. If the rollback segment does not contain any information needed to roll back an active transaction, Oracle takes it offline immediately. If the rollback segment does contain information for active transactions, Oracle makes the rollback segment unavailable for future transactions and takes it offline after all the active transactions are committed or rolled back. Once the rollback segment is offline, it can be brought online by any instance. To see whether a rollback segment is online or offline, query the data dictionary view DBA_ROLLBACK_SEGS. Online rollback segments have a STATUS value of IN_USE. Offline rollback segments have a STATUS value of AVAILABLE. Alex Hillman -Original Message- Sent: Monday, July 16, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Lyuda, The chief advantage of private rollback segments is that you can take them offline if/when needed. A public rollback segment is online always consequently making it impossible to get out of the way of batch processes or doing any kind of maintenance on, unless your in restricted access mode. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 7/16/2001 10:06 AM Hi List, Who can tell me what advantages/disadvantages of having private rollback segments versus public rollback segments? Thank you. Lyuda Hoska -- 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: 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
from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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!? Get personalized email addresses from Yahoo! Mail http://personal.mail.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: 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: 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: 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: 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).
RE: db-links question
So you mean that connection to the remote DB stays open until session ends which issued query on remote DB. Are these connection dedicated? I think yes bur did not check. Is it possible to use MTS for such connection? And all new features like connection pooling etc. Alex Hillman -Original Message- Sent: Monday, July 09, 2001 6:55 PM To: Multiple recipients of list ORACLE-L Yes, it creates a session. If you want to do a(n) SQL trace, you can do a SELECT 'x' FROM dual@remote_site, find the session at the remote site and turn on the trace, then run your next query. Henry -Original Message- Sent: Monday, July 09, 2001 5:06 PM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras 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).
OT - get together for list participants in DC area
There will be MAOP DBA SIG meeting on July 20 from 1 to 4PM in Reston Oracle building. Details on www.maop.org I am doing presentation about LMT, temporary tablespaces and Global Temporary tables( very rude sel promo :-)). I think it can be good opportunity to meet. After that we can go to get couple of beers etc. I do not know that area very well, so any suggestions welcome. 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: 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).
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).
Oracle support phone number
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).
RE: Keeping up w/list Email
Is it possible to search in MS Outlook for something like Solaris and IO and size? When I enter solaris io size it gives me everything about solaris. I tried advanced fieatures but it looks like that there is only OR condution by default. Alex Hillman -Original Message- Sent: Monday, July 09, 2001 12:21 PM To: Multiple recipients of list ORACLE-L I agree, I do exactly the same - though I AutoArchive anything older than 3 days.. Outlook really does rock when you exploit its full potential.. -Original Message- Sent: Monday, July 09, 2001 04:00 To: Multiple recipients of list ORACLE-L Liberal use of Outlook filters and AutoArchive. I generally scan the list of threads each morning, and follow the ones that look interesting, usually ignore the rest (unless it's a slow day). AutoArchive cleans out everything more than a week old whether I've read it or not, to an off-line .PST where I can search it. I know all the "cool kids" hate Microsoft, but Outlook truly rocks, I'm never going back to Pine or Netscape. g -Original Message- Sent: Monday, July 09, 2001 2:20 PM To: Multiple recipients of list ORACLE-L Not sure how others handle getting behind on mail, but work lately leaves me precious little time to keep up. Just spent the better part of a month clawing back through 6000 odd messages that queued up after a period away from the list. My curiosity lies w/how others handle the situation. I've always been reluctant to can the folder contents, as there's always gems hidden in there somewhere. Now I'm totally caught up and it's a bloody big relief. Gems were there too. :-) Anyone find themselves in the same boat from time to time or do you just click, shift+left mouse and delete em' all? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Dyke 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: Guy Hammond 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: Mark Leith 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
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: How to implement and use DBMS_STATS?
ing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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?
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. > >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: 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).
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: RE: RULE versus CHOOSE
Histogramms make sence only for columns with skewed data and only if literals used in where clause - not bind variables. To improve optimizer you need to change parameters OPTIMIZER_INDEX_CACHING and OPTIMIZER_INDEX_COST_ADJ. Get an article The Search for Intelligent Life in the Cost-Based Optimizer from www.evdbt.com - it ex-plains use of these parameters. Also check your parameter DB_FILE_MULTIBLOCK_READ_COUNT - maybe you need to increase it depending on your platform and your block size and your max IO size (Solaris 5.5 and up it is configurable) and your extent sizes. Alex Hillman -Original Message- Sent: Friday, July 06, 2001 10:55 AM To: Multiple recipients of list ORACLE-L Tom: I never did any official benchmark studies, per se. I studied the CBO/histograms about 4 months ago when we were converting an app over from Oracle 7 to 8i. The new version of the app had queries that were very different from its earlier version and so performance on 8i as compared to 7 was dramatically worse. Of course, the app owners blamed the database. In the course of my defense of the db, I discovered that the data (being primarily composed of case studies) was severely skewed to the more recent dates (i.e., the further back you went, the sparser the number of cases). I discovered that the optimizer was doing a lot of range scans for queries when it should have been doing full table scans according to the CBO thresholds. Histograms on certain date fields throughout the schema dropped times on certain large report queries from 30 minutes to under 2. That's all I know. I can't give you an hard empirical evidence, just anecdotal evidence that, when properly used, histograms do seem to have dramatic impacts. -- Jon Walthour, OCDBA Oracle DBA Computer Horizons Cincinnati, Ohio >--- Original Message --- >From: "Terrian, Tom" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 7/6/01 9:20:24 AM > >Jon, > >Great write up. > >Several times you mentioned creating Histograms for skewed data distributions. >I am just curious if you have ever studied the performance impact with and >without them? We used to maintain histograms but when we studied the >performance impact (with and without them) we determined that there was very >little benefit with histograms. The down side with them is that they >drastically increased the amount of time it took to analyze the tables at night. >We decided to do without them. Have you ever studied their benefits verse >drawbacks? > >Tom > >Tom Terrian >Oracle DBA >WPAFB - DAASC >[EMAIL PROTECTED] >937-656-3844 > -- 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).
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: 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: 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. 996&p_showHeader=1&p_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 ORACL
RE: Select only one of three tables
o 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: 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: 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. 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).
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: Fragmentation & Locally Managed Tablespaces
-- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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).
Wher is an error ?
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).
RE: OT RE: 24 x 7 on NT?
but as I can see its already too late > for some :) > > Thanks, > jon > > > "The idea that Bill Gates has appeared like a knight in shining armor to > lead all customers out of a mire of technological chaos neatly ignores the > fact that it was he who, by peddling second- rate technology, led them into > it in the first place." > > -- Douglas Adams > > "If you have trouble sounding condescending, find a Unix user to show you > how it's done." > > -- Scott Adams > > ---trim--- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > 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 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).
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: Griping about auditing (not the Oracle Kind)
A on another database had his request to increase the next extent size > on a table refused on the grounds that "what if this change causes the > database to go down?". His explanation that having a table that was over > 5,000 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 con
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 for another 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
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)
I agree with you, however in one of my previous contracts one guy decided to add datafile to the database. He aadded a 2G file and database for several minutes did only one thing - created datafile. Application servers were shut down because they checked DB every 5 sec or something like that. There was a big fass because even several minutes of downtime were not acceptable for this app. This guys even considered to sue Oracle (this guy was Oracle consultant). Alex Hillman -Original Message- Sent: Monday, June 25, 2001 11:32 AM To: Multiple recipients of list ORACLE-L Jay, You did not say what type of an employer you are currently at, so it is tough to comment. I have seen *very* strict controls put into place at various places of employment. It sounds like you are at a gov't facility where audit and control is serious business. You have three choices: 1). try and work thru the system to show why this is a bad idea - like let the system go to hell and explain that you would have fixed it, but have been waiting for a signature from the VP. 2). flood the VP with so many requests that he/she sees how ridiculous the requirement is. 3). if all else fails, start looking for another job. at exit interview time, explain that the audit process is NOT conducive to business standards. hope this helps Tom Mercadante Oracle Certified Professional -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: 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: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,
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: 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: 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: 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).
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).
