test mail -- plz ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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: Multithreaded server - effect of POOLING=ON option
Hi Peter, pooling is for: user that connected but idle will be disconnected temporary for new incoming or outgoing request. ON or BOTH or YES or TRUE is to turn on OFF or FALSE or NO is default to turn off IN for incoming connection only OUT for outgoing connection only Sinardy -Original Message- Sent: 12 November 2003 13:04 To: Multiple recipients of list ORACLE-L Hi Peter, There are many parameters for this particular option: ON, OFF, YES, NO, IN, OUT, TRUE, FALSE, BOTH (not even sure I've exhausted the entire list here) Used for connection pooling, the values you choose for this parameter impact your idle network connections. For more info, feel free to check out this link: http://download-west.oracle.com/docs/cd/B10501_01/network.920/a96580/mts.htm#453787 hth, melanie --- Schauss, Peter [EMAIL PROTECTED] wrote: Thanks for all of the input on the multi-threaded server. I have one more question: What is the effect of the POOLING option on the MTS_DISPATCHERS specification? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Melanie Caffrey 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: Sinardy Xing 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: Clean temporary tablespace
Hi, Restartup your database if possible. If you set the datafile autoextent on then you have to recreate that tablespace, if you set it to not autoextent on for some query may fail due to not enough sorting space. Sinardy -Original Message- Sent: 12 November 2003 14:24 To: Multiple recipients of list ORACLE-L Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Sinardy Xing 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: PCTFREE, PCTUSED and ASSM
Hi Mladen, Don't desert me now, I thought we've come a long way !! Although, I'm not a listed Oracle guru, let me try and explain further ;) PCTFREE works in almost exactly the same way as it does for non-ASSM objects. PCTFREE determines how much of the block we want to reserve for subsequent update growth. An insert that would violate this figure would result in the block being taken off the freelist (and other block being considered). However, with ASSM we don't have freelists, instead the corresponding BMB is updated to now reflect the block as being full. So an insert that would violate pctfree causes the block to be considered full and a full block is longer considered for subsequent inserts. Note an advantage of ASSM is that blocks can be filled more effectively because we know the relative free space in a given block thanks to the BMBs. So for example, if we have a row that is greater than 25% of a block in length, those blocks with less than 25% free space are not considered for inserts as we know such inserts would not succeed (in these blocks). Only blocks with over 25% free space are therefore considered. This way, rows of a relatively large size are less likely to prematurely make a block unavailable for inserts as is possible with non-ASSM tables. Thus, tables with widely variable row lengths are more suited to ASSM and could pack data in more tightly. For a block to be made available again for inserts, we need the available free space to be reduced below one of the free space boundaries. So for example, if a PCTFREE of 10% is used, once we have more than 25% free space (ie. the free space is between 25% and 50%) the block becomes unfull and the corresponding BMB is updated. Therefore the effective PCTUSED in this case is 75%. If however the PCTFREE were set to 30%, then we need to get below the 50% free space boundary (ie. free space is between 50-75%) in order to be insertable again, an effective PCTUSED of 50%. So in summary, PCTFREE is effectively used in a similar manner with ASSM, but rather than being taken off a freelist, the block is marked as full by the corresponding BMB. The PCTFREE value also has an influence on what with effective PCTUSED is used within the block as well. Hope this clears things up a bit(map ;) Cheers Richard (Non Oracle Guru / All Round Nice Guy ) - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 6:24 AM Int the note 247752.1 named Oracle9i Space Management Demystified oracle says the following: -- - AUTOMATIC SEGMENT SPACE MANAGEMENT ARCHITECTURE Oracle9i introduces a new way of managing free space within a segment using bitmaps. In the new scheme, a set of bits describes the space utilization for each block in a segment as well as whether it is formatted or not. Using these Paper # 32707 Oracle9i Database bits, for example, it is possible to represent the state of any given data block as follows: Free space in the block is less than 25% Free space in the block is greater than 25% and less than 50% Free Space in the block is greater than 50% but less than 75% Free space in the block is more than 75% The block is FULL i.e. there is no free space in the block The block is unformatted. It can be noted here that unlike freelists, where a block was either available for new rows or not, bitmaps provide a more granular and accurate idea of space utilization within blocks of segment. For LOBs and indexes, the bitmap just indicate Whether the block is formatted or not and, Whether the block is considered free or not. The Automatic Segment Space Management feature can only be used with Locally Managed Tablespaces. BITMAP BLOCKS The bitmaps are contained in a set of meta-data blocks known as bitmap blocks or BMBs. The number of BMBs in a segment depends on its size and the space consumed by the bitmap blocks is typically a very small part (less than 1%) of the total segment size for any reasonable sized segment. As shown in the table below, the space overhead of bitmap blocks decreases as the segment grows and becomes close to negligible for large segments. Segment Size Block Size No. Of BMBs Space Used by BMBs BMB Space Overhead 25 MB2 KB 201 400 KB .8% 500 MB 8 KB 251 2 MB .4% 100 TB 16KB 6555941 100 GB .05% -- -- From that, it would follow that free lists as such are gone in ASSM tablespaces and are replaced by bitmaps. As Richard Foote has shown, PCTFREE is not ignored, but without free lists, it doesn't make much sense. Does any of the gurus (Cary, Steve, Jonathan, Wolfgang, Pete Sharman) have any knowledge of how exactly PCTFREE is implemented in the ASSM situation? I can see and
RE: OT (DB2)
Many thanks. I am back on again. Regards Lee -Original Message- Sent: 11 November 2003 21:59 To: Multiple recipients of list ORACLE-L -Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 November 2003 00:45 To: Multiple recipients of list ORACLE-L Subject: OT (DB2) Hi, Anyone out there who used to be subscribed to the DB2-L listserv. Since it moved hosts, I have received no more emails and cannot register for the new one. Regards Lee Lee, it's definitely up and running, and Phil (Gunning) said that existing subscriptions had migrated. Here's the footer from current messages - might help troubleshoot your subscription. Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L archives webpage at http://www.idugdb2-l.org/archives/db2-l.html. From that page select Join or Leave the list. The IDUG List Admins can be reached at [EMAIL PROTECTED] Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen 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). ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robertson Lee - lerobe 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: (looong) PCTFREE, PCTUSED and ASSM
Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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).
bug info, not displayed!!
List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma 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: bug info, not displayed!!
Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: bug info, not displayed!!
Hmmm ... you saw only a through d ... that's why ... There is another bullet point .. e. This bug is caused by one of our stupid developers, but it is embarrassing for us to discuss that in public. ps: if you want details on that bug, log and itar ... and pray. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, November 12, 2003 7:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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).
Logical StandBy question
Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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: Logical StandBy question
yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Fwd: Looking for help.
I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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).
AW: Looking for help.
Hi We do something similiar, but instead of deleting the tables beforehand, I just use the SQL*LOADER REPLACE option. No such problems as described in the original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k. Regards, Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Stefan Jahnke 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: Looking for help.
Windows 3000? -Original Message- Sent: Wednesday, November 12, 2003 7:44 AM To: Multiple recipients of list ORACLE-L Hi We do something similiar, but instead of deleting the tables beforehand, I just use the SQL*LOADER REPLACE option. No such problems as described in the original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k. Regards, Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Stefan Jahnke 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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in
RE: Clean temporary tablespace
Or you can 1. Create another Temporary Tablespace with CREATE TEMPORARY TABLESPACE new_temporary_tablespace TEMPFILE . SIZE ... AUTOEXTEND ON NEXT .. MAXSIZE ... 2. Issue ALTER USER TEMPORARY TABLESPACE new_temporary_tablespace commands 3. If running 9.2 with a Default Temporary Tablespace, ALTER DATABASE DEFAULT TEMPORARY TABLESPACE new_temporary_tablespace 4. Check that there are no active sessions still using the existing Temporary Tablespace, querying V$SORT_SEGMENT and also use the Unix fuser command against the Temporary Tablespace Tempfiles 5. DROP TABLESPACE current_temporary_tablespace INCLUDING CONTENTS [add AND DATAFILES if using 9.2] Note : Ensure that you really have no segments in the tablespace other than the temporary segment [ie, it is really a temporary tablespace ! because the DROP TABLESPACE command syntax doesn't specify if it is a TEMPORARY or PERMANENT tablespace] 6. Recreate your original Temporary Tablespace 7. Run through Steps 2 and 3 again to revert to the original Temporary Tablespace 8. Run Steps 4 and 5 to drop the new_temporary_tablespace Because, bouncing or restarting the Database Instance isn't always an available option! Hemant At 12:05 AM 12-11-03 -0800, you wrote: Hi, Restartup your database if possible. If you set the datafile autoextent on then you have to recreate that tablespace, if you set it to not autoextent on for some query may fail due to not enough sorting space. Sinardy -Original Message- Sent: 12 November 2003 14:24 To: Multiple recipients of list ORACLE-L Hello! How can I clean temporary tablespace? It grows up faster and faster. -- ðÏÃÅÌÕÅ× ÷ÉÔÁÌÉÊ éÇÏÒÅ×ÉÞ (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: Sinardy Xing 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). Hemant K Chitale Oracle 9i Database Administrator Certified Professional My personal web site is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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).
anyone take the 8i performance tuning ocp test?
Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- 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: Logical StandBy question
Juan, How can you create Schema in STANDBY database that does not exist in Primiary database?? Can you give me an example? Muqthar Ahmed -Original Message- Sent: Wednesday, November 12, 2003 8:24 AM To: Multiple recipients of list ORACLE-L yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Muqthar Ahmed 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: Re[2]: var source_data varchar2(12)
I never use those. I find it better not to be overly smart with sqlplus. Sqlplus is a program for ad-hoc queries from the command line and for the administrative functions (startup/shutdown, alter database/system), nothing more and nothing less. If I need a program, I can either write a PL/SQL block, anonymous or not, or a program in another language, like perl, C or C++. As a DBA tool, sqlplus is not very well suited for general developer or user population. SQL*Plus has a ghastly and disgusting user interface, implemented without readline or equivalent, which would give a command history. Littering the system with those @#$%! afiedt.buf files is bad enough but line editting commands are an indicator of how much oracle cares for the user interface. They've had several catastrophic failures (Oracle*Media - does anybody still remember the Ellison's pizza presentation when he ordered a pizza using interactive TV? Oracle Developer is another monumental flop. They've lost a significant portion of the market after transition from SQL*Forms 3.0 - Developer 2000, which was practically unusable ) because of the inadequate user interface and sqlplus is definitely not something that I'd like presenting to my users. Using features like var and print is, in my opinion, being too smart for one's own good. If you need a report on permanent basis, write a perl script. Perl, after all, is a reporting tool (Practical Extraction and Reporting Language) with a phenomenal regular expression engine. Sqlplus, on the other side, is a DBA tool. If the company is willing to spend some money, there are always Crystal Reports, Business Objects and VB/VC++ for creating data entry forms. OEM is jet another example of oracle's user interface blunder, with it's slow speed, huge memory consumption and parts that simply do not work (change management pack) On 11/11/2003 07:59:24 PM, Jonathan Gennick wrote: Tuesday, November 11, 2003, 5:44:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG Of course, within sqlplus one can only use it to invoke another MG PL/SQL procedure. You can also PRINT (SQL*Plus command) the value of a REFCURSOR variable returned by a stored procedure to generate a SQL*Plus report. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Logical StandBy question
Short answer: look in the manuals. Longer answer: a LOGICAL standby database does not get updated in the same manner as a PHYSICAL standby database. Logical Standby is simply a database which is updated via SQL statements generated from the archived redo logs, not application of the archived redo logs themselves. so you can do anything in the logical standby (including creating additional indexes on the tables from the primary database) that you can do in a regular database with the exception (from memory so this may be wrong) that the tables that are in the primary database must be read-only in the standby --- Muqthar Ahmed [EMAIL PROTECTED] wrote: Juan, How can you create Schema in STANDBY database that does not exist in Primiary database?? Can you give me an example? Muqthar Ahmed -Original Message- Sent: Wednesday, November 12, 2003 8:24 AM To: Multiple recipients of list ORACLE-L yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Muqthar Ahmed 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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: (looong) PCTFREE, PCTUSED and ASSM
I believe it's direct read from files in parallel execution, nothing gets read from cache. Cached blocks for the table get flushed to files before the direct read. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 7:10 AM To: Multiple recipients of list ORACLE-L Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Khedr, Waleed 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: Fwd: Looking for help.
I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Logical StandBy question
The question was about LOGICAL standby database. From your point of view it is like a regular database and you can create schema in it. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:14 PM Juan, How can you create Schema in STANDBY database that does not exist in Primiary database?? Can you give me an example? Muqthar Ahmed -Original Message- Sent: Wednesday, November 12, 2003 8:24 AM To: Multiple recipients of list ORACLE-L yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Muqthar Ahmed 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: 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: bug info, not displayed!!
the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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: SQL comparison addition:
I'll try tracing the session.
Global.client_dim is just a table with client info and a column that
corresponds to client logins to enable row level security.
Thanks for the suggestions.
As stated earlier..i'll post the resolution.
chris
-Original Message-
Sent: Tuesday, November 11, 2003 4:39 PM
To: Multiple recipients of list ORACLE-L
You can flush shared pool, optionally, then enable SQL tracing and CBO
tracing and check the trace file, anyway you will be asked to do that
when you open a tar. What Oracle version do you use?
What's the object you're referencing in your query -- global.client_dim?
Is it a [partitioned] table, [m]view or synonym for some other object?
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Chris Stephens wrote:
SQL select sys_context('userenv','session_user'),
2 dump(sys_context('userenv','session_user')), a.reports_login,
3 dump(a.reports_login)
4 from global.client_dim a
5 WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN);
SYS_CONTEXT('USERENV','SESSION_USER')
DUMP(SYS_CONTEXT('USERENV','SESSION_USER'))
REPORTS_LOGIN
--
DUMP(A.REPORTS_LOGIN)
REPORTS_DELTA
Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65
REPORTS_DELTA
Typ=1 Len=13: 82,69,80,79,82,84,83,95,68,69,76,84,65
And
1 SELECT count(*)
2 FROM global.client_dim a
3* WHERE sys_context('userenv','session_user') =
trim(a.REPORTS_LOGIN)
SQL /
COUNT(*)
--
0
I'm going to open a tar on this.
I will email the resolution. ...and check for any more suggestions! :)
Chris
-Original Message-
Sent: Tuesday, November 11, 2003 2:24 PM
To: Multiple recipients of list ORACLE-L
Chris
There is a contradiction below:
Chris Stephens wrote:
SQL select sys_context('userenv','session_user'),
2 dump(sys_context('userenv','session_user')), a.reports_login,
3 dump(a.reports_login)
4 from global.client_dim a
5 WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN;
Produces some output.
Your original query does not return anything.
1 SELECT count(*)
2 FROM global.client_dim a
3* WHERE sys_context('userenv','session_user') =
trim(a.REPORTS_LOGIN)
The obvious differences here are:
. TRIM function
. probably when you've tried to launch the original query you had pofile
functions enabled, when you tried it second time it was disabled.
. query rewrite is used (could be, right?)
Could you please check the second and third items?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Vladimir Begun
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: Chris Stephens
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: bug info, not displayed!!
alright already. I think we got the message ! ;-) -Original Message- Sent: 12 November 2003 14:30 To: Multiple recipients of list ORACLE-L the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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). ** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this
Re: Re[2]: var source_data varchar2(12)
I never use those. I find it better not to be overly smart with sqlplus. Sqlplus is a program for ad-hoc queries from the command line and for the administrative functions (startup/shutdown, alter database/system), nothing more and nothing less. If I need a program, I can either write a PL/SQL block, anonymous or not, or a program in another language, like perl, C or C++. As a DBA tool, sqlplus is not very well suited for general developer or user population. SQL*Plus has a ghastly and disgusting user interface, implemented without readline or equivalent, which would give a command history. Littering the system with those @#$%! afiedt.buf files is bad enough but line editting commands are an indicator of how much oracle cares for the user interface. They've had several catastrophic failures (Oracle*Media - does anybody still remember the Ellison's pizza presentation when he ordered a pizza using interactive TV? Oracle Developer is another monumental flop. They've lost a significant portion of the market after transition from SQL*Forms 3.0 - Developer 2000, which was practically unusable ) because of the inadequate user interface and sqlplus is definitely not something that I'd like presenting to my users. Using features like var and print is, in my opinion, being too smart for one's own good. If you need a report on permanent basis, write a perl script. Perl, after all, is a reporting tool (Practical Extraction and Reporting Language) with a phenomenal regular expression engine. Sqlplus, on the other side, is a DBA tool. If the company is willing to spend some money, there are always Crystal Reports, Business Objects and VB/VC++ for creating data entry forms. OEM is jet another example of oracle's user interface blunder, with it's slow speed, huge memory consumption and parts that simply do not work (change management pack) On 11/11/2003 07:59:24 PM, Jonathan Gennick wrote: Tuesday, November 11, 2003, 5:44:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG Of course, within sqlplus one can only use it to invoke another MG PL/SQL procedure. You can also PRINT (SQL*Plus command) the value of a REFCURSOR variable returned by a stored procedure to generate a SQL*Plus report. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Looking for help.
That's the target year for the stable and secure release of MS Windows. HAL:What are you doing Dave? David Bowman: I'm turning you off, HAL. On 11/12/2003 08:49:26 AM, Nelson, Allan wrote: Windows 3000? -Original Message- Sent: Wednesday, November 12, 2003 7:44 AM To: Multiple recipients of list ORACLE-L Hi We do something similiar, but instead of deleting the tables beforehand, I just use the SQL*LOADER REPLACE option. No such problems as described in the original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k. Regards, Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Stefan Jahnke 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: Fwd: Looking for help.
IIRC, direct path loads invalidate indexes. As the execution plan may use this index, it makes sense that any statements referencing these tables will be invalidated and need to be reparsed. I've never tested this, but it makes sense (at least Oracle sense). As for the 4031 errors, could they be related to the reloading of the dictionary cache? I can't quite reason this one out, but it's early here in the Rockies and a storm is blowing in (feel free to hum Ridin' The Storm Out by REO Speedwagon). Daniel Fink Jonathan Gennick wrote: I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Daniel 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: How do you genrate primary keys?
sandali- may tatapusin lang ako. I'll call you in 30 minutes. wrote: You're much too nice. Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100 cc: @yahoo.com Subject: Re: How do you genrate primary keys? Sent by: ml-errors 11/05/2003 09:44 AM Please respond to ORACLE-L It was a compromise... since they had already written their code, I put in the triggers so that it was transparent to them that the key they were generating was not being used. I had to give them something, since I was really trying hard NOT to say I told you so! --- Yong Huang [EMAIL PROTECTED] wrote: Rachel, That's a good case to remember. Java programmers (or architects) sometimes miss those little things. I would ask why you used triggers to populate the PK field instead of saying INSERT ... MYSEQUENCE.NEXT_VAL in the code, or even INSERT ... SELECT ROWNUM (or ROWNUM+somefixedvalue). Wouldn't these perform better? Yong Huang --- Rachel Carmichael [EMAIL PROTECTED] wrote: At one site I worked at, the programmers insisted on using Java milliseconds as the primary key -- so that they wouldn't have to hit the database twice (once to get the sequence number, once to insert the row). They swore up, down and six ways from Sunday that there could never, ever, EVER be a collision. After we had collisions in development, we switched to sequences (one per table), with a trigger to populate the field on insert so that they wouldn't have to make the second round-trip. --- Jonathan Gennick [EMAIL PROTECTED] wrote: The recent article that mentioned sequences got me to thinking. I might pitch a more detailed article on sequences to Builder.com. But a more interesting article might be one that explored various ways to automatically generate primary keys. So, in the name of research, let me throw out the following questions: What mechanisms have you used to generate primary keys? Which ones worked well, and why? Which mechanisms worked poorly? I've run up against the following approaches: * Hit a table that keeps a counter. This is the roll your own sequence method. The one time I recall encountering this approach, I helped convert it over to using stored sequences. This was because of concurrency problems: with careful timing, two users could end up with the same ID number for different records. Is there ever a case when this roll-your-own approach makes sense, and is workable? * Stored sequences. I worked on one app that used a separate sequence for each automatically generated primary key. I worked on another app, a smaller one, that used the same sequence for more than one table. The only issue that I recall is that sometimes numbers would be skipped. But end users really didn't care, or even notice. * The SYS_GUID approach. I've never used SYS_GUID as a primary key generator. I wonder, was that Oracle's motivation for creating the function? Has anyone used it for primary keys in a production app? What's the real reason Oracle created this function? * Similar to SYS_GUID, I once worked on an obituary-tracking application that built up a primary key from, as best I can recall now: date of death, part of surname, part of first name, and a sequence number used only to resolve collisions, of which there were few. The approached worked well, actually, because whatever fields we munged together to generate a primary key gave us a unique key the vast majority of the time. The SYS_GUID approach is interesting, but if you need an ID number that users will see, and that users might type in themselves (e.g. social security number), is SYS_GUID really all that viable? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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
Re: (looong) PCTFREE, PCTUSED and ASSM
As a strange thing, from 10046 trace I saw that normal table scanning was done using direct reads, this was expected behaviour, but the lookups of migrated rows were reflected as 'db file sequential reads'. And even more, there were 3 subsequent sequential read waits for the same datablock in a row, it seems that a PX slave isn't even able to cache one datablock in it's PGA, in case of finding migrated rows... (or a wait event is registered for reading from cache...) I was just wondering, why a PQ FTS requires resolving migrated rows immediately, instead of reading them when scan hits their location. Could it be some concurrency issue, that if a row migrates to another location during the scan, then results could get inconsistent? It is not a direct read issue, because I experimented using _serial_direct_read parameter, and for regular FTS, no migrated rows were resolved ahead. There's lot to learn... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM I believe it's direct read from files in parallel execution, nothing gets read from cache. Cached blocks for the table get flushed to files before the direct read. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 7:10 AM To: Multiple recipients of list ORACLE-L Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Khedr, Waleed 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: Tanel Poder 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: bug info, not displayed!!
Enough already! Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- rahul Sent: Wednesday, November 12, 2003 9:30 AM To: Multiple recipients of list ORACLE-L the bug no. is correct, it relates to forms 6i (running on web) is not able to connect to the DB when using ASO, and third party authentication (securID) we have configured sucureID authentication for our DB, but out back office app using forms6i does not connect to the DB when this is configured.. when i remark the lines in sqlnet.ora, it can connect. there is so little information regarding using web forms, and third party authentication , methods.. On Wed, 12 Nov 2003 04:34:40 -0800, DENNIS WILLIAMS [EMAIL PROTECTED] wrote : Rahul Are you certain you have the correct number? What is the bug about -- you may be able to search using alternate words. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 6:30 AM To: Multiple recipients of list ORACLE-L List, i need some help on this... i am trying to get information on this but , and the patches available, the bug no is 1809113. but metaling does not allow to display this bug !!! even when i use my PARTNERS login !!! a.. The bug is not classified as publicly accessible (non-public). b.. The bug is filed under a product for which you have no license. To view your product licenses go in your User profile and select the Show License option. c.. The bug was filed before June 1996. Only bugs that were opened after this date are accessible on this server. d.. The bug number does not exist (it was referenced incorrectly). i need info on this but to patch my forms6i server using ASO and secureID authentication. i would appreciate if someone can give me info on this bug. -rahul -- -- -- -- The information contained in this email and its attachments if any may contain privileged and confidential information intended only for the attention of the recipient(s) specified. If you are not a recipient , any forwarding , disclosure , photocopying , distribution or use of the information in any way is prohibited . If you have received this email in error , please email us immediately on [EMAIL PROTECTED] or contact us on (62 21) 522 8775. -- -- -- -- - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul 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: Igor Neyman 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
Re: Clean temporary tablespace
Perhaps you could clarify what you mean by 'it grows up faster and faster'. What exactly does that mean, what script or tool is showing you that, what is its output, and why is it a problem? Restarting the database seems extreme advice for such a meager description of a problem. Jared On Tue, 2003-11-11 at 22:24, VirVit wrote: Hello! How can I clean temporary tablespace? It grows up faster and faster. -- (VirVit) Oracle 9i DBA beginner -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VirVit 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: 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: Logical StandBy question
Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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: (looong) PCTFREE, PCTUSED and ASSM
Tanel, Maybe a PQ FTS needs to resolve migrated rows immediately as it's possible that the migrated row is located in a block that's allocated to a different PQ slave. Chris -Original Message- Sent: 12 November 2003 15:49 To: Multiple recipients of list ORACLE-L As a strange thing, from 10046 trace I saw that normal table scanning was done using direct reads, this was expected behaviour, but the lookups of migrated rows were reflected as 'db file sequential reads'. And even more, there were 3 subsequent sequential read waits for the same datablock in a row, it seems that a PX slave isn't even able to cache one datablock in it's PGA, in case of finding migrated rows... (or a wait event is registered for reading from cache...) I was just wondering, why a PQ FTS requires resolving migrated rows immediately, instead of reading them when scan hits their location. Could it be some concurrency issue, that if a row migrates to another location during the scan, then results could get inconsistent? It is not a direct read issue, because I experimented using _serial_direct_read parameter, and for regular FTS, no migrated rows were resolved ahead. There's lot to learn... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM I believe it's direct read from files in parallel execution, nothing gets read from cache. Cached blocks for the table get flushed to files before the direct read. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 7:10 AM To: Multiple recipients of list ORACLE-L Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Khedr, Waleed 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: Tanel Poder 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: Dunscombe, Chris 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
RE: anyone take the 8i performance tuning ocp test?
Ryan - I took the 8i OCP for Tuning. I used Couchman to study with, and don't recall any big differences with the exam. The exam is prepared from the Oracle Education Student Guide for Oracle 8i. That would have been a couple of years ago, and if Oracle Education was teaching hit ratios back then, then you better know the answers on the exam. I thought Cary put it best in quoting his father: There is the right answer and the answer the teacher expects, and I expect you to know them both. When I took the 9i version of the Oracle Tuning class, they were in the process of shifting away from hit ratios. I expect by the time 10g rolls around Cary's book will have had a deep impact on Oracle Education. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 8:09 AM To: Multiple recipients of list ORACLE-L Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OCP 9i New Features for DBAs
Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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: (looong) PCTFREE, PCTUSED and ASSM
Using PQ, the segment is split into multiple sub-segments using rowid range scan. Since there is no guarantee that the migrated row will be in the same sub-segment that has the pointer to the migrated row, the PQ slave might need to resolve the issue real time. I mean the migrated row might exist in a different range that will be scanned by another PQ slave. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 10:49 AM To: Multiple recipients of list ORACLE-L As a strange thing, from 10046 trace I saw that normal table scanning was done using direct reads, this was expected behaviour, but the lookups of migrated rows were reflected as 'db file sequential reads'. And even more, there were 3 subsequent sequential read waits for the same datablock in a row, it seems that a PX slave isn't even able to cache one datablock in it's PGA, in case of finding migrated rows... (or a wait event is registered for reading from cache...) I was just wondering, why a PQ FTS requires resolving migrated rows immediately, instead of reading them when scan hits their location. Could it be some concurrency issue, that if a row migrates to another location during the scan, then results could get inconsistent? It is not a direct read issue, because I experimented using _serial_direct_read parameter, and for regular FTS, no migrated rows were resolved ahead. There's lot to learn... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM I believe it's direct read from files in parallel execution, nothing gets read from cache. Cached blocks for the table get flushed to files before the direct read. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 7:10 AM To: Multiple recipients of list ORACLE-L Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Khedr, Waleed 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: Tanel Poder 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: Khedr, Waleed 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
Re: Logical StandBy question
There are two kinds of standby database: physical and logical. The original post referred to logical standby. The normal state of a logical standby database is open, and it can contain schemas and objects that do not exist in the primary. Check the manuals again! ;-) --- Jose Luis Delgado [EMAIL PROTECTED] wrote: Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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: Logical StandBy question
I think you're confusing physical and logical standby databases. Logical standby databases aren't in recovery mode. --Walt Weaver Bozeman, Montana On Wed, 2003-11-12 at 09:09, Jose Luis Delgado wrote: Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver 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: Fwd: Looking for help.
Is there a primary key on the table ? Regards, Denny Jonathan Gennick wrote: I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Denny Koovakattu 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: Re: Logical StandBy question
Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: OCP 9i New Features for DBAs
Runs on 9.2 but there's nothing specific to 9.2 rather than 9.0, IIRC. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no, it's not. It's much harder than that! Bruce Pihlamae, long term Oracle DBA. -Original Message- Dunscombe, Chris Sent: Thursday, November 13, 2003 3:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris 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: Pete Sharman 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: (looong) PCTFREE, PCTUSED and ASSM
Maybe, the process that read the block use the same logic to pass the rows out, no matter if it FTS or direct block read. So this logic resolved migrated rows in the block that was passed to him. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:49 PM As a strange thing, from 10046 trace I saw that normal table scanning was done using direct reads, this was expected behaviour, but the lookups of migrated rows were reflected as 'db file sequential reads'. And even more, there were 3 subsequent sequential read waits for the same datablock in a row, it seems that a PX slave isn't even able to cache one datablock in it's PGA, in case of finding migrated rows... (or a wait event is registered for reading from cache...) I was just wondering, why a PQ FTS requires resolving migrated rows immediately, instead of reading them when scan hits their location. Could it be some concurrency issue, that if a row migrates to another location during the scan, then results could get inconsistent? It is not a direct read issue, because I experimented using _serial_direct_read parameter, and for regular FTS, no migrated rows were resolved ahead. There's lot to learn... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM I believe it's direct read from files in parallel execution, nothing gets read from cache. Cached blocks for the table get flushed to files before the direct read. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 7:10 AM To: Multiple recipients of list ORACLE-L Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Khedr, Waleed 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: Tanel Poder 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: 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
Re: Logical StandBy question
took me exactly two clicks to find the following: Oracle9i Release 2 (9.2) New Features in Data Guard The features and enhancements described in this section were added to Data Guard in Oracle9i release 2 (9.2). * Logical standby database Until now, there has been only the physical standby database implementation, in which the standby database can be in either recovery mode or in read-only mode. A physical standby database is physically equivalent to the primary database, and, while the database is applying logs it cannot be opened for reporting and vice versa. A logical standby database has the same logical schema as the primary database but may have different physical objects, such as additional indexes. With logical standby databases, you can have the database available for reporting and applying the logs to the standby log at the same time. --- Jose Luis Delgado [EMAIL PROTECTED] wrote: Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Fwd: Looking for help.
Jonathan, I don't see where the TRUNCATE command is used in the original request message. The 20 staging tables have a delete action against them. The data is sqlldr action to load the tables. The final tables are loaded from the staging tables using a PL/SQL procedure. The final tables are cleaned up using a PL/SQL procedure. The ORA-04031 is most likely caused by one of the PL/SQL procedures not releasing the memory stack. It takes a few days of loading before the failure occures. I would look into the os and possible the I/O. is it buffered and the sqlldr is looking at the physical not buffered area or vise-versa? Are the table cached? The sqlldr command is run and the previous delete from staging tables commands are invalidated? Is there a change of ownership on the tables at this time? Just a few random thoughts that may or may not invoke someone elses thought process. Ron [EMAIL PROTECTED] 11/12/2003 9:34:33 AM I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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
Re: Fwd: Looking for help.
Jonathan, I don't see where truncate is being invoked, though I am not a big user of sql*loader. Truncate should invalidate statements. Daniel Jonathan Gennick wrote: I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Daniel 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
RE: Re: Logical StandBy question
Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver 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: OCP 9i New Features for DBAs
Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Looking for help.
There are two options to replace all data in the table: REPLACE and TRUNCATE which are equivalent to truncate and delete sql statements. If you have staging tables without RI or triggers then use truncate. Using delete just takes a lot longer and use a lot more resources. We use TRUNCATE almost exclusively. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:44 PM Hi We do something similiar, but instead of deleting the tables beforehand, I just use the SQL*LOADER REPLACE option. No such problems as described in the original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k. Regards, Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Stefan Jahnke 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
RE: Re: Logical StandBy question
Hi all, As Stephane told, logical standby (LSB) has a lot of tiny little exceptions and special issues to cope with. I've done one implementation in production until now (did appr. 20 Physical Standby sites as well). But, even that site uses 2 LSB's as reporting systems, and has a PSB for the HA issue. Feel free to ask more. Regards, Carel-Jan At 08:49 12-11-03 -0800, you wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile+31 (0) 653 911 950 e-mail [EMAIL PROTECTED]
Re: Looking for help.
yeah but... if you attempt (as I do) to isolate the schema owner from the users which have select/insert/update/delete privileges, TRUNCATE won't work unless you have granted DROP ANY TABLE (I *really* hate that that is required) to the account which does the actual sql load. So I use REPLACE, because then I only have to grant the delete priv on that table. --- Yechiel Adar [EMAIL PROTECTED] wrote: There are two options to replace all data in the table: REPLACE and TRUNCATE which are equivalent to truncate and delete sql statements. If you have staging tables without RI or triggers then use truncate. Using delete just takes a lot longer and use a lot more resources. We use TRUNCATE almost exclusively. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:44 PM Hi We do something similiar, but instead of deleting the tables beforehand, I just use the SQL*LOADER REPLACE option. No such problems as described in the original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k. Regards, Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Stefan Jahnke INET: [EMAIL
RE: Re: Logical StandBy question
there was a thread -- Paul Baumgartel started it looking for information on logical standby. IIRC, he found that there were a few gotchas -- check the fatcity archives. I do know that since it's based on Logminer technology, it has the same limitations that Logminer does --- Walt Weaver [EMAIL PROTECTED] wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver 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!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
New interface on Metalink to do queries ...
Title: New interface on Metalink to do queries ... I found it today ... http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT_id=102421.1 Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! **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.**4
Re: Fwd: Looking for help.
Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron [EMAIL PROTECTED] 11/12/2003 12:04:35 PM Jonathan, I don't see where truncate is being invoked, though I am not a big user of sql*loader. Truncate should invalidate statements. Daniel Jonathan Gennick wrote: I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee JG -- JG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Daniel Fink
Re: Fwd: Looking for help.
KamYee, Can we take a look at the SQL*Loader control file? Also the output of select * from v$sql where lower(sql_text) like '%yourstagingtable%' and invalidations 0 Yong Huang --- Jonathan Gennick [EMAIL PROTECTED] wrote: I wonder whether the invalidation comes about from the use of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL to a table would invalidate existing SQL statements. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick ([EMAIL PROTECTED]) wrote: JG I don't usually forward my reader email to the list, but the JG question below strikes me as rather interesting. In this JG case, SQL*Loader appears to be causing all SQL statements JG that refer to the table being loaded to be invalidated. Is JG this normal behavior? Does anyone know why it might be the JG case? JG -- JG Best regards, JG Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] JG Join the Oracle-article list and receive one JG article on Oracle technologies per month by JG email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and JG include the word subscribe in either the subject or body. JG Wednesday, November 12, 2003, 1:07:41 AM, JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: JG Hi Jonathan, JG I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. JG We are using Oracle 9i sqlldr, direct path to load data from external files into JG staging tables. After data is loaded, we invoked stored procedures to JG transform data and move them to the target tables. The steps are: JG 1. delete all entries from 20 staging tables JG 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to JG load data to all 20 staging tables JG 3. invoke stored procedures to transform data from the staging tables to the JG final tables. Currently these stored procedures are standalone. JG 4. invoke stored procedures to remove out-of-date entries from the final JG tables. JG I monitor invalidations column in v$sqlarea. Every time JG after sqlldr is invoked for data loading (step 2), all the JG sql statements that reference the staging tables are JG invalidated, including delete from stageing_table sql JG statement. I setup a test and used a java program to loop JG steps 1-4 every ~2 minutes. There were no other activities JG in the database except data loading and transformation. JG After a couple days, I got the following error: ORA-04031: JG unable to allocate 4212 bytes of shared memory (shared JG pool,unknown object,sga heap(1,0),stat array mem) JG The questions are: JG 1. Do we need to delete entries in the staging table prior to loading. Will JG sqlldr remove the entires in the staging table first prior to loading? JG 2. There are no changes in the stored procedures, how / why sqlldr would JG invalidate the sql statement in the stored procedures? JG 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? JG I would appreciate if you can send me some pointers or suggestions. JG Thanks, JG KamYee __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang 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: New interface on Metalink to do queries ...
And yet it STILL returns articles about DEC's RDB. Wasn't the new/improved MetaLink supposed to be out Q1 of *this* year? All I want is valid HTML, no %$#*( frames, and no hits that I can't view or that don't apply to my search (e.g. DEC RDB, Apps, etc.). Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, November 12, 2003 11:49 AM To: Multiple recipients of list ORACLE-L I found it today ... http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_ database_id=NOTp_id=102421.1 Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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).
Help Interpreting TKProf
Hi.
I'm running tkprof on my PC with a version 9i client.
The trace file was generated on a Solars version
8.1.7.4 database. (I'm using tkprof on 9i to get wait
statistics.) The trace is 10046 level 12
I assume the time waited is in addition to the elapsed
time for the call -- correct?
Since the database itself is 8i, does that mean that
the wait stats are in centiseconds? I want to know
what the sql*net message from client wait time of
10.73 represents:
Elapsed times include waiting on following events:
Event waited onTimes Max. Wait Total
Waited
Waited -- -
SQL*Net message to client 8 0.00 0.00
SQL*Net message from client 8 10.71 10.73
Here's all the code:
select /*ClassSQL*/ distinct co.class,cl.claname
from
classorder co,class cl where co.paper='DNA' and
co.page='EM' and co.class=
cl.class and co.paper=cl.paper and cl.clatype='0'
order by 1
call count cpuelapsed disk
querycurrentrows
--- -- -- --
-- -- --
Parse1 0.01 0.01 0
0 0 0
Execute 1 0.00 0.00 0
0 0 0
Fetch8 0.01 0.01 0
169 0 82
--- -- -- --
-- -- --
total 10 0.02 0.02 0
169 0 82
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 586 (SYSADMIN)
Rows Row Source Operation
---
---
82 SORT UNIQUE
82 NESTED LOOPS
83INDEX RANGE SCAN (object id 395118)
82TABLE ACCESS BY INDEX ROWID CLASS
164 INDEX UNIQUE SCAN (object id 395113)
Rows Execution Plan
---
---
0 SELECT STATEMENT GOAL: CHOOSE
82 SORT (UNIQUE)
82NESTED LOOPS
83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'I_CLO1' (NON-UNIQUE)
82 TABLE ACCESS GOAL: ANALYZED (BY INDEX
ROWID) OF 'CLASS'
164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'I_CLA1' (UNIQUE)
Thanks for any help.
Barb
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
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: Fwd: Looking for help.
Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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: RE: OCP 9i New Features for DBAs
im going to take it soon. I was going to just read howard rogers guide then the otn one. you think that is enough? I just want to pass it and get my piece of paper. I already know the 9i stuff that is useful to me. From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/11/12 Wed PM 12:19:32 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OCP 9i New Features for DBAs Chris I'm betting on 9.0. For it to cover 9.2 would have meant that Oracle would have had to go back and recreate the test. And Oracle would have felt compelled to change the name of the test. However, I think it possible that any question whose answer would be true for 9.0 but false for 9.2 might be removed. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 12, 2003 10:24 AM To: Multiple recipients of list ORACLE-L Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
anyone looking for development dbas in northern virgnia?
My company started offshoring jobs to India. Ive been told Im safe, but in a corporate environment, your boss doesnt know much. He didnt even get advance notice about the layoffs that occurrted today. I believe long term they want to outsource the whole department overseas. My boss doesnt know. Id prefer private sector clients if its out there. I only want permanent employee. No high risk contracts. I am a us citizen and for what its worth I should be certified as both a dba and a developer by the end of the year/early january(not sure if its worth much). Ill then grab the first java certification just to have it. I post on here and spend alot of time improving my skills. Im also working on a masters in software engineering. -- 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: New interface on Metalink to do queries ...
On 11/12/2003 12:59:25 PM, Jesse, Rich wrote: And yet it STILL returns articles about DEC's RDB. Wasn't the new/improved MetaLink supposed to be out Q1 of *this* year? All I want is valid HTML, no %$#*( frames, and no hits that I can't view or that don't apply to my search (e.g. DEC RDB, Apps, etc.). Knowing oracle's knack for disgusting user interfaces, which shouldn't be used after a meal, we will get an abomination which will contain Java applets, lots of JavaScript, icons and flashing pictures, may be even some sound, like playing Mozart's concerto No. 40 in G-minor or Tchaikovsky's 1812 overture whenever the submit button is pressed, and then returning a bunch of unusable documents which you are not entitled to see. I must say, it's still better then playing Ludacris or Eminem to the unsuspecting Metalink users. BTW, oracle white papers in the rap format, sung by Ludacris would be a blast, when I come to think of it. Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Fwd: Looking for help.
Yep, truncate invalidates parsed SQL:
SQL select count(*) from
t3;
COUNT(*)--
0
SQL select sql_text, optimizer_mode,
invalidations from v$sql where sql_text like '%select count(*) from
t3%'and sql_text not like '%v$sql%';
SQL_TEXT
OPTIMIZER_
INVALIDATIONS
-- -select count(*) from
t3
CHOOSE
1
SQL truncate table
t3;
Table truncated.
SQL select sql_text, optimizer_mode,
invalidations from v$sql where sql_text like '%select count(*) from
t3%'and sql_text not like '%v$sql%';
SQL_TEXT
OPTIMIZER_
INVALIDATIONS
-- -select count(*) from
t3
NONE
2
Tanel.
- Original Message -
From: "Jonathan Gennick" [EMAIL PROTECTED]
To: "Multiple recipients of list ORACLE-L"
[EMAIL PROTECTED]
Sent: Wednesday, November 12, 2003 4:34
PM
Subject: Re: Fwd: Looking for
help.
I wonder whether the invalidation comes about from the use
of TRUNCATE, which is considered a DDL statement. I'd guess that any DDL
to a table would invalidate existing SQL statements.
Best regards, Jonathan Gennick --- Brighten the corner where
you are http://Gennick.com * 906.387.1698 *
mailto:[EMAIL PROTECTED]
Join the Oracle-article list and receive one article on Oracle
technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and
include the word "subscribe" in either the subject or body.
Wednesday, November 12, 2003, 8:34:24 AM, Jonathan Gennick
([EMAIL PROTECTED]) wrote:
JG I don't usually forward my reader email to the list, but the
JG question below strikes me as rather interesting. In this JG
case, SQL*Loader appears to be causing all SQL statements JG that
refer to the table being loaded to be invalidated. Is JG this normal
behavior? Does anyone know why it might be the JG case?
JG -- JG Best regards, JG
Jonathan Gennick --- Brighten the corner where you are JG http://Gennick.com * 906.387.1698 *
mailto:[EMAIL PROTECTED]
JG Join the Oracle-article list and receive one JG
article on Oracle technologies per month by JG email. To join,
visit http://four.pairlist.net/mailman/listinfo/oracle-article, JG or send email to [EMAIL PROTECTED] and
JG include the word "subscribe" in either the subject or
body. JG Wednesday, November 12, 2003, 1:07:41 AM,
JG [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
JG Hi Jonathan, JG I was unable to find the answers
from your book "SQL*Loader: The Definitive Guide" and the web. I am running out
of sources. I hope you can help me with the following questions.
JG We are using Oracle 9i sqlldr, direct path to load data from
external files into JG staging tables. After data is loaded, we
invoked stored procedures to JG transform data and move them to the
target tables. The steps are: JG 1. delete all entries from 20
staging tables JG 2. invoke "sqlldr userid=dbimpl/dbimpl
control=controlFile direct=true" to JG load data to all 20
staging tables JG 3. invoke stored procedures to transform
data from the staging tables to the JG final tables. Currently these
stored procedures are standalone. JG 4. invoke stored procedures to
remove out-of-date entries from the final JG tables.
JG I monitor invalidations column in v$sqlarea. Every time
JG after sqlldr is invoked for data loading (step 2), all the JG
sql statements that reference the staging tables are JG invalidated,
including "delete from stageing_table" sql JG statement. I
setup a test and used a java program to loop JG steps 1-4 every ~2
minutes. There were no other activities JG in the database except
data loading and transformation. JG After a couple days, I got the
following error: ORA-04031: JG unable to allocate 4212 bytes of
shared memory ("shared JG pool","unknown object","sga
heap(1,0)","stat array mem") JG The questions are:
JG 1. Do we need to delete entries in the staging table prior to loading.
Will JG sqlldr remove the entires in the staging table first prior
to loading? JG 2. There are no changes in the stored procedures, how
/ why sqlldr would JG invalidate the sql statement in the stored
procedures? JG 3. The error ORA-04031 in this case, is it due to
shared memory fragmentation? I suspect that the culprint is invalidations. How
do invalidations cause shared memory fragmentation? JG I
would appreciate if you can send me some pointers or suggestions.
JG Thanks, JG KamYee JG --
JG Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net --
Author: Jonathan Gennick 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
RE: Looking for help.
Or... Create a stored procedure that truncates the table... Grant execute on the procedure to the user... The user executes the procedure and then calls sqlldr... Tim -Original Message- Sent: Wednesday, November 12, 2003 12:45 PM To: Multiple recipients of list ORACLE-L yeah but... if you attempt (as I do) to isolate the schema owner from the users which have select/insert/update/delete privileges, TRUNCATE won't work unless you have granted DROP ANY TABLE (I *really* hate that that is required) to the account which does the actual sql load. So I use REPLACE, because then I only have to grant the delete priv on that table. --- Yechiel Adar [EMAIL PROTECTED] wrote: There are two options to replace all data in the table: REPLACE and TRUNCATE which are equivalent to truncate and delete sql statements. If you have staging tables without RI or triggers then use truncate. Using delete just takes a lot longer and use a lot more resources. We use TRUNCATE almost exclusively. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:44 PM Hi We do something similiar, but instead of deleting the tables beforehand, I just use the SQL*LOADER REPLACE option. No such problems as described in the original eMail occured so far. The platform is Oracle 9.2.0.3 on Win3k. Regards, Stefan -Ursprüngliche Nachricht- Von: Jonathan Gennick [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 12. November 2003 14:34 An: Multiple recipients of list ORACLE-L Betreff: Fwd: Looking for help. I don't usually forward my reader email to the list, but the question below strikes me as rather interesting. In this case, SQL*Loader appears to be causing all SQL statements that refer to the table being loaded to be invalidated. Is this normal behavior? Does anyone know why it might be the case? -- Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. Wednesday, November 12, 2003, 1:07:41 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote: Hi Jonathan, I was unable to find the answers from your book SQL*Loader: The Definitive Guide and the web. I am running out of sources. I hope you can help me with the following questions. We are using Oracle 9i sqlldr, direct path to load data from external files into staging tables. After data is loaded, we invoked stored procedures to transform data and move them to the target tables. The steps are: 1. delete all entries from 20 staging tables 2. invoke sqlldr userid=dbimpl/dbimpl control=controlFile direct=true to load data to all 20 staging tables 3. invoke stored procedures to transform data from the staging tables to the final tables. Currently these stored procedures are standalone. 4. invoke stored procedures to remove out-of-date entries from the final tables. I monitor invalidations column in v$sqlarea. Every time after sqlldr is invoked for data loading (step 2), all the sql statements that reference the staging tables are invalidated, including delete from stageing_table sql statement. I setup a test and used a java program to loop steps 1-4 every ~2 minutes. There were no other activities in the database except data loading and transformation. After a couple days, I got the following error: ORA-04031: unable to allocate 4212 bytes of shared memory (shared pool,unknown object,sga heap(1,0),stat array mem) The questions are: 1. Do we need to delete entries in the staging table prior to loading. Will sqlldr remove the entires in the staging table first prior to loading? 2. There are no changes in the stored procedures, how / why sqlldr would invalidate the sql statement in the stored procedures? 3. The error ORA-04031 in this case, is it due to shared memory fragmentation? I suspect that the culprint is invalidations. How do invalidations cause shared memory fragmentation? I would appreciate if you can send me some pointers or suggestions. Thanks, KamYee -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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,
RE: Re: Logical StandBy question
Walt, I'll step in here--my experiment with Logical Standby convinced me that it is not ready for prime time. 1. Major bugs caused apply process to crash repeatedly. 2. Difficulty filtering out DDL from apply stream. 3. Horrendous performance of apply process--frequently the elapsed time to apply changes on the standby was one or two orders of magnitude greater than that of the source operation. --- Walt Weaver [EMAIL PROTECTED] wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel 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: Help Interpreting TKProf
Barbs, what this trace file tells you is that the client program
takes much more time delivering the data to oracle then it takes
for oracle to deliver the data to the program. In other words, your
program takes its time between the calls to the database. Maybe you
should run the profiler and see where time in the program is spent.
On 11/12/2003 01:09:24 PM, Barbara Baker wrote:
Hi.
I'm running tkprof on my PC with a version 9i client.
The trace file was generated on a Solars version
8.1.7.4 database. (I'm using tkprof on 9i to get wait
statistics.) The trace is 10046 level 12
I assume the time waited is in addition to the elapsed
time for the call -- correct?
Since the database itself is 8i, does that mean that
the wait stats are in centiseconds? I want to know
what the sql*net message from client wait time of
10.73 represents:
Elapsed times include waiting on following events:
Event waited onTimes Max. Wait Total
Waited
Waited -- -
SQL*Net message to client 8 0.00 0.00
SQL*Net message from client 8 10.71 10.73
Here's all the code:
select /*ClassSQL*/ distinct co.class,cl.claname
from
classorder co,class cl where co.paper='DNA' and
co.page='EM' and co.class=
cl.class and co.paper=cl.paper and cl.clatype='0'
order by 1
call count cpuelapsed disk
querycurrentrows
--- -- -- --
-- -- --
Parse1 0.01 0.01 0
0 0 0
Execute 1 0.00 0.00 0
0 0 0
Fetch8 0.01 0.01 0
169 0 82
--- -- -- --
-- -- --
total 10 0.02 0.02 0
169 0 82
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 586 (SYSADMIN)
Rows Row Source Operation
---
---
82 SORT UNIQUE
82 NESTED LOOPS
83INDEX RANGE SCAN (object id 395118)
82TABLE ACCESS BY INDEX ROWID CLASS
164 INDEX UNIQUE SCAN (object id 395113)
Rows Execution Plan
---
---
0 SELECT STATEMENT GOAL: CHOOSE
82 SORT (UNIQUE)
82NESTED LOOPS
83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'I_CLO1' (NON-UNIQUE)
82 TABLE ACCESS GOAL: ANALYZED (BY INDEX
ROWID) OF 'CLASS'
164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'I_CLA1' (UNIQUE)
Thanks for any help.
Barb
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
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).
Mladen Gogala
Oracle DBA
Note:
This message is for the named person's use only. It may contain confidential,
proprietary or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard copies
of it and notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to
monitor all e-mail communications through its networks.
Any views expressed in this message are those of the individual sender, except where
the message states otherwise and the sender is authorized to state them to be the
views of any such entity.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
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
Re: Help Interpreting TKProf
Barb,
This is a great example of where reading the trace file will tell you
what you need to know. Is the 10 centiseconds of time in 8 1.25
centisecond events or in 1 10 centisecond event and 7 .1 centisecond
events? The location (parse/execute/fetch/post tx) are also important.
Daniel
Barbara Baker wrote:
Hi.
I'm running tkprof on my PC with a version 9i client.
The trace file was generated on a Solars version
8.1.7.4 database. (I'm using tkprof on 9i to get wait
statistics.) The trace is 10046 level 12
I assume the time waited is in addition to the elapsed
time for the call -- correct?
Since the database itself is 8i, does that mean that
the wait stats are in centiseconds? I want to know
what the sql*net message from client wait time of
10.73 represents:
Elapsed times include waiting on following events:
Event waited onTimes Max. Wait Total
Waited
Waited -- -
SQL*Net message to client 8 0.00 0.00
SQL*Net message from client 8 10.71 10.73
Here's all the code:
select /*ClassSQL*/ distinct co.class,cl.claname
from
classorder co,class cl where co.paper='DNA' and
co.page='EM' and co.class=
cl.class and co.paper=cl.paper and cl.clatype='0'
order by 1
call count cpuelapsed disk
querycurrentrows
--- -- -- --
-- -- --
Parse1 0.01 0.01 0
0 0 0
Execute 1 0.00 0.00 0
0 0 0
Fetch8 0.01 0.01 0
169 0 82
--- -- -- --
-- -- --
total 10 0.02 0.02 0
169 0 82
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 586 (SYSADMIN)
Rows Row Source Operation
---
---
82 SORT UNIQUE
82 NESTED LOOPS
83INDEX RANGE SCAN (object id 395118)
82TABLE ACCESS BY INDEX ROWID CLASS
164 INDEX UNIQUE SCAN (object id 395113)
Rows Execution Plan
---
---
0 SELECT STATEMENT GOAL: CHOOSE
82 SORT (UNIQUE)
82NESTED LOOPS
83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'I_CLO1' (NON-UNIQUE)
82 TABLE ACCESS GOAL: ANALYZED (BY INDEX
ROWID) OF 'CLASS'
164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'I_CLA1' (UNIQUE)
Thanks for any help.
Barb
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
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: Daniel 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: anyone take the 8i performance tuning ocp test?
I'm studying for the 9i Performance Tuning exam, too. I'm glad to hear about the inaccuracies in this book. I have this book and the Oracle Press book by Pack. I also have Oracle Online Learning and I think I will stick more closely to that. Also, hopefully the Self Test Software gives a good indication of the type of questions on the exam, or the focus of them. Mike -Original Message- Sent: Wednesday, November 12, 2003 7:09 AM To: Multiple recipients of list ORACLE-L Im reading the Sybex OCP book on tuning and it is absolutely loaded with inaccuracies. Is the test the same way? If so do they improve it in 9i? The book is loaded with all types of hit ratios, discussions about committing frequently to IMPROVE performance, and other garbage. anyone know the guys who wrote this book? I dont want to write their names. Did they just write it to the test? -- 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Re: Logical StandBy question
Walt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm. I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening. regards, Carel-Jan At 09:19 12-11-03 -0800, you wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote: Jose Luis, What you say refers to the physical standby database (which works well), not to the logical standby database (which on the paper looks great, allows you to open the database, create additional tablespaces, create additional indexes on replicated objects etc) but which in practice still has a lot of teething troubles. Wouldn't use it in production on Oracle 9.2. HTH, SF - --- Original Message --- - From: Jose Luis Delgado [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 12 Nov 2003 08:09:27 Hmm... I'd like to know where in the manuals... :-) I do not think so since the standby database stay in permanent recovery mode. JL --- Rachel Carmichael [EMAIL PROTECTED] wrote: yes. Well documented in the manuals --- Juan Miranda [EMAIL PROTECTED] wrote: Hi It is posible to create other schemas on a logical stand by database ? I mean, schemas that don?t exist in the primary database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver 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). DBA!ert, Independent Oracle Consultancy Kastanjelaan 61C 2743 BX Waddinxveen The Netherlands tel. +31 (0) 182 640 428 fax +31 (0) 182 640 429 mobile+31 (0) 653 911 950 e-mail [EMAIL PROTECTED]
RE: Help Interpreting TKProf
Barb,
I think tkprof prints output in seconds, so I think you're looking at
10.73 seconds of response time here.
First, some definitions:
- The SQL*Net message from client event maps to an OS read() call to
the file descriptor to which SQL*Net is connected.
- The SQL*Net message to client event maps to an OS write() call to
the file descriptor to which SQL*Net is connected.
The Oracle kernel uses a to event just to write a short message (often
1 byte) to a pipe. It takes practically no time to do that--usually on
the order of 3 microseconds (0.03 seconds).
However, as soon as a given to event completes, the kernel often next
executes a read() from the same file descriptor. The duration of this
read() is what ultimately shows up as the from event's duration.
What this means is that all the time spent in the following tiers gets
logged as SQL*Net message from client (see p13 of my book for a
picture):
- comm from db server to apps server
- apps server computation time
- comm from apps server to browser
- browser computation time
- user think time
- comm from browser to apps server
- apps server computation time
- comm from apps server to db server
Thus you'll almost always (maybe even always always) see from events
lasting longer than to events.
Getting good information out of SQL*Net message from client is
possible only if you are careful in how you collect your trace data. If,
for example, you allow 10 seconds of user think time into your trace
data, then it forces you to do a lot more analytical work on your trace
data to properly ignore the right data--unless, of course, the thing
you need to find out is that the user is wasting your business's time by
consuming 10 seconds instead of 2.
Optimizing Oracle Performance covers all this in great detail.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney, 12/16 Detroit
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Barbara Baker
Sent: Wednesday, November 12, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Hi.
I'm running tkprof on my PC with a version 9i client.
The trace file was generated on a Solars version
8.1.7.4 database. (I'm using tkprof on 9i to get wait
statistics.) The trace is 10046 level 12
I assume the time waited is in addition to the elapsed
time for the call -- correct?
Since the database itself is 8i, does that mean that
the wait stats are in centiseconds? I want to know
what the sql*net message from client wait time of
10.73 represents:
Elapsed times include waiting on following events:
Event waited onTimes Max. Wait Total
Waited
Waited -- -
SQL*Net message to client 8 0.00 0.00
SQL*Net message from client 8 10.71 10.73
Here's all the code:
select /*ClassSQL*/ distinct co.class,cl.claname
from
classorder co,class cl where co.paper='DNA' and
co.page='EM' and co.class=
cl.class and co.paper=cl.paper and cl.clatype='0'
order by 1
call count cpuelapsed disk
querycurrentrows
--- -- -- --
-- -- --
Parse1 0.01 0.01 0
0 0 0
Execute 1 0.00 0.00 0
0 0 0
Fetch8 0.01 0.01 0
169 0 82
--- -- -- --
-- -- --
total 10 0.02 0.02 0
169 0 82
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 586 (SYSADMIN)
Rows Row Source Operation
---
---
82 SORT UNIQUE
82 NESTED LOOPS
83INDEX RANGE SCAN (object id 395118)
82TABLE ACCESS BY INDEX ROWID CLASS
164 INDEX UNIQUE SCAN (object id 395113)
Rows Execution Plan
---
---
0 SELECT STATEMENT GOAL: CHOOSE
82 SORT (UNIQUE)
82NESTED LOOPS
83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'I_CLO1' (NON-UNIQUE)
82 TABLE ACCESS GOAL: ANALYZED (BY INDEX
ROWID) OF 'CLASS'
164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'I_CLA1' (UNIQUE)
Thanks for any help.
Barb
__
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Barbara Baker
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To
Re: Logical StandBy question
Walt Weaver wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt Walt, This is basically my feelings after the tests : o Properly monitoring is rather difficult. You must check at both ends to have more than a vague feeling that things could have gone awry. This is just one aspect of a general user-friendliness which first shows up in a 26 step installation procedure. o The automated check for incompatibilities (there is normally a view to tell you what will not work) is fairly deficient. I have (by mistake) tested on a schema with lots of (unsupported) LONGs, do you think I got any warning? o Although a surprisingly high number of DDL commands are successfully replicated (including CREATE USER, etc), others are understandably not replicated (when you extend a tablespace - well the directory lay-out may be different, so it makes sense. The workaround is to have AUTOEXTEND ON, which I am usually reluctant to have), something as mundane as RENAME is not - with all the ensuing consequences you may imagine. o I have found no way to ensure that the time gap between the two databases stayed below some predefined threshold. Not sure that issuing regular ALTER SYSTEM SWITCH LOGFILE on the master is enough. I wanted to test the performance impact of logical standby by running an import, first without it, then with it, and also to measure how fast the copy was catching up, but I've given up my tests after a few ORA-600 errors. The concept is great, and I am sure to have another look at it ... later. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: Help Interpreting TKProf
In other words, you can finish performance analysis of the client
only by finding out where the time is spent on the client side.
If it's an interactive program and you have a homo sapiens interacting
with it, then think time is a factor. If, on the other hand, it's
a batch program, then run a profiler (gprof, Jprof or alike) to find
out where the time is spent.
On 11/12/2003 02:09:28 PM, Cary Millsap wrote:
Barb,
I think tkprof prints output in seconds, so I think you're looking at
10.73 seconds of response time here.
First, some definitions:
- The SQL*Net message from client event maps to an OS read() call to
the file descriptor to which SQL*Net is connected.
- The SQL*Net message to client event maps to an OS write() call to
the file descriptor to which SQL*Net is connected.
The Oracle kernel uses a to event just to write a short message (often
1 byte) to a pipe. It takes practically no time to do that--usually on
the order of 3 microseconds (0.03 seconds).
However, as soon as a given to event completes, the kernel often next
executes a read() from the same file descriptor. The duration of this
read() is what ultimately shows up as the from event's duration.
What this means is that all the time spent in the following tiers gets
logged as SQL*Net message from client (see p13 of my book for a
picture):
- comm from db server to apps server
- apps server computation time
- comm from apps server to browser
- browser computation time
- user think time
- comm from browser to apps server
- apps server computation time
- comm from apps server to db server
Thus you'll almost always (maybe even always always) see from events
lasting longer than to events.
Getting good information out of SQL*Net message from client is
possible only if you are careful in how you collect your trace data. If,
for example, you allow 10 seconds of user think time into your trace
data, then it forces you to do a lot more analytical work on your trace
data to properly ignore the right data--unless, of course, the thing
you need to find out is that the user is wasting your business's time by
consuming 10 seconds instead of 2.
Optimizing Oracle Performance covers all this in great detail.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 11/19 Sydney, 12/16 Detroit
- SQL Optimization 101: 12/8 Dallas, 2/16 Dallas
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
Barbara Baker
Sent: Wednesday, November 12, 2003 12:09 PM
To: Multiple recipients of list ORACLE-L
Hi.
I'm running tkprof on my PC with a version 9i client.
The trace file was generated on a Solars version
8.1.7.4 database. (I'm using tkprof on 9i to get wait
statistics.) The trace is 10046 level 12
I assume the time waited is in addition to the elapsed
time for the call -- correct?
Since the database itself is 8i, does that mean that
the wait stats are in centiseconds? I want to know
what the sql*net message from client wait time of
10.73 represents:
Elapsed times include waiting on following events:
Event waited onTimes Max. Wait Total
Waited
Waited -- -
SQL*Net message to client 8 0.00 0.00
SQL*Net message from client 8 10.71 10.73
Here's all the code:
select /*ClassSQL*/ distinct co.class,cl.claname
from
classorder co,class cl where co.paper='DNA' and
co.page='EM' and co.class=
cl.class and co.paper=cl.paper and cl.clatype='0'
order by 1
call count cpuelapsed disk
querycurrentrows
--- -- -- --
-- -- --
Parse1 0.01 0.01 0
0 0 0
Execute 1 0.00 0.00 0
0 0 0
Fetch8 0.01 0.01 0
169 0 82
--- -- -- --
-- -- --
total 10 0.02 0.02 0
169 0 82
Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 586 (SYSADMIN)
Rows Row Source Operation
---
---
82 SORT UNIQUE
82 NESTED LOOPS
83INDEX RANGE SCAN (object id 395118)
82TABLE ACCESS BY INDEX ROWID CLASS
164 INDEX UNIQUE SCAN (object id 395113)
Rows Execution Plan
---
---
0 SELECT STATEMENT GOAL: CHOOSE
82 SORT (UNIQUE)
82NESTED LOOPS
83 INDEX GOAL: ANALYZED (RANGE SCAN) OF
'I_CLO1' (NON-UNIQUE)
82 TABLE ACCESS GOAL: ANALYZED (BY INDEX
ROWID) OF 'CLASS'
164 INDEX
Moving CDC data to a staging area
Hey all, After reading the article in the latest OraMag about 9i's CDC -- Change Data Capture and not Centers for Disease Control (cool reading that MMWR is) -- I'm wondering how most folk get that CDC data to the staging area of a DW/DM. The three ways I can think of are by using DB links, transportable tablespaces, and Oracle Streams. Having not used Oracle Streams, it would seem to me to duplicate the effort of the CDC and add complexity unneccesarily. I have the preconcieved notion that transport TSs would be better for large amounts of data, and DB links more suited to the rest. I'm thinking that if one would expect large amounts of data, that the transport TSs would be used instead of CDC instead of along with it to prevent the overhead of the CDC itself. Is this how folks typically approach this? The article (apparently not by Jonathon Gennick as it says in the first tagline on OTN) assumes the reader already knows why one would use CDC over other methods and what they're going to do with the CDC data once it's there. :) TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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[2]: Fwd: Looking for help.
Wednesday, November 12, 2003, 12:04:35 PM, Daniel Fink ([EMAIL PROTECTED]) wrote: DF I don't see where truncate is being invoked, though I am not a big user of sql*loader. DF Truncate should invalidate statements. Sorry. He mentioned in a later email to me that he was using the TRUNCATE option in his control file. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Help Interpreting TKProf
Daniel, it's seconds, not centiseconds. The tkprof writes things down in seconds. If it's a 9i trace, then the times within trc files are in microseconds. In trc file produced by 8i, it's centiseconds. By some magic, tkprof knows the difference and usually gets the right times. On 11/12/2003 01:49:34 PM, Daniel Fink wrote: Barb, This is a great example of where reading the trace file will tell you what you need to know. Is the 10 centiseconds of time in 8 1.25 centisecond events or in 1 10 centisecond event and 7 .1 centisecond events? The location (parse/execute/fetch/post tx) are also important. Daniel Barbara Baker wrote: Hi. I'm running tkprof on my PC with a version 9i client. The trace file was generated on a Solars version 8.1.7.4 database. (I'm using tkprof on 9i to get wait statistics.) The trace is 10046 level 12 I assume the time waited is in addition to the elapsed time for the call -- correct? Since the database itself is 8i, does that mean that the wait stats are in centiseconds? I want to know what the sql*net message from client wait time of 10.73 represents: Elapsed times include waiting on following events: Event waited onTimes Max. Wait Total Waited Waited -- - SQL*Net message to client 8 0.00 0.00 SQL*Net message from client 8 10.71 10.73 Here's all the code: select /*ClassSQL*/ distinct co.class,cl.claname from classorder co,class cl where co.paper='DNA' and co.page='EM' and co.class= cl.class and co.paper=cl.paper and cl.clatype='0' order by 1 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.01 0.01 0 169 0 82 --- -- -- -- -- -- -- total 10 0.02 0.02 0 169 0 82 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 586 (SYSADMIN) Rows Row Source Operation --- --- 82 SORT UNIQUE 82 NESTED LOOPS 83INDEX RANGE SCAN (object id 395118) 82TABLE ACCESS BY INDEX ROWID CLASS 164 INDEX UNIQUE SCAN (object id 395113) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 82 SORT (UNIQUE) 82NESTED LOOPS 83 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'I_CLO1' (NON-UNIQUE) 82 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'CLASS' 164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'I_CLA1' (UNIQUE) Thanks for any help. Barb __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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: Daniel 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). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or
Re: Help Interpreting TKProf
Daniel: Does this mean I was supposed to be paying attention in class?? Here's everything I can find associated with sql*net message from client in that cursor. Can't figure out from this how it came up with 10.73 (although that one wait matches up with the max wait of 10.71) Am I being really dense? WAIT!! don't answer that! WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1071 p1=1413697536 p2=1 p3=0 --- Daniel Fink [EMAIL PROTECTED] wrote: Barb, This is a great example of where reading the trace file will tell you what you need to know. Is the 10 centiseconds of time in 8 1.25 centisecond events or in 1 10 centisecond event and 7 .1 centisecond events? The location (parse/execute/fetch/post tx) are also important. Daniel Barbara Baker wrote: Hi. I'm running tkprof on my PC with a version 9i client. The trace file was generated on a Solars version 8.1.7.4 database. (I'm using tkprof on 9i to get wait statistics.) The trace is 10046 level 12 I assume the time waited is in addition to the elapsed time for the call -- correct? Since the database itself is 8i, does that mean that the wait stats are in centiseconds? I want to know what the sql*net message from client wait time of 10.73 represents: Elapsed times include waiting on following events: Event waited onTimes Max. Wait Total Waited Waited -- - SQL*Net message to client 8 0.00 0.00 SQL*Net message from client 8 10.71 10.73 Here's all the code: select /*ClassSQL*/ distinct co.class,cl.claname from classorder co,class cl where co.paper='DNA' and co.page='EM' and co.class= cl.class and co.paper=cl.paper and cl.clatype='0' order by 1 call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse1 0.01 0.01 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch8 0.01 0.01 0 169 0 82 --- -- -- -- -- -- -- total 10 0.02 0.02 0 169 0 82 Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 586 (SYSADMIN) Rows Row Source Operation --- --- 82 SORT UNIQUE 82 NESTED LOOPS 83INDEX RANGE SCAN (object id 395118) 82TABLE ACCESS BY INDEX ROWID CLASS 164 INDEX UNIQUE SCAN (object id 395113) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 82 SORT (UNIQUE) 82NESTED LOOPS 83 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'I_CLO1' (NON-UNIQUE) 82 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF 'CLASS' 164 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'I_CLA1' (UNIQUE) Thanks for any help. Barb __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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: Daniel 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
Stop using SYS, SYSTEM?
We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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[2]: New interface on Metalink to do queries ...
Wednesday, November 12, 2003, 12:59:25 PM, Jesse, Rich ([EMAIL PROTECTED]) wrote: JR And yet it STILL returns articles about DEC's RDB. But isn't that the solution to all Oracle problems? Just upgrade to DEC RDB? Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Fwd: Looking for help.
Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work? Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8 Support Description of Bug 1157495 Ron [EMAIL PROTECTED] 11/12/2003 1:14:25 PM Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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: Ron Rogers 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: Stop using SYS, SYSTEM?
That won't work if you're using RMAN. The account that makes the backup needs to be able to do so as sysdba. You can't grant that through a role. The reason for separate accounts is accountability. But if you're not auditing, that won't help much, as you already stated. Jared Smith, Ron L. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/12/2003 12:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Stop using SYS, SYSTEM? We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Fwd: Looking for help.
There is a difference between a statement that is invalid (i.e. won't execute) and one whose execution plan has been invalidated in the shared pool. When the statement is 'invalidated' all it means is that if a process wants to reexecute the statement, it must be reparsed. At this time, the statement may become invalid (column referenced has been dropped). Usually it means that a 'hard parse' occurs and the dictionary info is reloaded and the execution plan is regenerated (may be different than the last). Daniel Ron Rogers wrote: Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work? Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8 Support Description of Bug 1157495 Ron [EMAIL PROTECTED] 11/12/2003 1:14:25 PM Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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: Ron Rogers 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: Daniel 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: Logical StandBy question
Thanks for the info on logical standbys everyone. The opinions on it seem rather unanimous.:) --Walt On Wed, 2003-11-12 at 12:14, Stephane Faroult wrote: Walt Weaver wrote: Stephane, What sort of problems can one expect from logical standby? I'm toying with the idea of using it as a replication database -- no additional schema objects will be created, but users will have read-only access to it. It's one of the options I'm looking at. Seems to me like there was a thread on this a few months ago, but I'm not sure... --Walt Walt, This is basically my feelings after the tests : o Properly monitoring is rather difficult. You must check at both ends to have more than a vague feeling that things could have gone awry. This is just one aspect of a general user-friendliness which first shows up in a 26 step installation procedure. o The automated check for incompatibilities (there is normally a view to tell you what will not work) is fairly deficient. I have (by mistake) tested on a schema with lots of (unsupported) LONGs, do you think I got any warning? o Although a surprisingly high number of DDL commands are successfully replicated (including CREATE USER, etc), others are understandably not replicated (when you extend a tablespace - well the directory lay-out may be different, so it makes sense. The workaround is to have AUTOEXTEND ON, which I am usually reluctant to have), something as mundane as RENAME is not - with all the ensuing consequences you may imagine. o I have found no way to ensure that the time gap between the two databases stayed below some predefined threshold. Not sure that issuing regular ALTER SYSTEM SWITCH LOGFILE on the master is enough. I wanted to test the performance impact of logical standby by running an import, first without it, then with it, and also to measure how fast the copy was catching up, but I've given up my tests after a few ORA-600 errors. The concept is great, and I am sure to have another look at it ... later. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Walt Weaver 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: Help Interpreting TKProf
Barbara, I know how distracted you were with all the jokes being tossed about, but really... It looks to me (with just this snippet of trace) that the cursor #3 did some communication and then waited for 10 seconds for a response. Without seeing the raw trace file and sequence of events, this is my best guess. Daniel Barbara Baker wrote: Daniel: Does this mean I was supposed to be paying attention in class?? Here's everything I can find associated with sql*net message from client in that cursor. Can't figure out from this how it came up with 10.73 (although that one wait matches up with the max wait of 10.71) Am I being really dense? WAIT!! don't answer that! WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1 wait_time = 1 centisecond p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1 wait_time = wait_time (1 cs) + 1 cs = 2 cs p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1071 p1=1413697536 p2=1 p3=0 wait_time = wait_time(2 cs) + 1071 cs = 1073 cs -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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: Stop using SYS, SYSTEM?
Or if you're auditing in a pre-9i DB, which won't audit SYS and SYSDBA. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Wednesday, November 12, 2003 2:30 PM To: Multiple recipients of list ORACLE-L That won't work if you're using RMAN. The account that makes the backup needs to be able to do so as sysdba. You can't grant that through a role. The reason for separate accounts is accountability. But if you're not auditing, that won't help much, as you already stated. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Stop using SYS, SYSTEM?
Personal Opinion here: I don't use SYS or system for anything where it is not absolutely required. All of the DBA's have the DBA role granted to them we log on as ourselves. This is simply so that we don't accidentally step on something really important. In general one should never create anything in the SYS schema since it won't get exported when you do a full database export. System is a little safer, but still.. I have seen a couple of white papers that have made statements such as SYS and SYSTEM should be locked and never opened as well as other similar alarming (to the pointy headed non-technical types) statements that indicate that disaster is waiting in the wings. All of them can be summarily dismissed as having been written by those who are similarly non-technical. BTW: Even if you are auditing, a DBA can eliminate the records in V$Audit of they wish. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Goulet, Dick 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: Stop using SYS, SYSTEM?
Title: RE: Stop using SYS, SYSTEM? Jared, I followed Robert Freeman's advice and created an RMAN user in all my DBs called backup_admin with SYSDBA privilege so that RMAN doesn't use SYS or SYSTEM. This allows you to change system passwords at will and not interfere with backups. Works just fine. Is this what you were talking about? Perhaps I misunderstood. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Stop using SYS, SYSTEM? We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Stop using SYS, SYSTEM?
I agree 100% with Dick. Nobody should be using SYS or SYSTEM. If RMAN requires a SYS connection, then so be it. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, November 12, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Personal Opinion here: I don't use SYS or system for anything where it is not absolutely required. All of the DBA's have the DBA role granted to them we log on as ourselves. This is simply so that we don't accidentally step on something really important. In general one should never create anything in the SYS schema since it won't get exported when you do a full database export. System is a little safer, but still.. I have seen a couple of white papers that have made statements such as SYS and SYSTEM should be locked and never opened as well as other similar alarming (to the pointy headed non-technical types) statements that indicate that disaster is waiting in the wings. All of them can be summarily dismissed as having been written by those who are similarly non-technical. BTW: Even if you are auditing, a DBA can eliminate the records in V$Audit of they wish. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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: Goulet, Dick 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: Mercadante, Thomas F 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: Stop using SYS, SYSTEM?
Smith, Ron L. scribbled on the wall in glitter crayon: We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? it would seem to me that this would break things. the only two users Oracle can be sure are there are SYS and SYSTEM, just like the only tablespace it can be sure is there is the SYSTEM one. and what about running catalog and such? i think there are two many possibilities for things to break for me to be comfortable with this one. -- Bill Shrek Thater ORACLE DBA I'm going to work my ticket if I can... -- Gilwell song [EMAIL PROTECTED] Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction. - Albert Einstein -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: Fwd: Looking for help.
Daniel, That is what I thought I read in the doc's, Thanks, Ron [EMAIL PROTECTED] 11/12/2003 3:29:27 PM There is a difference between a statement that is invalid (i.e. won't execute) and one whose execution plan has been invalidated in the shared pool. When the statement is 'invalidated' all it means is that if a process wants to reexecute the statement, it must be reparsed. At this time, the statement may become invalid (column referenced has been dropped). Usually it means that a 'hard parse' occurs and the dictionary info is reloaded and the execution plan is regenerated (may be different than the last). Daniel Ron Rogers wrote: Daniel, I understand what is you are saying and what you tested but I don't the why or what it means. Does it mean that the sql command is not going to work? Does it means that you have to issue it again to get it to work? Ref: Doc ID: Note:123214.1 invalid Type: PROBLEM Status: PUBLISHED Seems that truncate command invalidates object definition and existence in library cache. Invalidation can also be seen on temporary tables! .. Jonathan, The memory problem is described in Doc id:1157495.8 Support Description of Bug 1157495 Ron [EMAIL PROTECTED] 11/12/2003 1:14:25 PM Ron, I don't know about the TRUNCATE option w/ sql*loader, but the regular DDL TRUNCATE invalidates sql that references the table. Example: 1 select sql_text, invalidations 2 from v$sql 3* where sql_text = 'select * from emp' SQL / SQL_TEXT INVALIDATIONS -- - select * from emp 0 SQL truncate table emp; Table truncated. SQL select sql_text, invalidations 2 from v$sql 3 where sql_text = 'select * from emp' 4 / SQL_TEXT INVALIDATIONS -- - select * from emp 1 Ron Rogers wrote: Daniel, How does using the TRUNCATE command is a sqlldr invalidate anything? The sqlldr truncate command reuses the storage that the table originally used and does not change the HW mark. If there are indexes on the tables then they are placed in the DIRECT PATH state during the load and updated with the now block info. Please explain whet you mean by invalidate. Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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: Ron Rogers 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: Daniel 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: Ron Rogers 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
RE: Stop using SYS, SYSTEM?
We avoid using SYS as much as we can, but we use SYSTEM ... cautiously I might add. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith ** 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. **5 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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: Stop using SYS, SYSTEM?
David You can remove the create session priv from the RMAN user and this will make a little harder for most users to connect, but RMAN will work fine :-) David Wagoner wrote: Jared, I followed Robert Freeman's advice and created an RMAN user in all my DBs called backup_admin with SYSDBA privilege so that RMAN doesn't use SYS or SYSTEM. This allows you to change system passwords at will and not interfere with backups. Works just fine. Is this what you were talking about? Perhaps I misunderstood. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions Web: http://www.arsenaldigital.com the most trusted source for STORAGE MANAGEMENT SERVICES The contents of this e-mail message may be privileged and/or confidential. If you are not the intended recipient, any review, dissemination, copying, distribution or other use of the contents of this message or any attachment by you is strictly prohibited. If you receive this communication in error, please notify us immediately by return e-mail or by telephone (919-466-6700), and please delete this message and all attachments from your system. Thank you. -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: Stop using SYS, SYSTEM? We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. 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). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: Miracle Master Class with Tom Kyte, 12-14 January 2004 Visit http://miracleas.dk/en/events.html#MasterClass Visit http://www.miracleas.dk fore news ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram 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: Stop using SYS, SYSTEM?
Ron, It is a good practice, in general, to stop using SYS and SYSTEM accounts for everyday use. The simplest rule of thumb is accountability somehow increases many times over when you link a database named user to a physical person, not a ethereal entity like SYS. This is especially true if you use auditing and turn on SYSDBA auditing; but even if you don't sometimes the use of specific named users put people on the alert when they do something potentially dangerous and can avoid accidents. The other reason of not using SYS is to avoid accidental creation of objects in SYS and SYSTEM schema. The best option is to lock SYSTEM user and never let SYS user. Unfortunately you can't lock the SYS user. Third, you can create default tablespaces for all these DBA users to hold their objects, specifically temporary/occasional tables (not the global temporary tables), test tables, etc. and all those will not get into SYSTEM tablespace. Perhaps I should mention here is that I also conduct database security audits for corporations. But unlike your auditors, I tend to follow the advice up with more detailed information :) Arup Nanda www.proligence.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:04 PM We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Stop using SYS, SYSTEM?
Smith, Ron L. wrote: We are being asked by Auditing to stop using the SYS, and SYSTEM accounts. They would like for us to create an Oracle Role with the same permissions a SYS and SYSTEM, then grant the role to each of the DBA's. Don't ask me why. Nothing is being audited in 99% of the databases. They just say it in a paper some where so they said we shouldn't use it. This seems like it would cause lots of problems with exports, imports, installs, etc... Has anyone had to deal with this type of request? Any potential problems with making the change? Thanks! Ron Smith -- I agree about SYS, but I don't have any problem with SYSTEM, which for the ownership of PRODUCT_USER_PROFILE and perhaps a couple of other dictionary-related tables, views or package is as equal a DBA as any other (SYS excepted). I like having an externally identified DBA account for running all those cron scripts etc., but on the other hand I am not in favour of unduly multiplying DBAs. This is pushing democracy too far for my taste. The more DBAs you have, the more chances you take of having an easy-to-guess or leaked password. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: Stop using SYS, SYSTEM?
And for an opposing opinion: Let's see now. We create another user and grant that user all the privileges needed to do ANYTHING. And that makes things so much more secure? If that's the prevailing thought among the database world, then it's safe to say that the Unix admins have infinitely more common sense by logging as root when functioning as root. Well NO! We should create a user named rewt with the same UID and GID as root; and then always log in as rewt (or route). For what it's worth, if you have many databases, it's going to be a real pain in the ass to track every stinkin' DBA account and not have those DBA accounts that we forgot about when old Joe quit or (worse) when Billy Bob decided to become a developer instead of a DBA. If somebody can't log in as SYSTEM or SYS without fouling things up, they shouldn't be logging in at all. And if they have DBA privs, they can make a mess regardless of whether they log in as SYSTEM or CISTUM. -- 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: Stop using SYS, SYSTEM?
And as Arup's Oracle Magazine's DBA of the Year for 2003, he's probably right. Congrats, Arup! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Arup Nanda [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 3:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Stop using SYS, SYSTEM? Ron, It is a good practice, in general, to stop using SYS and SYSTEM accounts for everyday use. The simplest rule of thumb is accountability somehow increases many times over when you link a database named user to a physical person, not a ethereal entity like SYS. This is especially true if you use auditing and turn on SYSDBA auditing; but even if you don't sometimes the use of specific named users put people on the alert when they do something potentially dangerous and can avoid accidents. The other reason of not using SYS is to avoid accidental creation of objects in SYS and SYSTEM schema. The best option is to lock SYSTEM user and never let SYS user. Unfortunately you can't lock the SYS user. Third, you can create default tablespaces for all these DBA users to hold their objects, specifically temporary/occasional tables (not the global temporary tables), test tables, etc. and all those will not get into SYSTEM tablespace. Perhaps I should mention here is that I also conduct database security audits for corporations. But unlike your auditors, I tend to follow the advice up with more detailed information :) Arup Nanda www.proligence.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: Help Interpreting TKProf
Barb, What you're really after is called forward attribution in the book. You need to see the dbcall that immediately follows each WAIT nam='SQL*Net message from client' event in the trace file. This will tell you what database call's execution it was that ended the read(). Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 11/19 Sydney, 12/16 Detroit - SQL Optimization 101: 12/8 Dallas, 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Daniel Fink Sent: Wednesday, November 12, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Barbara, I know how distracted you were with all the jokes being tossed about, but really... It looks to me (with just this snippet of trace) that the cursor #3 did some communication and then waited for 10 seconds for a response. Without seeing the raw trace file and sequence of events, this is my best guess. Daniel Barbara Baker wrote: Daniel: Does this mean I was supposed to be paying attention in class?? Here's everything I can find associated with sql*net message from client in that cursor. Can't figure out from this how it came up with 10.73 (although that one wait matches up with the max wait of 10.71) Am I being really dense? WAIT!! don't answer that! WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1 wait_time = 1 centisecond p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1 wait_time = wait_time (1 cs) + 1 cs = 2 cs p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 1071 p1=1413697536 p2=1 p3=0 wait_time = wait_time(2 cs) + 1071 cs = 1073 cs -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel 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: Cary Millsap 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: (looong) PCTFREE, PCTUSED and ASSM
Yep, that's exactly what I thought, that due migration the row might go to a PX granule read by another slave... but I still don't see enough reason why migrated rows are handled different from serial scan. During serial scan you also might have rows in beginning of segment migrating to end of it, so there has to be some other reason as well. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 6:24 PM Using PQ, the segment is split into multiple sub-segments using rowid range scan. Since there is no guarantee that the migrated row will be in the same sub-segment that has the pointer to the migrated row, the PQ slave might need to resolve the issue real time. I mean the migrated row might exist in a different range that will be scanned by another PQ slave. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 10:49 AM To: Multiple recipients of list ORACLE-L As a strange thing, from 10046 trace I saw that normal table scanning was done using direct reads, this was expected behaviour, but the lookups of migrated rows were reflected as 'db file sequential reads'. And even more, there were 3 subsequent sequential read waits for the same datablock in a row, it seems that a PX slave isn't even able to cache one datablock in it's PGA, in case of finding migrated rows... (or a wait event is registered for reading from cache...) I was just wondering, why a PQ FTS requires resolving migrated rows immediately, instead of reading them when scan hits their location. Could it be some concurrency issue, that if a row migrates to another location during the scan, then results could get inconsistent? It is not a direct read issue, because I experimented using _serial_direct_read parameter, and for regular FTS, no migrated rows were resolved ahead. There's lot to learn... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 4:34 PM I believe it's direct read from files in parallel execution, nothing gets read from cache. Cached blocks for the table get flushed to files before the direct read. Regards, Waleed -Original Message- Sent: Wednesday, November 12, 2003 7:10 AM To: Multiple recipients of list ORACLE-L Yep, the situation can get bad for parallel execution, especially if blocks read aren't cached... But for serial FTS I haven't seen such a problem, I did even a test to verify it on 9.2.0.4, and did see behaviour as I expected - all blocks were scanned using multiblock reads and rows were returned in order the contents of them were found, instead of pointers. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 5:14 AM Actually row migration is a big problem for FTS also(whether serially or using PQ). You end up waiting for too many db file sequential read single block reads instead of MBRC in (direct path read, db file scattered read) Regards, Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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: Khedr, Waleed 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: Tanel Poder 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
