Re: ORA-3113 errors after switching W2K server to new network
Success! I've now learnt, from our network security admin guy, that the Firewall Manager on the new network is configured by default to timeout inactive connections after 60 minutes. Even though all the user clients are inside the firewall, the server is specially ringfenced because the third-party application suppliers have access to it via PC Anywhere. Therefore the users have to access the server via the firewall, and therein lies the problem! Apparently the old firewall had this feature either disabled or set ludicrously high, but those responsible for the new firewall are unwilling to change the 60-minute default. Obviously they're being far more cautios about accumulating idle connections this time around! So we now have our solution choices - either someone makes the decision to up the timeout period, or the application vendors fix the app to issue a dummy query every so-many minutes of inactivity... or the users get used to logging in and out of the app when they need it, rather than leaving it running idle all day... It's now a political decision rather than a technical problem. A satisfactory end to the problem, which may well have not been the case without the input from this list, for which many thanks, particularly to Tim Onions, Paul Drake and Tim's resident firewall guru. Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: table reorganizations
Rachel, Thanks for the idea but the system is running 8i. I'll remember it for the future. Chris Quoting Rachel Carmichael [EMAIL PROTECTED]: Chris, Have you considered using dbms_redefinition for your second case? That would allow you to reorg and swap the tables without locking for any length of time. Rachel --- [EMAIL PROTECTED] wrote: Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- 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). __ 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 a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like
RE: table reorganizations
Tom, In my first example you are right that new inserts would use the space freed by the deletes but the purge program is run every quarter (sorry for not stating that explictly earlier). Therefore there is at most 2.25 years worth of data in the tables when before the first purge there was 4 years. Hence I believe the table reorg is valid for both disk space savings and performance. In my second example the amount of data loaded into the transaction log table can vary dramatically due to double-day processing caused by public holidays etc. Therefore if the table wasn't reorganised daily the table would end up being at least twice as large as necessary and therefore impcat the performance of FTS. These examples were both on 8i but I don't think 9i would make any difference. Pls let me know the details if 9i does make a difference. Cheers, Chris Quoting Mercadante, Thomas F [EMAIL PROTECTED]: Chris, I would argue that in your two examples, nothing needs to be done if you are using Locally Managed Tablespaces. All of the free space that your deletes generated would be reused by new inserts. When you say not good for FTS, I think you are wrong. Have you tried testing this statement? How much slower is it? Of course, I am talking about using Oracle 9i. Prior versions behaved much differently. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 09, 2004 6:09 AM To: Multiple recipients of list ORACLE-L Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh bugger, I've just gone and done it myself). A large table accessed via a FTS for various important reporting requirements has permanently shrunk in size from 10G to 100M (say list of Informix customers ;) Business requirements have changed and you need to add some columns to a table resulting in mucho row migration. You were told (incorrectly) that rows would grow significantly after loading (honestly) but now the 80 pctfree value you've set is causing problems for other really important reports. There are of course other cases but you get my point ;) Cheers Richard - Original Message - From: Mercadante, Thomas F To: Multiple recipients of list ORACLE-L Sent: Thursday, January 08, 2004 6:34 AM Subject: RE: table reorganizations Jolene, Tables should never *need* to be reorganized. This is an old falacy. If you know how big a table is going to grow, say in a year, then place it in a Locally Managed tablespace with extent sizes to hold enough data for one year (say 1M). You should never have to reorganize a table. Tom Mercadante Oracle Certified Professional -Original Message- From: Shrake, Jolene [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 2:39 PM To: Multiple recipients of list ORACLE-L Subject: table reorganizations What SQL statement do you use to identify tables that need reorganization? How do you identify tables that are used in full table scans? How often do you run this query? Thanks, Jolene Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- 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
RE: table reorganizations
Niall, In the first case disk space was the primary reason, performance improvement being a positive side-affect, so as to avoid a major disk array upgrade. I know that new inserts would use the deleted space in the pruged tables. However that free-space within the table block isn't very flexible i.e. it can only be used for inserts into the particular table. After the reorg the space is available to all objects in the tablespace and in our case as we moved the tables to new tablespaces we were also able to reduce the size of the tablespaces, therefore gving the space back as the OS level where it can be allocated to any tablespace in the future. In the second the table-swap was first implemented under Oracle 7 so alter table move wasn't available. I hope this explains the reasoning. Chris Quoting Niall Litchfield [EMAIL PROTECTED]: Hi Chris Richard, I agree there are a number of reasons for reorganising tables. LMTs remove the need to reorganise a tablespace but not to reorganise a table. Two further real- ilfe examples of table reorgs: 1) The purge programs have at last been written and run deleting data 2 years old. The system's been running for 4 years. So in simple terms most of the tables are approx 50% empty. You need to reorg in this case. What would be the rationale for this? If the rationale is performance how much faster does it make everything, and how many users are complaining to start with? If purely for space management purposes then I'd ask why the deleted space could not be reused? 2) A transaction log table is inserted to throughout the day and most of the night. A clear down processing job runs at the end of the day and deletes all the rows its processed, but more rows are being added. So the table is now 1% full. Not good for FTS. So instead of a conventional reorg we implemented a nightly table-swap. This meant locking the source table, copying it's contents to a replica empty single extent table, target table. The names of the target and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Pah. Once a day indeed. Once every 5 minutes... I'm interested in why you implemented table swap instead of 'alter table move' which is what we did. Cheers, Chris Dunscombe Cheers Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORACLE-L Digest -- Volume 2004, Number 012 (Out of Office
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tony Miller INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: pga workarea and ora-04030
Jonathan, Thanks for your answer this clarifies a bit more But it still bothers me that this program can swallow 4Gb of physical memory and 4 Gb of swap and it is still not enough. You explain that the memory of pl/sql tables is not in the sga so that's clear now. What still bothers me is that my original program works fine with pga_target = 0 and wa-size-policy=manual When I try this with this test-program it fails (see below) VU_2exec testarray(1); begin testarray(1); end; * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-04030: out of process memory when trying to allocate 8144 bytes (cursor work he,qesaQBInit:buffer) ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.DBMS_OUTPUT, line 127 ORA-06512: at VRIJ_UIT.TESTARRAY, line 23 ORA-06500: PL/SQL: storage error ORA-06512: at line 1 Somehow these setting influence the way the pl/sql program works. This testprogram is clearly not enough to explain this behaviour. Because we Use quite some pl/sql I would like to know more because it could happen Maybe with other programs. Oracle 7 the same code runs fine also. I read a post that the difference for pl/sql tables is that they are now implemented as fully allocated arrays in memory whether they were implemented in oracle 7 and chained linked lists. Obviously this takes more memory but why do these 2 settings play such a role? Is the memory involved differently when using these settings? Can I monitor specific memory usage with these setting and how should this be done on HPUX? Regards, Jeroen -Oorspronkelijk bericht- Van: Jonathan Lewis [mailto:[EMAIL PROTECTED] Verzonden: Saturday, January 10, 2004 6:54 PM Aan: Multiple recipients of list ORACLE-L Onderwerp: Re: pga workarea and ora-04030 I think what you've demonstrated is that pl/sql tables are not limited by pga-aggregate target, and that a pl/sql table can grow until it has taken up all the available memory on your machine. I'd guess that each element in your table takes about the same space - with a little error round the edges - so you can have 17.6M rows before you are out of memory - either as two tables of 8.8M or one table of 17.6M. The sleep time is probably because you start going to SWAP and your session spends time dumping real memory to disc. When the SGA is 1.5G smaller, that frees up an extra 1.5G of memory for you to use as PGA - so you get lots more entries in the table before you run out of memory. 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: Friday, January 09, 2004 10:34 PM Hi, I followed you advice and made small testprogram see below: I only get the ora-06500 which I have had before in the original program as A followup error so to me it seems to be reproducible. In manuals I only find that the index Of a pl/sql table cannot be more than 2**31, which is something like 2.000.000.000 I found on metalink some posts which suggested this might be functioning better enlarging shared pool and also max user data (ulimit of oracle) We increased maxdseg in the ux-kernel parameters to 4Gb to increase this limit (was 2Gb). There is 4Gb available of physical memory in the box. Using a shared pool 0f 500Mb, pga_aggregate_target 100Mb setting 100.000.000 elements - 22 minutes and it fails Exception raised insert i= 68102540 Using 1 table, shared pool 2Gb setting 1.000.000 elements - 14 seconds setting 10.000.000 elements - 282 seconds setting 100.000.000 elements - 12 min 24 seconds fails 21:54:37 VU_2exec testarray( 1 ); Exception raised insert i= 17613935 Running with a second table involved: after 17 minutes 29 seconds 22:40:20 VU_2exec testarray( 1 ); Exception raised insert i= 8806960 So it is reduced by 50%. But why is the result with a smaller sga Giving me more elements set? Watching the oracle serverprocess with top utility I see the memory resident part Most of the time around 2600M but more interesting the process is Most of the time sleeping, what the heck is it doing all the time before Going into an error? 1 ?4728 oracle 128 20 4116M 2626M sleep7:49 1.20 1.20 oracleVU_2 I cannot find any other restriction then 2**31 limit on the index. I don't know how to calculate how much memory this is taking because watching sqlworkarea of pgastat doesn't show any useful info in this
Re: Should we stop analyzing?
And all the +RULE queries you listed, where data dictionary queries anyway (which is designed for RBO). Tanel. [TG]: I can't even spell 10g, so I'll take your word for it... The OraApps 11i assertion did not sound right, so to verify I queried both the V$SQLAREA view as well as the STATSPACK repository (i.e. STATS$SQLTEXT) on a rather busy OraApps 11.5.8 system running Financials, ERP, HR/Payroll, Order Entry, and Inventory. The STATSPACK repository is only holding 14 days worth of data; I keep it purged pretty tight to keep it below 1Gb in size... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Should we stop analyzing?
Don, Comments inline... Yes! IME, there ARE still problems in the CBO, especially with complex subqueries. I have more than a dozen systems where management insists on staying with the RBO! [TG]: With all due respect, what does management know about this stuff anyway? They do not work with it, they do not research it, and they do not understand the issues if technical people do not research, understand, and inform them. Management makes decisions based on information provided. That is their job. Bad information, bad decisions. Hi Tim, Went to a management meeting the other day to discuss the statuses of a number of projects. At the meeting I asked the assembled managers Hey guys, what are your opinions on what type of Oracle optimizer we should use ? They kinda looked at me with a glazed look in their eyes and one of them was brave enough to ask What's an optimizer ?. OK, it's not entirely true but I were (stupid enough) to ask the question, I'm sure it's the reaction I would receive, if not a lot worse. Can't say I've (yet) worked in an organisation where management decides how to tune the databases !! Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problem with archive log when testing recovery..., urgent
Thank you for your reply, Yes, you're quite right, I think the archive next to the cold backup is corrupted. The hot backup is always succeeded. But I wonder why is my cold backup is largely end up with internal error or corrupted archive log files. All I do for closed backup is shutdown immediate, copy all controlfiles, datafiles and redo log files to backup destination, and then reopen the database. Is there any steps that I left which cause the archive log to be corrupted? Thank you in advance. Regards, Wendry. -Original Message- Sent: Monday, January 12, 2004 12:36 PM To: Wendry In which order did you perform the backups ? Say you do the cold backup, and the next archive is corrupted. You then do a hot backup. Restore the cold backup and the archive needs to be applied. Restore the hot backup, and it is after the corrupted archive. Does the corruption occur with an archive used by the cold backup, but not the hot backup ? Cheers GJC The fifty dwarves were reduced to eight, before anyone suspected hungry. __ Gary Colbran System/Database Administrator Telkom SA 55 Oak Avenue Centurian South Africa Ph: 012-680 1315. Ph: 082-786 6592. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] **Disclaimer** ** Information contained in this E-MAIL being proprietary to Telkom SA and is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ** * -Original Message- Sent: 16 January 2004 03:16 To: LazyDBA.com Discussion Hi all, I have done closed and open backup on my database. Later on I try to test my backup. So I try the closed backup that I've taken. The backup database can be opened succesfully. But when I try to recover database using backup controlfile, the archive logs giving me internal error (sometimes after applying 1st to 5th archive log), sometimes it gave me notification that the archive logs is corrupted. Strangely when I test my open backup, and recover it using the same set of archive logs, the process went smoothly. So what is the real problem here, I really don't have any idea. Is there somebody have the same experience? Now I'm in doubt of planning my backup schedule, please help... Thanks a lot. Regards, Wendry. Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] By using this list you agree to these terms:http://www.lazydba.com/legal.html -- 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: Problem with archive log when testing recovery..., urgent
Are you certain that SHUTDOWN IMMEDIATE succeeded? There are lots of bugs in MetaLink where it hangs or fails with ORA-00600... on 1/12/04 7:04 AM, Wendry at [EMAIL PROTECTED] wrote: Thank you for your reply, Yes, you're quite right, I think the archive next to the cold backup is corrupted. The hot backup is always succeeded. But I wonder why is my cold backup is largely end up with internal error or corrupted archive log files. All I do for closed backup is shutdown immediate, copy all controlfiles, datafiles and redo log files to backup destination, and then reopen the database. Is there any steps that I left which cause the archive log to be corrupted? Thank you in advance. Regards, Wendry. -Original Message- Sent: Monday, January 12, 2004 12:36 PM To: Wendry In which order did you perform the backups ? Say you do the cold backup, and the next archive is corrupted. You then do a hot backup. Restore the cold backup and the archive needs to be applied. Restore the hot backup, and it is after the corrupted archive. Does the corruption occur with an archive used by the cold backup, but not the hot backup ? Cheers GJC The fifty dwarves were reduced to eight, before anyone suspected hungry. __ Gary Colbran System/Database Administrator Telkom SA 55 Oak Avenue Centurian South Africa Ph: 012-680 1315. Ph: 082-786 6592. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] **Disclaimer** ** Information contained in this E-MAIL being proprietary to Telkom SA and is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ** * -Original Message- Sent: 16 January 2004 03:16 To: LazyDBA.com Discussion Hi all, I have done closed and open backup on my database. Later on I try to test my backup. So I try the closed backup that I've taken. The backup database can be opened succesfully. But when I try to recover database using backup controlfile, the archive logs giving me internal error (sometimes after applying 1st to 5th archive log), sometimes it gave me notification that the archive logs is corrupted. Strangely when I test my open backup, and recover it using the same set of archive logs, the process went smoothly. So what is the real problem here, I really don't have any idea. Is there somebody have the same experience? Now I'm in doubt of planning my backup schedule, please help... Thanks a lot. Regards, Wendry. Get today's cartoon: http://www.LazyDBA.com Please don't reply to RTFM questions Oracle documentation is here: http://tahiti.oracle.com To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-3113 errors after switching W2K server to new network
Have you considered enabling DCD? This causes oracle to send pseudo-keepalive packets periodically, which should keep your sessions active from the firewall's perspective. You enable this by adding sqlnet.expire_time = ?? to sqlnet.ora on the DB server, where ?? is the frequency (in minutes) for the packets to be sent. It should start being used for new connections immediately... no DB restart required. -Original Message- Paul Vincent Sent: Monday, January 12, 2004 1:44 AM To: Multiple recipients of list ORACLE-L Success! I've now learnt, from our network security admin guy, that the Firewall Manager on the new network is configured by default to timeout inactive connections after 60 minutes. Even though all the user clients are inside the firewall, the server is specially ringfenced because the third-party application suppliers have access to it via PC Anywhere. Therefore the users have to access the server via the firewall, and therein lies the problem! Apparently the old firewall had this feature either disabled or set ludicrously high, but those responsible for the new firewall are unwilling to change the 60-minute default. Obviously they're being far more cautios about accumulating idle connections this time around! So we now have our solution choices - either someone makes the decision to up the timeout period, or the application vendors fix the app to issue a dummy query every so-many minutes of inactivity... or the users get used to logging in and out of the app when they need it, rather than leaving it running idle all day... It's now a political decision rather than a technical problem. A satisfactory end to the problem, which may well have not been the case without the input from this list, for which many thanks, particularly to Tim Onions, Paul Drake and Tim's resident firewall guru. Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 setup on linux
I've set it before to prevent IP trips to the router for programs that use IP to talk to itself (like some backup programs that work over a network). But like I said, it's probably my lack of understanding of how proper networking is to be setup... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, January 09, 2004 5:14 PM To: Multiple recipients of list ORACLE-L Rich, Before now, I've not heard of setting localhosts to the real IP address. I've only seen it aliased to loopback ( 127.0.0.1 ). Why would you do otherwise? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Curious ORA-942 on DataDict Views in 8.1.7 with
Two custom views [DDFS_TOTAL on DBA_DATA_FILES,
and FSH_TOTAL on DBA_FREE_SPACE]
which I create in the DBSNMP schema are now failing with
ORA-00942 after having set O7_DICTIONARY_ACCESSIBILITY=FALSE.
The database is 8.1.7.4 32-bit on Solaris8.
These views used to work with O7_DICTIONARY_ACCESSIBILITY=TRUE
For example, the query on DBA_DATA_FILES works. I only get the ORA-942
when I use the
query inside a CREATE VIEW. [see below]
Also, a Trace file for
ORA-00600: internal error code, arguments: [17067], [0], [], [], [], [],
[], []
Current SQL statement for this session:
SELECT * FROM DBSNMP.DDFS_TOTAL
is generated in the user_dump_dest for each of such databases the first
time the automated scripts which create the view and then generate
reports are run after
setting O7_DICTIONARY_ACCESSIBILITY=FALSE
{The reason why I use the views DDFS_TOTAL and FSH_TOTAL is that I have a
generic set of
scripts working from 7.3.4 to 9.2.0 so I am not using some of the
advanced In-Line views}.
Other 8.0 to 8.1.7 instances with
O7_DICTIONARY_ACCESSIBILITY=TRUE.
9.2 instances work with O7_DICTIONARY_ACCESSIBILITY=FALSE.
However, the difference in 9.2 instances is that DBSNMP has the SELECT
ANY DICTIONARY
Privilege while in the 8.1.7 and below instances, DBSNMP has the
SELECT_CATALOG_ROLE Role.
{The SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY grants to DBSNMP
are my own extensions run manually after
catsnmp.sql}
These are my View Definitions :
REM These views are created in the
remote (monitored) database
create or replace view fsh_total (tablespace_name, free_size, date_stamp)
as
select tablespace_name, sum(bytes)/1024/1024 free_size, trunc(sysdate)
from dba_free_space
group by tablespace_name, trunc(sysdate);
create or replace view ddfs_total (tablespace_name, total_size)
as
select tablespace_name, sum(bytes/1024/1024)
from dba_data_files
where status = 'AVAILABLE'
group by tablespace_name;
rem spool off
rem Do NOT put an EXIT as this script is called by FREE_SPACE_WARN !!
rem
See below [8.1.7.4 32-bit on Solaris 8] for the Errors I get
:
SQL show user
USER is DBSNMP
SQL select granted_role from dba_role_privs where grantee =
'DBSNMP';
GRANTED_ROLE
--
CONNECT
RESOURCE
SELECT_CATALOG_ROLE
SNMPAGENT
SQL select privilege from dba_sys_privs where grantee =
'DBSNMP';
PRIVILEGE
CREATE ANY DIRECTORY
CREATE DATABASE LINK
CREATE PUBLIC SYNONYM
CREATE SESSION
DROP ANY DIRECTORY
SELECT ANY TABLE
UNLIMITED TABLESPACE
7 rows selected.
SQL show user
USER is DBSNMP
SQL l
1 select tablespace_name, sum(bytes)/1024/1024 free_size,
trunc(sysdate)
2 from dba_free_space
3* group by tablespace_name, trunc(sysdate)
SQL /
TABLESPACE_NAME FREE_SIZE TRUNC(SYSDATE)
-- -- --
PLUMINDEX 717.554688 January 12 2004 00:00:00
PLUMTABLE 421.128906 January 12 2004 00:00:00
RBS 219.527344 January 12 2004 00:00:00
SYSDEFLT 149.019531 January 12 2004 00:00:00
SYSTEM 116.25 January 12 2004 00:00:00
TEMP 199.996094 January 12 2004 00:00:00
6 rows selected.
SQL l
1 create or replace view fsh_total (tablespace_name, free_size,
date_stamp)
2 as
3 select tablespace_name, sum(bytes)/1024/1024 free_size, trunc(sysdate)
4 from dba_free_space
5* group by tablespace_name, trunc(sysdate)
SQL /
from dba_free_space
*
ERROR at line 4:
ORA-00942: table or view does not exist
SQL l4
4* from dba_free_space
SQL c/dba/sys.dba
4* from sys.dba_free_space
SQL /
from sys.dba_free_space
*
ERROR at line 4:
ORA-00942: table or view does not exist
SQL l
1 create or replace view fsh_total (tablespace_name, free_size,
date_stamp)
2 as
3 select tablespace_name, sum(bytes)/1024/1024 free_size, trunc(sysdate)
4 from sys.dba_free_space
5* group by tablespace_name, trunc(sysdate)
SQL del 1
SQL l
1 as
2 select tablespace_name, sum(bytes)/1024/1024 free_size,
trunc(sysdate)
3 from sys.dba_free_space
4* group by tablespace_name, trunc(sysdate)
SQL del 1
SQL l
1 select tablespace_name, sum(bytes)/1024/1024 free_size,
trunc(sysdate)
2 from sys.dba_free_space
3* group by tablespace_name, trunc(sysdate)
SQL /
TABLESPACE_NAME FREE_SIZE TRUNC(SYSDATE)
-- -- --
PLUMINDEX 717.554688 January 12 2004 00:00:00
PLUMTABLE 421.128906 January 12 2004 00:00:00
RBS 219.527344 January 12 2004 00:00:00
SYSDEFLT 149.019531 January 12 2004 00:00:00
SYSTEM 116.25 January 12 2004 00:00:00
TEMP 199.996094 January 12 2004 00:00:00
6 rows selected.
SQL
Of course, I resolved the issue with GRANT SELECT ON
DBA_FREE_SPACE to DBSNMP.
Hemant K Chitale
Oracle 9i Database Administrator Certified Professional
http://hkchital.tripod.com
{last updated 05-Jan-04}
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hemant K Chitale
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
RE: ORA-3113 errors after switching W2K server to new network
--- Norris, Gregory T [ITS] [EMAIL PROTECTED] wrote: Have you considered enabling DCD? Greg, short of migrating to *nix, dead connection detection does not work on win32. not in 8.1.7.4, not in 9.2.0.4. possibly in 10g? ;) Pd This causes oracle to send pseudo-keepalive packets periodically, which should keep your sessions active from the firewall's perspective. You enable this by adding sqlnet.expire_time = ?? to sqlnet.ora on the DB server, where ?? is the frequency (in minutes) for the packets to be sent. It should start being used for new connections immediately... no DB restart required. -Original Message- Paul Vincent Sent: Monday, January 12, 2004 1:44 AM To: Multiple recipients of list ORACLE-L Success! I've now learnt, from our network security admin guy, that the Firewall Manager on the new network is configured by default to timeout inactive connections after 60 minutes. Even though all the user clients are inside the firewall, the server is specially ringfenced because the third-party application suppliers have access to it via PC Anywhere. Therefore the users have to access the server via the firewall, and therein lies the problem! Apparently the old firewall had this feature either disabled or set ludicrously high, but those responsible for the new firewall are unwilling to change the 60-minute default. Obviously they're being far more cautios about accumulating idle connections this time around! So we now have our solution choices - either someone makes the decision to up the timeout period, or the application vendors fix the app to issue a dummy query every so-many minutes of inactivity... or the users get used to logging in and out of the app when they need it, rather than leaving it running idle all day... It's now a political decision rather than a technical problem. A satisfactory end to the problem, which may well have not been the case without the input from this list, for which many thanks, particularly to Tim Onions, Paul Drake and Tim's resident firewall guru. Paul Vincent DBA University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Norris, Gregory T [ITS] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 setup on linux
Have you checked that it doesn't go to the router when you set localhost to the address of your eth0 adapter and that it does when you set it to 127.0.0.1? I would be very surprised if the default route was used to resolve route from lo0-eth0. When you do netstat -r, your LAN network address should be listed without a gateway. Gateway should be present only in the entry with your default route. If that's not so, then yes, you do have a problem with the network setup. On 01/12/2004 09:49:26 AM, Jesse, Rich wrote: I've set it before to prevent IP trips to the router for programs that use IP to talk to itself (like some backup programs that work over a network). But like I said, it's probably my lack of understanding of how proper networking is to be setup... :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, January 09, 2004 5:14 PM To: Multiple recipients of list ORACLE-L Rich, Before now, I've not heard of setting localhosts to the real IP address. I've only seen it aliased to loopback ( 127.0.0.1 ). Why would you do otherwise? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Yep.....it's a Monday......
Title: Yep.it's a Monday.. While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) 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
Re: Yep.....it's a Monday......
almost as good as the SAN CE coming in and instead of formatting the new SAN, format the existing one, wiping out OS/databases/redo logs, etc. joe Bobak, Mark wrote: While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) 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* -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yep.....it's a Monday......
Ew! Don't say that! The UPS guy is here replacing all the batteries (on bypass) and adding another bank, so we're un-UPS'd for a bit. Hopefully my unanswered Packer prayers transfer to today... Happy Monday! R2 Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Monday, January 12, 2004 10:44 AM To: Multiple recipients of list ORACLE-L While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time.Yeah, it's a Monday. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes.sighI have a feeling lunch will be a little late today... At least I wasn't the one who caused the crash.;-) 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 -- 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: Yep.....it's a Monday......
I had an SA do that to my 500G DW once, in the middle of the day. Took a few minutes to figure out why tablespaces were successively going offline... Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/12/2004 08:54 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Yep.it's a Monday.. almost as good as the SAN CE coming in and instead of formatting the new SAN, format the existing one, wiping out OS/databases/redo logs, etc. joe Bobak, Mark wrote: While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) 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* -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 BCV / SnapShot / SnapClone and the ALTER SYSTEM
Mladen/Hemant,
I should have expressed myself more clearly. Suspend is not necessary,
it's only fast. Basically, with suspend, you don't put tablespaces into
backup mode. You
suspend, resync, split and start aonther instance as if it crashed. As no
I/O is
going to disk, datafiles aren't fuzzy, so no recovery is needed. Problem
with this approach
is that the original instance is not usable during this time. All sessions
are hanging.
Benefit is that no recovery is needed and if everything goes OK, you're
done very, very
quickly. It's either-or approach, not a combination.
I think there is some confusion here... AFAIU (As Far As I Understand!),
(a) A tablespace, and thus related datafiles, need to be in Hot backup
mode during an *OS* based backup to cater for split-block inconsistency
(i.e. to cater for the possibility of a generally shorter OS block read NOT
getting the generally larger whole block in a single read just when the DB
block was being updated). The Logwriter then writes *whole* blocks to redo
to avoid this split-block (aka fractured block) problem. This increased redo
logging becomes an issue when backing up a large database (such as an ERP
database). EMC's BCVs, Hitachi's ShadowImage (and other frozen disk copy
technologies) mitigate this problem by providing a snapshot copy of *almost
point in time* sets of disks that contain a hot backup copy of the database.
Both rely on the fact that the subsequent backup is an *OS* based copy (i.e.
outside of Oracle) and that the *whole* database was placed in Hot backup.
The split actually takes a few minutes (or seconds, depending on how it was
done and the amount of activity), and the whole database is in Hot backup
mode *only* at that time. A SUSPEND may possiblly only _reduce_ this split
time. Once the split completes, the Database is taken out of Hot backup mode
and the BCVs/Images are then presented back tp the OS via normal mount so
that a subsequent OS based backup utility (such as Legato or Netbackup) can
back it up to tape. Subsequent 'snapshots' will also require the DB to be
placed in Hot backup mode..
In essence, this technology provides for a slow backup of a large database
that is apparently in hot backup mode without having excessive redo being
generated during the physical backup. A positive side effect is that the
Backup I/O goes against currently non-production disks. As well, these
copies can also be mounted on a backup server connected to the same SAN to
even avoid using production CPU cycles... This concept has remained the same
since V7, going into V8/8.1. and 9i as well, and I daresay it is the same in
10g. The key point is that placing the complete DB in Hot backup mode is a
*requirement* before a BCV/Image split, regardless of the usage of SUSPEND
(and the assumption that I/O is not going to disk at this time).
(b) OTOH, RMAN reads a database file and the blocks therein directly, and
does not need the tablespace to be in backup mode since the DB block is
being read by an *Oracle* process. And since there is no need to place a
database in backup mode, one can use RMAN to backup a large database without
worrying about the excessive redo issue. *However*, since the Oracle process
can read only from a 'live' datafile, RMAN _cannot_ be used with
BCV/ShadowImage. And placing an RMAN backed-up DB in SUSPEND mode will only
aggravate users :)
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-Original Message-
From: Hemant K Chitale [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 6:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM
Yes, I hadn't read the line
so the tablespaces had to be put into backup mode or (8i and
after) the
database had to be suspended
you _do_ have an OR between the backup mode and the database
.. suspended.
We hadn't heard of anyone using the SUSPEND and didn't want to
take the chance
of a database seeming to be frozen for a few seconds or upto
a minute
{weren't sure
how long the split would actually take to run before we
implemented it}.
We'll stick to putting the tablespaces in BACKUP mode.
Hemant
At 09:34 PM 09-01-04 -0800, you wrote:
I should have expressed myself more clearly. Suspend is not
necessary,
it's only fast. Basically,
with suspend, you don't put tablespaces into backup mode. You
suspend,
resync, split
and start aonther instance as if it crashed. As no I/O is
going to disk,
datafiles aren't
fuzzy, so no recovery is needed. Problem with this approach
is that the
original instance
is not usable during this time. All sessions are hanging.
Benefit is that
no recovery is
needed and if everything goes OK, you're done very, very
quickly. It's
either-or approach,
not a
SQL Server DBA Position
FYI - I'm forwarding this on Lisa's behalf. Please reply to [EMAIL PROTECTED] - Please do not reply to m Please do not reply to the list. - My employer, Fairfield Resorts (www.fairfieldresorts.com) is looking to hire a SQL Server DBA with several years' worth of experience. We are primarily an Oracle shop. It would be nice if this person had Oracle experience, but I don't think that's necessary. He is mostly interested in hiring an experienced SQL Server person. The office is in southern Orlando, FL, and I don't believe relo is included. However, as an employee the benefits are unparalleled. There are boxes and boxes of hardware in the hallway here this company is going to be expanding in the next year and I think it's going to be fun. This is a nice change from the last couple of years here! Resumes can be forwarded to me, I'll be sure my boss receives them. Lisa Koivu [EMAIL PROTECTED] Senior Database Administrator Cendant Timeshare Resort Group 8427 South Park Circle Orlando, FL 32819
RE: PART2 - Yep.....it's a Monday......
Title: Yep.it's a Monday.. My damager just DTS'ed a bunch of tables that are critical for ourweb apps to work back on themselves. When he set up the DTS he thought he was going from our production box to our test box but did the DTS from production to production. The problem was that he had the tables be deleted as the first part of the DTS. At least I know that my backups work. Had everything restored in about 15 minutes and the web sites are up and running. Yea, I know it is SQL Server but I have to deal with that also. At least he doesn't mess with my Oracle DB's. Any other Monday stories for today?? Dave -Original Message-From: Bobak, Mark [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Yep.it's a Monday.. While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) 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
Re: Yep.....it's a Monday......
I have to confess that I was the one who did it once. I was supposed to test a new UPS for a VAX 4200, but I forgot to turn the UPS on. UPS was supposed to send a shutdown command with 15 min. grace time, but when I flipped the switch, everything just died. I did that after 18:00 but I forgot that there were programmers trying to catch up with deadlines. To make the long story short, I almost got myself lynched. Fortunately, it was Friday, not Monday. Have you noticed how touchy people get when someone switches off the power? People should really be much more tolerant toward fellow human beings, even if they are sys admins. On 01/12/2004 12:14:35 PM, [EMAIL PROTECTED] wrote: I had an SA do that to my 500G DW once, in the middle of the day. Took a few minutes to figure out why tablespaces were successively going offline... Jared Joe Testa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/12/2004 08:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Yep.it's a Monday.. almost as good as the SAN CE coming in and instead of formatting the new SAN, format the existing one, wiping out OS/databases/redo logs, etc. joe Bobak, Mark wrote: While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time?..Yeah, it's a Monday?.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes?..sigh?.I have a feeling lunch will be a little late today??. At least I wasn't the one who caused the crash?..;-) 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* -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RE: Ideas to workaround view merge being disabled (Answer)
I see that I never replied to the list for the answer, as given by The Goddess herself. Rachel had me create a view of a view, putting the function in the outer view while retaining the fields from the DECODE in the inner view. The explain plan still isn't optimal, but now at least the view can be merged correctly and the 1M row table lookups now use an index. Thanks, Rachel! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Thursday, January 08, 2004 11:09 AM To: Multiple recipients of list ORACLE-L sigh stupid KVM hacking my mouse gets me again. Here's the *whole* message: Hey all, So, there I am on 8.1.7.4.0 creating some SQL suitable for a view: SELECT TS.username, TS.reportdate, TS.hours AS hours, DECODE(TD.description, NULL, SC.DESCRIPTION, TD.DESCRIPTION) AS TASK_DESCRIPTION, TEAM.teamtype AS TeamType, TS.productline, ST.SUBTASKID DEFECTID, ST.DESCRIPTION DEFECT_DESCRIPTION FROM T1 TS, T2 ST, T3 TD, TEAM , T5 SC WHERE TS.TASKID = TD.TASKID (+) AND TS.TEAMID = TEAM.TEAMID AND TS.WORKORDERNO = SC.WORKORDERNO (+) AND TS.operation = SC.OPERATIONNO (+) AND TS.TASKID = ST.TASKID (+); Works great, except when the view is created from this SQL because according to Metalink article 1030221.6, the DECODE function is preventing the view from being merged, causing an FTS on the T5 (SC) table. Of course, this table is near 1M rows and gets caught in an inner NL in the explain plan (cutting/pasting the explain plan doesn't seem to want to work in Windohs). The doc says the workaround is to move the DECODE outside the view. This won't work for us as the end-user is sigh MS Access. Anyone have an idea other than a RULE hint to get around this? TIA, Rich -- 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: PART2 - Yep.....it's a Monday......
Title: Yep.it's a Monday.. What the heck... Monday story from last week.. Low voltage guys were working under the raised floor in the datacenter to pull SAN cable and network cables. Upon getting to the patch panel (wrong one), they found no open ports on the Brocade Switch. so thinking that they had a little precedence, went ahead and unplugged a few:-) Took down a few servers and databases.. Now vendors dont have badges to the data center;-) greg -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: PART2 - Yep.it's a Monday.. My damager just DTS'ed a bunch of tables that are critical for ourweb apps to work back on themselves. When he set up the DTS he thought he was going from our production box to our test box but did the DTS from production to production. The problem was that he had the tables be deleted as the first part of the DTS. At least I know that my backups work. Had everything restored in about 15 minutes and the web sites are up and running. Yea, I know it is SQL Server but I have to deal with that also. At least he doesn't mess with my Oracle DB's. Any other Monday stories for today?? Dave -Original Message-From: Bobak, Mark [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 10:44 AMTo: Multiple recipients of list ORACLE-LSubject: Yep.it's a Monday.. While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time.Yeah, it's a Monday. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes.sighI have a feeling lunch will be a little late today... At least I wasn't the one who caused the crash.;-) 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
sql question
Hi List, I have following sql that runs in 1 sec: SELECT b.* FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) However, when I try to count above query as following, it hangs. Does someone have any ideas? SELECT count(b.award_number) FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) _ High-speed users—be more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 BCV / SnapShot / SnapClone and the ALTER SYSTEM
John, I know that fro RMAN tablespaces need not be in hot backup
mode. The trick with susspend is quick dirty way of achieving
the same effect as with the cold backup, without bringing the
database down. No RMAN involved.
On 01/12/2004 12:44:36 PM, John Kanagaraj wrote:
Mladen/Hemant,
I should have expressed myself more clearly. Suspend is not necessary,
it's only fast. Basically, with suspend, you don't put tablespaces into
backup mode. You
suspend, resync, split and start aonther instance as if it crashed. As no
I/O is
going to disk, datafiles aren't fuzzy, so no recovery is needed. Problem
with this approach
is that the original instance is not usable during this time. All sessions
are hanging.
Benefit is that no recovery is needed and if everything goes OK, you're
done very, very
quickly. It's either-or approach, not a combination.
I think there is some confusion here... AFAIU (As Far As I Understand!),
(a) A tablespace, and thus related datafiles, need to be in Hot backup
mode during an *OS* based backup to cater for split-block inconsistency
(i.e. to cater for the possibility of a generally shorter OS block read NOT
getting the generally larger whole block in a single read just when the DB
block was being updated). The Logwriter then writes *whole* blocks to redo
to avoid this split-block (aka fractured block) problem. This increased redo
logging becomes an issue when backing up a large database (such as an ERP
database). EMC's BCVs, Hitachi's ShadowImage (and other frozen disk copy
technologies) mitigate this problem by providing a snapshot copy of *almost
point in time* sets of disks that contain a hot backup copy of the database.
Both rely on the fact that the subsequent backup is an *OS* based copy (i.e.
outside of Oracle) and that the *whole* database was placed in Hot backup.
The split actually takes a few minutes (or seconds, depending on how it was
done and the amount of activity), and the whole database is in Hot backup
mode *only* at that time. A SUSPEND may possiblly only _reduce_ this split
time. Once the split completes, the Database is taken out of Hot backup mode
and the BCVs/Images are then presented back tp the OS via normal mount so
that a subsequent OS based backup utility (such as Legato or Netbackup) can
back it up to tape. Subsequent 'snapshots' will also require the DB to be
placed in Hot backup mode..
In essence, this technology provides for a slow backup of a large database
that is apparently in hot backup mode without having excessive redo being
generated during the physical backup. A positive side effect is that the
Backup I/O goes against currently non-production disks. As well, these
copies can also be mounted on a backup server connected to the same SAN to
even avoid using production CPU cycles... This concept has remained the same
since V7, going into V8/8.1. and 9i as well, and I daresay it is the same in
10g. The key point is that placing the complete DB in Hot backup mode is a
*requirement* before a BCV/Image split, regardless of the usage of SUSPEND
(and the assumption that I/O is not going to disk at this time).
(b) OTOH, RMAN reads a database file and the blocks therein directly, and
does not need the tablespace to be in backup mode since the DB block is
being read by an *Oracle* process. And since there is no need to place a
database in backup mode, one can use RMAN to backup a large database without
worrying about the excessive redo issue. *However*, since the Oracle process
can read only from a 'live' datafile, RMAN _cannot_ be used with
BCV/ShadowImage. And placing an RMAN backed-up DB in SUSPEND mode will only
aggravate users :)
John Kanagaraj
DB Soft Inc
Phone: 408-970-7002 (W)
Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
-Original Message-
From: Hemant K Chitale [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 10, 2004 6:34 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM
Yes, I hadn't read the line
so the tablespaces had to be put into backup mode or (8i and
after) the
database had to be suspended
you _do_ have an OR between the backup mode and the database
.. suspended.
We hadn't heard of anyone using the SUSPEND and didn't want to
take the chance
of a database seeming to be frozen for a few seconds or upto
a minute
{weren't sure
how long the split would actually take to run before we
implemented it}.
We'll stick to putting the tablespaces in BACKUP mode.
Hemant
At 09:34 PM 09-01-04 -0800, you wrote:
I should have expressed myself more clearly. Suspend is not
necessary,
it's only fast. Basically,
with suspend, you don't put tablespaces into backup mode. You
suspend,
resync, split
and start
RE: sql question
David - Can you post the EXPLAIN PLAN for both? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 12, 2004 1:14 PM To: Multiple recipients of list ORACLE-L Hi List, I have following sql that runs in 1 sec: SELECT b.* FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) However, when I try to count above query as following, it hangs. Does someone have any ideas? SELECT count(b.award_number) FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) _ High-speed users-be more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql question
Can you change it to this query: SELECT count(1) FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, January 12, 2004 3:04 PM David - Can you post the EXPLAIN PLAN for both? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 12, 2004 1:14 PM To: Multiple recipients of list ORACLE-L Hi List, I have following sql that runs in 1 sec: SELECT b.* FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) However, when I try to count above query as following, it hangs. Does someone have any ideas? SELECT count(b.award_number) FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) _ High-speed users-be more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: eric king INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sql question
That's fairly typical behavior. Try the following SELECT /*+ NO_MERGE(x) */ COUNT(*) FROM (your 1 second query) x Kevin -Original Message- Sent: Monday, January 12, 2004 2:14 PM To: Multiple recipients of list ORACLE-L Hi List, I have following sql that runs in 1 sec: SELECT b.* FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) However, when I try to count above query as following, it hangs. Does someone have any ideas? SELECT count(b.award_number) FROM RF_BALANCE_T b, rf_security_by_dceid s WHERE (s.award_number = 'ALL') OR (b.award_number = s.award_number AND s.project_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND s.task_number = 'ALL') OR (b.award_number = s.award_number AND b.project_number= s.project_number AND b.task_number = s.task_number) _ High-speed users-be more efficient online with the new MSN Premium Internet Software. http://join.msn.com/?pgmarket=en-uspage=byoa/premST=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: David Boyd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yep.....it's a Monday......
Title: Yep.it's a Monday.. Yeah, it is a Monday. Vendor shows up to "fix" a minor problem my day gets trashed. Oh well, job justification!! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Bobak, Mark [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: Yep.it's a Monday.. While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) 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
A STRANGE QUERY
Dear List, I have a very strange query: The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system. It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated.
RE:problems with dbms_sql w/ 9.2.0.4???
Title: Yep.it's a Monday.. Developer is saying functions are good - all functions referencing dbms_sql bomb??? Help??? problem with dbms_sql Compiling function FUN_CHANGE_PASSWORD... Compilation error on function FUN_CHANGE_PASSWORD: PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 23, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 24, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 25, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 26, column 7 Statement ignored -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Monday, January 12, 2004 3:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Yep.it's a Monday.. Yeah, it is a Monday. Vendor shows up to "fix" a minor problem my day gets trashed. Oh well, job justification!! Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Bobak, Mark [mailto:[EMAIL PROTECTED]Sent: Monday, January 12, 2004 11:44 AMTo: Multiple recipients of list ORACLE-LSubject: Yep.it's a Monday.. While doing some SAN work, one of our intrepid Sys Admins unplugged the wrong cable, crashing 20+ production databases at the same time..Yeah, it's a Monday.. So, here I sit, waiting, while they scramble around, re-connecting cables and re-booting boxes..sigh.I have a feeling lunch will be a little late today. At least I wasn't the one who caused the crash..;-) 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
RE: Should we stop analyzing?
Hi Richard Strangely, I've also never been to a management meeting where the reason for my attendance was to enquire as to how the instance efficiency statistics were this month. On the other hand when management reports take 3 days not 3 hours they're the first to complain. I wonder since we know all management is damagement and that DBAs know best if you could advise me how to explain efficiency ratios to them. Niall P.S. whilst the above is fictitious they do care about %utilisation of bandwidth but not response time from remote sites, God that irritates me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql question
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.
--{56703FBA-6707-4823-B54F-C1F79FFDC9D6}
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
DQoNCg0KDQpIaSBEYXZpZCwNCg0KRG9lcyB0aGUgZmlyc3QgcXVlcnkgInJ1biB0byBjb21wbGV0
aW9uIiBpbiAxIHNlY29uZCwgb3IgImJlZ2lucyByZXR1cm5pbmcNCnJlc3VsdHMiIGluIDEgc2Vj
b25kPz8/DQoNCklFOiBIYXZlIHlvdSBydW4gdGhlIHF1ZXJ5IGluIFNRTCpQbHVzIGFuZCB3YWl0
ZWQgZm9yIHRoZSBwcm9tcHQgdG8gcmV0dXJuPw0KSSBzdXNwZWN0IGl0IHdpbGwgc3Bvb2wgZm9y
IGEgd2hpbGUuDQoNClNvbWUgcHJvZ3JhbXMgKGxpa2UgVE9BRCBmb3IgZXhhbXBsZSkgYXBwZWFy
IHRvIGhhdmUgZmluaXNoZWQgdGhlIHF1ZXJ5IGFzDQpzb29uIGFzIHRoZSBmaXJzdCBwYWdlIG9m
IHJlc3VsdHMgYXJlIGluLCBidXQgd2hlbiB5b3Ugc2Nyb2xsIGRvd24gaXQNCnJlcXVlc3RzIG1v
cmUgcmVjb3JkcyBmcm9tIHRoZSBkYXRhYmFzZS4gIFNlbGVjdGluZyBDT1VOVCgqKSBjYW5ub3Qg
cmV0dXJuDQp1bnRpbCB0aGUgZW50aXJlIHNlYXJjaCBpcyBjb21wbGV0ZSBiZWNhdXNlIGl0IG5l
ZWRzIHRoZSB0b3RhbCBudW1iZXIuDQoNCklmIHRoZSBmaXJzdCBxdWVyeSBnZW51aW5lbHkgcnVu
cyB0byBjb21wbGV0aW9uIGluIDEgc2Vjb25kIHRob3VnaCwgdGhlbg0KcG9zdCB0aGUgZXhwbGFp
biBwbGFucyBhcyBzdWdnZXN0ZWQgYnkgRGVubmlzLiAgSSBzdXNwZWN0IHRob3VnaCB0aGF0IHlv
dQ0KYXJlIHNpbXBseSBtaXN1bmRlcnN0YW5kaW5nIHRoZSAxIHNlY29uZCByZXN1bHQuDQoNCklN
UE9SVEFOVCBTSURFIElTU1VFOg0KQWxzbywgbG9va2luZyBhdCB5b3VyIHF1ZXJ5IEkgc3VzcGVj
dCB5b3Ugd2lsbCBnZXQgYSBjYXJ0ZXNpYW4gam9pbiBpbiB0aGUNCmZpcnN0IHBhcnQgb2YgeW91
ciB3aGVyZSBjbGF1c2UgLSBGb3IgZWFjaCByZWNvcmQgaW4gInMiIHdoZXJlIGF3YXJkX251bWJl
cg0KPSAnQUxMJyB5b3Ugd2lsbCBnZXQgZXZlcnkgcm93IGZyb20gImIiIC0gYSBtYXNzaXZlIHJl
c3VsdCBzZXQgdGhhdA0KcHJvYmFibHkgZXhwbGFpbnMgeW91ciBsb25nIHJ1bm5pbmcgcXVlcnku
ICBTb21lb25lIGVsc2UgbWlnaHQgd2FudCB0bw0KY29uZmlybSBteSBzdXNwaWNpb24/ICBUaGUg
ZXhwbGFpbiBwbGFuIG1pZ2h0IGV2ZW4gaW5kaWNhdGUgdGhhdCBhDQpjYXJ0ZXNpYW4gam9pbiBp
cyBvY2N1cmluZywgYnV0IEknbSBub3Qgc3VyZSBiZWNhdXNlIG9mIHRoZSBvdGhlciBjbGF1c2Vz
Lg0KDQpSZWdhcmRzLA0KICAgICAgTWFyay4NCg0KDQoNCg0KICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAN
CiAgICAgICAgICAgICAgICAgICAgICAiRGF2aWQgQm95ZCIgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgPGRhdmlkYjE1OEBo
b3RtYWkgICAgICAgIFRvOiAgICAgICBNdWx0aXBsZSByZWNpcGllbnRzIG9mIGxpc3QgT1JBQ0xF
LUwgPE9SQUNMRS1MQGZhdGNpdHkuY29tPiAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAg
ICAgICAgICAgIGwuY29tPiAgICAgICAgICAgICAgICAgICBjYzogICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICBTZW50IGJ5OiAgICAgICAgICAgICAgICAg
U3ViamVjdDogIHNxbCBxdWVzdGlvbiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgbWwt
ZXJyb3JzQGZhdGNpdHkgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAg
ICAgICAgICAgICAgICAgICAgIC5jb20gICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgIA0KICAgICAgICAgICAgICAgICAgICAgIDEzLzAxLzIwMDQgMDY6MTQgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICBQbGVhc2Ug
cmVzcG9uZCB0byAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAgICAg
ICAgICAgICAgICAgICAgT1JBQ0xFLUwgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAg
RE: What do these error messages indicate and how to subscribe to developer mailgroup?
Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so that they cannot compile their procs referencing dbms_sql. Help? -Original Message- Sent: Monday, January 12, 2004 4:27 PM To: '[EMAIL PROTECTED]' to developer mailgroup? 1) Please tell me how to subscribe to Developer mailgroup? 2) Any ideas? Compiling function FUN_CHANGE_PASSWORD... Compilation error on function FUN_CHANGE_PASSWORD: PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 23, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 24, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 25, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 26, column 7 Statement ignored -- 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: Should we stop analyzing?
My explanation for that would be that it is all driven by beans. If manager learns that a resource is underutilized he/she immediately starts to plan to switch it for a smaller (i.e. cheaper) resource. Unless you can express performance in terms of beans it doesn't mean beans (so to speak) to them. At 02:19 PM 1/12/2004, you wrote: P.S. whilst the above is fictitious they do care about %utilisation of bandwidth but not response time from remote sites, God that irritates me. Author: Niall Litchfield INET: [EMAIL PROTECTED] Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Should we stop analyzing?
I'm sure that buffer cache hit ratio is still a big hit with the damagement. You should also compile dictionary cache hit ratio (v$rowcache) and library cache hit ratio. Damagement usually loves statistics, the more meaningless it is, the more they love it. On 01/12/2004 04:19:34 PM, Niall Litchfield wrote: Hi Richard Strangely, I've also never been to a management meeting where the reason for my attendance was to enquire as to how the instance efficiency statistics were this month. On the other hand when management reports take 3 days not 3 hours they're the first to complain. I wonder since we know all management is damagement and that DBAs know best if you could advise me how to explain efficiency ratios to them. Niall P.S. whilst the above is fictitious they do care about %utilisation of bandwidth but not response time from remote sites, God that irritates me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Re: A STRANGE QUERY
Even stranger is, that you expect us to solve your problem without knowing what exactly the problem is! Does your query consist of a SQL statement? Does it have an execution plan? Very strange, indeed. Tanel. Dear List, I have a very strange query: The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system. It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: A STRANGE QUERY
Dear system mamager, You have given very little to work from. Is the query a SELECT, UPDATE, INSERT or DELETE? Can you produce explain plans for the query on both systems? What made you consider disabling the primary key on production (this sounds like a bold / crazy move, but I wonder why you considered it)? Are data volumes anywhere near the same on production and test? Is the query something that is impacted heavily by data volume? Are both databases analyzed / have stats for all relevant objects? Regards, Mark. system manager [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: A STRANGE QUERY [EMAIL PROTECTED] .com 13/01/2004 07:54 Please respond to ORACLE-L Dear List, I have a very strange query: The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system. It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated. 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: What do these error messages indicate and how to subscribe to developer mailgroup?
Paula, did you try re-running catproc? Did your duhveloper follow the installation instructions to the letter, or creatively, skipping the parts he didn't like? On 01/12/2004 04:34:25 PM, [EMAIL PROTECTED] wrote: Developer is saying that applying patchset 9.2.0.4 broke dbms_sql or changed it so that they cannot compile their procs referencing dbms_sql. Help? -Original Message- Sent: Monday, January 12, 2004 4:27 PM To: '[EMAIL PROTECTED]' to developer mailgroup? 1) Please tell me how to subscribe to Developer mailgroup? 2) Any ideas? Compiling function FUN_CHANGE_PASSWORD... Compilation error on function FUN_CHANGE_PASSWORD: PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 23, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 24, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 25, column 7 Statement ignored PL/SQL ERROR 801 at line 1, column 1 internal error [1907] PL/SQL ERROR 0 at line 26, column 7 Statement ignored -- 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). -- 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: A STRANGE QUERY
On 01/12/2004 03:54:27 PM, system manager wrote: Dear List, I have a very strange query: The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system. It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated. Can you translate the word paused into a wait event? What is the session waiting for? Did you look into V$SESSION_WAIT? Is there any difference in the execution plans? Just a word of advice, disabling the primary key is usually not a good idea, because it might help you with distinguishing one record from another. Without the primary key it's much harder to tell records apart. -- 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).
why would enable constraint cause a delete to wait on library cache lock?
I am only an egg, so I hope someone else can explain this to me. Oracle Enterprise Edition 8.1.7.4.1 on Windows 2000 I was experimenting to see if an alter table enable validate constraint would cause DML statements to wait. I thought it wouldn't. But in real life I see something different. I have a table X (object_id 429995) with about 100 million rows. In one session (sid 15) I enable a check constraint, and in another session (sid 14) I simultaneously delete a few rows from the table. The delete waits on the enable constraint to complete, and it's waiting on a library cache lock. Why would that be? At the end of this e-mail you can see the contents of DBA_LOCKS, V$LOCKED_OBJECT, V$SESSION_WAIT. I read the system state dump and I still don't understand why there would be a library cache lock. Session ID 15 --- sid-15-SQL1 alter table hes_a_keeper.many_rows add (constraint ck1 check (dummy_column 'B') disable) ; --- sid-15-SQL2 (simultaneous with sid-14-SQL1) alter table hes_a_keeper.many_rows enable validate constraint ck1 ; Session ID 14 --- sid-14-SQL1 (simultaneous with sid-15-SQL2) delete from hes_a_keeper.many_rows where rownum 10 ; Session ID 10 --- statements issued while sid-14-SQL1 and sid-15-SQL2 are running alter session set events 'immediate trace name systemstate level 10' ; select * from dba_locks where session_id in (14,15) ; select * from v$locked_object where object_id = 429995 ; select * from v$session_wait where sid in (14,15) ; SQL select * from dba_locks where session_id in (14,15) ; SESSION_ID LOCK_TYPE MODE_HELD -- -- MODE_REQUESTED LOCK_ID1 LOCK_ID2 LAST_CONVERT BLOCKING_OTHERS 15 DMLShare None 429995 0 10 Not Blocking SQL select * from v$locked_object where object_id = 429995 ; XIDUSN XIDSLOTXIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME - - - - -- -- OS_USER_NAME PROCESS LOCKED_MODE -- - --- 0 0 0429995 15 JRK jkilchoe 1540:2604 SQL select * from v$session_wait where sid in (14,15) ; SID SEQ# EVENT - - P1TEXT P1 P1RAW - P2TEXT P2 P2RAW - P3TEXT P3 P3RAW WAIT_TIME - - SECONDS_IN_WAIT STATE --- --- 15 5005 db file scattered read file# 13 000D block# 19516 4C3C blocks 8 0008 0 0 WAITING 14 142 library cache lock handle address47483828 02D48BB4 lock address 40114204 0264181C 10*mode+namespace 21 0015 0 9 WAITING SQL -- 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).
Re: why would enable constraint cause a delete to wait on library cache lock?
Did you loon into v$lock? V$LOCK has columns REQUEST and LMODE and it would tell you the mode of the lock imposed by alter table. I would guess that enable validate would briefly impose a shared lock on the whole table. On 01/12/2004 05:29:25 PM, Jacques Kilchoer wrote: I am only an egg, so I hope someone else can explain this to me. Oracle Enterprise Edition 8.1.7.4.1 on Windows 2000 I was experimenting to see if an alter table enable validate constraint would cause DML statements to wait. I thought it wouldn't. But in real life I see something different. I have a table X (object_id 429995) with about 100 million rows. In one session (sid 15) I enable a check constraint, and in another session (sid 14) I simultaneously delete a few rows from the table. The delete waits on the enable constraint to complete, and it's waiting on a library cache lock. Why would that be? At the end of this e-mail you can see the contents of DBA_LOCKS, V$LOCKED_OBJECT, V$SESSION_WAIT. I read the system state dump and I still don't understand why there would be a library cache lock. Session ID 15 --- sid-15-SQL1 alter table hes_a_keeper.many_rows add (constraint ck1 check (dummy_column 'B') disable) ; --- sid-15-SQL2 (simultaneous with sid-14-SQL1) alter table hes_a_keeper.many_rows enable validate constraint ck1 ; Session ID 14 --- sid-14-SQL1 (simultaneous with sid-15-SQL2) delete from hes_a_keeper.many_rows where rownum 10 ; Session ID 10 --- statements issued while sid-14-SQL1 and sid-15-SQL2 are running alter session set events 'immediate trace name systemstate level 10' ; select * from dba_locks where session_id in (14,15) ; select * from v$locked_object where object_id = 429995 ; select * from v$session_wait where sid in (14,15) ; SQL select * from dba_locks where session_id in (14,15) ; SESSION_ID LOCK_TYPE MODE_HELD -- -- MODE_REQUESTED LOCK_ID1 LOCK_ID2 LAST_CONVERT BLOCKING_OTHERS 15 DMLShare None 429995 0 10 Not Blocking SQL select * from v$locked_object where object_id = 429995 ; XIDUSN XIDSLOTXIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME - - - - -- -- OS_USER_NAME PROCESS LOCKED_MODE -- - --- 0 0 0429995 15 JRK jkilchoe 1540:2604 SQL select * from v$session_wait where sid in (14,15) ; SID SEQ# EVENT - - P1TEXT P1 P1RAW - P2TEXT P2 P2RAW - P3TEXT P3 P3RAW WAIT_TIME - - SECONDS_IN_WAIT STATE --- --- 15 5005 db file scattered read file# 13 000D block# 19516 4C3C blocks 8 0008 0 0 WAITING 14 142 library cache lock handle address47483828 02D48BB4 lock address 40114204 0264181C 10*mode+namespace 21 0015 0 9 WAITING SQL -- 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).
Re:Re: A STRANGE QUERY
It is not an expensive query.It runs really fast without the primary key in production but we dont have this problem in the test instance. -- Original Message Date: Mon, 12 Jan 2004 14:04:42 -0800 Even stranger is, that you expect us to solve your problem without knowing what exactly the problem is! Does your query consist of a SQL statement? Does it have an execution plan? Very strange, indeed. Tanel. Dear List, I have a very strange query: The table, data, indexes, constraints are set up exactly same The query was running ok in the test database but paused the production system. It is also running ok in production if the primary key disabled. Any ideas? Any input will be greatly appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: system manager INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: why would enable constraint cause a delete to wait on library cache lock?
You should first enable novalidate the constraint and then run enable validate. This way Oracle knows that any *new* DML can't invalidate data and can calmly scan through the table without locking it, to see whether the rest of the data is valid as well. Another reason for blocking locks that I can think of, is when enabling primary/unique key constraints and you don't have an index to support it. Then it even doesn't matter whether you're enabling validate or novalidate. One should build an index with online option first in order to reduce lock holding times. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM lock? I am only an egg, so I hope someone else can explain this to me. Oracle Enterprise Edition 8.1.7.4.1 on Windows 2000 I was experimenting to see if an alter table enable validate constraint would cause DML statements to wait. I thought it wouldn't. But in real life I see something different. I have a table X (object_id 429995) with about 100 million rows. In one session (sid 15) I enable a check constraint, and in another session (sid 14) I simultaneously delete a few rows from the table. The delete waits on the enable constraint to complete, and it's waiting on a library cache lock. Why would that be? At the end of this e-mail you can see the contents of DBA_LOCKS, V$LOCKED_OBJECT, V$SESSION_WAIT. I read the system state dump and I still don't understand why there would be a library cache lock. Session ID 15 --- sid-15-SQL1 alter table hes_a_keeper.many_rows add (constraint ck1 check (dummy_column 'B') disable) ; --- sid-15-SQL2 (simultaneous with sid-14-SQL1) alter table hes_a_keeper.many_rows enable validate constraint ck1 ; Session ID 14 --- sid-14-SQL1 (simultaneous with sid-15-SQL2) delete from hes_a_keeper.many_rows where rownum 10 ; Session ID 10 --- statements issued while sid-14-SQL1 and sid-15-SQL2 are running alter session set events 'immediate trace name systemstate level 10' ; select * from dba_locks where session_id in (14,15) ; select * from v$locked_object where object_id = 429995 ; select * from v$session_wait where sid in (14,15) ; SQL select * from dba_locks where session_id in (14,15) ; SESSION_ID LOCK_TYPE MODE_HELD -- -- MODE_REQUESTED LOCK_ID1 - --- LOCK_ID2 LAST_CONVERT BLOCKING_OTHERS 15 DMLShare None 429995 0 10 Not Blocking SQL select * from v$locked_object where object_id = 429995 ; XIDUSN XIDSLOTXIDSQN OBJECT_ID SESSION_ID ORACLE_USERNAME - - - - -- --- --- OS_USER_NAME PROCESS LOCKED_MODE -- - --- 0 0 0429995 15 JRK jkilchoe 1540:2604 SQL select * from v$session_wait where sid in (14,15) ; SID SEQ# EVENT - - -- -- P1TEXT P1 P1RAW - P2TEXT P2 P2RAW - P3TEXT P3 P3RAWWAIT_TIME - - SECONDS_IN_WAIT STATE --- --- 15 5005 db file scattered read file# 13 000D block# 19516 4C3C blocks 8 0008 0 0 WAITING 14 142 library cache lock handle address47483828 02D48BB4 lock address 40114204 0264181C 10*mode+namespace 21 0015 0 9 WAITING SQL -- 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
** OCP for 9i requirements
Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University.What is the minimum? Is any small course good enough?Can someone who has gone through this provide details? Thank you Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
RE: re BCV / SnapShot / SnapClone and the ALTER SYSTEM
Mladen, I apologize - I didn't want to imply that you were not aware of the way RMAN works. However, I am not sure I got my point across on the Hot backup issue, so here goes... You should not take a backup of a BCV mirror _without_ putting the whole database in Hot backup, even if you suspend all I/O using SUSPEND. AFAIK, the SUSPEND command was provided to enable an 'instance recoverable' database copy and NOT a day-to-day backup copy. In other words, a copy taken after a successful SUSPEND can be restored and started up, in which case an _instance_ recovery is done. The issue is that you cannot perform _media_ recovery to this copy to bring it up a particular point in time, which is the whole point of a backup... The way I see it, a DBA can use the SUSPEND command to backup a Development/Test database, which would not demand a point-in-time recovery requirement but require a end-of-day backup without having to shut it down. The other use of couse is to reduce or even eliminate IO activity to the BCV while the split occcurs. The split can take quite a while to complete if a session performs heavy writing - a Hash join writing to TEMP can very quickly overwhelme the Write cache of a SAN and delay the split. I found ML Note:91059.1 useful in understanding the SUSPEND command... 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: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Monday, January 12, 2004 11:34 AM To: Multiple recipients of list ORACLE-L Subject: Re: re BCV / SnapShot / SnapClone and the ALTER SYSTEM John, I know that fro RMAN tablespaces need not be in hot backup mode. The trick with susspend is quick dirty way of achieving the same effect as with the cold backup, without bringing the database down. No RMAN involved. -- 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: ** OCP for 9i requirements
www.oracle.com do a search for certification. Its all explained there. You can take an online course for $300. If your company is an oracle partner the course is free. - Original Message - From: A Joshi To: Multiple recipients of list ORACLE-L Sent: Monday, January 12, 2004 7:34 PM Subject: ** OCP for 9i requirements Hi, For taking Oracle9i OCP exam is it necessary to have attended a Oracle course by Oracle University.What is the minimum? Is any small course good enough?Can someone who has gone through this provide details? Thank you Do you Yahoo!?Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
Re: sql question (RESEND)
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.
--{E9F68FD4-42A7-47CE-A4DD-84FB99CBBCFE}
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: base64
DQoNCg0KDQpTb3JyeSBpZiB0aGlzIGFycml2ZXMgdHdpY2UgLSBJIHNlbnQgaXQgc2V2ZXJhbCBo
b3VycyBhZ28gYW5kIG5ldmVyIHNhdyBpdA0KYXBwZWFyIGV2ZW4gdGhvdWdoIG1lc3NhZ2VzIEkg
cG9zdGVkIGxhdGVyIGFwcGVhcmVkIHZlcnkgZmFzdC4NCg0KDQoNCiAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgDQogICAgICAgICAgICAgICAgICAgICAgTWFyayBSaWNoYXJkICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICBUbzogICAgICBPUkFDTEUtTEBmYXRjaXR5LmNvbSAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAg
ICAgICAgICAgICAgICAxMy8wMS8yMDA0IDA4OjMwICAgICAgICAgY2M6ICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgDQogICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgIFN1YmplY3Q6IFJlOiBzcWwgcXVlc3Rpb24oRG9jdW1lbnQgbGluazogTWFyayBSaWNoYXJk
KSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAN
Cg0KDQoNCkhpIERhdmlkLA0KDQpEb2VzIHRoZSBmaXJzdCBxdWVyeSAicnVuIHRvIGNvbXBsZXRp
b24iIGluIDEgc2Vjb25kLCBvciAiYmVnaW5zIHJldHVybmluZw0KcmVzdWx0cyIgaW4gMSBzZWNv
bmQ/Pz8NCg0KSUU6IEhhdmUgeW91IHJ1biB0aGUgcXVlcnkgaW4gU1FMKlBsdXMgYW5kIHdhaXRl
ZCBmb3IgdGhlIHByb21wdCB0byByZXR1cm4/DQpJIHN1c3BlY3QgaXQgd2lsbCBzcG9vbCBmb3Ig
YSB3aGlsZS4NCg0KU29tZSBwcm9ncmFtcyAobGlrZSBUT0FEIGZvciBleGFtcGxlKSBhcHBlYXIg
dG8gaGF2ZSBmaW5pc2hlZCB0aGUgcXVlcnkgYXMNCnNvb24gYXMgdGhlIGZpcnN0IHBhZ2Ugb2Yg
cmVzdWx0cyBhcmUgaW4sIGJ1dCB3aGVuIHlvdSBzY3JvbGwgZG93biBpdA0KcmVxdWVzdHMgbW9y
ZSByZWNvcmRzIGZyb20gdGhlIGRhdGFiYXNlLiAgU2VsZWN0aW5nIENPVU5UKCopIGNhbm5vdCBy
ZXR1cm4NCnVudGlsIHRoZSBlbnRpcmUgc2VhcmNoIGlzIGNvbXBsZXRlIGJlY2F1c2UgaXQgbmVl
ZHMgdGhlIHRvdGFsIG51bWJlci4NCg0KSWYgdGhlIGZpcnN0IHF1ZXJ5IGdlbnVpbmVseSBydW5z
IHRvIGNvbXBsZXRpb24gaW4gMSBzZWNvbmQgdGhvdWdoLCB0aGVuDQpwb3N0IHRoZSBleHBsYWlu
IHBsYW5zIGFzIHN1Z2dlc3RlZCBieSBEZW5uaXMuICBJIHN1c3BlY3QgdGhvdWdoIHRoYXQgeW91
DQphcmUgc2ltcGx5IG1pc3VuZGVyc3RhbmRpbmcgdGhlIDEgc2Vjb25kIHJlc3VsdC4NCg0KSU1Q
T1JUQU5UIFNJREUgSVNTVUU6DQpBbHNvLCBsb29raW5nIGF0IHlvdXIgcXVlcnkgSSBzdXNwZWN0
IHlvdSB3aWxsIGdldCBhIGNhcnRlc2lhbiBqb2luIGluIHRoZQ0KZmlyc3QgcGFydCBvZiB5b3Vy
IHdoZXJlIGNsYXVzZSAtIEZvciBlYWNoIHJlY29yZCBpbiAicyIgd2hlcmUgYXdhcmRfbnVtYmVy
DQo9ICdBTEwnIHlvdSB3aWxsIGdldCBldmVyeSByb3cgZnJvbSAiYiIgLSBhIG1hc3NpdmUgcmVz
dWx0IHNldCB0aGF0DQpwcm9iYWJseSBleHBsYWlucyB5b3VyIGxvbmcgcnVubmluZyBxdWVyeS4g
IFNvbWVvbmUgZWxzZSBtaWdodCB3YW50IHRvDQpjb25maXJtIG15IHN1c3BpY2lvbj8gIFRoZSBl
eHBsYWluIHBsYW4gbWlnaHQgZXZlbiBpbmRpY2F0ZSB0aGF0IGENCmNhcnRlc2lhbiBqb2luIGlz
IG9jY3VyaW5nLCBidXQgSSdtIG5vdCBzdXJlIGJlY2F1c2Ugb2YgdGhlIG90aGVyIGNsYXVzZXMu
DQoNClJlZ2FyZHMsDQogICAgICBNYXJrLg0KDQoNCg0KDQogICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIA0K
ICAgICAgICAgICAgICAgICAgICAgICJEYXZpZCBCb3lkIiAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICA8ZGF2aWRiMTU4QGhv
dG1haSAgICAgICAgVG86ICAgICAgIE11bHRpcGxlIHJlY2lwaWVudHMgb2YgbGlzdCBPUkFDTEUt
TCA8T1JBQ0xFLUxAZmF0Y2l0eS5jb20+ICAgICAgICAgICAgICAgICAgDQogICAgICAgICAgICAg
ICAgICAgICAgbC5jb20+ICAgICAgICAgICAgICAgICAgIGNjOiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgIA0KICAgICAgICAgICAgICAgICAgICAgIFNlbnQgYnk6ICAgICAgICAgICAgICAgICBT
dWJqZWN0OiAgc3FsIHF1ZXN0aW9uICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICANCiAgICAgICAgICAgICAgICAgICAgICBtbC1l
cnJvcnNAZmF0Y2l0eSAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgDQogICAg
Cold Fusion and Bind Variables
Dear List, We have a developer here that is pretty good with the web stuff, but his strong suit is not databases, or at least not Oracle. He develops primarily in Cold Fusion, which I know little about. I'm trying to teach him the difference between literal and bind variables, and the importance of knowing the difference. While it is easy to demonstrate this in PL/SQL or Perl, I have no idea how to do so in CF. A few minutes of googling didn't really turn up anything useful. I'm looking for some examples of using bind variables in SQL as used in Cold Fusion that connects to Oracle 8i. If you have one, the virtual beer is on me. :) Jared
test
test... We have been having mail problems. Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional Transit Authority1240 W. 6th StreetCleveland, Ohio 44113
Re: test
--- Jeffrey Beckstrom [EMAIL PROTECTED] wrote: test... We have been having mail problems. Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 yeah, I had 2 posts not go through today ... unless I'm blocking my own posts. mmm, could be ... Pd __ 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: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Disk capacity planning
Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel
