Rollback segments size calculation
Hi all I am getting ORA-01555 in my database and the solution is to create huge rollback segments but my doubt is how to calculate the size of this huge rollback segments . Now I have 24 G of space in rollback segment tablespace .But still i am getting the error.The environment is datawarehouse and loading happens almost every time except at night . and while loading data loading updataion and deletion happens frequently .Please help me in calculating the size of huge rollback segment . Happy Christmas and New year to all Regards, Shibu DISCLAIMER: This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission. winmail.dat
undo tablespace and rollback segments in oracle9i
I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: undo tablespace and rollback segments in oracle9i
Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select segment_name, tablespace_name from dba_rollback_segs; SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: undo tablespace and rollback segments in oracle9i
The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: undo tablespace and rollback segments in oracle9i
hi , please look attached file ; -Original Message- Sent: Wednesday, July 30, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Bahar, Arslan Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select segment_name, tablespace_name from dba_rollback_segs; SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com encoded content removed -- binaries not allowed by ListGuru
RE: undo tablespace and rollback segments in oracle9i
yes . What should i do -Original Message- Sent: Wednesday, July 30, 2003 5:30 PM To: Multiple recipients of list ORACLE-L The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: undo tablespace and rollback segments in oracle9i
If you are now running in manual undo mode and have created rollback segments, you can remove the undo segments. Verify that the segments are offline and you are not using them. Then drop the undo tablespace. This is the only way to get rid of them. [EMAIL PROTECTED] wrote: yes . What should i do -Original Message- Sent: Wednesday, July 30, 2003 5:30 PM To: Multiple recipients of list ORACLE-L The scenario you describe is not consistent with manual undo. Was the database created/started with automatic undo and you have switched to manual? [EMAIL PROTECTED] wrote: I use manual managed undo tablespace but there are some system named rollback segments on that tablespace ( I did not created them ) and they can not be dropped. What are they , how can I drop them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).begin:vcard n:Fink;Daniel tel;cell:303.808.3282 tel;work:303.272.3225 x-mozilla-html:TRUE adr:;; version:2.1 email;internet:[EMAIL PROTECTED] title:DB Services Lead x-mozilla-cpt:;-4832 fn:Daniel Fink end:vcard
RE: undo tablespace and rollback segments in oracle9i
Your attachment was removed by the list server. However, your direct e-mail to me had the following: SQL show parameter undo ; NAME TYPEVALUE --- -- undo_management string MANUAL undo_retention integer 900 undo_suppress_errors boolean FALSE undo_tablespace string rbs SQL SQL select segment_name, tablespace_name from dba_rollback_segs; SEGMENT_NAME TABLESPACE_NAME -- -- SYSTEM SYSTEM _SYSSMU1$ RBS _SYSSMU2$ RBS _SYSSMU3$ RBS _SYSSMU4$ RBS _SYSSMU5$ RBS _SYSSMU6$ RBS _SYSSMU7$ RBS _SYSSMU8$ RBS _SYSSMU9$ RBS _SYSSMU10$ RBS SEGMENT_NAME TABLESPACE_NAME -- -- RBS01 RBS RBS02 RBS RBS03 RBS RBS04 RBS RBS05 RBS RBS06 RBS 17 rows selected. SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; USN NAME STATUS -- -- --- 0 SYSTEM ONLINE 11 RBS01 ONLINE 12 RBS02 ONLINE 13 RBS03 ONLINE 14 RBS04 ONLINE 15 RBS05 ONLINE 16 RBS06 ONLINE 7 rows selected. --- So, it is clear that RBSnn were created in an undo tablespace titled RBS. To remove system managed undo segments (_SYSSMUn$) one must drop the undo tablespace itself. But, in your case, you will first have to: 1. Create a new, normal tablespace, say, rollback_ts, to hold new rollback segments (do not create it using create undo tablespace ) 2. Create required rollback segments (rbs07, rbs08 etc) in rollback_ts. 3. Bring them all online. 4. Offline RBS01 to RBS06 and drop them. 5. Drop tablespace RBS. Modify init.ora parameter as required. Hope this helps. - Kirti --- [EMAIL PROTECTED] wrote: hi , please look attached file ; -Original Message- Sent: Wednesday, July 30, 2003 3:52 PM To: [EMAIL PROTECTED] Cc: Bahar, Arslan Your question is not very clear. Sorry. Can you please post results of following commands? Thanks. - Kirti SQL show parameter undo SQL select segment_name, tablespace_name from dba_rollback_segs; SQL select a.usn, a.name, b.status 2 from v$rollname a, 3 v$rollstat b 4 where a.usn = b.usn; --- [EMAIL PROTECTED] wrote: __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling
Undo Tablespace vs Rollback segments
Can anyone point me to an article or white paper that goes into detail on this. When I RTFM, it just says use Undo TBS, don't worrry about it and all your problems will be solved. We are upgrading from Oracle8 to 9i and currently have Rollback segments in 4 tablespaces spread over 4 disks. It looks like you can specify multiple data files, but I can't find anything on how they would be used. I know that striping would spread the load, but that is not an option. Thanks, Keith Moore Oracle Certified Professional 972-431-5126 [EMAIL PROTECTED] The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
RE: exp, dbms_stats, RMAN and rollback segments
Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: exp, dbms_stats, RMAN and rollback segments
HELP... Has anyone encountered rollback problems while running dbms_stats? -Original Message- Sent: Thursday, May 29, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: exp, dbms_stats, RMAN and rollback segments
A Large Load or Update Before the Exp ... Delyed Block Clean out is one Reason that really pops out. HTH Best Regards, Ganesh R DID : +65-6215-8413 HP : +65-9067-8474 === Live to learn... forget... and learn again. === -Original Message- Sent: Friday, May 30, 2003 12:15 AM To: Multiple recipients of list ORACLE-L A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ganesh Raja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: exp, dbms_stats, RMAN and rollback segments
Steve, You may have to dig a little further... What happened to those table(s) in that schema prior to starting the export? Heavy DML, may be? This could be a case of 'delayed block cleanout'. Export triggered the cleanout and wanted to access the rollback segments. If no table data was modified after export started reading that table, then there is no need to read RBS info (except for the DBC case, IMO). - Kirti --- Orr, Steve [EMAIL PROTECTED] wrote: Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: exp, dbms_stats, RMAN and rollback segments
Hi Kirti, Sounds like you have the same suspicions as do we. So far as we know there isn't any heavy duty DML before the export and there isn't any other activity on the schema other than RMAN and DBMS_STATS. We don't understand how RMAN or DBMS_STATS ***could*** be the culprit but we've seen WEIRDNESS before. We host our webapp and upgrades are customer driven. (Shivers and shudders!) Upgrades often entail database changes so the application shuts out end user access and kicks off an export before changing tables, munging data, updating the code, etc. This process has been fairly automagic and the export went along about 5 minutes before it crapped out. The only known difference between this upgrade run and other successful ones is that dbms_stats was running. So now I've copied the data into our test environment in an effort to duplicate the error and walk through our code. Luckily it's not written in Perl so it won't be too hard to read. :-) Also, Walt found some delayed block cleanout issues on Metalink associated with analyzing indexes. The DBMS_STATS.GATHER_TABLE_STATS(...) routine in question is using the cascade option so I'm beginning to smell smoke. There are a few docs on Metalink about how ORA-01555's can occur even when NO updates are being performed but statistics are being gathered. WEIRDNESS!! See DocID's 367016.995; 17730.996; 45895.1; 89633.996; 61552.1. UNFORTUNATELY... the solutions proposed are not very appealing. Meanwhile we're trying to convince others that Oracle is better than MySQL even though MySQL continuously updates its optimizer statistics and doesn't have problems like this. :-( And proposing a blockout period when customers are not allowed to upgrade while maintenance operations are going on would not be very well received. Especially since it's not an issue with MySQL and how we keep talking about how Oracle is a better 24X7 solution for our 24X7 webapp. Arghh! Big sigh while contemplating a lot of tedious work and getting nowhere... And I had to get up at 2:30 A.M. this morning to help fix the outage. Whine, whine, whine... Steve -Original Message- Sent: Thursday, May 29, 2003 11:51 AM To: [EMAIL PROTECTED] Cc: Orr, Steve Steve, You may have to dig a little further... What happened to those table(s) in that schema prior to starting the export? Heavy DML, may be? This could be a case of 'delayed block cleanout'. Export triggered the cleanout and wanted to access the rollback segments. If no table data was modified after export started reading that table, then there is no need to read RBS info (except for the DBC case, IMO). - Kirti --- Orr, Steve [EMAIL PROTECTED] wrote: Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: exp, dbms_stats, RMAN and rollback segments
When one runs dbms_stats how often is the data committed? Before Oracle exports a table it needs to gather information about it such as the columns comprising it. I wonder if this information also includes data changed by dbms_stats and/or RMAN. We used to have similar problems when exporting while an application was doing quite a few drop tables and CTAS's. However that pretty much went away with 8.1.7. Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Thursday, May 29, 2003 9:15 AM To: Multiple recipients of list ORACLE-L Oh yeah, for the export consistent=N -Original Message- Sent: Thursday, May 29, 2003 9:14 AM To: '[EMAIL PROTECTED]' A certain alignment of the planets occurred creating a good ole ORA-01555 error... A user level export received the snapshot too old error and terminated. Concurrent to this was an RMAN backup and DBMS_STATS.GATHER_TABLE_STATS(...) which was being run on the same schema being backed up via the user level export. There was no other end user access to the schema data. Since exp got the error I assume it was reading from the rollback segments but why? I'm suspecting dbms_stats. We have ample RBS. Is there any significant undo generated by dbms_stats or RMAN which could create this problem? (Of course we need to improve our job scheduling but that's another issue, the timing of the user level export is application driven and out of our control). Befuddled in Bozeman, Walt and Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segments on 8.1.7.4
I will have to check your question on 'fewer sorts'. As far as changes to the SQL statements, there were 1 or 2 sql statements changed in the application because they no longer worked efficiently with the change to 8.1.7. But, on the whole (lets say 98%+ of the time) no changes were made. -Original Message- Sent: Monday, March 10, 2003 5:39 PM To: Multiple recipients of list ORACLE-L Did any of the rollback segment storage parameters (i.e. INITIAL, NEXT, PCTINCREASE, MINEXTENTS, MAXEXTENTS, OPTIMAL) or the number of rollback segments change between 8.0.5 and 8.1.7? Changes to any of these variables could impact the space available for storing inactive undo blocks for read-consistency purposes. If the answer is of course not, then here comes the harder question: did the SQL statements change between 8.0.5 and 8.1.7? Not just outright different SQL statements, but even the same SQL statements running with different execution plans? For example, changing explain plans so that SORT-MERGE join is no longer use could have significant impact on ORA-01555, as forcing sorts are one way to minimize SNAPSHOT TOO OLD. Having queries run faster is another way to minimize ORA-01555, so getting rid of SORT-MERGE joins will likely help, but if the performance improvements aren't good enough, then the conversion to HASH or NESTED LOOP joins may allow more ORA-01555 to occur. Have you noticed fewer sorts occurring since 8.0.5? Just some ideas... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:59 PM Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segments on 8.1.7.4
Dan; Everything remained the same on the DB except the version. No changes made. -Original Message- Sent: Monday, March 10, 2003 5:34 PM To: Multiple recipients of list ORACLE-L Kevin, The ORA-01555 errors are almost certainly symptoms, not the actual problem. It has been a few years since I tested an 8.0.x db, but I do not recall seeing any changes in rollback segments from 7.3 to 8.1. Have you converted from Dictionary to Locally managed RBS tablespaces? When you upgraded, did you change any of the settings, like OPTIMAL, for the rollback segments? Were they dropped and recreated or upgraded inline? -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Kevin Lange wrote: Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback Segments on 8.1.7.4
Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segments on 8.1.7.4
Kevin, The ORA-01555 errors are almost certainly symptoms, not the actual problem. It has been a few years since I tested an 8.0.x db, but I do not recall seeing any changes in rollback segments from 7.3 to 8.1. Have you converted from Dictionary to Locally managed RBS tablespaces? When you upgraded, did you change any of the settings, like OPTIMAL, for the rollback segments? Were they dropped and recreated or upgraded inline? -- Daniel W. Fink http://www.optimaldba.com IOUG-A Live! April 27 - May 1, 2003 Orlando, FL Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i SQL Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals Kevin Lange wrote: Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segments on 8.1.7.4
Did any of the rollback segment storage parameters (i.e. INITIAL, NEXT, PCTINCREASE, MINEXTENTS, MAXEXTENTS, OPTIMAL) or the number of rollback segments change between 8.0.5 and 8.1.7? Changes to any of these variables could impact the space available for storing inactive undo blocks for read-consistency purposes. If the answer is of course not, then here comes the harder question: did the SQL statements change between 8.0.5 and 8.1.7? Not just outright different SQL statements, but even the same SQL statements running with different execution plans? For example, changing explain plans so that SORT-MERGE join is no longer use could have significant impact on ORA-01555, as forcing sorts are one way to minimize SNAPSHOT TOO OLD. Having queries run faster is another way to minimize ORA-01555, so getting rid of SORT-MERGE joins will likely help, but if the performance improvements aren't good enough, then the conversion to HASH or NESTED LOOP joins may allow more ORA-01555 to occur. Have you noticed fewer sorts occurring since 8.0.5? Just some ideas... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:59 PM Evening; Has anyone noticed any difference on the way Oracle uses Rollback Segments on 8.1.7.4 versus 8.0.5 ?? Ever since upgrading to 8.1.7.4 from 8.0.5 on our Solaris servers we have noticed more SNAPSHOT TOO OLD errors than we used to. Are there any suggestions as to rollback tuning that has to be done with that kind of version move ?? Any help would be appreciated. Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
import and rollback segments
Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import and rollback segments
You can not specify RB segment for import to use. Consider using commit=y option of the import command. - Kirti -Original Message- Sent: Friday, December 20, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: import and rollback segments
If you cannot take the small ones offline, I do not think you can force to use a particular RBS. You could possible create multiple large RBS then take smaller ones offline then import. After completion put smaller ones online. You can try commit=y to commit after each buffer instead of each object. Use a larger BUFFER size on import to reduce round trips to export file. Perhaps others have some tricks Rick Leonard, George george.leonard@fa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rnell.com cc: Sent by: Subject: import and rollback segments [EMAIL PROTECTED] 12/20/2002 08:09 AM Please respond to ORACLE-L Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import and rollback segments
I am going with the commit=y it seems the best option since I am already using buffer size. This way I don't need to do anything with my current rollbacks. Thx for the feedback PS: can not remember now who it is but someone on this group wrote a new rman backup recover manual, can someone pls forward me the title of the book, someone asked me for it, know if I go to borders will find it just can not remember at the moment, Thx all, have a good weekend. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- Sent: 20 December 2002 14:54 PM To: Multiple recipients of list ORACLE-L You can not specify RB segment for import to use. Consider using commit=y option of the import command. - Kirti -Original Message- Sent: Friday, December 20, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
Behave children. ;) No, I wasn't reading the list. Another story... Jared On Tuesday 10 December 2002 10:20, Rachel Carmichael wrote: 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
From bitter experience: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. We had an all night session after this bug hit us. We had to call Oracle to come with the DUL utility to recover the data. Now we define our datafiles to be 1900MB each. Also each tablespace has an extra datafile with 200MB size with autoextend up to 1900MB. Our checks check that each tablespace has datafile with 200MB size. If not we get an alert and check the situation. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM David, As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
On Wed, 11 Dec 2002, Yechiel Adar wrote: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. I think the 4Gb limit is confined to a handfull of older operating system versions or older Oracle versions. For about the last five years I have been accustomed to creating 16Gb datafiles with no problem. Imagine trying to build a 5 terabyte data warehouse out of 1900Mb datafiles! It would require 2760 datafiles! Can anyone confirm that this is no longer a problem after certain versions of O/S and Oracle? Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you specify no size for a datafile, then adds it to the controlfile /data dictionary in a way that makes it look like it has a ton (like a terabyte) of free space. The datafile can't be resized or offline dropped, and the tablespace must be dropped and recreated (unless you get the patch). Let one segment extend into there and watch the ORA-600s. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Increase size of data files and rollback segments
Hello Jeremiah I did some research on metalink and it says: 1) Do not use datafiles more then 4GB on NT systems. 2) There is a bug on NT, W2K that if you resize datafile (direct command or autoextend) to 4GB boundary, i.e 4,8,12, then there are two conditions: 2.1) No archive log - database crashes but you can start again and resize the datafiles. 2.2) Archive log - restore and regenerate to a point in time prior before the resize. This bug was reported also on 9.2. The work around is to resize to 4.1, 8.1 GB datafiles. Bug number 1668488. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 12:54 PM On Wed, 11 Dec 2002, Yechiel Adar wrote: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. I think the 4Gb limit is confined to a handfull of older operating system versions or older Oracle versions. For about the last five years I have been accustomed to creating 16Gb datafiles with no problem. Imagine trying to build a 5 terabyte data warehouse out of 1900Mb datafiles! It would require 2760 datafiles! Can anyone confirm that this is no longer a problem after certain versions of O/S and Oracle? Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you specify no size for a datafile, then adds it to the controlfile /data dictionary in a way that makes it look like it has a ton (like a terabyte) of free space. The datafile can't be resized or offline dropped, and the tablespace must be dropped and recreated (unless you get the patch). Let one segment extend into there and watch the ORA-600s. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Increase size of data files and rollback segments
Yechiel, Thanks for pointing out the potential issues with autoextending onto an exact 4 Gb boundary (as I forgot to include them). Reading the bug you referenced (at http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUGp_id=1668488) it says: ... Does not reproduce on 8.1.7 Sun Solaris. ... Rediscovery Information: Resize a datafile file to [exactly] 4GB, 8G, 12G, 16G, etc. After resizing a datafile to 4G, alter system checkpoint was failing with ORA-27069 ... This fix is in 8.1.7.4.1 and 9.0.1.4.0 but not in 9.2.0.2.1 I am on 8.1.7.4.5 and so am not affected by this issue - I can't remember the version the original poster was on. Anyone using 817x may also want to check note 120607.1 (http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=120607.1) titled Support Status and Alerts for Oracle8i Release 3 (8.1.7.X) for information on this and other issues. This refers you to Note 148894.1 (http://metalink.oracle.com/metalink/plsql/showdoc?db=Notid=148894.1) titled ALERT: Problems with Datafile AUTOEXTEND/RESIZE on Oracle8i on NT/2000 Platforms This contains the information ... A fix is now available in 8.1.7.1.4 Bug.1823173 and will be included in8.1.7.3 BUG.1794199 ... For general Oracle information on 2Gb files see http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_id=62427.1p_database_id=NOT titled 2Gb or not 2Gb - File limits in Oracle. This contains links to other notes with Port specific information. I hope this helps. Regards, Bruce Reardon -Original Message- Sent: Wednesday, 11 December 2002 11:19 PM Hello Jeremiah I did some research on metalink and it says: 1) Do not use datafiles more then 4GB on NT systems. 2) There is a bug on NT, W2K that if you resize datafile (direct command or autoextend) to 4GB boundary, i.e 4,8,12, then there are two conditions: 2.1) No archive log - database crashes but you can start again and resize the datafiles. 2.2) Archive log - restore and regenerate to a point in time prior before the resize. This bug was reported also on 9.2. The work around is to resize to 4.1, 8.1 GB datafiles. Bug number 1668488. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 12:54 PM On Wed, 11 Dec 2002, Yechiel Adar wrote: Do not allow your datafile to autoextend across 4GB boundary. There is a bug that cause this datafile to be unusable. I think the 4Gb limit is confined to a handfull of older operating system versions or older Oracle versions. For about the last five years I have been accustomed to creating 16Gb datafiles with no problem. Imagine trying to build a 5 terabyte data warehouse out of 1900Mb datafiles! It would require 2760 datafiles! Can anyone confirm that this is no longer a problem after certain versions of O/S and Oracle? Note another mean bug (8.1.6.2 / HP-UX 64-bit) where Oracle lets you specify no size for a datafile, then adds it to the controlfile /data dictionary in a way that makes it look like it has a ton (like a terabyte) of free space. The datafile can't be resized or offline dropped, and the tablespace must be dropped and recreated (unless you get the patch). Let one segment extend into there and watch the ORA-600s. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 11, 2002 2:46 AM As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network
RE: Increase size of data files and rollback segments
Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
David, If my three year old said that, he'd be on the step immediately. Jeremiah has helped a lot of people on this list. The point is that you need to take a certain amount of responsibility to do some research before posting a question (i.e. metalink, tahiti.com, ...). Also, all answers should be checked out. All obvious points (I hope). Now please take a deep breath and try again. Henry -Original Message- David M Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments What bothers me is why can't you use sqlplus? Why do you need GUI tool? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Henry Poras [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments David, If my three year old said that, he'd be on the step immediately. Jeremiah has helped a lot of people on this list. The point is that you need to take a certain amount of responsibility to do some research before posting a question (i.e. metalink, tahiti.com, ...). Also, all answers should be checked out. All obvious points (I hope). Now please take a deep breath and try again. Henry -Original Message- David M Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Increase size of data files and rollback segments
Speak for yourself, man. I think the type of people we don't welcome here is those who don't bother to read a doc on something as trivial as how to increase the size of datafile and can't take a joke. Richard -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments Au contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink too much of my beer. Read between the lines, David.There's a message there. :) --Walt Weaver Bozeman, Montana -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Subject: RE: Increase size of data files and rollback segments Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
David, Wrong. we very much welcome Jeremiah here. He has helped countless people on this list, and if he on occasion chooses to make a joke (as do we all), then so be it. He was a good deal gentler and nicer than my first thought, which was to tell you to read the fine manual before asking basic questions. Many of us spend a LOT of time on this list, helping others. It is very discouraging though to continually get questions that can be answered by a very simple read of the manuals. I suggest that in the future, you attempt to investigate a problem yourself before asking a question. Besides the fact that you will learn much more by doing your own research, you will not annoy the members of the list who try to help. Rachel --- Nguyen, David M [EMAIL PROTECTED] wrote: Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
I welcome David input always, especially when he is yanking the leg of someone who did not troubled himself to open the SQL manual and look at obvious commands like alter rollback segment and alter tablespace. I liked his answer. BTW, Please do not tell ANYONE on this list to shut up. It is bad behavior and, believe me, you need those guys the same as me. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 5:49 PM Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments ORACLE ORACLE ORACLE ORACLE SQL*NET Just bringing it back on topic :) Nick -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 10:21 AM To: Multiple recipients of list ORACLE-L Subject: Re: Increase size of data files and rollback segments 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
Walt, Your french is pretty good ! --- Weaver, Walt [EMAIL PROTECTED] a écrit : Au contraire, I welcome Jeremiah just about anywhere, as long as he doesn't drink too much of my beer. Read between the lines, David. There's a message there. :) --Walt Weaver Bozeman, Montana -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
Thanks, I had to drop off the Lazy DBA list because of all the sniping. I would hate to have to drop off Jared's list too. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 1:20 PM 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538
RE: Increase size of data files and rollback segments
Alright guys, just because you know Jeremiah better than me so you can take his joke. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. If you were in my situation, you would understand. -Original Message- Sent: Tuesday, December 10, 2002 1:26 PM To: Multiple recipients of list ORACLE-L Thanks, I had to drop off the Lazy DBA list because of all the sniping. I would hate to have to drop off Jared's list too. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 1:20 PM 1) he's reading the list while traveling 2) I'm having dinner with him tonight I'll tell him :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Stop fighting children, or I will have to tell Daddy Jared when he gets back. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 10, 2002 12:15 PM I disagree! I do welcome Jeremiah's input on this list. David, I think you missed the smiley attached to his message. -Original Message- Sent: Tuesday, December 10, 2002 10:50 AM To: Multiple recipients of list ORACLE-L Jeremiah, I am seeking for help. If you are not willing to help then just SHUT your mouth. I don't think we welcome such people like you here. David -Original Message- Sent: Monday, December 09, 2002 5:39 AM To: Multiple recipients of list ORACLE-L On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send
RE: Increase size of data files and rollback segments
Title: RE: Increase size of data files and rollback segments From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard...
RE: Increase size of data files and rollback segments
David, As a start, look up the following commands in the SQL Reference guide: alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' autoextend on maxsize 20480M; Read up on the implications of autoextend and whether you want it alter database datafile 'C:\ORADATA\fred\DAT_LARGE_01.dbf' resize 10240M; For rollback datafile - same as any other datafile, eg: alter database datafile 'C:\ORADATA\fred\ROLLBACK1.DBF' autoextend on maxsize 10240M; You may then need to add another rollback segment or increase the max extents of an existing one. eg to add another rollback segment: CREATE PUBLIC ROLLBACK SEGMENT r09_big TABLESPACE rollback STORAGE ( minextents 20 INITIAL 10M NEXT 10M MAXEXTENTS UNLIMITED) (you would then need to bring this online - eg alter rollback segment r09_big online;) For tempfile (ie LMT temporary tablespaces): alter database tempfile 'C:\ORADATA\fred\TEMP1.dbf' autoextend on maxsize 10240M; Remember - don't use the exact sizes I've shown - alter to suit your case (these were part of a huge load into a new test system) Hope this helps (and willing to learn if some of the above could be improved). Regards, Bruce -Original Message- Sent: Wednesday, 11 December 2002 8:15 AM From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Alright guys, just because you know Jeremiah better than me so you can take his joke. I have no idea who Jeremiah is from Adam, and I got the joke. Hell, I nearly flamed you myself, and I'm just a lowly developer. My apology to him as I did not recognize it was a joke, however when I am asking for help from the group, I am in a situation to resolve problem ASAP and hope to find a answer not a joke. The problem is that if enough people like you refuse to RTFM, then no one will want to answer questions because it'll be duller'n your resume. If you were in my situation, you would understand. I've been in your situation, and been damned ashamed of myself for not having researched the question first. It ain't all that hard... -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Increase size of data files and rollback segments
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76956/dfiles.htm -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]]Sent: Monday, December 09, 2002 5:24 AMTo: Multiple recipients of list ORACLE-LSubject: Increase size of data files and rollback segments How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Thanks,David
Increase size of data files and rollback segments
How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Thanks,David
Re: Increase size of data files and rollback segments
On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Increase size of data files and rollback segments
A cruel joke Jeremy! BTW may be you can help me out here. I am not receiving back any of the messages I send to the the list and I do not know if list is receiving my messages either. Do you know how to solve this problem? Thanks in advance Shaleen Garg - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 09, 2002 3:38 AM On Mon, 9 Dec 2002, Nguyen, David M wrote: How do I increase size of oracle data files and rollback segments and Can I do it when database is online? Unfortunately these sizes are fixed, and based on your level of license with Oracle Corp. If you need to increase the size of your datafiles or rollback segments, you must contact your Oracle sales representative and request additional power units. If you find that you run in a dynamic enough environment, you may wish to upgrade to a more sophisticated database system such as MS SQL Server or Filemaker Pro, both of which allow dynamic resizing. :-) -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orafaq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How are rollback segments assigned?
Thanks Jared, thats not what I see. I have 20 rollback segments, and at no point in time, there were more than 4 transactions in the rollback segments. In fact, I happened to see it a couple of minutes ago. select usn, xacts from v$rollstat showed me 0 in 19 rollback segments, and 2 in one of them. And I have got alerts in place to alert me when there are more than 4 transactions in all of the rollback segments. And yeah, the rollback segments are online. Remains a mystery to me. Raj Jared.Still@r adisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: How are rollback segments assigned? com November 25, 2002 08:59 PM Please respond to ORACLE-L Here's one scenario: 4 transactions, 2 rollback segs tx 1 - rbs1 tx 2 - rbs 2 tx 3 - rbs 1 tx 4 - rbs 2 tx1 and tx3 finish. tx2 and tx4 have not yet committed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How are rollback segments assigned? Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command
Re: How are rollback segments assigned?
Raj, You're assuming that the transactions are lasting long enough for you to catch them in the rollback segments. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/26/2002 09:42 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: How are rollback segments assigned? Thanks Jared, thats not what I see. I have 20 rollback segments, and at no point in time, there were more than 4 transactions in the rollback segments. In fact, I happened to see it a couple of minutes ago. select usn, xacts from v$rollstat showed me 0 in 19 rollback segments, and 2 in one of them. And I have got alerts in place to alert me when there are more than 4 transactions in all of the rollback segments. And yeah, the rollback segments are online. Remains a mystery to me. Raj Jared.Still@r adisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: How are rollback segments assigned? com November 25, 2002 08:59 PM Please respond to ORACLE-L Here's one scenario: 4 transactions, 2 rollback segs tx 1 - rbs1 tx 2 - rbs 2 tx 3 - rbs 1 tx 4 - rbs 2 tx1 and tx3 finish. tx2 and tx4 have not yet committed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How are rollback segments assigned? Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing
RE: How are rollback segments assigned?
Exactly. A guy might have to poll V$ROLLSTAT 100+ times per second to see the allocations happening on a system with well-designed transactions. You just can't do that with SQL. Raj, you *can* test the behavior by using some artificially *bad* transactions. On a quiescent system (nothing else running) with n rollback segments, open n+1 sqlplus sessions. In each session, update a row but don't commit. After each session's update, look at V$ROLLSTAT. To the best of my knowledge, the assignment algorithm has always been to assign a new txn to the segment with the smallest number of active txns in it. There are of course lots of ties (e.g., lots of segments might have 0 active txns in them). The tie-breaker in v6 was to assign in round-robin order (as the segments are listed in the init.ora file). In v7, the tie-breaker algorithm apparently changed to choose the segment that is listed earliest in the init.ora file. I don't know whether it changed again in 8 or 9. You'll know if you do the test. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Raj, You're assuming that the transactions are lasting long enough for you to catch them in the rollback segments. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/26/2002 09:42 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: How are rollback segments assigned? Thanks Jared, thats not what I see. I have 20 rollback segments, and at no point in time, there were more than 4 transactions in the rollback segments. In fact, I happened to see it a couple of minutes ago. select usn, xacts from v$rollstat showed me 0 in 19 rollback segments, and 2 in one of them. And I have got alerts in place to alert me when there are more than 4 transactions in all of the rollback segments. And yeah, the rollback segments are online. Remains a mystery to me. Raj Jared.Still@r adisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: How are rollback segments assigned? com November 25, 2002 08:59 PM Please respond to ORACLE-L Here's one scenario: 4 transactions, 2 rollback segs tx 1 - rbs1 tx 2 - rbs 2 tx 3 - rbs 1 tx 4 - rbs 2 tx1 and tx3 finish. tx2 and tx4 have not yet committed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How are rollback segments assigned? Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat
RE: How are rollback segments assigned?
Raj, Not to be too obvious, but... Are there any transactions that are being explicitly assigned to the rollback segments by the user/application? -Original Message- Sent: Tuesday, November 26, 2002 10:42 AM To: Multiple recipients of list ORACLE-L Thanks Jared, thats not what I see. I have 20 rollback segments, and at no point in time, there were more than 4 transactions in the rollback segments. In fact, I happened to see it a couple of minutes ago. select usn, xacts from v$rollstat showed me 0 in 19 rollback segments, and 2 in one of them. And I have got alerts in place to alert me when there are more than 4 transactions in all of the rollback segments. And yeah, the rollback segments are online. Remains a mystery to me. Raj Jared.Still@r adisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: How are rollback segments assigned? com November 25, 2002 08:59 PM Please respond to ORACLE-L Here's one scenario: 4 transactions, 2 rollback segs tx 1 - rbs1 tx 2 - rbs 2 tx 3 - rbs 1 tx 4 - rbs 2 tx1 and tx3 finish. tx2 and tx4 have not yet committed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How are rollback segments assigned? Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: How are rollback segments assigned?
In v7, the tie-breaker algorithm apparently changed to choose the segment that is listed earliest in the init.ora file. What if the rollback segments are created PUBLIC, and are not listed in init.ora? Order of sys.undo$.us#? Jared Cary Millsap [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/26/2002 11:15 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: How are rollback segments assigned? Exactly. A guy might have to poll V$ROLLSTAT 100+ times per second to see the allocations happening on a system with well-designed transactions. You just can't do that with SQL. Raj, you *can* test the behavior by using some artificially *bad* transactions. On a quiescent system (nothing else running) with n rollback segments, open n+1 sqlplus sessions. In each session, update a row but don't commit. After each session's update, look at V$ROLLSTAT. To the best of my knowledge, the assignment algorithm has always been to assign a new txn to the segment with the smallest number of active txns in it. There are of course lots of ties (e.g., lots of segments might have 0 active txns in them). The tie-breaker in v6 was to assign in round-robin order (as the segments are listed in the init.ora file). In v7, the tie-breaker algorithm apparently changed to choose the segment that is listed earliest in the init.ora file. I don't know whether it changed again in 8 or 9. You'll know if you do the test. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- [EMAIL PROTECTED] Sent: Tuesday, November 26, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Raj, You're assuming that the transactions are lasting long enough for you to catch them in the rollback segments. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/26/2002 09:42 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: How are rollback segments assigned? Thanks Jared, thats not what I see. I have 20 rollback segments, and at no point in time, there were more than 4 transactions in the rollback segments. In fact, I happened to see it a couple of minutes ago. select usn, xacts from v$rollstat showed me 0 in 19 rollback segments, and 2 in one of them. And I have got alerts in place to alert me when there are more than 4 transactions in all of the rollback segments. And yeah, the rollback segments are online. Remains a mystery to me. Raj Jared.Still@r adisys.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Re: How are rollback segments assigned? com November 25, 2002 08:59 PM Please respond to ORACLE-L Here's one scenario: 4 transactions, 2 rollback segs tx 1 - rbs1 tx 2 - rbs 2 tx 3 - rbs 1 tx 4 - rbs 2 tx1 and tx3 finish. tx2 and tx4 have not yet committed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How are rollback segments assigned? Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
How are rollback segments assigned?
Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How are rollback segments assigned?
Here's one scenario: 4 transactions, 2 rollback segs tx 1 - rbs1 tx 2 - rbs 2 tx 3 - rbs 1 tx 4 - rbs 2 tx1 and tx3 finish. tx2 and tx4 have not yet committed. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/25/2002 07:39 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How are rollback segments assigned? Hello Friends, Oracle Parallel Server 8.0.6.2.0 on Solaris 2.6 Nodes We were having some locking and rollback issues, and I set up some scripts to alert me in case there are more than 4 transactions in the rollback segments, and more than 1 in any of the rollback segments. Select sum(xacts) from v$rollstat --- Alert if more than 4, condition set to exclude system rollback where usn != 0 Select count(*) from v$rollstat --- Alert if more than 0, where condition to exclude system rollback where xacts =2 andusn != 0 We have 20 rollback segments, and there is very minimal DML activity on this database. I happened to see a scenario where all rollback segments had 0 transactions, except for one which had 2 in them. Under what scenario, can this happen? I thought the criteria for assigning rollback segments to transactions was 1. If object in system tablespace, use system rolback segment 2. Use the one with the least number of active transactions 3. If 2 or more rollback segments fit the second criteria, use the LRU algorithm. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Unsetting OPTIMAL in rollback segments
We are getting the following error in our alert log for a database where we are doing some unusually large transactions: Wed May 15 03:26:22 2002 Failure to extend rollback segment 27 because of 1581 condition FULL status of rollback segment 27 set. On Metalink I've found a couple of references to bug 228441. Following is one such reference. Sounds like one part of the work-around is to unset OPTIMAL which we do currently have set. I've looked through the docs and Metalink. I do see text for altering the OPTIMAL value but I don't see any reference to unsetting OPTIMAL. Is there a way to unset optimal in rollback segments that are currently online? Or do I have to create a bunch of new rollback segments from scratch without OPTIMAL specified and then roll them in and roll out the existing rollback segments. Thanks, Cherie Machler Oracle DBA Gelco Information Network From: Oracle, Tom Villane 21-Sep-01 21:20 Subject: Re : ORA-01581, but seem to have more than enough space Hi, The ORA-01581 is not normally seen in Oracle8. Bug 228441 has an explanation of why it can happen. This can happen when we are trying to extend a rollback segment. We try to extend the rollback segment when we cannot wrap into the next extent and we are near the end of the current extent. When we try to allocate the new extent we generate undo, in addition, space management may generate undo to do a coalesce. If the amount of undo we generate cannot fit in the current extent we will get a 1581 as we are now trying to use the extent that we are trying to add. Suggestions for resolving the problems are to make the INITIAL EXTENTS a large number ( maybe even set minextents = maxextents), and unset OPTIMAL Regards
Re: Unsetting OPTIMAL in rollback segments
Just tested this on 8.1.7.0. alter rollback segment rbs0 storage(optimal null); Rob Pegram Oracle Certified DBA SQL select segment_name, optsize 2 from dba_rollback_segs, v$rollstat 3 where usn=segment_id; SEGMENT_NAME OPTSIZE -- -- SYSTEM RBS0 4194304 RBS1 4194304 RBS2 4194304 RBS3 4194304 RBS4 4194304 RBS5 4194304 RBS6 4194304 8 rows selected. SQL alter rollback segment rbs0 storage(optimal null); Rollback segment altered. SQL select segment_name, optsize 2 from dba_rollback_segs, v$rollstat 3 where usn=segment_id; SEGMENT_NAME OPTSIZE -- -- SYSTEM RBS0 RBS1 4194304 RBS2 4194304 RBS3 4194304 RBS4 4194304 RBS5 4194304 RBS6 4194304 8 rows selected. --- [EMAIL PROTECTED] wrote: We are getting the following error in our alert log for a database where we are doing some unusually large transactions: Wed May 15 03:26:22 2002 Failure to extend rollback segment 27 because of 1581 condition FULL status of rollback segment 27 set. On Metalink I've found a couple of references to bug 228441. Following is one such reference. Sounds like one part of the work-around is to unset OPTIMAL which we do currently have set. I've looked through the docs and Metalink. I do see text for altering the OPTIMAL value but I don't see any reference to unsetting OPTIMAL. Is there a way to unset optimal in rollback segments that are currently online? Or do I have to create a bunch of new rollback segments from scratch without OPTIMAL specified and then roll them in and roll out the existing rollback segments. Thanks, Cherie Machler Oracle DBA Gelco Information Network From: Oracle, Tom Villane 21-Sep-01 21:20 Subject: Re : ORA-01581, but seem to have more than enough space Hi, The ORA-01581 is not normally seen in Oracle8. Bug 228441 has an explanation of why it can happen. This can happen when we are trying to extend a rollback segment. We try to extend the rollback segment when we cannot wrap into the next extent and we are near the end of the current extent. When we try to allocate the new extent we generate undo, in addition, space management may generate undo to do a coalesce. If the amount of undo we generate cannot fit in the current
Re: Unsetting OPTIMAL in rollback segments
Rob, Just what the Dr. ordered. Many thanks, Cherie Robert Pegram pegramrg@yaho To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] o.com cc: Sent by: Subject: Re: Unsetting OPTIMAL in rollback segments [EMAIL PROTECTED] om 05/15/02 12:38 PM Please respond to ORACLE-L Just tested this on 8.1.7.0. alter rollback segment rbs0 storage(optimal null); Rob Pegram Oracle Certified DBA SQL select segment_name, optsize 2 from dba_rollback_segs, v$rollstat 3 where usn=segment_id; SEGMENT_NAME OPTSIZE -- -- SYSTEM RBS0 4194304 RBS1 4194304 RBS2 4194304 RBS3 4194304 RBS4 4194304 RBS5 4194304 RBS6 4194304 8 rows selected. SQL alter rollback segment rbs0 storage(optimal null); Rollback segment altered. SQL select segment_name, optsize 2 from dba_rollback_segs, v$rollstat 3 where usn=segment_id; SEGMENT_NAME OPTSIZE -- -- SYSTEM RBS0 RBS1 4194304 RBS2 4194304 RBS3 4194304 RBS4 4194304 RBS5 4194304 RBS6 4194304 8 rows selected. --- [EMAIL PROTECTED] wrote: We are getting the following error in our alert log for a database where we are doing some unusually large transactions: Wed May 15 03:26:22 2002 Failure to extend rollback segment 27 because of 1581 condition FULL status of rollback segment 27 set. On Metalink I've found a couple of references to bug 228441. Following is one such reference. Sounds like one part of the work-around is to unset OPTIMAL which we do currently have set. I've looked through the docs and Metalink. I do see text for altering the OPTIMAL value but I don't see any reference to unsetting OPTIMAL. Is there a way to unset optimal in rollback segments that are currently online? Or do I have to create a bunch of new rollback segments from scratch without OPTIMAL specified and then roll them in and roll out the existing rollback segments. Thanks, Cherie Machler Oracle DBA Gelco Information Network From: Oracle, Tom Villane 21-Sep-01 21:20 Subject: Re : ORA-01581, but seem to have more than enough space Hi, The ORA-01581 is not normally seen in Oracle8. Bug 228441 has an explanation of why it can happen. This can happen when we are trying to extend a rollback segment. We try to extend the rollback segment when we cannot wrap into the next extent and we are near the end of the current extent. When we try to allocate the new extent we generate undo, in addition, space management may generate undo to do a coalesce. If the amount of undo we generate cannot fit in the current extent we will get a 1581 as we are now trying to use the extent that we are trying
RE: Users reading from rollback segments
Thank you all. I agree now that there is no way to tell if someone will need the rollback segment data, EVEN if no queries are running when all transactions are committed (due to delayed block cleanout - I had forgotten about this!). As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). This was very helpful information and an eductional discussion. I'll post my rollback queries later today... -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Users reading from rollback segments Jeremiah is correct. In addition, rollback segments are read as part of the delayed block cleanout process, and it's not possible to predict that, either. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA-01555. Tell me if I'm off on this... Users will not read from the rollback segment unless they need read-consistent data due to an open transaction against the data they are looking for (thus reading the redo or undo info from rollback). Otherwise they read from the data segments (committed data). Oracle will not shrink the rollback segment if it contains open transactions. So, if there are no users reading from rollback and I issue a 'shrink' command, and it works, then the transactions are complete and any user coming in after that will read from the data segments. If there are no users reading from rollback and I issue a 'shrink' command, and it DOES NOT work, then the transactions are NOT complete and any user coming in after that will read from the rollback segments (the data is still there). If there ARE users reading from rollback and I issue a 'shrink' command, and it works, then users run the risk of getting ORA-01555 (the data MAY be gone). Which is exactly why I asked my original question (How do I identify READERS of the rollback segments?) :) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people bloating up RBSs by limiting their growth, and enforcing the use of smaller transactions. That way you won't have to shrink so much. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City
Re: Users reading from rollback segments
Hi Glenn and list: As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). If you're under Oracle 7 or 8.0, I think that you could set delayed_logging_block_cleanouts=FALSE (to make sure that the next reader will do the cleanout), and execute a FTS on the table after the commit, this would make all the block cleanouts for you. This way you can be sure that noone will need to read this RBS blocks for a cleanout operation. Plse, correct me if I'm wrong. Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 12:18 PM Thank you all. I agree now that there is no way to tell if someone will need the rollback segment data, EVEN if no queries are running when all transactions are committed (due to delayed block cleanout - I had forgotten about this!). As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). This was very helpful information and an eductional discussion. I'll post my rollback queries later today... -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Users reading from rollback segments Jeremiah is correct. In addition, rollback segments are read as part of the delayed block cleanout process, and it's not possible to predict that, either. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA-01555. Tell me if I'm off on this... Users will not read from the rollback segment unless they need read-consistent data due to an open transaction against the data they are looking for (thus reading the redo or undo info from rollback). Otherwise they read from the data segments (committed data). Oracle will not shrink the rollback segment if it contains open transactions. So, if there are no users reading from rollback and I issue a 'shrink' command, and it works, then the transactions are complete and any user coming in after that will read from the data segments. If there are no users reading from rollback and I issue a 'shrink' command, and it DOES NOT work, then the transactions are NOT complete and any user coming in after that will read from the rollback segments (the data is still there). If there ARE users reading from rollback and I issue a 'shrink' command, and it works, then users run the risk of getting ORA-01555 (the data MAY be gone). Which is exactly why I asked my original question (How do I identify READERS of the rollback segments?) :) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people bloating up RBSs by limiting their growth
Re: Users reading from rollback segments
The delayed_logging_block_cleanouts parameter does not force or suppress cleanouts. It just makes any cleanouts that do occur get logged as redo entries. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 27 Feb 2002, Diego Cutrone wrote: Hi Glenn and list: As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). If you're under Oracle 7 or 8.0, I think that you could set delayed_logging_block_cleanouts=FALSE (to make sure that the next reader will do the cleanout), and execute a FTS on the table after the commit, this would make all the block cleanouts for you. This way you can be sure that noone will need to read this RBS blocks for a cleanout operation. - Original Message - Thank you all. I agree now that there is no way to tell if someone will need the rollback segment data, EVEN if no queries are running when all transactions are committed (due to delayed block cleanout - I had forgotten about this!). As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). This was very helpful information and an eductional discussion. I'll post my rollback queries later today... -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Jeremiah is correct. In addition, rollback segments are read as part of the delayed block cleanout process, and it's not possible to predict that, either. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA-01555. Tell me if I'm off on this... Users will not read from the rollback segment unless they need read-consistent data due to an open transaction against the data they are looking for (thus reading the redo or undo info from rollback). Otherwise they read from the data segments (committed data). Oracle will not shrink the rollback segment if it contains open transactions. So, if there are no users reading from rollback and I issue a 'shrink' command, and it works, then the transactions are complete and any user coming in after that will read from the data segments. If there are no users reading from rollback and I issue a 'shrink' command, and it DOES NOT work, then the transactions are NOT complete and any user coming in after that will read from the rollback segments (the data is still there). If there ARE users reading from rollback and I issue a 'shrink' command, and it works, then users run the risk of getting ORA-01555 (the data MAY be gone). Which is exactly why I asked my original question (How do I identify READERS of the rollback segments?) :) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people
Re: Users reading from rollback segments
Jeremiah : What I meant was that the delayed_logging_block_cleanouts parameter (=FALSE) will make the next reader of the block to cleanout that block. Now, if this parameter's value is TRUE (default in Oracle 7 and 8.0) the next reader will NOT clean out the block (it will read the rollback segment and generate the appropiate block image but it will not clean the block out). The delayed logging block clean out feature delays the redo for the cleanout blocks until it could be logged in combination with another redo for another change to the block. So if you have this parameter set in TRUE the block clean out will be made only when you'll make another change to these blocks. According to what Glenn was saying: As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). I think that there's a way you can be sure that noone will need to read some RBS blocks for a cleanout operation. Greetings Diego Cutrone - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 27, 2002 4:38 PM The delayed_logging_block_cleanouts parameter does not force or suppress cleanouts. It just makes any cleanouts that do occur get logged as redo entries. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 27 Feb 2002, Diego Cutrone wrote: Hi Glenn and list: As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). If you're under Oracle 7 or 8.0, I think that you could set delayed_logging_block_cleanouts=FALSE (to make sure that the next reader will do the cleanout), and execute a FTS on the table after the commit, this would make all the block cleanouts for you. This way you can be sure that noone will need to read this RBS blocks for a cleanout operation. - Original Message - Thank you all. I agree now that there is no way to tell if someone will need the rollback segment data, EVEN if no queries are running when all transactions are committed (due to delayed block cleanout - I had forgotten about this!). As you mentioned, even if noone is reading from rollback at the time all transactions commit, a query may be executing which will access rollback later in its current run (which started prior to the commit). This was very helpful information and an eductional discussion. I'll post my rollback queries later today... -Original Message- From: Paul Baumgartel [mailto:[EMAIL PROTECTED]] Jeremiah is correct. In addition, rollback segments are read as part of the delayed block cleanout process, and it's not possible to predict that, either. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA-01555. Tell me if I'm off on this... Users will not read from the rollback segment unless they need read-consistent data due to an open transaction against the data they are looking for (thus reading
RE: Users reading from rollback segments
Here is the Query you are looking for. set lines 132 set pages 30 col rr heading 'RB Segment' format a18 col os heading 'OS User' format a10 col te heading 'Terminal' format a10 col sid format 9 col spid format 99 select r.name ROLLBACK SEG, s.sid, s.serial#, s.username,osuser,START_TIME from v$session s, v$transaction t, v$rollname r where s.taddr=t.addr and t.xidusn = r.usn order by 1 / Brijesh Gupta Oracle Production DBA Air Liquide Inc. Phone : (713) 438 6259 Fax : (713) 438-6825 Cell : (713) 539-1375 Email : [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ~~~ -Original Message- Sent: Tuesday, February 26, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Thanks for the replies. I have all sorts of neat queries (which I can post) which show me gobs of information about my rollback segments (sizes, extents, optimal, shrinks, active transactions, block used by those transcations, ad infinitum...). HOWEVER, I still cannot find an answer to my original question; Is there a way to tell if anyone is reading from the rollback segments? Readers do not open transactions, correct? So they will not show up on the queries most of us are running against v$rollxxx and v$transaction. Where can I find out of someone is using the undo info in the rollbacks for read consistency? In other words, how do I find the readers (from rollback, not from the tables themselves)? I do not want to issue a shrink (and thus risk a ORA-01555) if people are still using the rollback for read consistency. To answer another reply's question: I am shrinking the rollbacks right before I run a large batch job, so as to give the job the maximum amount of space in the rollback tablespace. (I cannot utilize 'set transaction use ...' as this is an Oracle Apps job which actually does many transactions (re: purges)). -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: Users reading from rollback segments Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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: 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: Gupta, Brijesh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Users reading from rollback segments
Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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).
RE: Users reading from rollback segments
Why would you want to shrink a rollback segment? -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: Users reading from rollback segments Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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: 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).
Re: Users reading from rollback segments
To partially answer your question, xacts in v$rollstat will tell you if there are any active transactions in the rollback segment. Raj Glenn Travis Glenn.TravisTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @sas.comcc: Sent by: Subject: Users reading from rollback segments root@fatcity. com February 26, 2002 02:38 PM Please respond to ORACLE-L Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Users reading from rollback segments
Is there a way to check if the rollback segment is in use first? I use following script to see which rollbacks are in use...and then shrink to certain size if it requires to do that... select substr(a.os_user_name,1,8) OS User ,substr(e.username,1,8) DB User , substr(b.object_name,1,30) Object Name , substr(b.object_type,1,10) Type , substr(c.segment_name,1,30) RBS , e.process PROCESS , substr(d.used_urec,1,8) # of Records from v$locked_object a , dba_objects b , dba_rollback_segs c , v$transaction d , v$session e where a.object_id = b.object_id and a.xidusn = c.segment_id and a.xidusn = d.xidusn and a.xidslot = d.xidslot and d.addr = e.taddr / Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 26 Feb 2002 11:38:28 -0800 Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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). MOHAMMAD RAFIQ _ 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: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Users reading from rollback segments
SELECT segment_name, USN,EXTENTS,RSSIZE,HWMSIZE,optsize,xacts,aveactive,WRAPS,shrinks FROM V$ROLLSTAT, dba_rollback_segs where usn=segment_id xacts =1 is in use. otherwise it is 0. oracle 8.1.6 you can take an active rollback segment offline, but also kill the transaction. 8.17 supposed to fix the bug. I assume it will let the transaction finished. Joan Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Users reading from rollback segments
Thanks for the replies. I have all sorts of neat queries (which I can post) which show me gobs of information about my rollback segments (sizes, extents, optimal, shrinks, active transactions, block used by those transcations, ad infinitum...). HOWEVER, I still cannot find an answer to my original question; Is there a way to tell if anyone is reading from the rollback segments? Readers do not open transactions, correct? So they will not show up on the queries most of us are running against v$rollxxx and v$transaction. Where can I find out of someone is using the undo info in the rollbacks for read consistency? In other words, how do I find the readers (from rollback, not from the tables themselves)? I do not want to issue a shrink (and thus risk a ORA-01555) if people are still using the rollback for read consistency. To answer another reply's question: I am shrinking the rollbacks right before I run a large batch job, so as to give the job the maximum amount of space in the rollback tablespace. (I cannot utilize 'set transaction use ...' as this is an Oracle Apps job which actually does many transactions (re: purges)). -Original Message- From: Glenn Travis [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:38 PM To: Multiple recipients of list ORACLE-L Subject: Users reading from rollback segments Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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: 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).
RE: Users reading from rollback segments
XACTS is the NUMBER of active transactions in the rollback segment. 0 or 0. However, I am not looking for transactions, I am looking for queries reading from the rollback space for read consistency purposes. I found an answer to my second question and it is NO. You can take the rollback segment offline and it will succeed if it is being used. It will just go into an 'OFFLINE PENDING' state until all users are out. So I don't think I can use this logic. Question: How does Oracle know it is in 'use'? What does in 'use' mean? Active transactions plus readers? I would not think Oracle would take a rollback segment offline if users are reading from it (this doesn't necessarily mean they are holding active transactions). So if Oracle knows it is 'in use', how can I get that info too? -Original Message- From: Joan Hsieh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 3:51 PM To: Multiple recipients of list ORACLE-L Subject: Re: Users reading from rollback segments SELECT segment_name, USN,EXTENTS,RSSIZE,HWMSIZE,optsize,xacts,aveactive,WRAPS,shrinks FROM V$ROLLSTAT, dba_rollback_segs where usn=segment_id xacts =1 is in use. otherwise it is 0. oracle 8.1.6 you can take an active rollback segment offline, but also kill the transaction. 8.17 supposed to fix the bug. I assume it will let the transaction finished. Joan Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- 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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 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).
Re: Users reading from rollback segments
Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people bloating up RBSs by limiting their growth, and enforcing the use of smaller transactions. That way you won't have to shrink so much. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Users reading from rollback segments
People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA-01555. Tell me if I'm off on this... Users will not read from the rollback segment unless they need read-consistent data due to an open transaction against the data they are looking for (thus reading the redo or undo info from rollback). Otherwise they read from the data segments (committed data). Oracle will not shrink the rollback segment if it contains open transactions. So, if there are no users reading from rollback and I issue a 'shrink' command, and it works, then the transactions are complete and any user coming in after that will read from the data segments. If there are no users reading from rollback and I issue a 'shrink' command, and it DOES NOT work, then the transactions are NOT complete and any user coming in after that will read from the rollback segments (the data is still there). If there ARE users reading from rollback and I issue a 'shrink' command, and it works, then users run the risk of getting ORA-01555 (the data MAY be gone). Which is exactly why I asked my original question (How do I identify READERS of the rollback segments?) :) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people bloating up RBSs by limiting their growth, and enforcing the use of smaller transactions. That way you won't have to shrink so much. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Users reading from rollback segments
Glenn, An approximation of what you require *may* be worked out this way: 1. Snoop v$session_wait for all events that start with 'db file%' and see if P1 is in a list of data files that belongs to the RBS tablespace(s). If you do see sessions that have P1s indicating RBS files, then you *may* be reading Rollback. It is not necessarily on the older entries, but see below: 2. Track the start time of that Query from the SID - using V$SESSION and V$PROCESS. If the start time is reasonably old, then you *may* have an issue, as ORA-01555 errors can be expected for those queries that started *before* the entry you are going to zap via shrink was made. I have successfully used P1 and P2 to indicate the progress of a long running query by working out the segments being accessed and matching that with an EXPLAIN PLAN. This is especially useful if multiple table joins are involved. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: Users reading from rollback segments People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA-01555. Tell me if I'm off on this... Users will not read from the rollback segment unless they need read-consistent data due to an open transaction against the data they are looking for (thus reading the redo or undo info from rollback). Otherwise they read from the data segments (committed data). Oracle will not shrink the rollback segment if it contains open transactions. So, if there are no users reading from rollback and I issue a 'shrink' command, and it works, then the transactions are complete and any user coming in after that will read from the data segments. If there are no users reading from rollback and I issue a 'shrink' command, and it DOES NOT work, then the transactions are NOT complete and any user coming in after that will read from the rollback segments (the data is still there). If there ARE users reading from rollback and I issue a 'shrink' command, and it works, then users run the risk of getting ORA-01555 (the data MAY be gone). Which is exactly why I asked my original question (How do I identify READERS of the rollback segments?) :) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people bloating up RBSs by limiting their growth, and enforcing the use of smaller transactions. That way you won't have to shrink so much. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving
RE: Users reading from rollback segments
John, I was thinking along the same lines, but then its not the sure shot way to do it. I was also wondering if one could instead do it with x$bh and dba_extents. Just a thought. Thanks Raj John Kanagaraj john.kanagaraTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: Sent by: Subject: RE: Users reading from rollback segments [EMAIL PROTECTED] om February 26, 2002 06:09 PM Please respond to ORACLE-L Glenn, An approximation of what you require *may* be worked out this way: 1. Snoop v$session_wait for all events that start with 'db file%' and see if P1 is in a list of data files that belongs to the RBS tablespace(s). If you do see sessions that have P1s indicating RBS files, then you *may* be reading Rollback. It is not necessarily on the older entries, but see below: 2. Track the start time of that Query from the SID - using V$SESSION and V$PROCESS. If the start time is reasonably old, then you *may* have an issue, as ORA-01555 errors can be expected for those queries that started *before* the entry you are going to zap via shrink was made. I have successfully used P1 and P2 to indicate the progress of a long running query by working out the segments being accessed and matching that with an EXPLAIN PLAN. This is especially useful if multiple table joins are involved. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 26, 2002 2:36 PM To: Multiple recipients of list ORACLE-L Subject: RE: Users reading from rollback segments People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA
RE: Users reading from rollback segments
Jeremiah is correct. In addition, rollback segments are read as part of the delayed block cleanout process, and it's not possible to predict that, either. --- Jeremiah Wilton [EMAIL PROTECTED] wrote: People also obtain read consistency data from the rollback segments after transactions have committed. If a query began before someone else's transaction committed, but continues reading, then needs the reconstruct the data from before the commit, in needs rollback data that is both committed and impossible to predict. I suppose if you could determine that the age of all undo entries in the portion of RBS that you will obliterate through shrinking are older than any query currently running in the database, then you could be sure that the shrink will not cause an ORA-01555. But the flaw in your logic is believing that once committed, rollback entries will not be needed for read consistency. They very well may. Because a query doesn't know what rollback entries it may need further down the road, you can't predict if your shrink will obliterate undo entries that a long-running query might need in the future. You keep asking if we can tell who is reading the rollback segments. The answer is that it doesn't matter. What you really need to ask is if we can tell who will need to read the rollback segments sometime soon. And you can't. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Hmmm. I think I CAN predict FUTURE needs of the rollback segments. If there are transactions using the rollback space, users MAY need it. If there are no transactions, then they won't. If I were able to know who is reading from rollback, I would know if shrinking might cause ORA-01555. Tell me if I'm off on this... Users will not read from the rollback segment unless they need read-consistent data due to an open transaction against the data they are looking for (thus reading the redo or undo info from rollback). Otherwise they read from the data segments (committed data). Oracle will not shrink the rollback segment if it contains open transactions. So, if there are no users reading from rollback and I issue a 'shrink' command, and it works, then the transactions are complete and any user coming in after that will read from the data segments. If there are no users reading from rollback and I issue a 'shrink' command, and it DOES NOT work, then the transactions are NOT complete and any user coming in after that will read from the rollback segments (the data is still there). If there ARE users reading from rollback and I issue a 'shrink' command, and it works, then users run the risk of getting ORA-01555 (the data MAY be gone). Which is exactly why I asked my original question (How do I identify READERS of the rollback segments?) :) -Original Message- From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] Since you cannot predict who might need to generate consistent reads from the RBS in the FUTURE, you cannot predict if you will cause ORA-01555 or not by shrinking. Your best bet is to get rid of people bloating up RBSs by limiting their growth, and enforcing the use of smaller transactions. That way you won't have to shrink so much. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Tue, 26 Feb 2002, Glenn Travis wrote: Is there a way to tell if anyone is reading from the rollback segments? I would like to manually issue 'alter rollback segment XXX shrink;', but do not want to do so if there are users reading read consistent data from the rollback space (thus giving them the ORA-01555 error). Is there a way to check if the rollback segment is in use first? Can I try to take it offline? Will it fail if there is someone reading from it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Greetings - Send FREE e-cards for every occasion! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: Rollback Segments
I stopped attending the EOUG after Amsterdam (1996) because I've crossed the pond and moved out of Europe. May favorite EOUG were in Cannes and Amsterdam. Boy, was it fun. They should organize one in Munich in October. That is probably the only place time that could top both Cannes and Amsterdam. -Original Message-From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]Sent: Saturday, February 23, 2002 10:33 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Rollback SegmentsAnd I'm sitting at my (the) oaktable right now thinking about a few things Jonathan Lewis said an hour ago, sorrounded by good whiskies brought in by Kyle Hailey and Connor McDonald and Jonathan. We still have a few seats available for his Master Class on Monday. You're of course all invited to attend for free and stay in my house... Now let's move a few decades forward, to other great products:Does anyone remember the Oracle Card product? Sure, some do. Now, how many ever saw the email variant of Oracle Card? Do you know what it was called (and I'm not kidding)? Oracle PostCard. Yep. It was probably the first product to handle LONG RAW's. Went out of production so fast you wouldn't beleive it. Pretty much before it went into production.Or how about Oracle Visuelle or whatever it was called? Remember the user group meeting in Paris or Brussels in the late 80's where Larry proudly presented it? I guess it later became Oracle Graphics Anyway, a friend of mine - Mogens Egan - and I stole the EOUG flag (took it down from the pole outside the conference center) and used it for the Danish user group meetings for a while. I wonder where it is now. It carried this cube with Europe on.Anjo Kolk wrote: Thanks.Yes I am on the list and on the oak table (http://www.oaktable.net ;-))Anjo."Gogala, Mladen" wrote: Wow! I've been recommending your paper about Oracle7 wait eventseverywhere! I didn't know that you are on this list, too.-Original Message-Sent: Tuesday, February 19, 2002 2:43 AMTo: Multiple recipients of list ORACLE-LHow about iag/iap ? And rpt ? Oh and SQL*Menu ?And there were about 14 enqueue/locks in Oracle Version 5 as far as I canremember.Anjo KolkBrings back memories of joining Oracle Europe in 1985 ;-)- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5.Hemant K ChitalePrincipal DBAChartered Semiconductor Manufacturing LtdRachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AMSent by: [EMAIL PROTECTED]Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L[EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback SegmentsUFI no, but the rest... that's where I started in Oracle -- version 5--- "Conboy, Jim" [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory!Does anybody else remember (or admit to) using UFI?Jim**...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Conboy, Jim INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo 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).__Do You Yahoo!?Yahoo! Sports - Coverage of the 2002 Olympic Gameshttp://sports.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-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: 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
Re: Rollback Segments
Oh yes. As I remember it, the Oktober Fest is actually in September nowadays. I would also add that the OakTable guys try to simulate an Oktober Fest as best they can :). But would it work anywhere in the US? I used to live in Baton Rouge, Louisiana, and that might be one possibility :)... Mogens Gogala, Mladen wrote: I stopped attending the EOUG after Amsterdam (1996) because I've crossed the pond and moved out of Europe. May favorite EOUG were in Cannes and Amsterdam. Boy, was it fun. They should organize one in Munich in October. That is probably the only place time that could top both Cannes and Amsterdam. -Original Message- From: Mogens Nrgaard[mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 10:33PM To: Multiple recipients of list ORACLE-L Subject: Re:Rollback Segments And I'm sitting at my (the) oaktableright now thinking about a few things Jonathan Lewis said an hour ago,sorrounded by good whiskies brought in by Kyle Hailey and Connor McDonald andJonathan. We still have a few seats available for his Master Class on Monday.You're of course all invited to attend for free and stay in my house... Nowlet's move a few decades forward, to other great products: Does anyoneremember the Oracle Card product? Sure, some do. Now, how many ever saw theemail variant of Oracle Card? Do you know what it was called (and I'm notkidding)? Oracle PostCard. Yep. It was probably the first product to handleLONG RAW's. Went out of production so fast you wouldn't beleive it. Prettymuch before it went into production. Or how about Oracle Visuelle orwhatever it was called? Remember the user group meeting in Paris or Brusselsin the late 80's where Larry proudly presented it? I guess it later becameOracle Graphics Anyway, a friend of mine - Mogens Egan - and I stole theEOUG flag (took it down from the pole outside the conference center) and usedit for the Danish user group meetings for a while. I wonder where it is now.It carried this cube with Europe on. Anjo Kolk wrote: Thanks.Yes I am on the list and on the oak table (http://www.oaktable.net ;-))Anjo."Gogala, Mladen" wrote: Wow! I've been recommending your paper about Oracle7 wait eventseverywhere! I didn't know that you are on this list, too.-Original Message-Sent: Tuesday, February 19, 2002 2:43 AMTo: Multiple recipients of list ORACLE-LHow about iag/iap ? And rpt ? Oh and SQL*Menu ?And there were about 14 enqueue/locks in Oracle Version 5 as far as I canremember.Anjo KolkBrings back memories of joining Oracle Europe in 1985 ;-)- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5.Hemant K ChitalePrincipal DBAChartered Semiconductor Manufacturing LtdRachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AMSent by: [EMAIL PROTECTED]Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback SegmentsUFI no, but the rest... that's where I started in Oracle -- version 5--- "Conboy, Jim" [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory!Does anybody else remember (or admit to) using UFI?Jim**...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Conboy, Jim INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe mes sage 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). __Do You Yahoo!?Yahoo! Sports - Coverage of the 2002 Olympic Gameshttp://sports.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-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, incl ude a l
Re: Rollback Segments
And I'm sitting at my (the) oaktable right now thinking about a few things Jonathan Lewis said an hour ago, sorrounded by good whiskies brought in by Kyle Hailey and Connor McDonald and Jonathan. We still have a few seats available for his Master Class on Monday. You're of course all invited to attend for free and stay in my house... Now let's move a few decades forward, to other great products: Does anyone remember the Oracle Card product? Sure, some do. Now, how many ever saw the email variant of Oracle Card? Do you know what it was called (and I'm not kidding)? Oracle PostCard. Yep. It was probably the first product to handle LONG RAW's. Went out of production so fast you wouldn't beleive it. Pretty much before it went into production. Or how about Oracle Visuelle or whatever it was called? Remember the user group meeting in Paris or Brussels in the late 80's where Larry proudly presented it? I guess it later became Oracle Graphics Anyway, a friend of mine - Mogens Egan - and I stole the EOUG flag (took it down from the pole outside the conference center) and used it for the Danish user group meetings for a while. I wonder where it is now. It carried this cube with Europe on. Anjo Kolk wrote: Thanks.Yes I am on the list and on the oak table (http://www.oaktable.net ;-))Anjo."Gogala, Mladen" wrote: Wow! I've been recommending your paper about Oracle7 wait eventseverywhere! I didn't know that you are on this list, too.-Original Message-Sent: Tuesday, February 19, 2002 2:43 AMTo: Multiple recipients of list ORACLE-LHow about iag/iap ? And rpt ? Oh and SQL*Menu ?And there were about 14 enqueue/locks in Oracle Version 5 as far as I canremember.Anjo KolkBrings back memories of joining Oracle Europe in 1985 ;-)- Original Message -To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5.Hemant K ChitalePrincipal DBAChartered Semiconductor Manufacturing LtdRachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AMSent by: [EMAIL PROTECTED]Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback SegmentsUFI no, but the rest... that's where I started in Oracle -- version 5--- "Conboy, Jim" [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory!Does anybody else remember (or admit to) using UFI?Jim**...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Conboy, Jim INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo 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). __Do You Yahoo!?Yahoo! Sports - Coverage of the 2002 Olympic Gameshttp://sports.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-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: 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 na me 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: Anjo Kolk INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public
RE: Rollback Segments
I used a lot 'ior i' to install our customized databases on new machines...installed oracle ..created database,,initialised it and imported customised database with full dump Those ior commands were wonderful and you may still see it in dbstart and dbshut file to provide backword support by oracle... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Thu, 21 Feb 2002 17:18:20 -0800 And how about the customer who used 'ior i' to 'start up the database' when he should have used 'ior w'??!?!? (for those who have forgotten: ior i - initialize (create) the V5 Db, ior w - warm start the database, ior s - shutdown) Welcome Anjo to this list. We wouldn't have been able do our jobs well without your exposition on 'Wait Events'. John Kanagaraj 5.1.17, 5.1.22, 6.0.27, 6.0.30, 6.0.33, 7.0.14, 7.0.16, 7.1.4, 7.1.6, 7.2.3, 7.3.2, 7.3.4, 8.0.4, 8.0.5, 8.0.6, 8.1.5, 8.1.6, 8.1.7 and finally 9.0.1!! (milestones on my memory lane) -Original Message- Sent: Tuesday, February 19, 2002 2:43 AM To: Multiple recipients of list ORACLE-L How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- 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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
Re: Rollback Segments
Bambi, HLI and OCI - that reminds me of another nice one from the dark ages. Some of you around here, who consider yourself old in terms of Oracle may remember, the oci call osql3(), which was later superceeded by oparse() (version 6/7-ish, I think). Well, the reason for the old call being called osql3() was that it was new with version 3! In version two, osql() was found, but it was limited to 6000 bytes of SQL statement text, where osql3() made it possible to go to to 64k. Rgds, Bjørn. On Tuesday 19 February 2002 20:18, you wrote: Bjorn, you old coot, you've got me beat. I do remember the UFI prompt though... User Friendly Interface... and the real geeks would program their own SQL*Plus environment using HLI (now OCI) with the OROL option which would allow the rollback of a single statement rather than a whole transaction. Now, in my day, we had fire but we had to make our own coal and we kept warm on the hides of old terminals that used to roam the plains. What were things like in your day? Bambi. -Original Message- Sent: Tuesday, February 19, 2002 5:23 AM To: Multiple recipients of list ORACLE-L There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
And how about the customer who used 'ior i' to 'start up the database' when he should have used 'ior w'??!?!? (for those who have forgotten: ior i - initialize (create) the V5 Db, ior w - warm start the database, ior s - shutdown) Welcome Anjo to this list. We wouldn't have been able do our jobs well without your exposition on 'Wait Events'. John Kanagaraj 5.1.17, 5.1.22, 6.0.27, 6.0.30, 6.0.33, 7.0.14, 7.0.16, 7.1.4, 7.1.6, 7.2.3, 7.3.2, 7.3.4, 8.0.4, 8.0.5, 8.0.6, 8.1.5, 8.1.6, 8.1.7 and finally 9.0.1!! (milestones on my memory lane) -Original Message- Sent: Tuesday, February 19, 2002 2:43 AM To: Multiple recipients of list ORACLE-L How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- 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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: Rollback Segments
Bambi, HLI and OCI - that reminds me of another nice one from the dark ages. Some of you around here, who consider yourself old in terms of Oracle may remember, the oci call osql3(), which was later superceeded by oparse() (version 6/7-ish, I think). Well, the reason for the old call being called osql3() was that it was new with version 3! In version two, osql() was found, but it was limited to 6000 bytes of SQL statement text, where osql3() made it possible to go to to 64k. Rgds, Bjørn. On Tuesday 19 February 2002 20:18, you wrote: Bjorn, you old coot, you've got me beat. I do remember the UFI prompt though... User Friendly Interface... and the real geeks would program their own SQL*Plus environment using HLI (now OCI) with the OROL option which would allow the rollback of a single statement rather than a whole transaction. Now, in my day, we had fire but we had to make our own coal and we kept warm on the hides of old terminals that used to roam the plains. What were things like in your day? Bambi. -Original Message- Sent: Tuesday, February 19, 2002 5:23 AM To: Multiple recipients of list ORACLE-L There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
On Tuesday 19 February 2002 20:53, bill thater wrote: i had to do a bunch with SQL*Calc because damagement understood Lotus123. it was less than enjoyable.;-) I was porting SQL*Calc to Unix - that was even less than enjoyable! Rgds, Bjørn. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
Wow! I've been recommending your paper about Oracle7 wait events everywhere! I didn't know that you are on this list, too. -Original Message- Sent: Tuesday, February 19, 2002 2:43 AM To: Multiple recipients of list ORACLE-L How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- 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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: Rollback Segments
Thanks. Yes I am on the list and on the oak table (http://www.oaktable.net ;-)) Anjo. Gogala, Mladen wrote: Wow! I've been recommending your paper about Oracle7 wait events everywhere! I didn't know that you are on this list, too. -Original Message- Sent: Tuesday, February 19, 2002 2:43 AM To: Multiple recipients of list ORACLE-L How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- 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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: Rollback Segments
iag/iap, rpt and sql*menu were for the duhvelopers!. I wouldn't remember these product ; Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Anjo Kolk [EMAIL PROTECTED] 19/02/2002 03:43 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Re: Rollback Segments How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- 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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
Re: Rollback Segments
There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
Actually, the Hercules graphics is able to generate graphics. I had to settle for Hercules since I could not afford a color monitor(using a CGA card) back then. So I looked for games, etc. that had a Hercules graphics mode. And, Hercules used twice the amount of pixels then CGA did, so I was able to find emulation software that allowed me to play CGA color games on my Hercules card. It replaced the limited CGA color pallete with patterns on the amber monitor. Sigh. The good old days... -Original Message- Sent: Monday, February 18, 2002 6:24 PM To: Multiple recipients of list ORACLE-L I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
Man, I remember those days. When I talk to teenagers about having actually worked with such machines, I get a deeper appreciation for the word 'old'. And you actually had a 20MB hard drive. *sigh* On Monday 18 February 2002 06:23 pm, you wrote: I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Dwayne Cox[EMAIL PROTECTED] DBA, Development Department, Info Tech, Inc. 5700 SW 34th Street, Suite 1235 phone: (352) 381.4521 Gainesville, FL 32608 fax: (352) 381. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dwayne Cox INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
Bjorn, you old coot, you've got me beat. I do remember the UFI prompt though... User Friendly Interface... and the real geeks would program their own SQL*Plus environment using HLI (now OCI) with the OROL option which would allow the rollback of a single statement rather than a whole transaction. Now, in my day, we had fire but we had to make our own coal and we kept warm on the hides of old terminals that used to roam the plains. What were things like in your day? Bambi. -Original Message- Sent: Tuesday, February 19, 2002 5:23 AM To: Multiple recipients of list ORACLE-L There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you wanted off of the DUAL table, so why bother with anything else). Now, in IAP, you could put in a %SW in the middle of the questions and IAG, while it was generating, would stop and ask you questions interactively until you entered %SW to have it return to the script. It was a handy way to add fields. User exits were the other big change with v5.1. Prior to that, you could specify any procedure of a C program linked with the form; afterwards, you had to use IAPXIT. Well, enough talking about the good old days. I'm off to do an applications upgrade on a production machine. See you some time next week. ;) Bambi (the geezer). -Original Message- Sent: Tuesday, February 19, 2002 1:43 AM To: Multiple recipients of list ORACLE-L How about iag/iap ? And rpt ? Oh and SQL*Menu ? And there were about 14 enqueue/locks in Oracle Version 5 as far as I can remember. Anjo Kolk Brings back memories of joining Oracle Europe in 1985 ;-) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 19, 2002 6:43 AM I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- 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: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com
RE: Rollback Segments
Bjørn - I remember the joys of Version 3. There was also the fun screen generator program where you had to decide where everything was going by using its character position and you had to enter that by hand. The first pass at most screens was interesting. One of the users referred to UFI as User Surly Interface Ben Schilling -Original Message- Sent: Tuesday, February 19, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Bjorn, you old coot, you've got me beat. I do remember the UFI prompt though... User Friendly Interface... and the real geeks would program their own SQL*Plus environment using HLI (now OCI) with the OROL option which would allow the rollback of a single statement rather than a whole transaction. Now, in my day, we had fire but we had to make our own coal and we kept warm on the hides of old terminals that used to roam the plains. What were things like in your day? Bambi. -Original Message- Sent: Tuesday, February 19, 2002 5:23 AM To: Multiple recipients of list ORACLE-L There must be somebody beside myself remembering version 3, which did not have read consistency - the great new feature of version 4. In 3, doing UFI insert into emp select * from emp; would cause anything from having 28 rows in emp till having and endless loop in the kernel only finishing when your database file ran full... Yep - we are some old bitter men around here... /Bjørn. On Tuesday 19 February 2002 06:43, you wrote: I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Rachel Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: RE: Rollback Segments UFI no, but the rest... that's where I started in Oracle -- version 5 --- Conboy, Jim [EMAIL PROTECTED] wrote: Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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! Sports - Coverage of the 2002 Olympic Games http://sports.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: Rollback Segments
I had a Hercules card too. I needed it to play some RPG game. Funny how many geeks had amber. I was so sick of the green on the VT and Vulcan boxes, I would sniff around for a tvi912c or tvi925 with it's baby blue. And then, of course the VT2xx series came out with its amber and everything was terrific. When I finally got off of VAXes, I was up to something like a VT460 only to go into Unix and set my TERM=vt100. How Neolithic. Pass the arthritis cream. Bambi. -Original Message- Sent: Tuesday, February 19, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Actually, the Hercules graphics is able to generate graphics. I had to settle for Hercules since I could not afford a color monitor(using a CGA card) back then. So I looked for games, etc. that had a Hercules graphics mode. And, Hercules used twice the amount of pixels then CGA did, so I was able to find emulation software that allowed me to play CGA color games on my Hercules card. It replaced the limited CGA color pallete with patterns on the amber monitor. Sigh. The good old days... -Original Message- Sent: Monday, February 18, 2002 6:24 PM To: Multiple recipients of list ORACLE-L I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
[EMAIL PROTECTED] wrote: SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you i had to do a bunch with SQL*Calc because damagement understood Lotus123. it was less than enjoyable.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Avoid temporary variables and strange women. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
I was s excited when I got my Hercules card! That computer was a 10 MHz speed-monster with a gigantic 83 KB hard drive. And WOW, graphics with my new Hercules card! I had such fun running stupid little programs that would make a globe turn, not to mention being able to type in Arabic and see it on the monitor. (Never mind that it took me hours to compose a letter in Arabic.) Before that ... well, it was Intel MDS and Isis, and Computer Automation, and DEC PDP's, and a bunch of OS's and pointer-based line editors that haven't existed for a realy long time now... We had block printers! Remember those? Did you say something about arthritis cream, Bambi ?? --JoJo -Original Message- Bambi Sent: Tuesday, February 19, 2002 11:50 AM To: Multiple recipients of list ORACLE-L I had a Hercules card too. I needed it to play some RPG game. Funny how many geeks had amber. I was so sick of the green on the VT and Vulcan boxes, I would sniff around for a tvi912c or tvi925 with it's baby blue. And then, of course the VT2xx series came out with its amber and everything was terrific. When I finally got off of VAXes, I was up to something like a VT460 only to go into Unix and set my TERM=vt100. How Neolithic. Pass the arthritis cream. Bambi. -Original Message- Sent: Tuesday, February 19, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Actually, the Hercules graphics is able to generate graphics. I had to settle for Hercules since I could not afford a color monitor(using a CGA card) back then. So I looked for games, etc. that had a Hercules graphics mode. And, Hercules used twice the amount of pixels then CGA did, so I was able to find emulation software that allowed me to play CGA color games on my Hercules card. It replaced the limited CGA color pallete with patterns on the amber monitor. Sigh. The good old days... -Original Message- Sent: Monday, February 18, 2002 6:24 PM To: Multiple recipients of list ORACLE-L I do. User Friendly Interface. Hush, don't tell anybody, but I started with Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole machine has had a Hercules screen card (text only, no graphics) and 512KB (no, it's not a mistake, it really is the letter K) of memory. I still have those 3 big, grey boxes with 5 5.25 floppies which used to contain the whole installation. Unfortunately, I cannot install it because I no longer have DOS 3.3 which was required for Oracle 4. Oh well, I seem to be getting old. -Original Message- Sent: Monday, February 18, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Holy cow Mladen, what a memory! Does anybody else remember (or admit to) using UFI? Jim ** ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
RE: Rollback Segments
Hey, Sql*Calc was pretty nice, but it kept changing and then they dropped it for the most part. Sql*Graph was pretty cool in theory, but never could come up with data to make it useful. And don't forget fastform which made things so easy, and rpt as a programming language instead of for reports... The days of micro-VAX and VAX750's. PC version fit on about 10-14 floppies, was it? I may still have them some place. The PC-XT and Dos 3.2 and Oracle 4.1.1 which could run on 512k of memory and you could write a distributed Order Entry system on it and tie it all back to a corporate VAX, before Sql*Net. Yea, them were the days... Michael Kline ThinkSpark Richmond, VA 804-744-1545 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of bill thater Sent: Tuesday, February 19, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Rollback Segments [EMAIL PROTECTED] wrote: SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you i had to do a bunch with SQL*Calc because damagement understood Lotus123. it was less than enjoyable.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Avoid temporary variables and strange women. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
Title: RE: Rollback Segments Does anyone have older copies of Oracle 4, and the equivalent version of forms? PVT Email me, please. -Original Message- From: Michael Kline [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Rollback Segments Hey, Sql*Calc was pretty nice, but it kept changing and then they dropped it for the most part. Sql*Graph was pretty cool in theory, but never could come up with data to make it useful. And don't forget fastform which made things so easy, and rpt as a programming language instead of for reports... The days of micro-VAX and VAX750's. PC version fit on about 10-14 floppies, was it? I may still have them some place. The PC-XT and Dos 3.2 and Oracle 4.1.1 which could run on 512k of memory and you could write a distributed Order Entry system on it and tie it all back to a corporate VAX, before Sql*Net. Yea, them were the days... Michael Kline ThinkSpark Richmond, VA 804-744-1545 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of bill thater Sent: Tuesday, February 19, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Rollback Segments [EMAIL PROTECTED] wrote: SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1 (it was the first of the SQL*Forms). RPT/RPF were there too. And there was something called SQL*Calc which I never used (cuz you could do anything you i had to do a bunch with SQL*Calc because damagement understood Lotus123. it was less than enjoyable.;-) -- -- Bill Shrek Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. Avoid temporary variables and strange women. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Kline INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback Segments
Hello DBAs Is there a command that tells me which rollback segment is being used by current transaction? Also, can you force a session to use particular rollback segment? I have used in the past the command: set transaction use rollback segment rbs_01 but the named rollback segment seemed to be used until the end of tranasction. After a commit or rollback a different rollback segment could have been used by Oracle. I wonder if there is a way to make sure that once a user logs in, a particular rollback segment is used. Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Segments
Hi Witold, This is exactly the way it is documented to work. After each commit you must reissue the set transaction use rollback segment rbs_01 statement. John [EMAIL PROTECTED] wrote: Hello DBAs Is there a command that tells me which rollback segment is being used by current transaction? Also, can you force a session to use particular rollback segment? I have used in the past the command: set transaction use rollback segment rbs_01 but the named rollback segment seemed to be used until the end of tranasction. After a commit or rollback a different rollback segment could have been used by Oracle. I wonder if there is a way to make sure that once a user logs in, a particular rollback segment is used. Thanks Witold == Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: orantdba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).