RE: Undelete Record
Use logminer http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer. htm#17869 Regards Naveen -Original Message- Sent: Friday, December 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
share oracle info?
Where can i find any softcopy or hardcopy books containing explanations or details of all data dictionary table? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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:RE: Deadlock
It is possible for ITL starvation to result in deadlocks, and changing INITRANS (and rebuilding the problem objects) would help - but no-one can give you an appropriate answer without seeing the deadlock graph that usually comes as The following information It would also help if you told use whether this was an ORA-04020 deadlock (dictionary internal) or ORA-00060 (data related). I think the text is the one that comes with ORA-00060, but the two texts are pretty similar. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- Sent: Thursday, December 19, 2002 12:55 PM To: Multiple recipients of list ORACLE-L Hi I have been noticing some times following error with one table during update. DEADLOCK DETECTED Current SQL statement for this session: The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock: Is chaning of INITTRANS would help ? Thx -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: performance comparision between LMT and DMT
Interesting test. One detail - the import will be creating indexes, which means it will be acquiring and formatting o/s blocks for the temp tablespace on demand. You might check how much used space you have in your temp, and check how long it would take to format by recreating that sized DMT tablespace. (35 minutes seems a bit long - but it was an 8GB t/s). If you have the time to repeat the test two more times, you could run it with a clean DMT and a clean LMT system, but keep taking snapshots of v$sesstat and v$session_event for the import process (or just use a logoff trigger to capture the values at the end of the import). PLay safe and take v$system_event and v$sysstat as well before and after the import. It would be interesting to see if the extra time showed up as CPU time or Wait time, and see what else we could infer from where the extra CPU/Waits were recorded. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 December 2002 04:56 Hi: We have several oracle 8173 dbs on Solaris 2.8. Recently I was planning to move all dictionary managered tablespace to locally-managered tablespace (except SYSTEM ts), because there are many advantages using lmt as I read. Today I did the following on a test db and here is what I did and found: 1. create a new locally-managered tablespace (8 files, each with 2048M in size), uniform extent 500K 2, cretae a temp tablespace (LMT) with tempfile (4 files, each 2000M in size), uniform extent 2M, very quick to create. 3. drop an old dmt wich holds data for a schema (say user SCH) 4. alter user SCH to set the default ts and temporary ts to tbs I created in step 1 and 2 5. run imp to import schema SCH from dump file. The import run successfully and the whole time was 5 hours and 40 minutes. This is about 35 minutes longer than the time it took last week! The only thing different was that the old tbs were NOT lmt, the dump file are basically the same, not much data change and there is no other stuff running on the machine. So my question is that if this is normal or I miss something here? Another questions is that from your experience how much improvement in terms of performance did you see after you convert dmt to lmt? TIA Guang Mei [EMAIL PROTECTED] http://www.geocities.com/guangmei/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: db block Size for Indexes Tablespaces in 9.2 ?
And just to add my bit...the possible performance gains with various blocksizes under various conditions all assume that your underlying OS layer provides good support for what you want to do. Whilst hardly being definitive, I remember (a few years ago now) a few colleagues of mine had access to a complete benchmarking suite of tools - as we were migrating a mainframe ERP product to oracle (on sun). So whilst we had the benchmarking gear, we had all sorts of fun with different db and os configs...Bottom line was, if you were purely on raw, then choosing the right blocksize was a function of how you intended oracle to be used - in our case (for the anticipated number of concurrent users), 4k outperformed the higher block sizes. For any non-raw test we could come up with (vxfs, ufs, ufs direct), the moment the oracle block size did not match the file system blocksize, things went to pot. So unless you intend totally avoiding a file system layer (something I'm personally a big fan of), a oracle blocksize decision may well be something that is not within the realms of the database anyway - its an OS issue. Cheers Connor --- Cary Millsap [EMAIL PROTECTED] wrote: Please pardon the forthcoming non-quantitative response... RESPONSE Yay! /RESPONSE Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Sent: Thursday, December 19, 2002 10:49 PM To: Multiple recipients of list ORACLE-L Please pardon the forthcoming rant... RANT Block size is one of the last things to consider in tuning indexes. Yes, it's a knob that can be twiddled, but it should be one of those out-of-the-way knobs that hardly ever get touched. It's much the same as adjusting DB_BLOCK_BUFFERS in order to improve performance -- after a certain point you are just rearranging deck chairs on the Titanic (i.e. waste of time and energy)... This list is for education, and it is important to understand how new features (like multiple block sizes and the multiple cache sizes to support them) can be used, so the discussion is useful. But these particular features are essentially intended for enabling transportable tablespaces between databases with differing block sizes. Not performance tuning. If they were actually intended for performance tuning, then why aren't there KEEP and RECYCLE buffer pools for each block size, to make them equivalent to the default buffer cache? How difficult would it have been to have those features in the other block size? Of course, this is not to say that a feature can't be adapted to purposes for which it wasn't intended, but it is food for thought, something to keep in mind... Time is more profitably spent ensuring that indexes are built only on columns that have data with high selectivity, ensuring that they are rebuilt periodically or that REVERSE indexes are used for monotonically-ascending data, that column-level CBO statistics are gathered where data skew exists, that indexes on columns with low selectively are used only in selecting unpopular data values, etc. After all these issues are resolved, then decisions about block size *might* produce a noticeable result. Tuning the block size for certain sets of indexes might yield a marginal improvement in performance at the very most, but shrewd SQL tuning commonly produces improvements of hundred-fold or thousand-fold, at the very least. Efficient SQL and wisely chosen indexes will beat out the perfect block size, any day of the week... /RANT OK, I'm better now... ..M..donuts.. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 17, 2002 10:33 PM Hi Arup , List Your point is Correct about High buffer busy wait Contention During Large OLTP Insert /Updates. High buffer busy wait on Corresponding INDEX during INSERT Operations was Observed during our previous benchmark which overcame by Converting to REVERSE Index as the Field Value was Sequentially Increasing . Following Article advocates HIGHER Block Size for Index , Strangely :- http://www.tusc.com/oracle/download/author.html#loneyk What may be the Commonly followed Best practice for DB_BLOCK_SIZE for Index Tablespaces in 9.2 ? Thanks -Original Message- Sent: Wednesday, December 18, 2002 12:14 AM To: Multiple recipients of list ORACLE-L I can't point to a paper or article on that, but based on tests I have done, the block size of index tablespaces for a high volume transaction system should be lower than the table block sizes. 2000 tps with 25 changes each does not sound like a really huge transaction rate. You could set the tables'
Re: ORA-04031
I happened when your shared pool is too small. You probably need to increase it. You can also clear the shared pool before the export but this will cause some degradation afterwards because whoever uses a procedure or function for the first time will have to wait for it to be loaded from the database. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 20, 2002 8:48 AM I received ORA-04031 while exporting database. Can someone explain what causes it and how to fix it? . exporting post-schema procedural objects and actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam Buffer) EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp . exporting statistics Export terminated successfully with warnings. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: Undelete Record
Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, 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).
RE: password
Title: Message BOB, its the same on my machine... 8.1.6 on NT -Venu -Original Message-From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:56 AMTo: Multiple recipients of list ORACLE-LSubject: RE: password created a user test identified by test on 2 separate systems in db's with different names The password value was the same Can someone verify if it is the same on their system Create user test identified by test; select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 -Original Message- on my db LTRACK1 SQL select password from dba_users where username = 'TEST'; PASSWORD--7A0F2B316C212D67 bob **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***
Re: Re:RE: Deadlock
Hello Dick If both processes first update table a and then table b there will be no deadlock problem. The first process will lock the row for update in table a and goes on to update table b. The second one will attempt to lock the row in table a and will wait for the first to finish. This can cause a delay but not a deadlock. I can see another potential problem: Process a selects item 1 and update stock on hand to 0. Process b reads item 1 and sees that stock on hand is 1 as process a did not finished the update in table b yet. In this case process b might decide that it does not need to update the stock on hand. Afterwards process a commit and you got stock on hand = 0 despite the fact that you have it in the warehouse. You must check that process b do select for update or does the update anyway without checking the stock on hand field. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 20, 2002 12:34 AM Please allow me to provide a case in point on the subject that we discovered and fixed some time ago. We have 2 PeopleSoft SQR's that are used for material movement into and out of the stock room. Both run on a scheduled basis and it is NOT odd to see both running at the same time. Now for every item in the stock room there is an entry in two different tables, one is a master list of all items (TABLE A) and if they have stock in the stock room + a couple of other control type columns. The other table says where the item is and how much is in that location (table B). Not bad at this point. Now, SQRA starts up to allocate material out of the stock room to the assembly floor. It starts by selecting all items that it needs to process and attempts to set stock on hand flag to zero on table A for each item it has. It then looks in the storage location (table B) and updates the quantity on hand field to decrement it by the amount to be sent to the floor. SQRB does similar things setting stock on hand in Table A to 1 and incrementing the on hand quantity in Table B, but in the reverse order. Can you see a potential deadlock brewing?? Dick Goulet Reply Separator Author: Fink; Dan [EMAIL PROTECTED] Date: 12/19/2002 2:04 PM Seema, Changing INITRANS may help IF you see waits for data block headers. INITRANS/MAXTRANS deal with the number of transactions that can lock a block at a given time. Deadlocks are caused when TransactionA has locked RowA and TxB has locked RowB. Then TxA needs to lock RowB (but can't because TxB has locked it) and TxB needs to lock RowA (but can't because TxA has locked it). The locks won't be released until the transaction completes, but they cannot complete successfully since they cannot acquire the needed lock. So you have a round robin affair. The transaction discovering the deadlock will be rolled back. Check the application code. Therein lies the problem. Dan Fink -Original Message- Sent: Thursday, December 19, 2002 12:55 PM To: Multiple recipients of list ORACLE-L Hi I have been noticing some times following error with one table during update. DEADLOCK DETECTED Current SQL statement for this session: The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock: Is chaning of INITTRANS would help ? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
RE: Happy Holidays
But what you can start doing is painting, plastering, levelling concrete and laying floors. 2 months in and the race is on to finish for Christmas. When all of that's done I can start looking for my wife's Christmas present. Hell, maybe I'll tell her that IS her present. All the best for the holidays folks, Mike -Original Message- Sent: 19 December 2002 21:17 To: Multiple recipients of list ORACLE-L you're a man. Genetically you can't start shopping until at LEAST 6 PM on Christmas Eve. --- Orr, Steve [EMAIL PROTECTED] wrote: Merry Christmas and/or Holly Happy-days to all. Man... I haven't even started my Christmas shopping yet. Sigh... Steve Orr, Still needing snow for a white Christmas (and skiing) in Montana... -Original Message- Sent: Thursday, December 19, 2002 1:31 PM To: Multiple recipients of list ORACLE-L Kevin, Thanks to you (and also to Lisa) for offering to share your scripts. Every little bit helps. Cherie Machler - close to leaving for vacation Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Footprint of 9i
I couldn't even get 9iAS R2 running on it's own with 500M. Of course it installs its own database so that doesn't help. My sympathies. Mike -Original Message- Sent: 19 December 2002 16:50 To: Multiple recipients of list ORACLE-L My issue is with memory requirements... try running iAS 9i R2 on 700M of RAM, with a local db. Ugh! Pat. -Original Message- Sent: Thursday, December 19, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Oracle 9.2.0.1 on NT: Demo files 80MB. Starter databases - 300MB Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 5:09 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Metelsky Sent: Thursday, December 19, 2002 13:49 To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob Bob, No surprises, you're not alone. The easiest 400MB to 500MB to remove are the templates and demo files for the starter instances and schemas. Try deleting %ORACLE_HOME%\assistants\dbca\templates\* to free up 300MB (these are the 'OLTP' and 'Data warehouse' templates used by the dbassist tool - if you don't use them for creating instances, get rid of them), and %ORACLE_HOME%\demo\schema\* to free up 100MB of the scripts used to create the sample schemas - again if you don't use them. There might be more that can be removed ... doco and the like ... but that's a start. 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
Re: Sql problem
Tim, Thank you very much for your help. I think it'll work. Zsolt At 07:04 2002.12.19. -0800, you wrote: Zsolt, In Oracle9i, you might be able to make use of the new WITH syntax: SQL with xxx as 2 (select 1+2 calc from dual) 3 select calc*2 from xxx; CALC*2 -- 6 It might cut down on typographic errors (if not syntax complexity) from repeatedly retyping the same complex formula... Hope this helps... -Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Undelete Record
the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, 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!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- 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).
RMAN, recatalog backup set
Hi! RMAN 8.1.7, nocatalog option I have two backup sets, placed on disk. Those backup sets contain archived logs. How do I register those sets (and arch. logs they contain) in newcontrolfile? "New controlfile" is created by "alter database backup controlfile to trace" script. So, RMAN info is nonexistant. Thanks, Vladimir Barac
Re: share oracle info?
technet.oracle.com has all the docs --- Jim [EMAIL PROTECTED] wrote: Where can i find any softcopy or hardcopy books containing explanations or details of all data dictionary table? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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).
Happy Holidays!!
Thanks to all for responding to my post on Oracle and Peoplesoft. I will be making the move this New Year. I wish I had found out about this List earlier. It is great to see people sharing their knowledge. Happy Holidays to every one!! Rachael, I have all my shopping done and gifts packed. :-) Wish we had a count of our kind on the list.(You know - orawoman kind.) Sumathy -Original Message- Sent: Thursday, December 19, 2002 11:35 AM To: Multiple recipients of list ORACLE-L I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata.As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tuftsTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .educc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45 AM Please respond to ORACLE-L Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: Happy Holidays
Title: RE: Happy Holidays Speaking of house ... Congratulations !! Yesterday my wife and I celebrated our 5th wedding anniversary. I was looking for what gift to give on a 5th anniversary. So my boss googled for a while and said ... he found the gift and a nice gift as well. He says, traditional gift is wood, so just give your wife the house you built. That was easy ... no shopping involved and she already loves the gift. Happy Holidays everyone !! Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: Happy Holidays Well I've got another excuse. We just moved into our newly constructed house. I tell the kids that they get their own room for Christmas and they just say, Oh Dad! So even though we're still living out of boxes I have to got get more junk and put it in fancier boxes... very strange. *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Disable Database Startup While COLD Backup is in Progress ?
Is here a way to Disable Database Startup While COLD Backup is in Progress ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_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: db block Size for Indexes Tablespaces in 9.2 ?
Title: RE: db block Size for Indexes Tablespaces in 9.2 ? Tim, it is no rant at all, at-least folks like (yours truly) can learn different aspects that must be considered in tuning. Thanks Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:49 PM To: Multiple recipients of list ORACLE-L Subject: Re: db block Size for Indexes Tablespaces in 9.2 ? Please pardon the forthcoming rant... [Sniped to save space ...] 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.*2
Object relational features and performance
Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a normal relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- 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: Undelete Record
If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Portal resources
Title: RE: How do I find Oracle's product roadmap? I was wondering if there are any resources on the 'net to help people customize Oracle Portal. I went to the OTN portal center and http://portal.oracle.com etc., but not sure where to look. Is it possible to configure Oracle Portal in such a way that it is hard to tell that it is in fact Oracle Portal? I am wondering how much of its look and feel is set in stone, and how much customization is possible. This is not critical, I am just experimenting. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED]
8i OCP DBA Exams
Hello Gurus, My company recently paid for the Oracle 8i DBA self-study courses to cover all 5 exams. Oracle sent me vouchers for the exams. The vouchers expire on July 31, 2003. Does that mean that the 8i DBA track is going to expire on that date and I really truly only have 6 months to write these exams? Thanks. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: password
Same on linux 7.2 Oracle 8.1.7 rel 3 Ron [EMAIL PROTECTED] 12/20/02 04:07AM BOB, its the same on my machine... 8.1.6 on NT -Venu -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: password created a user test identified by test on 2 separate systems in db's with different names The password value was the same Can someone verify if it is the same on their system Create user test identified by test; select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 -Original Message- on my db LTRACK1 SQL select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 bob -- 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).
import and rollback segments
Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-04031
Title: RE: ORA-04031 Hi David, I ran into this too. Try the following: 1. flush shared pool, re-execute 2. bounce database. IN addition if you search on this on Metalink you will find lots of info. HTH Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- From: Nguyen, David M [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 1:49 AM To: Multiple recipients of list ORACLE-L Subject: ORA-04031 I received ORA-04031 while exporting database. Can someone explain what causes it and how to fix it? . exporting post-schema procedural objects and actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam Buffer) EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp . exporting statistics Export terminated successfully with warnings. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Happy Holidays!!
I'm sure if Jared had time, energy or inclination, he could do a guess from the membership list. However, some names are not intuitively obvious as to gender. Not counting lurkers, since I can't tell who they are, I think there are at least 10 women on the list I'm more interested in the numbers to see if this field is less male-centric than others. --- Panicker, Thankam S. [EMAIL PROTECTED] wrote: Thanks to all for responding to my post on Oracle and Peoplesoft. I will be making the move this New Year. I wish I had found out about this List earlier. It is great to see people sharing their knowledge. Happy Holidays to every one!! Rachael, I have all my shopping done and gifts packed. :-) Wish we had a count of our kind on the list.(You know - orawoman kind.) Sumathy -Original Message- Sent: Thursday, December 19, 2002 11:35 AM To: Multiple recipients of list ORACLE-L I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata.As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tuftsTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .educc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45 AM Please respond to ORACLE-L Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-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: Undelete Record
We're in this situation right now. A user has delete information and want it back. Problem is that we do not know when it was delete. I have restore 20 copies (days) of the table via import. Going with logminer would have been difficult since we do not know when the data was changed and we have a lot of redo generation. --- Naveen Nahata [EMAIL PROTECTED] a écrit : Use logminer http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer. htm#17869 Regards Naveen -Original Message- Sent: Friday, December 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: API for TNSPING
KL Does anyone happen to have a pointer to documentation on any APIs KL for TNSPING that exist ?? One of our developers is putting KL together a page and he would like to get the value of the 'length KL of time' that TNSPING returns. Do you consider Pro*C as a set of API's? If so, writing a Pro*C program that logs on and reports the results could give what you want. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Row cache locks on INSERTs with a sequence
Title: Row cache locks on INSERTs with a sequence We are continually seeing sessions hanging on row cache locks, which in turn appear to be on dc_segments: SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - - -- -- -- - 29 row cache lock cache id 13 mode 0 request 5 105 row cache lock cache id 13 mode 0 request 5 The offending SQL statement is an INSERT of the following form: INSERT INTO TABLE (A,B,C,D...) VALUES (:b1, :b2, :b3, SEQUENCE.NEXTVAL,..) The sequence in question has it's cache value set to the default of 20. The developers keep insisting that it's a shared pool issue. I've researched Metalink and not come up with a whole lot. I've ran statspack and it has rendered advice with respect to the fact that a lot of new sequence values are being acquired, therefore the sequence cache size needs examination. But it is necessarily the small cache size of a sequence that can cause these locking issues? Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages'
RE: import and rollback segments
You can not specify RB segment for import to use. Consider using commit=y option of the import command. - Kirti -Original Message- Sent: Friday, December 20, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN, recatalog backup set
When you are not using a catalog database, the control file is your only catalog. If you destroy all copies ofit, then you have destroyed your catalog. It's gone. It is a late catalog. It is no more. (I wish I could remember the Monty Python dead parrot bit.) That's why you must backup the control file at the end of the rman backup -- a REAL backup of the file itself, not a "to trace" backup. -Original Message-From: Vladimir Barac [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 4:49 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN, recatalog backup set Hi! RMAN 8.1.7, nocatalog option I have two backup sets, placed on disk. Those backup sets contain archived logs. How do I register those sets (and arch. logs they contain) in newcontrolfile? "New controlfile" is created by "alter database backup controlfile to trace" script. So, RMAN info is nonexistant. Thanks, Vladimir Barac
Re:RE: Undelete Record
If you have no idea when the data was deleted then your completely out of luck. Bad answer I know, but without that little piece of information it's a needle in several haystacks on several farms type of problem. End of conversation. Dick Goulet Reply Separator Author: =?iso-8859-1?q?Stephane=20Paquette?= [EMAIL PROTECTED] Date: 12/20/2002 6:28 AM We're in this situation right now. A user has delete information and want it back. Problem is that we do not know when it was delete. I have restore 20 copies (days) of the table via import. Going with logminer would have been difficult since we do not know when the data was changed and we have a lot of redo generation. --- Naveen Nahata [EMAIL PROTECTED] a écrit : Use logminer http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer. htm#17869 Regards Naveen -Original Message- Sent: Friday, December 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
best case scenarios for export/import
Good day, all: I'm looking for real-life best-case scenarios for running import/export . . . I've been playing with this for quite some time and would like to know how fast I can really expect this to go, particularly for the import. I'd be interested to hear others' experiences - how fast have you been able to import data? what parameters have you used? etc. . . . it's both for informational purposes and as a sanity check. For example: I'm now trying to import a dump file of appx 6.5 Gb - breaks down into 12G data and 4G indexes. using the following params on the first import, to just get the data (I then rerun with the indexfile param to get the indexes): recordlength=65535 buffer=1500 (15M) commit=y indexes=n constraints=n grants=n This will import in appx 36 hours using a single 3 Gb rollback segment What kind of experiences have you had? Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays
Ah yes. . . there's nothing quite like home construction/renovation projects during the holidays to put the 'ell in jingle bells, aye. Or as I once put it: 'Twas the night before Christmas and all through our house not a creature was stirring, the wall was blown out. Lumber and plaster lay around in a heap, electric and plumbing supplies were hip deep. . . . [ Oracle instances were stuffed up the chimney with care. ] Happy Holidays, Mike -Original Message- Sent: Friday, December 20, 2002 4:54 AM To: Multiple recipients of list ORACLE-L But what you can start doing is painting, plastering, levelling concrete and laying floors. 2 months in and the race is on to finish for Christmas. When all of that's done I can start looking for my wife's Christmas present. Hell, maybe I'll tell her that IS her present. All the best for the holidays folks, Mike This transmission is intended only for use by the addressee(s) named herein and may contain information that is proprietary, confidential and/or legally privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Disable Database Startup While COLD Backup is in Progress
If you perform the cold backup from a script you can set a flag with the script. Modify the database startup script to check the flag. If the flag is set exit the database startup script. Simple but effective. Ron [EMAIL PROTECTED] 12/20/02 08:19AM Is here a way to Disable Database Startup While COLD Backup is in Progress ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_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: 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: Giving back Perl
Title: Giving back Perl The scripts are posted at www.optimaldba.com/library.html. Thanks to Lisa for sharing this with all of us! -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: Giving back Perl Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was "why don't you give back to the community". So I figure if I offer up my latest creation I could 1. give back and maybe help a person or two and 2. receive comments on my coding. My coding style is rather simplistic and I would appreciate any comments about what I'm doing wrong/how something could be done differently (TMTOWTDI), etc. My environment is W2K sp2/8.1.7.2. I slapped together a script that fires backup controlfile to trace (including the stored proc) and ftp's it off to another server. If anyone is interested in seeing it please email me directly. Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
RE: Disable Database Startup While COLD Backup is in Progress ?
Yes, there are... all are tricks or workarounds - Kirti -Original Message- Sent: Friday, December 20, 2002 7:19 AM To: Multiple recipients of list ORACLE-L Is here a way to Disable Database Startup While COLD Backup is in Progress ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Undelete Record
That's what I told the support team. I can give all the imports that are on the tape and good luck. --- [EMAIL PROTECTED] a écrit : If you have no idea when the data was deleted then your completely out of luck. Bad answer I know, but without that little piece of information it's a needle in several haystacks on several farms type of problem. End of conversation. Dick Goulet Reply Separator Author: =?iso-8859-1?q?Stephane=20Paquette?= [EMAIL PROTECTED] Date: 12/20/2002 6:28 AM We're in this situation right now. A user has delete information and want it back. Problem is that we do not know when it was delete. I have restore 20 copies (days) of the table via import. Going with logminer would have been difficult since we do not know when the data was changed and we have a lot of redo generation. --- Naveen Nahata [EMAIL PROTECTED] a écrit : Use logminer http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/logminer. htm#17869 Regards Naveen -Original Message- Sent: Friday, December 20, 2002 12:14 PM To: Multiple recipients of list ORACLE-L Hi Listers, I have little problem : how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from
RE: Row cache locks on INSERTs with a sequence
Title: Row cache locks on INSERTs with a sequence It looks like sequence generation caching rate is slower than your insertion rate. Waleed -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 9:45 AMTo: Multiple recipients of list ORACLE-LSubject: Row cache locks on INSERTs with a sequence We are continually seeing sessions hanging on row cache locks, which in turn appear to be on dc_segments: SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - - -- -- -- - 29 row cache lock cache id 13 mode 0 request 5 105 row cache lock cache id 13 mode 0 request 5 The offending SQL statement is an INSERT of the following form: INSERT INTO TABLE (A,B,C,D...) VALUES (:b1, :b2, :b3, SEQUENCE.NEXTVAL,..) The sequence in question has it's cache value set to the default of 20. The developers keep insisting that it's a shared pool issue. I've researched Metalink and not come up with a whole lot. I've ran statspack and it has rendered advice with respect to the fact that a lot of new sequence values are being acquired, therefore the sequence cache size needs examination. But it is necessarily the small cache size of a sequence that can cause these locking issues? Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages'
RE: Re:RE: Deadlock
Jonathan, What do you mean by ITL starvation? And how would it result in a deadlock? Dan Fink -Original Message- Sent: Friday, December 20, 2002 1:44 AM To: Multiple recipients of list ORACLE-L It is possible for ITL starvation to result in deadlocks, and changing INITRANS (and rebuilding the problem objects) would help - but no-one can give you an appropriate answer without seeing the deadlock graph that usually comes as The following information It would also help if you told use whether this was an ORA-04020 deadlock (dictionary internal) or ORA-00060 (data related). I think the text is the one that comes with ORA-00060, but the two texts are pretty similar. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- Sent: Thursday, December 19, 2002 12:55 PM To: Multiple recipients of list ORACLE-L Hi I have been noticing some times following error with one table during update. DEADLOCK DETECTED Current SQL statement for this session: The following deadlock is not an ORACLE error. It is a deadlock due to user error in the design of an application or from issuing incorrect ad-hoc SQL. The following information may aid in determining the deadlock: Is chaning of INITTRANS would help ? Thx -Seema -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Undelete Record
and if they caught the problem within the retention time and if there wasn't a lot of activity that would cause Oracle to overwrite the undo segment anyway... and and and while I like the idea of flashback query, I'd hate to depend on it for data recovery. --- Deshpande, Kirti [EMAIL PROTECTED] wrote: If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: best case scenarios for export/import
Title: RE: best case scenarios for export/import 2 x (IBM p690, 16CPU, 16GB Ram, Oracle 9201), Export file from 8161 34GB. Import is 12 parallel streams (6 on each machines) with no constraints, custom parfiles (to import certain schema per stream only), buffer (either 8M and 16M), 12GB Undo on each instance, all tablespaces LMT When testing the migration plan, I used to (everything below was scripted) 1. Drop the database 2. Create the database total datafiles are about 140GB. 3. precreate all objects with no data, no indexes 4. Run all imports 5. Validate everything is okay. 6. Trash everything and start all over again. The last week (Mon-Fri) I actually tested the whole process at-least twice in a day proofing the scripts, always looking for UNKNOWN-PROBLEMS and always scanning for KNOWN PROBLEMS. Total time 1 Hour and 30 minutes for the import using pre-created objects (no indexes). This is all from memory we did migrate on Oct 12, we had a good sized window. AIX created a problem with shared disk when we were in middle of import. So we trashed all we did and restarted. The databases were up and running, all verified, completely analyzed, necessary indexes (intermedia etc) rebuilt and running Active/Active on RAC one minute before user testing was supposed to start. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Magaliff, Bill [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 9:04 AM To: Multiple recipients of list ORACLE-L Subject: best case scenarios for export/import Good day, all: I'm looking for real-life best-case scenarios for running import/export . . . I've been playing with this for quite some time and would like to know how fast I can really expect this to go, particularly for the import. I'd be interested to hear others' experiences - how fast have you been able to import data? what parameters have you used? etc. . . . it's both for informational purposes and as a sanity check. For example: I'm now trying to import a dump file of appx 6.5 Gb - breaks down into 12G data and 4G indexes. using the following params on the first import, to just get the data (I then rerun with the indexfile param to get the indexes): recordlength=65535 buffer=1500 (15M) commit=y indexes=n constraints=n grants=n This will import in appx 36 hours using a single 3 Gb rollback segment What kind of experiences have you had? Thanks bill 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.*2
Re: best case scenarios for export/import
First of all you have to have an estimate on how long the import should take. Oracle rule-of-thumb formula for that is import elapsed time = export elapsed time X 4 At least you have a targeted time to shoot for then try to improve if necessary. Rick Magaliff, Bill Bill.Magaliff@len To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] dware.com cc: Sent by: Subject: best case scenarios for export/import [EMAIL PROTECTED] 12/20/2002 09:04 AM Please respond to ORACLE-L Good day, all: I'm looking for real-life best-case scenarios for running import/export . . . I've been playing with this for quite some time and would like to know how fast I can really expect this to go, particularly for the import. I'd be interested to hear others' experiences - how fast have you been able to import data? what parameters have you used? etc. . . . it's both for informational purposes and as a sanity check. For example: I'm now trying to import a dump file of appx 6.5 Gb - breaks down into 12G data and 4G indexes. using the following params on the first import, to just get the data (I then rerun with the indexfile param to get the indexes): recordlength=65535 buffer=1500 (15M) commit=y indexes=n constraints=n grants=n This will import in appx 36 hours using a single 3 Gb rollback segment What kind of experiences have you had? Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Portal resources
Patrice, Happy Holidays. What is the system you installed 9iAS on and what are the minimum system requirements you were able to get it working with? I am thinking of trying to load it on Linux RedHat 7.2 with 512 Meg ram but if I remember correctly the minimum requirements were for more ram and I don't have an extra chip right now. Maybe after we migrate from out Dell 6300 server with 1 GIG ram I can install Linux and 9iAS as a play station. From what I remember from the dog and pony shows, you can make it look like any other web site. It's all in how creative you choose to be. Ron [EMAIL PROTECTED] 12/20/02 08:54AM I was wondering if there are any resources on the 'net to help people customize Oracle Portal. I went to the OTN portal center and http://portal.oracle.com http://portal.oracle.com etc., but not sure where to look. Is it possible to configure Oracle Portal in such a way that it is hard to tell that it is in fact Oracle Portal? I am wondering how much of its look and feel is set in stone, and how much customization is possible. This is not critical, I am just experimenting. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- 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:Object relational features and performance
Stefan, I make limited use of TYPES in our largest production DB(8.1.7.4). Works very well. No problems to date. Dick Goulet Reply Separator Author: Stefan Jahnke [EMAIL PROTECTED] Date: 12/20/2002 4:34 AM Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a normal relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Happy Holidays!!
Rachel, I suspect that there are many more than ten female subscribers to the list. However, I'd have to agree that there are at least a dozen women who post somewhat regularly. Going to our local Oracle User's Group meeting, there are about 25% women in attendance at the meeting when I look over the crowd. I'm seeing a lot more young women at the meetings lately. Cherie Machler Oracle DBA Gelco Information Network Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Happy Holidays!! Sent by: [EMAIL PROTECTED] om 12/20/02 08:04 AM Please respond to ORACLE-L I'm sure if Jared had time, energy or inclination, he could do a guess from the membership list. However, some names are not intuitively obvious as to gender. Not counting lurkers, since I can't tell who they are, I think there are at least 10 women on the list I'm more interested in the numbers to see if this field is less male-centric than others. --- Panicker, Thankam S. [EMAIL PROTECTED] wrote: Thanks to all for responding to my post on Oracle and Peoplesoft. I will be making the move this New Year. I wish I had found out about this List earlier. It is great to see people sharing their knowledge. Happy Holidays to every one!! Rachael, I have all my shopping done and gifts packed. :-) Wish we had a count of our kind on the list.(You know - orawoman kind.) Sumathy -Original Message- Sent: Thursday, December 19, 2002 11:35 AM To: Multiple recipients of list ORACLE-L I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata.As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tuftsTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .educc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45
Re: Happy Holidays!!
Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Giving back sqlldr (was: Giving back Perl)
Great idea, Lisa! I may not have much to give back to the List for all that It's done for me, but this little ditty I just threw together might help someone: I've been struggling with grep, awk, and sed on the listener.log file to help me get an idea of how we're hitting our production DBs. Without much luck (not very good w/awk), a dim 10-watt bulb switched on when I thought of dumping the pertinent parts of the log into a DB so we can SQL some reports off of them. Since I rotate our listener.log daily to prevent them from growing too large (~10K attaches/day), a simple table and accompanying SQL*Load script ought to do the job. First, the simple table, indexes, and a trigger: CREATE TABLE LISTENER_LOG ( TIMESTAMP DATE, SIDNAMEVARCHAR2(10), PROGRAMVARCHAR2(80), HOSTNAME VARCHAR2(32), OSUSER VARCHAR2(32), IPADDR VARCHAR2(15) ); CREATE INDEX LISTENER_LOG_HOSTNAME ON LISTENER_LOG (HOSTNAME); CREATE INDEX LISTENER_LOG_OSUSER ON LISTENER_LOG (OSUSER); CREATE INDEX LISTENER_LOG_PROGRAM ON LISTENER_LOG (PROGRAM); REM Trigger used to remove Windohs directory specs from program name. CREATE OR REPLACE TRIGGER LISTENER_LOG_I BEFORE INSERT ON LISTENER_LOG FOR EACH ROW DECLARE BEGIN :NEW.program := LOWER(SUBSTR(:NEW.program,INSTR(:NEW.program,'\',-1)+1)); END listener_log_i; / SHOW ERRORS; Obviously, the above can be modified for size, tablespace, etc. Next, we need a SQL*Loader control file: load data infile '$ORACLE_HOME/network/log/listener.log' badfile 'listener.err' append into table listener_log when (43) = 'P' trailing nullcols (timestamp position(1:20) date DD-MON- HH24:MI:SS, skip1 FILLER char terminated by '=', sidname enclosed by (SID= and ), skip2 FILLER char terminated by =, program enclosed by (PROGRAM= and ), hostname enclosed by (HOST= and ), osuser enclosed by (USER= and ))), skip3 FILLER char terminated by '=', skip4 FILLER char terminated by '=', skip5 FILLER char terminated by ')', ipaddr enclosed by (HOST= and ) ) I used the WHEN clause to only pickup those rows in the listener.log file that actually log a connection to our production DB. For this example, our production DB might be PROD. The placement of the (SID=PROD) section will vary depending on how the service is defined in Oracle Networking (e.g. TNSNAMES.ORA, ONAMES, LDAP). Ours happens to start at column 43. Modify the WHEN clause according to your own listener.log. Additionally, with 8i (I think) there could be a (SRVR=DEDICATED) or (SERVER=DEDICATED) block -- unless you're using MTS (we're not). For this, I needed to change skip2 to read: skip2 FILLER char enclosed by (SRVR= and =, Finally, we need to call SQL*Loader (for me this is on 8.1.7 on HP/UX): sqlldr MYSCHEMANAME control=listener.sqlload log=listener_sqlload.log direct=false rows=2000 bindsize=1000 readsize=1000 ...where MYSCHEMANAME is the same user that owns the LISTENER_LOG table. Expect many many Discarded - failed all WHEN clauses in the listener_sqlload.log file. That's it! Afterwards, you can have all sorts of Holiday fun whilst querying your newly poplulated table. When we get to 9i, I'm thinking that an external table and a CTAS or other load script might do the trick, too. Ho-Ho-Hope this can help someone! Merry Christmas! Happy New Year! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, December 19, 2002 11:30 AM To: Multiple recipients of list ORACLE-L Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was why don't you give back to the community. So I figure if I offer up my latest creation I could 1. give back and maybe help a person or two and 2. receive comments on my coding. My coding style is rather simplistic and I would appreciate any comments about what I'm doing wrong/how something could be done differently (TMTOWTDI), etc. My environment is W2K sp2/8.1.7.2. I slapped together a script that fires backup controlfile to trace (including the stored proc) and ftp's it off to another server. If anyone is interested in seeing it please email me directly. Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- 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
RE: 8i OCP DBA Exams
Saira Well, you have some incentive to get on with the exams. ;-) I am certain that the 8i DBA track won't expire on that date. Oracle will formally announce the expiration date well ahead of the event. If you are unable to complete all the exams in time, it is possible you might get the vouchers extended, but if the voucher must be tendered to the exam center, then it might be more difficult to get an extension. Plan for one exam per month and you will have a month cushion! Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 7:24 AM To: Multiple recipients of list ORACLE-L Hello Gurus, My company recently paid for the Oracle 8i DBA self-study courses to cover all 5 exams. Oracle sent me vouchers for the exams. The vouchers expire on July 31, 2003. Does that mean that the 8i DBA track is going to expire on that date and I really truly only have 6 months to write these exams? Thanks. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: API for TNSPING
It's pretty easy just to call tnsping and parse the output using Perl or PHP. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Eskridge Sent: Friday, December 20, 2002 8:25 AM To: Multiple recipients of list ORACLE-L KL Does anyone happen to have a pointer to documentation on any APIs KL for TNSPING that exist ?? One of our developers is putting KL together a page and he would like to get the value of the 'length KL of time' that TNSPING returns. Do you consider Pro*C as a set of API's? If so, writing a Pro*C program that logs on and reports the results could give what you want. -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: import and rollback segments
If you cannot take the small ones offline, I do not think you can force to use a particular RBS. You could possible create multiple large RBS then take smaller ones offline then import. After completion put smaller ones online. You can try commit=y to commit after each buffer instead of each object. Use a larger BUFFER size on import to reduce round trips to export file. Perhaps others have some tricks Rick Leonard, George george.leonard@fa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rnell.com cc: Sent by: Subject: import and rollback segments [EMAIL PROTECTED] 12/20/2002 08:09 AM Please respond to ORACLE-L Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: share oracle info?
Rachel - Excellent answer and brief as well. Jim - An additional resource is Google. When you encounter a table you don't believe you have all the information you want from the manuals, search the Internet for additional information. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 4:59 AM To: Multiple recipients of list ORACLE-L technet.oracle.com has all the docs --- Jim [EMAIL PROTECTED] wrote: Where can i find any softcopy or hardcopy books containing explanations or details of all data dictionary table? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: 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: 8i OCP DBA Exams
Hi, Voucher expiration dates having NOTHING to do with retiring of a track. Every voucher has an expiration date, no different on any coupon you get out of the newspaper. No announcement has been made on retiring 8i DBA track. Oracle typically retires a track 6 months after announcement. Rick Saira Somani saira_somani@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Subject: 8i OCP DBA Exams [EMAIL PROTECTED] om 12/20/2002 08:24 AM Please respond to ORACLE-L Hello Gurus, My company recently paid for the Oracle 8i DBA self-study courses to cover all 5 exams. Oracle sent me vouchers for the exams. The vouchers expire on July 31, 2003. Does that mean that the 8i DBA track is going to expire on that date and I really truly only have 6 months to write these exams? Thanks. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: import and rollback segments
I am going with the commit=y it seems the best option since I am already using buffer size. This way I don't need to do anything with my current rollbacks. Thx for the feedback PS: can not remember now who it is but someone on this group wrote a new rman backup recover manual, can someone pls forward me the title of the book, someone asked me for it, know if I go to borders will find it just can not remember at the moment, Thx all, have a good weekend. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- Sent: 20 December 2002 14:54 PM To: Multiple recipients of list ORACLE-L You can not specify RB segment for import to use. Consider using commit=y option of the import command. - Kirti -Original Message- Sent: Friday, December 20, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: best case scenarios for export/import
Bill - For other import tuning ideas, see http://www.orafaq.com/faqiexp.htm Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Good day, all: I'm looking for real-life best-case scenarios for running import/export . . . I've been playing with this for quite some time and would like to know how fast I can really expect this to go, particularly for the import. I'd be interested to hear others' experiences - how fast have you been able to import data? what parameters have you used? etc. . . . it's both for informational purposes and as a sanity check. For example: I'm now trying to import a dump file of appx 6.5 Gb - breaks down into 12G data and 4G indexes. using the following params on the first import, to just get the data (I then rerun with the indexfile param to get the indexes): recordlength=65535 buffer=1500 (15M) commit=y indexes=n constraints=n grants=n This will import in appx 36 hours using a single 3 Gb rollback segment What kind of experiences have you had? Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Disable Database Startup While COLD Backup is in Progress ?
Just move one of the controlfiles to another directory before startup of your cold backup and after cold backup finishes, you can put it back in the original directory. But why you need this, at least the people who are managing the databases, should know that it's backup time and they should not try to start. And those who don't know the backup timings shouldn't be having privileges to startup database isn't it ;-) HTH, Rajesh Dayal -Original Message- Sent: Friday, December 20, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Is here a way to Disable Database Startup While COLD Backup is in Progress ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Happy Holidays!!
It's quite a few more than that. Reading the first 50 lines of the subscription roster, 11 of the subscribers have obviously female names. Jared On Friday 20 December 2002 06:04, Rachel Carmichael wrote: I'm sure if Jared had time, energy or inclination, he could do a guess from the membership list. However, some names are not intuitively obvious as to gender. Not counting lurkers, since I can't tell who they are, I think there are at least 10 women on the list I'm more interested in the numbers to see if this field is less male-centric than others. --- Panicker, Thankam S. [EMAIL PROTECTED] wrote: Thanks to all for responding to my post on Oracle and Peoplesoft. I will be making the move this New Year. I wish I had found out about this List earlier. It is great to see people sharing their knowledge. Happy Holidays to every one!! Rachael, I have all my shopping done and gifts packed. :-) Wish we had a count of our kind on the list.(You know - orawoman kind.) Sumathy -Original Message- Sent: Thursday, December 19, 2002 11:35 AM To: Multiple recipients of list ORACLE-L I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata.As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tuftsTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .educc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45 AM Please respond to ORACLE-L Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
Re: Happy Holidays!!
I was just going, off the top of my head, from names I remember seeing post. And I was hoping I was wrong! :) --- Jared Still [EMAIL PROTECTED] wrote: It's quite a few more than that. Reading the first 50 lines of the subscription roster, 11 of the subscribers have obviously female names. Jared On Friday 20 December 2002 06:04, Rachel Carmichael wrote: I'm sure if Jared had time, energy or inclination, he could do a guess from the membership list. However, some names are not intuitively obvious as to gender. Not counting lurkers, since I can't tell who they are, I think there are at least 10 women on the list I'm more interested in the numbers to see if this field is less male-centric than others. --- Panicker, Thankam S. [EMAIL PROTECTED] wrote: Thanks to all for responding to my post on Oracle and Peoplesoft. I will be making the move this New Year. I wish I had found out about this List earlier. It is great to see people sharing their knowledge. Happy Holidays to every one!! Rachael, I have all my shopping done and gifts packed. :-) Wish we had a count of our kind on the list.(You know - orawoman kind.) Sumathy -Original Message- Sent: Thursday, December 19, 2002 11:35 AM To: Multiple recipients of list ORACLE-L I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata.As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tuftsTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .educc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45 AM Please respond to ORACLE-L Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED]
RE: Object relational features and performance
Stefan - I believe the general consensus had emerged that usually object features aren't worth the effort. Often there are few benefits, and if you don't do it correctly you may see bad performance. Two questions: 1. Are your developers/management enamored with the concept of object, or is this just your own curiosity? 2. Is there something about your application that leads you to believe that it might derive significant benefit from the object features? For general business applications it is hard to beat the flexibility of the good old traditional relational data modeling. The lack of discussion may provide part of the answer to your question. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 6:35 AM To: Multiple recipients of list ORACLE-L Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a normal relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- 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). -- 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: Happy Holidays!!
Rachel, I'm in that category too. Newest Oracle DBA/Sys Admin on board at a 3rd Party Logistics company - Hospital Logistics Inc. And I admit! I'm a lurker :-) Saira Somani Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: password
Yes, this is the intended behaviour (although I can't find where it actually documented). Passwords are stored using a one-way encryption and this encrypted form applies to all Oracle platforms. It is used, for example, during export/import of full dumps where the users are created on the new (import) database with the same password they had on the old (export) database simply by copying the encrypted form. This must be cross-platform/version, and exp/imp is cross-platform/version. You can do the same thing as exp/imp does by: CREATE USER user IDENTIFIED BY VALUES encrypted form eg CREATE USER TEST IDENTIFIED BY VALUES '7A0F2B316C212D67'; Note, though that the encrypted form of the password is dependent on the username for which it applies, so you cannot use this to set the same password for a differently named user. - Bill. At 06:14 20/12/2002 -0800, you wrote: Same on linux 7.2 Oracle 8.1.7 rel 3 Ron [EMAIL PROTECTED] 12/20/02 04:07AM BOB, its the same on my machine... 8.1.6 on NT -Venu -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: password created a user test identified by test on 2 separate systems in db's with different names The password value was the same Can someone verify if it is the same on their system Create user test identified by test; select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 -Original Message- on my db LTRACK1 SQL select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 bob -- 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). -- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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:RE: Deadlock
Set maxtrans to 2 on a table. Insert three rows into the same block and commit. Use three sessions to update one row each. The third transaction has to wait for one of the other two transactions to commit, as there are insufficient ITL (interested transaction list) entries for three concurrent transactions on the same block. Now repeat the experiment with: rows A1, B1, C1 in block 1 rows A2, B2, C2 in block 2. Session X updates row A1 and A2, Session Y updates row B1 Session Z updates row C2 Session Y tries to update row B2 and waits because the ITL is full Session Z tries to update row C1 and waits because the ITL is full With a little luck, Y will be waiting for Z and Z will be waiting for Y (i.e. DEADLOCK) but you may have to fiddle with a more complex example, as both X and Y might end up waiting for A. It's easier to do this in 8.1 because MAXTRANS can be set to 1, so you need only use two sessions and two rows per block. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 December 2002 16:56 Jonathan, What do you mean by ITL starvation? And how would it result in a deadlock? Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: best case scenarios for export/import
Hi, That doesn't sound particularly healthy to me. Depends what you're running on I guess. We have a nightly batch job which does an import on 8.1.7, rather weedy 933MHz Intel, 50Mb SGA, 4 x SCSI disk Linux box. The dump file is 4.0Gb which turns out to be about 6Gb data, 1Gb indexes. It takes 3 hours, including all the index creation, and I've not even bothered trying to tune it *at all* (ie. default import parameters) because the window available for it is about 14 hours. One thing to take care over with indexes=n is that this is does not disable the creation of constraint indexes (ie. Primary Key, Unique). You may need to adjust the sort_area_size for these (however, I've not bothered as I still have 11 hours of spare window). When I do need to do this, I bounce the instance and set the sort_area_size instance wide - maybe somebody can suggest a better way of doing it just for the import? I guess your next step is to monitor the import itself and look at the wait events to see if something is obviously amiss. - Bill. At 06:04 20/12/2002 -0800, you wrote: Good day, all: I'm looking for real-life best-case scenarios for running import/export . . . I've been playing with this for quite some time and would like to know how fast I can really expect this to go, particularly for the import. I'd be interested to hear others' experiences - how fast have you been able to import data? what parameters have you used? etc. . . . it's both for informational purposes and as a sanity check. For example: I'm now trying to import a dump file of appx 6.5 Gb - breaks down into 12G data and 4G indexes. using the following params on the first import, to just get the data (I then rerun with the indexfile param to get the indexes): recordlength=65535 buffer=1500 (15M) commit=y indexes=n constraints=n grants=n This will import in appx 36 hours using a single 3 Gb rollback segment What kind of experiences have you had? Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-04031
David, What OS and Oracle version? At least in 8.1.7.0.0 on HPUX that error message could be the result of a bug - we get it every few weeks on our production financials database and have to bounce the DB. Flushing the Shared Pool every night doesn't prevent it. Eventually we'll patch to 8.1.7.4 where it's supposedly fixed. This from Metalink (didn't copy the ID of the doc I found this in): If you are receiving ORA-4031 errors which reference BAMIMA: Bam Buffer, please apply the 8.1.7.4 patchset. It is possible that you are hitting bug 2104071 which is fixed in that patchset. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED] Nguyen, David M david.m.nguyen@xTo: Multiple recipients of list ORACLE-L o.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: ORA-04031 12/20/2002 12:48 AM Please respond to ORACLE-L I received ORA-04031 while exporting database. Can someone explain what causes it and how to fix it? . exporting post-schema procedural objects and actions EXP-8: ORACLE error 4031 encountered ORA-04031: unable to allocate 4096 bytes of shared memory (shared pool,BEGIN :1 := SYS.DBMS_REFR...,PL/SQL MPCODE,BAMIMA: Bam Buffer) EXP-00083: The previous problem occurred when calling SYS.DBMS_REFRESH_EXP_SITES.schema_info_exp . exporting statistics Export terminated successfully with warnings. Thanks, David -- Author: Nguyen, David M INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Undelete Record
You can't depend on Flashback query for recovery. Even if the undo entries are not overwritten, there is a hard limit of retention. The maximum retention period is 5 days. Actually, the data could be retained for longer, but the SCN - Time map that allows for flashing back has a 5 day limit. -Original Message- Sent: Friday, December 20, 2002 8:35 AM To: Multiple recipients of list ORACLE-L and if they caught the problem within the retention time and if there wasn't a lot of activity that would cause Oracle to overwrite the undo segment anyway... and and and while I like the idea of flashback query, I'd hate to depend on it for data recovery. --- Deshpande, Kirti [EMAIL PROTECTED] wrote: If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Disable Database Startup While COLD Backup is in Progress ?
Just move one of the controlfiles to another directory before startup of your cold backup and after cold backup finishes, you can put it back in the original directory. But why you need this, at least the people who are managing the databases, should know that it's backup time and they should not try to start. And those who don't know the backup timings shouldn't be having privileges to startup database isn't it ;-) HTH, Rajesh Dayal -Original Message- Sent: Friday, December 20, 2002 5:19 PM To: Multiple recipients of list ORACLE-L Is here a way to Disable Database Startup While COLD Backup is in Progress ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: VIVEK_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: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN, recatalog backup set
Yup - if you look at your 'backup to trace' file it says that all recovery manager information will be lost. -Original Message-From: Stephen Lee [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 9:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: RMAN, recatalog backup set When you are not using a catalog database, the control file is your only catalog. If you destroy all copies ofit, then you have destroyed your catalog. It's gone. It is a late catalog. It is no more. (I wish I could remember the Monty Python dead parrot bit.) That's why you must backup the control file at the end of the rman backup -- a REAL backup of the file itself, not a "to trace" backup. -Original Message-From: Vladimir Barac [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 4:49 AMTo: Multiple recipients of list ORACLE-LSubject: RMAN, recatalog backup set Hi! RMAN 8.1.7, nocatalog option I have two backup sets, placed on disk. Those backup sets contain archived logs. How do I register those sets (and arch. logs they contain) in newcontrolfile? "New controlfile" is created by "alter database backup controlfile to trace" script. So, RMAN info is nonexistant. Thanks, Vladimir Barac
RE: Disable Database Startup While COLD Backup is in Progress
Rename the init.ora? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays!!
Title: RE: Happy Holidays!! Walt occasionally gets in touch with his feminine side so you can count him. :-) -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 7:04 AM To: Multiple recipients of list ORACLE-L Subject: Re: Happy Holidays!! Importance: High I'm sure if Jared had time, energy or inclination, he could do a guess from the membership list. However, some names are not intuitively obvious as to gender. Not counting lurkers, since I can't tell who they are, I think there are at least 10 women on the list I'm more interested in the numbers to see if this field is less male-centric than others.
Oracle connection/listener/dispatcher stops allowing connections
Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Happy Holidays!!
from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach [EMAIL PROTECTED] wrote: Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: Happy Holidays!!
Well that is nice to hear - it is difficult to find out from names - I always thought that Cary Millsap was a female .. :) -Original Message- Sent: Friday, December 20, 2002 11:40 AM To: Multiple recipients of list ORACLE-L from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach [EMAIL PROTECTED] wrote: Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Object relational features and performance
Is this the future ??? I know one big bank where the development is object oriented and the database (DB2 UDB in this case) is used as a big flat file. The development is using java, j2ee, bea weblogic. --- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : Stefan - I believe the general consensus had emerged that usually object features aren't worth the effort. Often there are few benefits, and if you don't do it correctly you may see bad performance. Two questions: 1. Are your developers/management enamored with the concept of object, or is this just your own curiosity? 2. Is there something about your application that leads you to believe that it might derive significant benefit from the object features? For general business applications it is hard to beat the flexibility of the good old traditional relational data modeling. The lack of discussion may provide part of the answer to your question. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 6:35 AM To: Multiple recipients of list ORACLE-L Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a normal relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- 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). -- 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New course for 9i - Dumps/Crashes from Oracle University
That was my reaction after taking the classes. I was, 'gee, if I could take these again in a year I'd really get a lot more out of them'. 3 years ago I thought I was a knowledgeable DBA. Now, I have some idea of how little I know. Jay -Original Message- Sent: Monday, December 16, 2002 3:39 PM To: Multiple recipients of list ORACLE-L I took this seminar set last year for Oracle 8i. It's really very good, but only a little was able to really soak in. I'm trying to convince manglement to let us go again. I had a professor in college who's first lesson was that he - despite speaking 8 languages, having 2 or 3 doctoral degrees in languages and such, and having many years of teaching experience - was more ignorant than we students. His lesson was The more you know, the more you know you don't know. I am now more ignorant of Oracle than I was a year ago, and I think I could learn more this time. So far, it's not flying, but I haven't given up! Cheers, Mike -Original Message- Sent: Monday, December 16, 2002 12:04 PM To: Multiple recipients of list ORACLE-L Oracle Corporation is conducting these 3 highly technical seminars. Each one of them is a full day class at a cost of $500 per class. http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12 856GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12 858GC10 http://education.oracle.com/web_prod-plq-dad/plsql/show_desc.redirect?dc=D12 860GC10 -Original Message- Sent: Monday, December 16, 2002 12:05 PM To: Multiple recipients of list ORACLE-L There will probably be others in the series... Looks like one of the 8i Internals seminars has made it to 9i! Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Monday, December 16, 2002 11:54 AM To: Multiple recipients of list ORACLE-L What is the world coming to? -Original Message- Sent: Friday, December 13, 2002 5:44 PM To: Multiple recipients of list ORACLE-L hmmm ... http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10 http://education.oracle.com/web_prod-plq-dad/plsql/cdesc?dc=D12856GC10p_or g_id=1001lang=US p_org_id=1001lang=US Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Logitech Give Away
Title: OT: Logitech Give Away Just to let everybody know to try and visit www.logitech.com They are giving away 20,000 mice and keyboards today Hopefully it'll make somebody's holiday's Merry Christmas David Hill Oracle DBA Le Chateau
RE: 8i OCP DBA Exams
Not to mention 10i is coming out soon. Too fast man. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
top waits
Hi Statspack report shows Single-task message wait is highfollowing wait. Top Wait Events ~ Wait % Total Event Waits Time (cs) Wt Time - --- single-task message 125,876 134,869 49.88 db file scattered read1,569,766 57,201 21.16 log file sync 9,082 51,477 19.04 control file parallel write 2,314 11,2494.16 Let me know how to fix single-task message. Thx -Seema _ Add photos to your e-mail with MSN 8. Get 3 months FREE*. http://join.msn.com/?page=features/featuredemailxAPID=42PS=47575PI=7324DI=7474SU= http://www.hotmail.msn.com/cgi-bin/getmsgHL=1216hotmailtaglines_addphotos_3mf -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN, recatalog backup set
it is an ex-catalog, it's pushing up the bleeding daisies --- Stephen Lee [EMAIL PROTECTED] wrote: When you are not using a catalog database, the control file is your only catalog. If you destroy all copies of it, then you have destroyed your catalog. It's gone. It is a late catalog. It is no more. (I wish I could remember the Monty Python dead parrot bit.) That's why you must backup the control file at the end of the rman backup -- a REAL backup of the file itself, not a to trace backup. -Original Message- Sent: Friday, December 20, 2002 4:49 AM To: Multiple recipients of list ORACLE-L Hi! RMAN 8.1.7, nocatalog option I have two backup sets, placed on disk. Those backup sets contain archived logs. How do I register those sets (and arch. logs they contain) in new controlfile? New controlfile is created by alter database backup controlfile to trace script. So, RMAN info is nonexistant. Thanks, Vladimir Barac __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: RMAN datafile allocation to channels
Here the the answer to my own question. This is the response from Oracle support about how datafiles are allocated to channels. The manual approach means explicitly specifying which datafiles go with which channels. I need to look at this further, because what happens when you add a datafile and forget to add it to the RMAN script. It should still get backed up, because it's a full backup. Keith You are right. Datafiles are assigned randomly to channels when backup database and you cannot predict the way they are assigned. So, as you have stated, the only way is manual approach which you already know. The same algorithm is used in most recent releases. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 16, 2002 1:49 PM My condolences on 8.0.5, you should patch to 8.0.5.1 for better a much better rman. I think that every channel is used for each datafile. When one datafile has been completely backed up the channels are used for the next. This is empiracal thought, what I have observed. I have 2 channels going to one disk. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, December 15, 2002 1:38 PM Does anyone know how RMAN decides which data files get backed up by which channels. I'm backing up to disk and have 4 channels, each to a separate disk drive. The data files seem to get assigned to channels at random. Also, this is a version 8.0.5 database (U). Keith -- -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If the reader of this message is not the intended recipient, you are hereby notified that your access is unauthorized, and any review, dissemination, distribution or copying of this message including any attachments is strictly prohibited. If you are not the intended recipient, please contact the sender and delete the material from any computer.
RE: Oracle connection/listener/dispatcher stops allowing connecti
Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix nice value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Happy Holidays!!
Title: RE: Happy Holidays!! At this point of the discussion I'd just like to come out of the closet and let everyone know that I am, indeed, 100% male. Thanks, --Walt Weaver Bozeman, Montana -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:35 AM To: Multiple recipients of list ORACLE-L Subject: Re: Happy Holidays!! Rachel, I suspect that there are many more than ten female subscribers to the list. However, I'd have to agree that there are at least a dozen women who post somewhat regularly. Going to our local Oracle User's Group meeting, there are about 25% women in attendance at the meeting when I look over the crowd. I'm seeing a lot more young women at the meetings lately. Cherie Machler Oracle DBA Gelco Information Network Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.com Subject: Re: Happy Holidays!! Sent by: [EMAIL PROTECTED] om 12/20/02 08:04 AM Please respond to ORACLE-L I'm sure if Jared had time, energy or inclination, he could do a guess from the membership list. However, some names are not intuitively obvious as to gender. Not counting lurkers, since I can't tell who they are, I think there are at least 10 women on the list I'm more interested in the numbers to see if this field is less male-centric than others. --- Panicker, Thankam S. [EMAIL PROTECTED] wrote: Thanks to all for responding to my post on Oracle and Peoplesoft. I will be making the move this New Year. I wish I had found out about this List earlier. It is great to see people sharing their knowledge. Happy Holidays to every one!! Rachael, I have all my shopping done and gifts packed. :-) Wish we had a count of our kind on the list.(You know - orawoman kind.) Sumathy -Original Message- Sent: Thursday, December 19, 2002 11:35 AM To: Multiple recipients of list ORACLE-L I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata. As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access. :-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tufts To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .edu cc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45 AM Please respond to ORACLE-L Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ:
Locally-managed temp tablespace question
Oracle 8173 on Solaris 2.8: bash-2.03$ pwd /oracle/u02/oradata/YPD bash-2.03$ df -k|grep /oracle/u02 /dev/dsk/c1t2d0s070592505 45549803 2292492767%/oracle/u02 bash-2.03$ ls -l templmt* -rw-r- 1 oracle oinstall 2097160192 Dec 19 20:40 templmt01.dbf -rw-r- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt02.dbf -rw-r- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt03.dbf -rw-r- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt04.dbf -rw-r- 1 oracle oinstall 2097160192 Dec 19 20:27 templmt05.dbf bash-2.03$ rm templmt* bash-2.03$ df -k|grep /oracle/u02 /dev/dsk/c1t2d0s070592505 44244651 2423007965%/oracle/u02 I thought I should get 10GB (2097160192 x 5) back, but instead I got only 1.3MB ( 24230079 - 22924927) released. Could someone explain? BTW, when I created the temp files (templmt0[1-5]) for locally-managed temp tablespace, I found they were created extremely fast, so I suspected that not real disk space were allocated. But the ls -l command still showed 10GB were allocated. TIA. Guang Mei [EMAIL PROTECTED] http://www.geocities.com/guangmei/ _ STOP MORE SPAM with the new MSN 8 and get 3 months FREE*. http://join.msn.com/?page=features/junkmailxAPID=42PS=47575PI=7324DI=7474SU= http://www.hotmail.msn.com/cgi-bin/getmsgHL=1216hotmailtaglines_stopmorespam_3mf -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Happy Holidays!!
Happy holidays to all! Working for a large manufacturing company in the past, I got in the habit of taking the week between Christmas and New Years off. Since I work mostly in development databases I've been able to cultivate that habit. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Portal resources
Oracle 9iAS R2 is massive, overly complex, a royal pain to install configure and riddled with BUGS. For example, on Solaris the Reports Server will NOT print a report directly to a printer after a new installation. I have an open bug with Oracle where I created a simple script which conatined 8 lines. The 1st 7 lines I started the rwclient utility in background. The 8th command line also invoked rwclient in the foreground. All commands were generating the same report with the results going to 8 different files. The Reports Server only ALWAYS creates only ONE file there is/was NO way to predict exactly which filename it would be. My advice is that if you have a choice; stay far, far away from 9iAS R2. Ron Rogers RROGERS@galotterTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] y.org cc: Sent by: Subject: Re: Oracle Portal resources [EMAIL PROTECTED] 12/20/2002 07:20 AM Please respond to ORACLE-L Patrice, Happy Holidays. What is the system you installed 9iAS on and what are the minimum system requirements you were able to get it working with? I am thinking of trying to load it on Linux RedHat 7.2 with 512 Meg ram but if I remember correctly the minimum requirements were for more ram and I don't have an extra chip right now. Maybe after we migrate from out Dell 6300 server with 1 GIG ram I can install Linux and 9iAS as a play station. From what I remember from the dog and pony shows, you can make it look like any other web site. It's all in how creative you choose to be. Ron [EMAIL PROTECTED] 12/20/02 08:54AM I was wondering if there are any resources on the 'net to help people customize Oracle Portal. I went to the OTN portal center and http://portal.oracle.com http://portal.oracle.com etc., but not sure where to look. Is it possible to configure Oracle Portal in such a way that it is hard to tell that it is in fact Oracle Portal? I am wondering how much of its look and feel is set in stone, and how much customization is possible. This is not critical, I am just experimenting. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail
RE: Undelete Record
Yes, I am aware of this hard limit (and how smon_scn_time table is maintained by Oracle ;) FBQ has its limitations. And it has some benefits. For an accidental mess up that is realized soon enough, FBQ may help. - Kirti -Original Message- Sent: Friday, December 20, 2002 10:55 AM To: Multiple recipients of list ORACLE-L You can't depend on Flashback query for recovery. Even if the undo entries are not overwritten, there is a hard limit of retention. The maximum retention period is 5 days. Actually, the data could be retained for longer, but the SCN - Time map that allows for flashing back has a 5 day limit. -Original Message- Sent: Friday, December 20, 2002 8:35 AM To: Multiple recipients of list ORACLE-L and if they caught the problem within the retention time and if there wasn't a lot of activity that would cause Oracle to overwrite the undo segment anyway... and and and while I like the idea of flashback query, I'd hate to depend on it for data recovery. --- Deshpande, Kirti [EMAIL PROTECTED] wrote: If it is Oracle9i and AUM is in use and UNDO_RETENTION is set up properly, then flashback query can be the answer... - Kirti -Original Message- Sent: Friday, December 20, 2002 5:04 AM To: Multiple recipients of list ORACLE-L the audit table works well, I've used it before and am implementing it now (after the fact, the code base updated orders incorrectly, I was told we don't want audit tables beforehand, now they are desperate) be careful with logminer, it's not intuitively obvious which statement is the one you want to recover and, if you do a lot of data refresh (we do a daily truncate and reload of a catalog schema) can give you LOTS of records to go through -- in our case, 11 million records in two days of logs --- Robson, Peter [EMAIL PROTECTED] wrote: Hi Listers, I have little problem : Hmmm, that may not be a little problem at all how to undelete record that we've delete and commit so I can restore again in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Happy Holidays!!
Some people have all the luck!! Enjoy Dick Goulet Reply Separator Author: Thomas Day [EMAIL PROTECTED] Date: 12/20/2002 8:09 AM Happy holidays to all! Working for a large manufacturing company in the past, I got in the habit of taking the week between Christmas and New Years off. Since I work mostly in development databases I've been able to cultivate that habit. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Object relational features and performance
You have a need for them? Or just want to try them out? Oracle pretty much admits (at least according to the presenter at a conference I attended) that few customers use this facility. However, the object relational stuff is a core componet of things like XML DB. Glenn On Fri, 2002-12-20 at 07:34, Stefan Jahnke wrote: Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a normal relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Glenn Stauffer [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Glenn Stauffer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Row cache locks on INSERTs with a sequence
Title: Row cache locks on INSERTs with a sequence You are waitingon locks for the dictionary cache dc_sequences (cache id = 13). Increasing how many sequences are cached may nothelp.If sequence cachingwere the problem, you would seenwaits for latch free event (for sequence cache). Increasing shared pool size may help. - Kirti -Original Message-From: Thomas Jeff [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 8:45 AMTo: Multiple recipients of list ORACLE-LSubject: Row cache locks on INSERTs with a sequence We are continually seeing sessions hanging on row cache locks, which in turn appear to be on dc_segments: SID EVENT P1TEXT P1 P2TEXT P2 P3TEXT P3 - - -- -- -- - 29 row cache lock cache id 13 mode 0 request 5 105 row cache lock cache id 13 mode 0 request 5 The offending SQL statement is an INSERT of the following form: INSERT INTO TABLE (A,B,C,D...) VALUES (:b1, :b2, :b3, SEQUENCE.NEXTVAL,..) The sequence in question has it's cache value set to the default of 20. The developers keep insisting that it's a shared pool issue. I've researched Metalink and not come up with a whole lot. I've ran statspack and it has rendered advice with respect to the fact that a lot of new sequence values are being acquired, therefore the sequence cache size needs examination. But it is necessarily the small cache size of a sequence that can cause these locking issues? Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba Select 'Indy DBA' then 'DBA Web Pages'
Re:RE: Object relational features and performance
I've not been to that place but one colleague (ex-job) describe it this way : The developpers only know the objects, they're not aware of the tables. All the locking and relation between the objects is done at the application server level. The application server generates the sql to read/write the tables. So for them a database or a a file, they do not care. I have to start reading about objects, j2ee, xml, uml, java, ... and I thought I would have time to go snowboarding during the Christmas time ;-) --- [EMAIL PROTECTED] a écrit : Just because the development tools are object orientated does not mean that the database has to be as well. Dick Goulet Reply Separator Subject:RE: Object relational features and performance Author: =?iso-8859-1?q?Stephane=20Paquette?= [EMAIL PROTECTED] Date: 12/20/2002 9:04 AM Is this the future ??? I know one big bank where the development is object oriented and the database (DB2 UDB in this case) is used as a big flat file. The development is using java, j2ee, bea weblogic. --- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : Stefan - I believe the general consensus had emerged that usually object features aren't worth the effort. Often there are few benefits, and if you don't do it correctly you may see bad performance. Two questions: 1. Are your developers/management enamored with the concept of object, or is this just your own curiosity? 2. Is there something about your application that leads you to believe that it might derive significant benefit from the object features? For general business applications it is hard to beat the flexibility of the good old traditional relational data modeling. The lack of discussion may provide part of the answer to your question. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 6:35 AM To: Multiple recipients of list ORACLE-L Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a normal relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- 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). -- 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).
RE: Re:RE: Deadlock
Jonathan, Thanks for the explanation. I've always addressed deadlocks as a row-level issue, but now I see how it can also be a block-level issue. What a way to start the holidays, with new knowledge (and some tests to run!). Dan Fink -Original Message- Sent: Friday, December 20, 2002 10:10 AM To: Multiple recipients of list ORACLE-L Set maxtrans to 2 on a table. Insert three rows into the same block and commit. Use three sessions to update one row each. The third transaction has to wait for one of the other two transactions to commit, as there are insufficient ITL (interested transaction list) entries for three concurrent transactions on the same block. Now repeat the experiment with: rows A1, B1, C1 in block 1 rows A2, B2, C2 in block 2. Session X updates row A1 and A2, Session Y updates row B1 Session Z updates row C2 Session Y tries to update row B2 and waits because the ITL is full Session Z tries to update row C1 and waits because the ITL is full With a little luck, Y will be waiting for Z and Z will be waiting for Y (i.e. DEADLOCK) but you may have to fiddle with a more complex example, as both X and Y might end up waiting for A. It's easier to do this in 8.1 because MAXTRANS can be set to 1, so you need only use two sessions and two rows per block. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 20 December 2002 16:56 Jonathan, What do you mean by ITL starvation? And how would it result in a deadlock? Dan Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Logitech Give Away
Title: OT: Logitech Give Away too late! I read the rules. they were giving away 62 units in NY State. -Original Message-From: david hill [mailto:[EMAIL PROTECTED]]Sent: Friday, December 20, 2002 12:44 PMTo: Multiple recipients of list ORACLE-LSubject: OT: Logitech Give Away Just to let everybody know to try and visit www.logitech.com They are giving away 20,000 mice and keyboards today Hopefully it'll make somebody's holiday's Merry Christmas David Hill Oracle DBA Le Chateau
RE: Oracle connection/listener/dispatcher stops allowing connecti
The reason I ask is because people around me always blame Oracle when things stop working. Anyways, the problem was traced to a corrupted Oracle database (as to whether the tables or the data file got corrupted. how and why - a $$$ consultant is trying to find out). How could an Oracle database get corruppted in the first place? Anyone here with an experience of their Oracle database getting corrupted and what caused it and what was done to fix it? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon I would look at the wait statistics to see what is happening inside Oracle. I would also look at the O.S. performance statistics to see what is happening underneath Oracle. Don't make any rash assumptions. Also, are any error messages or trace files generated? For me the funny story was a misunderstanding of the Unix nice value for an unfamiliar platform. Long story short, we wound up with batch running at a higher priority than interactive users. New users were shut out. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 9:45 AM To: Multiple recipients of list ORACLE-L connections Hello, Just in time for the Holidays. Oracle stops accepting connections. I am wondering if people here can give me their horror stories when Oracle stops accepting new connections or stops accepting connections altogether? Scalability problems when you've got around 5,000 concurrent connections? MTS/Shared server configurations enabled or disabled? It could be an Oracle problem or the application that's trying to connect's fault. Any tips and insights into what caused your horror story and how it was fixed. Thanks. Have a Happy Holidays everybody. -- Lyndon Tiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays!!
Is Jared sure? I surprised Gaja when I met him in person at the 2000 IOUG Live! ;) -- ? -Original Message- Sent: Friday, December 20, 2002 10:40 AM To: Multiple recipients of list ORACLE-L from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Object relational features and performance
Just because the development tools are object orientated does not mean that the database has to be as well. Dick Goulet Reply Separator Author: =?iso-8859-1?q?Stephane=20Paquette?= [EMAIL PROTECTED] Date: 12/20/2002 9:04 AM Is this the future ??? I know one big bank where the development is object oriented and the database (DB2 UDB in this case) is used as a big flat file. The development is using java, j2ee, bea weblogic. --- DENNIS WILLIAMS [EMAIL PROTECTED] a écrit : Stefan - I believe the general consensus had emerged that usually object features aren't worth the effort. Often there are few benefits, and if you don't do it correctly you may see bad performance. Two questions: 1. Are your developers/management enamored with the concept of object, or is this just your own curiosity? 2. Is there something about your application that leads you to believe that it might derive significant benefit from the object features? For general business applications it is hard to beat the flexibility of the good old traditional relational data modeling. The lack of discussion may provide part of the answer to your question. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 20, 2002 6:35 AM To: Multiple recipients of list ORACLE-L Hi everybody I'm not quite sure wether this has been discussed in deep before, but I couldn't find anything satisfieing (hope the spelling is correct ;)) things in the archive. Anyway: Due to my lack of experience with any real life scenarios with Oracle's object relational features, I never tried to recommend the usage of these and always kept to a normal relational approach. Does anybody have any experience with Types / Nested Tables and the like in a (preferrably big) production system of any kind ? What's recommendable, where are the pitfalls ? Any input deeply appreciated, TIA, Stefan -- 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). -- 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Object relational features and performance
Title: RE: Object relational features and performance From: Stephane Paquette [mailto:[EMAIL PROTECTED]] Is this the future ??? I know one big bank where the development is object oriented and the database (DB2 UDB in this case) is used as a big flat file. The development is using java, j2ee, bea weblogic. Here's another thought. Take a strong look at the J2EE architecture. The concept of Entity Beans + Session Facade pattern is a strong means of maintaining the 2 important concepts of OO and relational data. For quite a while I worked to develop a strong abstraction layer to maintain normalized data in the db, but give the Java developers a true OO API. Now with Entity Beans and intelligent design elements I've got the best of both worlds. Transactional data is most effeciently stored in most cases in normalized form. The issue is to not force OO developers to make the leap in their code. Entity Beans are not strictly OO (since you must reference them by a PK), but are close enough to meet the needs of at least 90% of the enterprise development projects, IMHO. If the data access is minimal, I suppose the above solution would be fine. I'd hate to try to roll out an app with a significant amount of transactions with that structure, though.
RE: Faking an ORA-600
Thanks for the replies. I was able to test sucessfully. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -Original Message- Sent: Thursday, December 19, 2002 2:52 PM To: Multiple recipients of list ORACLE-L We are trying to test out monitoring software (on a test database at 8.1.6.3). We have been able to generate most of the errors that we want to monitor for, but have been unable to generate an ORA-600. Does anyone have a way of doing this? TIA. Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1800 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays!!
Title: RE: Happy Holidays!! No offense guys, but having only small boy children (whom I love dearly), working in a 90% male IT support organization (cause I like men) - can't help feeling like what I really need now is some good woman friends - preferably ones that both work and are raising children. Are any of them going to IOUG? -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 11:40 AM To: Multiple recipients of list ORACLE-L Subject: Re: Happy Holidays!! from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach [EMAIL PROTECTED] wrote: Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.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: 8i OCP DBA Exams
They are trying to catch up with Sybase. Larry feels bad about falling behind. -Original Message- Not to mention 10i is coming out soon. Too fast man. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: password
Title: RE: password why isn't there a program available that can reverse engineer the code used to encrypt passwords... if username XYZ always has password (encrypted) CBA, you think that it would be easy to figure out the pattern... once you have the pattern it's easy to go back and forth with the password and the encrypted password. -Original Message- From: Bill Buchan [mailto:[EMAIL PROTECTED]] Sent: Friday, December 20, 2002 8:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: password Yes, this is the intended behaviour (although I can't find where it actually documented). Passwords are stored using a one-way encryption and this encrypted form applies to all Oracle platforms. It is used, for example, during export/import of full dumps where the users are created on the new (import) database with the same password they had on the old (export) database simply by copying the encrypted form. This must be cross-platform/version, and exp/imp is cross-platform/version. You can do the same thing as exp/imp does by: CREATE USER user IDENTIFIED BY VALUES encrypted form eg CREATE USER TEST IDENTIFIED BY VALUES '7A0F2B316C212D67'; Note, though that the encrypted form of the password is dependent on the username for which it applies, so you cannot use this to set the same password for a differently named user. - Bill. At 06:14 20/12/2002 -0800, you wrote: Same on linux 7.2 Oracle 8.1.7 rel 3 Ron [EMAIL PROTECTED] 12/20/02 04:07AM BOB, its the same on my machine... 8.1.6 on NT -Venu -Original Message- HREF="">mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 3:56 AM To: Multiple recipients of list ORACLE-L created a user test identified by test on 2 separate systems in db's with different names The password value was the same Can someone verify if it is the same on their system Create user test identified by test; select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 -Original Message- on my db LTRACK1 SQL select password from dba_users where username = 'TEST'; PASSWORD -- 7A0F2B316C212D67 bob -- 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). -- Intasys Billing Technologies Ltd. www.intasysbilling.com 74 Commercial Street, Commercial Quay, Leith, Edinburgh EH6 6LX tel (0)131 625 8200 fax (0)131 625 8201 email [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bill Buchan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).