Re: Data Conversion procedural
I think I forgot to take my happy pills today. Raymond, What possible input could you be looking for here? Have you designed the database? If not, start there. That requires some business process analysis. When you've designed the DB, you'll know what data elements you need to get out of the old system to populate the new. How you transfer the data depends on a variety of factors, none of which you've mentioned (except you're putting the old system into Oracle). If you're not looking to create and populate a database, are you trying to recreate the functionality? That requires some business process analysis (I sense a theme emerging here). Once that's done, the rest is merely hard. Folks here can (I'm convinced) do just about anything (including metaphysical database administration) and will help you with everything from design questions and administration pointers, to coding tips. But you've got to be just a wee bit more specific. Have fun. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 RAYMOND ro.com.my> cc: Sent by: Subject: Re: Data Conversion procedural [EMAIL PROTECTED] om 03/26/2002 08:23 PM Please respond to ORACLE-L Hi Friend Currently I'm going to do a conversion for our client to convert their system into our Oracle 8i Db.. I have prepare the package/function/procedure... and some of those script for the system. Did you all have any conversion checklist for the purpose ?? Should I do a benchmarking first ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAYMOND 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).
Mutation effect for Inserts
>From a table's pre insert trigger we are inserting to the same table (thru a procedure). But the recursive effect is stopped by using some logic (i.e. The second record is put only if the :NEW.status equals something. In the second insert, the record is put with a different 'status'. ). Is this ok ? I checked the docs it said upto 32 it is ok and depends on MAX_OPEN_CURSORS also. But when I update an existing record and expect to see the second record inserted I get the table is mutating error message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe 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: CASE under Oracle8i
Larry, that's brilliant. That solution hadn't occurred to me. On Sun, 24 Mar 2002 20:53:19 -0800, Larry Elkins wrote: > >The easy way around it is to use Native Dynamic SQL. > > 1 DECLARE > 2 dual_message VARCHAR2(20); > 3 BEGIN > 4 Execute Immediate > 5 'SELECT CASE > 6 WHEN DUMMY=''X'' THEN ''Dual is OK'' > 7 ELSE ''Dual is messed up'' > 8 END > 9 FROM DUAL' into dual_message; > 10 DBMS_OUTPUT.PUT_LINE(dual_message); > 11* END; >SQL> / >Dual is OK > >PL/SQL procedure successfully completed. Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7 LMTs Autoallocate vs Uniform Extents
I heard of it some place. that is try to have three different tablespaces. One for large table, one for medium size table and third for small tables. Each of these tablespaces can have their own extent sizes. Large having large extent size. Medium can have medium size extents and same for small tablespace. Each tablespace can still have uniform extent size. So depending on the table size you can choose which tablespace they will go in and thus save yourself from over allocating the space. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Sundeep > Oops, egg on my face. Reading too fast, seeing one word and thinking > another. My understanding from "Stop Defragmenting and Start Living" > was > that uniform extents was the direction Oracle was heading. The > problem with > autoallocate is that you can end up with fragmented tablespaces and > therefore have to reorganize them from time to time. You end up with > free > spaces of varying sizes. With uniform extents you can't have > fragmentation > because all the extents are exactly the same size. The down side is > that > you may waste a bit more space because a small table may have more > space > allocated than it needs. Also you must get beyond the myth that a > good table > is all in one extent. Based on the above, I opted for uniform extents > and > have been pleased with the results. However, if someone has some > strong > arguments for autoallocate, I would be interested in hearing them. > Hopefully > this time I have responded to your question. Let me know. > > I went to http://www.google.com and searched for Oracle Autoallocate. > Here > is a link I found: > > http://www.jlcomp.demon.co.uk/ch_08.html > With autoallocate tablespaces, you may get a fairly random scattering > of > 64K, 1MB, 8MB or 64MB depending on the demand and the current state > of the > tablespace. > > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, March 26, 2002 2:46 PM > To: Multiple recipients of list ORACLE-L > > > Dennis, > > I mentioned Autoallocate and not autoextend. I have > been using LMTs for over a year now but only with > UNIFORM extent sizes. I am not sure if I am ready to > handover space management to Oracle (via Autoallocate > which is being foisted upon me as a panecea of all > ills) least I have evaluated the pros and cons. The > stuff in Manual and technet I have reveiwed so far > doesn't give you enough information like how much > space is wated in Autoallocate vs Uniform extent > sizes. How does Oracle decide to allocate an extent > for an Insert or an Update in Autoallocate option and > how does it decide on the extent size? > > So far I have looked at SQLRef, Concepts manual and > technet. Any other pointers? > > TIA > Sundeep > > > > --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > > Sundeep - Start by reading the classic paper "How to > > Stop Defragmenting and > > Start Living" at this link: > > > http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm > > > > Actually, autoallocate and uniform extents work very > > well together. But you > > need to understand the concepts behind them first. > > And make sure your > > application doesn't use up all your disk space if > > you autoallocate. > > Dennis Williams > > DBA > > Lifetouch, Inc. > > [EMAIL PROTECTED] > > > > > > -Original Message- > > Sent: Tuesday, March 26, 2002 12:54 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Can someone point me to good reading material on > > this > > subject. Is one better than the other for > > performance > > and manageability? > > > > Syntactically the autoallocate is shorter and seems > > to > > be more hands off (does that mean worry free also?). > > > > > > > > TIA > > > > > > = > > > > Sundeep Maini > > Consultant > > Currently on Assignement at Marshfield Clinic WI > > [EMAIL PROTECTED] > > > > __ > > Do You Yahoo!? > > Yahoo! Movies - coverage of the 74th Academy Awards® > > http://movies.yahoo.com/ > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: sundeep maini > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: > > (858) 538-5051 > > San Diego, California-- Public Internet > > access / Mailing Lists > > > > > To REMOVE yourself from this mailing list, send an > > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: DENNIS WILLIAMS > > INET: [EMAIL PROTECTED] > > > > Fat City Network S
RE: STATSPACK
First it seems like you want to understand the report. The report does have some comments on the top of the page, what to expect. However, if you can buy the book that Dennis suggested, you will get additional information on how to interpret the report. The book also provides many scripts that generate reports as well as comments in the report. I found the book and especially the scripts real worth while. As far as writing you own query, you could use the scripts provided with Statspack and the book as a baseline and get your own canned reports. I have used scripts that I have collected over many years. Statspack collects relevant data, organizes data in a nice way and stores the data for you. The scripts and information in the book give you additional stuff that is not covered in the book. I hope this helps you in making the decision. --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Reddy - I assume that you mean that you ran the statsrep.sql and > printed the > report. Is your question about interpreting this report? There is a > good > series of articles at > http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html > > Or is your question how to write your own queries? If that is the > question, > I would recommend that you invest in the book "Oracle > High-Performance > Tuning with STATSPACK" by Don Burleson, available at your local > bookstore. > Don offers some articles on-line at > http://www.dba-oracle.com/articles.htm > > Let me know if that is the information that you want. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, March 26, 2002 3:00 PM > To: Multiple recipients of list ORACLE-L > > > Hello ALL, > I have set up the statspack on Oracle 8.1.7 and just now I also got > the > REPORT , but poor me unable to understand that . Can anybody help me > out in > this ... Well I know www.oraperf.com will do it for me by sending a > report , > but I want to do it myself by writing some queries ... would anybody > help me > with some white paper. > > Thanks In advance, > Madhu > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Reddy, Madhusudana > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Conversion procedural
Hi Friend Currently I'm going to do a conversion for our client to convert their system into our Oracle 8i Db.. I have prepare the package/function/procedure... and some of those script for the system. Did you all have any conversion checklist for the purpose ?? Should I do a benchmarking first ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: RAYMOND 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 HRMS Applications -> Cannot view concurrent request ou
Hi Gurus, The problem has been resolved. Not enough disk space in the /var/tmp directory. Regds, ChorLing -Original Message- From: CHAN Chor Ling Catherine (CSC) Sent: Tuesday, March 26, 2002 10:23 PM To: Multiple recipients of list ORACLE-L Subject:OT: Oracle HRMS Applications -> Cannot view concurrent request ou Hi Gurus, We encountered the error "FS-CANT OPEN TMPFILE" when we tried to view the concurrent request report. Yesterday, we can view any report but not today. The only thing that's different is that we run the "purge obselete workflow runtime data" concurrent program this morning but it should not affect the view of report, right ? Please help. Thanks. Desperate DBA :( -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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: CHAN Chor Ling Catherine (CSC) 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: Customize my SQLPlus login
So Dave, was your question answered? ;) Jared "Farnsworth, Dave" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/26/02 09:30 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Customize my SQLPlus login Got it and now it works fine. Thanks everyone. Dave -Original Message- Sent: Tuesday, March 26, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Put a carriage return at the end of the last line. "Farnsworth, Dave" wrote: > > I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; > > Connected to: > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > With the Partitioning option > JServer Release 8.1.7.0.0 - Production > > Input truncated to 13 characters > SQL> show pagesize > pagesize 250 > > I can see that my changes took place but what is the "Input truncated to 13 characters" about?? > > Thanks, > > Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis M. Heisler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: OT: Funniest line in the manual.
Actually, when you think about this for a moment, it's not such a bad idea.
The format below would need some improvement but WTF. I bet it ends up
being an Oracle 9i release 'n' feature.
where use_nested{A.col1 = B.col1, taba_pk, tabb_pk}
where use_bitmap{A.sex = 'M', taba_bdx}
I'll bet 90% of Oracle's new features started out as an "I Wish" in
somebodies head at 3 in the morning.
Brian P. MacLean
Oracle DBA, OCP8i
Connor
McDonald To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
Subject: Re: OT: Funniest line in the
manual.
Sent by:
[EMAIL PROTECTED]
om
03/26/02 03:45
PM
Please respond
to ORACLE-L
You mean all this time my hints like the following:
select *
from table
where /*+ LET_ME_CHOOSE_THE_ORDER */
/*+ DO_ME_FIRST */ col1 = 12 and
/*+ NOT_ME_YET */ col2 = 13 and
/*+ WHEN_YOU_GET_A_MOMENT_TRY_ME */ col3 = 14
isn't going to work ?
:-)
--- Jonathan Lewis <[EMAIL PROTECTED]>
wrote: >
> Do you have a favourite (or favorite) joke in the
> Oracle manuals. I've been reading the Oracle 9
> SQL reference manual - as one does from time
> to time - and spotted this gem on p. 2-97:
>
>
> /*+ ordered_predicates */
> Use this hint in the WHERE clause of SELECT
> statements.
>
>
> Can I propose this one for urban legend status
> for 2004 ?
>
>
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
>
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Jonathan Lewis
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California-- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
=
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
__
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Pleas
STATSPACK
Hello ALL, I have set up the statspack on Oracle 8.1.7 and just now I also got the REPORT , but poor me unable to understand that . Can anybody help me out in this ... Well I know www.oraperf.com will do it for me by sending a report , but I want to do it myself by writing some queries ... would anybody help me with some white paper. Thanks In advance, Madhu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: Customize my SQLPlus login
One thing no-one seemed to have mentioned is that login.sql is only processed once. A workaround to this is to have some extra files: connect.sql === conn &1 @login.sql conn.sql (same as above) Then you can use: SQL> @conn system/manager system@DEMO> hth connor --- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote: > What is the file that I need to edit on my client PC > to set personalized settings for SQLPlus so that I > do not have to set these at the command prompt every > time I start a new session? > > Thanks, > > Dave > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Funniest line in the manual.
You mean all this time my hints like the following: select * from table where /*+ LET_ME_CHOOSE_THE_ORDER */ /*+ DO_ME_FIRST */ col1 = 12 and /*+ NOT_ME_YET */ col2 = 13 and /*+ WHEN_YOU_GET_A_MOMENT_TRY_ME */ col3 = 14 isn't going to work ? :-) --- Jonathan Lewis <[EMAIL PROTECTED]> wrote: > > Do you have a favourite (or favorite) joke in the > Oracle manuals. I've been reading the Oracle 9 > SQL reference manual - as one does from time > to time - and spotted this gem on p. 2-97: > > > /*+ ordered_predicates */ > Use this hint in the WHERE clause of SELECT > statements. > > > Can I propose this one for urban legend status > for 2004 ? > > > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Next Seminar - UK, April 3rd - 5th > http://www.jlcomp.demon.co.uk/seminar.html > > Host to The Co-Operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > Author of: > Practical Oracle 8i: Building Efficient Databases > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Jonathan Lewis > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Loader-282: Unable to locate character set handle for
seems like You are loading data from one version of database to the other version , try to use the version compatible tool like sqlldr80, sqlldr73. sqlload. I guess this may be your problem -Original Message- Sent: Tuesday, March 26, 2002 4:30 PM To: Multiple recipients of list ORACLE-L charact I am trying to load data from a 8.1.7 SQL Loader session to a 7.3.4 database. I am getting a SQL*Loader-282: Unable to locate character set handle for character set ID (0). error message. Can anyone tell me how to get around this? Thanks! Ron Smith DBA Kerr-McGee Corp -- 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 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: Reddy, Madhusudana 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).
SQL*Loader-282: Unable to locate character set handle for charact
I am trying to load data from a 8.1.7 SQL Loader session to a 7.3.4 database. I am getting a SQL*Loader-282: Unable to locate character set handle for character set ID (0). error message. Can anyone tell me how to get around this? Thanks! Ron Smith DBA Kerr-McGee Corp -- 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 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: STATSPACK
No you don't need a book as such it is a pretty neat schema. Read the spreport.sql and sprepins.sql scripts, they will tell you a lot of things that you need to know. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: odd explain plan
search for Star Query Execution Method in this doc: http://www.dbatoolbox.com/WP2001/dssdw/star_query.pdf -Original Message- Sent: Tuesday, March 26, 2002 4:54 PM To: Multiple recipients of list ORACLE-L Read about star schema execution plan. Regards, Waleed -Original Message- Sent: Tuesday, March 26, 2002 4:26 PM To: Multiple recipients of list ORACLE-L Hi. I am tuning a query that runs against a star schema and a few dimension tables. The plan shows that the first step is two join two dimension tables via a cartesian join. Why would Oracle does that instead of joining the dimensions to the fact table one after another? Can anyone offer an explanation? thank you = __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: odd explain plan
It's faster to only have one join to the large fact table. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 1:25 PM > Hi. > > I am tuning a query that runs against a star schema > and a few dimension tables. The plan shows that the > first step is two join two dimension tables via a > cartesian join. Why would Oracle does that instead of > joining the dimensions to the fact table one after > another? Can anyone offer an explanation? > > thank you > > = > > > __ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gene Gurevich > 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: Greg Moore 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: STATSPACK
Dennis, I have got all the statistics in the STAT tables now and I would like to query them to see the last info. regarding performance of the system. Seems like I may need to purchase a book . Thanks for the mail. Reddy -Original Message- Sent: Tuesday, March 26, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Reddy - I assume that you mean that you ran the statsrep.sql and printed the report. Is your question about interpreting this report? There is a good series of articles at http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html Or is your question how to write your own queries? If that is the question, I would recommend that you invest in the book "Oracle High-Performance Tuning with STATSPACK" by Don Burleson, available at your local bookstore. Don offers some articles on-line at http://www.dba-oracle.com/articles.htm Let me know if that is the information that you want. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 26, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Hello ALL, I have set up the statspack on Oracle 8.1.7 and just now I also got the REPORT , but poor me unable to understand that . Can anybody help me out in this ... Well I know www.oraperf.com will do it for me by sending a report , but I want to do it myself by writing some queries ... would anybody help me with some white paper. Thanks In advance, Madhu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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: odd explain plan
Read about star schema execution plan. Regards, Waleed -Original Message- Sent: Tuesday, March 26, 2002 4:26 PM To: Multiple recipients of list ORACLE-L Hi. I am tuning a query that runs against a star schema and a few dimension tables. The plan shows that the first step is two join two dimension tables via a cartesian join. Why would Oracle does that instead of joining the dimensions to the fact table one after another? Can anyone offer an explanation? thank you = __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Check Constraint
Jay, Two possibilities: 1. Before you add the constraint, issue a Select query with the Where clause being the NOT version of your Check Constraint. This is the least hassle. 2. Use the Exceptions Into clause when you create the Check Constraint. This will populate an Exceptions table with the RowIDs of the rows that violate the Check. See the Constraint_Clause section of the SQL Reference for details. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- Sent: Tuesday, March 26, 2002 3:15 PM To: Multiple recipients of list ORACLE-L When a check constraint is added to a table, is there an option in Oracle that will display or list the rows in the table that violate the constraint? TIA. Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: Check Constraint
You could always do a select to see which rows will violate the check. If you add a check like (X>5) then to see what rows would violate this do something like: select * from table where X<=5; -- Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 4:14 PM > When a check constraint is added to a table, is there an option in Oracle > that will display or list the rows > in the table that violate the constraint ? TIA. > > Jay > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: JJ > 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: Paul Heely 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: STATSPACK
Hello: Check the following web site to get statspack related whitepaper. http://otn.oracle.com/deploy/performance/content.html Thanks > > Hello ALL, > I have set up the statspack on Oracle 8.1.7 and just now I also got > the REPORT , but poor me unable to understand that . Can anybody > help me out in this ... Well I know www.oraperf.com will do it for > me by sending a report , but I want to do it myself by writing some > queries ... would anybody help me with some white paper. > > Thanks In advance, > Madhu > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Reddy, Madhusudana > 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: GURUPRASAD.VIJAYANAGAR 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: Dynamic SQL
Sorry, fat fingers varchar2s is a table of varchar2(256) Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: Oracle Wants Users to Hand over Apps Management
At least you need the DBA to report bugs, open tars and apply patches! Regards, Waleed Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Oracle has been saying for years that you wil no longer need DBAs. I suppose it's possible, although the database gets more and more complicated each release, as more and more new features that can shoot themselves in the foot are added. On the other hand, SOMEONE will need those DBAs. Oracle? And isn't this just a little bit like that monopoly that Larry was so insistent on toppling? --- Mark Leith <[EMAIL PROTECTED]> wrote: > What got me was another quote by Jeff Henley: > > "This is really the way most customers are going to want to have > their > software delivered over time. The bulk of our customers are going to > operate > this way in the not-too-distant future," Henley said. "We offer much > faster > implementation, much lower cost and much better service." > > Another line that says "all DBAs will be redundant in the > not-too-distant > future"! Are they saying that Oracle support offers a much better > service > and response time than a well trained DBA can? Fair enough with bug > checking > and alike, but how long does it take for a lot of you to get iTARS > answered > etc.? > > -Original Message- > Dave > Sent: 26 March 2002 15:18 > To: Multiple recipients of list ORACLE-L > > > Another publicity blunder by Uncle Larry. > > -Original Message- > Sent: Tuesday, March 26, 2002 8:03 AM > To: Multiple recipients of list ORACLE-L > > > Oracle Wants Users to Hand over Apps Management > > > Putting muscle behind the outsourcing model of application > management, > Oracle Corp. said it is starting an international campaign to > persuade > customers to hand over maintenance of their Oracle software. > > "We have decided to go in and actively go after our installed base > and tell > them that this is a better way to [run Oracle applications]," said > Jeff > Henley, Oracle's chief financial officer, speaking to financial > analysts in > New York yesterday. "We will put the sales guys on it and invest > heavily in > capacity." > > For full story: > http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: htt
RE: STATSPACK
Reddy - I assume that you mean that you ran the statsrep.sql and printed the report. Is your question about interpreting this report? There is a good series of articles at http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html Or is your question how to write your own queries? If that is the question, I would recommend that you invest in the book "Oracle High-Performance Tuning with STATSPACK" by Don Burleson, available at your local bookstore. Don offers some articles on-line at http://www.dba-oracle.com/articles.htm Let me know if that is the information that you want. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 26, 2002 3:00 PM To: Multiple recipients of list ORACLE-L Hello ALL, I have set up the statspack on Oracle 8.1.7 and just now I also got the REPORT , but poor me unable to understand that . Can anybody help me out in this ... Well I know www.oraperf.com will do it for me by sending a report , but I want to do it myself by writing some queries ... would anybody help me with some white paper. Thanks In advance, Madhu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: odd explain plan
Gene, what's the next step in the explain plan? Can you post it? Are the dimension tables small? Lisa Koivu Oracle Database Tank. Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Gene Gurevich [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 4:26 PM > To: Multiple recipients of list ORACLE-L > Subject: odd explain plan > > Hi. > > I am tuning a query that runs against a star schema > and a few dimension tables. The plan shows that the > first step is two join two dimension tables via a > cartesian join. Why would Oracle does that instead of > joining the dimensions to the fact table one after > another? Can anyone offer an explanation? > > thank you > > = > > > __ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Gene Gurevich > 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: Koivu, Lisa 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: Remote or Not? Was: Production Oracle DBA Needed in Rocheste
Hey Dave... I counted - outsource - trending - managed service - leveraging - best practices - continuous basis - strategic but I'm sure I missed some... does this mean I win? :-) Cheers! Paul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 1:59 PM Get out the BS bingo cards.. ;o) -Original Message- Sent: Tuesday, March 26, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Rocheste Hello everyone, This is a very interesting thread. Speaking as a part-owner of one of the companies John held up as an example of the successful outsourcers (thanks for mentioning us John), I'd like to make some points that I think will be of interest to all. The first is that working in a shop such as Pythian is actually a dream come true for many DBAs. The fact that the industry is trending to a managed service model for database administration is NOT A BAD thing for salaried DBAs out there. I think the opposite is true. The same thing happened for payroll specialists in the 80s and 90s, and now some 40% of companies outsource payroll. Those payroll specialist jobs simply migrated from individuals working solo in firms into working in teams for the Ceridians, Paychex and myriad competitors (i.e. almost every bank too) of the world. It's a great transition for many reasons that work well for the DBA as well as for the customer. I'll concentrate on the advantages for the DBA (why DBAs love working here), because they might not be as obvious. I can't speak for our competitors (hi!!! just kidding) :-) , but I believe a similar dynamic applies to them. A Pythian DBA gets experience on every major platform Oracle runs on: Solaris, HP/UX, Tru64, AIX, Linux, Win2k, I'm sure I'm forgetting some. A Pythian DBA gets experience on many versions of Oracle, in many industries simulaneously. We get to learn and develop best practices learned by seeing the way Oracle is used in many shops. We get to work in teams, relying on each other to help in emergencies, unstall each other, teach each other and develop each other's skills, and make sure we put our best foot forward for any customer simply because as a team we have an enormous amount of skills and experience. We get to learn and teach the very best in the industry, getting to know and understand that even the giants don't know everything while still having so much to share. We get to know our customers so well we mutually consider ourselves teammates, co-workers and sometimes even friends, greatly leveraging our network of contacts and friendships. We get to take on new shops on a continuous basis, whenever the company signs on a new customer, instead of having to quit a job when it gets boring. The way I've structured our company, in many small teams, we even get to take on completely new challenges and team dynamics simply by changing teams, rather than having to look elsewhere. We get to not be on-call every night, to not get shit for taking holidays, to not have to work insane hours (our team model is scalable in a way that the single-person salaried model is not.) We get to work on some of the most challenging environments in the world. I'm not kidding; I'm sure Jeremiah at Amazon has his hands full, but I am confident any DBA here would have something to talk with him about if they sat together at a dining-room table. Moreover, we get the satisfaction of doing an extraordinarily good job. I considered myself an accomplished DBA before having started this company. And yet I am completely certain that never was I able to do as good a job as we are doing now as a team. We provide sophisticated problem tracking tools, availability monitoring tools and and performance monitoring tools that never when I was an individual could I have contributed. It's extremely satisfying and fun. Moreover, much of our work is with DBAs (or teams of DBAs!) at customer sites. We work with many shops where we are not the sole DBA resource, but rather a part of a larger team, sometimes with us doing mentoring, back-up and on-call support for a DBA early in their career. Sometimes, it's when a company has an (or many) expert DBA that's completely swamped, and we help with the 24/7 and routine but lengthy aspects of the work and let them focus on the project management, strategic data modeling and other tasks that are more than enough to keep them on the right side of the very busy/having a breakdown boundary. I can't recommend it enough; I haven't had a better job or been happier at work than I am here. Hope this give you some insight into our company and what we're trying to do here. Best regards, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "M
RE: Check Constraint
Jay, Look into the EXCEPTIONS INTO exceptions syntax of ALTER TABLE. The exceptions table is created by utlexcpt.sql or utlexpt1.sql Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: JJ [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 4:15 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Check Constraint > > When a check constraint is added to a table, is there an option in Oracle > that will display or list the rows > in the table that violate the constraint ? TIA. > > Jay > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: JJ > 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: Koivu, Lisa 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: 8.1.7 LMTs Autoallocate vs Uniform Extents
Reading descriptions of the effects of Autoallocate leads me to think that Autoallocate is nothing more than PCTINCREASE redux--a little less crude, but still no way to manage your space. Paul Baumgartel --- sundeep maini <[EMAIL PROTECTED]> wrote: > Dennis, > > I mentioned Autoallocate and not autoextend. I have > been using LMTs for over a year now but only with > UNIFORM extent sizes. I am not sure if I am ready to > handover space management to Oracle (via Autoallocate > which is being foisted upon me as a panecea of all > ills) least I have evaluated the pros and cons. The > stuff in Manual and technet I have reveiwed so far > doesn't give you enough information like how much > space is wated in Autoallocate vs Uniform extent > sizes. How does Oracle decide to allocate an extent > for an Insert or an Update in Autoallocate option and > how does it decide on the extent size? > > So far I have looked at SQLRef, Concepts manual and > technet. Any other pointers? > > TIA > Sundeep __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.7 LMTs Autoallocate vs Uniform Extents
Sundeep Oops, egg on my face. Reading too fast, seeing one word and thinking another. My understanding from "Stop Defragmenting and Start Living" was that uniform extents was the direction Oracle was heading. The problem with autoallocate is that you can end up with fragmented tablespaces and therefore have to reorganize them from time to time. You end up with free spaces of varying sizes. With uniform extents you can't have fragmentation because all the extents are exactly the same size. The down side is that you may waste a bit more space because a small table may have more space allocated than it needs. Also you must get beyond the myth that a good table is all in one extent. Based on the above, I opted for uniform extents and have been pleased with the results. However, if someone has some strong arguments for autoallocate, I would be interested in hearing them. Hopefully this time I have responded to your question. Let me know. I went to http://www.google.com and searched for Oracle Autoallocate. Here is a link I found: http://www.jlcomp.demon.co.uk/ch_08.html With autoallocate tablespaces, you may get a fairly random scattering of 64K, 1MB, 8MB or 64MB depending on the demand and the current state of the tablespace. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 26, 2002 2:46 PM To: Multiple recipients of list ORACLE-L Dennis, I mentioned Autoallocate and not autoextend. I have been using LMTs for over a year now but only with UNIFORM extent sizes. I am not sure if I am ready to handover space management to Oracle (via Autoallocate which is being foisted upon me as a panecea of all ills) least I have evaluated the pros and cons. The stuff in Manual and technet I have reveiwed so far doesn't give you enough information like how much space is wated in Autoallocate vs Uniform extent sizes. How does Oracle decide to allocate an extent for an Insert or an Update in Autoallocate option and how does it decide on the extent size? So far I have looked at SQLRef, Concepts manual and technet. Any other pointers? TIA Sundeep --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Sundeep - Start by reading the classic paper "How to > Stop Defragmenting and > Start Living" at this link: > http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm > > Actually, autoallocate and uniform extents work very > well together. But you > need to understand the concepts behind them first. > And make sure your > application doesn't use up all your disk space if > you autoallocate. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, March 26, 2002 12:54 PM > To: Multiple recipients of list ORACLE-L > > > Can someone point me to good reading material on > this > subject. Is one better than the other for > performance > and manageability? > > Syntactically the autoallocate is shorter and seems > to > be more hands off (does that mean worry free also?). > > > > TIA > > > = > > Sundeep Maini > Consultant > Currently on Assignement at Marshfield Clinic WI > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: sundeep maini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: htt
OT edge cities & new urbanism (re: Now: Remote or Not? ) / Re: ORACLE-L Digest -- Volume 2002, Number 085
John, The accepted term for what you call "extended suburbia" is "edge cities". In Sacramento, examples that violate your 100 mile rule would be Roseville/Rocklin & Folsom, although I guess you could see them as "edge cities" of the larger Bay Area in some sense. OT, but perhaps interesting in the context of this thread about "lifestyle" issues, relocation, etc. of DBAs (and other tech workers), see the info on "new urbanism" at the sites listed below. Andres Duany has identified 3 main "villians" in terms of ugly/stupid growth patterns in the USA: 1) environmentalists and other (usually leftist) activists that are dependent on an "oppositionalist" paradigm (as opposed to a "constructivist" paradigm). 2) road engineers, who are the rigidly doctrinaire "high priests" of the bureaucracy that gave birth to the suburban sprawl mess in the USA after WWII. 3) politically correct mentality at architecture schools. due to slavish devotion to "fashionable nonsense", it has been hard to get them to embrace human-centered design elements that were discovered for 100s, or 1,000s of years in "traditional" parts of the world. Note that Duany says that "developers" can easily be taught the new human-centered paradigm, and he has found they make as much money either way. developers just want to avoid problems from either road-engineer/planning bureauc-rats, or environmental protestors. Duany designed the town that is the site of the movie "Truman" (no, it wasn't purely a movie set, it is a real place). http://www.seasidefl.com/index.html regards, ep http://www.cheshire-tnd.com/index.html - http://www.cnu.org - http://www.dpz.com/main.htm > There is a growing movement in North America to put an end to suburban > sprawl and to replace the automobilebased settlement patterns of the > past fifty years with a return to more traditional planning principles. > This movement stems not only from the realization that sprawl is > ecologically and economically unsustainable but also from an awareness > of sprawls many victims: children, utterly dependent on parental > transportation if they wish to escape the cul-de-sac; the elderly, > warehoused in institutions once they lose their drivers licenses; > commuters, stuck in traffic for two or more hours each day; the urban > poor, isolated in deteriorating cities without access to jobs or > services. > > Founders of the Congress for the New Urbanism, Andres Duany and > Elizabeth Plater-Zyberk are at the forefront of this movement, and in > Suburban Nation they assess sprawls costs to society, be they > ecological, economic, aesthetic, or social. This book is a lively > critical lament, and an entertaining lesson on the distinctions between > postwar suburbiacharacterized by housing clusters, strip shopping > centers, office parks, and Parking lots-and the traditional > neighborhoods that were built as a matter of course until midcentury. > It indicts the design and development industries for the fact that > America no longer builds towns. Most important, though, it is a book > that also offers us solutions. > > > > Dissects the physical design of the suburbs brilliantly...[The > authors] set forth more clearly than anyone has done in our time the > elements of good town planning. > > Paul Goldberger > > The New Yorker > > > > Suburban Nation is an essential text for our time, as compelling and > import as Jane Jacobss The Death and Life of Great American Cities > and Venturi, Brown and Izenours Learning from Las Vegas. This book is > not only a passionately argued, carefully reasoned dissection of the > mess that is becoming man made America but also a clear program of > steps that can be taken to enhance the humanity of both our suburbs > and our cities while conserving our rapidly dwindling countryside. > Everyone who cares about the future of our American way of life should > read this book. > > Robert A.M. Stern > > Dean > > Yale School of Architecture > > > > America will continue to grow, like it or not. The challenge is to do > so in a way that contains sprawl and offers attractive living choices > for families of all descriptions and income levels. To meet that > challenge, Suburban Nation is an essential handbook. > > John King > > San Francisco Chronicle Book Review Date sent: Tue, 26 Mar 2002 01:05:25 -0800 To: Multiple recipients of list ORACLE-L Forum) Date: Mon, 25 Mar 2002 15:12:18 -0800 Subject: Now: Remote or Not? Was: Production Oracle DBA Needed in Rocheste | On a personal front, I observe that (at least in the US) the | urban/suburban cost-of-living is driving more and more | remote workers (quite a number of IT workers, esp. DBAs) | into the extended suburbia (100 miles or more, up from | the current 50 mile radius), where these workers do come in | once or twice a week, sometimes to 'branch offices' spread | out among the various suburbs -- Please see the official ORACLE-L FA
Re: 8.1.7 LMTs Autoallocate vs Uniform Extents
There's a note on my website in the errata and addenda to the book, chapter 8, about this. 64MB extents kick in when the segment has grown to about 1GB. However, oddities occur all over the place, particularly when the tablespace has been exercised for a while. It is possible for Oracle to be pretty arbitrary about how many of each of the 'legal' extent sizes it uses if (a) you specify a table with a large initial extent (notes about that on the same addendum page) and/or if there are available holes near the start of the tablespace which are waiting to be used up. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 26 March 2002 20:59 Sundeep, Major differences between AUTOALLOCATE and UNIFORM is the fact that extent sizes in AUTOALLOCATE tablespace are not uniformly-sized. I've been working in v9.0.1 (not 8.1.7 -- don't have one of those!) and noticed the following pattern in non-partitioned tables and range-partitioned tables: first 16 extents = 64K (8 blocks of 8K apiece) next 63 extents = 1M (128 blocks of 8K apiece) next ? extents = 8M (1024 blocks of 8K apiece) In my tablespaces, I haven't seen more than 16 extents of 64K for any segment, and I haven't seen more than 63 extents of 1M for any segment. I don't have any objects big enough (yet) to probe the upper reaches of the 8M extent range... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Dynamic SQL
Looking at Raj's post I seem to have made at least two errors in my original reply - the size of the varchar2s in the dbms_sql array and the question of whether a varchar2 can be 32K, 32,000 bytes, or 4,000 bytes in pl/sql. Perhaps there are a couple of version-dependent details that need to be checked. Having said that, when you say the error is | I get an exception and the error is: sqlstr _IS_NULL_ what exactly is reporting the error in that format; it doesn't appear to be a normal exception message, and isn't one of the standard exceptions. I have tried to reproduce your problem, but only have 8.1.7.3. If the sql_str variable is declared large enough to hold the incoming string it works as expected, if the variable is larger than the declared length of the variable the error is the usual PL/SQL 6502 numeric or value error. Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 26 March 2002 20:30 |Yes, I know it's 32767. |My code: |PROCEDURE ... |sqlstr VARCHAR2(4000); | |sqlstr := my_pack.GETSQL( sql_id ... ); -- function | |OPEN my_cursor FOR sqlstr; |... |END; | |If the length of sqlstr is > 4000, | I get an exception and the error is: sqlstr _IS_NULL_ |Why? |I'm using 8.1.7.0.3 on Linux. | |JP | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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).
odd explain plan
Hi. I am tuning a query that runs against a star schema and a few dimension tables. The plan shows that the first step is two join two dimension tables via a cartesian join. Why would Oracle does that instead of joining the dimensions to the fact table one after another? Can anyone offer an explanation? thank you = __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich 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: Remote or Not? Was: Production Oracle DBA Needed in Rochester
This is a bit of what I do, for those who wonder...
I *AM* one of those persons we are discussing, and I work from home. I've
got clients in Texas, Oklahoma, Pennsylvania, New Jersey, Virginia,
Ohio, and others that are often just a phone number and passwords...
What I do is just a tad different in that I trend databases and can
tell the clients things like "This is what you are doing and if it
continues you are going to need two more disk drives in July, and two
more in Sept. You'll have a choice of doing that or move application
two to a new system."
I would guess my more personal slogan is "No More Database Surprises"..
to which most managers reply "That's EXACTLY what I'm looking for."
Management tells me I have a FIERCE customer loyalty.
But with the trending, I am normally way ahead of what's going to happen.
At one client I've got tables in a "no room" situation, but that's not
going to happen for 4, 7, 9, and 17 weeks. I'll work on the 4 in a week
or two. This client came with me when I changed jobs. They have also given
me 3 other databases to watch for them. This leaves their group free
to work on development and moving the business forward, and except for
electricity, network, and the like, the database has not had a crash in
4 years.
Environment: I have a cable modem, 2 modems, 5-6 computers but mostly work
off an HP Desktop and Compaq laptop. You need a headset for the phone, I've
got 3 phone lines. I've got Comcast.net and Earthlink for backup. Storage
for customers is about 400-600 meg. File server has 100gb of disk. Every
pertinent piece of customer info is on 3 different pcs, and 4 different
disk drives. CDs for archiving.
The only thing I can't do from 300-4500 miles away is change CDs or
mount tapes.
"Normal Day": Get up, shower, make coffee, go down stairs and start email
which includes various reports mailed from the customer site. Make sure
everything is fine, and that no one has mailed with any new "opportunities".
Check out all the lists such as Oracle-L. Also keep track of Smart
Partners, VAR Business, all sorts of NwFusion and other lists that track
the going ons of our businesses. Submit occasional "view from the field"
back to management.
As we get into afternoon, I then dial up, vpn, or "back door" into various
clients and perform the daily checks. Several evenings I do "the gathering"
from which I do my trending, no more often that once a week, and some only
once a month.
So if you are wondering, the days may run something like this:
7:45-9:30 email, filing, etc...
10:30-12:30 email, filing, R&D, etc.
2:00-4:30 - checking databases.
8:00-9:30 - twice a week, evening gatherings
about 4-6 hours on Saturday, occasional 2 hours or so on Sunday.
On all the databases I watch, I get beeped or called perhaps once a
month or so. I have a cell phone.
I've been involved in conference calls. I "touch base" with the
"nuts and bolt" people of clients several times a week either by
cell phone, email, or ICQ/IM.
*Part of a business*: Being part of a team is good because it allows me
to have a vacation. The "daily" stuff gets passed along to the fellow
team members. The "laptop" can do the gathering, and that's only
about 5-8 hours a week, pretty much when I want to do it. Customers can
get the reports when I get back. Also, since there are "others" that
can do Oracle App customization and development, I stay a DBA. The team
is tied together with ICQ which allows us to ask backup ("Can you go
look at XYZ and expand the temp space, I'm busy on ABC"... "Okay,
be on it in 5 minutes."... "Thanks.") Our internal team listserv is
some 150-250 DBAS and developers.
*For the customers*: I think they are charging about $800-5600 a month
for customers or $9600-$67,2000 a year for a dba team of 8-15+ years
experience. I know many of my customers have to have a fixed cost
so they can budget. And with the backup and all, there are no
benefits, no vacations to worry about etc. (The high end is for
full Oracle Apps support.)
And it's totally proactive. With the trending and some daily watching
we catch the problems way before they even show up as a show stopper.
A new ramp up at one customer took I/O from 100 to 400/sec in just a
short time and index use fell from 80% to 5%... They had a report with
the SQL in question, which datafiles, which conveniently pointed to
80% of it being the datafiles of the new application, and a list of
recommendations... This allowed their people to work on getting things
right and not having to worry about each little nut and bolt.
There have been conference calls with the client and whole development
team and management going over the reports, ways to get things done,
and the steps to accomplish.
But anyhow, for those that were wondering, that's what I do... It can
be long hours, but I normally only see a "database emergency" about
once a year. Everything else is planned in advance.
Michael Kline
ThinkSpark
Richmond, VA
804-744-1545
> -Origi
Re: Check Constraint
When a check constraint is added to a table, is there an option in Oracle that will display or list the rows in the table that violate the constraint ? TIA. Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JJ 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 Wants Users to Hand over Apps Management
Uncle Larry (and his cohorts) issue such Earth-shaking, 'Future-direction-for-IT' type pronouncements as a way of assuring themselves when they are in a hole. Hate to say it, but there are a lot of Internal Oracle 'Consultants' without projects and Oracle would like to keep them employed at $300/hour! That said, Market forces will drive consolidations, whether in the Data Centre or Services, and the bean-counters will win in the end. Whether they are ultimately right or wrong does not matter in the 'now' - every organizations wants to show 'current profit' (which cannot be lied about, unless you are Enron and employ Arthur Andersen :) and project large profits in the future 'if we take this path'. The Internet was barely out of the Univs. about 8 years ago and look where we are now. Let's not pooh-pooh future possibilites, and instead concentrate on being prepared. In this case, I would look at Tools or technologies that would automate what I do as a DBA - whether in monitoring/fixing problems or in tuning or better automating backup/restore. For example, I would support an OEM implementation for 'point-and-click' types, but understand the SQL and scripts behind it, which will ensure that I can understand what's going on. This will make me more valuable than someone who is seen as a rebel who resists moving to new technologies and definitely more valuable than a newbie who has no clue about how OEM does what it does... John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Grace - Getting something we don't deserve Mercy - NOT getting something we deserve Click on 'http://www.needhim.org' for Grace and Mercy that is freely available! ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -Original Message- > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 10:29 AM > To: Multiple recipients of list ORACLE-L > Subject: RE: Oracle Wants Users to Hand over Apps Management > > > Oracle has been saying for years that you wil no longer need DBAs. I > suppose it's possible, although the database gets more and more > complicated each release, as more and more new features that can shoot > themselves in the foot are added. > > On the other hand, SOMEONE will need those DBAs. Oracle? And > isn't this > just a little bit like that monopoly that Larry was so insistent on > toppling? > > > --- Mark Leith <[EMAIL PROTECTED]> wrote: > > What got me was another quote by Jeff Henley: > > > > "This is really the way most customers are going to want to have > > their > > software delivered over time. The bulk of our customers are going to > > operate > > this way in the not-too-distant future," Henley said. "We offer much > > faster > > implementation, much lower cost and much better service." > > > > Another line that says "all DBAs will be redundant in the > > not-too-distant > > future"! Are they saying that Oracle support offers a much better > > service > > and response time than a well trained DBA can? Fair enough with bug > > checking > > and alike, but how long does it take for a lot of you to get iTARS > > answered > > etc.? > > > > -Original Message- > > Dave > > Sent: 26 March 2002 15:18 > > To: Multiple recipients of list ORACLE-L > > > > > > Another publicity blunder by Uncle Larry. > > > > -Original Message- > > Sent: Tuesday, March 26, 2002 8:03 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Oracle Wants Users to Hand over Apps Management > > > > > > Putting muscle behind the outsourcing model of application > > management, > > Oracle Corp. said it is starting an international campaign to > > persuade > > customers to hand over maintenance of their Oracle software. > > > > "We have decided to go in and actively go after our installed base > > and tell > > them that this is a better way to [run Oracle applications]," said > > Jeff > > Henley, Oracle's chief financial officer, speaking to financial > > analysts in > > New York yesterday. "We will put the sales guys on it and invest > > heavily in > > capacity." > > > > For full story: > > http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html > > > > === > > Mark Leith | T: +44 (0)1905 330 281 > > Sales & Marketing | F: +44 (0)870 127 5283 > > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > > === > >http://www.cool-tools.co.uk > >Maximising throughput & performance > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Mark Leith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this maili
Re: pL/SQL PROCEDUR
[EMAIL PROTECTED] wrote: > you forgot DNA sample. Rachel's good, but come-on! not THAT good. wanna bet?;-) PS for those of you who remember and were following my job saga, we were sold yesterday. well, partly sold anyway. the closing is 4/10 and we're still not sure if there will be any jobs after that date with either the new company or with the bankruptcy trustee. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: 8.1.7 LMTs Autoallocate vs Uniform Extents
Dennis, I mentioned Autoallocate and not autoextend. I have been using LMTs for over a year now but only with UNIFORM extent sizes. I am not sure if I am ready to handover space management to Oracle (via Autoallocate which is being foisted upon me as a panecea of all ills) least I have evaluated the pros and cons. The stuff in Manual and technet I have reveiwed so far doesn't give you enough information like how much space is wated in Autoallocate vs Uniform extent sizes. How does Oracle decide to allocate an extent for an Insert or an Update in Autoallocate option and how does it decide on the extent size? So far I have looked at SQLRef, Concepts manual and technet. Any other pointers? TIA Sundeep --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Sundeep - Start by reading the classic paper "How to > Stop Defragmenting and > Start Living" at this link: > http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm > > Actually, autoallocate and uniform extents work very > well together. But you > need to understand the concepts behind them first. > And make sure your > application doesn't use up all your disk space if > you autoallocate. > Dennis Williams > DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -Original Message- > Sent: Tuesday, March 26, 2002 12:54 PM > To: Multiple recipients of list ORACLE-L > > > Can someone point me to good reading material on > this > subject. Is one better than the other for > performance > and manageability? > > Syntactically the autoallocate is shorter and seems > to > be more hands off (does that mean worry free also?). > > > > TIA > > > = > > Sundeep Maini > Consultant > Currently on Assignement at Marshfield Clinic WI > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: sundeep maini > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini 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: 8.1.7 LMTs Autoallocate vs Uniform Extents
Sundeep, Major differences between AUTOALLOCATE and UNIFORM is the fact that extent sizes in AUTOALLOCATE tablespace are not uniformly-sized. I've been working in v9.0.1 (not 8.1.7 -- don't have one of those!) and noticed the following pattern in non-partitioned tables and range-partitioned tables: first 16 extents = 64K (8 blocks of 8K apiece) next 63 extents = 1M (128 blocks of 8K apiece) next ? extents = 8M (1024 blocks of 8K apiece) In my tablespaces, I haven't seen more than 16 extents of 64K for any segment, and I haven't seen more than 63 extents of 1M for any segment. I don't have any objects big enough (yet) to probe the upper reaches of the 8M extent range... These tables were loaded with conventional-path SQL*Loader, which appears to be an important factor. Because, for my composite-partitioned tables, I noticed that the subpartitions do not follow this pattern at all. It could be due to the nature of a HASH-partition or a COMPOSITE-partition, but I suspect that it is due more to the fact that they were loaded with direct, parallel SQL*Loader. The extent sizes follow a pattern that I, as a non-mathematically-inclined person, cannot yet quantify. For those with the same pattern-seeking mania exhibited by the character of John Nash in the movie "A Beautiful Mind", here's a query of a single large subpartition: EXTENT_ID BLOCKS -- -- 0 8 1 8 2 8 3 8 4 8 5 8 6 8 7 8 8 8 9 8 10 8 11 8 12 8 13 8 14 8 15 8 16128 17128 18128 19 24 20 8 21 8 22 8 23 8 24 8 25 8 26 8 27 8 28 8 29 8 30 8 31 8 32 8 33 8 34 8 35 8 36128 37128 38 96 39 8 40 8 41 8 42 8 43 8 44 8 45 8 46 8 47 8 48 8 49 8 50 8 51 8 52 8 53 8 54 8 55128 56128 57128 58128 59 48 60 8 61 8 62 8 63 8 64 8 65 8 66 8 67 8 68 8 69 8 70 8 71 8 72 8 73 8 74 8 75 8 76128 77128 78128 79 64 80 8 81 8 82 8 83 8 84 8 85 8 86 8 87 8 88 8 89 8 90 8 91 8 92 8 93 8 94 8 95 8 96128 97128 98128 99128 100 64 101 8 Quite a few patterns leap to mind from this, but then I started seeing trench-coated CIA operatives so I'm just going to leave it alone (a reference to the above-mentioned movie, in case you're wondering)... Hope this helps... -Tim - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 11:53 AM > Can someone point me to good reading material on this > subject. Is one better than the other for performance > and manageability? > > Syntactically the autoallocate is shorter and seems to > be more hands off (does that mean worry free also?). > > > TIA > > > = > > Sundeep Maini > Consultant > Currently on Assignement at Marshfield Clinic WI > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: sundeep maini > 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
RE: EXPORT FAST?
And how much time will my database take? The database size is 118Gb, the disk transfer rate is 1 Mbps, the physical memory is 64Mb and two 486's ;-) Anne Yu <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> e.tx.us> cc: Sent by: Subject: RE: EXPORT FAST? root@fatcity. com March 26, 2002 01:59 PM Please respond to ORACLE-L do this: exp usr/pass buffer=4096 file=xx log=xx owner=xx. It takes 2 hours for a 59GB's database. -Original Message- Sent: Tuesday, March 26, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Hi one of export for 35GB database is taking 12 hours.How to reduce this export time. Thx Seema -- 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: pL/SQL PROCEDUR
you forgot DNA sample. Rachel's good, but come-on! not THAT good. -Original Message- Sent: Tuesday, March 26, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Even though I am beyond lazy, I don't write any code, or RTFM (remind us of someone??)...I did manage to steal some auditing triggers from Rachel C. and place them on the new table. When Tom inserted those nasty pictures, the trigger fired and emailed Tom's name, address, phone number, height, weight, SSN, finger prints, rental eye scan and picture to the FBI... Rachel writes some pretty powerful triggers... -Original Message- Sent: Tuesday, March 26, 2002 2:25 PM To: Multiple recipients of list ORACLE-L ok it's done. check your database. I also populated it with all the URL links to child-porn. the FBI is knocking at your door right now. check the BLOB columns. pretty nasty stuff stored there. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > Roland S -- 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: 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 -
Re: 8.1.7 LMTs Autoallocate vs Uniform Extents
And also Metalink doc 105120.1 "Reddy, Madhusudana" wrote: > > http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/tspaces.htm > > -Original Message- > Sent: Tuesday, March 26, 2002 12:54 PM > To: Multiple recipients of list ORACLE-L > > Can someone point me to good reading material on this > subject. Is one better than the other for performance > and manageability? > > Syntactically the autoallocate is shorter and seems to > be more hands off (does that mean worry free also?). > > TIA > > = > > Sundeep Maini > Consultant > Currently on Assignement at Marshfield Clinic WI > [EMAIL PROTECTED] > > __ > Do You Yahoo!? > Yahoo! Movies - coverage of the 74th Academy Awards® > http://movies.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: sundeep maini > 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: Reddy, Madhusudana > 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: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Remote or Not? Was: Production Oracle DBA Needed in Rocheste
"The fact that the industry is trending to a managed service model for database administration is NOT A BAD thing for salaried DBAs out there. I think the opposite is true." So, let us all second the Oracle sales pitch about them managing our databases for us, and hope to sneak into Oracle ;-) And if I cant manage that, my Oracle stocks will feed me ;-) Raj "Paul Vallee" ian.com> cc: Sent by: Subject: Re: Remote or Not? Was: Production Oracle DBA Needed in root@fatcity.Rocheste com March 26, 2002 01:08 PM Please respond to ORACLE-L Hello everyone, This is a very interesting thread. Speaking as a part-owner of one of the companies John held up as an example of the successful outsourcers (thanks for mentioning us John), I'd like to make some points that I think will be of interest to all. The first is that working in a shop such as Pythian is actually a dream come true for many DBAs. The fact that the industry is trending to a managed service model for database administration is NOT A BAD thing for salaried DBAs out there. I think the opposite is true. The same thing happened for payroll specialists in the 80s and 90s, and now some 40% of companies outsource payroll. Those payroll specialist jobs simply migrated from individuals working solo in firms into working in teams for the Ceridians, Paychex and myriad competitors (i.e. almost every bank too) of the world. It's a great transition for many reasons that work well for the DBA as well as for the customer. I'll concentrate on the advantages for the DBA (why DBAs love working here), because they might not be as obvious. I can't speak for our competitors (hi!!! just kidding) :-) , but I believe a similar dynamic applies to them. A Pythian DBA gets experience on every major platform Oracle runs on: Solaris, HP/UX, Tru64, AIX, Linux, Win2k, I'm sure I'm forgetting some. A Pythian DBA gets experience on many versions of Oracle, in many industries simulaneously. We get to learn and develop best practices learned by seeing the way Oracle is used in many shops. We get to work in teams, relying on each other to help in emergencies, unstall each other, teach each other and develop each other's skills, and make sure we put our best foot forward for any customer simply because as a team we have an enormous amount of skills and experience. We get to learn and teach the very best in the industry, getting to know and understand that even the giants don't know everything while still having so much to share. We get to know our customers so well we mutually consider ourselves teammates, co-workers and sometimes even friends, greatly leveraging our network of contacts and friendships. We get to take on new shops on a continuous basis, whenever the company signs on a new customer, instead of having to quit a job when it gets boring. The way I've structured our company, in many small teams, we even get to take on completely new challenges and team dynamics simply by changing teams, rather than having to look elsewhere. We get to not be on-call every night, to not get shit for taking holidays, to not have to work insane hours (our team model is scalable in a way that the single-person salaried model is not.) We get to work on some of the most challenging environments in the world. I'm not kidding; I'm sure Jeremiah at Amazon has his hands full, but I am confident any
RE: HDS ShadowImage and database backups
Rafiq, Yes, that's what I meant. Cool!! We can discuss this off line.. as I have a few questions. - Kirti -Original Message- Sent: Tuesday, March 26, 2002 1:34 PM To: Multiple recipients of list ORACLE-L By HDS's ShadowImage you mean Hitachi Data Storage ShadowImage. Yes, we are in process of setting up new HP hardware with Hitachi Storage and planning to use their Shadow Imaging within couple of months for all our production database backup. So far no practical experience but from demo it seems ok. Their tech guy supposed to come this week to show us setup etc but missed his appointment. Regards, Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 26 Mar 2002 10:36:02 -0800 Hello All, Is anyone using HDS's ShadowImage for backing up large databases? Our Sys Admin Dgmt is pursuing this technique and is suggesting that all large databases be backed up using this software. Good? Bad? Any insights would be appreciated. My Damager is already crying foul as HDS will close the current fiscal year/quarter soon ;) Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: Deshpande, Kirti 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: .dbf is a valid name for a datafile name?
Alter tablespace is a better option wherby you can do it while database is up and only that particular tablespace is offline. OEM does the same thing. You can use it for any tablespace except SYSTEM tablespace which you cannot put offline. For 'Alter database' you need down time as database cannot be open and it is to be used to change any SYSTEM tbs datafile. Both does the samething with different situations. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 26 Mar 2002 11:12:25 -0800 Raj, That looks like it works also. Many ways to skin a cat. I personally have gotten used to using OEM and letting it issue the command. I think they both would work. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 26, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Tom, if he is going to have the tablespace off line with database up and running , shouldn't the command be alter tablespace rename file '< >' to '< >' ; Cheers, RS --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Hamid, > > .dbf is prefectly valid on all machines, as far as I > know. > > You can rename it - look at the ALTER DATABASE > RENAME FILE 'filename' to > 'newfilename' clause to rename the data file. You > will need to take the > tablespace offline to do this. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Tuesday, March 26, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > > > I have added a datafile to a the temp tablespace > with the name of .dbf only > is ithis a valid name?, is there any way to rename > it without shutdown the > database,if yes HOW? > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any > attachments is intended > only for the use of the individual or entity to > which it is addressed, and > may contain information that is PRIVILEGED, > CONFIDENTIAL and exempt from > disclosure under applicable law. If you have > received this message in error, > you are prohibited from copying, distributing, or > using the information. > Please contact the sender immediately by return > e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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: Mercadante, Thomas F 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
Re: EXPORT FAST?
Seema Singh wrote: > > Hi > one of export for 35GB database is taking 12 hours.How to reduce this export > time. > Thx > Seema > Try direct=Y, and (if nobody is currently using the database, otherwise you risk running into inconsistencies) try to export in parallel, by exporting several owners or tables in different processes, and trying to have all processes dealing with roughly the same amount of data. Quite obviously, try not to send all the data to the same controller/disk. If you still have times which are too long for you, totally reconsider. Import time will easily be 4/5 times greater. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: .dbf is a valid name for a datafile name?
Create another temp1 tablespace not big. point your user temp tablespace to temp1. Offline your temp tablespace and do whatever you want. Once done point back the original temp tbs and drop temp1 tbs. No system down time. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 26 Mar 2002 11:38:57 -0800 Just don't know can i make off line TEPM tablespace or not? alot of users using it ... -Original Message- Sent: Tuesday, March 26, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Tom, if he is going to have the tablespace off line with database up and running , shouldn't the command be alter tablespace rename file '< >' to '< >' ; Cheers, RS --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Hamid, > > .dbf is prefectly valid on all machines, as far as I > know. > > You can rename it - look at the ALTER DATABASE > RENAME FILE 'filename' to > 'newfilename' clause to rename the data file. You > will need to take the > tablespace offline to do this. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Tuesday, March 26, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > > > I have added a datafile to a the temp tablespace > with the name of .dbf only > is ithis a valid name?, is there any way to rename > it without shutdown the > database,if yes HOW? > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any > attachments is intended > only for the use of the individual or entity to > which it is addressed, and > may contain information that is PRIVILEGED, > CONFIDENTIAL and exempt from > disclosure under applicable law. If you have > received this message in error, > you are prohibited from copying, distributing, or > using the information. > Please contact the sender immediately by return > e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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). The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet acces
Re: Dynamic SQL
Yes, I know it's 32767. My code: PROCEDURE ... sqlstr VARCHAR2(4000); sqlstr := my_pack.GETSQL( sql_id ... ); -- function OPEN my_cursor FOR sqlstr; ... END; If the length of sqlstr is > 4000, I get an exception and the error is: sqlstr _IS_NULL_ Why? I'm using 8.1.7.0.3 on Linux. JP On Tue 26. March 2002 20:24, you wrote: > Depends how you are getting that 4,000 characters > to the procedure, of course, but a pl/sql varchar2() > can in principle be 32,000 bytes. > > And if that isn't enough, you may have to fall back > to dbms_sql which exposes a packaged type which > is an array of varchar2(255) so that you can build, > pass, and execute the array. (I think there's a > sample of this on my web site). > > > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Next Seminar - UK, April 3rd - 5th > http://www.jlcomp.demon.co.uk/seminar.html > > Host to The Co-Operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > Author of: > Practical Oracle 8i: Building Efficient Databases > > > -Original Message- > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Date: 26 March 2002 18:58 > > |Hello > |I'm using variable sqlstr VARCHAR2(4000) in procedure to create > > SELECT string. > > |But the length of my SELECT * FROM is bigger than 4000 chars. > | > |Is there a way how to call OPEN my_cursor FOR sqlstr; > |for sqlstr longer than 4000 signs? > | > |JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to duplicate production database onto development box
Is there any need to create a standby database in this case? My procedure for copying production to development is: 1. alter database backup controlfile to trace; (in production) 2. Restore a production backup (either hot or cold) to the development server 3. Update database name and filenames in the controlfile script from step 1, as required 4. Run script from step 3 on development server to create new controlfiles 5. Recover new development database up to desired point in time using archived redo from production 6. Open the new development database with resetlogs This approach allows me to rename the database and the datafiles (if the datafiles need to be placed differently on the development server than in production, for example) in one step, rather than manually renaming 50+ datafiles in a standby database, and then recovering, activating, and renaming that database. Marc Cure Oracle DBA, OCP -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L I use a hot backup to create a standby database then apply logs to the point I want to get a copy of production of a specific time. Then you can rename the database if you want to. -Original Message- Sent: Tuesday, March 26, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Just copy the files over and recreate the control file. Abraham -Original Message- Sent: Tuesday, March 26, 2002 7:48 AM To: Multiple recipients of list ORACLE-L Hi! We want to put an exact copy of our production database (approx. 200 GB) onto a development box. What would be the best way to achieve this? Export/import would take kinda long... ;) Would transportable tablespaces be the way to go? This is 8.1.7 on Sun Solaris. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Cure 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: .dbf is a valid name for a datafile name?
> That looks like it works also. Many ways to skin a > cat. true..!! Thanks for not taking this the wrong way..:) Cheers, RS __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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: Rename Oracle User
Todd Carlson wrote:
>
> Solaris 5.8 Oracle 8.1.7.2
> Has anyone successfully renamed the Oracle user on a solaris box? At the
> moment I don't a test box and this is a rarely used development system.
> The current Oracle user and group are oracle2 and dba2. We have to
> change it to match our standards, i.e. oracle & dba.
>
> The plan is to (after a full system backup):
> 1) Create the correct local user & group with the same home directory.
> 2) Shutdown all Oracle processes.
> 3) Find . -user oracle2 -exec chown oracle {} \;
> 4) Find . -user dba2 -exec chgrp dba {} \;
> 5) Modify all scripts to use the correct group & user.
> 6) Pray.
> 7) Start the database and listener.
> 8) Check for functionality & errors.
> 9) Shut everything down and take a full system backup.
>
> Am I missing anything? Is there any problems with the method?
>
> Thanks,
> Todd Carlson
> Oracle Database Administrator
> Tripos, Inc.
> (314) 647-8837 Ext.3246
>
There is one additional thing at least you should check, namely
$ORACLE_HOME/rdbms/admin/config.c which contains (hard-coded) the
expected group name. If 'dba2' was chosen during install, then you'll
probably find it inside config.c. You should then run
cc -c config.c -o config.o
and relink oracle (make -f ins_rdbms.mk install should do the trick).
You should take the backup as step 3, not step 9.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: pL/SQL PROCEDUR
Even though I am beyond lazy, I don't write any code, or RTFM (remind us of someone??)...I did manage to steal some auditing triggers from Rachel C. and place them on the new table. When Tom inserted those nasty pictures, the trigger fired and emailed Tom's name, address, phone number, height, weight, SSN, finger prints, rental eye scan and picture to the FBI... Rachel writes some pretty powerful triggers... -Original Message- Sent: Tuesday, March 26, 2002 2:25 PM To: Multiple recipients of list ORACLE-L ok it's done. check your database. I also populated it with all the URL links to child-porn. the FBI is knocking at your door right now. check the BLOB columns. pretty nasty stuff stored there. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > Roland S -- 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: 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, inclu
Re: Dynamic SQL
Depends how you are getting that 4,000 characters to the procedure, of course, but a pl/sql varchar2() can in principle be 32,000 bytes. And if that isn't enough, you may have to fall back to dbms_sql which exposes a packaged type which is an array of varchar2(255) so that you can build, pass, and execute the array. (I think there's a sample of this on my web site). Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 26 March 2002 18:58 |Hello |I'm using variable sqlstr VARCHAR2(4000) in procedure to create SELECT string. |But the length of my SELECT * FROM is bigger than 4000 chars. | |Is there a way how to call OPEN my_cursor FOR sqlstr; |for sqlstr longer than 4000 signs? | |JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: 8.1.7 LMTs Autoallocate vs Uniform Extents
Sundeep - Start by reading the classic paper "How to Stop Defragmenting and Start Living" at this link: http://www.dbatoolbox.com/WP2001/spacemgmt/defrag.htm Actually, autoallocate and uniform extents work very well together. But you need to understand the concepts behind them first. And make sure your application doesn't use up all your disk space if you autoallocate. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 26, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Can someone point me to good reading material on this subject. Is one better than the other for performance and manageability? Syntactically the autoallocate is shorter and seems to be more hands off (does that mean worry free also?). TIA = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Funniest line in the manual.
ROTFLMAO that *is* funny RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, March 26, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Do you have a favourite (or favorite) joke in the Oracle manuals. I've been reading the Oracle 9 SQL reference manual - as one does from time to time - and spotted this gem on p. 2-97: /*+ ordered_predicates */ Use this hint in the WHERE clause of SELECT statements. Can I propose this one for urban legend status for 2004 ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: Freeman, Robert 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: 8.1.7 LMTs Autoallocate vs Uniform Extents
http://technet.oracle.com/doc/oracle8i_816/server.816/a76956/tspaces.htm -Original Message- Sent: Tuesday, March 26, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Can someone point me to good reading material on this subject. Is one better than the other for performance and manageability? Syntactically the autoallocate is shorter and seems to be more hands off (does that mean worry free also?). TIA = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini 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: Reddy, Madhusudana 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: Rename Oracle User
Sorry, I should have specified the backup was first. Thanks for the
sanity check Brian!
Todd
-Original Message-
Sent: Tuesday, March 26, 2002 12:06 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Surprised to not see a backup of the DB and $ORACLE_BASE after #2.
You can combine #3 & #4 with "find / -user oracle2 -exec chown
oracle:dba
{} \;" as long as oracle2 is the only member of the dba2 group and
you're
not using the "oinstall" as oracle2's default group.
I think #4 should be "-group dba2" not "-user dba2".
Not sure what #5 means.
To be safe #6 should be a recompile of the Oracle executables. Something
like the following, but see ->
http://metalink.oracle.com/metalink/plsql/ml2_documents.showNot?p_id=131
321.1&p_font
(Note:131321.1 Subject: How to Relink Oracle Database Software on
Unix)
for details:
---THIS IS A SOLARIS KSH SHELL EXAMPLE---
export PATH=/usr/ccs/bin:${PATH}
which ld #should return '/usr/ccs/bin/ld'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}
#If using 64bit Oracle, LD_LIBRARY_PATH should also include
$ORACLE_HOME/lib64.
cd $ORACLE_HOME/bin
relink all
"Todd Carlson"
os.com> cc:
Sent by: Subject: Rename Oracle User
[EMAIL PROTECTED]
om
03/26/02 08:23
AM
Please respond
to ORACLE-L
Solaris 5.8 Oracle 8.1.7.2
Has anyone successfully renamed the Oracle user on a solaris box? At the
moment I don't a test box and this is a rarely used development system.
The current Oracle user and group are oracle2 and dba2. We have to
change it to match our standards, i.e. oracle & dba.
The plan is to (after a full system backup):
1) Create the correct local user & group with the same home directory.
2) Shutdown all Oracle processes.
3) Find . -user oracle2 -exec chown oracle {} \;
4) Find . -user dba2 -exec chgrp dba {} \;
5) Modify all scripts to use the correct group & user.
6) Pray.
7) Start the database and listener.
8) Check for functionality & errors.
9) Shut everything down and take a full system backup.
Am I missing anything? Is there any problems with the method?
Thanks,
Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Todd Carlson
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: Todd Carlson
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: HDS ShadowImage and database backups
By HDS's ShadowImage you mean Hitachi Data Storage ShadowImage. Yes, we are in process of setting up new HP hardware with Hitachi Storage and planning to use their Shadow Imaging within couple of months for all our production database backup. So far no practical experience but from demo it seems ok. Their tech guy supposed to come this week to show us setup etc but missed his appointment. Regards, Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Tue, 26 Mar 2002 10:36:02 -0800 Hello All, Is anyone using HDS's ShadowImage for backing up large databases? Our Sys Admin Dgmt is pursuing this technique and is suggesting that all large databases be backed up using this software. Good? Bad? Any insights would be appreciated. My Damager is already crying foul as HDS will close the current fiscal year/quarter soon ;) Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). MOHAMMAD RAFIQ _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq 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: EXPORT FAST?
Also look into the option BUFFER in export. Srini -Original Message- Sent: Tuesday, March 26, 2002 10:59 AM To: Multiple recipients of list ORACLE-L I think you can use direct=y option. Are you taking this export to a file (over disk) or directly to tape? Greeting Diego Cutrone - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 3:13 PM > Hi > one of export for 35GB database is taking 12 hours.How to reduce this export > time. > Thx > Seema > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.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: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Wants Users to Hand over Apps Management
Well trained monkey is (I think) the phrase that I last heard for Apps DBA... I think it has something to do with the fact (as I have seen it semi first hand) that you need to be able to use your four extremities productively, as well as your prehensile tail. April -Original Message- Sent: Tuesday, March 26, 2002 1:12 PM To: Multiple recipients of list ORACLE-L >From what I understand, the task is daunting keeping a release up to date. They've really built a beast. When you hear people on this list talking about "APPS DBA's", you get the feeling that it is something special. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 26, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Are they implying that Oracle Applications is proving too difficult to administer for many sites? ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Wants Users to Hand over Apps Management Another publicity blunder by Uncle Larry. -Original Message- Sent: Tuesday, March 26, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Oracle Wants Users to Hand over Apps Management Putting muscle behind the outsourcing model of application management, Oracle Corp. said it is starting an international campaign to persuade customers to hand over maintenance of their Oracle software. "We have decided to go in and actively go after our installed base and tell them that this is a better way to [run Oracle applications]," said Jeff Henley, Oracle's chief financial officer, speaking to financial analysts in New York yesterday. "We will put the sales guys on it and invest heavily in capacity." For full story: http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Mercadante, Thomas F 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). begin 666 InterScan_Disclaimer.txt M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA M;
RE: Dynamic SQL
Hmm this is a classic RTFM, but the answer is here ... if you are using dbms_sql then use "procedure dbms_sql.parse(c in integer, statement in varchar2s, lb in integer, ub in integer, lfflg in boolean, language_flag in integer);" syntax. This requires you to declare a local variable of type "dbms_sql.varchar2s". This type is essentially an index by table of varchar2(2000), so you are then pretty much limited by your creativity for the length of the sql statement. More information is available in $ORACLE_HOME/rdbms/admin/dbmssql.sql (it is a very good reading). If you are using "execute immediate" thant I don't see what you'd have a problem with 4000 characters. You mention 4000, so I assume you are on 8i or 9i, then since Oracle 7x, the varchar2 variable is 32K-1 i.e. 32767 in pl/sql, way more than 4000 characters. In either case, you win. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *2
RE: EXPORT FAST?
FAST EXPORT: 1. High Buffer 2. Have export on a disk where you have less activity of i/o 3. Do Not Export to a NFS mounted file system/disk , which is very slow. Hope this helps --- Madhu -Original Message- Sent: Tuesday, March 26, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Hi one of export for 35GB database is taking 12 hours.How to reduce this export time. Thx Seema _ Chat with friends online, try MSN Messenger: http://messenger.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: Reddy, Madhusudana 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: .dbf is a valid name for a datafile name?
Just don't know can i make off line TEPM tablespace or not? alot of users using it ... -Original Message- Sent: Tuesday, March 26, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Tom, if he is going to have the tablespace off line with database up and running , shouldn't the command be alter tablespace rename file '< >' to '< >' ; Cheers, RS --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Hamid, > > .dbf is prefectly valid on all machines, as far as I > know. > > You can rename it - look at the ALTER DATABASE > RENAME FILE 'filename' to > 'newfilename' clause to rename the data file. You > will need to take the > tablespace offline to do this. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Tuesday, March 26, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > > > I have added a datafile to a the temp tablespace > with the name of .dbf only > is ithis a valid name?, is there any way to rename > it without shutdown the > database,if yes HOW? > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any > attachments is intended > only for the use of the individual or entity to > which it is addressed, and > may contain information that is PRIVILEGED, > CONFIDENTIAL and exempt from > disclosure under applicable law. If you have > received this message in error, > you are prohibited from copying, distributing, or > using the information. > Please contact the sender immediately by return > e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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). The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Customize my SQLPlus login
Put a blank line at the end of your script. I don't know why it does that but that's the fix. "Farnsworth, Dave"To: Multiple recipients of list ORACLE-L @Ashleyfurnitcc: ure.com> Subject: RE: Customize my SQLPlus login Sent by: root 03/26/2002 11:18 AM Please respond to ORACLE-L I have added some customizations to my glogin.sql. When I start a session of SQLPlus I get this; Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production Input truncated to 13 characters SQL> show pagesize pagesize 250 I can see that my changes took place but what is the "Input truncated to 13 characters" about?? Thanks, Dave -Original Message- Sent: Tuesday, March 26, 2002 8:29 AM To: Multiple recipients of list ORACLE-L login.sql and glogin.sql glogin.sql will be global, from wherever you start your sqlplus session, login.sql is run from your current directory so if you have changed directories it won't be run --- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote: > What is the file that I need to edit on my client PC to set > personalized settings for SQLPlus so that I do not have to set these > at the command prompt every time I start a new session? > > Thanks, > > Dave > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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 you
RE: .dbf is a valid name for a datafile name?
Raj, That looks like it works also. Many ways to skin a cat. I personally have gotten used to using OEM and letting it issue the command. I think they both would work. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 26, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Tom, if he is going to have the tablespace off line with database up and running , shouldn't the command be alter tablespace rename file '< >' to '< >' ; Cheers, RS --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Hamid, > > .dbf is prefectly valid on all machines, as far as I > know. > > You can rename it - look at the ALTER DATABASE > RENAME FILE 'filename' to > 'newfilename' clause to rename the data file. You > will need to take the > tablespace offline to do this. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Tuesday, March 26, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > > > I have added a datafile to a the temp tablespace > with the name of .dbf only > is ithis a valid name?, is there any way to rename > it without shutdown the > database,if yes HOW? > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any > attachments is intended > only for the use of the individual or entity to > which it is addressed, and > may contain information that is PRIVILEGED, > CONFIDENTIAL and exempt from > disclosure under applicable law. If you have > received this message in error, > you are prohibited from copying, distributing, or > using the information. > Please contact the sender immediately by return > e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards(r) http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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: Mercadante, Thomas F 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: Net 8 installation on a server rather than client question
I did this for a while with the 7.3 client. Performance was abysmal. My network admin also was on my case about network traffic. I don't know if the Net8 client would be better or not. Pointing TNS_ADMIN to a network drive is great, but unless there have been significant changes in the client, I would be more inclined to have it local. What I did for the network install was to set up a machine installing the client to a network drive. Exported the registry key for Oracle. Copied the Windows system files to a network location. Added that location to the PATH variable. It was cumbersome, but it worked. On the other machines I imported the registry file, added the PATH variable, and TNS_ADMIN variable. The problem with all this is when you upgrade the client, you have to upgrad all the user registries with the new keys and structure changes that Oracle makes. You may as well install each machine. Rodd On Tue, 2002-03-26 at 09:18, Ron Cetnar wrote: Question to the list. Is there was way to install Net 8 on a nt server and have client pc's execute the Net 8 from the server instead of loading Net 8 on the client's pc. To avoid installation of Net 8 on the clients. I already have the tnsnames.ora file on the server and with a bat file that updates the registry on the client to point to the server to get the tnsnames file. Currently using Net 8 ver 8.1.6 Thanks Ron *** Ron Cetnar Supervising Programmer/Analyst/DBA State University of New York at Albany MSC 100 1400 Washington Ave Albany, NY 1 Email: [EMAIL PROTECTED] Work: (518) 437-4535 Fax: (518) 437-4540 *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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: Dynamic SQL
JP, No, but you can make multiple 4000 char strings and concat it all together: sel1 varchar2(4000); sel2 varchar2(4000); where_clause varchar2(4000); order_by_clause varchar2(4000); begin open my_cursor for sel1 || sel2 || where_clause || order_by_clause; I do it all the time! Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 26, 2002 1:44 PM To: Multiple recipients of list ORACLE-L Hello I'm using variable sqlstr VARCHAR2(4000) in procedure to create SELECT string. But the length of my SELECT * FROM is bigger than 4000 chars. Is there a way how to call OPEN my_cursor FOR sqlstr; for sqlstr longer than 4000 signs? JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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: Mercadante, Thomas F 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).
OT: Funniest line in the manual.
Do you have a favourite (or favorite) joke in the Oracle manuals. I've been reading the Oracle 9 SQL reference manual - as one does from time to time - and spotted this gem on p. 2-97: /*+ ordered_predicates */ Use this hint in the WHERE clause of SELECT statements. Can I propose this one for urban legend status for 2004 ? Jonathan Lewis http://www.jlcomp.demon.co.uk Next Seminar - UK, April 3rd - 5th http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis 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: EXPORT FAST?
Make sure you didn't issue consustent=y and refer to meta link for any problems with direct export on your platform. Direct is the way to go. Cheers, RS --- Diego Cutrone <[EMAIL PROTECTED]> wrote: > I think you can use direct=y option. > > Are you taking this export to a file (over disk) or > directly to tape? > > Greeting > Diego Cutrone > > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EMAIL PROTECTED]> > Sent: Tuesday, March 26, 2002 3:13 PM > > > > Hi > > one of export for 35GB database is taking 12 > hours.How to reduce this > export > > time. > > Thx > > Seema > > > > > > > > > _ > > Chat with friends online, try MSN Messenger: > http://messenger.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: Diego Cutrone > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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: EXPORT FAST?
do this: exp usr/pass buffer=4096 file=xx log=xx owner=xx. It takes 2 hours for a 59GB's database. -Original Message- Sent: Tuesday, March 26, 2002 12:13 PM To: Multiple recipients of list ORACLE-L Hi one of export for 35GB database is taking 12 hours.How to reduce this export time. Thx Seema _ Chat with friends online, try MSN Messenger: http://messenger.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: Anne Yu 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 Wants Users to Hand over Apps Management
In a sociology course I took they explained that capitalism and publicly traded companies naturally tend toward oligopolies, followed by monopolies. Not sure if that is true - I was hoping the antitrust laws would prove useful, but... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 2:29 PM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Wants Users to Hand over Apps Management Oracle has been saying for years that you wil no longer need DBAs. I suppose it's possible, although the database gets more and more complicated each release, as more and more new features that can shoot themselves in the foot are added. On the other hand, SOMEONE will need those DBAs. Oracle? And isn't this just a little bit like that monopoly that Larry was so insistent on toppling? --- Mark Leith <[EMAIL PROTECTED]> wrote: > What got me was another quote by Jeff Henley: > > "This is really the way most customers are going to want to have > their > software delivered over time. The bulk of our customers are going to > operate > this way in the not-too-distant future," Henley said. "We offer much > faster > implementation, much lower cost and much better service." > > Another line that says "all DBAs will be redundant in the > not-too-distant > future"! Are they saying that Oracle support offers a much better > service > and response time than a well trained DBA can? Fair enough with bug > checking > and alike, but how long does it take for a lot of you to get iTARS > answered > etc.? > > -Original Message- > Dave > Sent: 26 March 2002 15:18 > To: Multiple recipients of list ORACLE-L > > > Another publicity blunder by Uncle Larry. > > -Original Message- > Sent: Tuesday, March 26, 2002 8:03 AM > To: Multiple recipients of list ORACLE-L > > > Oracle Wants Users to Hand over Apps Management > > > Putting muscle behind the outsourcing model of application > management, > Oracle Corp. said it is starting an international campaign to > persuade > customers to hand over maintenance of their Oracle software. > > "We have decided to go in and actively go after our installed base > and tell > them that this is a better way to [run Oracle applications]," said > Jeff > Henley, Oracle's chief financial officer, speaking to financial > analysts in > New York yesterday. "We will put the sales guys on it and invest > heavily in > capacity." > > For full story: > http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > 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: Oracle Wants Users to Hand over Apps Management
It used to be better, when we could just call them. We used to have silver support. Then, at first, Web TARs were answered promptly. I don't know if there has been a change in policy, but as soon as it's past regular hours I get little feedback from Metalink technicians. They used to have a support site in Ireland or the UK, I don't know if it still exists. They must have a support site in India, I don't understand why (given the time zone difference) Oracle can't provide support 24x7 via MetaLink for most calls. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- 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).
RE: Customize my SQLPlus login
If you don't "@glogin.sql" before you truncate a table with millions of rows then you deserve to be unemployed (IMAO). Brian P. MacLean Oracle DBA, OCP8i "Grabowy, Chris" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: Customize my SQLPlus login Sent by: [EMAIL PROTECTED] om 03/26/02 11:38 AM Please respond to ORACLE-L How do you know you ran the login script?? Maybe you forgot? And your really on production...when your about to truncate that table...that's unrecoverable...that's billions of rowswith hundreds of recent Fairfield customer reservations...that will be very upset... BTW, any chance you can "slip" me into the system, for a paid hotel reservation in Miami for a couple of days? -Original Message- Sent: Tuesday, March 26, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Nothing happens, the prompt stays the same unless you run @login, which I do to keep my head straight (INV-SYSTEM)>show user USER is "SYSTEM" (INV-SYSTEM)>connect elvis@inv Enter password: * Connected. (INV-SYSTEM)>@login (INV-ELVIS)> or create a script with the login name and sid that calls login.sql right afterwards. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Customize my SQLPlus login > > What happens if the user then issues a connect statement to connect to > another database? > > It would be nice if there was a .sql file run every time a new connection > is > set, I don't know if that is the case in the 8i / 9i versions. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > -Original Message- > Sent: Tuesday, March 26, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Customize my SQLPlus login > > > in your oracle /bin directory - you need to alter (Or create) a login.sql > file > > here's what mine looks like - feel free to alter > > /* start */ > set heading on > set pause off > set pages 23 > set lines 100 > set verify off > set feedback on > set space 1 > set serveroutput on size 100 > set echo off > > set termout off > column d_bname new_value d_bname > select user ||'@'||instance_name d_bname > from v$instance ; > set sqlprompt '&d_bname.> ' > set termout on > set pause on > /* end */ > > Brian. > > > -- > 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: [E
RE: Remote or Not? Was: Production Oracle DBA Needed in Rocheste
Get out the BS bingo cards.. ;o) -Original Message- Sent: Tuesday, March 26, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Rocheste Hello everyone, This is a very interesting thread. Speaking as a part-owner of one of the companies John held up as an example of the successful outsourcers (thanks for mentioning us John), I'd like to make some points that I think will be of interest to all. The first is that working in a shop such as Pythian is actually a dream come true for many DBAs. The fact that the industry is trending to a managed service model for database administration is NOT A BAD thing for salaried DBAs out there. I think the opposite is true. The same thing happened for payroll specialists in the 80s and 90s, and now some 40% of companies outsource payroll. Those payroll specialist jobs simply migrated from individuals working solo in firms into working in teams for the Ceridians, Paychex and myriad competitors (i.e. almost every bank too) of the world. It's a great transition for many reasons that work well for the DBA as well as for the customer. I'll concentrate on the advantages for the DBA (why DBAs love working here), because they might not be as obvious. I can't speak for our competitors (hi!!! just kidding) :-) , but I believe a similar dynamic applies to them. A Pythian DBA gets experience on every major platform Oracle runs on: Solaris, HP/UX, Tru64, AIX, Linux, Win2k, I'm sure I'm forgetting some. A Pythian DBA gets experience on many versions of Oracle, in many industries simulaneously. We get to learn and develop best practices learned by seeing the way Oracle is used in many shops. We get to work in teams, relying on each other to help in emergencies, unstall each other, teach each other and develop each other's skills, and make sure we put our best foot forward for any customer simply because as a team we have an enormous amount of skills and experience. We get to learn and teach the very best in the industry, getting to know and understand that even the giants don't know everything while still having so much to share. We get to know our customers so well we mutually consider ourselves teammates, co-workers and sometimes even friends, greatly leveraging our network of contacts and friendships. We get to take on new shops on a continuous basis, whenever the company signs on a new customer, instead of having to quit a job when it gets boring. The way I've structured our company, in many small teams, we even get to take on completely new challenges and team dynamics simply by changing teams, rather than having to look elsewhere. We get to not be on-call every night, to not get shit for taking holidays, to not have to work insane hours (our team model is scalable in a way that the single-person salaried model is not.) We get to work on some of the most challenging environments in the world. I'm not kidding; I'm sure Jeremiah at Amazon has his hands full, but I am confident any DBA here would have something to talk with him about if they sat together at a dining-room table. Moreover, we get the satisfaction of doing an extraordinarily good job. I considered myself an accomplished DBA before having started this company. And yet I am completely certain that never was I able to do as good a job as we are doing now as a team. We provide sophisticated problem tracking tools, availability monitoring tools and and performance monitoring tools that never when I was an individual could I have contributed. It's extremely satisfying and fun. Moreover, much of our work is with DBAs (or teams of DBAs!) at customer sites. We work with many shops where we are not the sole DBA resource, but rather a part of a larger team, sometimes with us doing mentoring, back-up and on-call support for a DBA early in their career. Sometimes, it's when a company has an (or many) expert DBA that's completely swamped, and we help with the 24/7 and routine but lengthy aspects of the work and let them focus on the project management, strategic data modeling and other tasks that are more than enough to keep them on the right side of the very busy/having a breakdown boundary. I can't recommend it enough; I haven't had a better job or been happier at work than I am here. Hope this give you some insight into our company and what we're trying to do here. Best regards, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 2:53 AM Personally I like being in the office environment and interacting with other members of my species :-) I do get the opportunity to work from home on a fairly regular basis and I do take it when I really need to focus on something
Oracle Wants Users to Hand over Money (Was: Oracle Wants Users to Hand over Apps Management)
Oracle Wants Users to Hand over Apps Management = Oracle Wants Users to Hand over Money. Jerry Whittle ACIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Whittle Jerome Contr NCI INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pL/SQL PROCEDUR
ok it's done. check your database. I also populated it with all the URL links to child-porn. the FBI is knocking at your door right now. check the BLOB columns. pretty nasty stuff stored there. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > Roland S -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
RE: Oracle Wants Users to Hand over Apps Management
I think that this is a marketing ploy by Oracle, much like the DBO (and frankly to a lesser degree the OCP) in an effort to deal with the simple supply/demand problem with Oracle DBA's. Somehow, the tag line on my emails seems to apply here... :-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, March 26, 2002 1:29 PM To: Multiple recipients of list ORACLE-L Oracle has been saying for years that you wil no longer need DBAs. I suppose it's possible, although the database gets more and more complicated each release, as more and more new features that can shoot themselves in the foot are added. On the other hand, SOMEONE will need those DBAs. Oracle? And isn't this just a little bit like that monopoly that Larry was so insistent on toppling? --- Mark Leith <[EMAIL PROTECTED]> wrote: > What got me was another quote by Jeff Henley: > > "This is really the way most customers are going to want to have > their > software delivered over time. The bulk of our customers are going to > operate > this way in the not-too-distant future," Henley said. "We offer much > faster > implementation, much lower cost and much better service." > > Another line that says "all DBAs will be redundant in the > not-too-distant > future"! Are they saying that Oracle support offers a much better > service > and response time than a well trained DBA can? Fair enough with bug > checking > and alike, but how long does it take for a lot of you to get iTARS > answered > etc.? > > -Original Message- > Dave > Sent: 26 March 2002 15:18 > To: Multiple recipients of list ORACLE-L > > > Another publicity blunder by Uncle Larry. > > -Original Message- > Sent: Tuesday, March 26, 2002 8:03 AM > To: Multiple recipients of list ORACLE-L > > > Oracle Wants Users to Hand over Apps Management > > > Putting muscle behind the outsourcing model of application > management, > Oracle Corp. said it is starting an international campaign to > persuade > customers to hand over maintenance of their Oracle software. > > "We have decided to go in and actively go after our installed base > and tell > them that this is a better way to [run Oracle applications]," said > Jeff > Henley, Oracle's chief financial officer, speaking to financial > analysts in > New York yesterday. "We will put the sales guys on it and invest > heavily in > capacity." > > For full story: > http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > 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
Re: pL/SQL PROCEDUR
And do you expect a link or a real example script??? On Tue 26. March 2002 19:29, you wrote: > Can someone please create a table for me? Umm...I need last and first name > columns. I don't want the DDL, I want you to connect to my database and > create it for me. I need this done yesterday. > > Thanks, really, thanks. Hurry up!! > > -Original Message- > Sent: Tuesday, March 26, 2002 11:59 AM > To: Multiple recipients of list ORACLE-L > > > LMAO > > Obligatory Oracle Question: > > Does anybody have a sample init.ora file that they use for a 9.0.1 > instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my > desktop PC play database.. > > -Original Message- > [EMAIL PROTECTED] > Sent: 26 March 2002 16:39 > To: Multiple recipients of list ORACLE-L > > > > Roland, > > What a surprise! I thought you were moving to an Access list? Because > I've taken a rather perverse interest in the questions you ask, I'll give > you a hint: triggers and exception handling. > > By the way, if no one has answered your question regarding a "table of > table definitions", it's probably because they are suffering from shock. > You are the DBA, are you not? This information already exists in a number > of cleverly designed Oracle supplied views. I suggest you become familiar > with the DBA_ views and the V$ views. A simple SQL query (which of course > you'll ask for someone to provide an example) should get you all the > information your heart desires. > > Study your craft my friend. > > > David A. Barbour > Oracle DBA, OCP > AISD > 512-414-1002 > > > > Roland.Skoldbl > [EMAIL PROTECTED]To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR > om > > > 03/26/2002 > 12:23 AM > Please respond > to ORACLE-L > > > > > > > Hallo, > > > Can anyone give me an example on a pl/sql code, which does the following: > > > > I have 4 procedures, and I want the following to be logged in a status > > table. > > > > Procedure names > > Start_time of procedure > > End_time_of procedure > > Error_code(if anything goes wrong) > > Error_message > > > > Please give me example onhow to write the code and also tell me how to > > pick > > > out the procedure_name, start_time of_procedure, end_time_ptocedure, > > error_code, error_message. > > > > Thanks in advance.And just dontgive me a link, i wantthis real example > > too. > > > Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
Dynamic SQL
Hello I'm using variable sqlstr VARCHAR2(4000) in procedure to create SELECT string. But the length of my SELECT * FROM is bigger than 4000 chars. Is there a way how to call OPEN my_cursor FOR sqlstr; for sqlstr longer than 4000 signs? JP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner 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).
8.1.7 LMTs Autoallocate vs Uniform Extents
Can someone point me to good reading material on this subject. Is one better than the other for performance and manageability? Syntactically the autoallocate is shorter and seems to be more hands off (does that mean worry free also?). TIA = Sundeep Maini Consultant Currently on Assignement at Marshfield Clinic WI [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sundeep maini 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: Customize my SQLPlus login
You don't. It's a habit you have to get into. And it only works if you haven't changed your directory. Like I said you can have another script that has login commands (INV-SYSTEM)>@elvis Enter password: * Connected. (INV-ELVIS)> My @elvis script is simply this connect elvis@inv @login I can set you up at Hotel Koivu in Ft. Lauderdale for a "cheap" rate in the dogs & cat room. We feature an outdoor pool that is near 80 degrees, tivo, access to antique convertible autos and DSL... but watch out for the very crabby housekeeper :) Lisa Koivu Oracle Database Tank. Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 1:39 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Customize my SQLPlus login > > How do you know you ran the login script?? Maybe you forgot? And your > really on production...when your about to truncate that table...that's > unrecoverable...that's billions of rowswith hundreds of recent > Fairfield > customer reservations...that will be very upset... > > BTW, any chance you can "slip" me into the system, for a paid hotel > reservation in Miami for a couple of days? > > -Original Message- > Sent: Tuesday, March 26, 2002 1:19 PM > To: Multiple recipients of list ORACLE-L > > > Nothing happens, the prompt stays the same unless you run @login, which I > do > to keep my head straight > > (INV-SYSTEM)>show user > USER is "SYSTEM" > (INV-SYSTEM)>connect elvis@inv > Enter password: * > Connected. > (INV-SYSTEM)>@login > (INV-ELVIS)> > > or create a script with the login name and sid that calls login.sql right > afterwards. > > Lisa Koivu > Oracle Database Baby Oven. > Fairfield Resorts, Inc. > 954-935-4117 > > > > > > -Original Message- > > From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, March 26, 2002 12:24 PM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: Customize my SQLPlus login > > > > What happens if the user then issues a connect statement to connect to > > another database? > > > > It would be nice if there was a .sql file run every time a new > connection > > is > > set, I don't know if that is the case in the 8i / 9i versions. > > > > Regards, > > Patrice Boivin > > Systems Analyst (Oracle Certified DBA) > > > > -Original Message- > > Sent: Tuesday, March 26, 2002 10:23 AM > > To: Multiple recipients of list ORACLE-L > > Subject:Re: Customize my SQLPlus login > > > > > > in your oracle /bin directory - you need to alter (Or create) a > login.sql > > file > > > > here's what mine looks like - feel free to alter > > > > /* start */ > > set heading on > > set pause off > > set pages 23 > > set lines 100 > > set verify off > > set feedback on > > set space 1 > > set serveroutput on size 100 > > set echo off > > > > set termout off > > column d_bname new_value d_bname > > select user ||'@'||instance_name d_bname > > from v$instance ; > > set sqlprompt '&d_bname.> ' > > set termout on > > set pause on > > /* end */ > > > > Brian. > > > > > > -- > > 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: Koivu, Lisa > 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: [E
RE: RE: RE: Stand-by (Oracle9i Data Guard) vs. Replication
Well, being in health care industry myself I know too well what do you mean. Apart from 100s of tousands of $ lost every hour we are down, we have to take some safety also into account. As to the question of advanced replication, having implemented multi-master replication myself I know what a nightmare it could turn out to be . Moreover it wasn't greate shakes in performance either. Only advantage you are looking at when considering a third party software. It is script driven so no info gets stored in data dictionary. How this could be a merit ?...well you don't get hung up on distributed transaction ( 2 phase commit ) problem solving - performance hit which is inevitable. More over I have seen the technology of reading redo logs/archive logs and it seems to be stable and fast. Finally I think it is matter of personal preference also. But I coul dbe wrong. Cheers, RS --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > >>1. Is the critical data would be updated in the > sites..? > Yes... > >> 2. If yes , are you expecting the other sites to > 'see' this update...? > Yes... > >> 3. If one site is down, then are you expecting > the other sites to share > the >> load or you have the closest site in take in > all the load...? > Yes > __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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 Wants Users to Hand over Apps Management
>From what I understand, the task is daunting keeping a release up to date. They've really built a beast. When you hear people on this list talking about "APPS DBA's", you get the feeling that it is something special. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 26, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Are they implying that Oracle Applications is proving too difficult to administer for many sites? ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Wants Users to Hand over Apps Management Another publicity blunder by Uncle Larry. -Original Message- Sent: Tuesday, March 26, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Oracle Wants Users to Hand over Apps Management Putting muscle behind the outsourcing model of application management, Oracle Corp. said it is starting an international campaign to persuade customers to hand over maintenance of their Oracle software. "We have decided to go in and actively go after our installed base and tell them that this is a better way to [run Oracle applications]," said Jeff Henley, Oracle's chief financial officer, speaking to financial analysts in New York yesterday. "We will put the sales guys on it and invest heavily in capacity." For full story: http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Mercadante, Thomas F 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: Customize my SQLPlus login
How do you know you ran the login script?? Maybe you forgot? And your really on production...when your about to truncate that table...that's unrecoverable...that's billions of rowswith hundreds of recent Fairfield customer reservations...that will be very upset... BTW, any chance you can "slip" me into the system, for a paid hotel reservation in Miami for a couple of days? -Original Message- Sent: Tuesday, March 26, 2002 1:19 PM To: Multiple recipients of list ORACLE-L Nothing happens, the prompt stays the same unless you run @login, which I do to keep my head straight (INV-SYSTEM)>show user USER is "SYSTEM" (INV-SYSTEM)>connect elvis@inv Enter password: * Connected. (INV-SYSTEM)>@login (INV-ELVIS)> or create a script with the login name and sid that calls login.sql right afterwards. Lisa Koivu Oracle Database Baby Oven. Fairfield Resorts, Inc. 954-935-4117 > -Original Message- > From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, March 26, 2002 12:24 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Customize my SQLPlus login > > What happens if the user then issues a connect statement to connect to > another database? > > It would be nice if there was a .sql file run every time a new connection > is > set, I don't know if that is the case in the 8i / 9i versions. > > Regards, > Patrice Boivin > Systems Analyst (Oracle Certified DBA) > > -Original Message- > Sent: Tuesday, March 26, 2002 10:23 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Customize my SQLPlus login > > > in your oracle /bin directory - you need to alter (Or create) a login.sql > file > > here's what mine looks like - feel free to alter > > /* start */ > set heading on > set pause off > set pages 23 > set lines 100 > set verify off > set feedback on > set space 1 > set serveroutput on size 100 > set echo off > > set termout off > column d_bname new_value d_bname > select user ||'@'||instance_name d_bname > from v$instance ; > set sqlprompt '&d_bname.> ' > set termout on > set pause on > /* end */ > > Brian. > > > -- > 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: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EXPORT FAST?
I think you can use direct=y option. Are you taking this export to a file (over disk) or directly to tape? Greeting Diego Cutrone - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 3:13 PM > Hi > one of export for 35GB database is taking 12 hours.How to reduce this export > time. > Thx > Seema > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.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: Diego Cutrone 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: Stand-by (Oracle9i Data Guard) vs. Replication
>>1. Is the critical data would be updated in the sites..? Yes... >> 2. If yes , are you expecting the other sites to 'see' this update...? Yes... >> 3. If one site is down, then are you expecting the other sites to share the >> load or you have the closest site in take in all the load...? Yes but add this requirement as a wrinkle, the sites have to be able to run independently of each other (e.g. a WAN failure) and then resync with each other after a period of time. Finally, this is a bit different than Amazon in that this system has some human safety considerations associated with it. Amazon outage might represent lost sales, outage of this system could represent lost lives. Needless to say, I'm being very careful about the architecture we use. I've implemented replication solutions before as well as stand-by database solutions. But the replication solutions to this point have been very simple and not nearly as complex... so I was hoping for someone to say, we do that and here are the issues we ran into. As for RAC, we will be running RAC at each site, and replicating between the RAC cluster. Sites are way to distant for RAC between them through a SAN or some such thing. RF What does shareplex buy me that Oracle's advanced replication does not? Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, March 26, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Robert, If I understand your requirements correctly, You have multiple sites separated geographically ( 200 Miles perhaps..?? ) and you are looking for a highly available , 'Multimaster' kinda environment. This kind of setup is common in oh-don't-say-the-name-companies i.e. 'dot bombs' and companies with regional offices around the world, with certain variations. I think off the top of the top of head I can say Amazon as an example. To clear some points before jumping to solutions, 1. Is the critical data would be updated in the sites..? 2. If yes , are you expecting the other sites to 'see' this update...? 3. If one site is down, then are you expecting the other sites to share the load or you have the closest site in take in all the load...? Depending upon the answer you have to make a choice. For example, I notice you have been discussing "RAC" as a possible solution. In this case ,since you have multiple sites , which is going to be the Primary..? or are you proposing to use a "RAC" for each site..? Wouldn't a third party assisted solution be more scalable and cost effective..? Like EMC or HP's XP storage solution has some kinda 'track' or 'Block' replicating mechanism between the storage, which is extendable in term of geographical location...? Or if you are looking to share the load like in question 3 above, then wouldn't it be easy to Get a 'replicating' software to help replicate the data in real time or near real time...? Example , like said before quest software's shareplex. This can give you master-master replication capabilities. Just my 2 cents. Cheers, RS --- "Freeman, Robert " <[EMAIL PROTECTED]> wrote: > Log application services can run in foreground or > background now, but I > don't think the > database can be open read-only at the same time > while doing managed > recovery, even in > 9i. > __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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: Freeman, Robert 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).
HDS ShadowImage and database backups
Hello All, Is anyone using HDS's ShadowImage for backing up large databases? Our Sys Admin Dgmt is pursuing this technique and is suggesting that all large databases be backed up using this software. Good? Bad? Any insights would be appreciated. My Damager is already crying foul as HDS will close the current fiscal year/quarter soon ;) Thanks. - Kirti -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: .dbf is a valid name for a datafile name?
Tom, if he is going to have the tablespace off line with database up and running , shouldn't the command be alter tablespace rename file '< >' to '< >' ; Cheers, RS --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > Hamid, > > .dbf is prefectly valid on all machines, as far as I > know. > > You can rename it - look at the ALTER DATABASE > RENAME FILE 'filename' to > 'newfilename' clause to rename the data file. You > will need to take the > tablespace offline to do this. > > Hope this helps > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Tuesday, March 26, 2002 11:39 AM > To: Multiple recipients of list ORACLE-L > > > I have added a datafile to a the temp tablespace > with the name of .dbf only > is ithis a valid name?, is there any way to rename > it without shutdown the > database,if yes HOW? > > Thanks > > > > Hamid Alavi > Office 818 737-0526 > Cell818 402-1987 > > The information contained in this message and any > attachments is intended > only for the use of the individual or entity to > which it is addressed, and > may contain information that is PRIVILEGED, > CONFIDENTIAL and exempt from > disclosure under applicable law. If you have > received this message in error, > you are prohibited from copying, distributing, or > using the information. > Please contact the sender immediately by return > e-mail and delete the > original message from your system. > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Hamid Alavi > 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: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj 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 Wants Users to Hand over Apps Management
Are they implying that Oracle Applications is proving too difficult to administer for many sites? ; ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject:RE: Oracle Wants Users to Hand over Apps Management Another publicity blunder by Uncle Larry. -Original Message- Sent: Tuesday, March 26, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Oracle Wants Users to Hand over Apps Management Putting muscle behind the outsourcing model of application management, Oracle Corp. said it is starting an international campaign to persuade customers to hand over maintenance of their Oracle software. "We have decided to go in and actively go after our installed base and tell them that this is a better way to [run Oracle applications]," said Jeff Henley, Oracle's chief financial officer, speaking to financial analysts in New York yesterday. "We will put the sales guys on it and invest heavily in capacity." For full story: http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).
Re: Customize my SQLPlus login
[EMAIL PROTECTED] wrote: > check sqlplus\admin under ORACLE_HOME yup, my bad. -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater 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: Customize my SQLPlus login
Create yourself a script called "connect.sql" that looks like: connect &1 @@glogin.sql Keep it in your SQL_PATH just like your glogin.sql. Now when you connect to something else just precede your "connect" statement with a "@" as in: @connect un/pw@db02 Can't be much easier than that. Brian P. MacLean Oracle DBA, OCP8i "Boivin, Patrice J" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: mpo.gc.ca> Subject: RE: Customize my SQLPlus login Sent by: [EMAIL PROTECTED] 03/26/02 10:23 AM Please respond to ORACLE-L What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To:Multiple recipients of list ORACLE-L in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt '&d_bname.> ' set termout on set pause on /* end */ Brian. -- 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: 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 Wants Users to Hand over Apps Management
Oracle has been saying for years that you wil no longer need DBAs. I suppose it's possible, although the database gets more and more complicated each release, as more and more new features that can shoot themselves in the foot are added. On the other hand, SOMEONE will need those DBAs. Oracle? And isn't this just a little bit like that monopoly that Larry was so insistent on toppling? --- Mark Leith <[EMAIL PROTECTED]> wrote: > What got me was another quote by Jeff Henley: > > "This is really the way most customers are going to want to have > their > software delivered over time. The bulk of our customers are going to > operate > this way in the not-too-distant future," Henley said. "We offer much > faster > implementation, much lower cost and much better service." > > Another line that says "all DBAs will be redundant in the > not-too-distant > future"! Are they saying that Oracle support offers a much better > service > and response time than a well trained DBA can? Fair enough with bug > checking > and alike, but how long does it take for a lot of you to get iTARS > answered > etc.? > > -Original Message- > Dave > Sent: 26 March 2002 15:18 > To: Multiple recipients of list ORACLE-L > > > Another publicity blunder by Uncle Larry. > > -Original Message- > Sent: Tuesday, March 26, 2002 8:03 AM > To: Multiple recipients of list ORACLE-L > > > Oracle Wants Users to Hand over Apps Management > > > Putting muscle behind the outsourcing model of application > management, > Oracle Corp. said it is starting an international campaign to > persuade > customers to hand over maintenance of their Oracle software. > > "We have decided to go in and actively go after our installed base > and tell > them that this is a better way to [run Oracle applications]," said > Jeff > Henley, Oracle's chief financial officer, speaking to financial > analysts in > New York yesterday. "We will put the sales guys on it and invest > heavily in > capacity." > > For full story: > http://www.computerworld.com/storyba/0,4125,NAV47_STO69446,00.html > > === > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] > === >http://www.cool-tools.co.uk >Maximising throughput & performance > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mark Leith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Farnsworth, Dave > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > 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). __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send
RE: Customize my SQLPlus login
I have a custom-coded @connect.sql script that I run instead of the build-in connect statement HOST chmod 600 /tmp/xxx.sql >/dev/null 2>/dev/null SAVE /tmp/xxx.sql REPLACE CONNECT &1 @login.sql /bin/rm -f /tmp/xxx.sql >/dev/null UNDEFINE 1 -Original Message- Sent: Tuesday, March 26, 2002 12:24 PM To: Multiple recipients of list ORACLE-L What happens if the user then issues a connect statement to connect to another database? It would be nice if there was a .sql file run every time a new connection is set, I don't know if that is the case in the 8i / 9i versions. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Tuesday, March 26, 2002 10:23 AM To: Multiple recipients of list ORACLE-L Subject:Re: Customize my SQLPlus login in your oracle /bin directory - you need to alter (Or create) a login.sql file here's what mine looks like - feel free to alter /* start */ set heading on set pause off set pages 23 set lines 100 set verify off set feedback on set space 1 set serveroutput on size 100 set echo off set termout off column d_bname new_value d_bname select user ||'@'||instance_name d_bname from v$instance ; set sqlprompt '&d_bname.> ' set termout on set pause on /* end */ Brian. -- 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: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: .dbf is a valid name for a datafile name?
In fact, here with Oracle 7.3 we had .dbf for data files, .ora for init.ora file and other config files, and .trc for trace files, .log for log files, etc. With the GUI tools introduced with Oracle 8, the extensions were different -- .ora for everything it seems to me, but I still prefer the different extensions for the different file types. Just my conservative opinion. Maybe .dbf brings back memories of dBase III+ ? : ) Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 26, 2002 1:38 PM To: Multiple recipients of list ORACLE-L Subject:RE: .dbf is a valid name for a datafile name? .dbf is perfectly OK -Original Message- Sent: Tuesday, March 26, 2002 10:39 AM To: Multiple recipients of list ORACLE-L I have added a datafile to a the temp tablespace with the name of .dbf only is ithis a valid name?, is there any way to rename it without shutdown the database,if yes HOW? Thanks Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi 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: Reddy, Madhusudana 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).
Re: Oracle Wants Users to Hand over Apps Management
[EMAIL PROTECTED] wrote: > and response time than a well trained DBA can? Fair enough with bug checking > and alike, but how long does it take for a lot of you to get iTARS answered > etc.? maybe they aren't answering iTARs so they look better delivering it themselves? "see we can do it faster than your DBA can." -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. The opposite of a correct statement is a false statement. But the opposite of a profound truth may well be another profound truth. - Niels Bohr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pL/SQL PROCEDUR
Can someone please create a table for me? Umm...I need last and first name columns. I don't want the DDL, I want you to connect to my database and create it for me. I need this done yesterday. Thanks, really, thanks. Hurry up!! -Original Message- Sent: Tuesday, March 26, 2002 11:59 AM To: Multiple recipients of list ORACLE-L LMAO Obligatory Oracle Question: Does anybody have a sample init.ora file that they use for a 9.0.1 instance, for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC play database.. -Original Message- [EMAIL PROTECTED] Sent: 26 March 2002 16:39 To: Multiple recipients of list ORACLE-L Roland, What a surprise! I thought you were moving to an Access list? Because I've taken a rather perverse interest in the questions you ask, I'll give you a hint: triggers and exception handling. By the way, if no one has answered your question regarding a "table of table definitions", it's probably because they are suffering from shock. You are the DBA, are you not? This information already exists in a number of cleverly designed Oracle supplied views. I suggest you become familiar with the DBA_ views and the V$ views. A simple SQL query (which of course you'll ask for someone to provide an example) should get you all the information your heart desires. Study your craft my friend. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Roland.Skoldbl [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: pL/SQL PROCEDUR om 03/26/2002 12:23 AM Please respond to ORACLE-L Hallo, > > Can anyone give me an example on a pl/sql code, which does the following: > > I have 4 procedures, and I want the following to be logged in a status > table. > > Procedure names > Start_time of procedure > End_time_of procedure > Error_code(if anything goes wrong) > Error_message > > Please give me example onhow to write the code and also tell me how to pick > out the procedure_name, start_time of_procedure, end_time_ptocedure, > error_code, error_message. > > Thanks in advance.And just dontgive me a link, i wantthis real example too. > > Roland S -- 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: 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Remote or Not? Was: Production Oracle DBA Needed in Rocheste
Hello everyone, This is a very interesting thread. Speaking as a part-owner of one of the companies John held up as an example of the successful outsourcers (thanks for mentioning us John), I'd like to make some points that I think will be of interest to all. The first is that working in a shop such as Pythian is actually a dream come true for many DBAs. The fact that the industry is trending to a managed service model for database administration is NOT A BAD thing for salaried DBAs out there. I think the opposite is true. The same thing happened for payroll specialists in the 80s and 90s, and now some 40% of companies outsource payroll. Those payroll specialist jobs simply migrated from individuals working solo in firms into working in teams for the Ceridians, Paychex and myriad competitors (i.e. almost every bank too) of the world. It's a great transition for many reasons that work well for the DBA as well as for the customer. I'll concentrate on the advantages for the DBA (why DBAs love working here), because they might not be as obvious. I can't speak for our competitors (hi!!! just kidding) :-) , but I believe a similar dynamic applies to them. A Pythian DBA gets experience on every major platform Oracle runs on: Solaris, HP/UX, Tru64, AIX, Linux, Win2k, I'm sure I'm forgetting some. A Pythian DBA gets experience on many versions of Oracle, in many industries simulaneously. We get to learn and develop best practices learned by seeing the way Oracle is used in many shops. We get to work in teams, relying on each other to help in emergencies, unstall each other, teach each other and develop each other's skills, and make sure we put our best foot forward for any customer simply because as a team we have an enormous amount of skills and experience. We get to learn and teach the very best in the industry, getting to know and understand that even the giants don't know everything while still having so much to share. We get to know our customers so well we mutually consider ourselves teammates, co-workers and sometimes even friends, greatly leveraging our network of contacts and friendships. We get to take on new shops on a continuous basis, whenever the company signs on a new customer, instead of having to quit a job when it gets boring. The way I've structured our company, in many small teams, we even get to take on completely new challenges and team dynamics simply by changing teams, rather than having to look elsewhere. We get to not be on-call every night, to not get shit for taking holidays, to not have to work insane hours (our team model is scalable in a way that the single-person salaried model is not.) We get to work on some of the most challenging environments in the world. I'm not kidding; I'm sure Jeremiah at Amazon has his hands full, but I am confident any DBA here would have something to talk with him about if they sat together at a dining-room table. Moreover, we get the satisfaction of doing an extraordinarily good job. I considered myself an accomplished DBA before having started this company. And yet I am completely certain that never was I able to do as good a job as we are doing now as a team. We provide sophisticated problem tracking tools, availability monitoring tools and and performance monitoring tools that never when I was an individual could I have contributed. It's extremely satisfying and fun. Moreover, much of our work is with DBAs (or teams of DBAs!) at customer sites. We work with many shops where we are not the sole DBA resource, but rather a part of a larger team, sometimes with us doing mentoring, back-up and on-call support for a DBA early in their career. Sometimes, it's when a company has an (or many) expert DBA that's completely swamped, and we help with the 24/7 and routine but lengthy aspects of the work and let them focus on the project management, strategic data modeling and other tasks that are more than enough to keep them on the right side of the very busy/having a breakdown boundary. I can't recommend it enough; I haven't had a better job or been happier at work than I am here. Hope this give you some insight into our company and what we're trying to do here. Best regards, Paul --- www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 2:53 AM Personally I like being in the office environment and interacting with other members of my species :-) I do get the opportunity to work from home on a fairly regular basis and I do take it when I really need to focus on something but I do miss the buzz of being in the workplace if I'm away for too long. Working from home is ideal around the holidays and those days when you have overindulged in wh
Re: Rename Oracle User
Surprised to not see a backup of the DB and $ORACLE_BASE after #2.
You can combine #3 & #4 with "find / -user oracle2 -exec chown oracle:dba
{} \;" as long as oracle2 is the only member of the dba2 group and you're
not using the "oinstall" as oracle2's default group.
I think #4 should be "-group dba2" not "-user dba2".
Not sure what #5 means.
To be safe #6 should be a recompile of the Oracle executables. Something
like the following, but see ->
http://metalink.oracle.com/metalink/plsql/ml2_documents.showNot?p_id=131321.1&p_font
(Note:131321.1 Subject: How to Relink Oracle Database Software on Unix)
for details:
---THIS IS A SOLARIS KSH SHELL EXAMPLE---
export PATH=/usr/ccs/bin:${PATH}
which ld #should return '/usr/ccs/bin/ld'
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}
#If using 64bit Oracle, LD_LIBRARY_PATH should also include
$ORACLE_HOME/lib64.
cd $ORACLE_HOME/bin
relink all
"Todd Carlson"
os.com> cc:
Sent by: Subject: Rename Oracle User
[EMAIL PROTECTED]
om
03/26/02 08:23
AM
Please respond
to ORACLE-L
Solaris 5.8 Oracle 8.1.7.2
Has anyone successfully renamed the Oracle user on a solaris box? At the
moment I don't a test box and this is a rarely used development system.
The current Oracle user and group are oracle2 and dba2. We have to
change it to match our standards, i.e. oracle & dba.
The plan is to (after a full system backup):
1) Create the correct local user & group with the same home directory.
2) Shutdown all Oracle processes.
3) Find . -user oracle2 -exec chown oracle {} \;
4) Find . -user dba2 -exec chgrp dba {} \;
5) Modify all scripts to use the correct group & user.
6) Pray.
7) Start the database and listener.
8) Check for functionality & errors.
9) Shut everything down and take a full system backup.
Am I missing anything? Is there any problems with the method?
Thanks,
Todd Carlson
Oracle Database Administrator
Tripos, Inc.
(314) 647-8837 Ext.3246
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Todd Carlson
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 o
EXPORT FAST?
Hi one of export for 35GB database is taking 12 hours.How to reduce this export time. Thx Seema _ Chat with friends online, try MSN Messenger: http://messenger.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).
