Good Beginner Oracle book recommendations:
Hello, I inherited an oracle database not too long ago, and I've never used Oracle. So far it's running fine and I've been able to wing the startup/shutdown procedures from looking on the net, and most of the time just keeping my fingers crossed. Went to the book store yesterday, there are a lot of Oracle books, but I decided before I go and spend anywhere from $60 - $100, I'd like to know what books you guys would recommend a semi-newbie Oracle DBA. I'm looking for something that I can use as a reference when I need to, and also something I can read in my spare time to better understand Oracle. www.nul.cjb.net www.FreeBSD.org _ 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: Peter 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 DBA Needed in Phoenix..
On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying: . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote: . . . .|O> We would like to submit someone who is a renter and who is interested . . . .|O> in Phoenix but has not applied to Phoenix companies and is not working with . . . .|O> other recruiters for Phoenix companies. . . . .| . . . .|Now why in the world would any of this matter? They are trying to get more people into Phoenix, and they have invested in apartment buildings. But seriously that is kinda weird. . . . .| www.nul.cjb.net www.FreeBSD.org _ 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: Peter 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 DBA Needed in Phoenix..
On 07/05/2001 3:41:08 PM, Jonathan Gennick is quoted as saying: . . . .|Thursday, July 05, 2001, 4:15:20 PM, you wrote: . . . .|O> We would like to submit someone who is a renter and who is interested . . . .|O> in Phoenix but has not applied to Phoenix companies and is not working with . . . .|O> other recruiters for Phoenix companies. . . . .| . . . .|Now why in the world would any of this matter? They are trying to get more people into Phoenix, and they have invested in apartment buildings. But seriously that is kinda weird. . . . .| www.nul.cjb.net www.FreeBSD.org _ 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: Peter 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).
Experiences with AIX and NIS+
Does anyone have any experience with AIX in an NIS+ environment. In theory, this is possible. So far, we have not be able to get it to work. AIX and Oracle 8.1.7 work well with local accounts for Oracle and the DBAs. Automounting file systems has been successful. However, NIS+ just does not work and throws all sorts of other errors that crashes everything. Has anyone successfully done this? Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] -- 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: Oracle Compiler Bug? (+) symbol in Decode Allowed?
Many queries that worked in the past, which were syntactically challenged, fail with Oracle8. In theory, they never should have worked. Oracle is just applying the theory more strictly. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Wed, 7 Mar 2001, Sam Bootsma wrote: > I am running Oracle 8.1.6 on Windows NT. The query below to create a view > compiles on Oracle 8.1.6.1.0, but not on 8.1.6.3.0. If I remove the (+) > from within the decode statement, it compiles in 8.1.6.3.0. Our lead > developer insists it is valid and he also insists the query gives different > results when the (+) sign in the decode is removed. I have not confirmed > this. > > According to my understanding of outer joins (and from what I have seen in > the documentation) the (+) in the decode is invalid syntax. Can somebody > confirm this for me? > > Here is the view in question: > > CREATE OR REPLACE VIEW RULE$TYPE > (ruletype, caption, genlevel, defaultval, exposetype, switch, override) > AS > SELECT A.*,DECODE(B.RULETYPE(+),NULL,'G','M') FROM RULETYPE A, > RULETYPE_OVERRIDE B > WHERE B.RULETYPE(+)=A.RULETYPE > > And here is an excerpt from the documentation: > > Outer Joins > An outer join extends the result of a simple join. An outer join returns all > rows that satisfy the join condition and those rows from one table for which > no rows from the other satisfy the join condition. Such rows are not > returned by a simple join. To write a query that performs an outer join of > tables A and B and returns all rows from A, apply the outer join operator > (+) to all columns of B in the join condition. For all rows in A that have > no matching rows in B, Oracle returns NULL for any select list expressions > containing columns of B. See the syntax for an outer join in "SELECT and > Subqueries" . > Outer join queries are subject to the following rules and restrictions: > * The (+) operator can appear only in the WHERE clause or, in the > context of left-correlation (that is, when specifying the TABLE clause) in > the FROM clause, and can be applied only to a column of a table or view. > > > Thanks for any input... > > > Sam Bootsma > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sam Bootsma > 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: 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:RE: RE: RE: RE: RE: OT: Rachel in Vietnam
It did not work that wel. Just gave the bad guys really good cover after the noise stopped. Probably don't want to give developers that many places to hide. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Tue, 20 Mar 2001 [EMAIL PROTECTED] wrote: > Sure, why not. The BRICK-BAT method. > > Reply Separator > Author: "Mohan; Ross" <[EMAIL PROTECTED]> > Date: 3/20/2001 5:08 PM > > Wow. Talk about enforcing "foreign constraints". > > -Original Message- > Sent: Tuesday, March 20, 2001 5:01 PM > To: Mohan; Ross; Multiple recipients of list ORACLE-L > > > Ross, > > When a B-52, otherwise known as a BUFF (Big Ugly Fat F^cker), unloads > 150 to > 200(B-52D with wing racks) 750LB demolition bombs nothing stands. Even > duhvelopers. I've had Marines discribe the area where a BUFF strike landed > as > "It looked like God reached down, scooped out a three mile long by half a > mile > wide, by 100 foot deep piece of the earth and take it away". I don't know > about > cool, but it sure was effective!! > > Dick Goulet > > Reply Separator > Author: "Mohan; Ross" <[EMAIL PROTECTED]> > Date: 3/20/2001 4:28 PM > > BUFF bomb. That sounds cool. Will it work on developers? > > -Original Message- > Sent: Tuesday, March 20, 2001 4:18 PM > To: Mohan; Ross; Multiple recipients of list ORACLE-L > > > Ross, > > Makes sense, Nam was BUG heaven, unless they got caught in the path of a > BUFF bomb run. Nothing survived that. :-) > > Dick Goulet > > Reply Separator > Author: "Mohan; Ross" <[EMAIL PROTECTED]> > Date: 3/20/2001 8:02 AM > > Dick , > > Didn't you know? Rachel WAS in Nam. But she > never talks about it. I think it had to do > with the bugs. > > Just a thought. > > Ross > > -Original Message- > Sent: Tuesday, March 20, 2001 8:32 AM > To: Multiple recipients of list ORACLE-L > > > Rachel, > > If you were given one, as I was in Nam, you'd not know the difference. > Looks like, & tastes like a crunch bar for the most part, except for the > logo on > top. It just crunches better. > > Dick Goulet > > Reply Separator > Author: "Rachel Carmichael" <[EMAIL PROTECTED]> > Date: 3/19/2001 4:10 PM > > but Moom, the icky bugs TOUCHED the chocolate! :) > > > > >From: Kimberly Smith <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe > >Date: Mon, 19 Mar 2001 13:45:29 -0800 > > > >You could just lick the chocolate off. > > > >-Original Message- > >Sent: Monday, March 19, 2001 10:11 AM > >To: Multiple recipients of list ORACLE-L > > > > > > I have a phobia about bugs... > > > >what a waste of perfectly good chocolate > > > > > > >From: [EMAIL PROTECTED] > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Re:RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe > > >Date: Mon, 19 Mar 2001 09:11:20 -0800 > > > > > >OK you chocaholics try this on for size: > > > > > > Reuters Monday, March 19, 2001 > > > > > >Chocolate-Coated Bugs Are Latest Treat > > > > > >LONDON (Reuters) - Ants, crickets and scorpions, baked, coated > > >in chocolate and promoted as a high-protein snack, are proving > > >popular among peckish Londoners. > > > > > >Designer Todd Dalton, who trained as a chef in Louisiana and > > >acquired a taste for cooked insects on his travels in Asia and > > >central America, says he has sold 5,000 chocolate-coated bugs > > >since he began marketing them in December. > > > > > >"They are very high in protein and very low in fat. They have a > > >higher percentage of protein than any meat or fish that we > > >commonly eat," he told Reuters. > > > > > >The creepy-crawly chocs sell for between three and 3.50 pounds > > >($4.30-$5.00) at upmarket London stores such as Selfridges and > > >the Conran Shop and will soon be appearingin shops in Munich > > >and Zurich. > > >-- > > >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: Linux ver and Oracle
I am running Caldera Linux 2.5 (?) and Oracle 8.1.7 rel 2. Installed cleanly. Runs flawlessly. This is a personal sandbox not production. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Wed, 4 Apr 2001 [EMAIL PROTECTED] wrote: > > I'll be installing Suse 7.1 with Oracle this week. > > I'll let ya'll know how it goes. > > Jared > > On Mon, 2 Apr 2001, Ron Rogers wrote: > > > List, > > I am playing with the idea of loading my PC with Linux and Oracle for test >purposes( We have to migrate from Novell in the near future). What have you found to >be the most compatible and easiest to load by way of Linux version and Oracle version. > > I have tried Linux 7.0 and Oracle 8.1.7 rel 2 but there is a lot of updates needed >to get it that version of Linux and Oracle to talk smoothly. > > Your opinion would be appreciated. > > Thanks, > > ROR mª¿ªm > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Ron Rogers > > 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). > > > > > Jared Still > [EMAIL PROTECTED] > > > -- > 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: 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: Meeting at IOUG
ude a line containing: UNSUB ORACLE-L > > > (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: Stephen Andert > > > 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: Ari D Kaplan > > 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 your FREE download of MSN Explorer at http://explorer.msn.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: 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: Locally Managed Tablespaces
We are using LMTs with several of our databases. No problems. With these databases we are also running large file systems. Although our OS imposes a theoretical limit of 31.G, we have kept our datafiles to 20G or less. Again, no problems. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Tue, 17 Apr 2001, Patricia Ashe wrote: > > I am interested in some statistics on Oracle locally managed tablespaces. I > have been looking for any bugs or negative info about them. Are they in use > at alot of sites? Seems like all the information I have come across is > positive. Which is great! But maybe they aren't being used at alot of > sites. Can I hear about experiences from others on this list? how many > sites are actually using them? > I have several databases that I am getting ready to go production soon and > would like to create the tablespaces as locally managed, but need more > statistics. > > PA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Patricia Ashe > 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: 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: Awfully annoying SQLLDR problem
Have you run catexp7 on the 8.1.5 instance? Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Mon, 23 Apr 2001, Mohan, Ross wrote: > Ok,maybe i am lazy or a poor reader, but are you > using 732 sqlldr binaries to load an 815 db? > > Why not the 815 sqlldr binaries? > > I mean, it sounds like you have to ship data over the > wire no matter what you do, so...why not use the latest > version of the sqlldr bits? > > > > <==> -Original Message- > <==> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > <==> Sent: Monday, April 23, 2001 11:10 AM > <==> To: Multiple recipients of list ORACLE-L > <==> Subject: Awfully annoying SQLLDR problem > <==> > <==> > <==> I am executing a SQLLDR shell file from a server :: > <==> sourceserv; RDBMS 7.3.2.3 > <==> AIX 4.3.2 > <==> into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3 > <==> using a SQL*Net connect string destserv_destSID. > <==> > <==> This connect string is defined in the local tnsnames.ora > <==> and works. I confirmed > <==> this by doing sqlplus user/pass@destserv_destSID and > <==> verifying that I am > <==> connected to the correct instance. > <==> > <==> The target table exists. I am connecting as the owner > <==> of the target table. That > <==> owner has DBA. > <==> > <==> but when I run > <==> > <==> sqlldr userid=tabowner/pass@destserv_destSID > <==> CONTROL=localcontrolfile.ctl > <==> (controlfile is below) > <==> > <==> I get "SQL*Loader-925: Error while parsing a cursor (via ocisq3) > <==> ORA-00942: table or view does not exist" > <==> > <==> Help! Does anyone have any ideas? > <==> > <==> tia, > <==> > <==> ..tom > <==> > <==> here's the controlfile > <==> > <==> LOAD DATA > <==> INFILE data1.dat BADFILE load.bad > <==> DISCARDFILE load.dsc > <==> INSERT > <==> INTO TABLE OWNER.TEST_LOAD > <==> FIELDS TERMINATED BY ',' > <==> TRAILING NULLCOLS > <==> (COL1,COL2,COL3) > <==> > <==> > <==> -- > <==> 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: Mohan, Ross > 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: 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: spool command
SET ECHO OFF Original Message Follows Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 24 Apr 2001 12:12:16 -0800 This is a multi-part message in MIME format. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Hazelton 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: RE: looking job
line containing: UNSUB ORACLE-L > (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: Boivin, Patrice J > 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: 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: book
Hi, I am not aware of a 9i book, but I don't think you can go wrong by getting hold of Steve Adam's book on 8i internals. Regards Pete -Original Message- Sent: 01 September 2003 10:44 To: Multiple recipients of list ORACLE-L Sorry to repost but forgot to mention, that I needed a book for Oracle 9i > Hello list > any recommendations about buying a book on oracle internal working , oracle > kernel ? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: get sid (session id) and serial#?
Title: Message Hi, It is my understanding that Oracle do support the dbms_support package and that it should have been in the 8i distribution, but was missed out by mistake. It's calls to sys.dbms_system.set_ev they do not supoprt since this enables you to set any debug event in the kernel. Regards Pete -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: 30 August 2003 00:30To: Multiple recipients of list ORACLE-LSubject: Re: get sid (session id) and serial#? Oracle officially "desupported" the package in 8i; but then included (by mistake?) in 9i. In 8i, however, you could pester your friendly neuighborhood Support Analyst to give you the package. You could try from 9i sources, too; but not sure if they work. Arup - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, August 29, 2003 5:29 PM Subject: RE: get sid (session id) and serial#? It's not in 8.1.5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John KanagarajSent: Friday, August 29, 2003 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: get sid (session id) and serial#? Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand. John KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is inevitable, but Discouragement is optional!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali. __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __
RE: Oracle9iR2 - temporary tablespace usage error
Hi, There are a couple of issues here. Firstly you need to know that when you get the error about the "temp" segment when building the index, the segment in question is the index. It is just that when building the index Oracle creates a temp segment to sort the data in and to create the index in and when it finishes it changes the segment type to "index". But if it runs out of space trying to build the index, it reports the error about the segment without first changing the segment type. When it comes to the temporary space in a tempfile temporary tablespace, Oracle never actually drops the extents that get allocated until the database is shutdown, instead they just get marked as being available when the session that first created them no longer needs them. Regards Pete -Original Message-From: laura pena [mailto:[EMAIL PROTECTED]Sent: 05 September 2003 14:59To: Multiple recipients of list ORACLE-LSubject: Oracle9iR2 - temporary tablespace usage error HI all, I'm getting the following error when using temporary tablespace on a locally managed system tablespace. Seems if my system tablespace is locally managed I can not create a dictionary managed tablespace. Can anyone let me know if it is a bad idea to have system tablespace locally managed and why I am getting the following the error on building an index: ERROR at line 1:ORA-01652: unable to extend temp segment by 128 in tablespace TEMP01 Also, I issue the following query and looks like the tempoary tablespace is not being free'ed up( or maybe this is not what this v$ tables is telling me): select tablespace_name, file_id,bytes_used,bytes_freefrom v$temp_space_header; SQL> select tablespace_name,file_id,bytes_used,bytes_free 2 from v$temp_space_header; TABLESPACE_NAME FILE_ID BYTES_USED BYTES_FREE-- -- -- --TEMP01 2 2146435072 0 Thanks in advance. Lizz Do you Yahoo!?Yahoo! SiteBuilder - Free, easy-to-use web site design software __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __
Re: question on spfile and pfile
Jin *CREATE PFILE* [= 'pfile_name'] *FROM* SPFILE [= 'spfile_name']; Will create a pfile from the current content of thr spfile :-) CHEN,JIN wrote: Hi there, I found my SPFILE and PFILE are pointing to the same one that is spfile.ora. Now, I want to multiplex control file and books tell me to change in init.ora. I wonder how can create a init.ora from SPFILE. I knew there is one in $ORACLE_BASE/admin//pfile when I created database. But I might change some parameters by "alter database ..." or "alter system ...", like changing to ARCHIVELOG and multiplexing redo log. I am not sure if current spfile is different from that init.ora. Please help! thanks, Jin -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
Re: offshoring article
Let's see if I have this straight, the US is nearly a half trillion dollars in debt. It is going to add at least another 87 billion to that number. It has just reduced taxes on its citizens. And, now it is good for the country to send its best paying jobs overseas. Looks to me like the US is determined to become a third world country at warp speed. Can't blame anyone overseas since the decisions are made in the US. --- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote: > They're hired by the people who came out of those > very same > universities. Most often McKinsey et al are hired to > OK decisions that > management have a hard time OK'ing themselves for > various reasons. > > To be fair, of all the consulting companies that > make money out of > telling people that water runs downhill, McKinsey > are among the very best. > > Ryan wrote: > > >Here is a link to an article from McKinsey & Co. My > favorite positive is > >that offshoring IT jobs frees Americans up to do > other jobs. Now they dont > >say 'what' jobs, but we are free to do them. > > > >If you dont know these are the guys who payed > Chelsea Clinton 100k/year > >right out of college with no experience. If you > explore their website they > >are more interested in where you went to school > than anything else(notice > >how university comes before experience). > > > >who hires these guys? > > > >http://www.mckinsey.com/knowledge/mgi/offshore/ > > > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DB2 has a foot in the door
Hi, I looked into SE but found that Oracle would not allow it to be used on a machine that has 4 or more CPUs or can support that many CPUs, which for this company is a problem because we generally run Oracle on Sun servers. Don't know if that has changed now with later Oracle releases. Regards Pete -Original Message- Sent: 10 September 2003 13:21 To: Multiple recipients of list ORACLE-L When negotiating site licensing, does Oracle encourage the customers to buy EE licences? Or can people negotiate for a mix of EE or SE. Just curious, I don't know how that would work -- not very compatible with OracleStore, it seems to me. Patrice. -Original Message- Sent: Wednesday, September 10, 2003 5:59 AM To: Multiple recipients of list ORACLE-L We also has site licensing. It was done 3-4 years ago. Maybe Oracle changed tactics since then. Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.7 on AIX 5.2
We are getting ready to migrate one of our instances from AIX 4.3.3 to 5.2. Do I need to get different media for this? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)
O/S is AIX 4.3.3 /usr/sbin/bootinfo -p returns "chrp" meaning that the hardware is capable of either 32 or 64 bit operation. /usr/sbin/bootinfo -K returns "32" meaning that the kernel is running in 32 bit mode. When I run sqlplus the server says: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)
Thanks for the response. I have Metalink note 231901.1 which explains the options for installing 8.1.7 on AIX 5L, so I understand what I have to do (after reading it three times). Additional questions: - If we run the 64 bit kernel and put on the required patch for 8.1.7 will I be running Oracle in 64 bit or 32 bit mode? - If Oracle is running in 32 bit mode, what will happen if I restore a cold backup of my AIX 4.3.3 (64 bit) database onto the AIX 5L system? Thanks, Peter Schauss -Original Message- Sent: Friday, September 12, 2003 5:24 AM To: Multiple recipients of list ORACLE-L Peter, I know that this looks odd but as the hardware is 64 bit the AIX O/S has some sort of translation layer that allows it to run Oracle 64 bit even though the kernel is in 32 bit mode. I discovered this when investigating running Oracle 9.2 and Oracle 8.1.7 on AIX 5L. After raising a TAR with Oracle I received the response which basically stated: - Oracle 8.1.7 can only be run in 32 bit mode on AIX 5L. - To run Oracle 8.1.7 and Oracle 9.2 concurrently on AIX 5L you must run AIX in 32 bit mode on 64 bit hardware with 32 bit Oracle 8.1.7 and Oracle 9.2 64 bit (it only exists in 64 bit mode). Confusing I know but somehow true. As an aside I don't think this applies to the likes of HP-UX. I'm fairly sure that running 32bit HP-UX 11 on 64 bit hardware will not allow 64 bit Oracle to run. HTH Chris Dunscombe -Original Message- Sent: 11 September 2003 21:39 To: Multiple recipients of list ORACLE-L O/S is AIX 4.3.3 /usr/sbin/bootinfo -p returns "chrp" meaning that the hardware is capable of either 32 or 64 bit operation. /usr/sbin/bootinfo -K returns "32" meaning that the kernel is running in 32 bit mode. When I run sqlplus the server says: Oracle8i Enterprise Edition Release 8.1.7.0.0 - 64bit Production How can I be running the 64 bit server on a system with a 32 bit kernel? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move SQL Server Tables to Oracle
Hi Gunner You can push data from the sql server via DTS (Data transformation services) or pull the data from the Oracale database via (Heterogeneous services) Gunnar Berglund wrote: Hi all, I need to move some sql server tables to oracle. Do you have some ideas how to do it. I have no idea ... rgds G Want to chat instantly with your online friends? *Get the FREE Yahoo! Messenger* <http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/> -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
Re: Anyone have a copy of DUL ??
Hi Pete I have used Dul many times at customer sites when I was employed by Oracle Denmark. Every time the customer management had to verify by phone and fax that they understood the full impact of using Dul. Oracle have disclaimer that explains the problems with missing transaction consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner of it? - I covered the issue of DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article <[EMAIL PROTECTED]>, Mark Leith <[EMAIL PROTECTED]> writes One problem I see with giving this away "free" is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG "no no". I suppose that also applies to this kind of tool even under a paid license structure. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
Re: FAO: Peter Gram
Sorry Undskyld Förlåt Entschuldigen Excuser Excusa Desculpa Giustificazione Jamadagni, Rajendra wrote: Sorry list ... Pete, your email has again gone secure Raj This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sizing sort_area_size
Hi, Looking at v$sort_segment also can gve you a good idea of how much space you are using in your temporary tablespace, across the current uptime of the instance, assuming that it is a true temporary tablespace. Regards Pete -Original Message- Sent: 18 September 2003 23:35 To: Multiple recipients of list ORACLE-L > I have been doing some alter sessions to improve performance of gigabyte sized 'minus' operations. How do I tell if this is helping other than completion time? > > I believe that if LIOs to PIOs ratio improves with the SAME query then sort_area_size has helped right?(notice Im not trying to improve my cache/hit ratio). If you see less direct IO waits on your temporary tablespace, then increasing s_a_s has helped. > > I get this from v$sess_io. > > how do I tell how much temp tablespace my session uses? I cant find a statistic for it? I see that I used up all my PGA since PGA size and PGA max size are equal in v$sesstat. select * from v$sort_usage where sid = ; > anything else I can look at? Activity on temp tablespace from v$tempstat.. but it's only good enough for comparing with baselines.. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: wrapping packages
Hi Pete I must point out that there must be a unwrap, since the Oracle database can run the wrapped pl/sql code :-) It is based on trust in Oracle cooperation / development. Some times it would make since to write the code in c/c++ since it harder to revers. Pete Finnigan wrote: Hi Very true, but if there was the wrap process wouldn't be much use as anyone could un wrap your code. But you are right the main reason to be cautious is to not delete your source code locally. kind regards Pete In article <[EMAIL PROTECTED]>, bhabani s pradhan <[EMAIL PROTECTED]> writes one caution: there is no unwrap cmd/exe Regards -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: wrapping packages
Hi Did a "nm -D wrap" this gave heaps of symbols, so wrap is loading shared libs. This means revers engineering a lot of Oracle code :-( Govindan K wrote: Coming to think of it, is the 3Mb size is for stripped or unstripped executable?. I know 3Mb if stripped is not likely to come to 40K. Nevertheless the memory addressing for UNIX is diff. from Windoz. May be someone else in the list has a better knowledge of it. GovindanK <-Original Message-> *From: Tanel Poder* Sent: 9/20/2003 2:44:48 PM To: [EMAIL PROTECTED] Subject: Re: wrapping packages I checked, the wrap executable in 8.0.6 dist for solaris is about 3MB, but for 9.2 in Windows it's only about 40k. It shouldn't be that hard to reverse engineer it. Probably the ones who already have cracked the algorithm aren't spreading the knowledge - why should they anyway?! Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" Sent: Sunday, September 21, 2003 12:29 AM > Hi Pete > > I must point out that there must be a unwrap, since the Oracle database > can run the wrapped pl/sql code :-) > > It is based on trust in Oracle coopera! tion / development. > > Some times it would make since to write the code in c/c++ since it > harder to revers. > > Pete Finnigan wrote: > > >Hi > > > >Very true, but if there was the wrap process wouldn't be much use as > >anyone could un wrap your code. But you are right the main reason to be > >cautious is to not delete your source code locally. > > > >kind regards > > > >Pete > > > >In article , bhabani s pradhan > > writes > > > > > >>one caution: > >> > >>there is no unwrap cmd/exe > >> > >>Regards > >> ___ Get Your 10MB account for FREE at http://mail.arabia.com ! Access MILLIONS of JOBS *NOW*! <http://ads.arabia.com/?SHT=text_email_english> -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 check data between two similar tables?
Yes, I do this every days for hundreds of tables. But they are not large tables (max table size about 1.5 million rows). Comparison script is automatically generated from a table holding a list of the tables to be compared. These SQL comparisons are wrapped up in scripts which then mail me if there are dissimilarities between the candidate tables. Also (and this is of course vital) the DDLs for the tables being compared must be identical. Not unreasonable, I would have thought... Mail me if you want further details. peter edinburgh -Original Message- Sent: Friday, September 19, 2003 4:30 PM To: Multiple recipients of list ORACLE-L Hi Is there any script available for comparing tow tables in different databases using DB_LINK? Thanks Sami __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Query
Err, not quite, actually. The solution presented below will simply generate the cartesian product of the sum of attributes from the table. The (grossly pedantic) solution is: select distinct a.col1, a.col2, a.col3||b.col3||c.col3 from fred a, fred b, fred c where a.col3 = 'A' and b.col3 = 'B' and c.col3='C' ... which really begs the question - 'what IS the question?' ! Although this solution works, it would be quite impractical to apply it to 'test' if there were 'n' values of col3. Imran - try framing your question in general terms. peter edinburgh -Original Message- Sent: Friday, September 19, 2003 5:30 PM To: Multiple recipients of list ORACLE-L Assume your table is name fred: select a.col1 a.col2 a.col3||b.col3||c.col3 from fred a, fred b, fred c; Allan -Original Message- Sent: Friday, September 19, 2003 10:15 AM To: Multiple recipients of list ORACLE-L Hi, I have the following data in a table: col1 col2 col3 1 2 A 1 2 B 1 2 C I want to display this as : col1 col2 col3 1 2 A B C How can i do this? Regards Imran -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT, But really STUPID
Careful! After a week, the consensus view of the employees was very positive - they found they had far more time to get on with their work and regarded the ruling as worth while. External email was not affected. The rule was merely an attempt to cut down on the amount of internal email trafficking. The subtext was - 'why don't you speak to that person instead of emailing them?' peter edinburgh -Original Message- Sent: Friday, September 19, 2003 6:55 PM To: Multiple recipients of list ORACLE-L British Company Declares War On Internal E-mail British telephone retailer Phones 4u expects to save about $1.6 million a month by prohibiting employees from sending interoffice e-mails. http://computerworld.com/newsletter/0,4902,85174,00.html?nlid=AM Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 10g: SQL Plus
Hej Jay Yes it stil there :-) Jay Wade wrote: Hello: Was watching Larry Ellison's key note and he mentioned that they still have SQL Plus in 10g. I heard rumor that it was removed. Since it seems as though some from this list have seen it does it still have SQL Plus or has it been removed? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Plus
Hi No this is not true sqlplusw.exe on w2*k is stil there in the beta kit and I can not find anything about desupport in the manuals :-) Tanel Poder wrote: Hi! Sqlplusw is gone, the windows gui version. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 22, 2003 7:19 PM Hello: Was watching Larry Ellison's key note and he mentioned that they still have SQL Plus in 10g. I heard rumor that it was removed. Since it seems as though some from this list have seen it does it still have SQL Plus or has it been removed? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Offshore protests
"Dale Carnegie" ? ! My - that dates you! (Unless it has recently been reprinted - after 50 years!) peter edinburgh > -Original Message- > From: Mladen Gogala [mailto:[EMAIL PROTECTED] > Sent: Monday, September 22, 2003 5:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Offshore protests > > > No problem with beating people up. Violence is, contrary to > Chris Lawson's > book, > an integral part of DBA job. BTW, Chris Lawsons' "Art and > Science of Tuning > Oracle" > reads like Dale Carnegie for database administrators. > Basically, we should > give up > our cynical attitude, become indistinguishable from the > HR/finance drones > and get > rid of our geekish culture. Really terrifying stuff. > > -- > Mladen Gogala > Oracle DBA > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of Orr, Steve > > Sent: Monday, September 22, 2003 12:35 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Offshore protests > > > > > > But do we have to beat up people who refuse to join... > > Or "make an offer they can't refuse." ;-) > > > > -Original Message- > > Sent: Monday, September 22, 2003 10:00 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Definitely steel workers. We are being left to sweat in dark > > and we frequently get burnt by fire. > > > > -- > > Mladen Gogala > > Oracle DBA > > > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > On Behalf > > > Of KENNETH JANUSZ > > > Sent: Monday, September 22, 2003 11:30 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: Re: Offshore protests > > > > > > > > > The labor unions would definitely be interested. > Teamsters, Steel > > > Workers, AFSME? > > > > > > Ken Janusz, CPIM > > > > > > - Original Message - > > > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > > > Sent: Monday, September 22, 2003 10:09 AM > > > > > > > > > > We could make a splash by organizing a DBA union. I'm > > sure that all > > > > heads > > > on > > > > the Capitol Hill > > > > would turn when both members show up with banners, > > demanding better > > > > pay > > > for > > > > starved database > > > > administrators. What do you think, should we mandate 9i OCP for > > > > joining > > > the > > > > union? If we were > > > > in London, we could have a permanent beer table at the > > > White Heart pub > > > > (or is it the Sphere?). We might even encounter Harry > Purvis and > > > > exchange the union stories. > > > > > > > > -- > > > > Mladen Gogala > > > > Oracle DBA > > > > > > > > > > > > > > > > > -Original Message- > > > > > From: [EMAIL PROTECTED] > > > [mailto:[EMAIL PROTECTED] On Behalf > > > > > Of DENNIS WILLIAMS > > > > > Sent: Monday, September 22, 2003 10:45 AM > > > > > To: Multiple recipients of list ORACLE-L > > > > > Subject: Offshore protests > > > > > > > > > > > > > > > Looks as if tech workers are learning the basics of > protesting. > > > > > > > > > > http://informationweek.com/story/showArticle.j> > html?articleID=15000146 > > > > > > > > > > > > > > > Dennis Williams > > > > > DBA, 80%OCP, 100% DBA > > > > > Lifetouch, Inc. > > > > > [EMAIL PROTECTED] > > > > > -- > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > > -- > > > > > Author: DENNIS WILLIAMS > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network Services-- 858-538-5051 > > > http://www.fatcity.com > > > > > San Diego, California-- Mailing list and web > > > hosting services > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Orr, Steve > > INET: [EMAIL PROTECTED] > > > > Fat City
RE: Offshore protests
Hee hee hee! Then make the most of that erudite reply - you only have one year to indulge it! ps - just bought the CDs > -Original Message- > From: Mladen Gogala [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2003 1:15 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Offshore protests > > > My age is the answer to the question of life, universe and everything. > Unfortunately, I'm no longer in my twenties. > > On 2003.09.23 05:13, "Robson, Peter" wrote: > > "Dale Carnegie" ? ! My - that dates you! (Unless it has > recently been > > reprinted - after 50 years!) > > > > peter > > edinburgh > > > > > > > -Original Message- > > > From: Mladen Gogala [mailto:[EMAIL PROTECTED] > > > Sent: Monday, September 22, 2003 5:55 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Offshore protests > > > > > > > > > No problem with beating people up. Violence is, contrary to > > > Chris Lawson's > > > book, > > > an integral part of DBA job. BTW, Chris Lawsons' "Art and > > > Science of Tuning > > > Oracle" > > > reads like Dale Carnegie for database administrators. > > > Basically, we should > > > give up > > > our cynical attitude, become indistinguishable from the > > > HR/finance drones > > > and get > > > rid of our geekish culture. Really terrifying stuff. > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > > > > > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > > Behalf Of Orr, Steve > > > > Sent: Monday, September 22, 2003 12:35 PM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: RE: Offshore protests > > > > > > > > > > > > But do we have to beat up people who refuse to join... > > > > Or "make an offer they can't refuse." ;-) > > > > > > > > -Original Message- > > > > Sent: Monday, September 22, 2003 10:00 AM > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > Definitely steel workers. We are being left to sweat in dark > > > > and we frequently get burnt by fire. > > > > > > > > -- > > > > Mladen Gogala > > > > Oracle DBA > > > > > > > > > > > > > > > > > -Original Message- > > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > > On Behalf > > > > > Of KENNETH JANUSZ > > > > > Sent: Monday, September 22, 2003 11:30 AM > > > > > To: Multiple recipients of list ORACLE-L > > > > > Subject: Re: Offshore protests > > > > > > > > > > > > > > > The labor unions would definitely be interested. > > > Teamsters, Steel > > > > > Workers, AFSME? > > > > > > > > > > Ken Janusz, CPIM > > > > > > > > > > - Original Message - > > > > > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > > > > > Sent: Monday, September 22, 2003 10:09 AM > > > > > > > > > > > > > > > > We could make a splash by organizing a DBA union. I'm > > > > sure that all > > > > > > heads > > > > > on > > > > > > the Capitol Hill > > > > > > would turn when both members show up with banners, > > > > demanding better > > > > > > pay > > > > > for > > > > > > starved database > > > > > > administrators. What do you think, should we > mandate 9i OCP for > > > > > > joining > > > > > the > > > > > > union? If we were > > > > > > in London, we could have a permanent beer table at the > > > > > White Heart pub > > > > > > (or is it the Sphere?). We might even encounter Harry > > > Purvis and > > > > > > exchange the union stories. > > > > > > > > > > > > -- > > > > > > Mladen Gogala > > > > > > Oracle DBA > > > > > > > > > > >
RE: Offshore protests
Hmmm, odd reply, Dennis. I think you may just have inserted a perjorative complexion into the reading of my email, which was most certainly not there! Or perhaps you were confusing my reply with those from others on this thread? The 'winning of friends and influencing people' as stated by DC is as relevant today as it was when first published, if a bit corny. It was, after all, written for a very different world than our own. So you are, after all, absolutely correct in your analysis. (ps - that is a little practical Dale Carnegie for you to enjoy!) peter edinburgh > -Original Message- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2003 4:20 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Offshore protests > > > Peter >If you feel the being an experienced Oracle DBA will > continue to be as > scarce a commodity as it was during the dot-com boom, then > read no further. > If however, you feel that in the future you may no longer > rely on being > treated like royalty, then I would argue that Dale has some > very relevant > points for the DBA that wants to increase interpersonal > skills. And I have > surveyed many of the self-help books being published and haven't found > anyone that says it better. The only problem, as you say with > the 50+ years > since he wrote, many of his examples are dated. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, September 23, 2003 4:14 AM > To: Multiple recipients of list ORACLE-L > > > "Dale Carnegie" ? ! My - that dates you! (Unless it has recently been > reprinted - after 50 years!) > > peter > edinburgh > > > > -Original Message- > > From: Mladen Gogala [mailto:[EMAIL PROTECTED] > > Sent: Monday, September 22, 2003 5:55 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Offshore protests > > > > > > No problem with beating people up. Violence is, contrary to > > Chris Lawson's > > book, > > an integral part of DBA job. BTW, Chris Lawsons' "Art and > > Science of Tuning > > Oracle" > > reads like Dale Carnegie for database administrators. > > Basically, we should > > give up > > our cynical attitude, become indistinguishable from the > > HR/finance drones > > and get > > rid of our geekish culture. Really terrifying stuff. > > > > -- > > Mladen Gogala > > Oracle DBA > > > > > > > > > -Original Message- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > > Behalf Of Orr, Steve > > > Sent: Monday, September 22, 2003 12:35 PM > > > To: Multiple recipients of list ORACLE-L > > > Subject: RE: Offshore protests > > > > > > > > > But do we have to beat up people who refuse to join... > > > Or "make an offer they can't refuse." ;-) > > > > > > -Original Message- > > > Sent: Monday, September 22, 2003 10:00 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Definitely steel workers. We are being left to sweat in dark > > > and we frequently get burnt by fire. > > > > > > -- > > > Mladen Gogala > > > Oracle DBA > > > > > > > > > > > > > -Original Message- > > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > On Behalf > > > > Of KENNETH JANUSZ > > > > Sent: Monday, September 22, 2003 11:30 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject: Re: Offshore protests > > > > > > > > > > > > The labor unions would definitely be interested. > > Teamsters, Steel > > > > Workers, AFSME? > > > > > > > > Ken Janusz, CPIM > > > > > > > > - Original Message - > > > > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > > > > Sent: Monday, September 22, 2003 10:09 AM > > > > > > > > > > > > > We could make a splash by organizing a DBA union. I'm > > > sure that all > > > > > heads > > > > on > > > > > the Capitol Hill > > > > > would turn when both members show up with banners, > > > demanding better > > > > > pay > > > > for > > >
RE: select distinct values
Whoa there! See below: > -Original Message- > From: elain he [mailto:[EMAIL PROTECTED] > Sent: Tuesday, September 23, 2003 9:40 PM > To: Multiple recipients of list ORACLE-L > Subject: select distinct values > > > Hi, > Could someone shed some light on this. > > I'm trying to formulate a query to return distinct value on a > column - > testid. > > select * from testing; > TESTID NAME STATUS > -- --- > 1 MIKE Y > 1 JOE Y > 1 JIMY > 2 AMY Y > > The output I'm expecting is > TESTID NAME STATUS > -- --- > 1 MIKE Y > 2 AMY Y > ** This sentance contains a fundamental error of understanding of a relational db. > > The query should display the first occurence of the testid and ignore > records with the same testid. > The ORDER in which rows are retrieved from a table is not, never, ever will be significant. By definition. So if you can find a script which appears to give you the correct result for this example, then sure as eggs is eggs, it will fail on another data set. There is NOTHING in your example data set which enables a logical predicate to establish precedence of any one row with Testid=1 over another. peter edinburgh > thanks! > > elain > > _ > Instant message in style with MSN Messenger 6.0. Download it > now FREE! > http://msnmessenger-download.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: elain he > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. . http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 10g: SQL Plus
Ah-a - NOW I see why you want my old version 5 manuals!! peter edinburgh > -Original Message- > From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] > Sent: Wednesday, September 24, 2003 7:45 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: 10g: SQL Plus > > > Well, we have a good, working 5.25 floppy drive installed on > our Oracle > Museum PC (486, 25 MHz) now, and we're planning on installing > WordPerfect 4.2, Lotus 1-2-3 (with the plug-in for Oracle, which Cary > will bring over for the Database Forum next week), and other > goodies. We > have 5.1 running, and it's very, very fast to start up. Oh, > and exports > from 5.1 are fine to import in 9i. We haven't tested 10g yet. > > We're showcasing this wonder - and the rest of the Oracle Museum for > which some of you have so generously helped - at the 10g launch days > next week here in Denmark. > > Now, Mladen, would it be possible somehow to get hold of eg a zip of > those 4.1 floppies? > > We have of course ordered another 486 PC, and we intend to > give it all > of 4 MB of RAM like the other one. > > The guy that sells all these things has a shop called > Dinotech, and he > still has about 9 new 5.25 drives from way back then. He'll sell for > about 100 kroner each. > > We paid 200 kroner for the IBM DOS 5 in its original wrap. > > Mogens > > Mladen Gogala wrote: > > >Will they have UFI in 10g? I'm sort of nostalgic. I cannot install my > >3 360k 5.25 floppies with oracle 4.1 on any PC. How about oralink? > >Remarkably, it all used to run in 512k of RAM, which is less > then the > >L3 cache size on any decent P4 system. How many hundreds of > megabytes > >of RAM will I need for 10g? Don't tell me that RAM is cheap. EDO > >capable SDRAM for PCI/233 is NOT cheap. > > > >-- > >Mladen Gogala > >Oracle DBA > > > > > > > > > > > >>-Original Message- > >>From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > >>Behalf Of Bob Metelsky > >>Sent: Wednesday, September 24, 2003 11:45 AM > >>To: Multiple recipients of list ORACLE-L > >>Subject: RE: 10g: SQL Plus > >> > >> > >> > >> > >> > >>>Losing the pseudo-GUI version would be a a drag, because > >>> > >>> > >>it's so easy > >> > >> > >>>to copy and paste text in it (not so easy in a Windows command > >>> > >>> > >>prompt). > >> > >>Try right click - paste or click the upper left icon and > >>choose paste To copy - choose mark then enter -its then in > >>the "clipboard" > >> > >>Ive actually began to like sqlplus (opposed to sqlplusw). One > >>good feature is you have your command history using the up > >>arrow like regular shell > >> > >>bob > >>-- > >>Please see the official ORACLE-L FAQ: http://www.orafaq.net > >>-- > >>Author: Bob Metelsky > >> INET: [EMAIL PROTECTED] > >> > >>Fat City Network Services-- 858-538-5051 http://www.fatcity.com > >>San Diego, California-- Mailing list and web > hosting services > >> > - > >>To REMOVE yourself from this mailing list, send an E-Mail message > >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > >>and in the message BODY, include a line containing: UNSUB > >>ORACLE-L (or the name of mailing list you want to be removed > >>from). You may also send the HELP command for other > >>information (like subscribing). > >> > >> > >> > > > > > > > > > >Note: > >This message is for the named person's use only. It may > contain confidential, proprietary or legally privileged > information. No confidentiality or privilege is waived or > lost by any mistransmission. If you receive this message in > error, please immediately delete it and all copies of it from > your system, destroy any hard copies of it and notify the > sender. You must not, directly or indirectly, use, disclose, > distribute, print, or copy any part of this message if you > are not the intended recipient. Wang Trading LLC and any of > its subsidiaries each reserve the right to monitor all e-mail > communications through its networks. > >Any views expressed in this message are those of the > individual sen
RE: BAARF
Hi, To add my two pennies worth. By design I create physical database lqyouts that seperate indexes and tables by tablespace for ease of management, unless the database is real small. My experience over the years with Oracle, has been the object corruptions in the database have occurred more frequenty with indexes than tables, and when it happens its good just to be able to scrap the index tablespaces datafiles and start again. Regards Pete -Original Message- Sent: 29 September 2003 02:45 To: Multiple recipients of list ORACLE-L Thomas, Please pardon me, but you are off-target in your criticisms of OFA. It has never advocated separating tables from indexes for performance purposes. Ironically, your email starts to touch on the real reason for separating them (i.e. different types of I/O, different recovery requirements, etc). Tables and indexes do belong in different tablespaces, but not for reasons of performance. Cary first designed and implemented OFA in the early 90s and formalized it into a paper in 1995. Quite frankly, it is a brilliant set of rules of how Oracle-based systems should be structured, and a breath of fresh air from the simplistic way that Oracle installers laid things out at the time. It took several years for Oracle Development to see the light and become OFA-compliant, and not a moment too soon either. Just imagine if everything were still installed into a single directory tree under ORACLE_HOME? All of things you mention here have nothing to do with OFA. Please read the paper. Hope this helps... -Tim P.S.By the way, multiple block sizes are not intended for performance optimization; they merely enable transportable tablespaces between databases with different block sizes. on 9/25/03 11:04 AM, Thomas Day at [EMAIL PROTECTED] wrote: > > I would love to have a definitive site that I could send all RAID-F > advocates to where it would be laid out clearly, unambiguously, and > definitively what storage types should be used for what purpose. > > Redo logs on RAID 0 with Oracle duplexing (y/n)? > Rollback (or undo) ditto? > Write intensive tablespaces on RAID 1+0 (or should that be 0+1)? > Read intensive tablespaces on RAID ? (I guess 5 is OK since it's cheaper > than 1+0 and you won't have the write penalty) > > While we're at it could we blow up the OFA myth? Since you're tablespaces > are on datafiles that are on logical volumns that are on physical devices > which may contain one or many actual disks, does it really make sense to > worry (from a performance standpoint) about separating tables and indexes > into different tablespaces? > > We have killed the "everything in one extent" myth haven't we? Everybody's > comfortable with tables that have 100's of extents? > > And while we're at it, could we include the Oracle 9 multiple blocksizes > and how to use them. The best that I've seen is indexes in big blocks, > tables in small blocks --- uh, oh, time to separate tables and indexes. > > Maybe we will never get rid of the OFA myth. > > Just venting. > > Tired of arguing in front of management with Oracle certified DBAs that > RAID 5 is not good, OFA is unnecessary, and uniform extents is the only way > to go. Looking for a big stick to catch their attention with. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hitchman, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cali
RE: x$ constructs and memory
Dan - I think you are in grave danger of forgetting the point of sitting on the top of mountains Either that or your Colorado mountains have nothing on our variety from the NW Highlands of Scotland... (grin!) peter edinburgh > -Original Message- > From: Daniel Fink [mailto:[EMAIL PROTECTED] > Sent: Monday, September 29, 2003 4:10 PM > To: Multiple recipients of list ORACLE-L > Subject: x$ constructs and memory > > > I was sitting on a mountain here in Colorado, pondering Oracle > optimization and an interesting scenario crossed my feeble mind. > As I began to ponder this (I asked the resident marmot, but he > must be a SQL*Server expert...), I came up with several > questions. > > Where in memory (sga or other) do the x$ constructs reside? > Some of them are 'populated' by reading file-based structures > (control file, datafile headers, undo segments). Does this > information reside in memory or is it loaded each time the x$ > construct is accessed? > What happens when these x$constructs begin to consume large > amounts of memory? Is there an upper bound? > > Daniel Fink > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Off Topic: PC Firewall Recommendation
On the same area - I'm using Black Ice, but its never been clear to me whether these products trap outgoing stuff. The BIG problem as I see it as when one inadvertently loads a 1 pixel gif, populated from a rogue site, which then gives implicit confirmation that there is a PC at the end of the line... Anyone been down this particular topic? peter edinburgh > -Original Message- > From: Brian Dunbar [mailto:[EMAIL PROTECTED] > Sent: Monday, September 29, 2003 6:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Off Topic: PC Firewall Recommendation > > > KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September > 29, 2003 9:05 > AM said; > > > > I have a Dell 8200 with XP Prof. SP1. > > > I would like recommendations as to a good firewall for this > machine. XP > has a firewall but it is not the greatest. > > ZoneAlarm on the desktop - free version or pay to upgrade to the pro > version. > Assuming you have a home network, you also want to buy a > DSL/Cable router - > which has it's own firewall built in. > > If you're feeling frisky, consider replacing the > router/firewall with a PC > (with 2 nics) running BSD or Linux. You can also find > distros tweaked to > act as a firewall/router - that's what I've done. > > FWIW, a friend of mine had his XP system plugged directly into his RR > connection. Friend said he didn't need a firewall or router > (I'm not into > that security crap, I just want to play games). Friend has now had to > reformat his box (and lost work) because his box was rooted, > blasted and > fubared within days of hooking it to the cable connection > w/out a firewall. > YMMV. > > ~brian > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Brian Dunbar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: how to send mail from windows command prompt?
Yes, doing this all the time, all in a Dos window, Use 'find' to search through your log files, extracting the lines you want to another file, which you can mail to yourself. eg: find /N "ORA-1" G:\dos_work\work.log > G:\dos_work\pk_violate.txt I use a simple dos mail utility called Postie (http://www.ozemail.com.au/~adavison) - been using it for ages, when it was free. Now I think its $25. peter edinburgh > -Original Message- > From: Murali_Pavuloori/[EMAIL PROTECTED] > [mailto:Murali_Pavuloori/[EMAIL PROTECTED] > Sent: Thursday, October 02, 2003 11:15 PM > To: Multiple recipients of list ORACLE-L > Subject: how to send mail from windows command prompt? > > > > Hello All: > > I have setup some scripts that would export the db every day. > Instead of > looking through the logs manually every morning, is there a > way to tail > (windoze equivalent?) the file and send and email (mailx equivalent on > windows?) I know this can be implemented in Perl, but I don't > know perl so > I am looking for help on Windoze...PLEASE! > > I really appreciate your help in this matter. > > Thanks, > Murali. > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: Murali_Pavuloori/[EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Development environments
Interesting to see the reference to Ultraedit. Been my regular editor for many years now. Macros are particularly useful, but also the ability to column edit. Often used it in association with spooled output, macro manipulation, then subsequent data input (in migration work, for example). peter edinburgh > -Original Message- > From: Pete Finnigan [mailto:[EMAIL PROTECTED] > Sent: Friday, October 03, 2003 12:06 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Development environments > > > Hi Jared > > Interesting article that is quite current. I have just started to use > ultraedit on windows very recently after using textpad for years for > development. I use vi of course on unix. > > I moved to Ultraedit mainly for the reason it allows macros to be > edited, this is the one failing with textpad although there is an open > source movement to add a macro edit to textpad by a group of users. > > I just wanted to add that in the world of databases and the repetition > of code that sometimes exists maybe neither an IDE or text > editor is the > solution. back in 1996/7 i worked on a data migration from a mainframe > to Oracle/Dynix where we wrote a migration program for the > applications > data in C / Pro*C but we separated out the data access code and used > array interfaces and generated 45000 - 5 lines of Pro*C > with a 1000 > 1500 line bourne / awk script. The Pro*C generated was all dynamic > method 2, 3 and 4. Although maybe now with the likes of ultraedit / > slickedit this would be classed as a plugin module? > > cheers > > Pete > -- > Pete Finnigan > email:[EMAIL PROTECTED] > Web site: http://www.petefinnigan.com - Oracle security audit > specialists > Book:Oracle security step-by-step Guide - see > http://store.sans.org for details. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Pete Finnigan > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. . http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Shell script broken, bdf adds new line for long filesystem name.
I don't know if it will be available on your platform but have you tried using fold to see of that affects your script. I didn't think line wrapping was an issue with a script, so it seems to be a bug in bdf. have you tried just df Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = "If people did not sometimes do silly things, nothing intelligent would ever get done." - Ludwig Wittgenstein = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. "Post, Ethan" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/10/2003 04:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Shell script broken, bdf adds new line for long filesystem name. Note that the foofoofoo volume causes the disk info to show up on the following line. A script I have that loops through each line coming back from bdf is breaking because of this. Any simple way to bring the line back up to the Filesystem line using awk, sed etc...? bdf -l Filesystem kbytesused avail %used Mounted on /dev/vg02/foofoo 2048000 1973804 70415 97% /foofoo /dev/vg02/foofoofoo 532486624 43711 13% /foofoofoo /dev/vg02/foofoof 512000 259286 236944 52% /foofoof -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Find an unprintable character inside a column....
Yes, exactly Stephane - Non-printable characters like this are a proper pest in our environment, to the extent that I have exception reports running every night looking for them (cannot trust the users...). I have a small PL/SQL piece of code used to detect these things, if anyone wants it. peter edinburgh -Original Message- Sent: Thursday, October 09, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Steve, If you are patient, I guess that something like where dump(problem_column) like '%%' should more or less answer your question. HTH SF >- --- Original Message --- - >From: "Steve Main" <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Wed, 08 Oct 2003 15:44:26 > >Hello list, > >I have an application that is choking on the >following error, > >"...invalid character (Unicode: 0x19) was found in >the element >content..." > >Does anyone know how I could go about searching for >this "invalid" >character? > >Thanks > >Steve > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Find an unprintable character inside a column....
Some people have requested this code, so I thought you might as well all have the chance to pick it to bits... Its a function called BAD_ASCII, and it hunts out for any ascii characters with an ascii value of less than 32 in a specified field. (Acknowledgments to my colleague Keith Holmes for help with this code.) Use it as follows: Where a field called DATA in a table TABLE_1 may contain an ascci character with a value less than 32 (ie a non-printing character), the following SQL will find the row in question: select rowid,DATA,dump(DATA) from TABLE_1 where BAD_ASCII(DATA) > 0; You could use the PK of the table instead of rowid, of course. You will also note that I select the DATA field in both normal and ascii 'dump' mode, the better to locate where the corruption is located. peter edinburgh ... Source as follows: Function BAD_ASCII (V_Text in char) return number is V_Int number; V_Count number; begin -- V_Int := 0; V_Count := 1; while V_Count<=length(rtrim(V_Text)) and V_Int=0 loop if ascii(substr(V_Text, V_Count, 1))<32 then V_Int := V_Count; end if; V_Count := V_Count + 1; end loop; return V_Int; -- exception when others then return -1; end BAD_ASCII; / -- > -Original Message- > From: Prem Khanna J [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 09, 2003 10:49 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: RE: Find an unprintable character inside a column > > > Peter, i would be interested in that. > can u mail it to me ? > > Jp. > > 09-10-2003 18:29:33, "Robson, Peter" <[EMAIL PROTECTED]> wrote: > >I have a small PL/SQL piece of code used to detect these > things, if anyone > >wants it. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Prem Khanna J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk ***** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Find an unprintable character inside a column....
Just a brief foot-note to this discussion. The reason I selected the data, rather than attempted an automatic correction, was that sometimes two words would be separated by ascii(10) (forcing a line throw), and sometimes the corruption would appear as an additional spurious character in a line. In the former case, one wants to replace ascii(10) with a space (ascii 32), but in the latter case one simply wants to remove the corrupt data character. OK, yes, I could do it with decode, and I'm sure Jared will have the appropriate Perl script out before I finish typing this But but but... peter edinburgh > -Original Message- > From: Stephane Faroult [mailto:[EMAIL PROTECTED] > Sent: Friday, October 10, 2003 10:54 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Find an unprintable character inside a column > > > [EMAIL PROTECTED] wrote: > > > > I played with this a bit. > > > > First, I created some test data with one column corrupted with a > > single random character > > of 0-31 replacing a random char in that column 20% of the > rows of the > > table. > > > > Peter's function correctly found all of the rows in 7.5 seconds. > > > > Stephane's function ran in 3.5 seconds, but didn't find any of > > the rows. I didn't attempt to correct the code. > > > > Then I tried a function based on owa_pattern.regex. My initial > > attempts > > didn't return the correct rows, as the regex pattern needed some > > tuning. > > > > I didn't attempt to fix it, as it was woefully slow, about > 30 seconds. > > > > Regex in the WHERE clause in 10g will be nice. > > > > Jared > > > > "Stephane Faroult" > > <[EMAIL PROTECTED]> To:Multiple > > Sent by: [EMAIL PROTECTED] recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > 10/10/2003 07:09 AM cc: > > Please respond to ORACLE-LSubject:RE: RE: > > RE: Find an unprintable > character > > inside a column > > > > >Some people have requested this code, so I thought > > >you might as well all > > >have the chance to pick it to bits... Its a > > >function called BAD_ASCII, and > > >it hunts out for any ascii characters with an ascii > > >value of less than 32 in > > >a specified field. (Acknowledgments to my colleague > > >Keith Holmes for help > > >with this code.) > > > > > >Use it as follows: > > > > > >Where a field called DATA in a table TABLE_1 may > > >contain an ascci character > > >with a value less than 32 (ie a non-printing > > >character), the following SQL > > >will find the row in question: > > > > > >select rowid,DATA,dump(DATA) from TABLE_1 > > >where BAD_ASCII(DATA) > 0; > > > > > >You could use the PK of the table instead of rowid, > > >of course. You will also > > >note that I select the DATA field in both normal > > >and ascii 'dump' mode, the > > >better to locate where the corruption is located. > > > > > >peter > > >edinburgh > > >... > > > > > >Source as follows: > > > > > > > > >Function BAD_ASCII > > > (V_Text in char) > > > return number > > >is > > > V_Int number; > > > V_Count number; > > >begin > > >-- > > >V_Int := 0; > > >V_Count := 1; > > >while V_Count<=length(rtrim(V_Text)) and V_Int=0 > > > loop > > > if ascii(substr(V_Text, V_Count, 1))<32 then > > > V_Int := V_Count; > > > end if; > > > V_Count := V_Count + 1; > > >end loop; > > >return V_Int; > > >-- > > >exception > > > when others then > > >return -1; > > >end BAD_ASCII; > > >/ > > > > > > > Peter, > > > > I think that you can make this code 25% faster when the data is > > clean (which hopefully is the general case) by using 'replace', more > > efficient than a PL/SQL loop, to check whether you have some rubbish > > (sort of). It will not tell you where the bad character is, > however - > > which means that then you can loop to look for it. > > > > Here is what I would suggest : > > > >
RE: How to add ' (comma) at the begining and end of each line? Ei
Hmmm - we call that symbol a 'quote' (and I have used quotes to quote quote, if you follow... ) Various ways - if your data is in a text file - use an edit macro If it is a field in an Oracle table which you are extracting to a file - try this: select * (other fields) , ''''||data_field||'''', ***etc from table; peter > -Original Message- > From: Khedr, Waleed [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 16, 2003 3:55 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: How to add ' (comma) at the begining and end of > each line? > Ei > > > small C, java, Perl, etc program can get it done quickly. > > -Original Message- > Sent: Thursday, October 16, 2003 10:20 AM > To: Multiple recipients of list ORACLE-L > Either Unix or Windows > > > Hi List > > I have 1000 lines in my data file. I want to add > '(comma) at the begining and end of each line. > > For example, > > abf > jd > djkhk > jd3 > > Shold be convrted to > > 'abf', > 'jd', > 'djkhk', > 'jd3', > > Any help will be really appreciated. > > Thanks > Sami > > __ > Do you Yahoo!? > The New Yahoo! Shopping - with improved product search > http://shopping.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Oracle DBA > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Khedr, Waleed > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.7 to 8.1.7.4 database migration - step 10 hangs
Environment: AIX 5.2 Oracle 8.1.7.4 I copied a database from an 8.1.7.0 environment and am going through the procedure to migrate it to 8.1.7.4. My Oracle home has already been patched. When I get to step 10 in the procedure where it says: SQL> create or replace java system / sqlplus hangs. Has anyone else had this problem? Is there a workaround? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Problem in dropping Materialized View
Hi,
Did you rename the materialized view? If so you are probably hitting bug
1335477. Can you see the view name in user_mviews? I think you have to try
and re-create the materialized view and then drop it.
Really suggest you contact Oracle, unless someone on the list has the
definitive fix.
Regards
Pete
[END]
-Original Message-
Sent: 17 October 2003 07:54
To: Multiple recipients of list ORACLE-L
Hi Gurus
Oracle 8.1.7 on HP Unix
I have some problems in Materialized view
Here are the sequence of steps
Created a normal view CT_PRODUCTID_VW
Created a materialized view CT_PRODUCID_MVW
Dropped view CT_PRODUCTID_VW
Rename CT_PRODUCTID_MVW to CT_PRODUCTID_VW
Now I cannot drop the materialized view CT_PRODUCTID_VW
SQL> select owner,object_type from all_objects where
object_name='CT_PRODUCTID_VW';
OWNER OBJECT_TYPE
-- --
COMMADMTABLE
SQL> ANALYZE TABLE CT_PRODUCTID_VW VALIDATE STRUCTURE CASCADE;
Table analyzed.
SQL> DROP MATERIALIZED VIEW COMMADM.CT_PRODUCTID_VW;
DROP MATERIALIZED VIEW COMMADM.CT_PRODUCTID_VW
*
ERROR at line 1:
ORA-12003: snapshot "COMMADM"."CT_PRODUCTID_VW" does not exist
SQL> drop snapshot COMMADM.CT_PRODUCTID_VW;
drop snapshot COMMADM.CT_PRODUCTID_VW
*
ERROR at line 1:
ORA-12003: snapshot "COMMADM"."CT_PRODUCTID_VW" does not exist
SQL> DROP MATERIALIZED VIEW LOG ON CT_PRODUCTID_VW;
DROP MATERIALIZED VIEW LOG ON CT_PRODUCTID_VW
*
ERROR at line 1:
ORA-12002: there is no snapshot log on table "COMMADM"."CT_PRODUCTID_VW"
SQL> drop table ct_productid_vw;
drop table ct_productid_vw
*
ERROR at line 1:
ORA-12083: must use DROP MATERIALIZED VIEW to drop
"COMMADM"."CT_PRODUCTID_VW"
The definition of the materialized view is as follows:
CREATE
MATERIALIZED VIEW CT_PRODUCTID_VW
BUILD IMMEDIATE
REFRESH START WITH SYSDATE
NEXT (SYSDATE + 1)
AS
SELECT
msi.segment1productid,
msi.description description,
msi.inventory_item_id inventory_item_id,
mc.segment1 product_family,
mc.segment2 product_type
FROM [EMAIL PROTECTED] mcs,
[EMAIL PROTECTED] mc,
[EMAIL PROTECTED]mic,
[EMAIL PROTECTED] msi
where 1=1
and mc.structure_id = 50112
and mc.segment3 != 'SPARE'
and mc.global_name= 'US'
and mc.enabled_flag = 'Y'
and mcs.global_name = mc.global_name
and mcs.category_set_name = 'PROD GROUP'
and mic.category_set_id = mcs.category_set_id
and mic.category_id = mc.category_id
and mic.global_name = mc.global_name
and mic.organization_id = 1
and mic.inventory_item_id = msi.inventory_item_id
and msi.organization_id = mic.organization_id
and msi.global_name = mc.global_name
AND msi.auto_created_config_flag = 'N'
AND msi.item_type IN ('ATO MODEL','CONFIG SPARE','CONFIG
SUB','FEATURE PACK','PRODUCT LIST>$0','PTO MODEL','SPARE')
and msi.inventory_item_status_code IN
('ENABLE-MAJ','ENABLE-NON','ENABLE-OPT','NONORD')
Any help to drop this object is highly appreciated.
With Warm Regards
Siddharth Haldankar
Cisco Systems Inc. ODC
Zensar Technologies Ltd.
# : 4128374
[EMAIL PROTECTED]
[EMAIL PROTECTED]
__
The information contained in this email is confidential and
intended only for the use of the individual or entity named
above. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited. Thomson Scientific will accept no responsibility
or liability in respect to this email other than to the addressee.
If you have received this communication in error, please
notify us immediately via email: [EMAIL PROTECTED]
__
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Hitchman, Peter
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: OT California
the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Where can I download 10g ?
Well, one may not have to die waiting for the download to complete this time... (to twist the reference) At an Oracele 'do' this week we were informed that 10g can be accommodated 'in toto' on 1 CD, unlike the 3 that were required for 9i. Due, we are told, to old redundant code being flushed out hmm, that makes one wonder... peter edinburgh > -Original Message- > From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] > Sent: Friday, October 17, 2003 1:09 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Where can I download 10g ? > > > At least I would then die with a broad smile on my face, knowing that > that version was delayed, too... > > Pete Sharman wrote: > > >Sure, I've got an accurate rumour. Of course, I'd have to > kill you if I > >told you. Do you really want to know that much? :) > > > >Pete > >"Controlling developers is like herding cats." > >Kevin Loney, Oracle DBA Handbook > >"Oh no, it's not. It's much harder than that!" > >Bruce Pihlamae, long-term Oracle DBA > > > > > > > >-Original Message- > >Hately, Mike (LogicaCMG) > >Sent: Friday, October 17, 2003 3:04 AM > >To: Multiple recipients of list ORACLE-L > > > > > >Best plan at the moment is : > > > >1) Wait patiently for between 3 and 10 months (anyone got an > accurate rumour > >for a release date?). > >2) Download from Technet. > > > >Regards, > >Mike Hately > > > >-Original Message- > >Sent: 16 October 2003 16:49 > >To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7 to 8.1.7.4 database migration - step 10 hangs
Thanks for all the help. I was under a bit of time pressure and it was a small database, so a just created a new database on the 8.1.7.4 (AIX 5.2) system and imported my tables. Something was seriously wrong with the upgrade script, because the java migration step ran all night and still had not finished. Peter Schauss -Original Message- Sent: Thursday, October 16, 2003 4:44 PM To: Multiple recipients of list ORACLE-L It may take a while to run (1/2 hour), how long has it been running? There are some issues with reloading java on an upgrade. I just went through the same thing, but on AIX 4.3.3. I don't have the metalink note in front of me, I will be able to pass it on tomrrow. Some things from memory are: 1) You had to run rmjvm.sql and then initjvm.sql from $ORACLE_HOME/javavm/install. Make sure that you back up any java objects that you put in the DB first as rmjvm.sql does what the name implies. 2) The initjvm.sql script appears to hang right around the spot were it mentions something about javadebug, my guess is it is reloading java objects, it was over 6k in our case, should take around 15 minutes to 1/2 hour. 3) java_shared_pool had to be 1 or greater. I will send you the metalink note tomorrow if it isn't too late. HTH, Mike "Schauss, Peter" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> c.com> cc: Sent by: Subject: 8.1.7 to 8.1.7.4 database migration - step 10 hangs [EMAIL PROTECTED] .com 10/16/2003 04:14 PM Please respond to ORACLE-L Environment: AIX 5.2 Oracle 8.1.7.4 I copied a database from an 8.1.7.0 environment and am going through the procedure to migrate it to 8.1.7.4. My Oracle home has already been patched. When I get to step 10 in the procedure where it says: SQL> create or replace java system / sqlplus hangs. Has anyone else had this problem? Is there a workaround? Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Transportable tablespaces
Hi Listers Saw this on SearchOracle What new features are customers excited about in 10G? Abramson: What they've done is given you complete flexibility. They have introduced transportable table spaces, so all you have to do is export metadata and just copy files across during an upgrade. You don't have to do a full extraction. I've been in a situation were a company was on Sun and moving to HP, and they wanted to know how to do it. I told them that you just unload the database and reload the database. It sounds easy, but with two terabytes of data it's not unless you have transportable table spaces. Can anyone confirm that this is true, that is, the implication that I can copy a transportable tablespace from Sun to HP or vice versa without issue. I suppose then is it big endian - little endian constrained or not Cheers -- ===== Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = "If people did not sometimes do silly things, nothing intelligent would ever get done." - Ludwig Wittgenstein = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please notify the sender and delete the transmission. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Replication
--_=_NextPart_001_01C39882.D1104260 Content-Type: text/plain; charset="iso-8859-1" Use Oracla's advanced replication (only available with Enterprise Edition). Or use the patented Robson method!! peter -Original Message- Sent: Wednesday, October 22, 2003 11:45 AM To: Multiple recipients of list ORACLE-L Hi all, I have an environment where we are replication from Master to Slave a number of tables. But there is one table which needs to replicate also both ways. Currently I have setup snapshots/mviews master-slave, how I can implement this one table to be replicated also other way... rgds gb _ Want to chat instantly with your online friends? <http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.co m/> Get the FREE Yahoo! Messenger * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * --_=_NextPart_001_01C39882.D1104260 Content-Type: text/html; charset="iso-8859-1" Use Oracla's advanced replication (only available with Enterprise Edition). Or use the patented Robson method!! peter -Original Message-From: Gunnar Berglund [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 11:45 AMTo: Multiple recipients of list ORACLE-LSubject: Replication Hi all, I have an environment where we are replication from Master to Slave a number of tables. But there is one table which needs to replicate also both ways. Currently I have setup snapshots/mviews master-slave, how I can implement this one table to be replicated also other way... rgds gb Want to chat instantly with your online friends? http://uk.rd.yahoo.com/mail/tagline_messenger/*http://uk.messenger.yahoo.com/";>Get the FREE Yahoo! Messenger * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * --_=_NextPart_001_01C39882.D1104260-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle & SAN Experiences?
Some observations based on experience. Allocating storage based on the controllers helps if the database is large enough. e.g. 1 controller manages 100G of physical disk. Use that as a mount point. This does improve io somewhat if you can have mount points in 100G multiples (or whatever your controller manages). On board caching can be a problem. Oracle writes to disk but the data actually gets cached rather than physically written to disk. If a database crashes before the actual write to disk occurs you lose the data. Write through caching helps this but offer no guarantees. We found that approximately 60% of our io was actually from the cache rather than disk. The cache lru was holding the data blocks. This made the reads much faster. --- [EMAIL PROTECTED] wrote: > > The Sys. Admin. team wants to consolidate storage > (and > > probably get a new toy too) on all of our servers, > so they > > are evaluating a SAN (LSI Logic E4600). The DBA > team is > > doing some research to determine the pros and cons > of > > doing this, and I'd like to hear any of your > experiences > > (good and bad) using SAN with Oracle. > > > > My understanding is that all of our database > servers would > > remain intact, but the attached disk storage would > move > > into the SAN. So, we still have the Production, > Test, and > > App. servers with their processors and memory, > Oracle > > homes, etc. The SAN will hold database files from > > Production, Test, Apps., staging, ODS,data > warehouse, etc. > > > > Their arguments: > > -the SAN is very scalable (500 GB - 40 TB) > > -easy to manage disks in one central location > > -fancy statistics collection on all SAN disks > > -much higher throughput on the fiber SAN > connections than > > with locally attached disk arrays > > -capable of using mixed RAID levels (0, 1, 1+0, 5, > etc.) > > -can partition sets of disks in the SAN for > specific > > server access -Snapshot backup capability is very > fast in > > the SAN (much faster than traditional Oracle > backups) > > > > DBA arguments: > > -How will this affect database performance? > > -What are the drawbacks, if any, with the > pre-fetch of > > data performed by the SAN (i.e., SAN cache) > > -How tunable is the SAN > > -Fast, small disks are better for performance and > less > > wasted space than the typical huge disks in a SAN > (it's > > possible to use smaller disks in the SAN) -Prove > it! > > > > > > After reading the "Sane SAN" article and a case > study > > about Volvo implementing a SAN, I believe it's > possible to > > have a great Oracle/SAN implementation if it's > setup > > correctly and tuned. Other resources that you can > Google > > are "Using SVA SnapShot with Oracle", "Performance > > Benchmark LSI Logic E4600 (STK D178)", "SAN > Storage for > > Open Systems Environments", and of course check > the > > OraFaq. > > > > Thanks for sharing, > > > > David Wagoner > > Oracle DBA > > Sounds like you're going through an excellent > evaluation > process. I would suggest to keep in mind Anjo's > advice to > also regard I/O in terms of units of throughput > (i.e. read > or write rates) instead of Gbytes or Tbytes (i.e. > static > capacity). Helps clarify the discussions... > > The other thing is the idea of co-mingling > production and > dev/test. Of course it is possible and quite > feasible, but > if you look at things from the perspective of units > of > throughput, you might find a huge disparity or > conflict. > Perhaps the most telling indicator might be > reviewing > whether or not your LANs for production and dev/test > are > isolated from one another -- many of the rationales > for > doing so (or not doing so) might be similar to the > considerations for your SAN. > > Good luck! > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to
Re: Win2k/8.1.7.3/Optimizer Weirdness
Same thing in 9.2.0.2 on linux Clark, Tommy R wrote: I was able to duplicate this on my 9.0.1.1.1 database running on Win2K. -Original Message- Sent: Tuesday, November 19, 2002 1:17 PM To: Multiple recipients of list ORACLE-L Hi Listers: Has anyone ever seen something like this before? Can somebody explain it to me? Thanks, Mike SQL> SQL> select file_name from dba_temp_files; File Name - E:\ORANT\ORADATA\ECRMP\TEMP01.DBF 1 row selected. SQL> select /*+ RULE */ file_name from dba_temp_files; no rows selected SQL> --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: Sr. Oracle DBA Position- Must be 8i and 9i Certified-
Hmmm I do not seem to qualify as an alien, extra-terrestrial or otherwise, and I never heard from them after I sent a resume'. --- Joe Testa <[EMAIL PROTECTED]> wrote: > It could have been because they were aliens(either > the non-US citizen > type or the outer space kind, since neither need > apply). > > It had to be said, it had been a while since I made > reference to > spaceships, etc. > > Bwahahahhah > > joe > > > Stephen Andert wrote: > > >I guess the response wasn't overwhelming if he is > re-posting this again > >so soon. I wonder if they missed the whole > discussion awhile back about > >the people who never heard from them after sending > resumes. > > > >I use the frequency of these messages and the > quality of the job as a > >barometer for the condition of the job market. > > > >Stephen > > > > > > > >>>>[EMAIL PROTECTED] 11/25/02 10:14AM >>> > >>>> > >>>> > >Great opportunity for a Sr. Oracle DBA with 8i AND > 9i certification to > >join > >this software > >industry leader in Charlotte, North Carolina. > > > >Base salary is in the 90-120K range and depends on > experience. > > > >Relocation Assistance is provided. > > > >PLEASE Do Not send your resume for this position > UNLESS you have the > >skills > >outlined below for this position. > > > >Please Do Not send your resume unless you have a > stable work history. > >Candidates whose work history includes frequent job > changes connot be > >considered. > >If you are employed by a consulting company you > must have a long term > >project history. > > > >This is a full time staff position so no > sub-contractors or third > >parties > >please. > > > >NO H-1B candidates please. > > > >Interested candidates will be required to complete > a company > >questionnaire > >that must be submitted with the resume. > > > >*Description of duties: > >Production support of operations required to > maintain 7x24 > >database/application availability. > >Logical Design and Physical Design in support of > >Production/Development > >Database operations > >and support in Solaris/Linux ORACLE 8i/9i > environment. > >Essential Functions: Backup/recovery, RMAN, > Performance tuning, Shell > >scripting in Korn and Bourne Shells. ORACLE > Internet Directory, ORACLE > >Enterprise Manager, development/documentation of > standards and > >procedures. > >ORACLE DBA duties to include user management data > exports and imports, > >writing ORACLE scripts, general monitoring of > system performance. > >Assisting users with SQL and PL/SQL needs in > day-to-day operations and > >implementation of logical designs. > > > >* Requirements: > >-Oracle 8i and 9i Certification > >-7+Years in IT > >-5+ years of Production Oracle DBA > experience..including 8i and 9i > >-Knowledge of OPS/RAC, OEM > >-Proficient with SQL, PL/SQL, unix shell scritping > >-Expert understanding of Oracle architecture > >-Full understanding of Database concepts > >-Knowledge of relational database design > >-Must be a Self-starter. > > > >For immediate consideration, please email your > resume as an attachment > >to: > > > >OraStaff, Inc. > >Email: [EMAIL PROTECTED] > >Phone: 1-800-549-8502. > >Please Use Job Code: One/Charlotte/Certified > DBA/Carol > > > >We pay referral fees. > >So please contact me if you know of anyone who > would be > >qualified/interested > >in the > >position described above- if it is not a match for > your skills. > >Thanks. > > > > > > > > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > =
RE: IOUG 2003
Yeah, well I too had become somewhat puzzled at the length of time they seem to be taking in informing would-be speakers, so emailed them. The answer is that notifiations will be posted second week December. Good luck! peter edinburgh > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: 27 November 2002 15:04 > To: Multiple recipients of list ORACLE-L > Subject: IOUG 2003 > > > Okay, so I'm trying to get costs for conferences etc so my boss can > budget for them. > > I go to the IOUG site and look at costs for the 2003 conference. I see > "register online" so I click on it. They have it set up for speaker > registration already, and ask for the email confirmation code you > received. > > Has anyone on this list, who submitted an abstract, actually > RECEIVED a > response? Either acceptance or rejection? I haven't. > > How can you set something up to allow people to register if they don't > know which way to register? > > Sheesh. I can't even register for the University Session I > want because > I don't know what status I should use when registering. > > Rachel > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IOUG 2003
And Allen Greenspan says inflation is under control... --- [EMAIL PROTECTED] wrote: > Dues were $75.00 last year. > > > > > > "Weaver, Walt" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/27/2002 07:54 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: IOUG 2003 > > > Speaking of IOUG, did anyone else get a membership > renewal email recently? > > Seems to me the annual dues have gone up > significantly this year. > > --Walt Weaver > Bozeman, Montana > > -Original Message- > Sent: Wednesday, November 27, 2002 8:04 AM > To: Multiple recipients of list ORACLE-L > > > Okay, so I'm trying to get costs for conferences etc > so my boss can > budget for them. > > I go to the IOUG site and look at costs for the 2003 > conference. I see > "register online" so I click on it. They have it set > up for speaker > registration already, and ask for the email > confirmation code you > received. > > Has anyone on this list, who submitted an abstract, > actually RECEIVED a > response? Either acceptance or rejection? I haven't. > > How can you set something up to allow people to > register if they don't > know which way to register? > > Sheesh. I can't even register for the University > Session I want because > I don't know what status I should use when > registering. > > Rachel > > __ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up > now. > http://mailplus.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Weaver, Walt > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (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 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: move some records of some tables
There are issues here. Will the table being copied to have the same constraints in place as those tables from which the data is being extracted? If so, resolves those, and get these reference tables in place first. Then simply use a database link to 'pull' the data from your source tables, eg insert into USERNAME.COPY_TABLE select * from USERNAME.SOURCE_TABLE@DATABASE_LINK where... ; Of course, make sure the owner of the copy tables has select on the source tables. peter edinburgh > > Hi, > > what's the best method to move some rows of some tables > of a user > from one database to another database on another server? I > need a step by > step document to achieve this. > > Thanks, > Murat > > > -- > Bu e-posta sadece yukarida isimleri belirtilen kisiler > arasinda ozel > haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa > lutfen mesaji > geri gonderiniz ve sisteminizden siliniz. Rt.Net > Internet Hizmetleri > Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili > olarak hic bir > hukuksal sorumlulugu kabul etmez. > > This e-mail communication is intended for the private use > of the persons > named above. If you received this message in error, > please immediately > notify the sender and delete it from your system. > Rt.Net Internet > Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal > responsibility > for the contents of this message. > -- > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: MURAT BALKAS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UKOUG Meet.
Count me in on this, Mark - As for a 'table' - presupposes a venue in which to find said article of furniture...(!) no idea on that, but there are places out the back of the ICC as I recall which might be suitable. peter edinburgh > -Original Message- > From: Mark Leith [mailto:[EMAIL PROTECTED]] > Sent: 03 December 2002 09:59 > To: Multiple recipients of list ORACLE-L > Subject: UKOUG Meet. > > > Hi All, > > I remember that a number of people were all for getting > together on the > Monday night at the UKOUG. I *don't* remember us actually arranging a > place/time.. ;) Is there any chance of another show of hands > so that we can > see if we'll need to book a table or not. And has *anybody* > had any thoughts > on a place at all? > > See you all soon! > > 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 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UKOUG Meet.
> > > a table presumes there will be only a few of you there > > by my count, which is admittedly low, you folk are already at 8 > You haven't seen the SIZE of these tables - they are bl massive! We take our communal beering seriously over here! peter > > --- "Robson, Peter" <[EMAIL PROTECTED]> wrote: > > Count me in on this, Mark - > > > > As for a 'table' - presupposes a venue in which to find said article > > of > > furniture...(!) no idea on that, but there are places out > the back of > > the > > ICC as I recall which might be suitable. > > > > peter > > edinburgh > > > > > > > -Original Message- > > > From: Mark Leith [mailto:[EMAIL PROTECTED]] > > > Sent: 03 December 2002 09:59 > > > To: Multiple recipients of list ORACLE-L > > > Subject: UKOUG Meet. > > > > > > > > > Hi All, > > > > > > I remember that a number of people were all for getting > > > together on the > > > Monday night at the UKOUG. I *don't* remember us actually > arranging > > a > > > place/time.. ;) Is there any chance of another show of hands > > > so that we can > > > see if we'll need to book a table or not. And has *anybody* > > > had any thoughts > > > on a place at all? > > > > > > See you all soon! > > > > > > 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 > http://www.fatcity.com > > > San Diego, California-- Mailing list and web hosting > > services > > > > > > - > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed > from). You may > > > also send the HELP command for other information (like > > subscribing). > > > > > > > > > > * > > This e-mail message, and any files transmitted > with it, are > > confidential and intended solely for the use of the > addressee. If > > this message was not addressed to you, you have received > it in error > > and any copying, distribution or other use of any part > of it is > > strictly prohibited. Any views or opinions presented are > solely those > > of the sender and do not necessarily represent those of > the British > > Geological Survey. The security of e-mail communication > cannot be > > guaranteed and the BGS accepts no liability for claims > arising as a > > result of the use of this medium to transmit messages from > or to the > > BGS. The BGS cannot accept any responsibility for viruses, > so please > > scan all attachments. > http://www.bgs.ac.uk > > > * > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Robson, Peter > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web > hosting services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > >
Oracle 8i Certification Will Terminate When???
I have been looking at the Oracle web site for the termination date of Oracle 8i certification tests. There is nothing there. Only Oracle 8. Rumor has had it that there is a termination date. Does anyone have an authoritative answer? = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 tuning help
Hmmm - this is a Friday afternoon, you know. My suggestion is to forget it until Monday - don't spoil your weekend.... peter edinburgh > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 06 December 2002 12:54 > To: Multiple recipients of list ORACLE-L > Subject: sql tuning help > > > Hi, > > Oracle 8.1.6 NT 4.0 > > I have a rather complex query a developer gave to me to try to improve > performance. > There are 3 tables used. All relevant columns used are > indexed. The tables > have been analyzed > > SQLWKS> select count(*) from physicians; > COUNT(*) > -- > 340043 > 1 row selected. > SQLWKS> select count(*) from boards; > COUNT(*) > -- >220 > 1 row selected. > SQLWKS> select count(*) from phy_boards; > COUNT(*) > -- > 450674 > > Below is the sql statement and explain plan. > I see one FTS on 440,000+ records but cannot tell exactly > what statement it > is and how to resolve > > Any suggestions on how to optimize is appreciated. > > Thanks > Rick > > select board_other.description strBrdNameOtherTHQuest >,decode(board_aaps.description, null,' ','X') ysnAAPSBoard >,decode(board_aba.description, null,' ','X') ysnABABoard >,decode(board_abem.description, null,' ','X') ysnABEMBoard >,decode(board_abfp.description, null,' ','X') ysnABFPoard >,decode(board_abim.description, null,' ','X') ysnABIMBoard >,decode(board_abp.description, null,' ','X') ysnABPBoard >,decode(board_abr.description, null,' ','X') ysnABRBoard >,decode(board_aobem.description, null,' ','X') ysnAOBEMBoard >,decode(board_aobfp.description, null,' ','X') ysnAOBFPBoard >,decode(board_aobim.description, null,' ','X') ysnAOBIMBAoard >,decode(board_aobr.description, null,' ','X') ysnAOBRBoard >,decode(board_other.description, null,' ','X') ysnOtherBoard >from physicians p >,(select distinct pb.phy_id, b.name, b.description >from phy_boards pb, boards b > where pb.board_id = b.board_id > and (pb.expiration_date >= sysdate or > pb.expiration_date is null) > and b.description like 'AMERICAN ASSOCIATION OF PHYSICIAN > SPECIALIST%') board_aaps >,(select distinct pb.phy_id, b.name, b.description >from phy_boards pb, boards b > where pb.board_id = b.board_id > and (pb.expiration_date >= sysdate or > pb.expiration_date is null) > and b.description like 'AMERICAN BOARD OF > ANESTHESIOLOGY%') > board_aba >,(select distinct pb.phy_id, b.name, b.description >from phy_boards pb, boards b > where pb.board_id = b.board_id > and (pb.expiration_date >= sysdate or > pb.expiration_date is null) > and b.description like 'AMERICAN BOARD OF > EMERGENCY MEDICINE%') > board_abem >,(select distinct pb.phy_id, b.name, b.description >from phy_boards pb, boards b > where pb.board_id = b.board_id > and (pb.expiration_date >= sysdate or > pb.expiration_date is null) > and b.description like 'AMERICAN BOARD OF FAMILY > PRACTICE%') > board_abfp >,(select distinct pb.phy_id, b.name, b.description >from phy_boards pb, boards b > where pb.board_id = b.board_id > and (pb.expiration_date >= sysdate or > pb.expiration_date is null) > and b.description like 'AMERICAN BOARD OF > INTERNAL MEDICINE%') > board_abim >,(select distinct pb.phy_id, b.name, b.description >from phy_boards pb, boards b > where pb.board_id = b.board_id > and (pb.expiration_date >= sysdate or > pb.expiration_date is null) > and b.description like 'AMERICAN BOARD OF PEDIATRICS%') > board_abp >,(select distinct pb.phy_id, b.name, b.description >from phy_boards pb, boards b > where pb.board_id = b.board_id > and (pb.expiration_date >= sysdate or > pb.expiration_date is null) > and b.description like 'AMERICAN BOARD OF RADIOLOGY%') > board_abr >,(select distinc
Re: Implementing Continuous Managed Recovery on a Standby Database
I just started the databases up in the background. Patrol keeps track of the databases but we have never had a problem doing this. Had to write a custom dbstart script though. Works fine but is unsupported by Oracle. --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > Problem: How to keep a standby database in > continuous managed recovery > without having to maintain an open terminal session. > (Version 8.1.7.2) > > When you execute the following... > -- > > SQL> RECOVER MANAGED STANDBY DATABASE; > -- > > ...SQL*Plus does not return a prompt and the > database is in continuous > recovery BUT... as soon as you exit the session, > recovery discontiues and > the logs are nolonger automagically applied. "No > problem," I said, "I'll > just wrap it in a shell script and launch it in the > background." Doesn't > work and it appears SQL*Plus is a misbehaving > process. (Linux) > > So then I tried nohup: > -- > > $ nohup sqlplus "/ as sysdba" @managed_recov.sql & > [1] 23412 > $ nohup: appending output to 'nohup.out' > [1]+ Exit 127 nohup sqlplus "/ as sysdba" > @managed_recov.sql > -- > > The managed_recov.sql script contains this one line: > > RECOVER MANAGED STANDBY DATABASE; > This works but it does not persist as a background > process- it terminates > when I hit enter or leave the terminal session. I > think it terminates > because SQL*Plus is misbehaving. What do you think? > > So with a little help from a *nix geek I did this... > -- > > sqlplus "/ as sysdba" @managed_recov.sql &>standby.log & > -- > > ...presto chango, it works- standard I/O is OK and > running in the > background. The standby DB is in continuous recovery > and I can shutdown my > PC and go home and managed recovery just keeps on > running. Cool. > > Is there a better way to do this? I submitted a TAR > but OWS hasn't been any > help. Doesn't it seem lame that Oracle gives the > "RECOVER MANAGED STANDBY > DATABASE" command but is unable to provide a means > to implement it without > requiring the terminal session to remain open? > > > Whining in Bozeman, Montana > Steve Orr > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Orr, Steve > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqllldr, long datatype and carriage returns - an ugly combin
I cannot speak with experience of CRs in LONG fields, but they have certainly caused problems in varchar2 fields for us. FWIW, here the simple SQL I use to both detect presence of ascii(10), and then clear them out: select COLUMN_NAME from TABLE_NAME where instr(COLUMN_NAME,chr(0)) > 0; update TABLE_NAME set COLUMN_NAME = replace(COLUMN_NAME,chr(0),null); In fact, this basic construct lies within more sophisticated nested scripts, which enables me to browse over all varchar2 columns in the database with a length greater than an arbitrary set value. Also used to hunt down ascii(13). (Damn users WILL use M'S Access to load data...). More if required... peter edinburgh > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 12 December 2002 09:24 > To: Multiple recipients of list ORACLE-L > Subject: sqllldr, long datatype and carriage returns - an ugly > combinatio > > > Listers, > I have got a number of tables with long columns in them. The text is > free-format and contains carriage returns. Some long columns > may be empty > and others will have varying lengths of data (typical > call-centre operator > input scenario) there is no end of record marker that is > common between > columns. > I need to extract each record and load it via sqlldr into > another system. I > could extract using field1||chr(126)||field2||chr(126) etc > 126 being the ~ > character but that does not get around the chr(015) CR issue. > > I understand sqlldr has issues with CR and I have tried > various ways of > resolving this problem. I cannot pre-process the records and > remove the CR > character because of the volume of data and the lack of time involved. > > I have looked at the stream record format option in my > control file and I > fail to get this tro work as it seems to hang the session > every time I call > it. I also suspect that it defines a common end of record > marker and as I do > not have one I would have to massage the data which is not a > route I can go > down. PS This is Tru64 and 8.1.7 but I think it is a general > issue and not > specific to any version of Oracle or o/s > > Furthermore it appears that using stream record format > parameter reduces > performance which is a key requirement for us. > > The questions are > > 1)How have other people managed with carriage returns in > long columns > (I suspect a CR in a varchar2 field will be a problem as well)? > 2)Is the stream record format the way I want to go (I suspect not) > 3)Has anybody any better ideas > > TIA > > John > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: <[EMAIL PROTECTED] > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need help Reformatting output
Title: RE: Active sessions chewing up a huge amount of RAM
Ah - a
nice tricky one!
The
explanation can be lengthy. The solution involves use of decode. The best advice
I can give is to refer you to the chapter on Decode in the Koch / Loney Oracle
Press book ('Oracle Complete Reference'). The chapter is entitled 'DECODE - Amazing Power in a Single Word'.
peter
edinburgh
-Original Message-From: Sergei
[mailto:[EMAIL PROTECTED]]Sent: 12 December 2002
02:59To: Multiple recipients of list ORACLE-LSubject:
Need help Reformatting output
I am looking for a way to
display rows as columns.
For
example:
Id
name
value
1
a
5
1
b
10
2
a
15
2
b
20
I need it
as:
name 1
2
a
5
15
b
10
20
Thank you in advance
Sergei.
*
This e-mail message, and any files transmitted with it, are
confidential and intended solely for the use of the addressee. If
this message was not addressed to you, you have received it in error
and any copying, distribution or other use of any part of it is
strictly prohibited. Any views or opinions presented are solely those
of the sender and do not necessarily represent those of the British
Geological Survey. The security of e-mail communication cannot be
guaranteed and the BGS accepts no liability for claims arising as a
result of the use of this medium to transmit messages from or to the
BGS. The BGS cannot accept any responsibility for viruses, so please
scan all attachments.http://www.bgs.ac.uk
*
Re: career questions
I have gone the consulting route three times in my career. Here are some observations in no particular order of importance. Solo is a tough way to go. You have to find the business and do the work. Either, done right is a full time job. In spite of the fact that as professionals we place a lot of weight on technical expertise, the people that hire you frequently do not know how to evaluate your skills. Being able to fit into their comfort zone is frequently more important than abilities. If you can consistently make your deadlines you are going to build a solid reputation. People who hire you like on time, on budget performance. Do not be too intimidated by a specific set of required skills. My first Oracle gig resulted from a conflict between a director and an IT manager. The Director knew exactly what she wanted and the IT manager was sending her project to the back of the bus. After the project was successfully implemented, 18 months later, I asked her why she had hired me over all of the people with Oracle experience. Her answer was simple, "You listened to me." She knew what she wanted and she felt I could deliver it for her. That lucky assignment opened a whole new career for me. Integrity matters. Your word does need to be your bond as a consultant. If you work for a consulting firm, make sure that they can deliver the kind of assignments that are good for your career. I worked at one for about six months in a variety of different assignments. Some Oracle, some not. When I complained about the lack of consistent Oracle work, one of my coworkers laid it all out for me, "This is a good place to work if you are a money whore." I wanted my life defined by more than money so I left. My two cents worth and you get what you pay for. --- Maria Aurora VT de la Vega <[EMAIL PROTECTED]> wrote: > Gurus, > > I have been an Oracle DBA for almost 5 years and > would like very > much to venture into independent Oracle consulting > (part-time). As i > have spent most of these 5 years as a sole DBA for > different companies, > studying and learning the ropes of Oracle > Administration through books, > magazines, test machines and this list, I feel > confident enough to > handle most Oracle issues. At the same time, I still > have that feeling > of inadequacy. I am not sure if I am good enough to > offer my services to > local companies. > That said, I'd like to ask every one who are > into consulting (on > their own or as a part-time gig) what are the > technical and soft skills > necessary before I even think about consulting. How > would you know that > you're "technically" ready for it. And how do I get > started. Tips are > welcome too! > > Thanks everyone. > > =) > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Maria Aurora VT de la Vega > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Undelete Record
> > > Hi Listers, > > I have little problem : Hmmm, that may not be a little problem at all > how to undelete record that we've delete and commit so I can > restore again > in my data, thanks a lot. You can resort to conventional Oracle backup and recovery (other folk will tell you all about that). But if you have important data tables, you can audit them individually. We have. We also have people who are liable to do just this sort of thing. Using our auditing approach, we can recover immediately, even after a commit. Requires an audit table for each data table, with a pre-change trigger to capture each row before the DML statement. More details if you wish (after Christmas - I'm off!) peter edinburgh > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Sony kristanto > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk ***** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: year 2059 problem
Hi I have just tested with 2037 on a linux (2.4.18) with rdbms 9.2.0.2 and this works. Lyndon Tiu wrote: Hmmm, anyone tried Linux Oracle with year 2059? -- Lyndon Tiu On Sunday 29 December 2002 08:28 pm, Amit Nargotra wrote: This strange problem we are facing while implemting Oracle Based ERP at Nepal for asian paints. Nepal follows Hindu calender, as per the hindu calender the current year is 2059. as we try to install oracle 9i keeping year as 2059. oracle gets installed, but it is unable to create database.(OS is windows - 2000 server) even D2K is not running on 2059. we have tried different years and we found that till 2035 oracle is able to create database after 2035 it fails to create database. we have contacted oracle india also. they have said this is windows related problem. can any body help us out. Thanks in advance. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk
Trace Assistant
Has anyone successfully used trace assistant on Windoze computers. I have tried to use it on client trace files from both Win2K and NT4.0 SP6 without success. The error message is completely useless and the error number returns no response from MetaLink. The only recommendation I have seen is to edit the nsprecv and nspsend in the Hex returns to eliminate a space. I tried this without success. The threads on MetaLink indicate that this is a real buggy app that is fixed in 9i. We are running 8.1.7 clients with no possibility of upgrade in the imediate future. Of course, I can drudge through trace files as I have always done. Just hoping for a better way. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00600: [2662]
Mogens I do agree that this ora-600 [2662] is in the code that handle SCN numbers, since SCN handling is used many places in the code the stack trace that show which path throw the code you took is necessary if there is no hits on metalink fits the problem ;-) Mogens Nørgaard wrote: This response from Oracle is not a good one. Kirti is on the right track regarding the SCN stuff as far as I remember. Other than that, I know that Peter Gram and Bjorn Engsig (among a lot of other guys) might be able to suggest something, so I've CC'ed them. I have my own law on ora-600s: If you supply all the required information (tracefiles, alertlogs, repro-case, etc.) chances are Support is not gonna need them. If you miss out just one of those things, chances are Support will tell you they cannot proceed without that vital piece of information. In other words: There's no hope :-))) Could also be related to db-links between v7 and v8... But back to the good questions from Kirti: Have you set the funny _-parameters he mentions? Mogens PS: I do beleive there are ways around this with an alter system or alter session command where you bump the SCN some , but Peter/Bjorn/someone can confirm this. Sinardy Xing wrote: Hi guys, This is what I get from Oracle == Hi Sinardy, I've check several bug looking for the cause of this problem. However, what I've found is that Development could not diagnosis the problem other than the possibily hat there was some memory corruption that gave a bad SCN. Although, they could "sometimes" determine the root cause prior to the problem occurring by using certain parameters were set in the database. Those parameters are: a)_db_block_cache_protect. b)_db_block_checking c)DB_BLOCK_CHECKSUM They also recommended running dbverify on all datafiles tomake sure all files are clean on disk. IMPORTANT == These parameter may help later determine what cause the ORA-600 [2662] (and it's not for certain that a cause can be found). They parameters does have some performance overhead, but unfortunately this is the only way that can help in catching and we have to wait until the problem happens again. So, the bottomline is there is no list of reason for why this error occuring other than the error occurs when a data block SCN is ahead of the current SCN. Sorry Sinardy, we don't have more information. Thanks! Wonda = What can I do, help me please... Sinardy -Original Message- Sent: 07 January 2003 13:09 To: Multiple recipients of list ORACLE-L Sinardy ORA-0600 is really an encoded message from Oracle that reads : 'Thank you for helping find yet another bug in our software. You can now release your sphincter (some herbal tea might help), especially if this has cropped up in production. We suggest you do not try to solve this one by yourself, which is why the arguments are supplied. Kindly call OWWS with your CSI number, tell them exactly which version and platform you ran this on, and if we have encountered this previously, there is a small chance that we could have a patch. If not, please do not hold your breath waiting, while we assign this to an experienced software engineer, or perhaps a recent college grad, in which case, you're toast !' However, we will ask you to ftp up to our ftp site loads of dumps and traces which might prove useful. Seriously though, ORA-0600 are mysteries. Your best chance is to get Tim Gorman to look at it, he has an amazing knowledge of these. And of course, Tim should not work for free either. (Tim, it was 10% commission we agreed on, right ? ) :-) Ferenc Mantfeld -Original Message- From:Sinardy Xing [SMTP:[EMAIL PROTECTED]] Sent:Tuesday, January 07, 2003 2:34 PM To:Multiple recipients of list ORACLE-L Subject:ORA-00600: [2662] Hi all, I hit by this error ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], [54173017], [16781180], [], [] Can you help me where to find info about this error Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: Different Backups - A Comparative analysis
Ditto what Jared said. It was bad! --- Jared Still <[EMAIL PROTECTED]> wrote: > > Yes, well, I've heard that claim too. > > It may actually work now, but a very capable DBA ( 2 > actually ) > spent quite a bit of time testing this with no good > results. > > And then there was the SQL BT glitch that left one > of my former > coworkers without a certain TBS in the DW for 6 > weeks. > > Yes, 6 weeks. > > And you complain about Oracle Support. ;) > > Jared > > On Monday 13 January 2003 18:29, Deshpande, Kirti > wrote: > > I think SQLBackTrack can get the table data back > from the backup file > > without the need to create a partial database on > another server and then > > export the table from it. > > > > I remember seeing a demo where a dropped table was > recovered by the BMC > > rep. > > > > - Kirti > > > > -Original Message- > > Sent: Monday, January 13, 2003 6:15 PM > > To: Multiple recipients of list ORACLE-L > > > > > > RMAN Does everything that SQL Backtrack does, for > free. :-) > > In fact, last I heard, BMC was planning on > altering SQL Backtrack so that > > it > > > > is really nothing more than a nice fancy front end > to RMAN. When I was > > at CSX we moved away from SQL Backtrack to RMAN > and never had any regrets. > > The only issue with SQL Backtrack vs. RMAN was > support for 7.x databases. > > RMAN does not support anything < 8.0. > > > > RF > > > > Robert G. Freeman > > Technical Management Consultant > > TUSC - The Oracle Experts www.tusc.com > > 904.708.5076 Cell (it's everywhere that I am!) > > Author of several books you can find on > Amazon.com! > > > > > > > > -Original Message- > > Sent: Monday, January 13, 2003 4:39 PM > > To: Multiple recipients of list ORACLE-L > > > > > > > > I *think* that RMAN does everything SQL Backtrack > does. > > > > Can't be positive, as I haven't used it for > awhile. > > > > RMAN seems to have everything I recall SQL BT > having, and then some. > > > > Jared > > > > On Monday 13 January 2003 12:38, Tim Gorman wrote: > > > Don't know really. Just thought that it should > probably be included, > > > then I was hoping to find out... :-) > > > > > > - Original Message - > > > To: <[EMAIL PROTECTED]>; "Tim Gorman" > <[EMAIL PROTECTED]> > > > Sent: Monday, January 13, 2003 10:49 AM > > > > > > > On Monday 13 January 2003 06:03, Tim Gorman > wrote: > > > > > Another question: should SQL BackTrack be > included for > > > > > consideration? > > > > > > > > What does SQL BackTrack to that RMAN doesn't > do? > > > > > > > > Jared > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jared Still > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN error when deleting archivefiles on tape
Dear RMAN Wizards I have this problem with a script for deleting archive file on tape. The story is that this script has worked perfect for more than a 2 year until the database and there by rman was upgraded to 8.1.7.4 from 8.1.6..x. The media manager is TSM (IBM Tivoli) and everything is running on a Win NT 4 sp 6a. The odd thing is that backup and restore works OK, this was tested. The NT box is using TSM to send the the backup to a MVS that has the tape robot attached. I have looked at Metalink / Google and IBM Web support without getting a sensible clue. -- Start Fri 03/01/2003 10:29 Recovery Manager: Release 8.1.7.4.1 - Production RMAN-06005: connected to target database: TMSPRD8 (DBID=4183866567) RMAN-06008: connected to recovery catalog database RMAN> allocate channel for delete type 'SBT_TAPE'; 2> change backuppiece '/archivefiles/af_TMSPRD8_480164575_21631_1' delete; 3> change backuppiece '/archivefiles/af_TMSPRD8_480197119_21669_1' delete; 4> change backuppiece '/archivefiles/af_TMSPRD8_480197446_21670_1' delete; 5> change backuppiece '/archivefiles/af_TMSPRD8_480197663_21671_1' delete; 6> change backuppiece '/archivefiles/af_TMSPRD8_480197810_21672_1' delete; 7> change backuppiece '/archivefiles/af_TMSPRD8_480250980_21673_1' delete; 8> change backuppiece '/archivefiles/af_TMSPRD8_480251087_21674_1' delete; 9> change backuppiece '/archivefiles/af_TMSPRD8_480251194_21675_1' delete; 10> change backuppiece '/archivefiles/af_TMSPRD8_480251313_21676_1' delete; 11> change backuppiece '/archivefiles/af_TMSPRD8_480251421_21677_1' delete; 12> change backuppiece '/archivefiles/af_TMSPRD8_480251531_21678_1' delete; 13> change backuppiece '/archivefiles/af_TMSPRD8_480251648_21679_1' delete; 14> change backuppiece '/archivefiles/af_TMSPRD8_480284960_21717_1' delete; 15> change backuppiece '/archivefiles/af_TMSPRD8_480285117_21718_1' delete; 16> change backuppiece '/archivefiles/af_TMSPRD8_480285323_21719_1' delete; 17> change backuppiece '/archivefiles/af_TMSPRD8_480285480_21720_1' delete; 18> release channel; 19> exit; RMAN-03022: compiling command: allocate RMAN-03023: executing command: allocate RMAN-08030: allocated channel: delete RMAN-08500: channel delete: sid=71 devtype=SBT_TAPE RMAN-08526: channel delete: Tivoli Data Protection for Oracle: version 2.2.0.0 RMAN-03022: compiling command: change RMAN-03023: executing command: DELETE RMAN-03026: error recovery releasing channel resources RMAN-00571: === RMAN-00569: === ERROR MESSAGE STACK FOLLOWS === RMAN-00571: === RMAN-03006: non-retryable error occurred during execution of command: change RMAN-07004: unhandled exception during command execution on channel delete RMAN-10035: exception raised in RPC: ORA-19509: failed to delete sequential file, handle="/archivefiles/af_TMSPRD8_480164575_21631_1", parms="" ORA-27027: sbtremove2 returned error ORA-19511: ANS0238E (RC2041) The sequence of calls is invalid. RMAN-10031: ORA-19509 occurred during call to DBMS_BACKUP_RESTORE.CHANGEBACKUPPIECE Recovery Manager complete. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:[EMAIL PROTECTED] - http://MiracleAS.dk smime.p7s Description: application/pkcs7-signature
Re: log_file_sync io wait question
Hi Pat There is not a lot you can do since every commit will force a write to the disk ! You are hitting that limit of the disk that normally is app. 100 - 120 I/O per sek. The only real fix is change the application to do less commit's. It will not help to change the size of the redo log buffer or the redo log files if you have multiple redo log members on the same disk it will help to separate the members to different disk's but it will not fix the design problem of committing for every insert. Somebody might suggest you to put a chach on the redo log file system but don't this very dangerous since Oracle assumes that writes to disk's are true writes and if you ever had a loss of the chach there is a big chance that your database would loose transactions :-( Pat Howe wrote: >We have a canned package that we use to insert approx 100 records/second >into one table (oltp environment). >Each record is just under 1K (datatypes = number and varchar). >There are several indexes that are build on the table as the records are >inserted. >Each and every record is committed. >Therefore we are flushing the 'redo log buffer' to disk (online redo >logfiles) 100 times per second (once per commit). > >Not surprisingly we have noticed IO waits which we believe are associated >with our 'Redo Log buffer'. Namely ; > log_file_sync = 180 waits/sec > log_file_parallel_write = 180 waits/sec > >We tried resizing the 'redo log buffer' from 16K to 256K - but we did not >notice any improvements. >Neither Log switching or archiving seem to be excessive. >100 records per second seems to be our maximum speed without the application >queuing up and Oracle showing very high waits on log_file_sync and >log_file_parallel_writes. > >Does anyone know how we might be able to minimize the IO waits? > >Thanks in advance. > >ENVIRONMENT >oracle : Oracle 8.1.7.4 >os : Sun Sparc Solaris 8 >box: 8x8 E10K >IO : Hitachi SANS unit through fiber and Brocade switch > > >_ > Patrick J. Howe > > > > > -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
RE: Consulting Position Available-Oracle DBA/Developer/NYC
Or SQL server -- = 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" = 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. Bill Christison <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 20-09-2002 11:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Consulting Position Available-Oracle DBA/Developer/NYC TD, Transactional..for Sybase Bill Christison --- Thomas Day <[EMAIL PROTECTED]> wrote: > > Datawarehouse meta data. > > But what the heck is T SQL? > > > > > > "Miller, Jay" > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > @TDWaterhousecc: > > .com>Subject: RE: > Consulting Position Available-Oracle DBA/Developer/NYC > Sent by: root > > > > > > 09/19/2002 > > 02:08 PM > > Please > > respond to > > ORACLE-L > > > > > > > > > > But 4th normal form? Does anyone really use this? > > -Original Message- > Sent: Tuesday, September 17, 2002 3:35 PM > To: Multiple recipients of list ORACLE-L > > > well the market must be picking up some, been definitely more > reqs > posted here a/o recent. > > joe > > > Bill Christison wrote: > > >Interested candidates reply to: [EMAIL PROTECTED] > >* > >Consulting Position Title: > >Oracle DBA/Developer > > > >Duties and Responsibilities: > > > >This position is a conversion to an Oracle Data warehouse. > >Excellent verbal skills are needed to obtain technical > >specification from the architect and users then to transform > >into written specifications. > > > >Experience Required: > >*Must have experience in PL SQL and T SQL > >*Must have 3rd and 4th form data normalization > >*Must have done business systems analysis > > > >Consulting Assignment Duration: 6 months to 12 months > > > >Assignment Location: New York City > > > >= > >Bill Christison > >Knowlton Group, LLC > >845-258-5129 > >www.knowltongroup.com > > > >__ > >Do you Yahoo!? > >Yahoo! News - Today's headlines > >http://news.yahoo.com > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail > message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). > You may > also send the HELP command for other information (like > subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web hosting > services > - > To REMOVE yourself from this mailing list, send an E-Mail > message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') > and in > the message BODY, include a line containin
Query Tool That Reads LOBs, CLOBs, etc.
We have a development project that is using third party software. The tables include several clob datatypes. The project needs to identify a tool that allows a knowledgeable user can use to browse data in the CLOBs. Does anyone have any suggestions of tools to do this? Thanks, = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Scripts to reengineer a DB / recovery speed-up
Go to Cool-Tools website http://www.cool-tools.co.uk/ and have a look at the Databee DBA Tool Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = 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" = 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. Andrey Bronfin <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 23-09-2002 04:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Scripts to reengineer a DB / recovery speed-up Dear gurus ! Could you please point me to a free script /tool to capture the current DB metadata and to be able to recreate the DB (except for the actual data), i.e. tablespaces, users, roles etc... I can think of 2 semi-ways of doing it: 1) get the physical DB attributes (data files , redo logs , character set etc..) from "alter database backup controlfile to trace" 2) get the rest of metadata from a full DB export with no rows (rows=N). But if someone has a ready script , it will save me some time and work ;-) Thanks a lot ! Another question : i need the above in order to speed up bringing our DB back to production. We currently back it up via RMAN to tapes (via HP OmniBack II). This is a quite large DB (~950 GB, running on win2k , no UNIX) , and the RMAN restore/recovery took almost 48 hours after the recent crash. We're looking to speed up recovery and the most feasible option seems to be this : recreate the DB (empty DB , just build the users, TBS , tables etc..) , load configuration / reference / lookup/ static data (which needs to be backed up (exported) separately) . At this point the DB is operational again, loss of detailed data may be tolerated. The actual question is : what do you think of this scheme ? DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG40831 Description: Binary data
RE: Agnostic references for Pracle v SQl Server 2000
Hi Maybe you need to talk with a Developer to quickly do a rough estimate of costs involved in taking one on the more complex form/reports systems to VB/.net platforms. make sure they don't scrimp on cost but be realistic. I don't think a 1 page report is fair or does justice to the question so develop a longer report and produce a 1 page executive summary to present, but say a development cost of 1,000,000 in that report to move only one application might be a significant hindrance to the M$ is cheaper. Also beware that a lot of things run in Win2k/sqlserver, but to get the advanced features for say clustering you then need to be running Advanced Server along with M$ clustering software and the price point then runs up somewhat higher. Remember the MSDN licenses that will need to be acquired, along with NT licenses if you don't currently have them Oh and decent Intel based hardware for the DB servers. Also consider talking to your Oracle rep and see if the issue of pricing re Charity status cant be worked over. A lesser license to Oracle for a registered charity has to be better than no license fee in the present climate. my 0.02c Cheers -- ===== Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = 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" = 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. "Martin Kendall" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 24-09-2002 08:53 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Agnostic references for Pracle v SQl Server 2000 Hi Dennis, They have 5 databases, dating back to 7.1 and up to 8.1.7 They also have some very complex Oracle Forms and Reports. What they do not realise at the moment is the amount of work they will have to put in to convert the Apps. AND retrain the 4-5 members of staff who are more scientists than DP professional types. The data extraction and migration itself should not be a problem. The "Oracle costs a lot of money to licence" story has worried them quite a bit. Martin -Original Message- WILLIAMS Sent: 23 September 2002 21:49 To: Multiple recipients of list ORACLE-L Martin - Thanks for the clarification, but this prompts more questions. Is there a single database involved that multiple clients share the use of, or are you the vendor of a product that sits atop a database, but each client has their own database installed at their location. If it is the latter, then the correct answer would be for them to keep ported to both Oracle and SQL Server. My experience has been that Microsoft tries to arrange it so that if you have a Microsoft front-end (.NET or VB), interface to the database will be much easier. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Monday, September 23, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Hi Dennis, Personally I would like them not to move. Apart from all the Platform issues, they don't have ANY experience in .NET architecture and they only think it will be easier to administer the DB because they do not have any experienced Oracle DBA's in their employ. I am struggling to understand how they can possibly think of future-proofing their systems AND at the same time become a 100% Microsoft site. Martin -Original Message- WILLIAMS Sent: 23 September 2002 20:39 To: Multiple recipients of list ORACLE-L Martin - If I understand your first statement, the database is now on Oracle and you are writing a paper on why they should move it to MS SQL Server. If this is true, and given your other statements about the client, I would think you could get plenty of reasons from the Microsoft web site. Or did you mean to say you are trying to give them reasons not to move? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Monday, September 23, 2002 1:34 PM To: Multiple recipients of list ORACLE-L Hello all. I need to provide a on
Re: DBA work load
Sadly this is one of those "How long is a piece of string" questions, It relates to what are you doing with those databases what support is required on a daily basis for those databases I can have a single database that requires 2 full time DBA's and another DBA supporting 20 or 50 databases. It also comes down to the available management tools that you have to do set analysis tasks like mining the alert logs for errors. Apparently the book "Implementing and Managing Oracle Databases" has a chapter to assist in answering this question. I think one of the best ways to get a understanding on this is to show your manager what it is you do each day by doing a time and motion study on yourself, something like 8 am checked alert logs on databases 930 am Checked tablespace utilisation 10am increased xxx tablespace on database 1030 worked with Finance to tune new ad hoc query ( ie used for corporate BI tool) and so on Also you might like to see if having some management tools would simplify any processes to free up time and provide a list of tools, how they make you more efficient and the proposed cost of such tools. You can then say that the tools whilst useful still aren't going to be able to recover those 3 mission critical databases if they were to crash when you are 2 continents away skiing or surfing. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = 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" = 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. tony ynot <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 24-09-2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:DBA work load I'm trying to justify hiring another DBA, and management wants more justification. I have put together the usual reasons, but they want "Industry Standards", like how many Databases can one DBA manage. Or how many GB/DBA or endusers/DBA? Does anyone keep these kind of stats? thanks __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tony ynot INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG09122 Description: Binary data
DBA place in the business (was RE: DBA work load)
I've found the thread on DBA workload valuable and interesting. It endorses points made repeatedly over the past years, basically the highly variable nature of the job. This variability is giving us a small problem. Our dba work (shared between two of us) tends to function in the background, and of course because we do it so damn well (!!), our impact on the running of the organisation is pretty low. Kind of 'reverse exception' effect, if you will. There is now a desire to formalise the role of the dba function within the organisation, and nobody has the first idea of how to define, in an organisational / structural sense just how the dba role slots in. I'm talking about organsiational charts, herarchies etc, that sort of thing. Not just across the org, but particularly within the IT domain too. Specifically, dba impacts from the low-level hardware side, right up to application development, with everything in between. And that already spans several existing lines of management responsibility. Our problem has added spice as we are (trying) to operate a matrix management system, which repeatedly throws up intriguing political dimensions. Anybody ever been down this particular route? Any thoughts much appreciated, peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: [Fwd: RE: Forms 3.0 ; Oracle 8i/9i ; Patch 380665 ; HP-UX 11]]
Hi Kurth This is from Johannes that is not on the oracle-l mailing list. I have no knowlegde about patch 380665 but I have a happy customer running Forms 3.0 (version Version 3.0.16.12 from the Oracle 7.2.3 installation CD) in an Oracle 7.2.3 home on Sun Solaris (SunOS 5.7), with TWO_TASK set to point at an Oracle 9i instance on another server. So it can work for sure! I would imagine that there could be problems with the installation and execution of Forms 3.0 on some newer operating systems. I tried for years to find a patch that would allow Forms 3.0 to work with Oracle8.x.x. I think there is a path for NT, but none for Unix. Time to bite the bullet and upgrade to Forms 4.5 or higher. -Original Message- Sent: Wednesday, September 25, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Hello guys, I am trying to figure out the mystery of Patch 380665, which allows Forms 3.0 to be used with Oracle 8.1.7 I have a few questions 1. Does this patch exist or is it just a myth? 2. Is this a Database patch or Forms patch? 3. How to get this patch? I would really appreciate if any of ull have travelled this path of trying to make Forms 3.0 work with Oracle 8i. Thanks Mandar -Original Message- Sent: Wednesday, September 25, 2002 11:34 AM To: Mandar A. Ghosalkar -- >>>> SEARCH ORACLE-L 380655 The archive for this mailing list exists, but cannot be accessed. This may be due to the server being down or some other network problem. Please contact [EMAIL PROTECTED] for further assistance. Sorry for the inconvenience. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Privileged/Confidential information may be contained in this message. The information contained in this message is intended only for the use of the recipient(s) named above and their co-workers who are working on the same matter. The recipient of this information is prohibited from disclosing the information to any other party unless this disclosure has been authorized in advance. If you are not intended recipient of this message or any agent responsible for delivery of the message to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of this message is strictly prohibited. You should immediately destroy this message and kindly notify the sender by reply E-Mail. Please advise immediately if you or your employer does not consent to Internet E-Mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of the firm shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kurth, Michael J. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Måløv http://miracleas.dk smime.p7s Description: application/pkcs7-signature
RE: DBA place in the business (was RE: DBA work load)
Give me a break - I'm looking for solutions, not to compound the problem!! peter edinburgh > -Original Message- > From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]] > Sent: 26 September 2002 20:05 > To: Multiple recipients of list ORACLE-L > Subject: RE: DBA place in the business (was RE: DBA work load) > > > and DDBA, and ODBA, and DA, and DM, and DWA, and DWM > ... any more? > > -Original Message- > Sent: Thursday, September 26, 2002 2:37 PM > To: Multiple recipients of list ORACLE-L > > > Have you gone through "what's the difference between an > application DBA and > a database DBA?" yet? > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Boivin, Patrice J > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Inka Bezdziecka > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA place in the business (was RE: DBA work load)
> > Have you gone through "what's the difference between an > application DBA and > a database DBA?" yet? Oh yes, and a logical dba, and a physical dba ... you name it, we found it ... which rather confirms the point Jared was making - 'We fit everywhere, and nowhere.' peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Way of extracting record
Cool Tools have a tool that can assist with this The Extraction and load tool from Databee http://www.cool-tools.co.uk/ Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = 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" = 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. "Deshpande, Kirti" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01-10-2002 02:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Way of extracting record 1. You can use SQL*Plus COPY command to copy data from Production into development database. 2. You can create a link from Development database to Production database, and then use insert into Development database table by selecting data from table@Production database. 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). I would go with #1 first. Check SQL*Plus Reference Guide for (1) and (2) Check Utilities Guide for (3). HTH.. - Kirti -Original Message- Sent: Monday, September 30, 2002 9:18 PM To: Multiple recipients of list ORACLE-L Hi guru , I need your advise , currently our customer have a production and development system , if there is a problem log being raise , then we need to port the data from development to production but not the whole database sometime is only certain record. Is there any method to use instead of generate insert statement for necessary table(PROD) and run the statement (DEV) ? I do think of using XML but I don't know how to do it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG20975 Description: Binary data
RE: Way of extracting record
IF you can identify the problem rows automatically, and flag them as such in your production environment, then you can have those rows automatically copied (or moved - your choice) to your development machine (presumably using database links). For what its worth, we have been doing just this for years, fully automated. Its replication, but not as Oracle recognises the term! peter edinburgh > > > "Deshpande, Kirti" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 01-10-2002 02:13 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Way of extracting record > > > 1. You can use SQL*Plus COPY command to copy data from Production into > development database. > 2. You can create a link from Development database to > Production database, > and then use insert into Development database table by > selecting data from > table@Production database. > 3. You can use export with QUERY option to export just the > rows you need > from each table in Production and import those into > Development database. > However, it will depend on how easy it is to get to the > required data by > the > QUERY option (available with Oracle 8i). > > I would go with #1 first. > Check SQL*Plus Reference Guide for (1) and (2) > Check Utilities Guide for (3). > > HTH.. > > - Kirti > > -Original Message- > Sent: Monday, September 30, 2002 9:18 PM > To: Multiple recipients of list ORACLE-L > > > Hi guru , > > I need your advise , currently our customer have a production and > development system , if there is a problem log being raise , > then we need > to > port the data from development to production but not the > whole database > sometime is only certain record. > > Is there any method to use instead of generate insert statement for > necessary table(PROD) and run the statement (DEV) ? > > I do think of using XML but I don't know how to do it > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raymond > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Deshpande, Kirti > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
7.3.2 ->7.3.4.4
Hi Friends, I had one of the oracle production database with 7.3.2 on AIX, I want to go 7.3.4 base first and apply patchset 7.3.4.4. Could any body have document that takes me step by step process!! The documentation is there in CDs, But not step by step process!! Thanks in advance peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: oracle-dba.com domain auction
With the economy in the tank and most of the successful web businesses being the old bricks and mortar stores with another means to penetrate the market, did you expect otherwise? A web presence is so passive that it is not much of an investment without the ability to do collateral advertising. Especially, something as marginal as a specialized oracle web site. I did the research a couple of months ago for a site like this and concluded I could not make it pay off. There are some major league players who are no longer in the phone book (or on the web). I had to ask myself, with compelling data in hand, "What made me think I was smarter than they were?". Lacking a good answer I set the whole idea aside for another day. Keep your domain name for another day. It may have value in the future but right now it is likely just another casualty in the dot bomb train wreck. --- JOE TESTA <[EMAIL PROTECTED]> wrote: > With as much interest as i'd seen, i'd thought it > would have been above $102.50, oh well unless you > all run up the price in the last few days, guess > i'll just be holding onto it for a while. > > joe > = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA work load - BDBAFH #1
Nah - I go for the subtle approach - 'YES?' - very, VERY loudly! And looking them dead straight in the eye... (You should see 'em jump!) peter edinbugh > -Original Message- > From: Connor McDonald [mailto:[EMAIL PROTECTED]] > Sent: 01 October 2002 15:38 > To: Multiple recipients of list ORACLE-L > Subject: RE: DBA work load - BDBAFH #1 > > > My favourite when they come to your desk... > > "Ah, I see the f..k up fairy has come to visit" > > (Apologies for profanity) > > :-) > > --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > > Paula, > > > > It just takes practice. You can learn to say no. I > > did. You just have > > to work up to it :) > > > > You start with: > > > > "If I do that for you now, I will fall behind x days > > on the critical > > project I am working on for you" > > > > move on to: > > > > "I'm sorry. I have too much to do" > > > > then to: > > > > "not gonna happen" > > > > and finally, either of the following: > > > > "what part of the word NO don't you understand?" > > > > or (my personal favorite) > > > > "failure to plan on your part does not constitute an > > emergency on mine" > > > > > > Try it, you'll like it > > > > > > > > --- [EMAIL PROTECTED] wrote: > > > H. How come I always seem to be the DBA who > > can't say no - you > > > don't > > > seem to have that problem at all. > > > > > > -Original Message- > > > Sent: Monday, September 30, 2002 3:58 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > The phone rings. Another user. Still pissed off, > > I pick it up... > > > > > > "Database Administration, can I help you?" I > > answer professionally. > > > > > > Troubled silence on the phone. Politeness is a > > very bad signal from > > > me and > > > they know it. He was rattled. > > > > > > "Uh, hi, this is Joe, technical lead on that > > super-critical project > > > for > > > Benefits? Is this a good time? I have some stuff > > I need moved to > > > production?" > > > > > > The last was a statement, but it came out like a > > question. With a > > > slight > > > quaver in the voice, too. Excellent. Technical > > lead my arse. > > > > > > "Could you be more specific so I can schedule you > > appropriately?" > > > > > > He hesitated. Gosh, I sounded for real. I almost > > convinced myself. > > > The > > > victim approached warily. > > > > > > "I've got a bunch of PL/SQL packages and some > > outlines to speed up > > > the > > > queries with special hints. The scripts are all > > ready for your > > > review, they > > > include the create statements, the grants, > > everything. I'm > > > forwarding the > > > email package to you with signoffs from IT, the > > user department, and > > > your > > > own from reviewing our design and test results". > > This last was > > > delivered > > > with almost pathetic eagerness. Good boy. Good, > > simple, foolish > > > boy. > > > > > > If he could see me he'd be terrified by my grin. > > "Joe, I need you to > > > help > > > me out. You've just given me 10 minutes of work, > > but I'm due for > > > lunch in 5 > > > minutes. What do you suggest I do?" > > > > > > Joe knew better, he really did. But his team had > > been up all night > > > finishing and the prize was so close... > > > > > > "Look, I really hate to impose. But we've missed > > several major > > > deadlines, > > > and department head has made it clear if we screw > > up again he'll > > > outsource > > > the whole project and have us laid off. I need it > > now so we can make > > > sure > > > everything's perfect for the big production run at > > COB today". > > > > > > "Consider it done," I promised cheerfully and > > hung up. I surprised > > > him, > > > and maybe mysel
Re: SQL Backtrack Reports
Do you want to parse the log file and only report the backup start and stop times? If so, that's a really tall order. What we do is run SQL Backtrack from a shell script that reports start and stop time and emails success/failure for each instance. --- "Smith, Ron L." <[EMAIL PROTECTED]> wrote: > If anyone out there is using SQL Backtrack to backup > Oracle I am looking for > a home grown reporting > script that will give me start and stop times for > all the backups on the log > file. > > Thanks! > R. Smith > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Smith, Ron L. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and case structure
Doug Burns wrote a very informative paper on Decode, presented at an earlier UK-OUG meeting. Its available from his web site: http://doug.burns.tripod.com/decode.html And the answer to the question posed below is 'yes'. peter edinburgh > -Original Message- > From: Droogendyk, Harry [mailto:[EMAIL PROTECTED]] > Sent: 07 October 2002 23:59 > To: Multiple recipients of list ORACLE-L > Subject: RE: SQL and case structure > > > Jesse: > > Can I also use the value of another column rather than a > literal like my > example coded? > > e.g. > > select acct_no, >decode(substr(acct_no,16,1),'1',field1 >'2',field2 >field3 ) as descr > from star.kills > ; > > > TIA > > > -Original Message- > Sent: Monday, October 07, 2002 5:28 PM > To: Multiple recipients of list ORACLE-L > > > "CASE" in PL/SQL serves a slightly different function, but > DECODE should do > the trick. Try: > > select acct_no, > DECODE(substr(acct_no,16,1), >'1','one', >'2','two', > 'other') as DESCR > from star.kills; > > I also changed "desc" to "descr", since "desc" is a reserved word. > > HTH! GL! :) > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, > Sussex, WI USA > > > -Original Message- > > From: Droogendyk, Harry [mailto:[EMAIL PROTECTED]] > > Sent: Monday, October 07, 2002 3:39 PM > > To: Multiple recipients of list ORACLE-L > > Subject: SQL and case structure > > > > > > Listers: > > > > I've used SAS's version of SQL and it allows the coding of > > conditional logic > > in the SELECT statement: > > > > proc sql; > > select acct_no, > > case substr(acct_no,16,1) > >when '1' then 'one' > >when '2' then 'two' > >else 'other' > > end as desc > > from star.kills; > > quit; > > > > The same syntax does not work in SQL*Plus for Oracle 8. Can > > someone point > > me to the correct syntax? > > > > Secondly, any URLs for this kind of information would be most > > appreciated. > > > > Regards, > > Harry > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Droogendyk, Harry > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all at
Listener Problem
Yesterday we had a cpu panic followed by a spontaneous reboot of a Sun E6000 server. When the server and databases came back on line we were getting 'no listener' errors from several Unix servers but not all of them. We also lost connectivity between the mainframe and the databases on the affected server. Those that failed were consistent, those that conected were also consistent. The Unix Admin captured the following lines from a netsta -an command: Following line is from dragon - the server that has the TNSLISTENER on only one interface 161.208.1.138.1521 *.*0 0 0 0 LISTEN Following line is from beowulf - the server that has the TNSLISTENER on all interfaces *.1521 *.*0 0 0 0 LISTEN He is focusing the ip address binding to the oracle port on one server but using a wild card for the other. We have a tar open for this but so far, they have not been too helpful. = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Listener Problem
Magically, it's fixed. No one has 'fessed up' but it is definietly not an Oracle problem. --- Peter Barnett <[EMAIL PROTECTED]> wrote: > Yesterday we had a cpu panic followed by a > spontaneous > reboot of a Sun E6000 server. When the server and > databases came back on line we were getting 'no > listener' errors from several Unix servers but not > all > of them. We also lost connectivity between the > mainframe and the databases on the affected server. > Those that failed were consistent, those that > conected > were also consistent. > > The Unix Admin captured the following lines from a > netsta -an command: > > Following line is from dragon - the server that has > the TNSLISTENER on only one interface > > 161.208.1.138.1521 *.*0 > 0 > 0 0 LISTEN > > > Following line is from beowulf - the server that has > the TNSLISTENER on all interfaces > > *.1521 *.*0 > 0 > 0 0 LISTEN > > He is focusing the ip address binding to the oracle > port on one server but using a wild card for the > other. > > We have a tar open for this but so far, they have > not > been too helpful. > > > > = > Pete Barnett > Lead Database Administrator > The Regence Group > [EMAIL PROTECTED] > > __ > Do you Yahoo!? > Faith Hill - Exclusive Performances, Videos & More > http://faith.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 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Advice needed on move to Sun 15K (losing spindles)
Ask the Sun guys if they will sign a document saying they will pay all cost including hardware to fix the performance problems, if after you make the change and performance is worse. It will show that you are serious and if they seriously believe they are right then they have nothing to fear, I never understand why these vendors insist in building systems with so little hardware Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = 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" = 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. Anjo Kolk <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10-10-2002 05:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Re: Advice needed on move to Sun 15K (losing spindles) Jay, You will hit performance problems because of not having I/O bandwidth. Databases don't need storage, they need IO operations. Two important pieces of info that are missing from your post: - How many databases in total are going to run on this Sun 15K ? - How many concurrent users on all databases at the same time ? Anjo. "Miller, Jay" wrote: > > Our CIO has suggested that we get a Sun 15K to house all of our > databases. This has some advantages (communication between the various > boxes would be much faster) but I have some performance concerns. > > Specifically, our main OLTP database would go down from 18 spindles to 8 > spindles. Mirroring will take away 4 of those leaving 4 spindles. The > vendor (Sun) was recommending striping across all 4 spindles. He said we > don't need to worry about i/o issues because there will be a large cache. > > I'm skeptical and argued for cutting them in half (striping 2 and 2). We > could then at least seperate the redo logs from the datafiles (probably > putting them with the oracle executables and some other files). > > The Sun rep kept talking up how much more powerful the CPUs were and I kept > saying, "but we're not CPU bound, we don't need any more CPU". > > If anyone can either > > a) tell me I'm worrying for nothing > b) recommend a better way to stripe/distribute my files > c) provide references or experience to show this is a bad idea > > I'd really appreciate it. > > > Thanks, > Jay Miller > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Miller, Jay > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG18945 Description: Binary data
RE: Listener Problem
Unfortunately, our company is large enough that no one ever really has to admit to anything because it is simply too difficult to run down the perpetrators. The listener did start. Some users could connect to the databases from one server but not another. We think it was related to an intrusion software install, but the back out of the install did not fix the problem. There was a giant meeting of everyone who might have any impact on the box and minutes after the meeting ended everything was working again. My guess is that someone in the meeting recognized a mistake and corrected it without saying anything. So, we will never know the true cause. --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > As luck would have it, we just went through a > similar problem. > > Does the listener actually startup? Can you stop > and restart it manually > using "lsnrctl"? > > Ours wouldn't. We tracked it down to two problems, > both security related. > The one that was hampering our listener was a change > in /etc/nsswitch.conf > that caused a change in the way that the listener > tried to listen on the > port. Specifically, look for differences in the > "protocols" line and the > "services" line. Also, potentially, the "ipnodes" > line. > > We were installing LDAP and had changed these lines > to "ldap > [NOTFOUND=return] files", but the listener just > didn't like it, so we > changed them back to just "files". Also, the only > time we'd see a problem > is in the start and stop of the listener. If we > changed the files back to > "ldap..." while the listener was up, connections > worked fine. We just > couldn't start it back up if it was shutdown. > > Barring this, check for security differences in your > "bin" and "network" dir > trees under $ORACLE_HOME. Check for owner, group > and protection bits. > > HTH! GL! :) > > Rich > > > Rich Jesse System/Database > Administrator > [EMAIL PROTECTED] Quad/Tech > International, Sussex, WI USA > > > > -Original Message- > > From: Peter Barnett [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, October 09, 2002 2:09 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Listener Problem > > > > > > Yesterday we had a cpu panic followed by a > spontaneous > > reboot of a Sun E6000 server. When the server and > > databases came back on line we were getting 'no > > listener' errors from several Unix servers but not > all > > of them. We also lost connectivity between the > > mainframe and the databases on the affected > server. > > Those that failed were consistent, those that > conected > > were also consistent. > > > > The Unix Admin captured the following lines from a > > netsta -an command: > > > > Following line is from dragon - the server that > has > > the TNSLISTENER on only one interface > > > > 161.208.1.138.1521 *.* 0 > 0 > > 0 0 LISTEN > > > > > > Following line is from beowulf - the server that > has > > the TNSLISTENER on all interfaces > > > > *.1521 *.* 0 > 0 > > 0 0 LISTEN > > > > He is focusing the ip address binding to the > oracle > > port on one server but using a wild card for the > > other. > > > > We have a tar open for this but so far, they have > not > > been too helpful. > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 > http://www.fatcity.com > San Diego, California-- Mailing list and web > hosting services > - > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 list for developers ??
Actually there is and it runs of the fatcity servers go to the ODTUG website http://www.odtug.com and the details to sign up are there Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = 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" = 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. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11-10-2002 09:04 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Oracle list for developers ?? No there isn't. And a google search certainly wouldn't turn up any. Give up the quest and read your manuals. That is all. Scott Shafer San Antonio, TX 210.581.6217 > -Original Message- > From: Droogendyk, Harry [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 5:44 PM > To:Multiple recipients of list ORACLE-L > Subject: Oracle list for developers ?? > > Listers: > > While I certainly appreciate the great range of experience and knowledge > by > the subscribers on this list, if my rudimentary knowledge is to be > trusted, > I think 95% of the postings are DBA type stuff. > > Since I'm interested in developer questions / answers I'm asking, again!!, > if an Oracle list exists that is developer oriented rather than DBA > oriented. > > TIA for your answers. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG06646 Description: Binary data
Session Data Unit and tcp.nodelay
We have third party CAD application called VPM which we are using to organize 3d engineering models. It uses an Oracle database to store some information on locations of models and relationships between parts. We are having some performance problems which seem to point to the database access. With sql tracing turned on, we determined that one of the operations in question used more than 1700 sql statements. The consultant we work with is suggesting that we try to improve the Net8 throughput either by seting tcp.nodelay or by adjusting the size of the Session Data Unit. A quick look at the Net8 manual suggests that both of these could potentially improve throughput by forcing packets to be sent out sooner instead of blocking several requests/responses together. Does anyone have any experience with these settings? Any suggestions as to what settings to try as a start? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Interpretation of TKPROF output
I am running tkprof on some trace files with the following options: (Oracle 8.1.7) explain=/ sort=exeqry,fchqry,execu,fchcu Output after each query includes the following two tables: Rows Row Source Operation --- --- 36 INLIST ITERATOR 36 TABLE ACCESS BY INDEX ROWID PART_LIST 72INDEX RANGE SCAN (object id 3451) Rows Execution Plan --- --- 0 SELECT STATEMENT GOAL: CHOOSE 36 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'PART_LIST' The "Execution Plan" table corresponds to the Explain Plan section of the Performance manual. There is no mention, however, of the "Row Source Operation" table. I note particularly, that in some cases the first table seems to agree with the second. In others, however, such as the example here, the Row Source table shows use of an index while the Execution Plan shows a Table Access (Full table scan?). Am I interpreting this correctly? If so, what is going on? Thanks, Peter Schauss Northrop Grumman Corporation [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Warehouse design: snowflake vs star schemas
Just for the record (and perhaps to confirm that there are always two sides to a story). Readers may like to see the article Chris Date wrote to Ralph Kemball on the subject of business rules and integrity constraints: http://www.dbdebunk.com/kimball1.htm peter edinburgh > -Original Message- > From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED]] > Sent: 09 October 2002 15:04 > To: Multiple recipients of list ORACLE-L > Subject: RE: Warehouse design: snowflake vs star schemas > > > Dennis, > > Thanks for the link. It's a great DW resource. > There are not only fundamentals, but some valuable real-life > stuff, which is > what I need. Live and learn, learn,learn... > > Regards, > Alex > > -Original Message- > WILLIAMS > Sent: Tuesday, October 08, 2002 7:39 PM > To: Multiple recipients of list ORACLE-L > > > Alexandre >Stephane gave you an excellent reply. If you want to learn > more about > these DW design issues, I would start by visiting > http://www.ralphkimball.com. He is one of the leading figures > in the DW > field, and has copies of all his articles posted on his site. > I would start > with the oldest articles because those are where he discusses the > fundamentals of data warehousing. > > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, October 08, 2002 3:29 AM > To: Multiple recipients of list ORACLE-L > > > Stéphane, > > Thanks for response. > > > I have always discplined myself to use star schema and > > never snowflake. > Would you mind asking why? > > > The "Which one is easier to implement and easier ETL > > ?" is not a good question as your data model should > > not be design for the ETL procecess but only for the > > querying. > I mean ETL to load data _INTO_ data warehouse. Of course, > complexity is > mostly determined by sources, but still I'd like to know if > there is any > general influence by DW's data model. > > Another question. Is it feasible to make date dimension or > just use date > column? For example, Oracle Discoverer can work with date > columns using > hierarchies Y->M->D and similar. > What is faster: separate table for date dimension or date column? > If I go with date dimension table should I use date column as > a foreign key > in fact table or use some artificial key? > > TIA, > Alexandre > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alexandre Gorbatchev > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Alexandre Gorbatchev > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > * This e-mail message, and any f
RE: Warehouse design: snowflake vs star schemas
No no - it wasn't to do with the specifics of snowstorms or cosmic radiation, rather a further discussion of the issues of database design, which ultimately has to be the reference point in any discussion of star schemas etc. peter > -Original Message- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > Sent: 14 October 2002 15:09 > To: Multiple recipients of list ORACLE-L > Subject: RE: Warehouse design: snowflake vs star schemas > > > Peter - What does this article have to do with snowflake vs. > star schema? I > didn't see where Chris Date was advocating snowflaking. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Monday, October 14, 2002 4:59 AM > To: Multiple recipients of list ORACLE-L > > > Just for the record (and perhaps to confirm that there are > always two sides > to a story). Readers may like to see the article Chris Date > wrote to Ralph > Kemball on the subject of business rules and integrity constraints: > > http://www.dbdebunk.com/kimball1.htm > > peter > edinburgh > > > > -Original Message- > > From: Alexandre Gorbatchev [mailto:[EMAIL PROTECTED]] > > Sent: 09 October 2002 15:04 > > To: Multiple recipients of list ORACLE-L > > Subject: RE: Warehouse design: snowflake vs star schemas > > > > > > Dennis, > > > > Thanks for the link. It's a great DW resource. > > There are not only fundamentals, but some valuable real-life > > stuff, which is > > what I need. Live and learn, learn,learn... > > > > Regards, > > Alex > > > > -Original Message- > > WILLIAMS > > Sent: Tuesday, October 08, 2002 7:39 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Alexandre > >Stephane gave you an excellent reply. If you want to learn > > more about > > these DW design issues, I would start by visiting > > http://www.ralphkimball.com. He is one of the leading figures > > in the DW > > field, and has copies of all his articles posted on his site. > > I would start > > with the oldest articles because those are where he discusses the > > fundamentals of data warehousing. > > > > > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Tuesday, October 08, 2002 3:29 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Stéphane, > > > > Thanks for response. > > > > > I have always discplined myself to use star schema and > > > never snowflake. > > Would you mind asking why? > > > > > The "Which one is easier to implement and easier ETL > > > ?" is not a good question as your data model should > > > not be design for the ETL procecess but only for the > > > querying. > > I mean ETL to load data _INTO_ data warehouse. Of course, > > complexity is > > mostly determined by sources, but still I'd like to know if > > there is any > > general influence by DW's data model. > > > > Another question. Is it feasible to make date dimension or > > just use date > > column? For example, Oracle Discoverer can work with date > > columns using > > hierarchies Y->M->D and similar. > > What is faster: separate table for date dimension or date column? > > If I go with date dimension table should I use date column as > > a foreign key > > in fact table or use some artificial key? > > > > TIA, > > Alexandre > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Alexandre Gorbatchev > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web > hosting services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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
