RE: How to take sql*loader trace
That is why my advice was 10046 trace name context forever, level 8, not SQL_TRACE. With 10046, level 8 you can still get waits (tkprof in 9i understands them). You cannot Get explain plan because direct path doesn't use SQL to insert into the database. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 11, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Senthil Are you using direct-path loader? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Hi All, I'm loading a set of data into one of my schema. And wanted to take the trace files also. I tried the follwoing. 1. Identified the sid,serila# for the sql*loader session. 2. used the follwoing, exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE); but this is not generation any trace files. But if I trun my system to sql_trace=TRUE, I'm able to collect the trace details. I don't want to do this. I want to take the trace only for the sql*loader session. How do i do that. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
High availability and real time data warehosuing
Hi I was wundering if any of your shops are using High avaliability solutions . 1)Can you tell me how these solutions like datamirror are superior to oracle9i RAC ? 2)Has anybody implemented real time data warehousing solution ?If so what were the enabling technologies used like 1)Java Messaging servcies 2)Mq series 3)Oracle streams 3)Has anybody implemented oracle 9i datagaurd what has been your experinces so far regards Hrishy Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://uk.messenger.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?hrishy?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OT : Learning curve
I second the recommendation to buy and read Tufte's books, whether you're the creator of graphic communication, or just the victim of it. When I was at Oracle management meetings, you could always tell the groups that were underperforming financially. They had the most complicated charts. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Jared Still Sent: Wednesday, August 06, 2003 11:09 AM To: Multiple recipients of list ORACLE-L I have two or three of Tuftes more well known books. For anyone that creates presentations with graphics, these are a must have. For anyone that feels stupid because they can't understand someone else's charts in an power-point presentation, these are a must have. Hint: It ain't you. It's terribly ironic that the most informative and easy to understand chart ever created was drawn by hand in the 19th century. I apologize for the somewhat OT nature of this reply, but as most of us are in IT, we are subjected to meaningless charts with alarming regularity. Jared On Wed, 2003-08-06 at 03:59, Stephane Faroult wrote: I stumbled by chance into the following article http://www.norvig.com/21-days.html which, without being in anyway related to Oracle, will probably ring familiar bells - and what it says about programming could probably be said about administration as well. By the way (and still more OT) I came to this site because of the PowerPoint 'Gettysburgh address' and I was brought there by a reference on Edward Tufte's site (http://www.edwardtufte.com), all of them worth a look if you have imports or installations to run. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to take sql*loader trace
Mladen Yes, when I saw your posting, I assumed that was what you were getting at. I'll have to remember this one if I have trouble with a SQL*Loader session. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 10:34 AM To: Multiple recipients of list ORACLE-L That is why my advice was 10046 trace name context forever, level 8, not SQL_TRACE. With 10046, level 8 you can still get waits (tkprof in 9i understands them). You cannot Get explain plan because direct path doesn't use SQL to insert into the database. -- Mladen Gogala Oracle DBA -Original Message- DENNIS WILLIAMS Sent: Monday, August 11, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Senthil Are you using direct-path loader? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 9:39 AM To: Multiple recipients of list ORACLE-L Hi All, I'm loading a set of data into one of my schema. And wanted to take the trace files also. I tried the follwoing. 1. Identified the sid,serila# for the sql*loader session. 2. used the follwoing, exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE); but this is not generation any trace files. But if I trun my system to sql_trace=TRUE, I'm able to collect the trace details. I don't want to do this. I want to take the trace only for the sql*loader session. How do i do that. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
Re: RE: quick suggestions for tuning ?
Thanks a lot Millsap,Stephane Faroult,Jared Still,Wolfgang,Tanel and Dennis for your pointers and suggestions. I owe a lot to you Oracle Gurus. A novice DBA like me is ever grateful to this wonderful list. I love this list. Thanks once again. Jp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Antw: Take an Oracle 8.1 export file back to an Oracle 7.1
You could load the 7.1 exp on the 8.1 server and export then import on 7.1 server Rick |-+ | | Guido Konsolke | | | [EMAIL PROTECTED]| | | nkrupp.com | | | Sent by: [EMAIL PROTECTED] | | || | || | | 08/07/2003 01:34 PM | | | Please respond to ORACLE-L | | || |-+ --| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: Antw: Take an Oracle 8.1 export file back to an Oracle 7.1 | --| Hi David, no, not possible to my knowledge. You have to use the 7.1 exp against the 8.1 server. That's what they all say. If anyone knows better, I would be glad to hear from him. Greetings, Guido [EMAIL PROTECTED] 07.08.2003 19.14 Uhr Hi all Is it possible to take an Oracle Version 8.1 database export file and load it into an Oracle Version 7.1 database? The export file of the 8.1 is on a different machine than the 7.1 database. If I can not is there some other method I can use to get the data from the 8.1 export file to the 7.1 database. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Take an Oracle 8.1 export file back to an Oracle 7.1 database.
Title: Take an Oracle 8.1 export file back to an Oracle 7.1 database. Hi all Is it possible to take an Oracle Version 8.1 database export file and load it into an Oracle Version 7.1 database? The export file of the 8.1 is on a different machine than the 7.1 database. If I can not is there some other method I can use to get the data from the 8.1 export file to the 7.1 database. Thanks David
RE: UNDO Tablespace
The answer for this from our vendor is to increase the size of the UNDO based on their DBAs statement that UNDO is consumed rapidly because every query makes a physical copy of all tables and holds on to them for the retention period. Sherrie, In my considered opinion: Woohoohoohoo. That's a ridiculous thing for a DBA to say. I hope he was misinterpreted somewhere down the line because otherwise he's got a very flimsy grasp of the read-consistency model. In very simple terms Undo is used to hold a copy of any changed data (not the whole table!) which has not been committed and flushed to the datafiles. While it's there the data for an update transaction is available a) to the 'owning' transaction in case it has to ROLLBACK the updates it's made. b) to any other transactions which need to reconstruct the data as it was before the update began. On a more positive note I agree that we need the text of the error message in order to give some help. Cheers, Mike - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 4:39 PM I have a 2gb UNDO tablespace. A third-party application continually runs out of UNDO when it joins two tables to produce a result table. Our retention time is set to 15 minutes, the NoSpaceErrCnt in V$UNDOSTAT is always zero. The answer for this from our vendor is to increase the size of the UNDO based on their DBAs statement that UNDO is consumed rapidly because every query makes a physical copy of all tables and holds on to them for the retention period. I can find nothing that discusses exactly how UNDO physically works, and am not sure that this can be true. That would mean that every user querying our database would have copies of the tables in the UNDO, and I'd need about a gazillion gb to handle that. Does anyone have any insights on how the UNDO physically works? --- Sherrie Kubis Southwest Florida Water Management District 2379 Broad Street Brooksville FL 34604-6899 E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: URGENT: Trying to duplicate database from cold backup - auxi
BTW, I just waited till afterhours brought the database down, copied the file and cloned the easy way. I love RMAN, but truth be told, I still find the old manual method of cloning a database to be easier somehow. Must be an old fogie. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Limits on PL/SQL block?
-Original Message- From: Rudy Zung [mailto:[EMAIL PROTECTED] I'm seeing a PLS-00123 program too large error. Oracle's documentation says that the actual limit on the size of the block is dependant on the mix of statements in the PL/SQL block. Does anyone know how Oracle determines this limit? Is it a pure size of PL/SQL block in bytes, or is it number of unique statements in the block, or is it dependant on how much redo that the block may generate? I asked a question about the maximum trigger size on Metalink recently (the 9.2 documentation said that the maximum trigger size is 32K). Short answer - the easiest way to tell if a PL/SQL block is too big: try it and see if you get an error. Here is the full answer from Oracle: The limit of 32k for a trigger is platform dependent. The 32K limit is set taking into account the limit of 64K DIANA Nodes which includes the m-code and parsed-code. You may therefore end up having larger source code if the parsed-code ends up being lesser than the source code. In the shared pool, a package spec, object type spec, stand-alone subprogram, or anonymous block is limited to 64K DIANA nodes. The nodes correspond to tokens such as identifiers, keywords, operators, and so on. The m-code is limited to 64K compiler-generated temporary variables. Unfortunately, you cannot estimate the number of DIANA nodes from the parsed size. Two program units with the same parsed size might require 1500 and 2000 DIANA nodes, respectively (because, for example, the second unit contains more complex SQL statements). When a PL/SQL block, subprogram, package, or object type exceeds a size limit, you get an error such as program too large. Typically, this problem occurs with packages or anonymous blocks. With a package, the best solution is to divide it into smaller packages. With an anonymous block, the best solution is to redefine it as a group of subprograms, which can be stored in the database. You can query the user_object_size table on the database to find out the size of the procedure/package/plsql block. -- 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: Record breaking query
Title: RE: Record breaking query I have seen the time for wait_events in 8.1 do funny things when the system date was changed by ntp. Oracle assumes that end time is after start time for each wait event, if this is not the case due to the system clock being changed, you get a BIG number. Every time this happened to us, our firewall (which is the ntp server for all of our other machines) had been rebooted and we saw an ntp event in the system log file. However, we were never able to reproduce this manually. --Michael Brown Glen Raven, Inc./Info ServicesSenior Oracle DBA 1831 N. Park AvePhone: (336)586-1146 Glen Raven, NC 27217Fax: (336)586-1382 [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Friday, August 08, 2003 5:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Record breaking query Thanks Wolfgang, our retention time is 21600 seconds ... and this one bailed out in half the time ... Oh well ... we need to fix few more things .. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 5:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: Record breaking query I know what the message says. Do you believe everything you see printed? Or expressing is differently: how many error/diagnostics messages have you seen that are more misleading than helpful. At 01:24 PM 8/8/2003 -0800, you wrote: but message says it is in seconds ... anf yes it is 92 ... Thanks Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Wolfgang Breitling [mailto:[EMAIL PROTECTED]mailto:[EMAIL PROTECTED]] Sent: Friday, August 08, 2003 4:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Record breaking query Is that an Oracle 9 system and the time is in microseconds rather than seconds? At 10:39 AM 8/8/2003 -0800, you wrote: Yeah, but think of the uptime! One helluva MTBF on that server... Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- Sent: Friday, August 08, 2003 12:49 PM To: Multiple recipients of list ORACLE-L TICK : Fri Aug 8 09:06:03 2003 SEARCH in kdisti: tsn = 5, objd = 83525, rdba = 33588489 ORA-01555 caused by SQL statement below (Query Duration=1060347963 sec, SCN: 0x0011.05e003c2): TICK : Fri Aug 8 09:06:03 2003 SELECT VOBJID, VNAME, VTEXT, VLEN, VOWNER, VOWNERID, VAUDIT, VCOMMENT, VCNAME, PROPERTY, DEFER, FLAGS, OIDLEN, OIDCLAUSE, TYPEOWNER, TYPENAME, UNDERLEN, UNDERCLAUSE FROM SYS.EXU8VEW WHERE VOWNERID != :"SYS_B_0" ORDER BY VLEVEL, VOWNER, VOBJID according to this error message this query has been running for close to 33 years. appears to be a export running for 33 years. I am clusless Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.nethttp://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comhttp://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.comhttp://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.nethttp://www.orafaq.net -- Author: Wolfgang Breitling INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.comhttp://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send
tables and views
How to diiferentiate views and tables in all_tables and all_tab_columns . which column and what criteria can return only tables ?? -ak
RE: Hot Backup
Just use rman, it comes with your Oracle RDBMS and has a whole book of documentaion. Rut5h -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Oracle DBA Sent: Tuesday, August 12, 2003 9:29 AM To: Multiple recipients of list ORACLE-L Subject: Hot Backup Hi List Does anyone have sample hot backup script for solaris env? If so could you please share with me in offline? Thanks Sami __ Do you Yahoo!? The New Yahoo! Search - Faster. Easier. Bingo. http://search.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Capacity Planning Methods?
OK, I'll post it. Salt to taste or toss it in the garbage. Note that this is just collecting data and doesn't make any recommendations or such. Comments and critiques welcome, except from Mladen... (running for cover) ;) And, of course, standard disclaimers apply! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- CREATE TABLE TS_ACTIVITY ( TABLESPACE_NAME VARCHAR2(30), FREE_SPACE NUMBER, USED_SPACE NUMBER, MAX_FREE_SPACE NUMBER, TIMESTAMPDATE ) TABLESPACE USERS / COMMENT ON TABLE TS_ACTIVITY IS 'Tablespace Activity: Records changes in physical attributes of all permanent, dictionary-managed tablespaces.' / CREATE INDEX TS_ACTIVITY_TS_NAME ON TS_ACTIVITY (TABLESPACE_NAME) TABLESPACE USERS / CREATE OR REPLACE PROCEDURE TS_CHECK IS -- -- Explicit SELECT access must be granted to this schema on the following SYS views: -- -- DBA_TABLESPACES -- DBA_DATA_FILES -- DBA_FREE_SPACE -- -- Modification History -- - -- 12/19/2001 REJ Created. v_tablespace_name ts_activity.tablespace_name%TYPE; v_free_spacets_activity.free_space%TYPE; v_used_spacets_activity.used_space%TYPE; v_max_free_spacets_activity.max_free_space%TYPE; v_rowcount NUMBER; CURSOR C_TS IS SELECT d.tablespace_name, f.bytes FREE_SPACE, NVL(a.bytes - NVL(f.bytes, 0), 0) USED_SPACE, f.max_free_space FROM sys.dba_tablespaces d, (SELECT tablespace_name, SUM(bytes) bytes FROM dba_data_files GROUP BY tablespace_name) a, (SELECT tablespace_name, SUM(bytes) bytes, MAX(bytes) max_free_space FROM dba_free_space GROUP BY tablespace_name) f WHERE d.tablespace_name = a.tablespace_name(+) AND d.tablespace_name = f.tablespace_name(+) AND d.contents = 'PERMANENT'; BEGIN FOR tsrec IN C_TS LOOP SELECT COUNT(*) INTO v_rowcount FROM ts_activity WHERE tablespace_name = tsrec.tablespace_name; IF v_rowcount 0 THEN SELECT q.tablespace_name, q.free_space, q.used_space, q.max_free_space INTO v_tablespace_name, v_free_space, v_used_space, v_max_free_space FROM ts_activity q, (SELECT MAX(timestamp) timestamp FROM ts_activity WHERE tablespace_name = tsrec.tablespace_name) ts WHERE q.tablespace_name = tsrec.tablespace_name AND q.timestamp = ts.timestamp; END IF; IF tsrec.free_space != v_free_space OR tsrec.used_space != v_used_space OR tsrec.max_free_space != v_max_free_space OR v_rowcount = 0 THEN INSERT INTO ts_activity (tablespace_name, free_space, used_space, max_free_space, timestamp) VALUES (tsrec.tablespace_name, tsrec.free_space, tsrec.used_space, tsrec.max_free_space, SYSDATE); END IF; END LOOP; END TS_CHECK; / -Original Message- Sent: Monday, August 11, 2003 5:29 PM To: Multiple recipients of list ORACLE-L Rich, I'd love to see the procedure and table that you use. Thanks for offering. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -- 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: rman implementation
Sai - Several factors: - This was several years ago, so memory fades. - This was the sys admin's first go at NFS. - Got through the initial configuration issues, and the system was up and running. Then several months later I was trying to use the device for RMAN recovery. It would hang with no errors. Experts on this list provided a lot of useful ideas, and put me much closer to the issue, but finally I ended up pushing Oracle Support. They insisted we take NFS out of the mix, just use regular disk. It worked, which forced the sys admin to go back and review everything. In the rhosts file, had the name with the wrong I.P. number. Surprisingly it would mount, but wouldn't accept heavy loads. And that is about all I can reconstruct on that. Unfortunately probably not particularly useful to you. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 6:39 PM To: Multiple recipients of list ORACLE-L yes dennis. this is what i am planning to do. can you please mention the glitches and the parameters that have to be changed. or some pointers from your implementaion which could be very useful. thanks a lot sai DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Sai Are you planning to do a RMAN backup to disk and the disk is Netapp? We ran into a couple of hitches. If you are able to mount a tablespace on the Netapp device, you should be past the first thing we ran into. The other issue had to do with the fact that RMAN opens many connections to disk, so when we tried to recover the backup, RMAN would recover some files, then quit. Changing a Netapp configuration parameter fixed that problem. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, August 10, 2003 2:39 PM To: Multiple recipients of list ORACLE-L hi can someone give me pointers on pros and cons of implementing rman with netapp filers. any pointers,white papers,case study,implementation doc will be very helpful. thanks sai -- 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: 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: Analytical Functions
Nope, Use them every day. Their standard issue, but require Enterprise edition in 8i. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, August 12, 2003 2:59 AM To: Multiple recipients of list ORACLE-L Hi Can anyone tell me if the Analytical functions as shown in the extracted piece of SQL using the OVER clause are part of standard 9i SQL or is it part of the OLAP engine. What i want to know is do I need OLAP installed to use these functions SELECT last_name, hire_date, salary, LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees WHERE job_id = 'PU_CLERK'; Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partitioning
I have worked with partitioning before but have yet encountered the following challenge - The table we are trying to partition is a large table with hundreds of millions of rows, which is ok. But it does not have a month column, although it has dates. I would like to partition by month because this table contains years of data and partitioning by days will result in thousands of partitions. Of course we can add a month column but I think that will require extensive downtime which we can't afford and I suspect it will cause row-chaining as well. So anybody care to share with me any other options/suggestions? TIA Dennis Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Meng, Dennis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).