RE: PL/SQL help
i had similar situation, 1. wrote .sql script which has 'set serveroutput on 'in it 2.set it in glogin.sql > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, February 23, 2002 3:39 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: PL/SQL help > > 1. there isn't a host command in PL/SQL. Read up on external > procedures for this. You need to be painfully aware of the > security implications of this. You need to ask yourself if this > is really necessary. If so, you can write external procs in > Java, C, or even Perl ( that last one isn't well documented... yet ) > > > 2. DBMS_OUTPUT: read up on the docs for it. there's a > built in procedure for this, dbms_output.enable. > > Jared > > > > > > "k k" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 02/22/02 01:13 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:PL/SQL help > > > Hello, > > How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? > Also is there a way to issue set serveroutput on from within a stored > procedure so that when someone run the stored procedure, the stored > procedure output will be seen even if the person forgot to set > serveroutput > on for their sql*plus session ?? > > TIA > > K > > > _ > Join the world's largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: k k > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Ghadge,Sameer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OracleMTSService on win2000 and Database on solaris.
Hi , We are planning to deploy some VB forms (with some COm components) on WEB. Can anybody share their experiences with OracleMTSServie on win2000(with IIS) and database on unix/solaris . What are the advantages/disadvantages ? What will be the issues from database aspect ?? Backend -Database version is 8.0.5 on Sun Middle-tier: Win2000 with SP6 installed . Any help is appreciated. Regards , Abhijit . * Disclaimer This message (including any attachments) contains confidential information intended for a specific individual and purpose, and is protected by law. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message, or the taking of any action based on it, is strictly prohibited. * Visit us at http://www.mahindrabt.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abhijit INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-27072
Hi all.. My database is going down frequently showing this error in alertfile . This is happening to different datafiles and controlfiles. What are the possibilities that cause this error ? How can i avoid this error ? oracle 8.1.7 in win2k Errors in file C:\oracle\admin\acusis\bdump\acusisCKPT.TRC:ORA-00206: error in writing (block 3, # blocks 1) of controlfileORA-00202: controlfile: 'D:\ORADATA\CONTROL01.CTL'ORA-27072: skgfdisp: I/O errorOSD-04008: WriteFile() failure, unable to write to fileO/S-Error: (OS 33) The process cannot access the file because another process has locked a portion of the file. regards, shibu
Oracle OLE-DB
Title: Oracle OLE-DB Hi All Can anyone help me on this..Pls reply ASAP The requirement is as follows: -- The front-end is reading some data from external files (flat files like csv or maybe xml). -- The middle tier application (C++ component) is processing this information i.e. identifying the data and mapping the information to the respective table/column format -- The middle tier application is storing this mapped information in some kind of buffer/array -- The OLE-DB (or anything similar) set of functions/procedures should provide means to interface with this buffer and also the oracle database. I wanted to know if there is any layer (like OLE-DB or something similar) that can read this and provide functions that can insert/update data to the oracle database. Please let me know anyone's view on this. Let anybody forward me the ideas if any. Regards, Viral Amin
Networker?
Hello, /etc/init.d/networker Is this script related to Legato Storage Manager in any way? Is this essential for the operation of Oracle9i in a Sun? What is this script for? Thanks for any help. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Welcome to the ORACLE-L mailing list
TEST [home account] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PL/SQL help
> Begin > dbms_output.enable(1); > dbms_output.put_line('Jared is wrong!'); > end; >/ Oh well, ain't the first time. :) I always put 'set serveroutput on size 100' in glogin.sql Jared "Alec Macdonell" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 04:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: PL/SQL help I do not know a way to enable DBMS from within a procedure either. The second item Jared mentions does not seem to set the session to recieve output. I just ran a check to see and the 'enable' portion of DBMS did not set the toggle the session for output. I used this simple script Begin dbms_output.enable(1); dbms_output.put_line('Jared is wrong!'); end; / IF you run this script you will recieve the procedure completed successfully message. If you the issue a 'set serveroutput on' and run again you will recieve the output text twice. If anyone knows how get DBMS to output without the serveroutput option being explicitly set I would love to hear it. Alec -Original Message- [EMAIL PROTECTED] Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L 1. there isn't a host command in PL/SQL. Read up on external procedures for this. You need to be painfully aware of the security implications of this. You need to ask yourself if this is really necessary. If so, you can write external procs in Java, C, or even Perl ( that last one isn't well documented... yet ) 2. DBMS_OUTPUT: read up on the docs for it. there's a built in procedure for this, dbms_output.enable. Jared "k k" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 01:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:PL/SQL help Hello, How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? Also is there a way to issue set serveroutput on from within a stored procedure so that when someone run the stored procedure, the stored procedure output will be seen even if the person forgot to set serveroutput on for their sql*plus session ?? TIA K _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k k INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Alec Macdonell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rollback Segments
I used a lot 'ior i' to install our customized databases on new machines...installed oracle ..created database,,initialised it and imported customised database with full dump Those ior commands were wonderful and you may still see it in dbstart and dbshut file to provide backword support by oracle... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 21 Feb 2002 17:18:20 -0800 And how about the customer who used 'ior i' to 'start up the database' when he should have used 'ior w'??!?!? (for those who have forgotten: ior i - initialize (create) the V5 Db, ior w - warm start the database, ior s - shutdown) Welcome Anjo to this list. We wouldn't have been able do our jobs well without your exposition on 'Wait Events'. John Kanagaraj 5.1.17, 5.1.22, 6.0.27, 6.0.30, 6.0.33, 7.0.14, 7.0.16, 7.1.4, 7.1.6, 7.2.3, 7.3.2, 7.3.4, 8.0.4, 8.0.5, 8.0.6, 8.1.5, 8.1.6, 8.1.7 and finally 9.0.1!! (milestones on my memory lane) > -Original Message- > Sent: Tuesday, February 19, 2002 2:43 AM > To: Multiple recipients of list ORACLE-L > > > How about iag/iap ? And rpt ? Oh and SQL*Menu ? > And there were about 14 enqueue/locks in Oracle Version 5 as > far as I can > remember. > > Anjo Kolk > > Brings back memories of joining Oracle Europe in 1985 ;-) > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, February 19, 2002 6:43 AM > > > > > > I remember the BI.ORA (Before-Image) file, IOR and ODS in Oracle 5. > > > > Hemant K Chitale > > Principal DBA > > Chartered Semiconductor Manufacturing Ltd > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM > > Sent by: [EMAIL PROTECTED] > > > > Please respond to ORACLE-L > > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > > Subject: RE: Rollback Segments > > > > > > > > > > > > > > > > > > UFI no, but the rest... that's where I started in Oracle -- > version 5 > > > > > > --- "Conboy, Jim" <[EMAIL PROTECTED]> wrote: > > > Holy cow Mladen, what a memory! > > > > > > Does anybody else remember (or admit to) using UFI? > > > > > > Jim > > > > > > ** > > > > > > ...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?... > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Conboy, Jim > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > > Lists > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (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! Sports - Coverage of the 2002 Olympic Games > > http://sports.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / > Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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.com > -- > Author: Anjo Kolk > INET:
RE: PL/SQL help
I do not know a way to enable DBMS from within a procedure either. The second item Jared mentions does not seem to set the session to recieve output. I just ran a check to see and the 'enable' portion of DBMS did not set the toggle the session for output. I used this simple script Begin dbms_output.enable(1); dbms_output.put_line('Jared is wrong!'); end; / IF you run this script you will recieve the procedure completed successfully message. If you the issue a 'set serveroutput on' and run again you will recieve the output text twice. If anyone knows how get DBMS to output without the serveroutput option being explicitly set I would love to hear it. Alec -Original Message- [EMAIL PROTECTED] Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L 1. there isn't a host command in PL/SQL. Read up on external procedures for this. You need to be painfully aware of the security implications of this. You need to ask yourself if this is really necessary. If so, you can write external procs in Java, C, or even Perl ( that last one isn't well documented... yet ) 2. DBMS_OUTPUT: read up on the docs for it. there's a built in procedure for this, dbms_output.enable. Jared "k k" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 01:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:PL/SQL help Hello, How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? Also is there a way to issue set serveroutput on from within a stored procedure so that when someone run the stored procedure, the stored procedure output will be seen even if the person forgot to set serveroutput on for their sql*plus session ?? TIA K _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k k INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Alec Macdonell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PL/SQL help
Re the use of PIPE's to execute commands: There's a page on my website on using DBMS_PIPE and perl for debugging PL/SQL. A slight change is all that's need to make it execute a command. Simple to do, and fraught with security implications. http://www.cybcon.com/~jkstill/util/debug_pipe/debug_pipe.html Jared Jonathan Gennick <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: PL/SQL help You can't SET SERVEROUTPUT ON from within a PL/SQL block, because that's a SQL*Plus command, not a PL/SQL function. You *can* invoke dbms_output.enable(), but that still doesn't set the flag within SQL*Plus that tells SQL*Plus to fetch and display the output. If you tend to forget a lot, you could issue the SET SERVEROUTPUT ON command from your SQL*Plus login file. I know of no way to directly execute commands from within a PL/SQL block. I have heard of using DBMS_PIPE to send commnands to a daemon (written in a language such as C) that executes commands on your behalf. I've never actually done that myself, but I can see where it's possible. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Friday, February 22, 2002, 4:13:19 PM, you wrote: kk> I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? kk> Also is there a way to issue set serveroutput on from within a stored kk> procedure so that when someone run the stored procedure, the stored kk> procedure output will be seen even if the person forgot to set serveroutput kk> on for their sql*plus session ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
get out of command without leaving RMAN ???
Hi, I made some mistake on a RMAN command, and then try to get out of the command, I tried ;, exit, /, but none of them works, they just keep showing me the next line. So I used control+C, it does get out the command, but I was out of RMAN also. I was back in OS prompt. RMAN> release channel' 2> ; 3> exit 4> / 5> So, if there anyway to get out the command without leaving RMAN? Thank you! Leslie __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: testing freelists
See my comments in the text: Robert Eskridge wrote: > (20 days later -- occurrences aren't that common) > > Jared, > > Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book > unbelievably. I've used the event 10046 traces while the blocking > lock event was going on. The curious thing is that I'm not seeing any > buffer busy waits. The blocked process sits there and cranks out an > equeue wait trace every 3 seconds and does not report a file, block > or row that it is waiting on. If I'm reading Steve's book correctly, > I should see file and block but no row if it's an initrans problem, so > that's out. > I am assuming that the mode for the TX enqueue is 4. Right ? > > In Katz's article in the Feb 2002 elementK Journal he says that if all > three are 0 then it's a problem with free space in the block and maybe > pctfree is low. The table I'm inserting into has 2k blocks and > PCTFREE=30. The insert is only populating 7 of the 185 columns, > that's 6 varchar2's and a date. There should be plenty of room, > unless as you pointed out that the problem was really not in this > table -- possibly in the indexes. This guy does have 15 indexes (all > single column, all PCTFREE=10). A curious thing is that when I look > at the blocker, he shows that he's blocking on 2 tables, this one that > he has a transaction open on, and a journaling table that triggers off > the first insert into -- but his rows are only 70 bytes and he has > PCTFREE=10 also. > Are the indexes UNIQUE ? If yes, what is the chance of people inserting into with the same value ? Are the indexes BITMAP ? > > So I've got 17 suspects, all with plausible alibis. And I haven't > figured out how to get the enqueue wait to squeal on any of them. If > I'm understanding the file=0 block=0 row=0 properly, he tried, he > couldn't get a block so he waits 3 seconds and tries again > indefinately. But when one of these happens, I see a rash of them so > something's causing it. > Forget about the file, block, row values. They don't mean a thing if you are not waiting on TX mode 6. > > I keep returning to free lists. This is an evolved application (he > says euphemistically) and it's had a freelist=1 on everything since it > slithered out of the slime. Now it's running on a 4 cpu sparc. I'm > wondering if the free list is just getting overran and if bumping it > to the sometimes advised cpu*2 could clear the problem. I have > lingering doubts because I haven't found anything that specifically > says what I should be seeing when that happens. > The only freelist problem that you could have is transaction freelists. But you are doing inserts so that is not the case here. > > So I guess I should try to make this into a question hmmn... > > Am I barking up the wrong tree? > The right tree, but the tree doesn't understand barking ;-) Anjo. > > -rje > > > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > > Date: Tuesday, February 05, 2002, 10:36:27 AM > > Subject: testing freelists > > > > ===8<==Original message text=== > > Robert, > > > > Simulating the problem and proving the correction is an excellent idea. > > > > One thing to consider when putting together your testing scenario is > > that writes to the database block by a transaction are done in memory, > > that is they are made to the cached database blocks. > > > > An internal locking mechanism ( a latch ) is used to control access to > > the cache, and it is normally held for only a short time. > > > > The data may be written to the disk before a commit, and it may not > > be written to disk until after a commit. ( referring to datafiles only > > here, not the redo log ). > > > > The 60 second sleep in your script is only simulating user think time, > > it's not actually blocking anything. You will need to similate several > > session simultaneously inserting, and you will need to know if the > > contention > > is in the table or in an index: I'm guessing it's an index or indexes. > > > > Some time spent with the Concepts manual would help you out here. > > > > Here's an excerpt from the section on database writer: > > > > Database Writer (DBWn) > > > > The database writer writes modified blocks from the database buffer > > cache to the datafiles. Although one database writer process (DBW0) > > is sufficient for most systems, you can configure additional processes > > (DBW1 through DBW9) to improve write performance for a system that > > modifies data heavily. The initialization parameter DB_WRITER_PROCESSES > > specifies the number of DBWn processes. > > > > Since Oracle uses write-ahead logging, DBWn does not need to write > > blocks when a transaction commits. Instead, DBWn is designed to perform > > batched > > writes with high efficiency. In the most common case, DBWn writes only > > when more > > data needs to be read into the system global area and too few database > > buffers are
RE: 8i Replication: administrator privs
Somehow this seems like a bad idea. I've always restricted administration to REPADMIN, but maybe I lack outside-of-the-box thinking I'm kinda an outside-the-box-kind-of-gal. But, yeah, that looks like a recipe for failure to me too. Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: Group email account for exchanging files and scripts
FYI to all. There's no reason both groups shouldn't use this resource, so please join in and contribute your scripts and documents that would be too large to send as attachments. Best regards, Paul - Original Message - To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 5:35 PM Hello everyone, I was sad to hear that scripts needed to be deleted at the Yahoo group email account because of a lack of available space. I decided to set up and provide an account where we could exchange scripts indefinitely without the fear that they'll be deleted or that someone might change the password on us. The site is: https://webmail.pythian.com. The username is: scripts The password is: pythian To send a message, address your email to [EMAIL PROTECTED] I have taken the liberty of forwarding all of the yahoo.com messages to that account so there isn't anything you're missing if you just want to use that one right away. I encourage all of you to send any scripts you'd like there. The nice thing is that if the scripts are well described in the body of your emails, they'll be searchable via the search interface. This account is part of my company's IT infrastructure and as such it will also get backed up regularly. By the way, it's on purpose that no-one has permission to delete messages (except me of course). Cheers, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vallee INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PL/SQL help
You can't SET SERVEROUTPUT ON from within a PL/SQL block, because that's a SQL*Plus command, not a PL/SQL function. You *can* invoke dbms_output.enable(), but that still doesn't set the flag within SQL*Plus that tells SQL*Plus to fetch and display the output. If you tend to forget a lot, you could issue the SET SERVEROUTPUT ON command from your SQL*Plus login file. I know of no way to directly execute commands from within a PL/SQL block. I have heard of using DBMS_PIPE to send commnands to a daemon (written in a language such as C) that executes commands on your behalf. I've never actually done that myself, but I can see where it's possible. Best regards, Jonathan Gennick mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com Friday, February 22, 2002, 4:13:19 PM, you wrote: kk> I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? kk> Also is there a way to issue set serveroutput on from within a stored kk> procedure so that when someone run the stored procedure, the stored kk> procedure output will be seen even if the person forgot to set serveroutput kk> on for their sql*plus session ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tkprof output
Dennis: In the session: alter session set events '10046 trace name context forever, level 12' Barb > -- > From: DENNIS WILLIAMS[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Friday, February 22, 2002 3:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Tkprof output > > Paul (or anyone) - > Is there a way to set the level within the session as: >alter session set sql_trace = true > Or do I have to start the session, start a SQLPLUS session, find the > session_id and run the procedure to set it on another session? > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Friday, February 22, 2002 3:23 PM > To: Multiple recipients of list ORACLE-L > > > Set you 10046 trace at level 4 or 12, and then check the trace file. > > Paul > > > -Original Message- > Sent: Friday, February 22, 2002 3:53 PM > To: Multiple recipients of list ORACLE-L > > > Hi Listers, > > I got the following statement in the tkprof output file : > > update EMP set "ENAME"=:V001,"EMPNO"=:V002 > where rowid = :V003 > > I'm just wondering how to get the value of that variables (instead of > :V001, > > :V002 and :V003). > Is there a way to do that ? > Thanks. > > Aldi > > _ > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Aldi Barco > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tkprof output
Paul (or anyone) - Is there a way to set the level within the session as: alter session set sql_trace = true Or do I have to start the session, start a SQLPLUS session, find the session_id and run the procedure to set it on another session? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Set you 10046 trace at level 4 or 12, and then check the trace file. Paul -Original Message- Sent: Friday, February 22, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Hi Listers, I got the following statement in the tkprof output file : update EMP set "ENAME"=:V001,"EMPNO"=:V002 where rowid = :V003 I'm just wondering how to get the value of that variables (instead of :V001, :V002 and :V003). Is there a way to do that ? Thanks. Aldi _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: PL/SQL help
1. there isn't a host command in PL/SQL. Read up on external procedures for this. You need to be painfully aware of the security implications of this. You need to ask yourself if this is really necessary. If so, you can write external procs in Java, C, or even Perl ( that last one isn't well documented... yet ) 2. DBMS_OUTPUT: read up on the docs for it. there's a built in procedure for this, dbms_output.enable. Jared "k k" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 01:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:PL/SQL help Hello, How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? Also is there a way to issue set serveroutput on from within a stored procedure so that when someone run the stored procedure, the stored procedure output will be seen even if the person forgot to set serveroutput on for their sql*plus session ?? TIA K _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k k INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8i Replication: administrator privs
Would you consider this to be an open opportunity for disaster? Granting each application schema 'dbms_repcat_admin.grant_admin_any_schema' in a replicated environment. Here's the example: REPADMIN = replication administrator/propagator/receiver ACCT_APP = application schema HR_APP = application schema The owners of ACCT_APP & HR_APP want administrator privs granted to these schemas so they can create replication groups, add/remove objects and generate replication support within their replication groups. Somehow this seems like a bad idea. I've always restricted administration to REPADMIN, but maybe I lack outside-of-the-box thinking Thanks, Suzy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: testing freelists
(20 days later -- occurrences aren't that common) Jared, Ok, I've re-RTFM'd the Concepts manual and have dog eared Steve's book unbelievably. I've used the event 10046 traces while the blocking lock event was going on. The curious thing is that I'm not seeing any buffer busy waits. The blocked process sits there and cranks out an equeue wait trace every 3 seconds and does not report a file, block or row that it is waiting on. If I'm reading Steve's book correctly, I should see file and block but no row if it's an initrans problem, so that's out. In Katz's article in the Feb 2002 elementK Journal he says that if all three are 0 then it's a problem with free space in the block and maybe pctfree is low. The table I'm inserting into has 2k blocks and PCTFREE=30. The insert is only populating 7 of the 185 columns, that's 6 varchar2's and a date. There should be plenty of room, unless as you pointed out that the problem was really not in this table -- possibly in the indexes. This guy does have 15 indexes (all single column, all PCTFREE=10). A curious thing is that when I look at the blocker, he shows that he's blocking on 2 tables, this one that he has a transaction open on, and a journaling table that triggers off the first insert into -- but his rows are only 70 bytes and he has PCTFREE=10 also. So I've got 17 suspects, all with plausible alibis. And I haven't figured out how to get the enqueue wait to squeal on any of them. If I'm understanding the file=0 block=0 row=0 properly, he tried, he couldn't get a block so he waits 3 seconds and tries again indefinately. But when one of these happens, I see a rash of them so something's causing it. I keep returning to free lists. This is an evolved application (he says euphemistically) and it's had a freelist=1 on everything since it slithered out of the slime. Now it's running on a 4 cpu sparc. I'm wondering if the free list is just getting overran and if bumping it to the sometimes advised cpu*2 could clear the problem. I have lingering doubts because I haven't found anything that specifically says what I should be seeing when that happens. So I guess I should try to make this into a question hmmn... Am I barking up the wrong tree? -rje > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Date: Tuesday, February 05, 2002, 10:36:27 AM > Subject: testing freelists > > ===8<==Original message text=== > Robert, > > Simulating the problem and proving the correction is an excellent idea. > > One thing to consider when putting together your testing scenario is > that writes to the database block by a transaction are done in memory, > that is they are made to the cached database blocks. > > An internal locking mechanism ( a latch ) is used to control access to > the cache, and it is normally held for only a short time. > > The data may be written to the disk before a commit, and it may not > be written to disk until after a commit. ( referring to datafiles only > here, not the redo log ). > > The 60 second sleep in your script is only simulating user think time, > it's not actually blocking anything. You will need to similate several > session simultaneously inserting, and you will need to know if the > contention > is in the table or in an index: I'm guessing it's an index or indexes. > > Some time spent with the Concepts manual would help you out here. > > Here's an excerpt from the section on database writer: > > Database Writer (DBWn) > > The database writer writes modified blocks from the database buffer > cache to the datafiles. Although one database writer process (DBW0) > is sufficient for most systems, you can configure additional processes > (DBW1 through DBW9) to improve write performance for a system that > modifies data heavily. The initialization parameter DB_WRITER_PROCESSES > specifies the number of DBWn processes. > > Since Oracle uses write-ahead logging, DBWn does not need to write > blocks when a transaction commits. Instead, DBWn is designed to perform > batched > writes with high efficiency. In the most common case, DBWn writes only > when more > data needs to be read into the system global area and too few database > buffers are free. The least recently used data is written to the datafiles > first. DBWn > also performs writes for other functions such as checkpointing. > > Take a look at Chapter 15 on Transactions as well. > > Also check out Steve Adams' web site, www.ixora.com.au. Lots of > interesting stuff > there if you want to learn about the internals. Here's an excerpt from > the section > on Free lists: > > As mentioned previously, free list contention occurs when multiple > processes using the same free list attempt to modify the data block on the > head of the free list concurrently. It is shown in V$WAITSTAT against the data block >class. V$WAITSTAT can also show contention for the segment header and free list
RE: How to make deletes faster.
Mmm. Max sequence number. I'll go on the assumption that you are selecting the max for a column populated by a sequence. Here's one option.1) CREATE TABLE AS SELECT ROWID myrowid FROM WHERE < 2) DELETE FROM WHERE ROWID IN (SELECT myrowid FROM )3) DROP TABLE Another option: 1) establish a maintenance window with users2) CREATE TABLE 3) INSERT INTO SELECT * FROM WHERE >= 4) DROP TABLE 5) RENAME TABLE to 6) recreate indexes7) recreate constraints8) recreate triggers9) recompile invalid objects10) recreate the grantsHere's a slicker option that I had posted previously: "Aponte, Tony" <[EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> et> cc: Sent by: Subject: RE: providing 24*7 database --- [EMAIL PROTECTED] om 10/22/01 09:05 AM Please respond to ORACLE-L We use a modified version of your duplicate schema idea. But we don't havethe objects in different schemas. We use partitioned objects so that wecan exchange the partitions with the production tables at a scheduled time.The voodoo is that we use a single range partition of MAXVALUE and allindexes are LOCAL PARTITIONED. The partitioning key doesn't really matterin this setup since we aren't using the features for its advantages, justto be able to swap data and index segments on the fly. I've attached atranscript showing the actual sequence but I'll give you a shortexplanation first:There are production tables/indexes that are used by the application,whether directly or via synonyms. There is a second set of tables with a_TEMP suffix that have duplicate structural definitions (constraints,column names and data types, etc.) The indexes also end with a _TEMP butare identical to the production ones. The only difference is that they arepartitioned tables/indexes. All partitioned objects have a single rangepartition by a bogus column. The single partition is bounded by theMAXVALUE keyword, so all of the data is contained in one partition.Now you can manipulate the _TEMP tables at your convenience withoutinterrupting the access tot he "published" objects. Once you haverefreshed your _TEMP objects and are ready to publish the new data yourwould execute a series of ALTER TABLE _TEMP EXCHANGE PARTITIONTABLE . That's it. No re-pointing of synonyms, revalidating ofviews/stored procs./etc. The application keeps chugging along. The nextexecution of SQL will use the published tables.HTHTony Aponte** pseudo-attachment **SQL> create table x(x1 number,x2 varchar2(50));Table created.SQL> create index xi1 on x(x1);Index created.SQL> create table y(x1 number,x2 varchar2(50)) 2 partition by range (x1) (partition y values less than (maxvalue));Table created.SQL> create index yi1 on y(x1) 2 local (partition yi1 );Index created.SQL> insert into x values (1,'original data from regular table');1 row created.SQL> insert into y values (2,'original data from partitioned table');1 row created.SQL> commit;Commit complete.SQL> select * from x; X1 X2-- -- 1 original data from regular tableSQL> select * from y; X1 X2-- -- 2 original data from partitioned tableSQL> alter table y exchange partition y with table x;Table altered.SQL> select * from x; X1 X2-- -- 2 original data from partitioned tableSQL> select * from y; X1 X
PL/SQL help
Hello, I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? Also is there a way to issue set serveroutput on from within a stored procedure so that when someone run the stored procedure, the stored procedure output will be seen even if the person forgot to set serveroutput on for their sql*plus session ?? TIA K _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k k INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 make deletes faster.
[Bjørn Engsig] > You should consider doing a create newtable as select with the oposite > conditions as your delete, followed by a truncate/drop, exchange partition or > whatever. Delete is really hard against the undo segments. Anyway to lessen that? like nologging on the delete itself, putting the table into nologging during the delete (if that's an option, which it probably isn't), etc? -- James Manning <[EMAIL PROTECTED]> GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
Switching an Access application from using Access tables to Oracle ODBC linked tables or ADO tables is extremely easy. Then you can go directly to your Oracle DB or to a new one outside the network that could be sync using Oracle Technology. Waleed -Original Message- Sent: Friday, February 22, 2002 2:58 PM To: Multiple recipients of list ORACLE-L The Oracle server is on our internal network, the MS Access is on a server from ISP, which is outside of our network. The cost to eliminate the MS Access, merge all application to our Oracle is too high, so we decide to stay the way it is. It's not real replication, just copy(move) the data from Oracle to MS Access in batch process, but we want to automate the process. > -Original Message- > From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare, Merge and replicate between Oracle and MS > Access > > Are you serious? > Replication between Oracle and MS Access, why? > > -Original Message- > Sent: Friday, February 22, 2002 2:09 PM > To: Multiple recipients of list ORACLE-L > > > Hi DBAs, > > I am researching for solution for a new project. We have a few tables in > Oracle8i db, similar tables with more columns and more data in MS Access. > The data is very static. > > Our plan is to synchronize the two dbs, from then on we will always put > change(adding more columns, or insert new data) in Oracle first, then > replicate the change to MS access db in batch process. > > I am looking for solutions > 1) to compare the existing data in Oracle and MS Access > 2) to merge the data into Oracle > 3) to maintain the two db on ongoing basis. periodically check if they are > in synch, then replicate data to MS access. > > Is there any tool to do the job? any ideas for solution? One solution I > thought about is to use MS DTS to put Oracle into Access, then > compare. > > TIA > James > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Xing, James > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tkprof output
Set you 10046 trace at level 4 or 12, and then check the trace file. Paul -Original Message- Sent: Friday, February 22, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Hi Listers, I got the following statement in the tkprof output file : update EMP set "ENAME"=:V001,"EMPNO"=:V002 where rowid = :V003 I'm just wondering how to get the value of that variables (instead of :V001, :V002 and :V003). Is there a way to do that ? Thanks. Aldi _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
Thanks Dennis, link to Oracle in Access through ODBC is one option, actually good idea.., if I can get through the network. the Access and Oracle are on different network. > -Original Message- > From: DENNIS WILLIAMS [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare, Merge and replicate between Oracle and MS > Access > > James - Have you considered just maintaining the Oracle tables and then > attaching (or whatever the Access word is) the Oracle table in Access? > That > way you have a single table, single source, etc. Simple is good. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Friday, February 22, 2002 1:09 PM > To: Multiple recipients of list ORACLE-L > > > Hi DBAs, > > I am researching for solution for a new project. We have a few tables in > Oracle8i db, similar tables with more columns and more data in MS Access. > The data is very static. > > Our plan is to synchronize the two dbs, from then on we will always put > change(adding more columns, or insert new data) in Oracle first, then > replicate the change to MS access db in batch process. > > I am looking for solutions > 1) to compare the existing data in Oracle and MS Access > 2) to merge the data into Oracle > 3) to maintain the two db on ongoing basis. periodically check if they are > in synch, then replicate data to MS access. > > Is there any tool to do the job? any ideas for solution? One solution I > thought about is to use MS DTS to put Oracle into Access, then > compare. > > TIA > James > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Xing, James > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
Can you not substitute say, Oracle Lite for Access on the 'downstream' sites & use Oracle's native replication? (Or keep Access as a front-end, but use OL for the actual storage & the replication.) I would guess you'd be in for less work/trouble that way (tho I know zip about Oracle's replication features). If you can't, I would try to find a third-party tool that can do it automagically (http://www.aardvark.on.ca/pd/replicate.html claim to have such a solution). If that fails, consider just doing a brute-force complete update of the Access db & have your downstream sites FTP the entire new mdb file over top of the old version. HTH, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, February 22, 2002 11:54 AM To: Multiple recipients of list ORACLE-L James can you tell us more about the requirements of your environment/software that would cause such a solution to arise. I can see the possibility of writing a MS Access client that perhaps your sales staff uses that replicates with the database. Hopefully, you don't have too many tables. You really are not going to have a lot of success I think using anything but a PL/SQL and VBA solution in this regard. - Ethan -Original Message- Sent: Friday, February 22, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL help
Hello, How I can i issue host commands from within a PL/SQL block in 8i(8.1.7) ?? Also is there a way to issue set serveroutput on from within a stored procedure so that when someone run the stored procedure, the stored procedure output will be seen even if the person forgot to set serveroutput on for their sql*plus session ?? TIA K _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: k k INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
I am wondering what the license issues with this would be. - E -Original Message- Sent: Friday, February 22, 2002 1:49 PM To: Multiple recipients of list ORACLE-L James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the Oracle table in Access? That way you have a single table, single source, etc. Simple is good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Tkprof output
Hi Listers, I got the following statement in the tkprof output file : update EMP set "ENAME"=:V001,"EMPNO"=:V002 where rowid = :V003 I'm just wondering how to get the value of that variables (instead of :V001, :V002 and :V003). Is there a way to do that ? Thanks. Aldi _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aldi Barco INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
You will need to use VBA and DAO to. 1. Connect to the Oracle database. 2. Delete or drop the tables in the Access database. 3. Insert or create the tables from the Oracle database. Anyone proficient with VBA and DAO and Access should be able to do this very easily. - Ethan -Original Message- Sent: Friday, February 22, 2002 1:58 PM To: Multiple recipients of list ORACLE-L The Oracle server is on our internal network, the MS Access is on a server from ISP, which is outside of our network. The cost to eliminate the MS Access, merge all application to our Oracle is too high, so we decide to stay the way it is. It's not real replication, just copy(move) the data from Oracle to MS Access in batch process, but we want to automate the process. > -Original Message- > From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare, Merge and replicate between Oracle and MS > Access > > Are you serious? > Replication between Oracle and MS Access, why? > > -Original Message- > Sent: Friday, February 22, 2002 2:09 PM > To: Multiple recipients of list ORACLE-L > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
The Oracle server is on our internal network, the MS Access is on a server from ISP, which is outside of our network. The cost to eliminate the MS Access, merge all application to our Oracle is too high, so we decide to stay the way it is. It's not real replication, just copy(move) the data from Oracle to MS Access in batch process, but we want to automate the process. > -Original Message- > From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] > Sent: Friday, February 22, 2002 2:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Compare, Merge and replicate between Oracle and MS > Access > > Are you serious? > Replication between Oracle and MS Access, why? > > -Original Message- > Sent: Friday, February 22, 2002 2:09 PM > To: Multiple recipients of list ORACLE-L > > > Hi DBAs, > > I am researching for solution for a new project. We have a few tables in > Oracle8i db, similar tables with more columns and more data in MS Access. > The data is very static. > > Our plan is to synchronize the two dbs, from then on we will always put > change(adding more columns, or insert new data) in Oracle first, then > replicate the change to MS access db in batch process. > > I am looking for solutions > 1) to compare the existing data in Oracle and MS Access > 2) to merge the data into Oracle > 3) to maintain the two db on ongoing basis. periodically check if they are > in synch, then replicate data to MS access. > > Is there any tool to do the job? any ideas for solution? One solution I > thought about is to use MS DTS to put Oracle into Access, then > compare. > > TIA > James > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Xing, James > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
James can you tell us more about the requirements of your environment/software that would cause such a solution to arise. I can see the possibility of writing a MS Access client that perhaps your sales staff uses that replicates with the database. Hopefully, you don't have too many tables. You really are not going to have a lot of success I think using anything but a PL/SQL and VBA solution in this regard. - Ethan -Original Message- Sent: Friday, February 22, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
James - Have you considered just maintaining the Oracle tables and then attaching (or whatever the Access word is) the Oracle table in Access? That way you have a single table, single source, etc. Simple is good. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 audit an exception in a trigger/procedure
I agree since it's better than auditing the audit! -Original Message- Sent: Friday, February 22, 2002 2:18 PM To: Multiple recipients of list ORACLE-L How about monitoring the audit tablespace to ensure it doesn't fill up? Jared "Jesse, Rich" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 10:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:How to audit an exception in a trigger/procedure Hi all, In 8.1.7 on HP/UX 11.0, we've got some homemade triggers on a vendor's schema. One of these triggers tried to write an audit record to a table in a tablespace different from the table that was being updated, but the audit table's tablespace filled up. Since we had an exception clause on the trigger to ignore errors (priority is making sure the purchased app is OK), some of the audits didn't get written. We can probably recreate those audits manually, but I'm wondering if there was a better way to handle this in the trigger. We don't want the trigger to return an exception to the caller, since the caller is most likely the vendor app. Basically, we want our trigger to be completely unobtrusive/unknown to the app. For example, in an EXCEPTION clause, is it possible to force the current process to dump a trace without affecting the current transaction? I was also thinking that the EXCEPTION could attempt to write to an error table in another tablespace, but since it's still DML, there's no real guarantees that it won't bonk either. The only other thing I could think of is to write a proc that UTL_FILE's a pseudo-trace out to disk that would be picked up by our custom Oracle log checkers. Anyone done anything like this before or have any suggestions/pros/cons? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 audit an exception in a trigger/procedure
Send an email to whomever in the EXCEPTION clause? Actually, the whomever should be some email account that the DBAs can subscribe to (and unsubscribe when they get that six figure job somewhere else). Also, is there any interest in coding for those "this full" type error messages and then increasing the object on the fly?? You probably cant code for every single error message, but at least get the big ones so you dont lose any audit data. And your not jumping through hoops to recover when you discover the error... -Original Message- Sent: Friday, February 22, 2002 1:43 PM To: Multiple recipients of list ORACLE-L Hi all, In 8.1.7 on HP/UX 11.0, we've got some homemade triggers on a vendor's schema. One of these triggers tried to write an audit record to a table in a tablespace different from the table that was being updated, but the audit table's tablespace filled up. Since we had an exception clause on the trigger to ignore errors (priority is making sure the purchased app is OK), some of the audits didn't get written. We can probably recreate those audits manually, but I'm wondering if there was a better way to handle this in the trigger. We don't want the trigger to return an exception to the caller, since the caller is most likely the vendor app. Basically, we want our trigger to be completely unobtrusive/unknown to the app. For example, in an EXCEPTION clause, is it possible to force the current process to dump a trace without affecting the current transaction? I was also thinking that the EXCEPTION could attempt to write to an error table in another tablespace, but since it's still DML, there's no real guarantees that it won't bonk either. The only other thing I could think of is to write a proc that UTL_FILE's a pseudo-trace out to disk that would be picked up by our custom Oracle log checkers. Anyone done anything like this before or have any suggestions/pros/cons? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Compare, Merge and replicate between Oracle and MS Access
Are you serious? Replication between Oracle and MS Access, why? -Original Message- Sent: Friday, February 22, 2002 2:09 PM To: Multiple recipients of list ORACLE-L Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 audit an exception in a trigger/procedure
How about monitoring the audit tablespace to ensure it doesn't fill up? Jared "Jesse, Rich" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/22/02 10:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:How to audit an exception in a trigger/procedure Hi all, In 8.1.7 on HP/UX 11.0, we've got some homemade triggers on a vendor's schema. One of these triggers tried to write an audit record to a table in a tablespace different from the table that was being updated, but the audit table's tablespace filled up. Since we had an exception clause on the trigger to ignore errors (priority is making sure the purchased app is OK), some of the audits didn't get written. We can probably recreate those audits manually, but I'm wondering if there was a better way to handle this in the trigger. We don't want the trigger to return an exception to the caller, since the caller is most likely the vendor app. Basically, we want our trigger to be completely unobtrusive/unknown to the app. For example, in an EXCEPTION clause, is it possible to force the current process to dump a trace without affecting the current transaction? I was also thinking that the EXCEPTION could attempt to write to an error table in another tablespace, but since it's still DML, there's no real guarantees that it won't bonk either. The only other thing I could think of is to write a proc that UTL_FILE's a pseudo-trace out to disk that would be picked up by our custom Oracle log checkers. Anyone done anything like this before or have any suggestions/pros/cons? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Compare, Merge and replicate between Oracle and MS Access
Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static. Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare. TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 audit an exception in a trigger/procedure
if you can (and I assume you can) change the trigger code and if you are on 8i, make use of autonomous transactions. so you can capture all required information and insert it into a table. You may want to write this as a separate procedure and call that with appropriate information from the trigger, so that the procedure is the one that has the autonomous pragma. Or put messages on a db pipe, have a pipe daemon listen continuously and as soon as it gets message, dump into another table and commit. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: data dictionary View about jobs
Are you logging in as the owner of the DBMS job? Stupid securty-by-obscurity, IMHO. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Friday, February 22, 2002 12:15 PM To: Multiple recipients of list ORACLE-L Do you use "commit" after removing the job? -Original Message- Sent: Friday, February 22, 2002 1:03 AM To: Multiple recipients of list ORACLE-L Hi, All, Is there any Oracle data dict view to see whether the dbms jobs is on the job queue or not. Why I ask this is that I use dbms_job.remove to remove one job, later on, I check it using user_jobs, it's still there. Thus issue dbms_job.remove again, this time, this execution seems hung there. I log into sys and issue dbms_job.remove, I got the following error ORA-23421: job number 41 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 525 ORA-06512: at "SYS.DBMS_JOB", line 166 ORA-06512: at line 2 Could anyone tell me why this happens? or is there any dict view to check the job queue? Thanks in advance, Chuan Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to audit an exception in a trigger/procedure
Hi all, In 8.1.7 on HP/UX 11.0, we've got some homemade triggers on a vendor's schema. One of these triggers tried to write an audit record to a table in a tablespace different from the table that was being updated, but the audit table's tablespace filled up. Since we had an exception clause on the trigger to ignore errors (priority is making sure the purchased app is OK), some of the audits didn't get written. We can probably recreate those audits manually, but I'm wondering if there was a better way to handle this in the trigger. We don't want the trigger to return an exception to the caller, since the caller is most likely the vendor app. Basically, we want our trigger to be completely unobtrusive/unknown to the app. For example, in an EXCEPTION clause, is it possible to force the current process to dump a trace without affecting the current transaction? I was also thinking that the EXCEPTION could attempt to write to an error table in another tablespace, but since it's still DML, there's no real guarantees that it won't bonk either. The only other thing I could think of is to write a proc that UTL_FILE's a pseudo-trace out to disk that would be picked up by our custom Oracle log checkers. Anyone done anything like this before or have any suggestions/pros/cons? TIA! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Thanks Paul, That worked. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: sql question >Date: Fri, 22 Feb 2002 07:53:39 -0800 > >How about : > >select num >from NUMBERS, >( select begin, end from RANGE) >where num between begin and end; > >Paul > > >-Original Message- >Sent: Friday, February 22, 2002 10:14 AM >To: Multiple recipients of list ORACLE-L > > >You are right that the range aren't necessarily contigous. >I'd probably have to write it in PL/SQL, I just want to see >if one can do this with SQL. > >Thanks. > > >From: [EMAIL PROTECTED] > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: sql question > >Date: Thu, 21 Feb 2002 21:33:20 -0800 > > > >Rich, > > > >Are you sure that that is what you want ? > >Suppose your range values were something like : > > begin end > > 1 9 > > 1519 > > 2329 > >ie, the RANGE table shows that 10-14 and 20-22 are invalid ("not >allowed") > >values. > > > >Your problem statement and the SQL that Paul provides for the problem > >statement > >would return numbers like 10, 11, 20,21 which are, actually, invalid. > > > >You'd have to write a cursor to loop through the valid ranges ?? > > > >Hemant K Chitale > >Principal DBA > >Chartered Semiconductor Manufacturing Ltd > > > > > >Paul Baumgartel <[EMAIL PROTECTED]> 22/02/2002 12:43 PM > >Sent by: [EMAIL PROTECTED] > > > >Please respond to ORACLE-L > > > > To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > > Subject: Re: sql question > > > > > > > > > > > > > > > > > >To use your example column names: > > > >select num from numbers where num between > >(select min(begin) from range) and (select max(end) from range); > > > > > >--- oracle dba <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > I have a SQL question. Suppose I have a table called RANGE looks > > > like > > > this: > > > > > > begin end > > > 1 9 > > > 1019 > > > 2029 > > > > > > Then I have a table NUMBERS that's full of bunch of numbers like > > > this: > > > > > > num > > > 1 > > > 2 > > > 3 > > > 4 > > > ... > > > 98 > > > 99 > > > 100 > > > > > > I want to write a SQL that returns the number that are within > > > the ranges defined in the RANGE table. So number 1 through 29 > > > should be returned. > > > > > > Can someone help me with this? Thanks. > > > > > > Rich > > > > > > _ > > > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: oracle dba > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > > Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (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! Sports - Coverage of the 2002 Olympic Games > >http://sports.yahoo.com > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Paul Baumgartel > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(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.com > >-- > >Author: > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP comm
RE: data dictionary View about jobs
Do you use "commit" after removing the job? -Original Message- Sent: Friday, February 22, 2002 1:03 AM To: Multiple recipients of list ORACLE-L Hi, All, Is there any Oracle data dict view to see whether the dbms jobs is on the job queue or not. Why I ask this is that I use dbms_job.remove to remove one job, later on, I check it using user_jobs, it's still there. Thus issue dbms_job.remove again, this time, this execution seems hung there. I log into sys and issue dbms_job.remove, I got the following error ORA-23421: job number 41 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 525 ORA-06512: at "SYS.DBMS_JOB", line 166 ORA-06512: at line 2 Could anyone tell me why this happens? or is there any dict view to check the job queue? Thanks in advance, Chuan Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Blobs and Extents
Darren a 1 : === I would use both thprof to make sure that the SQL is efficient and statpack to monitor the full database a 2 : === I would never recommend to make the data files bigger than 2 Gb on unix, so anything up to 2 GB will be fine. How small you what to make the files depends on the number of disk's or if you use raid to strip ? a 3 : === You would use locally managed table spaces and make the extend size 1, 4, 10 or 512 Mb in this case it does not matter. a 4 : === Yes, if the table space is read only you only need one backup but on the other hand who gives a dam on 4 - 6 GB tape per today Browett, Darren wrote: >We are in the process of installing a GIS package (Arc/info) which has an >oracle component (SDE) > >I have to setup tablespaces to handle various types of data, one of the >tablespaces will be holding >Tiff images. These images range are on average 25 Megs and there will be >upto 200 images. > >It is Oracle 8.1.7.2 on Tru64 Unix > >>From this I have a couple of questions. > >1. I want to test different extent sizes for performance, what tool should I >use, tkprof or statspack > >2. How big should the datafiles be, 500m, 1Gb etc. > >3. As for the extents, I am leaning towards a locally managed tablespace, >what kind of extent >size would work best, 1m, 4m, 10 m etc. As mentioned in 1 I plan on testing >this, just looking >for feedback. > >4. And, once these are loaded, is there any advantage to having the >tablespace set to readonly ? > >Thank You > >Darren > > > > > >-- >Darren Browett P.Eng This message >was transmitted >Data Administrator using 100% >recycled electrons >Information and Communication Technology >City of Coquitlam >P:(604)927 - 3614 >E:[EMAIL PROTECTED] > >--- > > -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Blobs and Extents
-Original Message- Sent: Friday, February 22, 2002 12:43 PM To: Multiple recipients of list ORACLE-L > We are in the process of installing a GIS package (Arc/info) which has an > oracle component (SDE) > I have to setup tablespaces to handle various types of data, one of the > tablespaces will be holding > Tiff images. These images range are on average 25 Megs and there will be > upto 200 images. > It is Oracle 8.1.7.2 on Tru64 Unix > From this I have a couple of questions. > 1. I want to test different extent sizes for performance, what tool should I > use, tkprof or statspack I prefer so called DBA intuition. The DBA intuition tells me that for pictures you want the block to be as big as possible. Thus, - 32k. > 2. How big should the datafiles be, 500m, 1Gb etc. 2GB datafiles are usually the most reliable ones. > 3. As for the extents, I am leaning towards a locally managed tablespace, > what kind of extent > size would work best, 1m, 4m, 10 m etc. As mentioned in 1 I plan on testing > this, just looking > for feedback. 32M would be my personal preference. That would mean that 99% of your pictures would reside in a single extent. > 4. And, once these are loaded, is there any advantage to having the > tablespace set to readonly ? Yes. If the tablespace is read-only, then you don't need the undo protection for the blocks from that tablespace nor do you need redo protection. In other words, the access to those blocks is much more streamlined, shortening the path through the code and thus making it faster. > Thank You > Darren You're welcome. -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: data dictionary View about jobs
You must be logged in as the owner of the job to remove it. Jared "Chuan Zhang" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/21/02 10:03 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:data dictionary View about jobs Hi, All, Is there any Oracle data dict view to see whether the dbms jobs is on the job queue or not. Why I ask this is that I use dbms_job.remove to remove one job, later on, I check it using user_jobs, it's still there. Thus issue dbms_job.remove again, this time, this execution seems hung there. I log into sys and issue dbms_job.remove, I got the following error ORA-23421: job number 41 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 525 ORA-06512: at "SYS.DBMS_JOB", line 166 ORA-06512: at line 2 Could anyone tell me why this happens? or is there any dict view to check the job queue? Thanks in advance, Chuan Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hours to support an Oracle database per week, documented some
Yeah, pretty much what I was thinking. I just wanted to ping the list and see what others would say. Thanks everyone. Chris -Original Message- Sent: Friday, February 22, 2002 12:08 PM To: Multiple recipients of list ORACLE-L some Chris - Are you guaranteeing that you can support their system for 6 hours of work/week? Are you merely providing an estimate of what you guess it will be and plan to bill based on actual time taken? If it is the former, woe be unto you. If it is the latter, I would think that you could provide a list of the tasks you expect to accomplish. Other posts have given you some good ideas. If the client wants to be bull-headed and budget for less support per week either 1) they will get lucky and not much will occur for you to do, 2) they will have to cough up more money, or 3) you will decide to provide some services pro bono as the lawyers say. I don't think you will find any official studies because the needs vary so widely, as others have pointed out. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 9:39 AM To: Multiple recipients of list ORACLE-L somewher I have received the following from one of my co-workers at a client site. Any links, docs, thoughts, gripes, complaints, help would be appreciated. Thanks. -- I am looking for any documentation out there on Oracle support - like the amount of effort to support an oracle database. The client insists that our revised estimate of 6 hours per week is too high. Do you know of anything we can use as an independent data source??? Gardner document something from Oracle etc I have looked, but can find nothing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Blobs and Extents
We are in the process of installing a GIS package (Arc/info) which has an oracle component (SDE) I have to setup tablespaces to handle various types of data, one of the tablespaces will be holding Tiff images. These images range are on average 25 Megs and there will be upto 200 images. It is Oracle 8.1.7.2 on Tru64 Unix >From this I have a couple of questions. 1. I want to test different extent sizes for performance, what tool should I use, tkprof or statspack 2. How big should the datafiles be, 500m, 1Gb etc. 3. As for the extents, I am leaning towards a locally managed tablespace, what kind of extent size would work best, 1m, 4m, 10 m etc. As mentioned in 1 I plan on testing this, just looking for feedback. 4. And, once these are loaded, is there any advantage to having the tablespace set to readonly ? Thank You Darren -- Darren Browett P.EngThis message was transmitted Data Administrator using 100% recycled electrons Information and Communication Technology City of Coquitlam P:(604)927 - 3614 E:[EMAIL PROTECTED] --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Linux Cluster
I wish that I had some of that 10 year ago OPS experience ;-) Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 22, 2002 5:53 PM > I'm also running it on two Vmware machines running Linux on my laptop. > I'm currently working on a 'real' cluster, using a mixture of SMP linux > boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big > problem. I believe it still to be electrical on the SCSI bus, so watch > this space. If you have a choice, use FC, preferably switched! > Oracle version: 9.0.1.2 > Is it fun? I always say - If you really want to learn about how Oracle > instances work, run OPS. I don't say that anymore, because they changed > the name to RAC. But that's the only change to the saying. I love it > though, it's loads of fun, but very much in a masochistic way. > In the particular case of Linux, if anyone worked on any big multi-node > OPS configurations about ten years ago, you have a good idea of what > it's like now on Linux > > Regards > > James > > -- > James Morle > Scale Abilities, Ltd > http://www.scaleabilities.co.uk > Author of "Scaling Oracle8i - Building Highly Scalable OLTP System > Architectures" > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > > Henrik Ekenberg <[EMAIL PROTECTED]> > > Sent: 22 February 2002 15:03 > > To: Multiple recipients of list ORACLE-L > > Subject: Linux Cluster > > > > > > Hi from the Swow storm from Sweden, > > > > We wants to try to run Oracle on a Linux Cluster. > > Is someone using Oracle on a Linux Cluster ? > > > > Who is your configuration ? > > 1- (DELL,HP,Compaq,..) > > 2- Which Linux version ? > > 3- Which Oracle version ? > > 4- Is is fun ? > > > > Best Regards, > > HEnrik > > > > -- > > -- > > - > > There's fun in being serious. > > > > -- Wynton Marsalis > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Henrik Ekenber > > INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > > and in the message BODY, include a line containing: UNSUB > > ORACLE-L (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.com > -- > Author: James Morle > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: replication setup questions
There are several papers on Oracle's web site which may help. I am working my way through the contents now so I cannot give you any hands on experience yet. Look for Notes: 117343.1, 50593.1, 1015725.6 plus others. --- James Ambursley <[EMAIL PROTECTED]> wrote: > I am thinking of implementing replication for remote > sites. What I have not > been able to gather from documentation to date is > what are the pre steps required to setup a > replicated site(master > destination) > what are the steps to bring the replicated site > online after the > master definition site has failed > is replicating to remote sites a band-width hog > are there any issues creating a replicated site > when the main site > has RMAN implemented > is there a detail step by step document which shows > how to create a > replication master site including the > pre-configuration steps > > > We are using 8.1.7.3 on solaris 2.6. Our database > currently generates > hundreds of megs of redo because of all the > transactions > occurring. But the database itself is about 50 > gigs. > > Thanks > > ATTACHMENT part 2 application/ms-tnef name=winmail.dat = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: replication setup questions
James - Given the breadth of your questions, you may want to purchase "Oracle Distributed Systems" by Charles Dye, an O'Reilly book. It is the only book I have found on Oracle replication. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 11:04 AM To: Multiple recipients of list ORACLE-L There are several papers on Oracle's web site which may help. I am working my way through the contents now so I cannot give you any hands on experience yet. Look for Notes: 117343.1, 50593.1, 1015725.6 plus others. --- James Ambursley <[EMAIL PROTECTED]> wrote: > I am thinking of implementing replication for remote > sites. What I have not > been able to gather from documentation to date is > what are the pre steps required to setup a > replicated site(master > destination) > what are the steps to bring the replicated site > online after the > master definition site has failed > is replicating to remote sites a band-width hog > are there any issues creating a replicated site > when the main site > has RMAN implemented > is there a detail step by step document which shows > how to create a > replication master site including the > pre-configuration steps > > > We are using 8.1.7.3 on solaris 2.6. Our database > currently generates > hundreds of megs of redo because of all the > transactions > occurring. But the database itself is about 50 > gigs. > > Thanks > > ATTACHMENT part 2 application/ms-tnef name=winmail.dat = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Sports - Coverage of the 2002 Olympic Games http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Licensing vs. The Others
Jay - Try this URL: http://www.microsoft.com/sql/evaluation/compare/pricecomparison.asp naturally it is entirely biased in Microsoft's favor and I don't see where it mentions that under Oracle's pricing model, upgrades are included, but not with Microsoft. Oracle and IBM probably have equivalent documents on their sites. Hope that helps. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Our management has started asking questions about how Oracle's licensing costs compare to other database vendors. Specifically, DB2 and Sql Server. I think I am pretty well armed with the "features" arguments, at least for Oracle vs. Sql Server, but I really have no clue about licensing and support costs for DB2 and Sql Server. Can somebody please provide ballpark numbers? We will be comparing it to Oracle's latest licensing model (https://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?site=OracleStoreUS&r espid=22372). Oracle tells me that support costs are currently 22% of the license per year. Of course, this is prior to any of the black magic which they call "discounting." I would like comparable numbers for the other vendors products. If I get a chance, I'll dig around on the web sites, but I was also curious to know if the other vendors practice "discounting." Thank you, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hours to support an Oracle database per week, documented some
Chris - Are you guaranteeing that you can support their system for 6 hours of work/week? Are you merely providing an estimate of what you guess it will be and plan to bill based on actual time taken? If it is the former, woe be unto you. If it is the latter, I would think that you could provide a list of the tasks you expect to accomplish. Other posts have given you some good ideas. If the client wants to be bull-headed and budget for less support per week either 1) they will get lucky and not much will occur for you to do, 2) they will have to cough up more money, or 3) you will decide to provide some services pro bono as the lawyers say. I don't think you will find any official studies because the needs vary so widely, as others have pointed out. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, February 22, 2002 9:39 AM To: Multiple recipients of list ORACLE-L somewher I have received the following from one of my co-workers at a client site. Any links, docs, thoughts, gripes, complaints, help would be appreciated. Thanks. -- I am looking for any documentation out there on Oracle support - like the amount of effort to support an oracle database. The client insists that our revised estimate of 6 hours per week is too high. Do you know of anything we can use as an independent data source??? Gardner document something from Oracle etc I have looked, but can find nothing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 import PDF files into Oracle database
Check out DBMS_LOB.LOADFROMFILE to load them into lob's in the db. Similarly, you can use dbms_lob.read and htp.prn to spit it out to a web page. hth connor --- "Nguyen, David M" <[EMAIL PROTECTED]> wrote: > Is is possible to store PDF files in oracle database > to allow user accesses > the files, open it and read it? If so, please > advise how. I am using > oracle8i with DBI running on Solaris8. > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Nguyen, David M > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Linux Cluster
I'm also running it on two Vmware machines running Linux on my laptop. I'm currently working on a 'real' cluster, using a mixture of SMP linux boxes on a shared SCSI array. Two nodes, no problem. Three nodes, big problem. I believe it still to be electrical on the SCSI bus, so watch this space. If you have a choice, use FC, preferably switched! Oracle version: 9.0.1.2 Is it fun? I always say - If you really want to learn about how Oracle instances work, run OPS. I don't say that anymore, because they changed the name to RAC. But that's the only change to the saying. I love it though, it's loads of fun, but very much in a masochistic way. In the particular case of Linux, if anyone worked on any big multi-node OPS configurations about ten years ago, you have a good idea of what it's like now on Linux Regards James -- James Morle Scale Abilities, Ltd http://www.scaleabilities.co.uk Author of "Scaling Oracle8i - Building Highly Scalable OLTP System Architectures" > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > Henrik Ekenberg <[EMAIL PROTECTED]> > Sent: 22 February 2002 15:03 > To: Multiple recipients of list ORACLE-L > Subject: Linux Cluster > > > Hi from the Swow storm from Sweden, > > We wants to try to run Oracle on a Linux Cluster. > Is someone using Oracle on a Linux Cluster ? > > Who is your configuration ? > 1- (DELL,HP,Compaq,..) > 2- Which Linux version ? > 3- Which Oracle version ? > 4- Is is fun ? > > Best Regards, > HEnrik > > -- > -- > - > There's fun in being serious. > > -- Wynton Marsalis > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Henrik Ekenber > INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in the message BODY, include a line containing: UNSUB > ORACLE-L (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.com -- Author: James Morle INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Licensing vs. The Others
>-This probably pales when compared to mainframe maintenance fees. And don't forget that mainframes also "rent" the OS for a hefty fee!! Dave -Original Message- Sent: Friday, February 22, 2002 10:25 AM To: Multiple recipients of list ORACLE-L Re the 22% annual support cost. This is apparently not unusually high. We were quote a 22% for an application last week. This probably pales when compared to mainframe maintenance fees. Jared On Friday 22 February 2002 06:03, Jay Hostetter wrote: > Our management has started asking questions about how Oracle's licensing > costs compare to other database vendors. Specifically, DB2 and Sql Server. > I think I am pretty well armed with the "features" arguments, at least for > Oracle vs. Sql Server, but I really have no clue about licensing and > support costs for DB2 and Sql Server. Can somebody please provide ballpark > numbers? We will be comparing it to Oracle's latest licensing model > (https://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?site=OracleStoreUS&; >respid=22372). Oracle tells me that support costs are currently 22% of the > license per year. Of course, this is prior to any of the black magic which > they call "discounting." I would like comparable numbers for the other > vendors products. If I get a chance, I'll dig around on the web sites, but > I was also curious to know if the other vendors practice "discounting." > > Thank you, > Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hours to support an Oracle database per week, documented some
I'd say if the client can give me the expected code errors, user errors, number of time someone will delete/drop/truncate a table, expected number of ora 600/7445 errors, I can pretty much give a estimate of db support time. Oh ... and did I mention failed backups, space shortage, SA availability, imports/exports etc? Couple of days ago we spent about 5 hours relocating some tables from one data file to another ONLINE because system couldn't be taken down, the expected time was couple of hours, lest we knew that couple of tables had CLOBS, and a small procedure was dependent on that table. This procedure is used by EVERY piece of code in the database, so imagine what a nightmare it was for us. This is even when we were doing on-line moving on a 9012 db. HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: Oracle Licensing vs. The Others
Re the 22% annual support cost. This is apparently not unusually high. We were quote a 22% for an application last week. This probably pales when compared to mainframe maintenance fees. Jared On Friday 22 February 2002 06:03, Jay Hostetter wrote: > Our management has started asking questions about how Oracle's licensing > costs compare to other database vendors. Specifically, DB2 and Sql Server. > I think I am pretty well armed with the "features" arguments, at least for > Oracle vs. Sql Server, but I really have no clue about licensing and > support costs for DB2 and Sql Server. Can somebody please provide ballpark > numbers? We will be comparing it to Oracle's latest licensing model > (https://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?site=OracleStoreUS&; >respid=22372). Oracle tells me that support costs are currently 22% of the > license per year. Of course, this is prior to any of the black magic which > they call "discounting." I would like comparable numbers for the other > vendors products. If I get a chance, I'll dig around on the web sites, but > I was also curious to know if the other vendors practice "discounting." > > Thank you, > Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8i and Veritas NetBackup
Rick, This is what our corporation uses as a standard. We are not having any of the problems you describe, however, we are on HP, AIX, Tru64, and NT, not Solaris. Jim [EMAIL PROTECTED] wrote: >Is anyone using this combination? We're having problems getting backups to work with >8i. It works fine with our 8 dbs, but when we try to backup the 8i ones, the control >panel says the backup has started, but it doesn't finish and usually has a dead rman >process on the db. > >We've working with Veritas support, but it's been 2 weeks and no answer. > >The dbs are 8.1.7.3 on Solaris 7 and we did patch the oracle executables. > >Thank you for any help. > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to import PDF files into Oracle database
Is is possible to store PDF files in oracle database to allow user accesses the files, open it and read it? If so, please advise how. I am using oracle8i with DBI running on Solaris8. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hours to support an Oracle database per week, documented somewher
Wow, what an open question How many instances? How big of a database? How many users? Development or production? What type of application? Amount of change management required? Unix or Windows? I could go on and on. -Joe On Fri, 22 Feb 2002 07:38:31 -0800 "Grabowy, Chris" <[EMAIL PROTECTED]> wrote: > > I have received the following from one of my co-workers at a client site. > Any links, docs, thoughts, gripes, complaints, help would be appreciated. > Thanks. > > -- > I am looking for any documentation out there on Oracle support - like the > amount of effort to support an oracle database. The client insists that our > revised estimate of 6 hours per week is too high. Do you know of anything > we can use as an independent data source??? Gardner document something from > Oracle etc I have looked, but can find nothing. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Grabowy, Chris > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Question
Thanks to all of you, who provided your input on this issue. I will test it and I will get in touch with you if I have any problem. Ashoke -Original Message- Sent: Friday, February 22, 2002 8:38 AM To: Multiple recipients of list ORACLE-L The following command will backup you archivelogs and then delete them if the backup is successful. (archivelog all delete input); HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 4:58 PM > Ashoke > If I understand you correctly, you are using RMAN to backup to disk, > rather than to a media manager. You are asking whether you can archive these > in RMAN, plus leave them on disk so they are readily available for recovery. > > I have used this configuration, and I have found that RMAN leaves > the archive logs on disk after it has backed them up. Also, I believe but > have not tested this, that in case of a recovery, RMAN first looks to the > original unarchived disk location for the archive logs and if it can't find > them there, it will retrieve them from its backup location (disk file or > tape if you are using a media manager), and put them where they should be, > then continue the recovery. > After thinking about this, I decided that using RMAN to backup the > archive logs wasn't buying me anything. Just making my setup more > complicated. If I was backing up to a media manager, then having RMAN back > up the archive logs would be great because it would be moving them to tape. > As it is, RMAN isn't compressing them before moving them to disk. My regular > nightly tape backup will give me a safety copy on tape. If I feel I need a > disk copy, I will just compress the files to another location and end up > with something significantly smaller. If I have overlooked something in my > logic, please point that out to me because I am just beginning to learn RMAN > and am frequently interrupted by other DBA duties, so learning is going very > slowly. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Thursday, February 21, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > > > Greetings, > > We are at Oracle 8.1.7 on Sun Solaris 7. > > Can we backup all the archive logs at any point of time but not deleting all > these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) > in the disk so that we don't need to restore the archive logs from rman > backup in case of some recovery up to point within last 2 days. > > Thanks, > Ashoke > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message t
RE: sql question
How about : select num from NUMBERS, ( select begin, end from RANGE) where num between begin and end; Paul -Original Message- Sent: Friday, February 22, 2002 10:14 AM To: Multiple recipients of list ORACLE-L You are right that the range aren't necessarily contigous. I'd probably have to write it in PL/SQL, I just want to see if one can do this with SQL. Thanks. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: sql question >Date: Thu, 21 Feb 2002 21:33:20 -0800 > >Rich, > >Are you sure that that is what you want ? >Suppose your range values were something like : > begin end > 1 9 > 1519 > 2329 >ie, the RANGE table shows that 10-14 and 20-22 are invalid ("not allowed") >values. > >Your problem statement and the SQL that Paul provides for the problem >statement >would return numbers like 10, 11, 20,21 which are, actually, invalid. > >You'd have to write a cursor to loop through the valid ranges ?? > >Hemant K Chitale >Principal DBA >Chartered Semiconductor Manufacturing Ltd > > >Paul Baumgartel <[EMAIL PROTECTED]> 22/02/2002 12:43 PM >Sent by: [EMAIL PROTECTED] > >Please respond to ORACLE-L > > To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > Subject: Re: sql question > > > > > > > > >To use your example column names: > >select num from numbers where num between >(select min(begin) from range) and (select max(end) from range); > > >--- oracle dba <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I have a SQL question. Suppose I have a table called RANGE looks > > like > > this: > > > > begin end > > 1 9 > > 1019 > > 2029 > > > > Then I have a table NUMBERS that's full of bunch of numbers like > > this: > > > > num > > 1 > > 2 > > 3 > > 4 > > ... > > 98 > > 99 > > 100 > > > > I want to write a SQL that returns the number that are within > > the ranges defined in the RANGE table. So number 1 through 29 > > should be returned. > > > > Can someone help me with this? Thanks. > > > > Rich > > > > _ > > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: oracle dba > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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! Sports - Coverage of the 2002 Olympic Games >http://sports.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOV
Hours to support an Oracle database per week, documented somewher
I have received the following from one of my co-workers at a client site. Any links, docs, thoughts, gripes, complaints, help would be appreciated. Thanks. -- I am looking for any documentation out there on Oracle support - like the amount of effort to support an oracle database. The client insists that our revised estimate of 6 hours per week is too high. Do you know of anything we can use as an independent data source??? Gardner document something from Oracle etc I have looked, but can find nothing. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Linux Cluster
On Friday 22 February 2002 16:03, "Henrik Ekenberg wrote: > Who is your configuration ? Two nodes running in VMWare on an HP laptop > 2- Which Linux version ? RH 7.1 + logical volume manager > 3- Which Oracle version ? 9.0.1.2.0 > 4- Is is fun ? That depends. -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Oracle8i - Oracle9i issue??????
C# is ms' we-can't-run-away-with-the-java-standard-so-here's-our-own-'c-like'-language language for .Net. There's a good bit of foofaraw over whether or not it is better/faster than/will kill java etc. in the dev community. Not to be confused with the latest version of visual C++ (which is mostly the same as old C++, but includes extensions for coding against the .net virtual machine) or J#, which is supposedly yet still more Java-like than C#. Interested readers can get the party line at http://www.msdn.microsoft.com/msdnmag/issues/0900/csharp/csharp.asp. Cheers, -Roy Roy Pardee Programmer/Analyst SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Friday, February 22, 2002 12:38 AM To: Multiple recipients of list ORACLE-L Yeah they refer to it as C "Sharp" as in the music # symbol. It is Microsoft's C.Net - I think. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 10:08 AM To: Multiple recipients of list ORACLE-L C# ? Hemant K Chitale Principal DBA Chartered Semiconductor Manufacturing Ltd Denham Eva <[EMAIL PROTECTED]> 22/02/2002 03:13 PM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) Subject: Oracle8i - Oracle9i issue?? Hello Guru's I wonder if any of you have had this problem, we have a external company developing a software package in C#. On their Oracle9i test system, the software works fine, however once brought accross to our systems, which is an Oracle8i ( 817) system the software gives a (ORA - 00933 SQL command not properly ended) error, but funny enough only on the one window. I am told by them that they do straight select from a table, saving the returned columns in variables etc. The only difference is they don't have any semi-colons (;) at the end of the their queries. But catch 22 it works on the other screens(windows). Hope you folks can help TIA Denham This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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
Rich, how about : SELECT col1 FROM TEST WHERE EXISTS(SELECT 1 FROM RANGE WHERE col1 BETWEEN BEGIN AND END) The above is where the TEST table contains the list of numbers. I assume that, even though your RANGE table has begin/end entries of 1,9 that 1 and 9 are valid. If they are not valid, you could either change the values to be 2,8 or change the where clause to say WHERE col1 > BEGIN and col1 < END. Either way works, no? Hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, February 22, 2002 10:14 AM To: Multiple recipients of list ORACLE-L You are right that the range aren't necessarily contigous. I'd probably have to write it in PL/SQL, I just want to see if one can do this with SQL. Thanks. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: sql question >Date: Thu, 21 Feb 2002 21:33:20 -0800 > >Rich, > >Are you sure that that is what you want ? >Suppose your range values were something like : > begin end > 1 9 > 1519 > 2329 >ie, the RANGE table shows that 10-14 and 20-22 are invalid ("not allowed") >values. > >Your problem statement and the SQL that Paul provides for the problem >statement >would return numbers like 10, 11, 20,21 which are, actually, invalid. > >You'd have to write a cursor to loop through the valid ranges ?? > >Hemant K Chitale >Principal DBA >Chartered Semiconductor Manufacturing Ltd > > >Paul Baumgartel <[EMAIL PROTECTED]> 22/02/2002 12:43 PM >Sent by: [EMAIL PROTECTED] > >Please respond to ORACLE-L > > To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > Subject: Re: sql question > > > > > > > > >To use your example column names: > >select num from numbers where num between >(select min(begin) from range) and (select max(end) from range); > > >--- oracle dba <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I have a SQL question. Suppose I have a table called RANGE looks > > like > > this: > > > > begin end > > 1 9 > > 1019 > > 2029 > > > > Then I have a table NUMBERS that's full of bunch of numbers like > > this: > > > > num > > 1 > > 2 > > 3 > > 4 > > ... > > 98 > > 99 > > 100 > > > > I want to write a SQL that returns the number that are within > > the ranges defined in the RANGE table. So number 1 through 29 > > should be returned. > > > > Can someone help me with this? Thanks. > > > > Rich > > > > _ > > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: oracle dba > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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! Sports - Coverage of the 2002 Olympic Games >http://sports.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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: Dropping users from Oracle 9i seed database.
Title: Dropping users from Oracle 9i seed database. You can drop the following users: scott (demo) ctxsys (context) wksys (workflow) mdsys (Oracle*Media) Hopefully, this font is big enough. Yours was a wee bit too small. -Original Message-From: Yuval Arnon [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 21, 2002 5:18 PMTo: Multiple recipients of list ORACLE-LSubject: Dropping users from Oracle 9i seed database. Hi, Using Oracle Configuration Manager a handful of users are created. Which of these users can be safely dropped without affecting Oracle health. List of users. AURORA$JIS$UTILITY$ CTXSYS HR LBACSYS MDSYS OE OLAPSYS ORDSYS OSE$HTTP$ADMIN OUTLN PM QS QS_CBADM QS_CS QS_ES QS_OS QS_WS SCOTT SH WKSYS TIA Yuval.
Re: sql question
You are right that the range aren't necessarily contigous. I'd probably have to write it in PL/SQL, I just want to see if one can do this with SQL. Thanks. >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: sql question >Date: Thu, 21 Feb 2002 21:33:20 -0800 > >Rich, > >Are you sure that that is what you want ? >Suppose your range values were something like : > begin end > 1 9 > 1519 > 2329 >ie, the RANGE table shows that 10-14 and 20-22 are invalid ("not allowed") >values. > >Your problem statement and the SQL that Paul provides for the problem >statement >would return numbers like 10, 11, 20,21 which are, actually, invalid. > >You'd have to write a cursor to loop through the valid ranges ?? > >Hemant K Chitale >Principal DBA >Chartered Semiconductor Manufacturing Ltd > > >Paul Baumgartel <[EMAIL PROTECTED]> 22/02/2002 12:43 PM >Sent by: [EMAIL PROTECTED] > >Please respond to ORACLE-L > > To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> > cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group) > Subject: Re: sql question > > > > > > > > >To use your example column names: > >select num from numbers where num between >(select min(begin) from range) and (select max(end) from range); > > >--- oracle dba <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I have a SQL question. Suppose I have a table called RANGE looks > > like > > this: > > > > begin end > > 1 9 > > 1019 > > 2029 > > > > Then I have a table NUMBERS that's full of bunch of numbers like > > this: > > > > num > > 1 > > 2 > > 3 > > 4 > > ... > > 98 > > 99 > > 100 > > > > I want to write a SQL that returns the number that are within > > the ranges defined in the RANGE table. So number 1 through 29 > > should be returned. > > > > Can someone help me with this? Thanks. > > > > Rich > > > > _ > > Send and receive Hotmail on your mobile device: http://mobile.msn.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: oracle dba > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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! Sports - Coverage of the 2002 Olympic Games >http://sports.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(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.com >-- >Author: > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oracle dba INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
RE: 8i and Veritas NetBackup
Title: RE: 8i and Veritas NetBackup The folloiwng is a good post from Samir which I kept. It seems to cover your environment well. Hope it helps John Hi, In order for RMAN to work with a third party backup product the third party vendor writes an interface to an Oracle supplied API and supplies this in the form of a library. Oracle supplies a default copy of the library as $ORACLE_HOME/lib/libobk.so which has the RMAN default functionality of writing to disk only. Installation of an RMAN media management product logically replaces this library. How this logical replacement is done depends on several Oracle documents and one netbackup document, most of which contradict each other. As long as it is clear how the library is logically presented to Oracle it doesn't matter how it is done. The library that Oracle currently uses can be established by executing: ldd $ORACLE_HOME/bin/oracle This will list the libraries linked to the Oracle executable, specifically libobk.so. The Veritas supplied file is called libobk.so.1. Oracle thinks it is called libobk.so, which it looks for in LD_LIBRARY_PATH. Therefore a soft link is needed from libobk.so somewhere in LD_LIBRARY_PATH to the Netbackup supplied libobk.so.1. This can be done with: LD_LIBRARY_PATH=$ORACLE_HOME/lib: and then either: ln -s /opt/openv/netbackup/bin/libobk.so.1 $ORACLE_HOME/lib/libobk.so or: cp /opt/openv/netbackup/bin/libobk.so.1 $ORACLE_HOME/lib/libobk.so.1 ln -s $ORACLE_HOME/lib/libobk.so.1 $ORACLE_HOME/lib/libobk.so Other combinations of these links are obviously possible, but the important thing is to be consistent. With several ORACLE_HOME's the former is preferable, the latter becomes more relevant if a version dependency had been discovered between RMAN and Netbackup such that each ORACLE_HOME needed a different copy of the library. Additionally, Oracle 8.0.5 statically links the library into the Oracle executable, so once the executable is relinked it doesn't matter what happens to the original library file. At 8.1.6 however the library is THEORETICALLY dynamically linked and so always depends on finding a copy on LD_LIBRARY_PATH. A bug in 8.1.6 (1252142) means this dynamic linking does not work and the library still has to be statically linked to the Oracle executable. The bug is fixed at 8.1.7. Hope this helps. Hi Listers, I have a question regarding using 8i RMAN with Netbackup 3.4. I remember on 8i one no longer needs to relink the oracle executable when intergrate with a 3rd party backup software. All I have to do it change the symbolic link $ORACLE_HOME/lib/libobk.so to point to the media management library. Now from the Netbackup 3.4 for Oracle manual, it says on Solaris for 8.1.6, you need to relink the oracle executable by doing: make -f ins_rdbms.mk ioracle LLIBOBK=-lobk So the question is should I relink or not? Thanks for your feedback. Rich Nice answer Samir. As an additional note... after linking I've used the sbttest utility from Oracle to verify a working installation. (We're using Netbackup with Linux and have encountered problems which Veritas is working on.) The sbttest program is nice but for complete backup installation testing I believe in performing test recoveries. I've created small test databases on production servers and have scripted several recovery scenarios. For our current situation it turns out that we can get a successful backup but restores are a problem. Since backups aren't any good if you can't restore the backup is suspect. We can restore files from tape to disk but finishing the recovery requires getting out of RMAN and recovering from the SQL prompt. We can also restore from RMAN as long as we don't have more than 2 commands in the run { commands... } syntax. Of course this could get quite tedious in a multiple datafile restore scenario so we're insisting that Veritas fix the communication problems between RMAN, Netbackup and our tape robot. So I guess the object lesson from all this is that, regardless of "apparent" linking success, it pays to be anal and thorough when it comes to validating your backup implementation and the best way to do this is to perform some actual recoveries. Hi Listers, I have a question regarding using 8i RMAN with Netbackup 3.4. I remember on 8i one no longer needs to relink the oracle executable when intergrate with a 3rd party backup software. All I have to do it change the symbolic link $ORACLE_HOME/lib/libobk.so to point to the media management library. Now from the Netbackup 3.4 for Oracle manual, it says on Solaris for 8.1.6, you need to relink the oracle executable by doing: make -f ins_rdbms.mk ioracle LLIBOBK=-lobk So the question is should I relink or not? Thanks for your feedback. Rich -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 14:38 To: Multiple recipients of list ORACLE-L Subject: 8i and Veritas NetBackup Is anyone using this combinat
RE: Problem with Rollback segment getting locked
Anjo, I usually advise in the strongest possible words against setting "optimal". May logic is that if rollback segment extends occasionally then we should leave the space allocated to a) prevent the dynamic disk space management and b) to make room for large queries. The space will be consumed anyhow. What's your take on the "optimal" parameter? -Original Message-From: Anjo Kolk [mailto:[EMAIL PROTECTED]]Sent: Friday, February 22, 2002 8:53 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Problem with Rollback segment getting locked What lock ? And did you specify optimal ? Viral Amin wrote: Hi All, I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments. My Query is..Why Oracle is just using the few rollback segments from the avilable 12 & then others have to wait till the locks on the rollback segments are released. Pls help..This is URGENT!! Regards, Viral Amin
replication setup questions
I am thinking of implementing replication for remote sites. What I have not been able to gather from documentation to date is what are the pre steps required to setup a replicated site(master destination) what are the steps to bring the replicated site online after the master definition site has failed is replicating to remote sites a band-width hog are there any issues creating a replicated site when the main site has RMAN implemented is there a detail step by step document which shows how to create a replication master site including the pre-configuration steps We are using 8.1.7.3 on solaris 2.6. Our database currently generates hundreds of megs of redo because of all the transactions occurring. But the database itself is about 50 gigs. Thanks <>
Linux Cluster
Hi from the Swow storm from Sweden, We wants to try to run Oracle on a Linux Cluster. Is someone using Oracle on a Linux Cluster ? Who is your configuration ? 1- (DELL,HP,Compaq,..) 2- Which Linux version ? 3- Which Oracle version ? 4- Is is fun ? Best Regards, HEnrik -- --- There's fun in being serious. -- Wynton Marsalis -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: data dictionary View about jobs
Hi Chuan, The views dba_jobs, user_jobs show information about the jobs. It will be removed after the next execution. Once happen to me and the job had to broke it before remove it. The experts of the list can show more light about the subject. Luck, -Original Message- Sent: Friday, 22 February, 2002 1:03 AM To: Multiple recipients of list ORACLE-L Hi, All, Is there any Oracle data dict view to see whether the dbms jobs is on the job queue or not. Why I ask this is that I use dbms_job.remove to remove one job, later on, I check it using user_jobs, it's still there. Thus issue dbms_job.remove again, this time, this execution seems hung there. I log into sys and issue dbms_job.remove, I got the following error ORA-23421: job number 41 is not a job in the job queue ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86 ORA-06512: at "SYS.DBMS_IJOB", line 525 ORA-06512: at "SYS.DBMS_JOB", line 166 ORA-06512: at line 2 Could anyone tell me why this happens? or is there any dict view to check the job queue? Thanks in advance, Chuan Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chuan Zhang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8i and Veritas NetBackup
Is anyone using this combination? We're having problems getting backups to work with 8i. It works fine with our 8 dbs, but when we try to backup the 8i ones, the control panel says the backup has started, but it doesn't finish and usually has a dead rman process on the db. We've working with Veritas support, but it's been 2 weeks and no answer. The dbs are 8.1.7.3 on Solaris 7 and we did patch the oracle executables. Thank you for any help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Q] how to setup sql*net trace on client side?
I tried to setup SQl*NET (ORACLE 8/8i)trace on client side and put trace_level_server=10 on sqlnet.ora. I did NOT see log file ($ORACLE_HOME/network/log) generate. Does anyone know why? Thanks. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Question
The following command will backup you archivelogs and then delete them if the backup is successful. (archivelog all delete input); HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, February 21, 2002 4:58 PM > Ashoke > If I understand you correctly, you are using RMAN to backup to disk, > rather than to a media manager. You are asking whether you can archive these > in RMAN, plus leave them on disk so they are readily available for recovery. > > I have used this configuration, and I have found that RMAN leaves > the archive logs on disk after it has backed them up. Also, I believe but > have not tested this, that in case of a recovery, RMAN first looks to the > original unarchived disk location for the archive logs and if it can't find > them there, it will retrieve them from its backup location (disk file or > tape if you are using a media manager), and put them where they should be, > then continue the recovery. > After thinking about this, I decided that using RMAN to backup the > archive logs wasn't buying me anything. Just making my setup more > complicated. If I was backing up to a media manager, then having RMAN back > up the archive logs would be great because it would be moving them to tape. > As it is, RMAN isn't compressing them before moving them to disk. My regular > nightly tape backup will give me a safety copy on tape. If I feel I need a > disk copy, I will just compress the files to another location and end up > with something significantly smaller. If I have overlooked something in my > logic, please point that out to me because I am just beginning to learn RMAN > and am frequently interrupted by other DBA duties, so learning is going very > slowly. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Thursday, February 21, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > > > Greetings, > > We are at Oracle 8.1.7 on Sun Solaris 7. > > Can we backup all the archive logs at any point of time but not deleting all > these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) > in the disk so that we don't need to restore the archive logs from rman > backup in case of some recovery up to point within last 2 days. > > Thanks, > Ashoke > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mandal, Ashoke > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Licensing vs. The Others
Our management has started asking questions about how Oracle's licensing costs compare to other database vendors. Specifically, DB2 and Sql Server. I think I am pretty well armed with the "features" arguments, at least for Oracle vs. Sql Server, but I really have no clue about licensing and support costs for DB2 and Sql Server. Can somebody please provide ballpark numbers? We will be comparing it to Oracle's latest licensing model (https://oraclestore.oracle.com/OA_HTML/ibeCZzpHome.jsp?site=OracleStoreUS&respid=22372). Oracle tells me that support costs are currently 22% of the license per year. Of course, this is prior to any of the black magic which they call "discounting." I would like comparable numbers for the other vendors products. If I get a chance, I'll dig around on the web sites, but I was also curious to know if the other vendors practice "discounting." Thank you, Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sorry RE: Woopeee and TWO ORA-600's!
sorry ... I am trying too fast ... the error parameter was different it wasn't 26599 ... I am heading for a coffee. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, February 22, 2002 9:28 AM To: '[EMAIL PROTECTED]' Couple of days ago I have a ORA-600 [26599], it was being signaled during our periodic recompilation cron job. It turned out to be that a clever duheveloper had a hard new line character in an object name. Once we took it out, the error went away. This happened in 9012. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
Re: Problem with Rollback segment getting locked
What lock ? And did you specify optimal ? Viral Amin wrote: Hi All, I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments. My Query is..Why Oracle is just using the few rollback segments from the avilable 12 & then others have to wait till the locks on the rollback segments are released. Pls help..This is URGENT!! Regards, Viral Amin
Recall: Woopeee and TWO ORA-600's!
Jamadagni, Rajendra would like to recall the message, "Woopeee and TWO ORA-600's!". *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Woopeee and TWO ORA-600's!
Couple of days ago I have a ORA-600 [26599], it was being signaled during our periodic recompilation cron job. It turned out to be that a clever duheveloper had a hard new line character in an object name. Once we took it out, the error went away. This happened in 9012. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Problem with Rollback segment getting locked
Title: Problem with Rollback segment getting locked Hi, Viral, Are these RB segments public? Regards, Sergey -Original Message- From: Viral Amin [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 7:29 AM To: Multiple recipients of list ORACLE-L Subject: Problem with Rollback segment getting locked Hi All, I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments. My Query is..Why Oracle is just using the few rollback segments from the avilable 12 & then others have to wait till the locks on the rollback segments are released. Pls help..This is URGENT!! Regards, Viral Amin
RE: Woopeee and TWO ORA-600's!
9i starts to use some of the java stuff all by itself which possibly explains the error. For example, there is now a trigger on every create-table to handle the cdc publish/subscribe features. This of course means you typically to allocate something to the java pool (if you have installed java) Take a look at rmjvm (as opposed to jvmrm) hth connor --- Mark Leith <[EMAIL PROTECTED]> wrote: > Ahh well! > > I have another question following this: > > I am also getting the following error on startup: > > Fri Feb 22 09:33:04 2002 > Errors in file > C:\oracle\admin\ORCL\udump\ORA03028.TRC: > ORA-04031: unable to allocate 4032 bytes of shared > memory ("shared > pool","unknown object","joxs heap > init","ioc_allocate_pal") > > Fri Feb 22 09:33:10 2002 > Errors in file > C:\oracle\admin\ORCL\udump\ORA03028.TRC: > ORA-00604: error occurred at recursive SQL level 1 > ORA-04031: unable to allocate 4032 bytes of shared > memory ("shared > pool","unknown object","joxs heap > init","ioc_allocate_pal") > ORA-06512: at "SYS.DBMS_JAVA", line 216 > ORA-06512: at line 2 > > Completed: alter database open > > This is because I set the java_pool to 0 in my init > file (we don't use > anything java related against our databases). Does > anybody know how to > disable or de-install java from the database? I've > taken a look at the > jvmrm.sql in RDBMS/Admin: > > -- Remove some portion of the Java related data > dictionary objects > > -- This script must be run as a subscript of a > script which sets the > -- variable jvmrmaction. > -- Possible values are > -- FULL_REMOVAL:remove all java related > objects > > But can't find anything of a script that will call > this? Anyone have any > ideas? > > Cheers > > Mark (Why do I bother?) Leith > > -Original Message- > Sent: 22 February 2002 10:18 > To: Multiple recipients of list ORACLE-L > > > Mark > The ora600 lookup tool on Metalink states that > there is no description for > this code > John > -Original Message- > Sent: 22 February 2002 09:34 > To: Multiple recipients of list ORACLE-L > > > Hi Ladies and Gents, > I installed 9.0.1 on to my Win2K machine yesterday, > and whilst installing an > un-named monitoring tool against it this morning, > the instance crashed with > a bunch of ORA-600's in the alert log. Below are the > two that appeared, > though the first turned up about 10 times > concurrently: > Fri Feb 22 09:22:28 2002 > Errors in file > C:\oracle\admin\ORCL\udump\ORA01668.TRC: > ORA-00600: internal error code, arguments: [26599], > [1], [190], [], [], [], > [], [] > Fri Feb 22 09:22:34 2002 > Errors in file > C:\oracle\admin\ORCL\udump\ORA01668.TRC: > ORA-00600: internal error code, arguments: [150], > [], [], [], [], [], [], [] > Anyone ever seen these before? I'm not going to call > support as this is only > a sandbox database, so please don't tell me to call > them or log a tar.. I > have enough to do today already! :( > Any feedback on these is, however, much appreciated! > Thanks > Mark > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > > > = > This electronic message contains information from > the mmO2 plc Group > which may be privileged or confidential. The > information is intended to be > for the use of the individual(s) or entity named > above. If you are not the > intended recipient be aware that any disclosure, > copying, distribution or > use of the contents of this information is > prohibited. If you have received > this electronic message in error, please notify us > by telephone or email > (to the numbers or address above) immediately. > = > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > -
RE: Problem with Rollback segment getting locked
Title: Problem with Rollback segment getting locked I might not be right but why dont u try reducing the number of transaction per rollback segment and see -Original Message-From: Viral Amin [mailto:[EMAIL PROTECTED]]Sent: Friday, February 22, 2002 7:29 AMTo: Multiple recipients of list ORACLE-LSubject: Problem with Rollback segment getting locked Hi All, I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments. My Query is..Why Oracle is just using the few rollback segments from the avilable 12 & then others have to wait till the locks on the rollback segments are released. Pls help..This is URGENT!! Regards, Viral Amin
RE: Woopeee and TWO ORA-600's!
Mark, I've had success running removing Java by running the following package: exec sys.rmjvm(true); The package sould have been installed when Java was installed. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, February 22, 2002 6:08 AM To: Multiple recipients of list ORACLE-L Ahh well! I have another question following this: I am also getting the following error on startup: Fri Feb 22 09:33:04 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") Fri Feb 22 09:33:10 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") ORA-06512: at "SYS.DBMS_JAVA", line 216 ORA-06512: at line 2 Completed: alter database open This is because I set the java_pool to 0 in my init file (we don't use anything java related against our databases). Does anybody know how to disable or de-install java from the database? I've taken a look at the jvmrm.sql in RDBMS/Admin: -- Remove some portion of the Java related data dictionary objects -- This script must be run as a subscript of a script which sets the -- variable jvmrmaction. -- Possible values are -- FULL_REMOVAL:remove all java related objects But can't find anything of a script that will call this? Anyone have any ideas? Cheers Mark (Why do I bother?) Leith -Original Message- Sent: 22 February 2002 10:18 To: Multiple recipients of list ORACLE-L Mark The ora600 lookup tool on Metalink states that there is no description for this code John -Original Message- Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Hi Ladies and Gents, I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an un-named monitoring tool against it this morning, the instance crashed with a bunch of ORA-600's in the alert log. Below are the two that appeared, though the first turned up about 10 times concurrently: Fri Feb 22 09:22:28 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], [] Fri Feb 22 09:22:34 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], [] Anyone ever seen these before? I'm not going to call support as this is only a sandbox database, so please don't tell me to call them or log a tar.. I have enough to do today already! :( Any feedback on these is, however, much appreciated! Thanks Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
RE: Woopeee and TWO ORA-600's!
Title: RE: Woopeee and TWO ORA-600's! Thanks John, worked like a charm! Thanks for the pointer too Tom, but thanks to John it's all sorted.. Cheers! Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Hallas JohnSent: 22 February 2002 12:43To: Multiple recipients of list ORACLE-LSubject: RE: Woopeee and TWO ORA-600's! Mark, Here are a couple of notes I saved on the subject John rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following. If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql has to be run. Unfortunately it does not remove all the components. Following workaround has to be used to get over the bugs. 1. Restart the database. 2. Start a different session other than the one that started the database. 3. Run initjvmaux.sql 4. Run rmjvm.sql 5. Run following SQL queries, LOG on as SYS. --The minimum action to remove JIS trigger is running the following sql. drop trigger JIS$ROLE_TRIGGER$; delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; delete from aurora$dyn$reg; . Are you sure its hanging. Documents have said it can take up to an hour and its that statement that tends to take the longest. I have seen quite the variation in time depending on the system I am on. -Original Message- From: Saravana Kumar [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 11, 2001 11:25 PM To: Multiple recipients of list ORACLE-L Subject: initjvm.sql Hi friends, I have problem during execution of initjvm.sql The step's which i have followed. 1)Increased system tablespace 200 mb 2)increased the shared pool size 50mb 3)increased the java pool size to 50mb 4)ran rmjvm.sql 5)initjvm.sql While runnig initjvm.sql the script hangs while i get the statement create or replace java system; -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 11:08 To: Multiple recipients of list ORACLE-L Subject: RE: Woopeee and TWO ORA-600's! Ahh well! I have another question following this: I am also getting the following error on startup: Fri Feb 22 09:33:04 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") Fri Feb 22 09:33:10 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") ORA-06512: at "SYS.DBMS_JAVA", line 216 ORA-06512: at line 2 Completed: alter database open This is because I set the java_pool to 0 in my init file (we don't use anything java related against our databases). Does anybody know how to disable or de-install java from the database? I've taken a look at the jvmrm.sql in RDBMS/Admin: -- Remove some portion of the Java related data dictionary objects -- This script must be run as a subscript of a script which sets the -- variable jvmrmaction. -- Possible values are -- FULL_REMOVAL: remove all java related objects But can't find anything of a script that will call this? Anyone have any ideas? Cheers Mark (Why do I bother?) Leith -Original Message- Sent: 22 February 2002 10:18 To: Multiple recipients of list ORACLE-L Mark The ora600 lookup tool on Metalink states that there is no description for this code John -Original Message- Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Hi Ladies and Gents, I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an un-named monitoring tool against it this morning, the instance crashed with a bunch of ORA-600's in the alert log. Below are the two that appeared, though the first turned up about 10 times concurrently: Fri Feb 22 09:22:28 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], [] Fri Feb 22 09:22:34 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], [] Anyone ever seen these before? I'm not going to call support as this is only a sandbox database, so please don't tell me to call them or log a tar.. I have enough to do today already! :( Any feedback on these is, however, much appreciated! Thanks Mark === Mark Leith
Re: How to make deletes faster.
You should consider doing a create newtable as select with the oposite conditions as your delete, followed by a truncate/drop, exchange partition or whatever. Delete is really hard against the undo segments. /Bjørn. On Thursday 21 February 2002 23:13, you wrote: > Hello All, > I have a non-partitioned table with 20 millions > records and growing. Every night a pl/sql stored > procedures deletes around 1 million rows 10,000 at a > time.Currently it is taking aroung 1 hour to delete 1 > million messages. > Is there any way I can make deletes faster. I need > good suggestions. I have already tried all the obvious > init.ora parameters like make_delete_faster=true but > they do not seem to work.:-) > > Thanks > Sonia > > > __ > Do You Yahoo!? > Yahoo! Sports - Coverage of the 2002 Olympic Games > http://sports.yahoo.com -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Anybody against using views?
It might be the case, that the dictionary cache cannot store any information of type LONG (which the view text is), but that requires more investigation. If somebody knows, please inform the rest of us. But you can just turn on sql_trace and see the query against view$ for each parse. /Bjørn. On Thursday 21 February 2002 22:23, you wrote: > How did you determine that it's not stored in the DC? > > The DC is not a data store but it's a cache. > > Just curios. > > Thanks, > > Waleed > > -Original Message- > Sent: Thursday, February 21, 2002 3:48 PM > To: Multiple recipients of list ORACLE-L > > > A thing about views, that nobody else seem to have mentioned is that the > view > text is not stored in the dictionary cache. Hence, each time you hard > parse > > a sql statement with a view, Oracle will query view$ to get the text. > Hence, > if you are at the limit of scalability or performance due to hard parses, > views make things worse. > > /Bjørn. > > On Thursday 21 February 2002 17:18, you wrote: > > We have several applications that use views extensively. On the other > > hand > > > there are several apps that use no views at all. We have a new developer > > who wants to use views when writing reports in Crystal Reports. The > > application administrator is leery of using views and ask the DBA group > > what we think. I can see several reasons to use views and a few reasons > > not to use them. I was just wondering what the rest of the group > > thought. > > > > Ron Smith > > DBA > > Kerr-McGee Corp -- Bjørn Engsig, Miracle A/S http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Bj=F8rn=20Engsig?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JDBC problem
- Original Message - > I am not at all getting connected to the database. what is the exception? if u don't get connection for some reason then an exception is thrown with the proper error code can u access the instance [EMAIL PROTECTED]:1521:edb with any tool? also next time don't send the whole source tree for the project to the list, there were just 2 jdbc related statements in this source Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem with Rollback segment getting locked
Title: Problem with Rollback segment getting locked Hi All, I have about 12 Rollback segmennts in my database & 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments. My Query is..Why Oracle is just using the few rollback segments from the avilable 12 & then others have to wait till the locks on the rollback segments are released. Pls help..This is URGENT!! Regards, Viral Amin
RE: RMAN Question
You can tell RMAN to delete the archive files. We tell RMAN to keep the last 12 hours on disk. run { allocate channel ch1 type disk format '/bkup1/oracle/%d/full_s%s_p%p_%t'; allocate channel ch2 type disk format '/bkup5/oracle/%d/full_s%s_p%p_%t'; set limit channel ch1 kbytes=100; # Limit sets to 1 Gb. set limit channel ch2 kbytes=100; # filesperset is used to avoid O R A-04030 backup full database filesperset=4 tag='daily_full_backup'; allocate channel ch3 type disk format '/bkup5/oracle/%d/arc_s%s_p%p_%t'; allocate channel ch4 type disk format '/bkup1/oracle/%d/arc_s%s_p%p_%t'; set limit channel ch3 kbytes=100; set limit channel ch4 kbytes=100; backup filesperset=20 (archivelog from time 'sysdate-12/24' channel ch3 ) (archivelog until time 'sysdate-12/24' delete input channel ch4 ); } The reason that we use RMAN to backup our archive logs is so that we have a complete backup on our tapes. We backup to disk, which is then backed up to tape. If I want to restore my database from 3 weeks ago, I know that the tape from that day contains all of the files I need to restore my database for that day. This is especially important if I am restoring a hot backup or I am restoring to a specific point in time (i.e. a point in time that is different from the backup time). On a separate but related note, I previously posted a script which used SET UNTIL TIME and TO_DATE. e.g.: #set until time "to_date(0125200207,mmddhh24miss)"; I obtained this from a note on MetaLink. It turns out that this doesn't work, due to a bug (1887009). I found it mentioned on a forum under Doc ID: 180832.995. It is supposedly fixed in 9.0.2. The workaround is to use NLS_DATE_FORMAT. Be sure to set NLS_LANG as well, otherwise NLS_DATE_FORMAT is ignored (at least on 8.1.7 on Tru64). Jay Hostetter Oracle DBA D. & E. Communications Ephrata, PA USA >>> [EMAIL PROTECTED] 02/21/02 04:58PM >>> Ashoke If I understand you correctly, you are using RMAN to backup to disk, rather than to a media manager. You are asking whether you can archive these in RMAN, plus leave them on disk so they are readily available for recovery. I have used this configuration, and I have found that RMAN leaves the archive logs on disk after it has backed them up. Also, I believe but have not tested this, that in case of a recovery, RMAN first looks to the original unarchived disk location for the archive logs and if it can't find them there, it will retrieve them from its backup location (disk file or tape if you are using a media manager), and put them where they should be, then continue the recovery. After thinking about this, I decided that using RMAN to backup the archive logs wasn't buying me anything. Just making my setup more complicated. If I was backing up to a media manager, then having RMAN back up the archive logs would be great because it would be moving them to tape. As it is, RMAN isn't compressing them before moving them to disk. My regular nightly tape backup will give me a safety copy on tape. If I feel I need a disk copy, I will just compress the files to another location and end up with something significantly smaller. If I have overlooked something in my logic, please point that out to me because I am just beginning to learn RMAN and am frequently interrupted by other DBA duties, so learning is going very slowly. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, February 21, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Greetings, We are at Oracle 8.1.7 on Sun Solaris 7. Can we backup all the archive logs at any point of time but not deleting all these archive logs as we like to keep the archive logs for 2 days(SYSDATE-1) in the disk so that we don't need to restore the archive logs from rman backup in case of some recovery up to point within last 2 days. Thanks, Ashoke -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandal, Ashoke INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mail
RE: Woopeee and TWO ORA-600's!
Title: RE: Woopeee and TWO ORA-600's! Mark, Here are a couple of notes I saved on the subject John rmjvm.sql doesnot remove all the components properly. If your resources sizes are ok, then try following. If for any reason the installation fails then $ORACLE_HOME/javavm/install/rmjvm.sql has to be run. Unfortunately it does not remove all the components. Following workaround has to be used to get over the bugs. 1. Restart the database. 2. Start a different session other than the one that started the database. 3. Run initjvmaux.sql 4. Run rmjvm.sql 5. Run following SQL queries, LOG on as SYS. --The minimum action to remove JIS trigger is running the following sql. drop trigger JIS$ROLE_TRIGGER$; delete from ducs$ where owner='SYS' and pack='JIS$INTERCEPTOR$' and proc='USER_DROPPED'; delete from aurora$startup$classes$ where classname='oracle.aurora.mts.http.admin.RegisterService'; delete from aurora$dyn$reg; . Are you sure its hanging. Documents have said it can take up to an hour and its that statement that tends to take the longest. I have seen quite the variation in time depending on the system I am on. -Original Message- From: Saravana Kumar [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 11, 2001 11:25 PM To: Multiple recipients of list ORACLE-L Subject: initjvm.sql Hi friends, I have problem during execution of initjvm.sql The step's which i have followed. 1)Increased system tablespace 200 mb 2)increased the shared pool size 50mb 3)increased the java pool size to 50mb 4)ran rmjvm.sql 5)initjvm.sql While runnig initjvm.sql the script hangs while i get the statement create or replace java system; -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 11:08 To: Multiple recipients of list ORACLE-L Subject: RE: Woopeee and TWO ORA-600's! Ahh well! I have another question following this: I am also getting the following error on startup: Fri Feb 22 09:33:04 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") Fri Feb 22 09:33:10 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") ORA-06512: at "SYS.DBMS_JAVA", line 216 ORA-06512: at line 2 Completed: alter database open This is because I set the java_pool to 0 in my init file (we don't use anything java related against our databases). Does anybody know how to disable or de-install java from the database? I've taken a look at the jvmrm.sql in RDBMS/Admin: -- Remove some portion of the Java related data dictionary objects -- This script must be run as a subscript of a script which sets the -- variable jvmrmaction. -- Possible values are -- FULL_REMOVAL: remove all java related objects But can't find anything of a script that will call this? Anyone have any ideas? Cheers Mark (Why do I bother?) Leith -Original Message- Sent: 22 February 2002 10:18 To: Multiple recipients of list ORACLE-L Mark The ora600 lookup tool on Metalink states that there is no description for this code John -Original Message- Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Hi Ladies and Gents, I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an un-named monitoring tool against it this morning, the instance crashed with a bunch of ORA-600's in the alert log. Below are the two that appeared, though the first turned up about 10 times concurrently: Fri Feb 22 09:22:28 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], [] Fri Feb 22 09:22:34 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], [] Anyone ever seen these before? I'm not going to call support as this is only a sandbox database, so please don't tell me to call them or log a tar.. I have enough to do today already! :( Any feedback on these is, however, much appreciated! Thanks Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
Re: JDBC problem
Hi, I think you might have read my java code. My problem is I am not at all getting connected to the database. Anything wrong in my code.i don't understand whether the problem is with some settings on the server[Solaris] or Java code Please check my code & give me your suggestions Thanks Sankar On Fri, 22 Feb 2002, Marin Dimitrov wrote: > > - Original Message - > From: "P.V.Sankar" > > > I am using java only > > The code as follows: > > Please give me some suggestions in solving this problem > > > > which problem? > > what is the exception? > > > Marin > > > "...what you brought from your past, is of no use in your present. When > you must choose a new path, do not bring old experiences with you. > Those who strike out afresh, but who attempt to retain a little of the > old life, end up torn apart by their own memories. " > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: P.V.Sankar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Raster Data in Oracle Spatial
I am getting some conflicting answers to what I deem to be a fairly simple question. Does Oracle Spatial support storage of raster data? We are looking at this in particular to reference to GIS systems. I have contacted MapInfo Support and have been told that "Oracle Spatial does not store Images or any type of raster data including Mr Sid and other compressed formats. Rasters are usually stored locally." However, I have just come across something referencing the GeoImage Component of Oracle. What is this? Does it allow the storage of raster data in Oracle Spatial? And if it does, can you store compressed images such as Mr. Sid? I'm really hoping someone out there can clarify this for me. Thank you. Sharyn McMenamin email: [EMAIL PROTECTED] * ** *** ** * ** *** ** * ** *** ** * This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message has been scanned for viruses. * ** *** ** * ** *** ** * ** *** ** * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: McMenamin. Sharyn ESBI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Woopeee and TWO ORA-600's!
Ahh well! I have another question following this: I am also getting the following error on startup: Fri Feb 22 09:33:04 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") Fri Feb 22 09:33:10 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA03028.TRC: ORA-00604: error occurred at recursive SQL level 1 ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal") ORA-06512: at "SYS.DBMS_JAVA", line 216 ORA-06512: at line 2 Completed: alter database open This is because I set the java_pool to 0 in my init file (we don't use anything java related against our databases). Does anybody know how to disable or de-install java from the database? I've taken a look at the jvmrm.sql in RDBMS/Admin: -- Remove some portion of the Java related data dictionary objects -- This script must be run as a subscript of a script which sets the -- variable jvmrmaction. -- Possible values are -- FULL_REMOVAL:remove all java related objects But can't find anything of a script that will call this? Anyone have any ideas? Cheers Mark (Why do I bother?) Leith -Original Message- Sent: 22 February 2002 10:18 To: Multiple recipients of list ORACLE-L Mark The ora600 lookup tool on Metalink states that there is no description for this code John -Original Message- Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Hi Ladies and Gents, I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an un-named monitoring tool against it this morning, the instance crashed with a bunch of ORA-600's in the alert log. Below are the two that appeared, though the first turned up about 10 times concurrently: Fri Feb 22 09:22:28 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], [] Fri Feb 22 09:22:34 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], [] Anyone ever seen these before? I'm not going to call support as this is only a sandbox database, so please don't tell me to call them or log a tar.. I have enough to do today already! :( Any feedback on these is, however, much appreciated! Thanks Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Options instead of ODBC + MS-Access [Slightly? Off-topic]
Corvu, Cognos, Crystal reports(oops did I say that), Oracle Discoverer, Depends on the budget and what you really need to do. The first to are to very powerful tools but do cost a bit but they will use native links annd you can generate much smater queries with them Access and ODBC may well show performance problems as ODBC isn't generally a great performer. HTH -- = 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 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom "The People, The Experience, The Vision" = "O'Neill, Sean" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 21/02/2002 10:48 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Fax to: Subject:Options instead of ODBC + MS-Access [Slightly? Off-topic] A developer here has put together a reporting package which uses ODBC to interface to an 8.1.7 DB on W2K server and utilises MS-Access on client to extract data and generate nice GUI final presentation of data. The data extracted has various computations performed. The developer has asked what other Oracle or 3rd party options might be used to realise the same end results perhaps in a more efficient manner. Their concern is that as data volumes grow the performance will degredate substantially. Anyone any ideas?. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: JDBC problem
- Original Message - > I am using java only > The code as follows: > Please give me some suggestions in solving this problem > which problem? what is the exception? Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Woopeee and TWO ORA-600's!
Title: RE: Woopeee and TWO ORA-600's! Mark The ora600 lookup tool on Metalink states that there is no description for this code John -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: 22 February 2002 09:34 To: Multiple recipients of list ORACLE-L Subject: Woopeee and TWO ORA-600's! Hi Ladies and Gents, I installed 9.0.1 on to my Win2K machine yesterday, and whilst installing an un-named monitoring tool against it this morning, the instance crashed with a bunch of ORA-600's in the alert log. Below are the two that appeared, though the first turned up about 10 times concurrently: Fri Feb 22 09:22:28 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [26599], [1], [190], [], [], [], [], [] Fri Feb 22 09:22:34 2002 Errors in file C:\oracle\admin\ORCL\udump\ORA01668.TRC: ORA-00600: internal error code, arguments: [150], [], [], [], [], [], [], [] Anyone ever seen these before? I'm not going to call support as this is only a sandbox database, so please don't tell me to call them or log a tar.. I have enough to do today already! :( Any feedback on these is, however, much appreciated! Thanks Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =