Re: Oracle vs Mysql
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 4:04 AM Hi, I've been asked by management to explore the pros and cons of Mysql vs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb. Can someone let me know the advantages of Oracle over Mysql or the problems we can face using Mysql for example support issues or availability/performance issues. Thanks in advance Mujeeb Ask your damagement if they are ready to give up on Microslop Office in favour of OpenOffice. If the reply is yes, then come back and we'll talk again. If the reply is no, ask for the reasons and use PRECISELY the same to argue in favour of Oracle. Don't even bother with MySQL. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reset sequence at midnight
Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February 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] Sent: Wednesday, January 14, 2004 7:09 PM Interesting, I've actually had to do this before. Be forewarned that this is not a good method to use for a very busy app, as it does introduce some level of serialization. control access to the sequence through a package Within the package use a function that sets a lock via dbms_lock.request and then immediately release the lock. Did you request the lock in share mode to request next val ? This would help to reduce the contention. Normal users would then only queue on the exclusive lock that you would take for the fix-up. lock(shared) increment sequence release The purpose of this will become clear in a moment. Create a procedure within the package that will be used to reset the sequence to 0. It is not necessary to drop the sequence to do this. eg. drop sequence s; create sequence s start with 100; select s.nextval from dual; declare vs integer; inc integer; junk integer; begin lock(exclusive) select s.nextval into vs from dual; inc := 0 - vs; execute immediate 'alter sequence s minvalue ' || inc; execute immediate 'alter sequence s increment by '||inc; select s.nextval into junk from dual; execute immediate 'alter sequence s increment by 1'; release() end; / select s.nextval from dual; The procedure that does this just needs to take the same dbms_lock.request that the function mentioned earlier takes. The difference is that it does not release the lock until the modification of the sequence is completed. This forces any requests for new sequence numbers to wait for the modification to the sequence to complete. Jared -- 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: Veritas Backup Question
Teresita Castro wrote: Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He has been working with *Veritas NetBackup 4.5 for Windows* for three moths with out results. We still can not make a backup of our data bases. Hello, Did you use RMAN to backup your database ? If yes, did you use RMAN with recovery catalog or in nocatalog mode ? Did you install Veritas NetBackup Agent for Oracle ? regards, Marcin Przepio'rowski Senior Oracle DBA www.oracledba.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-7?Q?Marcin_Przepio=27rowski?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Process consumes CPU and long time to finished
Hi all, I have process in Oracle apps 11.5.8 which need very lot CPUs and long time to complete. for about 17,000 invoices it takes 28 hours !! I have open TAR since month ago, and still get no solution. maybe here someone can share any idea ? im using 11.5.8, sparc. DB 9i rel2 here is from the tkprof : SELECT sum(nvl(entered_cr,0) - nvl(entered_dr,0)) , sum(nvl(accounted_cr,0) - nvl(accounted_dr,0)) FROM AP_AE_Lines AEL, AP_AE_Headers AEH, AP_Invoice_Payments AIP WHERE AIP.Invoice_ID = :b2 ANDAEL.Source_ID = AIP.Invoice_Payment_ID ANDAEL.Source_Table = 'AP_INVOICE_PAYMENTS' ANDAEL.AE_Line_type_code = 'LIABILITY' ANDAEL.AE_Header_ID = AEH.AE_Header_ID ANDAEH.Set_of_Books_ID = :b1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1539 0.23 0.31 0 0 0 0 Fetch 1539 16474.95 21810.67 24 46864854 0 1538 --- -- -- -- -- -- -- total 3079 16475.18 21810.99 24 46864854 0 1538 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 24 (recursive depth: 1) tq -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: hernawan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAC on Win2K using RMAN to Create Standby
jwiegand wrote: Good Day. Has anyone succeeded in this and care to share? I've tried sharing out the directory containing the Oracle backup, tried setting the Oracle services to run under a Windows domain user, but continue to get failures. Hello, Oracle on Windows don't support network drives. You may copy backup file from one server to other manualny, and then create standby database from backup. regards, Marcin Przpiórowski Senior Oracle DBA www.oracledba.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Partitioning question (duplicate?)
that's what I get for not testing but just reading the manual :) remind me not to answer questions when I don't have a database handy. sounds like Dan's going to have to add a column. --- Kirtikumar Deshpande [EMAIL PROTECTED] wrote: Rahcel, Dan: I played with such things a long time ago Here's the text for ORA-14120 error that I used to get: 14120, 0, incompletely specified partition bound for a DATE column // *Cause: An attempt was made to use a date expression whose format // does not fully (i.e. day, month, and year (including century)) // specify a date as a partition bound for a DATE column. // The format may have been specified explicitly (using // TO_DATE() function) or implicitly (NLS_DATE_FORMAT). // *Action: Ensure that date format used in a partition bound for a // DATE column supports complete specification of a date // (i.e. day, month, and year (including century)). // If NLS_DATE_FORMAT does not support complete // (i.e. including the century) specification of the year, // use TO_DATE() (e.g. TO_DATE('01-01-1999', 'MM-DD-') // to fully express the desired date. And here is what I just tested to make sure it has (DATE in range partitions) not changed in 9.2.0.4 (AIX 4.3.3): kirti @dbmt : SQL l 1 CREATE TABLE Orders 2(order_id NUMBER, 3 order_dt DATE, 4 cust_id NUMBER) 5 PARTITION BY RANGE(order_dt) 6 (PARTITION JanOrd VALUES LESS THAN 7 (TO_DATE('02','MM')), 8PARTITION FebOrd VALUES LESS THAN 9 (TO_DATE('03','MM')), 10PARTITION MarOrd VALUES LESS THAN 11* (TO_DATE('04','MM'))) kirti @dbmp : SQL / (TO_DATE('02','MM')), * ERROR at line 7: ORA-14120: incompletely specified partition bound for a DATE column kirti @dbmp : SQL If anyone has any tricks to get around this issue, I would love to hear. Cheers! - Kirti --- Rachel Carmichael [EMAIL PROTECTED] wrote: First time I've seen this post. And from the fine Data Warehousing manual: here's an example of range partitioning. Note the to_date in the values clause. I don't see why you couldn't use to_date(date_column,'MONTH') Rachel CREATE TABLE sales (s_productid NUMBER, s_saledate DATE, s_custid NUMBER, s_totalprice NUMBER) PARTITION BY RANGE(s_saledate) (PARTITION sal99q1 VALUES LESS THAN (TO_DATE('01-APR-1999','DD-MON-')), PARTITION sal99q2 VALUES LESS THAN (TO_DATE('01-JUL-1999','DD-MON-')), PARTITION sal99q3 VALUES LESS THAN (TO_DATE('01-OCT-1999', 'DD-MON-')), PARTITION sal99q4 VALUES LESS THAN (TO_DATE('01-JAN-2000', 'DD-MON-')), PARTITION sal00q1 VALUES LESS THAN (TO_DATE('01-APR-2000', 'DD-MON-')), PARTITION sal00q2 VALUES LESS THAN (TO_DATE('01-JUL-2000', 'DD-MON-')), PARTITION sal00q3 VALUES LESS THAN (TO_DATE('01-OCT-2000', 'DD-MON-')), PARTITION sal00q4 VALUES LESS THAN (TO_DATE('01-JAN-2001', 'DD-MON-'))); --- Daniel Fink [EMAIL PROTECTED] wrote: Pardon if this is a duplicate, but the original has not shown up on the list after 3 hours... Is it possible in 9.2 to partition on a function? I have a table with a date column and I would like to partition by month, regardless of the year. For example, data from January 2003 or January 2004 would go into the same partition. Any sneaky ideas on how to accomplish this without changing the data structures. Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- 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
Re: Process consumes CPU and long time to finished
hi you write query in order of largest,larger,large table fashion and input parameter column may be indexed tlw hernawan wrote: Hi all, I have process in Oracle apps 11.5.8 which need very lot CPUs and long time to complete. for about 17,000 invoices it takes 28 hours !! I have open TAR since month ago, and still get no solution. maybe here someone can share any idea ? im using 11.5.8, sparc. DB 9i rel2 here is from the tkprof : SELECT sum(nvl(entered_cr,0) - nvl(entered_dr,0)) , sum(nvl(accounted_cr,0) - nvl(accounted_dr,0)) FROM AP_AE_Lines AEL, AP_AE_Headers AEH, AP_Invoice_Payments AIP WHERE AIP.Invoice_ID = :b2 ANDAEL.Source_ID = AIP.Invoice_Payment_ID ANDAEL.Source_Table = 'AP_INVOICE_PAYMENTS' ANDAEL.AE_Line_type_code = 'LIABILITY' ANDAEL.AE_Header_ID = AEH.AE_Header_ID ANDAEH.Set_of_Books_ID = :b1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1539 0.23 0.31 0 0 0 0 Fetch 1539 16474.95 21810.67 24 46864854 0 1538 --- -- -- -- -- -- -- total 3079 16475.18 21810.99 24 46864854 0 1538 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 24 (recursive depth: 1) tq -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: hernawan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: MIS DEPT -BAFL- INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: kill session privilege
Ideally you should filter current sid/serial# ... else you'll get error .. no? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, January 14, 2004 9:44 PM To: Multiple recipients of list ORACLE-L create procedure kill_your_session (in_sid in sys.v_$session.sid%type, in_serial# in sys.v_$session.serial#%type) as row_count pls_integer ; begin select count (*) into row_count from v$session where username = user and sid = in_sid and serial# = in_serial# ; if row_count 0 then execute immediate 'alter system kill session ''' || to_char (in_sid) || ', ' || to_char (in_serial#) || ; end if ; end ; / -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Veritas Backup Question
I am from the old school, doesn't use RMAN, but soon will w/ our 9i upgrades. I recommend to use RMAN if you are starting out and buy this book. http://www.bookpool.com/.x/dt3bpjmwz1/sm/0072226625 hth, Gene [EMAIL PROTECTED] 01/15/04 03:14AM Teresita Castro wrote: Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He has been working with *Veritas NetBackup 4.5 for Windows* for three moths with out results. We still can not make a backup of our data bases.Hello,Did you use RMAN to backup your database ?If yes, did you use RMAN with recovery catalog or in nocatalog mode ?Did you install Veritas NetBackup Agent for Oracle ?regards,Marcin Przepio'rowskiSenior Oracle DBAwww.oracledba.pl-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: =?ISO-8859-7?Q?Marcin_Przepio=27rowski?= INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Veritas Backup Question
To do incremental backups of Oracle databases via NetBackup you need to purchase the Veritas Agent for Oracle, which is an add-on to the NetBackup client. Veritas charges for this component, per server. You have to hand over more money to Veritas. This may not be an option at your site. Without the Veritas Agent for Oracle as far as I know you cannot use RMAN with NetBackup (hopefully can prove me wrong so I can start using RMAN too). Without the Veritas Agent for Oracle, you are forced to use Oracle 7.3 methods to back up your database. 1) Don't Want Database To Be Down Because People Log In or Jobs Need To Run. Hot backups -- using scripts, put each tablespace in backup mode, then trigger NetBackup to back up that tablespace's datafile(s). Put the tablespace back online. Do all the tablespaces, one after the other. The database will remain available while the tablespace is offline, Oracle logs changes during that time and applies them in a hurry once the tablespace is back online. The less workload at night the better. 2) I Don't Care If My Database Is Down At Night -- I Won't Lose Any Sleep. Cold Backups -- shutdown abort, startup restrict, shutdown immediate. Tell NetBackup (using a script) to back up your datafiles. Once done, the script should restart the Oracle database (On Windows, net start OracleServiceXXX will usually work, but you may want to use a cript to log in as / as DBA or as internal, and issue a startup statement from within -- Windows memory allocation is slow enough that I have seen databases not completely come up by themselves). There are tech notes in Metalink on how to do this on UNIX and on Windows. I haven't tried, but if you use the OEM (Oracle Enterprise Manager) it may be possible to issue these commands via OEM jobs. I haven't tested that on any platform, I would definitely test rigorously against the Windows platform. I have noticed that sometimes on Windows the networking side of it clogs up if the demand is too high. To schedule jobs on the Windows platform I use an old freeware utility called Crontab for Windows. It was developed for NT Server 4 but it works on Windows2000. I like it because you can, in one line, tell a script to run every 5 minutes, Mon - Fri, 7AM - 5PM. You can't do that with AT or WinAT (GUI version of AT). There may be freeware utilities on the 'net equivalent to crontab for windows. Scripting is a pain in Windows, because Windows assumes there is always someone sitting there at the console clicking on buttons etc. If you have an old DOS 6 Commands book you're half way there. grin I also noticed that the MCSEs who know how or are willing to write command line scripts for Windows servers are rare. If you find one grab him/her and don't let go. Patrice. -Original Message- Sent: January 14, 2004 11:09 PM To: Multiple recipients of list ORACLE-L OK, Teresita, what is your question? Do you have MLM? Did you put the database in the backup mode? Did you save archives? How about the control files? Did you backup control files? I doubt that this forum is an appropriate place for a backup recovery course, but it seems that you have a good incentive to learn. First advice is to try to restore database and see whether you can actually recover. If you can, well, you're a pro. If you can't get backup and recovery book, one of Rama Velpuri's, if possible. My favorite is V7 book, because it's not too thick, it's very clear and well written and I like the color of copper. The most important thing about backup and recovery is never to allow yourself to run out of coffee. On 2004.01.14 21:14, Teresita Castro wrote: Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He has been working with Veritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my boss make me work with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thru Saturday make another incremental backup, but this one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 34567 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help
What is hash join?
Dear all, I understand join is for joining two tables, I know nested loops and sort-merge joins and I know how they work and on what situation theyre used best at. But I really dont understand hash join, how are they working to join tables and on what situation they performed best? And based on what does Oracle use hash join for joining tables in the execution plan? If they use hash value, how does Oracle determine the hash value when performing hash join? I really in the dark here, please give me some light , Thank you all in advance. Regards, Wendry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Application Server Caching
Obviously. The issue has been whether or not Oracle's data caching worked well - and was read for prime-time in earlier versions. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of RyanSent: Wednesday, January 14, 2004 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: Application Server Caching I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have any of you worked with this? What are your opinions? His opinion was that people go back to the database to ask the same question way too often and cause a botteneck, if you can cache these frequently asked questions at the front end, it will significantly scale better.
Who is Melanie Craft?
Melanie Craft is a romance novelist andthe fourth woman to be known as Mrs. Larry Ellison. This is from an article is today's WSJ print edition page B4. Mrs. Ellison also has a web site although I don't know the address. Mrs. Ellison is 34 years old and Larry is 59. My $0.02 worth, Ken Janusz, CPIM
Re: What is hash join?
read the docs. otn.oracle.com click on search. do a search for hash join. The docs are very good. read them. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 8:34 AM Dear all, I understand join is for joining two tables, I know nested loops and sort-merge joins and I know how they work and on what situation they're used best at. But I really don't understand hash join, how are they working to join tables and on what situation they performed best? And based on what does Oracle use hash join for joining tables in the execution plan? If they use hash value, how does Oracle determine the hash value when performing hash join? I really in the dark here, please give me some light., Thank you all in advance. Regards, Wendry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wendry INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 vs Mysql
On 01/14/2004 04:49:52 PM, Jesse, Rich wrote: Expect to pay about the same for PostgreSQL support as you would for Oracle. 15% of the purchase price/year? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
powerbuilder in rbo and multiple constraint question...
I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? ..and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? .when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. ..after possibly putting my foot in my mouth I'm looking to validate what I said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
advice
List, I have to be involved in a conference call this afternoon concerning a client. They want advice on how to tune their Oracle database. It is a claims/transaction processing system. It is 8i on Sun 8. The dba on their system has only 6 months experience and no training. What advice can I give them? They need a baseline to build from. I will suggest statspack, tuning scripts, and run these over time. What else can I suggest to help them collect data that will be informative? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 OTN account
Hi all, Do you have any idea that how I can change my email adress in OTN account profile ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: advice
Hi , I think that their dba should be adviced with following link. http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a76992/toc.htm Rgds. Arslan. -Original Message- Sent: Thursday, January 15, 2004 3:59 PM To: Multiple recipients of list ORACLE-L List, I have to be involved in a conference call this afternoon concerning a client. They want advice on how to tune their Oracle database. It is a claims/transaction processing system. It is 8i on Sun 8. The dba on their system has only 6 months experience and no training. What advice can I give them? They need a baseline to build from. I will suggest statspack, tuning scripts, and run these over time. What else can I suggest to help them collect data that will be informative? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: advice
-Have them run a stress test and monitor on a non-productional system with sufficient volume of data : CPU, memory, disk utilization. (show newbie as you do this) -Look at how the database was put together for maintainability - best practices, etc.. -Look at some of the SQL related to their main processes -If they have a new DBA then have them get a good monitoring tool for real-time performance diagnostics as well as the scripts that provides some actually helpful guidance - like Quest Spotlight. Introduce them to a couple of good websites like oraperf... -Suggest the hotsos class for performance issues and IOUG for a good place for a newbie to get up to speed in a shorter time without lots of traveling. -Original Message- Ehresmann, David Sent: Thursday, January 15, 2004 9:59 AM To: Multiple recipients of list ORACLE-L List, I have to be involved in a conference call this afternoon concerning a client. They want advice on how to tune their Oracle database. It is a claims/transaction processing system. It is 8i on Sun 8. The dba on their system has only 6 months experience and no training. What advice can I give them? They need a baseline to build from. I will suggest statspack, tuning scripts, and run these over time. What else can I suggest to help them collect data that will be informative? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: advice
To hire a better DBA or enlist the help of the Hotsos Corp. would be the most appropriate advice I can think of. On 01/15/2004 09:59:25 AM, Ehresmann, David wrote: List, I have to be involved in a conference call this afternoon concerning a client. They want advice on how to tune their Oracle database. It is a claims/transaction processing system. It is 8i on Sun 8. The dba on their system has only 6 months experience and no training. What advice can I give them? They need a baseline to build from. I will suggest statspack, tuning scripts, and run these over time. What else can I suggest to help them collect data that will be informative? thanks, David Ehresmann. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Strange behavior - update
Hello again, Sorry if this is the 2nd msg in a short time, but Oracle Support amazed me with their quick response this morning and I haven't seen many messages (or any from me) on the list this morning. I promised to keep you updated on this strangeness. After further testing, we have discovered that the queries returning the wrong values return the correct values when /*+rule */ is added. I don't like telling my developers that until I have a better solution, so we are still working a TAR with the folks at Oracle Support who have come up with this. UPDATE: === This appears to be related to the bugs referenced above. Bug 2700474 is fixed in the 9.2.0.4 patch set. ACTION PLAN: 1. Without the rule hint if you alter the session as listed below are the correct results returned? SQLalter session set _complex_view_merging=false ; Then execute the query without the rule hint. 2. If this returns the correct results, the parameter can be set at the database level. or 3. To obtain a bug fix, the latest patch set (9.2.0.4) can be applied. _complex_view_merging=false did not work in my test, so it looks like we have more motivation to continue working towards 9.2.0.4. Thanks for your troubleshooting help. Stephen --- Greetings fellow-DBA-folk: When I run several queries, I am getting very strange results. Selecting * from apple returns the expected data records, but count(*) does not. Selecting anything other than * from apple says no records. The subquery for pear works fine on it's own. Selecting anything other than * from apple returns the expected records when about 900+ values are placed literally in the subquery as shown in example 4 below. Am I missing something? Anyone have a direction for me to look for the cause of this? Thanks Stephen EX 1 select rowid from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum 10 ; no rows selected EX 2 select rownum from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum 10 ; no rows selected EX 3 select * from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 4 select count(*) from common.apple where appleinter1 in ( 7009 , 7010 , 7011 , 7012 , 7013 , 7014 , 7015 , 7016 , 7017 , 7018 , 7019) and appletermd is null and rownum 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 5 select count(*) from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Michael Boligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Process consumes CPU and long time to finished
sarcasm Wow, your buffer cache hit ratio for this query is better than 99.99%! With a BCHR like that, how could you possibly tune this query to be better?? /sarcasm Now, seriously, since I know nothing about your application or environment, and you do not show execution plan, I can only offer some general thoughts. Table join order should be in the order of smallest to largest number of rows being returned, based on the non-join filter predicates, as they apply to each table. So, if you have a 1 million row table joining a 10,000 row table, but there is no non-join filter predicate on the 10,000 row table, and you have a primary key lookup on the 1 million row table, then you want the 1 million row table to be the driving table. Also, make sure that index access paths are available for your filter and join predicates, where possible. Hope that helps get you pointed in the right direction, -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Thursday, January 15, 2004 4:05 AM To: Multiple recipients of list ORACLE-L Hi all, I have process in Oracle apps 11.5.8 which need very lot CPUs and long time to complete. for about 17,000 invoices it takes 28 hours !! I have open TAR since month ago, and still get no solution. maybe here someone can share any idea ? im using 11.5.8, sparc. DB 9i rel2 here is from the tkprof : SELECT sum(nvl(entered_cr,0) - nvl(entered_dr,0)) , sum(nvl(accounted_cr,0) - nvl(accounted_dr,0)) FROM AP_AE_Lines AEL, AP_AE_Headers AEH, AP_Invoice_Payments AIP WHERE AIP.Invoice_ID = :b2 ANDAEL.Source_ID = AIP.Invoice_Payment_ID ANDAEL.Source_Table = 'AP_INVOICE_PAYMENTS' ANDAEL.AE_Line_type_code = 'LIABILITY' ANDAEL.AE_Header_ID = AEH.AE_Header_ID ANDAEH.Set_of_Books_ID = :b1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1539 0.23 0.31 0 0 0 0 Fetch 1539 16474.95 21810.67 24 46864854 0 1538 --- -- -- -- -- -- -- total 3079 16475.18 21810.99 24 46864854 0 1538 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 24 (recursive depth: 1) tq -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: hernawan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Data Warehouse Vendors
Hey All, We are a small software company in the Life Sciences industry. Our consulting division is looking at subcontracting a data warehouse project. The PHBs are looking for vendors and Knightsbridge was mentioned. Before I start serious research into them, I was hoping the list could offer opinions on them. Has anyone on the list heard of them? Is anyone on this list working for or worked for Knightsbridge? Has anyone worked with them in this type of arrangement? Thanks in advance! Todd Carlson Oracle Database Administrator Tripos, Inc. (314) 951-3246 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Todd Carlson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: List problems
Jared/Bruce: Is this still being worked on? I'm not seeing a lot of volume nor anything I've sent recently. Stephen [EMAIL PROTECTED] 01/14/04 07:54AM Folks, It seems that a fair number of emails are not being retransmitted to the list. Some of mine and a few others have not appeared in list traffic sent out to subscribers. Searching by author at fatcity.com reveals that the posts made it there, but either are not being sent out, or getting shanghaied along the way. I'll let you know when I find out. I am of course, assuming that some of you will get this one... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Veritas Backup Question
You should get nightly cold backups working first as it is the easiest. Then look into setting the database to do archive logging. Right now you don't have any valid backups and if you crash and your DB fails to start you are potentially screwed. Also you should do a full database export RIGHT AWAY, right NOW!! So at least you can save your data. use the exp command at the command prompt. Run exp login as a dba follow the prompts and do an entire database export. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:15 PMTo: Multiple recipients of list ORACLE-LSubject: Veritas Backup Question Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - --- --- - -- -- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
Re: Who is Melanie Craft?
Well, at least he didn't marry Lara Croft. That would do him in faster then Bill Gates. On 01/15/2004 09:19:26 AM, KENNETH JANUSZ wrote: Melanie Craft is a romance novelist and the fourth woman to be known as Mrs. Larry Ellison. This is from an article is today's WSJ print edition page B4. Mrs. Ellison also has a web site although I don't know the address. Mrs. Ellison is 34 years old and Larry is 59. My $0.02 worth, Ken Janusz, CPIM -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle OTN account
Make a new account with a different username. They funny like that...I think I have about three of four old OTN accounts... Brad -Original Message- [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 9:24 AM To: Multiple recipients of list ORACLE-L Hi all, Do you have any idea that how I can change my email adress in OTN account profile ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: Who is Melanie Craft?
I have just done an Amazon search, I guess that Melanie Craft's book 'A Hard-Hearted Man (Intimate Moments, No 870)' will bring some terrific change to my usual reading list. Although one of her other masterpieces, 'Trust Me' looks terribly reminiscent of the Oracle doc, doesn't it. SF (almost time to go home) - --- Original Message --- - From: Mladen Gogala [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 15 Jan 2004 07:29:56 Well, at least he didn't marry Lara Croft. That would do him in faster then Bill Gates. On 01/15/2004 09:19:26 AM, KENNETH JANUSZ wrote: Melanie Craft is a romance novelist and the fourth woman to be known as Mrs. Larry Ellison. This is from an article is today's WSJ print edition page B4. Mrs. Ellison also has a web site although I don't know the address. Mrs. Ellison is 34 years old and Larry is 59. My $0.02 worth, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Process consumes CPU and long time to finished
Hernawan, Is this a custom or standard Concurrent request? If this is standard, there may be a patch out for your module/level. If not, I would use a 10046 level 12 to look at the issue. As you can see from tkprof, you have a huge amount of LIO... Is your init.ora parameters kosher as per Oracle 11i recommendations? DO you see the explain plan for this particular SQL? Is this slowdown new or has existed previously? Can you process a smaller set (with Start/End invoice numbers)? These are some things to try, rather than wait on Oracle Support... John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Grace - Getting something we do NOT deserve Mercy - NOT getting something we DO deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: hernawan [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 1:05 AM To: Multiple recipients of list ORACLE-L Subject: Process consumes CPU and long time to finished Hi all, I have process in Oracle apps 11.5.8 which need very lot CPUs and long time to complete. for about 17,000 invoices it takes 28 hours !! I have open TAR since month ago, and still get no solution. maybe here someone can share any idea ? im using 11.5.8, sparc. DB 9i rel2 here is from the tkprof : SELECT sum(nvl(entered_cr,0) - nvl(entered_dr,0)) , sum(nvl(accounted_cr,0) - nvl(accounted_dr,0)) FROM AP_AE_Lines AEL, AP_AE_Headers AEH, AP_Invoice_Payments AIP WHERE AIP.Invoice_ID = :b2 ANDAEL.Source_ID = AIP.Invoice_Payment_ID ANDAEL.Source_Table = 'AP_INVOICE_PAYMENTS' ANDAEL.AE_Line_type_code = 'LIABILITY' ANDAEL.AE_Header_ID = AEH.AE_Header_ID ANDAEH.Set_of_Books_ID = :b1 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1539 0.23 0.31 0 0 0 0 Fetch 1539 16474.95 21810.67 24 46864854 0 1538 --- -- -- -- -- -- -- total 3079 16475.18 21810.99 24 46864854 0 1538 Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 24 (recursive depth: 1) tq -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: hernawan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi!!
Teresita, The first thing I would do is to make sure and make full, coldbackups by shutting down the database and doing a tape backup of the disk your database files are on. This will keep you out of trouble immediately. Then, since you said you were using Oracle 9.2.0.2,set up yourbackups to go every night using RMAN, straight to the tape device. Oracle RMAN handles this. It includes a driver for Veritas. There is an excellent book on RMAN. It's called Oracle9i RMAN Backup Recovery by Robert G. Freeman and Matthew Hart. It's an Oracle Press book that you can get on amazon.com or Borders, Barnes Noble, etc. That will guide you through the process. Here is the link: http://www.amazon.com/exec/obidos/tg/detail/-/0072226625/qid=1074186675/sr=1-2/ref=sr_1_2/103-6635244-7274242?v=glances=books You can do this. Just start with protecting your data immediately with cold backups, then move on to using RMAN for full backups. Then move on to incremental backups. I hope that helps. Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 wrk 801-982-3081 mbl 801-628-6058 [EMAIL PROTECTED] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
Re: Oracle OTN account
Arslan, Per the OTN webstie.. Q: How do I change the e-mail address in my membership profile? A: OTN's membership management system does not let you change your email address in your membership profile. Please create a new account with the new email address you wish to use. Ron [EMAIL PROTECTED] 01/15/2004 10:24:26 AM Hi all, Do you have any idea that how I can change my email adress in OTN account profile ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: RAC on Win2K using RMAN to Create Standby
True, but you can use a UNC address \\machine_name\shared_dir to copy a backup file remotely. But you need to make sure that the user who fires off the copy command has write access on the shared destination directory. Julio Cesar Quijada-Reina Programmer Analyst Computer Services at Alfred State College -Original Message- Sent: Thursday, January 15, 2004 4:34 AM To: Multiple recipients of list ORACLE-L jwiegand wrote: Good Day. Has anyone succeeded in this and care to share? I've tried sharing out the directory containing the Oracle backup, tried setting the Oracle services to run under a Windows domain user, but continue to get failures. Hello, Oracle on Windows don't support network drives. You may copy backup file from one server to other manualny, and then create standby database from backup. regards, Marcin Przpiórowski Senior Oracle DBA www.oracledba.pl -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Marcin_Przepi=F3rowski?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: QuijadaReina, Julio C INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi!! Veritas Backup Question
Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Veritas Backup Question
Teresita, You've gotten some good comments...even a quick tutorial on backups. My recommendation to you (especially if you don't have any backups at all) is that until you're more familiar with the tools you have that you should initially avoid the complexities of incremental backups and immediately arrange for a regular cold (database down) backup. Minimally this should include all datafiles, control files, online redologs, and archived redologs (you didn't say whether or not you are in archivelog mode). But don't stop with these files. Check documentation CD. It will have a section on backup and recovery. Kip |Hi!! |My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just |to make queries, funtions some updates and create indexes or tables, that |all. |Now I am in a little difficult situation, here we have a DBA that do not |have much experience. He has been working with Veritas NetBackup 4.5 for |Windows for three moths with out results. We still can not make a backup of |our data bases. |The situation is that because of that my boss make me work with him in this |task, of course I don't know anything about the issue and my priority for |tomorrow is to make and investigation of how other people make their backups |with Veritas. |Our DBA explain us that it was a way that he saw in a book, first make a |complete backup of our databases on Sunday then from Monday thru Wednesday |made a incremental backup, then from Thursday thru Saturday make another |incremental backup, but this one will be done from the last incremental |backup of Wednesday to the day we are. |- |--- |--- | - | -- | -- | Complete backup |1 2 34567 |1-Monday |7- Sunday |I am really lost in this task because the person that is suppose to teach |about Veritas is really reluctant , but my boss what results. |If any one can help me telling was is the better way to do a backup using |Veritas that will be great. I also need to learn Veritas so if you have any |page or document that can help I will appreciate it. |We really need to make this work because in the last weeks we are having |troubles with our server, with out explication it gets crushes. |I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 |and |And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server |with Windows 2000 SP4 -- 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).
ora-1555 under automatic undo management
Hi all: I'm having an ora-1555 under Oracle9 database and not sure what I can do to get rid of it. I had some recollecions from Oracle8 days , but the things like adding a new rollback segment or shrinking the segments I don't think are applicable under the auto undo management. Besides separating the long queries from batch programs, is ther anything that I can do here? thanks Gene __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reset sequence at midnight
Did you request the lock in share mode to request next val ? This would help to reduce the contention. Normal users would then only queue on the exclusive lock that you would take for the fix-up. lock(shared) increment sequence release Good point. No I didn't. :( actually the sequence is lock(exclusive) release increment sequence When the maintenance is done, the sequence requestor must wait on the lock taken by the maintenance routine. Otherwise there is very little waiting on the lock, as it is released immediately. Jared Jonathan Lewis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/14/2004 11:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Reset sequence at midnight Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February 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] Sent: Wednesday, January 14, 2004 7:09 PM Interesting, I've actually had to do this before. Be forewarned that this is not a good method to use for a very busy app, as it does introduce some level of serialization. control access to the sequence through a package Within the package use a function that sets a lock via dbms_lock.request and then immediately release the lock. Did you request the lock in share mode to request next val ? This would help to reduce the contention. Normal users would then only queue on the exclusive lock that you would take for the fix-up. lock(shared) increment sequence release The purpose of this will become clear in a moment. Create a procedure within the package that will be used to reset the sequence to 0. It is not necessary to drop the sequence to do this. eg. drop sequence s; create sequence s start with 100; select s.nextval from dual; declare vs integer; inc integer; junk integer; begin lock(exclusive) select s.nextval into vs from dual; inc := 0 - vs; execute immediate 'alter sequence s minvalue ' || inc; execute immediate 'alter sequence s increment by '||inc; select s.nextval into junk from dual; execute immediate 'alter sequence s increment by 1'; release() end; / select s.nextval from dual; The procedure that does this just needs to take the same dbms_lock.request that the function mentioned earlier takes. The difference is that it does not release the lock until the modification of the sequence is completed. This forces any requests for new sequence numbers to wait for the modification to the sequence to complete. Jared -- 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: Veritas Backup Question
If you have the room, I would suggest doing a daily export of the database until you get all the problems ironed out with Netbackup. Especially if you are trying to do incremental backups. That way you will at least have something to restore with if you find out your Netbackup plan wasn't working. Also, don't trust any backup plan until you have backed it up every which way AND restored it using the backups. I export every day and then run the export through WinZip to save space. I keep the export around for at least a week. Good Luck! R. Smith -Original Message- Sent: Thursday, January 15, 2004 11:50 AM To: Multiple recipients of list ORACLE-L Teresita, You've gotten some good comments...even a quick tutorial on backups. My recommendation to you (especially if you don't have any backups at all) is that until you're more familiar with the tools you have that you should initially avoid the complexities of incremental backups and immediately arrange for a regular cold (database down) backup. Minimally this should include all datafiles, control files, online redologs, and archived redologs (you didn't say whether or not you are in archivelog mode). But don't stop with these files. Check documentation CD. It will have a section on backup and recovery. Kip |Hi!! |My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle |just to make queries, funtions some updates and create indexes or |tables, that all. |Now I am in a little difficult situation, here we have a DBA that do |not have much experience. He has been working with Veritas NetBackup |4.5 for Windows for three moths with out results. We still can not |make a backup of our data bases. The situation is that because of that |my boss make me work with him in this task, of course I don't know |anything about the issue and my priority for tomorrow is to make and |investigation of how other people make their backups with Veritas. |Our DBA explain us that it was a way that he saw in a book, first make a |complete backup of our databases on Sunday then from Monday thru Wednesday |made a incremental backup, then from Thursday thru Saturday make another |incremental backup, but this one will be done from the last incremental |backup of Wednesday to the day we are. |- |--- |--- | - | -- | -- | Complete backup |1 2 34567 |1-Monday |7- Sunday |I am really lost in this task because the person that is suppose to |teach about Veritas is really reluctant , but my boss what results. If |any one can help me telling was is the better way to do a backup using |Veritas that will be great. I also need to learn Veritas so if you have |any page or document that can help I will appreciate it. We really need |to make this work because in the last weeks we are having troubles with |our server, with out explication it gets crushes. I am using Oracle |9.2.0.2 in a Windows Server with Windows 2000 SP3 and |And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server |with Windows 2000 SP4 -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Wind Chill PDM LINK
List, We are starting to use PTC WindChill in our Oracle 9i environment. If anyone has expierence with this product, I would a appreciate it I could discuss with you offline. Please e-mail me directly. TIA Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
RE: most practical 9iR2 features?
Brad, We're primarily using 9i with a third party time accounting system, so I haven't had too much time with a lot of 9i, but the resumable transactions are a REAL time energy saver. The Time accounting system has to do bulk data loads from our HR system as well as it's own batch processing. All things that like to eat up tablespace and you can guess that the vendor's estimates (more like Guesstimates) were not up to the realities. But they did set themselves up to use the resumable transaction capability and I did manage to get the database internals setup, thank you OTS. Then when these batch jobs were run for real the jobs stopped while I got paged. In the old days the job would have failed leading to a lot of finger pointing, etc... In this case I was able to fix it it continued without error. Now that's a FEATURE!!! :-) Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, January 15, 2004 12:15 PM To: Multiple recipients of list ORACLE-L Hey listers I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals: 1. Ease administration 2. Are not marketing crap 3. Are not already in 8.1.7 4. Increase response time and or perfromance A quick bullet list would be way cool of stuff that make you puff up and say ...this is so cool We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app. Reply direct if you desire. We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...) (I am already reading the new features doc and another doc by Howard Rogers) Thanks in advance Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi!! Veritas Backup Question
Teresita, One of the CD's is titled documentation. You'll find the RMAN manual thereon. There are two, Recovery Manager Quick Reference and Recovery Manager Reference. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hi!! Veritas Backup Question Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - -- -- - - Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Application Server Caching
Title: Message He's right, accessing the database is expensive. So is accessing from an app server if you have to support concurrency, updataing, transaction control,etc. Only if you consider the ACID properties of databases of no use for your application is this line of argument correct. The businesses that this is true of are small in number. Allan -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of RyanSent: Wednesday, January 14, 2004 4:14 PMTo: Multiple recipients of list ORACLE-LSubject: Application Server Caching I heard a presentation from a front end performance analyst last night from www.tangasol.com (im not associated with them at all). He was pretty impressive. He argued that accessing the database is expensive. He also argued in favor of caching data at the application server level. Have any of you worked with this? What are your opinions? His opinion was that people go back to the database to ask the same question way too often and cause a botteneck, if you can cache these frequently asked questions at the front end, it will significantly scale better. __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
alter table rename error
Just try to rename table and get this error, anyone knows what this error is? alter table scott.emp rename to scott.employee ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations eric
RE: powerbuilder in rbo and multiple constraint question...
Chris I know from a previous assignment that PowerBuilder has no issues running queries against a database using the CBO. In fact, PowerBuilder doesn't give a rats backside what the database does to the query as long as it returns what's expected. As for redundant constraints, they will increase the parse time for all sql commands and slow down all DML operations -- just as they do in SQL Server. HTH Kevin -Original Message- Sent: Thursday, January 15, 2004 9:55 AM To: Multiple recipients of list ORACLE-L I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? .and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. .after possibly putting my foot in my mouth I'm looking to validate what I said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: powerbuilder in rbo and multiple constraint question...
try again... -Original Message- Chris I know from a previous assignment that PowerBuilder has no issues running queries against a database using the CBO. In fact, PowerBuilder doesn't give a rats backside what the database does to the query as long as it returns what's expected. As for redundant constraints, they will increase the parse time for all sql commands and slow down all DML operations -- just as they do in SQL Server. HTH Kevin -Original Message- Sent: Thursday, January 15, 2004 9:55 AM To: Multiple recipients of list ORACLE-L I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? .and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. .after possibly putting my foot in my mouth I'm looking to validate what I said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Toepke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
most practical 9iR2 features?
Hey listers I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals: 1. Ease administration 2. Are not marketing crap 3. Are not already in 8.1.7 4. Increase response time and or perfromance A quick bullet list would be way cool of stuff that make you puff up and say ...this is so cool We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app. Reply direct if you desire. We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...) (I am already reading the new features doc and another doc by Howard Rogers) Thanks in advance Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
named pipes, sql loader and ftps
I was flipping through Tim Gorman's Data Warehouse and he has a short section on using named pipes to kick off sql loader when you send files to your data warehouse with ftps. Ive never used named pipes in Unix? Does it depend on the shell(I only know korn). Anyone do this? With this method you can start doing your sqlloader while still recieving your file. Anyone ever do this with automated file reciept? Files come in over night and the sqlloader gets kicked off?
RE: alter table rename error
Title: Message Eric, Try: ALTER TABLE scott.emp RENAME TO employee; Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message-From: eric king [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 3:00 PMTo: Multiple recipients of list ORACLE-LSubject: alter table rename error Just try to rename table and get this error, anyone knows what this error is? alter table scott.emp rename to scott.employee ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations eric
Re: alter table rename error
You cannot specify a schema in the rename clause. Simply change your statement to alter table scott.emp rename to employee. The table will stay within the scott schema even if the command is executed by another user. eric king [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] il.com cc: Sent by: Subject: alter table rename error [EMAIL PROTECTED] .com 16/01/2004 06:59 Please respond to ORACLE-L Just try to rename table and get this error, anyone knows what this error is? alter table scott.emp rename to scott.employee ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations eric Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: most practical 9iR2 features?
Brad, - External Tables have the potential to be WOW and when properly used instead of SQLLDR can meet #1 4. - Resumable transactions Stephen [EMAIL PROTECTED] 01/15/04 10:14AM Hey listers I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals: 1. Ease administration 2. Are not marketing crap 3. Are not already in 8.1.7 4. Increase response time and or perfromance A quick bullet list would be way cool of stuff that make you puff up and say ...this is so cool We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app. Reply direct if you desire. We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...) (I am already reading the new features doc and another doc by Howard Rogers) Thanks in advance Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: named pipes, sql loader and ftps
Comments inline On 01/15/2004 04:14:27 PM, Ryan wrote: I was flipping through Tim Gorman's Data Warehouse and he has a short section on using named pipes to kick off sql loader when you send files to your data warehouse with ftps. Tim is a resourceful guy. I scripted it once for export. Ive never used named pipes in Unix? Does it depend on the shell(I only know korn). No, it doesn't depend on the shell. You create named pipe by using mknod pipe name p. Some Unix versions have specialized command called mkpipe. Anyone do this? Yup. With this method you can start doing your sqlloader while still recieving your file. Anyone ever do this with automated file reciept? Files come in over night and the sqlloader gets kicked off? Since the advent of the external tables, loader is no longer a must. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter table rename error
Title: Message Rewrite the query without specifying the owner name and it works. Alter table emp to employee; -Original Message-From: eric king [mailto:[EMAIL PROTECTED] Sent: Thursday, January 15, 2004 12:00 PMTo: Multiple recipients of list ORACLE-LSubject: alter table rename error Just try to rename table and get this error, anyone knows what this error is? alter table scott.emp rename to scott.employee ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations eric
Re: powerbuilder in rbo and multiple constraint question...
Powerbuilder is a GUI. just like forms. This is what typically happens with 3rd party apps. They develop them some time in the past. Oracle adds new features, they dont want to spend the money to test to see if it works. So they tell customers not to use them. Its how they keep costs down. New development costs money. Most people buy these 3rd party applications because its cheaper than making their own. Making changes to them would cause them to have to raise prices. Which 3rd party application is that? I dont like that they lied. It would be better if they were just honest about. Becareful just analyzing the tables and letting the CBO take over. Old RBO applications can be loaded with hints that can cause problems in the CBO. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 9:54 AM I'm working with a 3rd party vendor to resolve some performance issues with there call center app. The app is written in PowerBuilder. When I traced the offending sessions, I noticed the queries are being run under the rbo. When I run those same queries under the cbo the response time is dramatically different. I asked why they insisted on running under the rbo. There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? ..and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? .when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. ..after possibly putting my foot in my mouth I'm looking to validate what I said. ...if I don't get any responses to this, I'll run the trace myself and post my findings. oh yeah...the .not developers responded by saying the redundant constraints wouldn't be a problem in sql server. ..something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Anyone using IBM's Flashcopy for hotbacks?
We're considering an IBM FAStT SAN for a 30GB Oracle9i DB on HP/UX 11i. One option with the FAStT is called FlashCopy. It's been six months since I've last looked at this, but our original idea was to smack all TSs into backup mode, FlashCopy, then smack all TSs out of backup mode. We'd also need to dump the copy to tape, then startup this copy as another instance, so the Tivoli plugin to have RMAN manage this probably wouldn't be worth the money for us. So, has anyone done this? Which FlashCopy options did you use? Any major gotchas to not do this? Does the Flash cause I/O problems during the backup due to the block reads from the original DB? TIA, Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Convert to Locally-Managed Tablespaces
The release specific bits are stored in release specific tablespaces, which are migrated to new tablespaces during the upgrade. You can reclaim the space afterward. For example, upgrading 4.0B to 4.6C will cause a migration of data from PSAPES40BD to PSAPES46CD, among others. Newer releases based on WAS 6.20 and higher use PSAPSCHEMAREL instead (e.g. PSAPDEV620 or PSAPPRD620 for a DEV or PRD db running 6.20). Upgrades are done the same way, e.g. PSAPDEV620 - PSAPDEV630 and you can free up PSAPDEV620's segments afterward. Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Tuesday, January 06, 2004 3:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Convert to Locally-Managed Tablespaces Jared - I don't know SAP, but other canned applications have a wonderful process they put you through every few years called an upgrade. Often you end up creating another database and moving the data. This is a great opportunity for the DBA to fix some issues like this. However, since SAP is used by some REALLY large organizations with really, really large amounts of data, perhaps SAP uses a different practice. I would like to know if that is the case. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 05, 2004 8:09 PM To: Multiple recipients of list ORACLE-L Tanel, That's a good idea. I briefly considered this, but didn't really dig into it. The systems I need to do this on is our SAP systems, and downtime is a precious commodity, especially for production. I just may try this on our test system. The problem with SAP of course, and many other ERP's is that there are 22k+ tables, which could consume a bit of time. The amount of fragmented space that would be recovered is probably not worth the trouble of this procedure, depending on how much time it takes. I see that you too need to keep the original tablespace names, is this SAP per chance? If you have already performed a test of this, what kind of times are you seeing, along with relevant platform information, and the number of tables/indexes? Jared On Mon, 2004-01-05 at 16:49, Tanel Poder wrote: Hi! This is what I will need to use on our systems, as there are about 400 gig of data and indexes. 200 gig of data is too large to export/import, at least it is for this project. So dbms_space_admin it will be. I'm about to do a reorg+conversion of a 250GB 8.1.6 database in next week, here's what I'll do (there is practically no free space for temporary usage): 1) Export index definitions (normal export with rows=n) 2) Drop all indexes 3) use alter table move with parallel 16 and nologging to move all tables to old index tablespaces (the indexes consumed more space than tables) 4) drop and recreate data tablespaces 5) use alter table move again to move tables back (the segments have to reside in original tablespaces, otherwise I could have skipped this step) 6) drop and recreate index tablespaces 7) get index definitions out of exportfile and modify them to add parallel nologging (with big sort area size) 8) rebuild indexes 9) do a full backup It might help to recreate index tablespaces even before step 3, to speed up parallel table moving a bit.. Maybe you want to test this Jared, this approach is much faster than export/import, because everything can be done with direct path operations and nologging (import doesn't have direct path facility, so regular array inserts are used, which always require logging as well). Also, your tables/datablocks will be optimized after moving them (which is not the case with dbms_space_admin) and you don't have to have any space for reorg in case your cleared index tablespace can temporarily accommodate your data. IIRC one of the drawbacks of using dbms_space_admin to convert is that you won't be converting to nice uniform extent sizes for existing data. Yes, and if your tablespace is fragmented, the fragmentation will remain there, despite your conversions (of course, smaller extents might be able to use some of this fragmented space later on). Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY,
RE: 9i OEM/tools to monitor 8i instances
Repost ... -Original Message- Sent: Wednesday, January 14, 2004 9:14 AM To: '[EMAIL PROTECTED]' LG, Has there been any issue monitoring and administering 8i databases using 9i tools? I am seeing some strange behavior when using 9i OEM tools to monitor 8.1.7.0 database and unfortunately I can not reproduce on a consistent basis. TIA, Nikhil -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikhil Khimani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: most practical 9iR2 features?
This is a good question. We've been running 9i instances for 18+ months now. Here are my impressions: I would say RESUMABLE, especially for bulk loads, export/import, sqlloader is #1. This has saved HOURS!!! Dynamically modifiable SGA parameters have helped us with reliability. Less need to ever bounce! We're now letting the database name datafiles for new partitions, which, for archivable tables, makes it easier to drop partitions and datafiles and more easily reclaim space in an automated fashion. The new RMAN features, overall, make the product finally usable in our eyes. It still needs improvement, though... Undo tablespaces have significantly cut down on rollback and snapshot too old errors. But it's not perfect... Automated workarea size policy is much better than manually calculating PGA variables such as sort_area_size, etc... We haven't used much flashback or query rewrite features yet. At least not directly (some vendor code may use them). I am sure interested in seeing what others have to say. Michael Fontana Sr. DBA NTT/Verio -Original Message- Odland, Brad Sent: Thursday, January 15, 2004 11:15 AM To: Multiple recipients of list ORACLE-L Hey listers I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals: 1. Ease administration 2. Are not marketing crap 3. Are not already in 8.1.7 4. Increase response time and or perfromance A quick bullet list would be way cool of stuff that make you puff up and say ...this is so cool We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app. Reply direct if you desire. We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...) (I am already reading the new features doc and another doc by Howard Rogers) Thanks in advance Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Michael Fontana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Looking for OEM 9i book(s)
Title: Message Are there any good 3rd party OEM 9i books out there? I know OEM 10G is the new version, but I am looking for a 9i one right now. Specifically on PM and on CP. Thanks. Patrice.
Re: powerbuilder in rbo and multiple constraint question...
On 01/15/2004 09:54:36 AM, Chris Stephens wrote: There response was that it's a limitation of powerbuilder. I don't buy that for a second. ...anyone know for sure? I have slight experience with supporting Powerbuilder apps in 1996 and, later, in 1998. At that time it was completely possible to enter comments in the SQL statements. I assure you that Powerbuilder has no such limitations and that some of the wise guys in development just do not like RBO, based on magazine reading and the latest NFL results. Not a single NFL quarterback uses CBO,so why would they? ..and on a side note...my company is developing a call center app in .not. The dba's were conveniently left out of the design process. Then he cannot be made responsible for the performance, either. Just sit back, put an evil grin on your face, and enjoy. I just took a look at the schema they are using and noticed redundant constraints on almost every table. i.e. not null, primary key, unique on the same column. Before I investigate myself with a 10046, does anyone know if oracle has to do multiple recursive sql to validate each constraint or is it smart enough to know they are redundant and only validate the pk constraint? Me thinks not, but you should test it out by doing 10046 as sys and see the recursive SQL commands. .when I saw this, I blasted the developers (admittedly some misdirected aggression) for not having a clue what they were working with and blankly stated that the redundant constraints (among other things if found...no bind variables for one) would negatively affect performance. Any arguments there or is his conviction based on the the Holy Bible and the Book of Genesis? Is your developer from Kansas? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter table rename error
Title: RE: alter table rename error Eric, No schemas allowed. Take out both of the scott. You need to be logged in as Scott to rename Scott's tables. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: eric king [SMTP:[EMAIL PROTECTED] Just try to rename table and get this error, anyone knows what this error is? alter table scott.emp rename to scott.employee ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations eric
Re: Process consumes CPU and long time to finished
comments in line... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 11:04 AM sarcasm Wow, your buffer cache hit ratio for this query is better than 99.99%! With a BCHR like that, how could you possibly tune this query to be better?? /sarcasm Now, seriously, since I know nothing about your application or environment, and you do not show execution plan, I can only offer some general thoughts. Table join order should be in the order of smallest to largest number of rows being returned, based on the non-join filter predicates, as they apply to each table. So, if you have a 1 million row table joining a 10,000 row table, but there is no non-join filter predicate on the 10,000 row table, and you have a primary key lookup on the 1 million row table, then you want the 1 million row table to be the driving table. Also, make sure that index access paths are available for your filter and join predicates, where possible. I have never had a problem with join order with the CBO. I have yet to see oracle pick a bad join order on its own as long as I analyze the tables. Hope that helps get you pointed in the right direction, -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Thursday, January 15, 2004 4:05 AM To: Multiple recipients of list ORACLE-L Hi all, I have process in Oracle apps 11.5.8 which need very lot CPUs and long time to complete. for about 17,000 invoices it takes 28 hours !! I have open TAR since month ago, and still get no solution. maybe here someone can share any idea ? im using 11.5.8, sparc. DB 9i rel2 here is from the tkprof : SELECT sum(nvl(entered_cr,0) - nvl(entered_dr,0)) , sum(nvl(accounted_cr,0) - nvl(accounted_dr,0)) FROM AP_AE_Lines AEL, AP_AE_Headers AEH, AP_Invoice_Payments AIP WHERE AIP.Invoice_ID = :b2 ANDAEL.Source_ID = AIP.Invoice_Payment_ID ANDAEL.Source_Table = 'AP_INVOICE_PAYMENTS' ANDAEL.AE_Line_type_code = 'LIABILITY' ANDAEH.Set_of_Books_ID = :b1 AND AEL.AE_Header_ID = AEH.AE_Header_ID call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse1 0.00 0.00 0 0 0 0 Execute 1539 0.23 0.31 0 0 0 0 Fetch 1539 16474.95 21810.67 24 46864854 0 1538 --- -- -- -- -- -- -- total 3079 16475.18 21810.99 24 46864854 0 1538 1. post the explain plan 2. If your in 9i do a 10046 trace, if not run statspack just before running this query, then just after running it and post the top 5 wait events. Ill bet your writing a ton to your temp tablespace. This causes massive slowdowns. I dont think 'disk' accounts for temp tablespace writes. I could be wrong. 3. are your tables analyzed? Misses in library cache during parse: 0 Optimizer goal: CHOOSE Parsing user id: 24 (recursive depth: 1) tq -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: hernawan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: alter table rename error
Jerry, Not true. With the right permisssions it is defintely possible to rename someone else's objects. Connect as system and try to rename scottt's tables - definitely possible. I just tried it against Oracle 8.1.7.4, and we actually used it during some migrations to a production environment only a month ago. Regards, Mark. PS: No schema for the second name though - that would be changing the actual owner, not just renaming. Putting the owner in (even if it's the same owner) will cause an error to be raised. Whittle Jerome Contr NCITo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ott.af.mil Subject: RE: alter table rename error Sent by: [EMAIL PROTECTED] com 16/01/2004 08:34 Please respond to ORACLE-L Eric, No schemas allowed. Take out both of the scott. You need to be logged in as Scott to rename Scott's tables. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: eric king [SMTP:[EMAIL PROTECTED] Just try to rename table and get this error, anyone knows what this error is? alter table scott.emp rename to scott.employee ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations eric Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hi!! Veritas Backup Question
Thanks I saw that CD. [EMAIL PROTECTED] 01/15/04 01:04PM Teresita, One of the CD's is titled documentation. You'll find the RMAN manual thereon. There are two, Recovery Manager Quick Reference and Recovery Manager Reference. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hi!! Veritas Backup Question Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
RE: Hi!! Veritas Backup Question
Thanks I saw that CD. [EMAIL PROTECTED] 01/15/04 01:04PM Teresita, One of the CD's is titled documentation. You'll find the RMAN manual thereon. There are two, Recovery Manager Quick Reference and Recovery Manager Reference. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, January 15, 2004 12:50 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Hi!! Veritas Backup Question Hi!! TheCD's that we have saidOracle 9.2.0.1.0, but I did not see any that said RMAN,( when I asked the DBA the version of Oracle that we have and he said 9.2.0.2.1.) the RMAN is inside a specify CD? [EMAIL PROTECTED] 01/14/04 09:49PM Teresita, What your DBA is talking about is Oracle's RMAN backup utility. There us an interface from Oracle to Veritas which allows RMAN to use Veritas as a librarian for the backups. The first thing I'd suggest is finding out what version of Oracle your using. There are significant differences in using and setting up the RMAN and Veritas software between the two. Check out the documentation CD on RMAN that shipped with your database. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 14, 2004 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: Hi!! Hi!! My name is Tere Castro I am from Mexico I am not a DBA, I uses ORacle just to make queries, funtions some updates and create indexes or tables, that all. Now I am in a little difficult situation, here we have a DBA that do not have much experience. He hasbeen working withVeritas NetBackup 4.5 for Windows for three moths with out results. We still can not make a backup of our data bases. The situation is that because of that my bossmake mework with him in this task, of course I don't know anything about the issue and my priority for tomorrow is to make and investigation of how other people make their backups with Veritas. Our DBA explain us that it was a way that he saw in a book, first make a complete backup of our databases on Sunday then from Monday thru Wednesday made a incremental backup, then from Thursday thruSaturday make another incremental backup, butthis one will be done from the last incremental backup of Wednesday to the day we are. - ?-- ?-- ? ?- ?- Complete backup 1 2 3 4 5 6 7 1-Monday 7- Sunday I am really lost in this task because the person that is suppose to teach about Veritas is really reluctant , but my boss what results. If any one can help me telling was is the better way to do a backup using Veritas that will be great. I also need to learn Veritas so if you have any page or document that can help I will appreciate it. We really need to make this work because in the last weeks we are having troubles with our server, with out explication it gets crushes. I am using Oracle 9.2.0.2 in a Windows Server with Windows 2000 SP3 and And the veritas is VERITAS NetBackup 4.5 for Windows in a Windows Server with Windows 2000 SP4
Partitions, loading and moving at the same time?
Got some partitions to work on. They are divided by date and we've got several that this is the first month that two partitions are in the same tablespace and shouldn't be. But we can't stop production. If they are loading "December" data, can I safely move the "September" partition at the same time. The data is divided such they should not be touching it, but needless to say the index will go invalid for that partition until the move of the index is also done. Some of these are 2,000-5,000 meg, 176 million plus rows. If I had just had a bit more notice. But I'll probably have to start looking at this tomorrow. Also, if I chance the table partition name, does that invalid the matching partition index. I also have to rename it was well. They are going 5 years, 60 months, so M1, M2, M3 ain't going to cut it. We want to go to x_200309, x_200310, x_200311, etc. Thanks. Michael Kline, Principal ConsultantBusiness To Business Solutions, LLCRichmond, VA804-744-1545
test mail -- plz. ignore
test mail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Checkpoint ...
All, Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen.. Other than that any scenarios? Thanks and Regards, Satheesh Babu.S DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Checkpoint ...
If the datafile is off-line? (Not tested, just a guess.) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Fri 1/16/2004 12:04 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Checkpoint ... All, Whenever checkpoint happens datafile header scn and controlfile scn will be in sink. Is my assumption is right? Is there any other scenarios where checkpoint only update controlfile and doesn't update datafile header? Agreed, during begin backup mode datafile header will be frozen.. Other than that any scenarios? Thanks and Regards, Satheesh Babu.S DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). winmail.dat