RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS **CLOSED**
Thanks everyone. I did decide on CHOOSE. It seemed like the best choice considering most of our queries aren't run interactively through tools like SQL*Plus. In fact it should become an even better choice as our applications are becoming more and more browser based. ALL_ROWS also looked like it would be the best choice considering our batch reporting requirements. Michael Armstead Principal Database Administrator, OCP-Certified World Wide Corporate IT Database Administration GlaxoSmithKline -Original Message- From: John Kanagaraj [SMTP:[EMAIL PROTECTED]] Sent: Monday, November 04, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: What's your opinion: ALL_ROWS vs. FIRST_ROWS Hi Mike, Your article was very good in describing RBO vs. CBO. I hope you don't mind me using it to help better describe why we're switching from RBO to CBO to my team. I forgot to mention this before, but you should also look at Tim Gorman's excellent paper on the CBO at http://www.evdbt.com - search in the library. On the other hand it didn't help me much in practical use of ALL_ROWS (CHOOSE) vs. FIRST_ROWS. I understand this was out of the scope of the paper. Yes, but we can always discuss this here in the list :) The problem I have with the FIRST_ROWS is that _all_ queries would default to use this mode. While this may be good for a specific interactive query, it certainly would perform poorly for batch jobs, more so when the table joins larger tables. IMHO, you are better off leaving it to default to CHOOSE and control specific modes. This can be done via a variety of methods, including login triggers, Outlines, anf finally the code itself. Note: When leaving your web page I was notified that my IP address was captured. I didn't like that. My web page is served by Yahoo! Geocities, and I obtained that when it was free (and still is free). I suppose that they capture some info and do manipulate cookies. This is the first time, though that I have come across such a message. I will need to investigate further... Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What's your opinion: ALL_ROWS vs FIRST_ROWS
We're moving from RBO to CBO. For those of you who use CBO, what mode do you use FIRST_ROWS or ALL_ROWS? And why? My thinking is if it's a database where most of the querying is done on small sets of records, then we may want to use FIRST_ROWS. On the other hand, if our database is used to generate sizable reports, we might use ALL_ROWS. I also understand that we can always change it per session (with alter session) and per query (with hints). Michael Armstead Principal Database Administrator, OCP-Certified World Wide Corporate IT Database Administration GlaxoSmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to get rid of a column default value ?
My guess is to alter it DEFAULT NULL. Michael Armstead Principal Database Administrator, OCP-Certified World Wide Corporate IT Database Administration GlaxoSmithKline -Original Message- From: Louis BROUILLETTE [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 04, 2002 11:29 AM To: Multiple recipients of list ORACLE-L Subject: How to get rid of a column default value ? Anyone knows how to get rid of a column default value ? I rtfm and search metalink with no luck. Louis Brouillette Analyste en informatique (DBA) Universite du Quebec a Trois-Rivieres Tel: (819) 376-5011 ext. 2435 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Louis BROUILLETTE INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: 9i On Linux
Joe, Did you get time to do your RH Linux tests this weekend? If you're in Dresden, you probably didn't have much else to do. If you did test, how'd it go? Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: JOE TESTA [SMTP:[EMAIL PROTECTED]] Sent: Friday, June 15, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9i On Linux i've got 256M, dont run SUSE but will attempt it on rh 7.1 this weekend. joe [EMAIL PROTECTED] 06/15/01 04:20PM Can any of you just confirm that Oracle 9i requires 500M of memory on Linux? Thank, Waleed -- 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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ps -ef | grep sqlplus
We recognized the same problem and found this program as an answer: http://www.orafaq.org/scripts/c_src/hide.txt Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Kris Austin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 2:38 PM To: Multiple recipients of list ORACLE-L Subject: ps -ef | grep sqlplus hi, do you know how to hide oracle passwords from ps -ef? we pass in our pw in cron, and it shows up when you run ps -ef (to check unix processes). i recognize that is this NOT a smart thing to do... can anyone recommend a better way of supplying oracle passwords when scripts are connecting to oracle? do you use config files that store pws? just curious what everyone else is doing to plug this security hole. thanks, kris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kris Austin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OLE vs. ODBC
Does anyone know where I can find documented information on Oracle's current stance on ODBC vs. OLE? I am under the impression that they lean toward ODBC now. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle, applications user group resume conference feud
. But in a response http://www.oaug.org/member_comm.html posted on the OAUG's Web site, Young said Oracle's proposal is largely similar to the one rejected by the user group's members last year. Young also claimed that the written version of the firm's proposal contained a variety of errors and omissions, and he said OAUG officials continue to be disappointed by Oracle's inability to compromise. In addition, Young took Oracle to task for not giving the OAUG advance notice of its plans to go public with the proposal. We had sought to avoid going into details on the discussions in public, as we felt that might jeopardize progress, he wrote. I am not clear what your purpose was in doing so ... I am forced to wonder whether Oracle [is] really negotiating in good faith in this matter. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: My Website
Chris, It's just my opinion, but that regular blue font on blue background is a little hard to focus. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Christopher Spence [SMTP:[EMAIL PROTECTED]] Sent: Saturday, May 19, 2001 4:00 AM To: Multiple recipients of list ORACLE-L Subject: My Website Some of you already know me from Lazyda list, some of your don't (prob glad). Well I have been working on putting up yet! another dba portal site. I have articles, scripts, and forums. I been really busy lately fire fighting a huge new product of ours, so I haven't got as much content as I wanted to have by now, but i do have about 45 articles and 30 or so scripts. Most of the famous and popular (or ones I liked) articles are already up their as I always had them an arms reach away. Feel free to contact me (please use email on site) for any additions one may feel appropriate. And unlike OTHER lists, none of the information on the site I claim as my own unless it is of course, my own. Everyone who participates gets due credit and there are no royalties with the site either (go figure heh?). Now that everyone is asleep from me running on, here is the URL: www.vampired.net Aka Vampire D's Oracle Den. Christopher, -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MICROSOFTDTPROPERTIES
I have developers who have created this table. Now they've come to me to find out what the table does. I think it is used by the Microsoft Transaction Server software. Does anyone know for sure the purpose of the MICROSOFTDTPROPERTIES table? Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export Split Script
Rajaram, Please give me details on how to use mknod to split export files larger than 2 GB. We have broken our jobs into over 50 separate export jobs on the table level just to keep our files less than 2GB. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: Export Split Script If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files 2GB. Rajaram (Now that I am at the top of a mountain - I dont know how to get down!) -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject: Export Split Script I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Export Split Script
Thanks, Rachel. You're a sweetheart. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 5:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Export Split Script there is a note out on Metalink on how to do this. You can also break the export into separate files in later versions of Oracle8i. or you can run the following script (modified to suit your system, it was last tested on Solaris/Oracle 7.3.4) #!/bin/sh # cd $EXPORT_DIR # # set maximum file size for each chunk of the export file # MAXFILESIZE=2000m export MAXFILESIZE # # create filenames for the parts of the backup... for now let's go to 3 # FILENAME1=$EXPORT_DIR/backup1_$ORACLE_SID.dmp FILENAME2=$EXPORT_DIR/backup2_$ORACLE_SID.dmp FILENAME3=$EXPORT_DIR/backup3_$ORACLE_SID.dmp LOGFILE=$EXPORT_DIR/backup_$ORACLE_SID.log # # save off the old ones # mv $FILENAME1 $FILENAME1.old if [ -f $FILENAME2 ] then mv $FILENAME2 $FILENAME2.old fi if [ -f $FILENAME3 ] then mv $FILENAME3 $FILENAME3.old fi mv $LOGFILE $LOGFILE.old # # create the pipes # mkfifo exportpipeaa mkfifo exportpipeab mkfifo exportpipeac mkfifo wrkpipe umask 000 # # start the readers from the pipes to create the export files # dd if=exportpipeaa of=$FILENAME1 dd if=exportpipeab of=$FILENAME2 dd if=exportpipeac of=$FILENAME3 # # start the reader from the wrkpipe to compress and split the export # dd if=wrkpipe|compress|split -b $MAXFILESIZE - exportpipe # # start the export for real # exp / file=wrkpipe full=y compress=n buffer=4096000 LOG=$LOGFILE # # clean up after ourselves # rm exportpipeaa exportpipeab exportpipeac wrkpipe # # if you haven't used all the pipes, the dd may still linger on # make sure to REALLY clean up # ps -ef|grep exportpipe|grep -vi grep|awk '{printf (kill -9 %d; \n,$2)}'kill.lst chmod u+x kill.lst sh kill.lst rm kill.lst now to import from those split files #!/bin/sh # cd $EXPORT_DIR # # create filenames for the parts of the backup... for now let's go to 3 # FILENAME1=$EXPORT_DIR/backup1_$ORACLE_SID.dmp FILENAME2=$EXPORT_DIR/backup2_$ORACLE_SID.dmp FILENAME3=$EXPORT_DIR/backup3_$ORACLE_SID.dmp LOGFILE=$EXPORT_DIR/backup_$ORACLE_SID.log # # create the pipe to import from # mkfifo wrkpipe umask 000 # # start the reader from the import pipe # imp / file=wrkpipe full=y commit=y buffer=4096000 LOG=$LOGFILE # # create the import stream coming from the pipes # cat $FILENAME1 $FILENAME2 $FILENAME3 | uncompress | dd of=wrkpipe # # clean up the import pipe # rm wrkpipe From: Armstead, Michael A [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Export Split Script Date: Wed, 16 May 2001 13:07:24 -0800 Rajaram, Please give me details on how to use mknod to split export files larger than 2 GB. We have broken our jobs into over 50 separate export jobs on the table level just to keep our files less than 2GB. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Rajaram [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 4:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: Export Split Script If you are using Oracle on Unix , You may want to use unix pipes ( mknod). - most people use this method to manage files 2GB. Rajaram (Now that I am at the top of a mountain - I dont know how to get down!) -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, May 16, 2001 3:57 PM To: Multiple recipients of list ORACLE-L Subject: Export Split Script I tries using a compressed export and the output is still over 2G. Does anyone have the export script that splits the export files into multiple files? Ron Smith Database Administration [EMAIL PROTECTED] NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: a bit of a brag...
Congratulations. Apparently you did a great job. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Thater, William [SMTP:[EMAIL PROTECTED]] Sent: Monday, May 14, 2001 4:20 PM To: Multiple recipients of list ORACLE-L Subject: OT: a bit of a brag... My eldest graduated from college Saturday. A double major in Spanish and German, cum laude, and a Fullbright scholar. I'm proud of the boy!;-) Follow the link below for a nice picture and a little blurb. http://www.naz.edu/academics/fulbright/scholars.cfm -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[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. ~~ Microwave: Signal from a friendly micro... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop schema and all related objects
DORP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Mujeeb Chowdhry [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Subject: Drop schema and all related objects Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Drop schema and all related objects
Let's try to spell it correctly this time: DROP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Armstead, Michael A Sent: Friday, May 11, 2001 9:24 AM To: '[EMAIL PROTECTED]' Subject: RE: Drop schema and all related objects DORP USER username CASCADE; Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Mujeeb Chowdhry [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Subject:Drop schema and all related objects Hi DBA's, How can I drop schema (user and all it's objects). I have one main user in the application and wants to drop user and all related objects. Can anyone help me in this regard. Thanks Mujeeb Chowdhry Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Silver vs. Gold support
We have Metalink access with bronze. Michael Armstead Application Database Administrator, OCP-Certified US Pharmaceuticals IT Glaxo SmithKline -Original Message- From: Cyril Thankappan [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 10, 2001 4:16 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: Silver vs. Gold support Hi Is metalink available under 'bronze' support? How do u live 'with bugs' without metalink support? Thanks - Original Message -- Cale, Rick T (Richard) [EMAIL PROTECTED] wrote: To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] From:Cale, Rick T (Richard) [EMAIL PROTECTED] Date:Thu, 10 May 2001 11:35:31 -0800 Subject:RE: Silver vs. Gold support We still have Bronze support which you can no longer get but we would not even consider upgrading to Gold because their phone support is not very good at all. There are too many resources available where you can actually get a correct answer much sooner. Rick -Original Message- Sent: Thursday, May 10, 2001 2:39 PM To: Multiple recipients of list ORACLE-L Kim, I have not seen a reason to get GOLD support from Oracle. Unless you've got a boss who doubts your capabilities. Sounds like time to brush off the resume!! Dick Goulet Reply Separator Author: Kimberly Smith [EMAIL PROTECTED] Date: 5/10/2001 9:16 AM My manager is thinking of moving us up to Gold support. Does anyone out there have it and if so could you give me you general impression on having that over Silver. She says that at sites she used to work at it means having a dedicated resource on site. Their phone support for SEV1 calls is basically sucks unless you hit the day shift. Kimberly Smith Database Administrator EDS - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cyril Thankappan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX
RE: Unix memory used
Just from looking at what you've described, you don't use the memory you have on the machine. But I'm on the outside looking in. If your databases are memory bound, my recommendation is to look into tuning your database memory first, and expanding each SGA. I'm also assuming that this is only a database server. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject: Unix memory used Hello list, We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6. The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one more help desk app. As the below shows, or SGA's are very small (same for all 4 databases): SVRMGR show sga Total System Global Area 6278336 bytes Fixed Size 39816 bytes Variable Size 4567352 bytes Database Buffers 1638400 bytes Redo Buffers 32768 bytes I'm looking for some ammunition to make a case to increase the RAM. Yes, some database response is slow, however before I start tuning, especially memory sizes, I really think any efforts will be wasted if the memory is constantly thrashing to disk. I've been given access to top, and it reports the following: Memory: 1024M real, 15M free, 198M swap in use, 571M swap free (at 8:30 am on weekday) I guess I'm asking if I can say with validity that our memory is presently being used up, and the "198 MB swap in use" is a real number. Also, our SAs don't monitor memory use, so if anyone has any good tool, tricks, book references, etc...that I can use to see this kind of thing, I'd appreciated it. Thanks, Mike Lanteigne The views expressed here are mine and do not reflect the official position my employer or the organization through which the internet was accessed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Unix memory used
I guessed (emphasis on "guess") that you weren't using the memory you had because you originally showed your SGAs were very small. I looked at a Sun server that I run 2 databases on and the Total SGA for my training database was 35 MB, while my production was over 100Mb. Another thing I said, that was very important is, was I assume that this is only a database server. If your application is running here too, then you have to consider the apps memory requirements too. If your machine is exclusively a database server, then you should be able to divide the memory for Oracle processes, Oracle User processes, and the OS. Considering what I said, I recommend that you start your evaluation by tuning the memory of your databases because you don't know that you need more memory yet. You may be able to change some init.ora parameters and give yourself some huge performance gains. Management tends to like that! :-) Good luck! Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Subject: RE: Unix memory used Michael, Yes, that's what I want to do. In fact, I've pin pointed some areas, such as redolog buffers that can user larger memory segments. However I do not want to do this at the expense of the servers total memory use. That's why I'm wondering about the overall memory use (all databases and apps). Just out of curiosity, what makes you say I'm not using all the memory I have? Thanks Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. -Original Message- From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 11:35 AM To: Multiple recipients of list ORACLE-L Subject:RE: Unix memory used Just from looking at what you've described, you don't use the memory you have on the machine. But I'm on the outside looking in. If your databases are memory bound, my recommendation is to look into tuning your database memory first, and expanding each SGA. I'm also assuming that this is only a database server. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Lanteigne, Mike [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, April 04, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject: Unix memory used Hello list, We have a Sun e3500 with 4x300 MH processors, 1 GB Ram and OS 2.6. The server runs 4 small instances ( 7.3.4.5), two PeopleSoft apps and one more help desk app. As the below shows, or SGA's are very small (same for all 4 databases): SVRMGR show sga Total System Global Area 6278336 bytes Fixed Size 39816 bytes Variable Size 4567352 bytes Database Buffers 1638400 bytes Redo Buffers 32768 bytes I'm looking for some ammunition to make a case to increase the RAM. Yes, some database response is slow, however before I start tuning, especially memory sizes, I really think any efforts will be wasted if the memory is constantly thrashing to disk. I've been given access to top, and it reports the following: Memory: 1024M real, 15M free, 198M swap in use, 571M swap free (at 8:30 am on weekday) I guess I'm asking if I can say with validity that our memory is presently being used up, and the "198 MB swap in use" is a real number. Also, our SAs don't monitor memory use, so if anyone has any good tool, tricks, book references, etc...that I can use to see this kind of thing, I'd appreciated it. Thanks, Mike Lanteigne The views expressed here are mine and do not reflect the official position my employer or the organization through which the internet was accessed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lanteigne, Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL
RE: SQLPLUS hangs
Please clarify "it just sits there". Do you lose your cursor? Does it come back to a Unix prompt? Are you running Unix? Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: SHAIBAL TALUKDER [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Subject: SQLPLUS hangs Hi Folks, Could you pls shed some light. My SQLplus log in hangs when I am trying to log in. As soon as type SQLPlus it just sits there. Ant help would be appreciated. Thanks Shaibal _ Do You Yahoo!? Yahoo! Mail Personal Address http://personal.mail.yahoo.com/?.refer=mailiyfoot - Get email at your own domain with Yahoo! Mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Revoke - Alter - Users
Please correct me if I'm wrong. I thought you could only revoke that access if you were the schema owner. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Apps Sol [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Subject: Revoke - Alter - Users I am trying to revoke alter table capability for some users as system and sys and it's not . What's the best way to stop users from altering any table structure and disabling any constraints ?? RK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Apps Sol INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sqlloader
If it is already installed, it should be in your $ORACLE_HOME/bin directory. The executable is named sqlldr. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Friday, March 30, 2001 8:31 AM To: Multiple recipients of list ORACLE-L Subject: sqlloader Hallo, Can anyone tell me how to get sqlloader, how can I try and find out to see if I have it already installed ? How do i Install it? Roland Skldblom -- 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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Db stat change query
Yes. Unless you can risk having a time where you can't recover your database. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, March 28, 2001 3:25 PM To: Multiple recipients of list ORACLE-L Subject: Db stat change query Hi gurus Is it necessary to take full backup when we change the database from archivelog mode to noarchivelog mode and vice versa. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Read the documentation on the 'orapwd' utility. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Nihar [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 26, 2001 4:41 AM To: Multiple recipients of list ORACLE-L Subject: hi ppl can any body help in changing internal pwd on solaris system. i couldn't find oradim on sun. Is there any similar tools like oradim on solaris.. thanks - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmagicsolutions.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nihar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Start with "Oracle8 Server Utilities" that comes with the Oracle Documentation Set. You may be able to find it at http:\\docs.oracle.com. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Chesebro, Eric [SMTP:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Any one know where to find good documentation on sqlloader? Thanks, Eric -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chesebro, Eric INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - Tuning SQL - ISSUE CLOSED
Thanks for the help guys. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Armstead, Michael A [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 2:51 PM To: Multiple recipients of list ORACLE-L Subject: Help - Tuning SQL I've got some simple questions on tuning SQL. Please reply with references, I'm not looking for guesses. * If you have a SELECT statement with a WHERE clause and 2 AND clauses, which one is processed first, the WHERE clause, the first AND clause, or the second AND clause? * Is there any performance loss in using "" over "!="? Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Help - Tuning SQL
I've got some simple questions on tuning SQL. Please reply with references, I'm not looking for guesses. * If you have a SELECT statement with a WHERE clause and 2 AND clauses, which one is processed first, the WHERE clause, the first AND clause, or the second AND clause? * Is there any performance loss in using "" over "!="? Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dba_errors
It's updated each time an error occurs when an object is compiled. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Boivin, Patrice J [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, February 21, 2001 10:37 AM To: Multiple recipients of list ORACLE-L Subject: dba_errrors Does anyone have an idea of how often this view is updated? Not just upon instance startup, I hope. Just curious. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: System Tablespace
ORACLE-L FAQ: http://www.orafaq.com -- Author: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo logging with version 8.1.6.x
We can see a significant increase in generated redo information on both Solaris and HP-UX platforms. I think it has also been documented. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: Koivu, Lisa [SMTP:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 10:36 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo logging with version 8.1.6.x Hi Dan, What os? What did you upgrade from? I didn't see anything significant change with redo when we upgraded... Lisa Rutland Koivu Oracle Database Administrator Qode.com 4850 North State Road 7 Suite G104 Fort Lauderdale, FL 33319 V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849 http://www.qode.com "The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com." -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Sent: Monday, February 19, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: Redo logging with version 8.1.6.x Just rolled out version 8.1.6 to our first "serious" application. It appears that more redo is being generated with the newer software. Does that sound accurate? Or is my application owner not telling me the truth regarding his activities? -- 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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to know the physical device using Oracle ?????
The HOST_NAME column of V$INSTANCE contains the machine where the database is running. Michael Armstead Database Administrator, OCP-Certified Corporate Finance Information Systems Glaxo SmithKline -Original Message- From: bipin sahani [SMTP:[EMAIL PROTECTED]] Sent: Thursday, February 15, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Subject: How to know the physical device using Oracle ? Hi All, Is there a way to know the machine or device through a oracle query??? That means something similar like the info which I get when I type uname -a on Unix machine I want to know through a query I'm accessing Oracle on which physical machine. Thankx in advance Regards Bipin Do You Yahoo!? Get your free @yahoo.co.in address at http://mail.yahoo.co.in -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Armstead, Michael A INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).