exp73 dumpparam for unlimited extents?
Hello, Running Oracle 7.3.4.4 on Win2k. Trying to implement unlimited extents of the same size. (Same size works for us). Set the tablespace defaults Dumped the users Dropped the users Imported the users Tables still had the same mish-mash of extents and max extents 121 Here are my dump params USERID = system/@** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = Y buffer=100 consistent=y compress=n That did not work so I tried dumping an individual user USERID = system/*@*** FILE = c:\dumps\test.dmp LOG = c:\dumps\test.log FULL = N COMPRESS = N owner=restek Still get mish-mash extents on import. The load was always: USERID = system/**@* FILE = c:\dumps\test.dmp LOG = c:\dumps\test.dmprs.implog FROMUSER = restek TOUSER = restek My quick test of create table tmp_xyz as select * from xyz gives me the result I want. Any suggestions? Do I have to wait until I upgrade to 8i or 9i? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Monical INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback OPTIMAL setting
Don, 9i has system managed undo -- you don't think it works yet? Rachel --- Don Granaman <[EMAIL PROTECTED]> wrote: > I prefer to have OPTIMAL set and deal with "long running large > transactions" > another way - setting "OPTIMAL" on the developers! Granted, this > doesn't > work for 3rd party products, but I usually deal with in-house > applications. > Getting this to work requires: (1) having enough rollback segments, > (2) > large enough rollback segments that extends almost never occur, and > (3) NOT > having the "one giant rollback segment for large jobs", and, most > importantly, (4) all "batch-lookin' thingies" have to be reviewed by > the DBA > and optimized, by either the DBA or the developer - or both, until > they pass > muster. Using this, I rarely seen an ORA-01555 or a rollback shrink > (over > six months on the systems I'm working with now) - and when I do, I > know that > it (usually) means that somebody broke rule #(4). When that happens, > I > track it down and work with the developer to fix it. My experience > is that > the vast majority of developers are receptive - they actually like to > have > their code run without problems. > > Of course, this assumes that the "wasted" disk space for (1) and (2) > is not > a significant issue. It rarely is, but I work almost exclusively > with > (essentially) OLTP systems where space is typically less critical > than I/O > throughput capability and reliability. Usually, we have to add disks > for > performance rather than space. The database datafile drives are > typically > 36 GB (less often 18 GB) and are rarely "full", so a GB or two more > for > rollback tablespace is OK. If I had to operate under the space > constraints > that many seem to have, I might not set OPTIMAL either. > > I am looking forward to the day that this "no OPTIMAL" suggestion > fades into > the "myths and folklore" category. Either because of basic policy > changes > (e.g. the extents myth), a better Oracle algorithm (e.g. 10i system > managed > undo???), more intelligently designed batch processes in > applications, or > the trend towards ever-increasing drive size. > > Note: All this doesn't mean that I don't understand why so many use > the > "manual shrink" method. My philosophy differs in that not setting > OPTIMAL > should be a last resort, not a blanket policy. > > Don Granaman > [OraSaurus] > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, June 27, 2002 10:13 AM > > > One of the constant comments regarding rollback segments is not to > set > optimal. I am wondering why this setting is often discouraged. I have > my own > ideas, but I want to gather more opinions and experiences. > > Daniel W. Fink > Sr. Oracle DBA > MICROMEDEX > 303.486.6456 > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Don Granaman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.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).
Re: rbs oracle data block corrupted
Atul, Using "_OFFLINE_ROLLBACK_SEGMENTS" or "_CORRUPTED_ROLLBACK_SEGMENTS" might allow you to open the database, but there is an almost absolute certainty that you will hopelessly corrupt the data in the database in doing so. So this is not a solution, this is the absolute very LAST resort. Instead, using these parameters usually means that you will be initiating a complete dump all of the data out of this database in order to load it into a "fresh" new uncorrupted one. Please do NOT consider using these parameters unless you've exhausted all other possibilities, and absolutely do NOT use them without logging a SEV-1 TAR and having an Oracle Support analyst on the phone throughout. The danger of these parameters is that just about everyone has heard about them, but very few clearly understand how they work and the implications. Roughly put, the "_OFFLINE_ROLLBACK_SEGMENTS" parameter means that Oracle will attempt to determine whether the transaction has been committed or rolled back. If it can, it will put things right. If it can't, Oracle will just simply commit the transaction. Of course, it may have been that the transaction was never committed, thus corruption. Roughly, the "_CORRUPTED_ROLLBACK_SEGMENTS" parameter means that the rollback segment in question is hopeless, and Oracle will simply commit any uncommitted transaction that were using it. Again, this is very scary... --- The best solution to data block corruption? Data block corruption should first be treated exactly like media failure. That is, exactly like a failed disk drive. Restore an older copy of the datafile from a backup that occurred prior to the detection of the corruption, and recover forward until a complete recovery has been performed. But first, before doing even that, please verify that the database block indicated is really corrupt. The ALTER SYSTEM DUMP DATAFILE BLOCK command will make a symbolic dump of the block to a ".trc" file in your USER_DUMP_DEST directory. The error message has the "file#" and "block#" values in it, so please use those then examine the resulting ".trc" file. If it truly is corrupt, there will some obvious indication the ".trc" file (i.e. it'll say "corrupted"). Then, please backup the datafile in question before restoring over it, just out of caution. Or, if you know how, rename the datafile and restore it from backup to the new location. Either way, don't wipe out the datafile with the corruption if you can help it... Hope this helps... -Tim - Original Message - From: Nikunj Gupta To: Multiple recipients of list ORACLE-L Sent: Saturday, June 29, 2002 4:23 PM Subject: Re: rbs oracle data block corrupted In Init.ora there is some setting to ignore using ROLLBACK Segments. Talk to Oracle support and try that. Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Danisment Gazi Unal (ubTools) To: Multiple recipients of list ORACLE-L Sent: Saturday, June 29, 2002 11:43 AM Subject: Re: rbs oracle data block corrupted Hi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com
Re: ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
Tim, Excellent Mate, You are 100% right. I just did it. (some how my mind didn't work) Can you please explain me a bit more about check point not complete error. Cheers Mate, Ravi --- Tim Gorman <[EMAIL PROTECTED]> wrote: > No big mystery. When they run it in the other > database, they generate less > than 2000 bytes of output. When it fails, it is > overflowing the buffer of > 2000 bytes, as the error message indicates. > > If they continue to argue, then don't argue back. > Just prove it by setting > the buffer size higher to allow the output to come > out, and then compare > spooled output. Nothing stops an argument faster > than proof... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Saturday, June 29, 2002 2:08 PM > > > > Hi Tim, > > > > Thanks for the response, but that is not the > > point,here developers question is why it is > working in > > > > other database? (sure they haven't set anything > over > > there) > > > > thanks, > > ravi > > > > --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Ravi, > > > > > > The DBMS_OUTPUT package stores all output from > > > PUT_LINE commands into a > > > buffer, and this error indicates you are > overflowing > > > this buffer. The > > > default size is 2000. If you are executing from > > > SQL*Plus you can change the > > > size of the DBMS_OUTPUT buffer using the "SET > > > SERVEROUTPUT ON SIZE n", where > > > "n" is 100 or less... > > > > > > Alternatively, if you are not using SQL*Plus, > then > > > you can change the buffer > > > size using "DBMS_OUTPUT.ENABLE(n)", where "n" is > the > > > size... > > > > > > Hope this helps... > > > > > > -Tim > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" > > > <[EMAIL PROTECTED]> > > > Sent: Saturday, June 29, 2002 11:38 AM > > > > > > > > > > Dear All, > > > > > > > > When We run simple pl/sql we are getting the > > > follwoing > > > > error > > > > ORA-2: ORU-10027: buffer overflow, limit > of > > > 2000 > > > > bytes. > > > > > > > > But the fact is it is running fine in another > > > database > > > > Completely on different server). > > > > > > > > I have compared the following thigs please let > me > > > know > > > > if there is anything else to check other than > the > > > > follwoing one's. > > > > > > > > 1) DB version is same on both the site i.e > > > 8.1.7.0.0 > > > > 2) source for dbms_output is same both the > > > systems. I > > > > even checked it from dba_source text and > > > everything is > > > > equal. > > > > 3) we don't specify anything in either > login.sql > > > or > > > > glogin.sql. > > > > 4) pl/sql simple one is running same same one > is > > > > running. > > > > > > > > Please let me know if I miss anything else > other > > > than > > > > the above. > > > > > > > > Cheers, > > > > ravi. > > > > > > > > > __ > > > > Do You Yahoo!? > > > > Everything you'll ever need on one web page > > > > from News and Sport to Email and Music Charts > > > > http://uk.my.yahoo.com > > > > -- > > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > > -- > > > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services-- (858) 538-5051 > > > FAX: (858) 538-5051 > > > > San Diego, California-- Public > Internet > > > access / Mailing Lists > > > > > > > > > > > > > > To REMOVE yourself from this mailing list, > send an > > > E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling > of > > > 'ListGuru') and in > > > > the message BODY, include a line containing: > UNSUB > > > ORACLE-L > > > > (or the name of mailing list you want to be > > > removed from). You may > > > > also send the HELP command for other > information > > > (like subscribing). > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Tim Gorman > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > FAX: > > > (858) 538-5051 > > > San Diego, California-- Public Internet > > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send > an > > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > > 'ListGuru') and in > > > the message BODY, include a line containing: > UNSUB > > > ORACLE-L > > > (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!? > > Everything you'll ever need on one web page > > from News and Sport to Email and Music Charts > > http://uk.my.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: >
Re: rbs oracle data block corrupted
In Init.ora there is some setting to ignore using ROLLBACK Segments. Talk to Oracle support and try that. Make a FREE long distance call from your PC!http://www.eboom.com/free/ - Original Message - From: Danisment Gazi Unal (ubTools) To: Multiple recipients of list ORACLE-L Sent: Saturday, June 29, 2002 11:43 AM Subject: Re: rbs oracle data block corrupted Hi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com
Re: performance
Ravi, ARCHIVELOG isn't "obviously slow"; it is the default method of operation for most Oracle installations. Your experience is not the norm (though not uncommon, to be sure!), so I'm sure it can be fixed (unless your system is grossly underconfigured). If you have some form of contention in the redo log generation/archival stream, then it will be slower than NOARCHIVELOG, but most of the range of possible problems are quite easily dealt with. Rather than speculate in the absence of information, it would be best if you gather hard data to pinpoint exactly where the problems are... I would suggest enabling STATSPACK, but doing so is somewhat involved. To determine if you want to do this, the best documentation is online in a file called "spdoc.txt" located in the "$ORACLE_HOME/rdbms/admin" directory. There are also notes and bulletins on MetaLink as well as other sites on the internet (search www.google.com for STATSPACK). For more immediate results, please run the "utlbstat/utlestat" scripts during a period of about 20-30 minutes while you are experiencing "slowness". Take the resulting "report.txt" file (generated by "utlestat.sql" from SVRMGRL) and upload it to the http://www.oraperf.com website in order to get a YAPP analysis report, which is returned in HTML format. You have to register for a login to use that site and it's facilities, but it is free and well worth the 30 seconds involved... If you need help interpreting the output from the YAPP report, then please paste the original "report.txt" report into an email back to this list and I'm sure a couple folks would be delighted to run a YAPP report with it and help interpret it with you. There are no security issues with the data in a "report.txt" or STATSPACK report, unless your datafile names are classified :-). Also, there are several "white papers" on the http://www.oraperf.com site which explain the methodology of "response time analysis" using the YAPP report which might help; click on the link for "white papers" in the left-hand navigation bar... Hope this helps... -Tim - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 1:13 PM > Dear All, > > Can any one please give me some hints or tips when we > move to archive mode? when Our DB is non-archive mode > that was ok,when we moved to Archive, it is dead slow. > > Obviosuly archive mode performance is slow, is there > any other precations to be taken care? > > Thanks for your help. > Cheers, > Ravi > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Nalla=20Ravi?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-20000: ORU-10027: buffer overflow, limit of 2000 bytes
No big mystery. When they run it in the other database, they generate less than 2000 bytes of output. When it fails, it is overflowing the buffer of 2000 bytes, as the error message indicates. If they continue to argue, then don't argue back. Just prove it by setting the buffer size higher to allow the output to come out, and then compare spooled output. Nothing stops an argument faster than proof... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 2:08 PM > Hi Tim, > > Thanks for the response, but that is not the > point,here developers question is why it is working in > > other database? (sure they haven't set anything over > there) > > thanks, > ravi > > --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Ravi, > > > > The DBMS_OUTPUT package stores all output from > > PUT_LINE commands into a > > buffer, and this error indicates you are overflowing > > this buffer. The > > default size is 2000. If you are executing from > > SQL*Plus you can change the > > size of the DBMS_OUTPUT buffer using the "SET > > SERVEROUTPUT ON SIZE n", where > > "n" is 100 or less... > > > > Alternatively, if you are not using SQL*Plus, then > > you can change the buffer > > size using "DBMS_OUTPUT.ENABLE(n)", where "n" is the > > size... > > > > Hope this helps... > > > > -Tim > > > > - Original Message - > > To: "Multiple recipients of list ORACLE-L" > > <[EMAIL PROTECTED]> > > Sent: Saturday, June 29, 2002 11:38 AM > > > > > > > Dear All, > > > > > > When We run simple pl/sql we are getting the > > follwoing > > > error > > > ORA-2: ORU-10027: buffer overflow, limit of > > 2000 > > > bytes. > > > > > > But the fact is it is running fine in another > > database > > > Completely on different server). > > > > > > I have compared the following thigs please let me > > know > > > if there is anything else to check other than the > > > follwoing one's. > > > > > > 1) DB version is same on both the site i.e > > 8.1.7.0.0 > > > 2) source for dbms_output is same both the > > systems. I > > > even checked it from dba_source text and > > everything is > > > equal. > > > 3) we don't specify anything in either login.sql > > or > > > glogin.sql. > > > 4) pl/sql simple one is running same same one is > > > running. > > > > > > Please let me know if I miss anything else other > > than > > > the above. > > > > > > Cheers, > > > ravi. > > > > > > __ > > > Do You Yahoo!? > > > Everything you'll ever need on one web page > > > from News and Sport to Email and Music Charts > > > http://uk.my.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > > -- > > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 > > FAX: (858) 538-5051 > > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > > (or the name of mailing list you want to be > > removed from). You may > > > also send the HELP command for other information > > (like subscribing). > > > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Tim Gorman > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (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!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Nalla=20Ravi?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also
OCP - Completed first OCA exam - hand-on $$$ course is waived.
hello, I'm sure most of you guys here are aware that to get an OCP after June 15 would cost you extra $$$ since a hands-on course is required. But this only applies to people who took the first OCA exam after June 15. My question is: If you completed the first exam before June 15 but 'FAILED'. Does this mean you are still exempted from taking the hands-on or ar you required to take the $$$ hands-on? No pun please, ok? I admit, I failed the first exam on my first take by two points (argh). Thanks for any input. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-20000: ORU-10027: buffer overflow, limit of 2000 bytes
Hi Tim, Thanks for the response, but that is not the point,here developers question is why it is working in other database? (sure they haven't set anything over there) thanks, ravi --- Tim Gorman <[EMAIL PROTECTED]> wrote: > Ravi, > > The DBMS_OUTPUT package stores all output from > PUT_LINE commands into a > buffer, and this error indicates you are overflowing > this buffer. The > default size is 2000. If you are executing from > SQL*Plus you can change the > size of the DBMS_OUTPUT buffer using the "SET > SERVEROUTPUT ON SIZE n", where > "n" is 100 or less... > > Alternatively, if you are not using SQL*Plus, then > you can change the buffer > size using "DBMS_OUTPUT.ENABLE(n)", where "n" is the > size... > > Hope this helps... > > -Tim > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Saturday, June 29, 2002 11:38 AM > > > > Dear All, > > > > When We run simple pl/sql we are getting the > follwoing > > error > > ORA-2: ORU-10027: buffer overflow, limit of > 2000 > > bytes. > > > > But the fact is it is running fine in another > database > > Completely on different server). > > > > I have compared the following thigs please let me > know > > if there is anything else to check other than the > > follwoing one's. > > > > 1) DB version is same on both the site i.e > 8.1.7.0.0 > > 2) source for dbms_output is same both the > systems. I > > even checked it from dba_source text and > everything is > > equal. > > 3) we don't specify anything in either login.sql > or > > glogin.sql. > > 4) pl/sql simple one is running same same one is > > running. > > > > Please let me know if I miss anything else other > than > > the above. > > > > Cheers, > > ravi. > > > > __ > > Do You Yahoo!? > > Everything you'll ever need on one web page > > from News and Sport to Email and Music Charts > > http://uk.my.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: =?iso-8859-1?q?Nalla=20Ravi?= > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Tim Gorman > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
stop oracle instance on ha standby give out the 7445 error message.
hi, £¬ RDBMS Version: 8.1.7.2 Operating System and Version: Sun solaris 7 Error Number (if applicable): 7445 Product (i.e. SQL*Loader, Import, etc.): Product Version: 8.1.7.2 stop oracle instance on ha standby give out the error message. Hei, This is a solaris7/Veritas VCS1.3/Oracle 8172 HA database, the primary database is on 4500, and the HA standby is on 3500.We have another oracle standby database on 3500.So, when primary database failover to 3500, there are two instance running on that 3500, one sid is biddb, and another sid is standby, with the same database name biddb in the same oracle home. When we shutdown the primary database from the 3500 and move back to 4500, oracle always give out error message from 3500: at Jun 29 22:30:43 2002 Shutting down instance (immediate) License high water mark = 31 Sat Jun 29 22:30:51 2002 ALTER DATABASE CLOSE NORMAL Sat Jun 29 22:30:52 2002 SMON: disabling tx recovery SMON: disabling cache recovery Sat Jun 29 22:31:00 2002 Thread 1 closed at log sequence 8591 Sat Jun 29 22:31:02 2002 Completed: ALTER DATABASE CLOSE NORMAL Sat Jun 29 22:31:02 2002 ALTER DATABASE DISMOUNT Sat Jun 29 22:31:04 2002 ARC0: Completed archiving log# 5 seq# 8590 ARC0: thread not mounted ARC0: archiving disabled or thread not mounted Sat Jun 29 22:31:04 2002 Completed: ALTER DATABASE DISMOUNT archiving is disabled Sat Jun 29 22:31:05 2002 ARCH shutting down ARC0: Archival stopped Sat Jun 29 22:31:12 2002 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_20047.trc: ORA-07445: exception encountered: core dump [0001015C04E8] [SIGSEGV] [Address not mapped to object] [350] [] [] Sat Jun 29 22:31:12 2002 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_20051.trc: ORA-07445: exception encountered: core dump [0001015AE510] [SIGSEGV] [Address not mapped to object] [100] [] [] Sat Jun 29 22:31:13 2002 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_20053.trc: ORA-07445: exception encountered: core dump [0001015AE510] [SIGSEGV] [Address not mapped to object] [100] [] [] Sat Jun 29 22:31:13 2002 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_20055.trc: ORA-07445: exception encountered: core dump [0001015AE510] [SIGSEGV] [Address not mapped to object] [100] [] [] Sat Jun 29 22:31:13 2002 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_20057.trc: ORA-07445: exception encountered: core dump [0001015AE510] [SIGSEGV] [Address not mapped to object] [100] [] [] Sat Jun 29 22:31:13 2002 Errors in file /export/home/oracle/admin/biddb/udump/biddb_ora_20059.trc: I post it here to see if someone can help? Or someone have the same error? Thanks. Good luck chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Nalla Ravi£¬ Does your database have too much log switch, so make logfile unable to be reused? is archivelog process unable to catch up? What is in the alert file? and what is the wait event from v$session_wait during slow time? Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-29 11:13:00 You wrote: >Dear All, > >Can any one please give me some hints or tips when we >move to archive mode? when Our DB is non-archive mode >that was ok,when we moved to Archive, it is dead slow. > > Obviosuly archive mode performance is slow, is there >any other precations to be taken care? > >Thanks for your help. >Cheers, >Ravi > >__ >Do You Yahoo!? >Everything you'll ever need on one web page >from News and Sport to Email and Music Charts >http://uk.my.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: =?iso-8859-1?q?Nalla=20Ravi?= > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-20000: ORU-10027: buffer overflow, limit of 2000 bytes
Nalla Ravi£¬ÄúºÃ£¡ hi, SQL>set serveroutput on size 2000 and retry. Good luck! chaos [EMAIL PROTECTED] zhu chao DBA of Eachnet.com 86-021-32174588-667 ÔÚ 2002-06-29 09:38:00 You wrote: >Dear All, > >When We run simple pl/sql we are getting the follwoing >error >ORA-2: ORU-10027: buffer overflow, limit of 2000 >bytes. > >But the fact is it is running fine in another database >Completely on different server). > >I have compared the following thigs please let me know >if there is anything else to check other than the >follwoing one's. > >1) DB version is same on both the site i.e 8.1.7.0.0 >2) source for dbms_output is same both the systems. I >even checked it from dba_source text and everything is >equal. >3) we don't specify anything in either login.sql or >glogin.sql. >4) pl/sql simple one is running same same one is >running. > >Please let me know if I miss anything else other than >the above. > >Cheers, >ravi. > >__ >Do You Yahoo!? >Everything you'll ever need on one web page >from News and Sport to Email and Music Charts >http://uk.my.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: =?iso-8859-1?q?Nalla=20Ravi?= > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chaos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-20000: ORU-10027: buffer overflow, limit of 2000 bytes
Ravi, The DBMS_OUTPUT package stores all output from PUT_LINE commands into a buffer, and this error indicates you are overflowing this buffer. The default size is 2000. If you are executing from SQL*Plus you can change the size of the DBMS_OUTPUT buffer using the "SET SERVEROUTPUT ON SIZE n", where "n" is 100 or less... Alternatively, if you are not using SQL*Plus, then you can change the buffer size using "DBMS_OUTPUT.ENABLE(n)", where "n" is the size... Hope this helps... -Tim - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Saturday, June 29, 2002 11:38 AM > Dear All, > > When We run simple pl/sql we are getting the follwoing > error > ORA-2: ORU-10027: buffer overflow, limit of 2000 > bytes. > > But the fact is it is running fine in another database > Completely on different server). > > I have compared the following thigs please let me know > if there is anything else to check other than the > follwoing one's. > > 1) DB version is same on both the site i.e 8.1.7.0.0 > 2) source for dbms_output is same both the systems. I > even checked it from dba_source text and everything is > equal. > 3) we don't specify anything in either login.sql or > glogin.sql. > 4) pl/sql simple one is running same same one is > running. > > Please let me know if I miss anything else other than > the above. > > Cheers, > ravi. > > __ > Do You Yahoo!? > Everything you'll ever need on one web page > from News and Sport to Email and Music Charts > http://uk.my.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?Nalla=20Ravi?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
performance
Dear All, Can any one please give me some hints or tips when we move to archive mode? when Our DB is non-archive mode that was ok,when we moved to Archive, it is dead slow. Obviosuly archive mode performance is slow, is there any other precations to be taken care? Thanks for your help. Cheers, Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rbs oracle data block corrupted
Hi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com
ORA-20000: ORU-10027: buffer overflow, limit of 2000 bytes
Dear All, When We run simple pl/sql we are getting the follwoing error ORA-2: ORU-10027: buffer overflow, limit of 2000 bytes. But the fact is it is running fine in another database Completely on different server). I have compared the following thigs please let me know if there is anything else to check other than the follwoing one's. 1) DB version is same on both the site i.e 8.1.7.0.0 2) source for dbms_output is same both the systems. I even checked it from dba_source text and everything is equal. 3) we don't specify anything in either login.sql or glogin.sql. 4) pl/sql simple one is running same same one is running. Please let me know if I miss anything else other than the above. Cheers, ravi. __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dblink / global names explanation please
8.1.6 on NT I have java installed and a java email package on instance A on a server. One the same server on instance B with global names set to false I created a public database link to instance A, then created a public synonym javamail for my email routine at A. This worked. On a third instance ( C ) on this same server with gobal names set to true (do you see where this is going) I did the same thing as I had done on instance B - but I couldn't use a short name - I had to use the full A.moto.com. Then I created a public synonym for the [EMAIL PROTECTED] This kept returning an error - couldn't find class com/moto/utils/mail - this is a home grown java class in the database A. I could not find anything different between the two setups other than one had global names set to false and the other had global names set to true (after many hours of looking and head banging) - so I just tried setting global names to false on instance C and bounced the database - went back and created a new short named public database link and then created the public synonym. It now worked ? WHY ?? can any one tell why this works or doesn't as the case may be? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: the ora certified masters cert - finally bloody sick
You have to take prescribed Oracle University's Instructor Let Training Classes (ILT). Please note that it is not guaranteed that one passes OCP after reading these Guides. From my experience most questions are based on the material in those Guides. - Kirti -Original Message- Sent: Saturday, June 29, 2002 9:43 AM To: Multiple recipients of list ORACLE-L Hi Kirti, >From where can i get Student Guides to pass OCP Nitheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: Rollback OPTIMAL setting
I prefer to have OPTIMAL set and deal with "long running large transactions" another way - setting "OPTIMAL" on the developers! Granted, this doesn't work for 3rd party products, but I usually deal with in-house applications. Getting this to work requires: (1) having enough rollback segments, (2) large enough rollback segments that extends almost never occur, and (3) NOT having the "one giant rollback segment for large jobs", and, most importantly, (4) all "batch-lookin' thingies" have to be reviewed by the DBA and optimized, by either the DBA or the developer - or both, until they pass muster. Using this, I rarely seen an ORA-01555 or a rollback shrink (over six months on the systems I'm working with now) - and when I do, I know that it (usually) means that somebody broke rule #(4). When that happens, I track it down and work with the developer to fix it. My experience is that the vast majority of developers are receptive - they actually like to have their code run without problems. Of course, this assumes that the "wasted" disk space for (1) and (2) is not a significant issue. It rarely is, but I work almost exclusively with (essentially) OLTP systems where space is typically less critical than I/O throughput capability and reliability. Usually, we have to add disks for performance rather than space. The database datafile drives are typically 36 GB (less often 18 GB) and are rarely "full", so a GB or two more for rollback tablespace is OK. If I had to operate under the space constraints that many seem to have, I might not set OPTIMAL either. I am looking forward to the day that this "no OPTIMAL" suggestion fades into the "myths and folklore" category. Either because of basic policy changes (e.g. the extents myth), a better Oracle algorithm (e.g. 10i system managed undo???), more intelligently designed batch processes in applications, or the trend towards ever-increasing drive size. Note: All this doesn't mean that I don't understand why so many use the "manual shrink" method. My philosophy differs in that not setting OPTIMAL should be a last resort, not a blanket policy. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, June 27, 2002 10:13 AM One of the constant comments regarding rollback segments is not to set optimal. I am wondering why this setting is often discouraged. I have my own ideas, but I want to gather more opinions and experiences. Daniel W. Fink Sr. Oracle DBA MICROMEDEX 303.486.6456 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: the ora certified masters cert - finally bloody sick
Hi Kirti, >From where can i get Student Guides to pass OCP Nitheesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pullikol Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: the ora certified masters cert - finally bloody sick
Kirti, I've got that book if you want it. joe Deshpande, Kirti wrote: >To pass OCP tests, one has to follow whatever the Student Guides say :-) >What is right or wrong is not what is tested in OCP, but what's in those >guides that you get in those ILT classes from OU. >That's why I am looking for 8i NF Student Guides (I can't locate mine since >our move to our new 42 sq ft cubicles a few months ago ;) > >- Kirti > > >-Original Message- >Sent: Friday, June 28, 2002 12:14 PM >To: Multiple recipients of list ORACLE-L > > >Kirti, > >Im curious If you scored 100%, what was your answer >on that performance question when your cache hit ratio was >not 99+% ? > >Mike > >-Original Message- >Sent: Friday, June 28, 2002 7:53 AM >To: Multiple recipients of list ORACLE-L > -- 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).
RE: Hints being ignored
A hint is absolutely, positively a DIRECTIVE, not a suggestion. Jonathan can explain if you have doubts. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Jul 9-11 New York City - Hotsos Clinic, Jul 23-25 Chicago - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas -Original Message- Sent: Friday, June 28, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Hints used to be more like that. hints are more like "do it" nowadays, their aggressiveness has gone up. joe basher 59 wrote: > When putting in hints, remember this bit of advise. A hint is just a > hint. Oracle may choose today to use your hit and tomorrow it may > not. I don't like using hints for this reason, and I usually try and > rewrite the query if I can. Have you analyzed the table lately. If > the table is not analyzed, it may not use the indexes. > > >> From: Robertson Lee - lerobe <[EMAIL PROTECTED]> >> Reply-To: [EMAIL PROTECTED] >> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> Subject: Hints being ignored >> Date: Fri, 28 Jun 2002 06:13:19 -0800 >> >> All >> >> Oracle 8.0.5.0.0 >> >> Tru64 4.0f >> >> Select statement as follows. The hint is being totally ignored. Any >> ideas ?? >> >> Regards >> >> Lee >> >> SELECT /*+ INDEX(CONSUMER_COMM_D2C CONSUMER_COMM_D2C_PK) */ >> i.household_id >> || '|' || 'd' >> || '|' || d.promotion_item_id >> || '|' || xp.campaign_id >> || '|' || xp.document_id >> || '|' || xp.segment >> || '|' || xd.contact_type_code >> || '|' >> FROM genex_individual i >> , consumer_comm_d2c d >> , x_promotion_item xp >> , x_document xd >> WHERE i.brief_name = '$brief_name' >> AND i.individual_id = d.consumer_id >> AND d.promotion_item_id = xp.promotion_item_id >> AND xp.document_id = xd.document_id >> ORDER >> BY i.household_id >> ; >> >> Table CONSUMER_COMM_D2C is as follows >> >> NameNull?Type >> --- >> CONSUMER_ID NOT NULL NUMBER(9) >> PROMOTION_ITEM_ID NOT NULL NUMBER(9) >> COMMUNICATION_DATE NOT NULL DATE >> COMMUNICATION_STATUS_CODEVARCHAR2(2) >> COMMUNICATION_DETAIL VARCHAR2(500) >> BLOCK_LDT NOT NULL DATE >> ROW_CHANGE_SOURCE NOT NULL NUMBER(9) >> ROW_CHANGE_TIME DATE >> ROW_CHANGE_USERIDVARCHAR2(50) >> >> Index CONSUMER_COMM_D2C_PK is built as follows >> >> consumer_id >> promotion_item_id >> communication_date. >> >> The table is partitioned on promotion_item_id and the indexes on the >> partitions are local >> >> Explain plan is as follows >> >> >> Operation Object Name Rows Bytes Cost TQ In/Out PStart PStop >> >> SELECT STATEMENT 1440 G 106 G >> >> SORT ORDER BY 1440 G 171770G 106 G >> >> MERGE JOIN 1440 G 171770G 17 M >> >> SORT JOIN 13 M 1G 300284 >> >> HASH JOIN 13 M 1G 10271 >> >> TABLE ACCESS FULL X_PROMOTION_ITEM 7 K 409 K 10 >> >> MERGE JOIN CARTESIAN 2 M 90 M 3206 >> >> TABLE ACCESS FULL X_DOCUMENT 1 K 25 K 6 >> >> SORT JOIN 1 K 31 K 3200 >> >> TABLE ACCESS FULL GENEX_INDIVIDUAL 1 K 31 K 2 >> >> SORT JOIN 1 G 39G 17 M >> >> PARTITION CONCATENATED 1 26 >> >> TABLE ACCESS FULL CONSUMER_COMM_D2C 1 G 39G 1352283 1 26 >> >> >> >> >> >> * >> >> 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. Thank You. >> > > > > > Over and out Basher 59 > > > _ > MSN Photos is the easiest way to share and print your photos: > http://photos.msn.com/support/worldwide.aspx > -- 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: Cary Millsap
RE: Installing 8.17 and 9.2 on one machine
Hi Bill For a start, I'll use the 9.2 listener to serve 9.2 and 8.1.7, but I kept the 8.1.7 stuff and will try it out soon. Thanks for the hint. Regards, Stefan -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/28/2002 7:38 PM I'm sure there are changes but I'm connecting to 9i database via 8i listener without any problems - Bill. At 03:04 26/06/02 -0800, you wrote: >Hi everybody > >I'm looking for the pitfalls in a mixed 8.1.7 / 9.2 environment. >We're running 8.1.7 for development on Linux (SuSE 7.3). >Now I want to install 9.2 on the same machine. I was thinking of >getting rid of the 8.1.7 listener and having the 9.2 one serving >both the 9.2 and the 8.1.7 instances. Or can I just use the 8.1.7 >listener for 9.2 (is there even a change in the listener software ??). > > > > > >-- >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: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
does anyone has encounter problem browsing the web
hi, after installing oracle forms,reports and designer. there are web pages that i couldn't browse w/c i could before using ie. one examples are the links in www.oracle.com. click these links go to a blank page w/ message"done:error on thispage". clicking the symbol yellow triangle w/ "!" shows the 3 ff: error s 1.line 12 char 69 error:unterminated string constant code :0 url:http://oracle.com/ip/deploy/database/oracle9i/ 2. line 3 char 1 error: object expected 3. line 13 char 1 error. langjsload isundefined #2&3 has same url and code as of #1 can anybody help me w/ this? lin Best regards, Grace Lim IT Department Suy Sing Comm'l Corp. T- (632)-2474134 F- (632)-2474160 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).