Re: parallel query performance
On Friday 08 June 2001 23:20, Stephane Faroult wrote: > > And why is Elbonia submitted to such restriction? Do they actively > support terrorism from militant ethnic Graecian groups in the Balkans? It's based on human rights violations. They encourage child labor and discriminate against molly-dookers. The British government however has been lobbying to have trade restrictions with Elbonia lifted. It seems that Elbonian mud can be used to stop the spread of hoof and mouth disease. Tony Blair has even gone on record as saying that it's vital to the nations economy. Most UN members however are still dissenting. Jared > Jared Still wrote: > > On Friday 08 June 2001 08:17, Mohan, Ross wrote: > > > pq slaves have special buffers in the large pool. > > > > > > I do not believe, however, that this is the ONLY > > > place they read from. > > > > > > Perhaps a Latvian web site has more details? > > > > No, but I did locate one in Elbonia. > > > > Since they have no diplomatic relations with > > any North American or European countries, they > > can get away with publishing anything you want. > > > > Shoot, they even burn Solaris and Oracle CD's and > > practically give the stuff away. > > > > Several software companies have added Elbonia to > > their list of countries that their software may > > not be exported to, due to their flagrant > > violations. > > > > Here's an example: > > > > http://www.gemstone.com/linux/license.htm > > > > Jared > > LOL. And why is Elbonia submitted to such restriction? Do they actively > support terrorism from militant ethnic Graecian groups in the Balkans? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dumn unix script question
Thanks Jared!
Off to find my first Perl Book :) I've seen on the list the things you do
with perl scripts, and have to say I'm always impressed..
Mark
-Original Message-
Sent: Friday, June 08, 2001 10:11
To: Multiple recipients of list ORACLE-L
Let me start off by saying that I like Java. I took a class
in it from Sun, and Java is easy. Learning the libs is hard
but the language is easy.
I'm going to say something now that may sound counter intuitive:
Learn Perl first. The reason it may seem counter intuitive is
that Perl is hard to learn, at least at first. Much easier if
you've had exposure to C though.
The reason for learning Perl is that there are many tasks that
are easy in Perl that are hard in Java. It's the same old balance:
with power comes complexity.
The basics of Perl aren't really *too* hard, just take a little
getting used to.
The payoff is big. There is no better language for data munging
than Perl. If you need to clean up data for SQL loader files,
use Perl. Don't try to do it with PL/SQL or Korn as it is just
too much work.
While SQL*Loader allows you to do some very complex things in it,
it is *very* difficult at times. Clean your data first.
Need to deal with a lot of text files, search for errors in log
files, etc., do it with Perl.
You will also be able to develop Perl code much faster than you
can develop Java code. Java is very wordy, Perl can be very
terse if you want or require.
Perl makes hard things easy, and impossible things possible. :)
see www.perl.com for articles, downloads and tutorials.
Good first books for the non-programmer are Learning Perl and/or
Learning Perl for Win32.
Jared
On Friday 08 June 2001 04:10, Mark Leith wrote:
> A quick question - I have VERY limited scripting experience - for
arguments
> sake, lets say - none:)
>
> Now, looking at the code below, and having started with java a short time
> ago to implement certain functions in to our web page, I have to say that
> they look similar in style.. Is the case? Could I learn one code
> intimatley - like java - and have a good head start when faced with
others?
>
> If so, which would you reccomend starting to REALLY learn? I'm thinking
> java myself, and have already started as mentioned, but wanted to get your
> invaluable knowledge..
>
> Cheers
>
> Dorothy "Red Shoes"
>
> -Original Message-
> Sent: Friday, June 08, 2001 01:46
> To: Multiple recipients of list ORACLE-L
>
>
>
> Well, you've got the right idea, just in the
> wrong order.
>
> The korn shell does not compile the whole script
> and then execute as say Perl does.
>
> It executes it a line at a time.
>
> So rearrange your script like so:
>
> ==
> #!/bin/ksh
>
> function quick_test {
> echo "hello"
> }
>
> echo "supposed to show hello below"
> quick_test
>
> ==
>
> and it will work.
>
> Might be a good idea to pick up a good Korn
> shell book. O'Reilly has one I believe.
>
> I like the one by Kochan and Wood, published
> by Hayden books.
>
>
> Jared
>
> On Thursday 07 June 2001 15:55, Janet Linsy wrote:
> > Hi all,
> >
> > This must be a really dumn question. :-<
> >
> > I have a script which doesn't work well, since it
> > doesn't recognize a subroutine. I compared my code
> > with other codes that work fine with sub function, and
> > didn't see any difference. (at least look the same
> > style to me.)
> >
> > So I wrote a really small scipt to test the sub:
> > ==
> > #!/bin/ksh
> >
> > echo "supposed to show hello below"
> > quick_test
> >
> > function quick_test {
> > echo "hello"
> > }
> > ==
> > after I run it, I got: 1[3]: quick_test: not found.
> >
> > The box is:
> > Machine hardware: sun4u
> > OS version: 5.6
> >
> > Don't know ksh version, how to know ksh version
> > really?
> >
> > Thanks!
> >
> > Janet
> >
> >
> > __
> > Do You Yahoo!?
> > Get personalized email addresses from Yahoo! Mail - only $35
> > a year! http://personal.mail.yahoo.com/
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San D
RE: whats new in oracle8.1.7
http://technet.oracle.com -Original Message- Sent: Friday, June 08, 2001 10:06 To: Multiple recipients of list ORACLE-L Hi from where can I get oracle8.1.7 new features?Any website except www.oracle.com Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT - Wrap-up of "Serious Question (believe it or not)..."
Rachel, Well, I didn't want to suggest you be the "bad girl" type right off the bat. What we can do is have you play two parts in the movie, one the "good angel" and one the "dark angel". That way, you can really bring out the best of both worlds. set director_talk on It's all about motivation. What motivates you? Yes, capture that and don't let go. set director_talk off Jim ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) ^ -Original Message- Carmichael Sent: Friday, June 08, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Jim, I promise to come see that movie! "do-good angel caught between Heaven and Hell" though? Darn it all, I thought I was more the "bad girl" type :) Rachel >From: "Jim Hawkins" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: OT - Wrap-up of "Serious Question (believe it or not)..." >Date: Fri, 08 Jun 2001 07:47:38 -0800 > >Well, we certainly had a fine discussion on this topic, and I thank all >those who responded and weighed in. All of your input was extremely >valuable to me (and others). > >Based on Rachel's and others' comments, I believe that I could not >*happily* >write a technical book at this point in my life (3 kids under age 4), so >I've decided to follow the other camp's suggestion. That's right, we're >going straight to the big screen. Join me in next year's Cannes Festival >in >southern France (yeah, they'll love an invasion of drunk Oracle DBA's). > >"Hidden Parameter, Crouching Developer - or How I Learned to Love the >Larry" >directed by Jim Hawkins. > >Starring (not in order of importance): >*Larry Ellison as God >*Bill "Shrek" Thater as The Enforcer (a gentle assassin with a >compassionate >heart) >*Ross Mohan as Hannibal (speedo-wearing cannibal) >*Rachel Carmichael as The Goddess (a do-good angel caught between Heaven >and >Hell) >*Jared Still as Charlie (the voice behind the chair) > >And anyone else that wants a part, just let me know. Haven't built a >story-line yet, but wht could possibly go wrong with this winning >combination film? > >But seriously, sorry about this post - it's Friday, I'm in a good mood, and >have my databases all running so well, that I could spend 15 minutes typing >this email. > >Virtual Guiness Stout to all on the list, compliments of my new film >company. > >Jim > >-- >Jim Hawkins >Lead SAPR/3 Oracle Database Administrator >MEMC Electronic Materials, Inc. >600 Pearl Drive >St. Louis, MO 633376 >9636) 474-7832 >[EMAIL PROTECTED] (work) >[EMAIL PROTECTED] (home) > > > 10% of GROSS sales? or net? I'd be really really surprised if it were > > gross. > > > > Figure that net sales on that @29.95 book is at most half that. > > > > And 10,000 copies? Hm, well, I'd bet someone like Steven Feuerstein or >Kevin > > Loney would sell that many, but not most authors. > > > > > > > > >From: Jared Still <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: Re: Re[2]: Serious Question (believe it or not)... > > >Date: Thu, 07 Jun 2001 18:55:22 -0800 > > > > > >On Thursday 07 June 2001 15:56, [EMAIL PROTECTED] wrote: > > > > > > > I think all the original poster was asking was ballpark figures. >ie; > > > > should a prospective author of an Oracle book expect to make around > > >$1,000, > > > > around $10,000, around $100,000, etc. No personal finances >involved. > > >Your > > > > mileage may vary, etc. > > > > > >100K?! > > > > > >In your dreams. Standard royalty rate for O'Reilly is 10%, which is > > >public knowledge as they publish it on their web site. > > > > > >If you sell 10,000 copies of a 29.95 book ( assuming they all sell > > >for the list price, which isn't likely ) and no returns, you will > > >gross $30K from the book. > > > > > >10,000 copies is probably optimistic. And if there are co-authors, > > >you will split the proceeds. > > > > > >Writing a technical book is in most cases a labor of love. > > > > > >There are exceptions, like 'SQL for Smarties' by Joe Celko, but > > >not many tech books sell that well. > > > > > >Jared > > >-- > > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > > >-- > > >Author: Jared Still > > > INET: [EMAIL PROTECTED] > > > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > >San Diego, California-- Public Internet access / Mailing Lists > > > > > >To REMOVE yourself from this mailing list, send an E-Mail message > > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > >the message BODY, include a line containing: UNSUB ORACLE-L > > >(or the name of mailing list you w
RE: OT - Wrap-up of 'Serious Question (believe it or not)...'
Yes, but this leads to virtual hang-over which is a very good thing... ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) ^ -Original Message- Aschenbrenner Sent: Friday, June 08, 2001 6:33 PM To: Multiple recipients of list ORACLE-L I think I've had too many virtual beers. I'm getting a virtual buzz Alan -Original Message- Sent: Friday, June 08, 2001 3:46 PM To: Multiple recipients of list ORACLE-L Always glad to spread some semi-on-topic humor on Fridays. It helps me out of the daily drone mode... By Monday, I'll be back to my serious, helpful, wannabe-guru self! Cheers, everyoneand another round of virtual Guiness on me! Jim > > Oh god Jim, this is the best laugh I have > had in days! > > Thank you, thank you, thank you! > > Jared ( still laughing ) > > On Friday 08 June 2001 08:47, Jim Hawkins wrote: > > > > > "Hidden Parameter, Crouching Developer - or How I Learned to Love the > > Larry" directed by Jim Hawkins. > > > > Starring (not in order of importance): > > *Larry Ellison as God > > *Bill "Shrek" Thater as The Enforcer (a gentle assassin with a > > compassionate heart) > > *Ross Mohan as Hannibal (speedo-wearing cannibal) > > *Rachel Carmichael as The Goddess (a do-good angel caught between Heaven > > and Hell) > > *Jared Still as Charlie (the voice behind the chair) > > > > And anyone else that wants a part, just let me know. Haven't built a > > story-line yet, but wht could possibly go wrong with this winning > > combination film? > > > > But seriously, sorry about this post - it's Friday, I'm in a good mood, and > > have my databases all running so well, that I could spend 15 minutes typing > > this email. > > > > Virtual Guiness Stout to all on the list, compliments of my new film > > company. > > > > Jim > > -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner 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: Hawkins Family 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: OT - Wrap-up of 'Serious Question (believe it or not)...'
Rachel, Well...umer..ah..maybe. You know, Martin Sheen was drunk during the filming of many scenes of Apocalypse Now. I just thought I would follow Coppola's lead and get all the actors/actresses drunk for a more free-flowing performance. Wait 'til I break out the virtual schnapps shots ;) Jim ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) ^ -Original Message- Carmichael Sent: Friday, June 08, 2001 8:20 PM To: Multiple recipients of list ORACLE-L Jim, Two rounds of Guiness? are you trying to get me drunk? :) Rachel >From: "Jim Hawkins" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: OT - Wrap-up of 'Serious Question (believe it or not)...' >Date: Fri, 08 Jun 2001 13:46:11 -0800 > >Always glad to spread some semi-on-topic humor on Fridays. It helps me out >of the daily drone mode... > >By Monday, I'll be back to my serious, helpful, wannabe-guru self! > >Cheers, everyoneand another round of virtual Guiness on me! > >Jim > > > > > > Oh god Jim, this is the best laugh I have > > had in days! > > > > Thank you, thank you, thank you! > > > > Jared ( still laughing ) > > > > On Friday 08 June 2001 08:47, Jim Hawkins wrote: > > > > > > > > "Hidden Parameter, Crouching Developer - or How I Learned to Love the > > > Larry" directed by Jim Hawkins. > > > > > > Starring (not in order of importance): > > > *Larry Ellison as God > > > *Bill "Shrek" Thater as The Enforcer (a gentle assassin with a > > > compassionate heart) > > > *Ross Mohan as Hannibal (speedo-wearing cannibal) > > > *Rachel Carmichael as The Goddess (a do-good angel caught between >Heaven > > > and Hell) > > > *Jared Still as Charlie (the voice behind the chair) > > > > > > And anyone else that wants a part, just let me know. Haven't built a > > > story-line yet, but wht could possibly go wrong with this winning > > > combination film? > > > > > > But seriously, sorry about this post - it's Friday, I'm in a good >mood, >and > > > have my databases all running so well, that I could spend 15 minutes >typing > > > this email. > > > > > > Virtual Guiness Stout to all on the list, compliments of my new film > > > company. > > > > > > Jim > > > > > > >-- >Jim Hawkins >Lead SAPR/3 Oracle Database Administrator >MEMC Electronic Materials, Inc. >600 Pearl Drive >St. Louis, MO 633376 >9636) 474-7832 >[EMAIL PROTECTED] (work) >[EMAIL PROTECTED] (home) > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jim Hawkins > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). _ 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: Hawkins Family 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).
Create Directory - Statemen
Hi all, Can anyone please tell me what is the use of the 'CREATE DIRECTORY' sql statement. Hope that it would be used on LOB datatype manipulations. Please enlighten me. Regards, Nirmal. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nirmal Kumar Muthu Kumaran 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: SID on sqlplus prompt?
If the db_name will do just as well you can use
sys_context('USERENV', 'DB_NAME') to obtain the database name and not have to
grant access to any of the v$ tables. There's also ora_database_name which is a
function that takes no arguments and returns . Both of these can
"selected from dual"
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 08, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
How about something like this? Of course, it requires that the user have
select access to v$instance -- maybe there's another place to find this.
You could do some sort of batch to reference the $ORACLE_SID instead, but
the advantage of this is you can put it into glogin.sql or login.sql -- or
maybe not. I just tried doing that and it didn't affect anything. Hmm.
Oh, well, this may help you...
set heading off
set term off
set feedback off
spool set_sqlprompt.lst
select 'set sqlprompt "' || instance_name || '> "'
from v$instance
/
spool off
@set_sqlprompt.lst
set heading on
set term on
set feedback on
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
Walter K
ahoo.com>cc:
Sent by: Fax to:
root@fatcity.Subject: SID on sqlplus prompt?
com
06/08/2001
04:35 PM
Please
respond to
ORACLE-L
Hi,
Is there a way to get the SID or database name
displayed in the command prompt of SQL*Plus? Can this
be generated dynamically if I perform a "CONNECT
/" ?
Thanks!
-w
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REM
Dedicated connections on MTS server
Hi, We have setup a MTS server on our oracle 8.0.5 database. The total number of >users is around 800 - 900. Eventough MTS configuration is working fine, we find around 200+ users getting connected to the database as DEDICATED users. According to me If the server is setup as MTS there should not be any dedicated connections going on to database. My question is Why my connetions to database are going as DEDICATED...? How do I make sure that all my connections to server are SHARED and not DEDICATED. I have checked my SQLNET.ORA, We do not have use_dedicated_server=on setup on any of the client machines. Please let me know if you have any answer for this. TIA, Dan _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aravind Tigadi 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: Create Directory - Statemen
Nirmal, Create directory command simply creates a database object,Client system directory path can't be given during its creation. it is used with LOB manipulation, DBMS_LOB package read and write operations are related to this directorty path given during creation. For more details, do check DBMS_LOB samples. HTH Azhar - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Saturday, June 09, 2001 8:27 PM > Hi all, > > Can anyone please tell me what is the use of the 'CREATE DIRECTORY' sql > statement. > > Hope that it would be used on LOB datatype manipulations. > > Please enlighten me. > > Regards, > Nirmal. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nirmal Kumar Muthu Kumaran > 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: Azhar Siddiq 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: Dedicated connections on MTS server
You enable MTS on the server and that method becomes the default connection method, but the final determination on whether shared or dedicated servers are used is controlled on the client side. If a client's tnsnames file has server=dedicated as part ofn the stanza for connecting to the database, the conenction is going to be a dedicated one. Ian MacGregor Stanford Linear Acclerator Center [EMAIL PROTECTED] -Original Message- Sent: Saturday, June 09, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hi, We have setup a MTS server on our oracle 8.0.5 database. The total number of >users is around 800 - 900. Eventough MTS configuration is working fine, we find around 200+ users getting connected to the database as DEDICATED users. According to me If the server is setup as MTS there should not be any dedicated connections going on to database. My question is Why my connetions to database are going as DEDICATED...? How do I make sure that all my connections to server are SHARED and not DEDICATED. I have checked my SQLNET.ORA, We do not have use_dedicated_server=on setup on any of the client machines. Please let me know if you have any answer for this. TIA, Dan _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Aravind Tigadi 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: MacGregor, Ian A. 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: Dedicated connections on MTS server
I'm fighting this same problem, but in reverse. I'm trying to get all my folks using DEDICATED connections. Simply put on my server the listener uses port 1521 for MTS/shared connections. It uses port1529 for DEDICATED connections. The TNSNAMES.ORA file on each client determines which port is used. If you simply & REALLY want to preclude your users from connecting as DEDICATED session, then simply remove that port from the listener.ora file & bounce the listener. If/when the listener no longer accepts connections for the dedicated port, all your users will be forced to use MTS. FWIW - When I switched from MTS to DEDICATED my nightly batch jobs went from 5 hours of run time to about ONE hour of runtime. HTH & YMMV! Aravind Tigadi wrote: > Hi, > > We have setup a MTS server on our oracle 8.0.5 database. The total number of > >users is around 800 - 900. > Eventough MTS configuration is working fine, we find around 200+ users > getting connected to the database as DEDICATED users. According to me If > the server is setup as MTS there should not be any dedicated > connections going on to database. > > My question is > > Why my connetions to database are going as DEDICATED...? > How do I make sure that all my connections to server are SHARED and not > DEDICATED. > > I have checked my SQLNET.ORA, We do not have use_dedicated_server=on setup > on any of the client machines. > > Please let me know if you have any answer for this. > > TIA, > > Dan > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Aravind Tigadi > 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: Charlie Mengler 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: OT - Wrap-up of 'Serious Question (believe it or not)...'
I'd forgotten all about thiswhat a delight to be reminded! -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/8/2001 7:27 PM Meet Ross and Mark (or other certifiable goofs) at the following for secret decoder ring training: http://images.burningman.com/gallery/bdamer.1524.jpg - http://images.burningman.com/gallery/quitob1.1435.jpg - http://www.burningman.com/first_timers/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
RE: SID on sqlplus prompt?
Neat! I knew there was some way of selecting that, but couldn't remember
it and also couldn't find them in the FM. Didn't someone complain about
the terrible indexes on Oracle manuals? Let me add my voice to that
particular clamor.
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
"MacGregor,
Ian A." To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED]cc:
nford.EDU> Fax to:
Sent by: Subject: RE: SID on sqlplus prompt?
root@fatcity.
com
06/09/2001
12:40 PM
Please
respond to
ORACLE-L
If the db_name will do just as well you can use
sys_context('USERENV', 'DB_NAME') to obtain the database name and not
have to grant access to any of the v$ tables. There's also
ora_database_name which is a function that takes no arguments and returns
. Both of these can "selected from dual"
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, June 08, 2001 2:30 PM
To: Multiple recipients of list ORACLE-L
How about something like this? Of course, it requires that the user have
select access to v$instance -- maybe there's another place to find this.
You could do some sort of batch to reference the $ORACLE_SID instead, but
the advantage of this is you can put it into glogin.sql or login.sql -- or
maybe not. I just tried doing that and it didn't affect anything. Hmm.
Oh, well, this may help you...
set heading off
set term off
set feedback off
spool set_sqlprompt.lst
select 'set sqlprompt "' || instance_name || '> "'
from v$instance
/
spool off
@set_sqlprompt.lst
set heading on
set term on
set feedback on
Diana Duncan
TITAN Technology Partners
One Copley Parkway, Ste 540
Morrisville, NC 27560
VM: 919.466.7337 x 316
F: 919.466.7427
E: [EMAIL PROTECTED]
Walter K
ahoo.com>cc:
Sent by: Fax to:
root@fatcity.Subject: SID on sqlplus
prompt?
com
06/08/2001
04:35 PM
Please
respond to
ORACLE-L
Hi,
Is there a way to get the SID or database name
displayed in the command prompt of SQL*Plus? Can this
be generated dynamically if I perform a "CONNECT
/" ?
Thanks!
-w
__
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Walter K
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other informati
OT: DBA 101 paper
Okay, since I protested when it was up without authorization, and the site owner did take it down, an authorized copy of the paper is now on the www.nyoug.org site. There is a link to the paper on the home page. Rachel _ 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).
RE: OT - Wrap-up of "Serious Question (believe it or not)..."
Jim, Gulp! What have I gotten myself into? Okay, none of you will believe this but I'm shy and get stage fright. Stop laughing! It's true Two roles, twice as much to memorize but I get to bring out the best and worst in me. Rachel >From: "Hawkins Family" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT - Wrap-up of "Serious Question (believe it or not)..." >Date: Sat, 09 Jun 2001 05:50:19 -0800 > >Rachel, > >Well, I didn't want to suggest you be the "bad girl" type right off the >bat. >What we can do is have you play two parts in the movie, one the "good >angel" >and one the "dark angel". That way, you can really bring out the best of >both worlds. > >set director_talk on > >It's all about motivation. What motivates you? Yes, capture that and >don't >let go. > >set director_talk off > >Jim > >^ >Jim Hawkins >Lead SAPR/3 Oracle Database Administrator >MEMC Electronic Materials, Inc. >501 Pearl Drive >St. Louis, MO 63376 >(636) 474-7832 >[EMAIL PROTECTED] (work) >[EMAIL PROTECTED] (personal) >^ > >-Original Message- >Carmichael >Sent: Friday, June 08, 2001 2:16 PM >To: Multiple recipients of list ORACLE-L > > >Jim, > >I promise to come see that movie! "do-good angel caught between Heaven and >Hell" though? Darn it all, I thought I was more the "bad girl" type :) > >Rachel > > > >From: "Jim Hawkins" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: OT - Wrap-up of "Serious Question (believe it or not)..." > >Date: Fri, 08 Jun 2001 07:47:38 -0800 > > > >Well, we certainly had a fine discussion on this topic, and I thank all > >those who responded and weighed in. All of your input was extremely > >valuable to me (and others). > > > >Based on Rachel's and others' comments, I believe that I could not > >*happily* > >write a technical book at this point in my life (3 kids under age 4), so > >I've decided to follow the other camp's suggestion. That's right, we're > >going straight to the big screen. Join me in next year's Cannes Festival > >in > >southern France (yeah, they'll love an invasion of drunk Oracle DBA's). > > > >"Hidden Parameter, Crouching Developer - or How I Learned to Love the > >Larry" > >directed by Jim Hawkins. > > > >Starring (not in order of importance): > >*Larry Ellison as God > >*Bill "Shrek" Thater as The Enforcer (a gentle assassin with a > >compassionate > >heart) > >*Ross Mohan as Hannibal (speedo-wearing cannibal) > >*Rachel Carmichael as The Goddess (a do-good angel caught between Heaven > >and > >Hell) > >*Jared Still as Charlie (the voice behind the chair) > > > >And anyone else that wants a part, just let me know. Haven't built a > >story-line yet, but wht could possibly go wrong with this winning > >combination film? > > > >But seriously, sorry about this post - it's Friday, I'm in a good mood, >and > >have my databases all running so well, that I could spend 15 minutes >typing > >this email. > > > >Virtual Guiness Stout to all on the list, compliments of my new film > >company. > > > >Jim > > > >-- > >Jim Hawkins > >Lead SAPR/3 Oracle Database Administrator > >MEMC Electronic Materials, Inc. > >600 Pearl Drive > >St. Louis, MO 633376 > >9636) 474-7832 > >[EMAIL PROTECTED] (work) > >[EMAIL PROTECTED] (home) > > > > > 10% of GROSS sales? or net? I'd be really really surprised if it were > > > gross. > > > > > > Figure that net sales on that @29.95 book is at most half that. > > > > > > And 10,000 copies? Hm, well, I'd bet someone like Steven Feuerstein or > >Kevin > > > Loney would sell that many, but not most authors. > > > > > > > > > > > > >From: Jared Still <[EMAIL PROTECTED]> > > > >Reply-To: [EMAIL PROTECTED] > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > >Subject: Re: Re[2]: Serious Question (believe it or not)... > > > >Date: Thu, 07 Jun 2001 18:55:22 -0800 > > > > > > > >On Thursday 07 June 2001 15:56, [EMAIL PROTECTED] wrote: > > > > > > > > > I think all the original poster was asking was ballpark figures. > >ie; > > > > > should a prospective author of an Oracle book expect to make >around > > > >$1,000, > > > > > around $10,000, around $100,000, etc. No personal finances > >involved. > > > >Your > > > > > mileage may vary, etc. > > > > > > > >100K?! > > > > > > > >In your dreams. Standard royalty rate for O'Reilly is 10%, which is > > > >public knowledge as they publish it on their web site. > > > > > > > >If you sell 10,000 copies of a 29.95 book ( assuming they all sell > > > >for the list price, which isn't likely ) and no returns, you will > > > >gross $30K from the book. > > > > > > > >10,000 copies is probably optimistic. And if there are co-authors, > > > >you will split the proceeds. > > > > > > > >Writing a technical book is in most cases a labor of love. > > > >
RE: OT - Wrap-up of 'Serious Question (believe it or not)...'
Jim, trust me, you'll need the alcohol to persuade the bad Rachel to come out. I hadn't realized Martin Sheen was drink during Apocalyse Now. New fact for the day. Rachel >From: "Hawkins Family" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT - Wrap-up of 'Serious Question (believe it or not)...' >Date: Sat, 09 Jun 2001 06:05:22 -0800 > >Rachel, > >Well...umer..ah..maybe. > >You know, Martin Sheen was drunk during the filming of many scenes of >Apocalypse Now. I just thought I would follow Coppola's lead and get all >the actors/actresses drunk for a more free-flowing performance. > >Wait 'til I break out the virtual schnapps shots ;) > >Jim > >^ >Jim Hawkins >Lead SAPR/3 Oracle Database Administrator >MEMC Electronic Materials, Inc. >501 Pearl Drive >St. Louis, MO 63376 >(636) 474-7832 >[EMAIL PROTECTED] (work) >[EMAIL PROTECTED] (personal) >^ > >-Original Message- >Carmichael >Sent: Friday, June 08, 2001 8:20 PM >To: Multiple recipients of list ORACLE-L > > >Jim, > >Two rounds of Guiness? are you trying to get me drunk? :) > >Rachel > > > >From: "Jim Hawkins" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: OT - Wrap-up of 'Serious Question (believe it or not)...' > >Date: Fri, 08 Jun 2001 13:46:11 -0800 > > > >Always glad to spread some semi-on-topic humor on Fridays. It helps me >out > >of the daily drone mode... > > > >By Monday, I'll be back to my serious, helpful, wannabe-guru self! > > > >Cheers, everyoneand another round of virtual Guiness on me! > > > >Jim > > > > > > > > > > Oh god Jim, this is the best laugh I have > > > had in days! > > > > > > Thank you, thank you, thank you! > > > > > > Jared ( still laughing ) > > > > > > On Friday 08 June 2001 08:47, Jim Hawkins wrote: > > > > > > > > > > > "Hidden Parameter, Crouching Developer - or How I Learned to Love >the > > > > Larry" directed by Jim Hawkins. > > > > > > > > Starring (not in order of importance): > > > > *Larry Ellison as God > > > > *Bill "Shrek" Thater as The Enforcer (a gentle assassin with a > > > > compassionate heart) > > > > *Ross Mohan as Hannibal (speedo-wearing cannibal) > > > > *Rachel Carmichael as The Goddess (a do-good angel caught between > >Heaven > > > > and Hell) > > > > *Jared Still as Charlie (the voice behind the chair) > > > > > > > > And anyone else that wants a part, just let me know. Haven't built >a > > > > story-line yet, but wht could possibly go wrong with this winning > > > > combination film? > > > > > > > > But seriously, sorry about this post - it's Friday, I'm in a good > >mood, > >and > > > > have my databases all running so well, that I could spend 15 minutes > >typing > > > > this email. > > > > > > > > Virtual Guiness Stout to all on the list, compliments of my new film > > > > company. > > > > > > > > Jim > > > > > > > > > > > >-- > >Jim Hawkins > >Lead SAPR/3 Oracle Database Administrator > >MEMC Electronic Materials, Inc. > >600 Pearl Drive > >St. Louis, MO 633376 > >9636) 474-7832 > >[EMAIL PROTECTED] (work) > >[EMAIL PROTECTED] (home) > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Jim Hawkins > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > > > >To REMOVE yourself from this mailing list, send an E-Mail message > >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > >the message BODY, include a line containing: UNSUB ORACLE-L > >(or the name of mailing list you want to be removed from). You may > >also send the HELP command for other information (like subscribing). > >_ >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: Hawkins Family > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, Cal
Crystal Reports 7 on 8i client fix?
This issue is about a year old so I wonder if anyone knew of a fix. Crystal 7 will not work with an 8i client. Some people have indicated that ODBC works ok this way, but we are using Oracle native drivers, p2sora7.dll or something. Here's a link on the subject http://support.seagatesoftware.com/library/kbase/articles/c2003786.asp Anyone know of a resolution other than switching to ODBC or upgrading to Crystal 8? Thanks, D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C 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: OT - Wrap-up of 'Serious Question (believe it or not)...'
Hi Jim, I have an idea for a book. I don´t know if it has been written before , but I think that it would be very useful to a lot of people. Oracle High Availability: - Recovery scenarios (The author could put scripts to backup archive logs , tips about archiving , recovering , how Oracle process instance recovery , case studies , etc...); - Stand-by Databases (concepts , implementations , pitfalls , etc...); - OPS (concepts , implementations , pitfalls , etc...); - Replication (as a tool to keep another database in sync with production databases); - Hardware concepts (redundancy , RAID controllers , clusters , SANs , etc...); - Tips & Techniques for a 24 x 7 x 365 environment (administration , online backups , archiving , change manegement , etc...); - It could have a chapter with an overview or introduction about Oracle 9i Real Application Clusters. Of course , someone would ask "Why don´t you write it yourself ??". 1st : I have a 1-year old baby to take care , and I can´t let all the duties ( and happiness :- ) to my wife; 2nd : I take care of 15 databases on my daily job and none of them is 24 x 7 x 365. So , I don´t feel comfortable to write about the matter; 3rd : My English isn´t good. If is there a book similar , sorry about the waste of time , and , please , could you give me the name of this book ?? Regards, Antonio Belloni "Hawkins Family" <[EMAIL PROTECTED]>@fatcity.com on 09/06/2001 11:05:21 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Yes, but this leads to virtual hang-over which is a very good thing... ^ Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 501 Pearl Drive St. Louis, MO 63376 (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) ^ -Original Message- Aschenbrenner Sent: Friday, June 08, 2001 6:33 PM To: Multiple recipients of list ORACLE-L I think I've had too many virtual beers. I'm getting a virtual buzz Alan -Original Message- Sent: Friday, June 08, 2001 3:46 PM To: Multiple recipients of list ORACLE-L Always glad to spread some semi-on-topic humor on Fridays. It helps me out of the daily drone mode... By Monday, I'll be back to my serious, helpful, wannabe-guru self! Cheers, everyoneand another round of virtual Guiness on me! Jim > > Oh god Jim, this is the best laugh I have > had in days! > > Thank you, thank you, thank you! > > Jared ( still laughing ) > > On Friday 08 June 2001 08:47, Jim Hawkins wrote: > > > > > "Hidden Parameter, Crouching Developer - or How I Learned to Love the > > Larry" directed by Jim Hawkins. > > > > Starring (not in order of importance): > > *Larry Ellison as God > > *Bill "Shrek" Thater as The Enforcer (a gentle assassin with a > > compassionate heart) > > *Ross Mohan as Hannibal (speedo-wearing cannibal) > > *Rachel Carmichael as The Goddess (a do-good angel caught between Heaven > > and Hell) > > *Jared Still as Charlie (the voice behind the chair) > > > > And anyone else that wants a part, just let me know. Haven't built a > > story-line yet, but wht could possibly go wrong with this winning > > combination film? > > > > But seriously, sorry about this post - it's Friday, I'm in a good mood, and > > have my databases all running so well, that I could spend 15 minutes typing > > this email. > > > > Virtual Guiness Stout to all on the list, compliments of my new film > > company. > > > > Jim > > -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Aschenbrenner 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 wa
WAS: Re: OT - Wrap-up of 'Serious Question ' - now book idea - high
[EMAIL PROTECTED] wrote: > > Hi Jim, > > I have an idea for a book. I don´t know if it has been written before , but > I think that it would be very useful to a lot of people. > > Oracle High Availability: > - Recovery scenarios (The author could put scripts to backup archive logs , > tips about archiving , recovering , how Oracle process instance recovery , > case studies , etc...); > - Stand-by Databases (concepts , implementations , pitfalls , etc...); > - OPS (concepts , implementations , pitfalls , etc...); > - Replication (as a tool to keep another database in sync with production > databases); > - Hardware concepts (redundancy , RAID controllers , clusters , SANs , > etc...); > - Tips & Techniques for a 24 x 7 x 365 environment (administration , online > backups , archiving , change manegement , etc...); > - It could have a chapter with an overview or introduction about Oracle 9i > Real Application Clusters. > > If is there a book similar , sorry about the waste of time , and , please , > could you give me the name of this book ?? > > Regards, > Antonio Belloni > Antonio, A book covering some of this material already exists: Oracle 24x7 Tips & Techniques http://www.osborne.com/oracle/index.html http://www.bookpool.com/.x/sshhpzr290/sm/0072119993 I'm not making a recommendation either way - I read the book some time ago, and thought it was good, but that was many books ago. My standards are likely to have risen - then again - I might get alot more out of it the second time thru. Chapter 19 is available online at the osborne site - "Builing a Real-World Arsenal". A book covering some of the Backup and Recovery material would be Oracle 8i Backup and Recovery Handbook - Velpuri - which has no less than 22 case studies listed. (Just don't expect to get any good NT backup scripts there). In general, your best bet is to stick to the papers published in this area - as you are much more likely to find individual topics discussed in a white paper format that are recent enough to be useful. So much high-avail material is platform-dependent - it would be difficult to assemble something across all platforms - and fit it into a single book. Tim Gorman's paper on High-Avail - http://www.evergreen-database.com/TD_HA.pdf You ask about: > - It could have a chapter with an overview or introduction about Oracle 9i > Real Application Clusters. I would suggest visiting the IOUG.org site. Here is one paper as an example - #114 "An Introductiono to High Availability Solutions" by Brian McGraw Okay - its only introductory - but you have to start somewhere. (no surprise here) - I would also recommend searching Metalink http://metalink.oracle.com/ here are some examples from the Technical Library for high avail Failover Issues and Limitations [Connect-time failover and TAF] 97926.1 8.0.x-8.1.x: Sample config for Transparent Application 69745.1 Dead Connection Detection Explained 2061476.6 Do you want someone to simply re-use the Oracle Documentation on the subject, or get advice from someone that has actually used the product? It seems to me that you won't see a book on such things until 12 months after it has been released - while you might see individual papers out much sooner. You'll just have to do a bit of searching on your own to find the info. (no surprise here) - I would also recommend searching Technet there is a section called "Oracle Real Application Clusters" at http://otn.oracle.com/products/oracle9i/content.html including: Managing Oracle9i Real Application Clusters Building Highly Available Database Servers Using Oracle Real Application Clusters Oracle9i Real Application Clusters, Cache Fusion Delivers Scalability that would certainly be a start. hth, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9i V$VERSION and changes to the system views for 9i
Hello, I have not yet tried my OCI based application on 9i (currently downloading...). I'm curious about the V$VERSION string that will be returned for 9i - I'm assuming that it will return something like: "Oracle9i Enterprise Edition Release 9.0.6.0.0 - Production" Can anyone confirm for me what is returned from "select * from v$version;"? As long as it starts with "Oracle9i" or something similar I'll be happy. Also - can anyone out there who has tried 9i give me a heads up on how significantly any of the existing system views/tables have been changed? I'm not concerned about new tables/views, or new columns in tables. I would be concerned about any views that were removed or columns that were dropped (hopefully there aren't any) over 8i. The primary one's I'm using are: V$VERSION, V$ARCHIVE_DEST, V$BGPROCESS, V$CONTROLFILE, V$DATABASE, V$INSTANCE, V$LOG, V$LOGFILE, V$NLS_PARAMETERS, V$OPTION, V$PARAMETER, V$SGA, V$VERSION, DBA_PROFILES, DBA_ROLE_PRIVS, DBA_ROLES, DBA_ROLLBACK_SEGS, DBA_SYS_PRIVS, DBA_TAB_PRIVS, DBA_TABLESPACES, DBA_USERS. Has anyone seen this documented anywhere - changes to the data dictionary in 9i? Thanks Joe Sanderson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Sanderson 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: OT - Wrap-up of 'Serious Question (believe it or not)...'
Antonio, There isn't one book that covers all those topics, and for good reason. If written properly -- lots of detailed information and scripts, and explanations of the scripts (so that you feel comfortable to modify them on your own) -- this book is thousands of pages. Unwritable, unreadable and unaffordable. BUT... much of this is covered either in books already in existence or in the process of being written. Rachel >From: [EMAIL PROTECTED] >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT - Wrap-up of 'Serious Question (believe it or not)...' >Date: Sat, 09 Jun 2001 15:50:19 -0800 > > >Hi Jim, > >I have an idea for a book. I don´t know if it has been written before , but >I think that it would be very useful to a lot of people. > >Oracle High Availability: >- Recovery scenarios (The author could put scripts to backup archive logs , >tips about archiving , recovering , how Oracle process instance recovery , >case studies , etc...); >- Stand-by Databases (concepts , implementations , pitfalls , etc...); >- OPS (concepts , implementations , pitfalls , etc...); >- Replication (as a tool to keep another database in sync with production >databases); >- Hardware concepts (redundancy , RAID controllers , clusters , SANs , >etc...); >- Tips & Techniques for a 24 x 7 x 365 environment (administration , online >backups , archiving , change manegement , etc...); >- It could have a chapter with an overview or introduction about Oracle 9i >Real Application Clusters. > >Of course , someone would ask "Why don´t you write it yourself ??". > >1st : I have a 1-year old baby to take care , and I can´t let all the >duties ( and happiness :- ) to my wife; >2nd : I take care of 15 databases on my daily job and none of them is 24 x >7 x 365. So , I don´t feel comfortable to write about the matter; >3rd : My English isn´t good. > >If is there a book similar , sorry about the waste of time , and , please , >could you give me the name of this book ?? > >Regards, >Antonio Belloni > > > > >"Hawkins Family" <[EMAIL PROTECTED]>@fatcity.com on 09/06/2001 11:05:21 > >Please respond to [EMAIL PROTECTED] > >Sent by: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >cc: > > > >Yes, but this leads to virtual hang-over which is a very good thing... > >^ >Jim Hawkins >Lead SAPR/3 Oracle Database Administrator >MEMC Electronic Materials, Inc. >501 Pearl Drive >St. Louis, MO 63376 >(636) 474-7832 >[EMAIL PROTECTED] (work) >[EMAIL PROTECTED] (personal) >^ > >-Original Message- >Aschenbrenner >Sent: Friday, June 08, 2001 6:33 PM >To: Multiple recipients of list ORACLE-L > > >I think I've had too many virtual beers. I'm getting a virtual buzz > >Alan > >-Original Message- >Sent: Friday, June 08, 2001 3:46 PM >To: Multiple recipients of list ORACLE-L > > >Always glad to spread some semi-on-topic humor on Fridays. It helps me >out >of the daily drone mode... > >By Monday, I'll be back to my serious, helpful, wannabe-guru self! > >Cheers, everyoneand another round of virtual Guiness on me! > >Jim > > > > > > Oh god Jim, this is the best laugh I have > > had in days! > > > > Thank you, thank you, thank you! > > > > Jared ( still laughing ) > > > > On Friday 08 June 2001 08:47, Jim Hawkins wrote: > > > > > > > > "Hidden Parameter, Crouching Developer - or How I Learned to Love >the > > > Larry" directed by Jim Hawkins. > > > > > > Starring (not in order of importance): > > > *Larry Ellison as God > > > *Bill "Shrek" Thater as The Enforcer (a gentle assassin with a > > > compassionate heart) > > > *Ross Mohan as Hannibal (speedo-wearing cannibal) > > > *Rachel Carmichael as The Goddess (a do-good angel caught between >Heaven > > > and Hell) > > > *Jared Still as Charlie (the voice behind the chair) > > > > > > And anyone else that wants a part, just let me know. Haven't built >a > > > story-line yet, but wht could possibly go wrong with this winning > > > combination film? > > > > > > But seriously, sorry about this post - it's Friday, I'm in a good >mood, >and > > > have my databases all running so well, that I could spend 15 minutes > >typing > > > this email. > > > > > > Virtual Guiness Stout to all on the list, compliments of my new film > > > company. > > > > > > Jim > > > > > > >-- >Jim Hawkins >Lead SAPR/3 Oracle Database Administrator >MEMC Electronic Materials, Inc. >600 Pearl Drive >St. Louis, MO 633376 >9636) 474-7832 >[EMAIL PROTECTED] (work) >[EMAIL PROTECTED] (home) > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Jim Hawkins > INET: [EMAIL PROTECTED] > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California-- Public Internet access / Mailing Lists > >To REMOVE yourself from thi
