Re: sqlldr
Ravi, To the best of my knowledge, there is no limitation on the number of records that can be loaded at a time other than the size of your rollback segments. I have loaded 10's of millions of rows in a single sqlldr job by setting some parameters. There are defaults that work, but don't perform very well. To determine appropriate settings, you may want to read an article I wrote for O'Reilly & Associates (located at http://oracle.oreilly.com/news/oraclesqlload_0401.html) which gives the step-by-step directions on setting 2 of the key parameters (BINDSIZE and ROWS). It's a pretty easy thing to do, but without knowing you data, the only advice I could give is that DIRECT is the best quick tuning fix if you can. If you are going to be doing any serious data loading with SQL*Loader, Jonathan's book Oracle SQL*Loader: The Definitive Guide would be a good investment. HTH Stephen>>> [EMAIL PROTECTED] 04/25/02 10:13PM >>>i belive there is a limitation on the number of records that can be loadedfrom sqlldr at a time based on the bind array and rows default parameter.if i have a data file with more than 5000records(don't know the exactnumber) that needs to be imported using sqlldrwhat is the value i need to set for the "rows" and/or "bind array" for me toload the records to the table at one attempt.thanksravi-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ravindra B INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Wait Event - Slave
Everything I've read tells me that slave wait events are non-issues, that I shouldn't worry about them. I'm wondering if they may be pointers to some issues I think we are facing. We are using Compaq WildFire boxes with multiple QBB's running Tru64 Unix. These boxes use NUMA architecture and the os has not yet been patched so that NUMA and Oracle will work well together (layman's terms :) Can anyone tell me if the excessive slave waits (they are always in my top 5 and usually the top one by several orders of magnitude) might be related to this? TIA for comments. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: List slow today?
Other than during IOUG-A, I haven't seen this few messages. Is my mail server eating messages or is it just a slow day? Stephen
RE: OT -- training
Christopher, On that same thought, I read the best response to a company who won't train their people because "then they'll leave". Which would you rather have happen? Train people and have them leave or not train them and have them stay? I know where I'd rather work. Stephen Andert >>> [EMAIL PROTECTED] 08/13 12:53 PM >>> Very common what you explained. I think businesses are afraid to do training as they think you will become more marketable and opt to leave. If they are afraid of that, they should fix the problems or give more money to make it so you would not want to leave. If they themselves think your going to leave because of training, they must already know it sucks and they should fix it. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, August 13, 2001 2:42 PM To: Multiple recipients of list ORACLE-L Patrice, There is "resistance" to any training that I feel is necessary to further my knowledge and/or enhance my understanding of the Oracle processes. Even though I have money in the budget for such items I have to submit a business case defining the gains to the company and after completing the course with a passing grade the company will reimburse me the expenses for the course only. I also have to sign a waver that I will pay the company back the full cost of the course if I leave their employment before 365 days. Needless to say I pay for everything myself and hope to write it off on taxes if they ever get the bill signed into law. ROR mª¿ªm >>> [EMAIL PROTECTED] 08/13/01 11:46AM >>> Just out of curiosity, how many days / weeks of real training did your employer provide you with in the last couple of years? "real" is in quotes, I don't mean the little 1 - 3 day seminars given by CareerTrack and other "training" companies, or management-related stuff like little MBA-flavoured certificates from universities. Oh, and did the amount of training you received match what you were told during your job interview? 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] <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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
Re: Netbackup with Oracle 817
Nbir, Well I'm no expert on backups, but we are in the process of rolling out rman and Veritas Netbackup across our company. This includes several databases that are well over 200GB. We have an ATL (Automated Tape Library) with around 300 slots and currently 10 drives. We are having some, as yet undetermined, "issues" with NetBackup taking drives offline. The rman piece seems to be working when the NetBackup piece cooperates. We are also working out differences between different dbas with regards to backup philosophy. For example, rman does not need to shut the database down to get a "good" backup. For some of us, this was difficult to comprehend how you can get a consistent backup while the database is up and running. Also, different groups have different practices on how many archived redo logs to keep. With rman, we are trying to standardize on length of time to keep them after they are backed up. I haven't been involved with the script-writing pice, so I can't help you there, but I hope to get my hands a bit more dirty with B&R after I pass my performance tuning test. Good Luck Stephen>>> [EMAIL PROTECTED] 08/14/01 02:53PM >>>Hi Experts,Can somebody guide me towards Oracle database backupof around 200G with Netbackup and I really appreciateany document for Rman Scripts/Backup document likerestore or other test scenario. I know lots of big company has implemented it and I amtold to submit mine document in a week and sodesperately need all of ur advice and very greatfullif someone can help me all test scenario plus scriptThanks a ton in advanceNbir
RE: Comment on 'Practical Oracle 8i'
That's nothing, I've got 3 486's in my garage. Stephen If you have any questions, please feel free to call me or drop me a note. Stephen Andert480-445-2506>>> [EMAIL PROTECTED] 08/16/01 01:06PM >>> i got a 75Mhz pentium sitting in my desk drawer :) joe >>> [EMAIL PROTECTED] 08/16/01 03:45PM -Original Message-> From: Christopher Spence [mailto:[EMAIL PROTECTED]]> Sent: Thursday, August 16, 2001 1:52 PM> To: Multiple recipients of list ORACLE-L> Subject: RE: Comment on 'Practical Oracle 8i'> > For example. 100MHz Pentium is no where near 1/15 the speed > of the 1.5GHz> AMD. So it remains a very difficult test to make.> Where in the world did you come across 100MHZ Pentium? Natural historymuseum,next to the T-Rex skeleton?-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Gogala, Mladen INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: OT: DBA tasks
Zig Ziglar (a great motivational speaker in case you aren't familiar with the name) refers to his wife of many years as a decided red-head "That is one day she woke up and decided to be a red-head." Stephen If you have any questions, please feel free to call me or drop me a note. Stephen Andert 480-445-2506 >>> [EMAIL PROTECTED] 08/20 1:17 PM >>> Grandpa was a redhead... I was born brunette but when I get in the sun it goes red... so I sometimes "help it along" >From: "Koivu, Lisa" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: OT: DBA tasks >Date: Mon, 20 Aug 2001 11:32:49 -0800 > > I'm only blonde on football game days, when I put on my blonde stripper >wig >and braid it :) A nice Nicole Kidman red would be a wise choice. > >I'm brunette and proud of it! Just anything but blonde. HA > > > -Original Message- > > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > > Sent: Monday, August 20, 2001 2:51 PM > > To: Multiple recipients of list ORACLE-L > > Subject:Re: OT: DBA tasks > > > > you go girl! :) > > > > do I have to have Barbie-blond hair though? I'm thinking a nice, > > brilliant > > red myself > > > > > > >From: "Koivu, Lisa" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: OT: DBA tasks > > >Date: Mon, 20 Aug 2001 09:38:58 -0800 > > > > > >Ahem... the female DBA's save the database, save the world, flatten >the > > >evil people with her well-tuned martial arts skills, swims in icy cold > > >water > > >without showing one goose pimple on her Barbie-proportioned body, > > impresses > > >the Diet Coke guy, and then tells him "thanks but no thanks" > > > > > >and skips through the commercials on her Tivo after such an eventful >day. > > > > > >Sorry, couldn't let this one go There's a script in here waiting >to > > >come out but I'm playing with Perl and feel that Chris Bowes is better > > >suited for this task :) > > > > > >Lisa Koivu > > >aka. Angelina Jolie. > > >Ft. Lauderdale, FL, USA > > > > > > > > > > -Original Message- > > > > From: Adams, Matthew (GEA, 088130) [SMTP:[EMAIL PROTECTED]] > > > > Sent: Monday, August 20, 2001 11:59 AM > > > > To: Multiple recipients of list ORACLE-L > > > > Subject:RE: DBA tasks > > > > > > > > And we do it in 30 minutes and still have time > > > > for commercials > > > > > > > > > > > > Matt Adams - GE Appliances - [EMAIL PROTECTED] > > > > Doing linear scans over an associative array is like > > > > trying to club someone to death with a loaded Uzi. > > > > - Larry Wall (creator of Perl) > > > > > > > > > > > > > -Original Message- > > > > > From: Guy Hammond [ <mailto:[EMAIL PROTECTED]>] > > > > > Sent: Monday, August 20, 2001 11:22 AM > > > > > To: Multiple recipients of list ORACLE-L > > > > > Subject: RE: DBA tasks > > > > > > > > > > > > > > > We find the treasure, kill the bad guys, save the world and get >the > > > > > girl. > > > > > > > > > > I think that about covers it :0) > > > > > > > > > > g > > > > > > > > > > > > > > > -Original Message- > > > > > Sent: Friday, August 17, 2001 7:56 PM > > > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > > > > > > Hi... > > > > > > > > > > I'am searching for a oracle dba task guide. A doc that > > > > > especifi all the > > > > > task > > > > > of a oracle dba. > > > > > > > > > > javs > > > > > > > > > > -- > > > > > Please see the official ORACLE-L FAQ: <http://www.orafaq.com> > > > > > -- > > > > > Author: Jairo Villalobos > > > > > INET: [EMAIL PROTECTED] > > > > > > > > > > Fat City Network S
Exporting partitioned tables
Greetings and salutations oh magnificent Oracles of Oracle, I am experiencing something that I don't understand. (No comments from the peanut gallery!) When I do an export for a schema that contains a number of partitioned tables most of the time everything works fine. Sometimes however, the last partition of one object produces the following errors: EXP-8: Oracle error 8103 encountered ORA-08103: object no longer exists This error happens overnight and when I check in the morning (select count(*) from schema.table partition (P026);) and it always shows that I have rows. I RTFM'd and that error message indicates that the object is gone. This object is not dropped and re-created by any process. Any ideas? Stephen Andert
Re: How do they get the answer?
Well, to me it looks like WHERE subject_id IN (102, 105);will select 2 classes. Since there are a minimum of 2 teachers per class, this will select at least 4 teachers. Am I missing something? Stephen>>> [EMAIL PROTECTED] 08/21/01 09:25AM >>>I am taking the Self-Test software test for the SQL exam and don't see how they get the answer to this problem. They don't explain how it is arrived at.Any help you can give me will be appreciated.Thanks,Ken Janusz, CPIM--Examine the structure of the TEACHER table:Name Null? TypeID NOT NULL NUMBER(9)SALARY NUMBER(7,2)SUBJECT_ID NOT NULL NUMBER(3)SUBJECT_DESCRIPTION VARCHAR2(2)There are 200 teachers and 15 subjects. Each subject is taughtby at least 2 teachers.Evaluate this PL/SQL block:DECLARE v_pct_raise number := 1.10;BEGIN UPDATE teacher SET salary = salary * 1.10 WHERE subject_id IN (102, 105); COMMIT;END;Which result will the PL/SQL block provide?(A) Only two teachers will receive a 10% salary increase.(B) All of the teachers will receive a 10% salary increase.(C) At least four teachers will receive a 10% salary increase.(D) A syntax error will occur.Answer:(C) -- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RMAN Copies
Hello, We are in the process of learning and implementing RMAN. We are also in the process of implementing BCP (Business Continuity Planning). We have a BCP machine with enough disk space to do a restore of our "production-critical" databases. I need to be able to make a copy of the RMAN backup from one location, make a copy and overnight the tapes to our BCP location. The problem I have is that we are multi-plexing the backups of several databases and I need to make a copy on to one set of tapes of just 1 database. PLEASE tell me there is an easy way to do this!!! I looked in the Oracle8i Recovery Manager User's Guide and Reference and found duplexing, but that will require more tape drives than we currently have available as well as some additional configuration of NetBackup that our Tape Operators are hesitant to undertake. Thanks for any pointers, tips, suggestions, etc. Stephen Andert
Re: OT: Unix - performance tuning (vmstat 5)
Try this: var_pid=`echo $var_grep_vmstat | grep -v grep | (read u v w x y z; echo ${v} )`kill $var_pid the grep -v grep will remove any lines with the word grep. HTH Stephen >>> [EMAIL PROTECTED] 08/22/01 05:05AM >>>Hi Unix Gurus,I submit a job to monitor the CPU utilization etc every 15 mins using thecommand vmstat 5.How do I kill the submitted unix process of the batch job ? I tried to kill the submitted process using a batch job using the followingcommand :var_pid=`echo $var_grep_vmstat | (read u v w x y z; echo ${v} )`kill $var_pidThis works if the output is $ ps -ef | grep vmstat orahrms 11271 11263 0 17:30:00 ? 0:00 vmstat 5 orahrms 11612 11576 0 18:50:53 pts/11 0:00 grep vmstatIf the output is as below, the program will not work $ ps -ef | grep vmstat orahrms 11612 11576 0 18:50:53 pts/11 0:00 grep vmstat orahrms 11271 11263 0 17:30:00 ? 0:00 vmstat 5Please help. Thanks in advance.Regds,New Bee-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Standard SQLNET.ORA with multiple O_HOME's
Greetings fellow listers, We are starting to make the changes to sqlnet.ora files, I discovered that we have 9 separate files on one particular. Most of the file is identical with the only variance appearing to be in the SQLNET.EXPIRE_TIME value which ranges from 10 to 300. I'm thinking that we could have a single file (maybe in /etc/) and create OS links from the various $ORACLE_HOME/network/admin/sqlnet.ora files. Has anyone tried this or know of any reason why this wouldn't be a good idea? We also have quite a number of hosts and have a standard tnsnames.ora that we ftp from a master location on a nightly basis and would like to do the same with a standard sqlnet.ora. Any thoughts? Thanks Stephen Andert
RE: Data Center monitoring
Raghu, Well, I/Watch is nice when it works. While we were attempting to roll it out the first (and second) time, I left most of my "manual" old fashioned scripts running through cron. Many times, things that were supposed to page or e-mail us from I/Watch didn't. But sometimes they would. It was just too unreliable. My scripts are still in place and I've been spending time polishing them lately. Also, the quest processes would sometimes spin out of control and crash the box (a mutiple-cpu unix box running Tru64 so no NT jokes). I think they fixed that in the more recent version. Stephen >>> [EMAIL PROTECTED] 08/27 1:51 PM >>> I/Watch is nice. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Monday, August 27, 2001 4:21 PM To: Multiple recipients of list ORACLE-L Hi Gurus, I have number of Oracle8i instances on HP-Ux in a 400 servers Data center!! I want valuble suggestions from Gurus and who maintaining their real Data ceners.. I appreciate your help. Thanks in advance Raghu. _ 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: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 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: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: financial problems with fatcity.com
I second that motion. I just spent over $100 to get my 2 boys signed up for Cub Scouts and one of them has weekly dues of $1.00. For me it $12/yr would be worth it. Maybe offer a lifetime membership of $25 or something. My 2 cents worth Stephen Andert >>> [EMAIL PROTECTED] 08/29/01 08:15AM >>>I think that much better than voluntary contributions will be somes*u*b*s*c*r*i*p*t*i*o*n fees - like $1 per month or better $12 per year. Iam sure thateverybody working with Oracle and living in US or UK or other developedcountry can afford such fees. We will not need to charge people fromdeveloping countries - I am sure these subscription fees will generate morethan $500 per month.Alex Hillman
RE: Lisa
Lisa, do you have a file of "titles" or do you keep coming up with new ones? I read your messages just to see things like: Dog Bone AdministratorThe Bootylicious DBA and many more StephenNo funny sig line
RE: Oracle DBA With Internet Experience Needed in Harrisburg,
A lot cheaper that regular mail where he would have to pay for printing, paper, envelopes and postage. It's all relative. Stephen >>> [EMAIL PROTECTED] 08/30/01 12:26PM >>>1500 users / 10$ = 6.6 cents per email. Pretty expensive rates don't yathink?>-Original Message->From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]>Sent: Thursday, August 30, 2001 11:48 AM>To: Multiple recipients of list ORACLE-L>Subject: RE: Oracle DBA With Internet Experience Needed in Harrisburg,>PA>>>That will be $10 for the advertisement fee. Please send your >check or Money>Order to Jared!!>>Dave>>-Original Message->Sent: Thursday, August 30, 2001 11:58 AM>To: Multiple recipients of list ORACLE-L>>>This Manufacturing Client located near Harrisburg, >Pennsylvania needs an>Oracle DBA>to join its' I.T. staff.>The selected candidate will receive general direction from the Sr. DBA >and Director of Application Services however, independence is >encouraged for>>the day-to-day operations. >>* Candidates local to the Greater Harrisburg area only will be >considered.>>This is a full time staff position so no sub-contractors or >third parties>please.>>Please do not call or send a resume if you are not in the U.S. >and/or need >sponsorship.>>>* Description: Directs the day to day activities of personnel>involved in the internet database architechture and infrastructure, to>ensure the availability, stability and responsiveness of >Company's Internet>systems. >Essential functions-- Responsible for: Internet database tuning>and performance, management and monitoring of database>sizing and design, for database backup and recovery for the>internet systems, for recommending internet and report>database interface recommendations. >Duties will also include daily activities releated to >customers databases , >including upgrades, requested deletions or adding custom database>modifications.>>* Requirements:>- 2-5 Years Oracle DBA in a large Internet environment.>- 2 years Java, JSP and or Pearl programming experience a plus.>- B.S. in Computer Science preferred or related technical discipline. >- Must be able to work effectively in a team environment and be a team>player >- U.S. citizenship or Permanent residency is also required>>These positions offer:> * Stability > * The opportunity to become a key member of the team.> * Base salary of between 70-90K-D.O.E.> >PLEASE do not send your resume if you are not in the United States.>>For immediate consideration, please send your resume as a >Word attachment>to:>OraStaff, Inc.>Email: [EMAIL PROTECTED]>ph: 1-800 -549-8502>Please use job code One/Harrisburg/DBA/Coombes>>Candidates who we are interested in will be contacted immediately.>>*We pay referral fees.>So please contact me if you know of anyone who would be >qualified/interested>in the posiition described above- if it is not a match for your skills.>Thanks,>Bill Law>>>-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com>-- >Author: OraStaff> INET: [EMAIL PROTECTED]>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051>San Diego, California -- Public Internet access / Mailing Lists>>To REMOVE yourself from this mailing list, send an E-Mail message>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in>the message BODY, include a line containing: UNSUB ORACLE-L>(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).>--This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.==--Please see the official ORACLE-L FAQ: http://www.orafaq.com--Author: Post, Ethan INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Inter
Re: SQL*LOADER ERROR
Hello, Have you connected with "sqlplus username/password@qtel"? If you did sqlplus without the @qtel, you are not using the listener. In that case, you will probably want to get the listener running (or running correctly). HTH Stephen>>> [EMAIL PROTECTED] 09/04/01 01:56AM >>>Hi gurus,Greetings.c:\> sqlldr80 userid=msalah/msalah@qtel control=c:\test.ctlORA-12203: TNS:unable to connect destinationSQL*Loader-704: Internal error: ulconnect : OCIServerAttach [-1]But am able to connect with SQL*Plus with the same username/password.Why it's showing this error, then?.Am using oracle 8.0.4, on Win NT.Rgds,Nirmal.-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Nirmal Kumar Muthu Kumaran INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Interesting News..
In fact today's Wall Street Journal quotes HP's CEO as saying the Compaq name will go away. I guess running it into the ground would take too much time so she is just going to abandon the Compaq name. They did say they plan to keep some of the "valuable sub-brands" like Presario. We currently only have HP-UX and Tru64 so it looks like one way or another if this deal goes through we will be affected. FWIW Stephen If you have any questions, please feel free to call me or drop me a note. Stephen Andert480-445-2506>>> [EMAIL PROTECTED] 09/05/01 12:01PM >>>More agreement. How many companies did AT&T buy only to drive them into theground? How much advantage did Compaq take of the impressive Alphatechnology? These mega mergers rarely produce anything much.Unless the HP strategy is to run Compaq's product line into the ground somore people turn to the HP products. That one might work...Jay Miller-Original Message-Sent: Wednesday, September 05, 2001 7:16 AMTo: Multiple recipients of list ORACLE-LI agree. First of all there is no certainty that the marriage will everbe consummed (there has been a lot of corporate engagement break-ups inthe past years. Remember GE/Honeywell, Jack Welch's apotheosis? Germanand French banks? Pharmacy?). There's too much overlap between the two(all those small NT servers ...), it will definitely translate intojob-axing, bitterness, and a lot of people fleeing the companies (notthe worst ones usually), which seldom has the best of effects oncustomers (there has been a time, during the Compaq/Digital merger, whenin the whole greater Paris area there was ONE field-engineer to changecontrollers and the like for Alpha servers. Fortunate that MTBF ishigh). I am ready to bet that before long it will be such a mess,whether the merger goes ahead or doesn't, that Ms Fiorina will bethanked with a handsome cheque and that champagne will flow at Sun andIBM. In comparison, DaimlerChrysler will look like a major successstory.S Faroult.Guy Hammond wrote:> > On the contrary, I'd say this is a godsend for Sun. Compaq made a mess> of truly epic proportions when they tried to integrate DEC and Tandem> into their operations. HP did just as badly with Apollo. There are going> to be bitter turf wars between the HP/UX and Tru64 (or Ultrix or> whatever it's called this week) camps, Alpha and PA-RISC, ProLiant and> whatever HP's x86 servers are called, and so forth. Sun will walk right> in and clean up in the workstation and midrange markets. And, when it> comes to shifting x86 boxes, neither HP nor Compaq could match the> efficiency of Dell, and in a commodity market, operating efficiency is> all that matters. This merger will go down in corporate history as a> mistake of epic proportions.> > Of course, I'm in the Solaris camp, so take my words in context :0)> > g> > -Original Message-> Sent: Tuesday, September 04, 2001 7:30 PM> To: Multiple recipients of list ORACLE-L> > I'm curious. What happens to Tru64 or HP-UX? One of> them's got to go, would'nt you think? How about their> Unix servers? I know they're both going to 64-bit> Itanium eventually, but can they support both product> lines? Wonder how VAX/VMS is going to fare? How does> this effect Sun? I'd say this would have a negative> impact on Sun.> > It'll be interesting to see what product lines get cut> and which ones continue. Should be fun to see how> things pan out over the next 12 to 18 months.> > mkb> > --- "Walthour, Jon (GEAE, Compaq)"> <[EMAIL PROTECTED]> wrote:> > Jared:> >> > It's the buzz of the office this morning. No one> > here seems to have seen it> > coming.> >> > Jon Walthour> > Oracle Database Administrator> > COMPAQ DBA Team> > Cincinnati, Ohio> >> > -Original Message-> > Sent: Tuesday, September 04, 2001 12:33 PM> > To: Multiple recipients of list ORACLE-L> >> >> >> > HP Acquiring Compaq?> >> > Yow!> >> > That's big news!> >> > Anyone see this coming? I would have never guessed.> >> > Jared> > On Tuesday 04 September 2001 07:02, Mark Leith> > wrote:> > > Thought this would interest you guys..> > >> > >> >>-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Miller, Jay INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-
Re: !! Where to contribute to keeping Oracle-l alive
It has been asked, but I haven't seen an answer yet (forgive me if I missed it) as to whether there will be a summary posted. I would like to just see a total contributed. I don't think anyone needs a detailed how it was spent since it was made clear that this would be used as start-up expense money. Stephen >>> [EMAIL PROTECTED] 09/05/01 12:41PM >>>I've received a few emails regarding this, so I thought it might begood to post the URL under a new topic.If you're interested in contributing financially to keeping this listviable, you may do so at: http://www.fatcity.com/ListGuru/Donate/Thanks,Jared-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
User Query Tools
Hey all, I just got out from a meeting where I was told that some of our users are asking for a tool to do their own queries against our database so they wouldn't have to request reports and such from IS. Oh BTW, they don't know (or feel the need to learn) SQL so they will be needing something with either a good GUI QBF or some kind of natural language interface. We are leaning against MS Query to avoid ODBC performance problems. Does anyone out there have users like this? Any product referrals with pros/cons? TIA If you have any questions, please feel free to call me or drop me a note. Stephen Andert480-445-2506
New York/East Coast !!!!
I sure hope our members on the East Coast are ok. If anyone is out there and has access, I'd be happy to pass along any messages to family, etc. Let us know if you guys are ok. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New York/East Coast !!!!
I don't any connections in NY, but figured that if anyone there can pass a message through me (or anyone else that has an available phone line) to any family/friends outside of the area, it might be helpful. Especially if they don't have an open phone line. Stephen >>> [EMAIL PROTECTED] 09/11 9:25 AM >>> Is there anyway we can submit names of family members in NY > -Original Message- > From: Stephen Andert [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, September 11, 2001 11:25 AM > To: Multiple recipients of list ORACLE-L > Subject: New York/East Coast > > I sure hope our members on the East Coast are ok. If anyone is out there > and has access, I'd be happy to pass along any messages to family, etc. > > Let us know if you guys are ok. > > Stephen Andert > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephen Andert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Giles, Teri INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Performance tuning
Azhar, I agree with the other responses (more RAM, don't use OPTIMAL on your RBS's) but would also suggest dropping all indexes except PK until the load is done, the rebuild them. Also, does this table have any triggers? If so, if can you disable them during the load, that will help speed up the load. For help in setting the ROWS and BINDSIZE parameters, there is an article of mine that O'Reilly published on their web site (http://oracle.oreilly.com/news/oraclesqlload_0401.html) which details my experience which resulted in some big performance gains. HTH, Stephen>>> [EMAIL PROTECTED] 05/30/01 02:19AM >>>HI ALL,We have to load almost 3 millions records of average row size of 150 bytes.We are importing data using sqloader with ROWS=4000 and bindsize=845 .We have adjusted the rollback segment to almost 10 m with 8 extents enoughfor single transaction size and considering 30% rollback overhead. Weadjusted the OPTIMAL TO 10 M to have avoid rollback extensionRollback segment, databuffer cache have hit ratio of 100%.The loading was fast only for first 10 commits but then it slowed likesnail. LOADING TOOK 22 hours in the first run on ORACLE8i NT4 128 megs RAM.SGA figures in M :NAME VALUE -Fixed Size .0676384Variable Size 239.02734Database Buffers 39.0625Redo Buffers 7.8203125 -sum 285.97779( we can't use direct path due to functions in sqlldr controlfile). .Couldn't figure out the bottleneck yet.Any ideas.TIAAzhar Siddiq,DBALMK Resources-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: OT: Working from home
Mark, Well, in order to give you my 2 cents worth, lets answer those in order: — Accountability: Work needs be get done whether in office or at home. If it gets done and db's are running well, it shouldn't matter where it gets done from. This is very hard for some managers to understand and one of the reasons I left my last job. If the manager is open to results-based management, this won't be a problem. We also overcome some of this by over-communicating when working at home. For example things that don't generally warrant an e-mail when in the office, (like adding space to a tbs that is causing IWatch to chirp) get a quick "FYI, I took care of X" while working from home. — Communication: Our telecomm guys set us up so our phones can be set to ring at home. Thus for the in-office user who calls our 4-digit extention, they don't even know we are sitting at home in shorts/t-shirt. You also need a second line so you can be connected all day and still answer your phone. — Unforeseen problems. 1) What to do it remote access is down? If ETA is all day, drag yourself to the office. If 1-2 hours, read white papers/manuals, work on status report, project plan or anything else that you can do with software on your home pc. 2) What if a meeting is scheduled on your work at home day? Have someone conference call you in. That is widely accepted in our company as we have a lot of projects that involve people at different locations. — Specific company benefits: 1) happier dba's = less turn-over. Personally I work from home 1-day per week and enjoy the extra time and gas saved from not driving. I also like wearing shorts and t-shirt. 2) In many bigger cities, bigger companies are required to work on reducing the number of "single occupant vehicle miles" driven by their employees. Generally companies will encourage carpooling, bus riding, etc, but they also get credit for regular telecommuters. In some areas, this is actually a huge motivator for companies. 3) I find I generally start work earlier and stop later when I'm at home. Also lack of typical office interruptions makes this a good time for anything that requires concentration. HTH Stephen >>> [EMAIL PROTECTED] 06/13/01 03:00PM >>>Hi All,I have a few off-topic questions for those of you who are allowed to workfrom home either occasionally or on a regular basis. My department isputting a proposal together to present to management and we're looking forany information you could provide. How did you handle accountability? Howdid you handle communication between work and home? What were some of theunforeseen problems that you encountered? Were there any specific companybenefits? (This appears to be more a benefit to the employee than to thecompany.) Thanks to all who can reply.MarkProduction: In Progress:Oracle 7.3.4.4 Oracle 8iOracle Apps (Fin/Mfg) 10.7SC Oracle Apps (Fin/Mfg) 11.5.3Sun Solaris 2.6 Sun Solaris 8 (2.8)Mark WillettCorporate Database Administrator- Sunnen Products Company 7910 Manchester Ave Maplewood, Missouri 63143 USA Voice: 314.781.2100 x2429 Fax: 314.951.2749 E-mail: [EMAIL PROTECTED]The statements and opinions expressed herein are my own and do notnecessarily reflect those of Sunnen Products Company. --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Willett, Mark INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Bug 1367773
So far no one answered so I tried and was told Your search returned no hits! I generally have the worst luck in looking up bugs. I do ocassionally hit a few bugs, but most of the time nothin'. HTH Stephen >>> [EMAIL PROTECTED] 11/14/01 07:45AM >>>Hi List,does anyone have description (body) of bug # 1367773Thanks in advance,Ed-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Edward Shevtsov INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Microsoft Transaction Server hangs
I'm looking into this for a colleague. Environment NT 4 SP 6 Oracle server 8.1.5 At several times throughout the day, the connection hangs. MTS seems to still be running, the db is still accessible. Bouncing the MTS service resolves the problem for a while. I have asked them to check listener status when this hanging takes place. Has anyone encountered this? Any ideas where to look? Stephen
RE: Microsoft Transaction Server hangs
Thanks for your response. I have not worked with MTS, can you please tell me what I should have my colleague do to turn on tracing and identify the location of the log file? They are in a different state and since it is not unix, I am a bit behind the curve and I have very big shots watching over my shoulder. Thanks. Stephen >>> [EMAIL PROTECTED] 11/28/01 01:01PM >>> Hello, What about the oramts service? Is it stopping or something? you should turn the trace on. Daniel -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Stephen AndertSent: Wednesday, November 28, 2001 8:35 PMTo: Multiple recipients of list ORACLE-LSubject: Microsoft Transaction Server hangs I'm looking into this for a colleague. Environment NT 4 SP 6 Oracle server 8.1.5 At several times throughout the day, the connection hangs. MTS seems to still be running, the db is still accessible. Bouncing the MTS service resolves the problem for a while. I have asked them to check listener status when this hanging takes place. Has anyone encountered this? Any ideas where to look? Stephen
Re: Rollbacks - ORA-1555
Christine, Howdy neighbor. I've almost eliminated 1555's. It took some trial and error, but what we ended up with in one of our bigger db's is: 30 rollback segments OPTIMAL (NULL) minextents 20 initial = next = 4MB 6GB total space We have between 400 and 500 interactive users, several high volume batch jobs and some DSS jobs. By getting rid of OPTIMAL, you avoid one of the more common causes of the 1555 where a rollback segment is shrunk while the data block is being used. We schedule a shrink script to run and manually shrink all the rollback segments weekly. At times some tasks can eat up more rbs, but since they are dba activities, we just shrink a single rollback segment at a time if it gets too big. HTH Stephen Andert >>> [EMAIL PROTECTED] 12/04/01 03:50PM >>> Greetings All I am some what new to the list, so forgive me if I don't have the proper etiquette in addressing my issue. I have a database, 8.1.6, running on Windows NT, that currently has 5 rollback segments. The specs are as follows for each segment: OPTIMAL 350M minextents 7 maxextents unlimited initial 50M next 50M These segments are currently in one tablespace, for rollbacks only, which is sized at 2.5 gig, and currently the segments are taking 1.7 gig, obviously aprox 750 meg free. I have an application, written by our developers here, which is doing a functionality called "pricing". Within this process is alot of DML (updates and deletes) with some DDL inter-mixed. There is an auto-commit feature, which is currently commiting every 1000 records. There is also a locking feature, before the actual "fetches" the application is performing for it's cursors, and the developers are currently using "select * from table for update nowait" to lock the whole table for this process. The locking is in place because this particular process can use up to 5 different sessions. Currently the stats of the rollbacks look like this: data requests- 3817488 CLASS COUNT-- --system undo header 0system undo block 0undo header 3undo block 1 USN NAME AVEACTIVE OPTSIZE WAITS WRAPS EXTENDS SHRINKS AVESHRINK -- -- -- - - --- -- -- 0 SYSTEM 0 0 0 0 0 0 2 SV_ROLL0 0 367001600 2 0 0 0 0 3 SV_ROLL1 0 367001600 0 0 0 0 0 4 SV_ROLL2 0 367001600 1 0 0 0 0 5 SV_ROLL3 0 367001600 0 0 0 0 0 6 SV_ROLL4 0 367001600 0 0 0 0 0 6 rows selected. TSPACE TOTAL USED FREE--- -- -- --SV_ROLL_TSP 2500 1751 750 At times I have seen the "aveactive" column have some numeric value in it, but when the database and services are shutdown and brought back up, this number clears out. My question is this: how much larger are these rollbacks supposed to be before I can eliminate the waits and wraps? More importantly, eliminate the undo headers and block. I have done alot of testing, with different sizing, and I feel like I'm chasing my tail. This is a major feature of our software, so it's not like it can be "ran at night" to differ to a timing issue. I have also noticed, that PMON doesn't really "shrink" appropriately, not back to a state like they are when they are first created. At this point, I guess I'm looking for some insight, advice as to what to specifically do to tune these segments a little more. Thanks So Much, in advance Christine
ODBC & Microsoft Transaction Server
Hello, The application frequently (several times per day) hangs. Restarting the MTS (Microsoft Transaction Server) (Package shutdown) resolves the problem and the users are able to work again. The database appears to be unaffected and appears ready to process. The Oracle ODBC version is 8.01.74.00 7/24/01. The Client on the MTS server is 8.1.7 The Server is 8.1.5 running on NT 4.0 I traced ODBC for awhile until after it hung the next time. Some of the things I saw that looked like errors are: SQLPOINTER 0x0003 (BADMEM) DIAG [IM006][Microsoft][ODBC Driver Manager] Driver's SQL SetConnectAttr Failed(0) SQLPOINTER [Unknown attribute 201] Any help pointing me where to look for the root cause of this problem would be appreciated. Thanks If you have any questions, please feel free to drop me a note. Stephen Andert Scottsdale, Arizona -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recommenations for a DB conversion using SQL Loader
Depending on how much data you have, look at doing a little tuning of the BINDSIZE and ROWS parameters. Send me a personal e-mail if you want more information on that. Stephen Andert Scottsdale, Arizona >>> [EMAIL PROTECTED] 12/12/01 11:35 AM >>> Ken, A few things you could try here: 1) disable the foreign key constraints for the load or 2) load the parent tables before the child tables If you have a huge amount, you might want to consider dropping all of the indexes, except for the primary and unique key constraints. (I don't like to take chances when it comes to data integrity.) This would save you a boatload of time. Regards, Jeff - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, December 12, 2001 9:45 AM I am working on a one time DB conversion project for a state government entity. I have a DB (8.1.7 on W2000 server) setup without the application SW that I am using to load the data into from flat files. When I get this data loaded I will then load it into the production tables at the client site. I will not be running any applications on this DB, it's for conversion purposes only. I am running into some constraint violation problems since I am loading the data to each table one at a time. Would it be prudent to disable the constraints until I get all the data loaded? Any and all suggestions are welcome. Ken -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SqlLoader
Laura, One idea, select username and status from dba_user. I would guess that should work, but ... Another thought, you say you can connect via sqlplus. Is your sqlplus connection of the form user/password@sid or just user/password? If it is the latter, your environment vairable ORACLE_HOME (echo $ORACLE_HOME on Unix) decides what db to connect to and could be pointing you to a different db. HTH Stephen Andert >>> [EMAIL PROTECTED] 12/12/01 23:54 PM >>> Thank you for your reply. The user does have DBA rights and also owns the table that is being referenced. If it was a table rights issue I would think I would have gotten 'table or view does not exist' message. I don't think it is even getting connected to the database. Laura -Original Message- Sent: Wednesday, December 12, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Laura, The username that you are trying to use, does this username own the table that is to be loaded, or does this username have DBA privileges? Even though you can connect via sqlplus and/or svrmgr to a session, this does not mean that you will be able to load data into any table that you desire. HTH Regards, Jeff Tempe, AZ - Original Message - To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L Sent: Wednesday, December 12, 2001 3:35 PM I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message. I can sign on svrmgr and through sqlplus with no problems. Any ideas? Thanks, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SqlLoader
Laura, One idea, select username and status from dba_user. I would guess that should work, but ... Another thought, you say you can connect via sqlplus. Is your sqlplus connection of the form user/password@sid or just user/password? If it is the latter, your environment vairable ORACLE_HOME (echo $ORACLE_HOME on Unix) decides what db to connect to and could be pointing you to a different db. HTH Stephen Andert >>> [EMAIL PROTECTED] 12/12/01 23:54 PM >>> Thank you for your reply. The user does have DBA rights and also owns the table that is being referenced. If it was a table rights issue I would think I would have gotten 'table or view does not exist' message. I don't think it is even getting connected to the database. Laura -Original Message- Sent: Wednesday, December 12, 2001 5:30 PM To: Multiple recipients of list ORACLE-L Laura, The username that you are trying to use, does this username own the table that is to be loaded, or does this username have DBA privileges? Even though you can connect via sqlplus and/or svrmgr to a session, this does not mean that you will be able to load data into any table that you desire. HTH Regards, Jeff Tempe, AZ - Original Message - To: Multiple <mailto:[EMAIL PROTECTED]> recipients of list ORACLE-L Sent: Wednesday, December 12, 2001 3:35 PM I have never had a problem with sqlloader before, but now when I run it I get an error 'invalid name/password' message. I can sign on svrmgr and through sqlplus with no problems. Any ideas? Thanks, Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL*Loader-417 Error
Ken, You can't do a lot of things to the data in a direct path load. You could modify your source data (awk, grep, sed, etc.) so you wouldn't need to reformat the date field and then if there are no additional problems, you will still have a problem with the FK that you are seeing in the conventional load. Not knowing the FK error, I can't really point you towards a solution there. I would probably just stick with conventional since it is easier than mucking around with your source data. FK violations are good. They mean you are not putting garbage into your database so you won't get GIGO. If you provide more info on your layout and the FK error I'm sure someone will be able to help. If you have any questions, please feel free to drop me a note. Stephen Andert Scottsdale, Arizona >>> [EMAIL PROTECTED] 12/13/01 15:52 PM >>> I am getting the following error for this line of code in my control file Any ideas of how I can get around this? When I try a conventional path load I get a FK constraint error (not on this field). creation_date "to_date('01/01/2002','dd/mm/')", SQL*Loader-417: SQL string (on column CREATION_DATE) not allowed in direct path. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Becoming a DBA questions
1. Depends on the company/part of the country and the economy. 2. State your experience with other databases. Once you get Oracle up and running at home, add that so they know you have installed it (IMHO installing on Linux is more impressive as it is very close to unix, but doing it under windows is better than nothing.) Don't say "looking for entry-level Oracle dba job" in your mission statement. Say something like "looking for the opportunity to move my proven database design and administration skills to a new level with Oracle" or something to that extent. 3. If you are good at self-study, Oracle has online learning that appears pretty reasonable ($99/month or something like that). But get yourself an Oracle installation to practice on first. 4. Quite possible to get a job with self-study and training. Passing your OCP tests will help you get that first job. After that it is nice to put on your biography when you submit papers to present at the conferences and user groups. 6. I'm not in the office today, but I'm sure someone will correct me on the title, but the two books I think are great are a. Oracle 8i dba from Oracle Press. I think that is the one that has a great example of real-life paper to database that explains things very well. b. DBA 101 by Rachel Carmichael (and others). I haven't had the chance to read it yet, but I've got a friend who is an aspiring dba so I've looked at it and he really loves it. And since I'm a big fan of Rachel's work, I have to recommend it. 8. Well, I have been working with databases for many years. But my first Oracle job was an accident. I was hired for other skills that I had and the day I started my new manager said "the Oracle DBA is leaving. You've got a lot of database experience on your resume. Want to be our Oracle DBA?" The rest is history. My advice to you is to get Oracle installed and decide on a project that you can use and maintain. I built a contact manager using an Access front-end. I kept learning new ways to improve the design and adding new features. Besides coming in very handy for job searches, it gave me something to discuss when networking and someone would hear that I worked with databases and ask what I had worked on recently. I would also recommend looking up a local user group (start at www.ioug.org and click on the User Group link). Attend and make friends. These will be your peers and if you're lucky, you may find someone that will become your mentor. They may not be in a position to hire you, but they (we) are generally connected to the pulse of the hiring market and know when someone is looking to expand or hire a replacement. They can also help you learn new things and correct any misconceptions you have. At the social portion of the event (most user groups have conversation time) find someone who has been a dba for a number of years and ask them if you can talk to them. Explain what your understanding of something is and then pay attention as they either correct you or add to your knowledge. Before you know it, you will be sitting in an interview and the interviewer will ask you to explain how to use pctfree and you will know from your conversations and testing. Good luck. Stephen Andert Scottsdale, Arizona >>> [EMAIL PROTECTED] 12/31 2:00 AM >>> > Questions for a Database Administrator: 1. What is the average salary range for an entry-level DBA position? Or a position for someone who is just starting out as a DBA? 2. In a job resume, should I request an entry-level position or would that set me up for no phone calls? 3. What are some steps I should take to becoming a DBA w/ the background that I have (ie. generated databases w/ MS Access)? a) Recommended training/education in Los Angeles area? b) Where do you recommend I study & is online training valuable? 4. If I could learn Oracle software on my own through Independent study (books & reference sites), could this be sufficient enough to go about to get a job? a) Is the OCP certification necessary? b) If I took this independent study route instead of formal training from like a vocational school, would the steps to getting a job (or even my OCP certification) be the same? Or would it be more difficult without formal training? 5. What are some valuable books and resources to aid in my training? 6. How much does Oracle9i cost & would it be worth it to get since i want to learn? Are there evaluation copies out there that I can get my hands on? 7. What are the basic introductory courses/resources/training I could do to learn or get started in DBA training? 8. Basically, please list the steps you took to become a DBA (starting with education/training to job entry) and how you sould suggest I should go about starting to learn the fundamentals and then more in depth? Thank you!! I really appreciate your help
RE: Table MONITORING
In one version (I think is was 8.1.6.x.x) analyze stale didn't work right. In 8.1.7 (releases the we've tried, .0 and .2), it didn't work for partitioned tables. The monitor piece appears to work, so one of the other dba's here wrote a script using all_tab_modifications and dynamic sql to handle this. It get's tricky with global indexes and big partitioned tables because some days the whole thing finishes in a couple minutes while when a table is stale enough that it analyzes the whole index. But it's working better than before. Stephen >>> [EMAIL PROTECTED] 01/01/02 04:35PM >>>Paul,The bug actually says:"Rediscovery Information:You will see this bug when using dbms_stats.gather_xxx_stats and :1. An invalid granularity is supplied2. The GATHER STALE or GATHER EMPTY options are used3. The procedure call does not seem to work.Workaround:Correct the granularity parameter"So, provided you spell the granularity parameter correctly, this bug doesnot apply.We are using monitoring and gather_xxx_stats on NT under 81714 and it seemsto be working ok (ie num_rows is being updated correctly).Are you aware of any other bugs relating to monitoring / gather stats?(I know of bug 1407738 relating to table names > 28 characters).Regards,Bruce Reardonmailto:[EMAIL PROTECTED]-Original Message-Sent: Saturday, 29 December 2001 10:00The DBMS_STATS.GATHER_SCHEMA_STATS procedure (with the GATHER STALEoption), which uses the information produced when a table is inMONITORING mode, does not work properly in any current release ofOracle (see bug 1890016 on MetaLink).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Analyzing partitioned tables
Here is what we use which also incorporates using our own definition of STALE with monitoring on. It includes indexes as well as partitioned and non-partitioned tables as well as non-monitored tables. HTH select 'analyze table ' || '${SCHEMA}.' || a.table_name || ' compute statistics;' from dba_tables a, all_tab_modifications b where a.owner = upper('${SCHEMA}') and b.table_owner = a.owner and a.table_name = b.table_name and a.partitioned = 'NO' and (a.num_rows is null or ((b.inserts+b.deletes+b.updates)*100) / decode(a.num_rows,0,1,a.num_rows) > ${PERCENTAGE} or b.truncated = 'YES') union select 'analyze table ' || '${SCHEMA}.' || a.table_name || ' partition (' || b.partition_name || ') compute statistics;' from dba_tab_partitions a, all_tab_modifications b where a.table_owner = upper('${SCHEMA}') and b.table_owner = a.table_owner and a.table_name = b.table_name and a.partition_name = b.partition_name and (a.num_rows is null or ((b.inserts+b.deletes+b.updates)*100) / decode(a.num_rows,0,1,a.num_rows) > ${PERCENTAGE} or b.truncated = 'YES')union select 'analyze index ' || '${SCHEMA}.' || index_name || ' compute statistics;' from dba_indexes where table_owner=upper('${SCHEMA}' ) and index_name not in (select distinct index_name from dba_part_indexes where owner=upper('${SCHEMA}') and locality = 'LOCAL') and table_name in (select distinct a.table_name from dba_tab_partitions a, all_tab_modifications b where a.table_owner = upper('${SCHEMA}') and b.table_owner = a.table_owner and a.table_name = b.table_name and a.partition_name = b.partition_name and (a.num_rows is null or ((b.inserts+b.deletes+b.updates)*100) / decode(a.num_rows,0,1,a.num_rows) > ${PERCENTAGE} or b.truncated = 'YES'))union select 'analyze table ' || '${SCHEMA}.' || table_name || ' compute statistics;' from dba_tables where owner = upper('${SCHEMA}') and monitoring = 'NO'; If you have any questions, please feel free to call me or drop me a note. Stephen AndertScottsdale, Arizona >>> [EMAIL PROTECTED] 01/03/02 06:00AM >>>Good morning everyone,Can anyone give me the command to analyze a partitioned tabled? To analyzethis table unpartitioned I use: analyze table schema.table_name computestatistics;I am partitioning it into 6 partitions and want to compute statistics oneach partition.Thanks in advance,Ruth-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ruth Gramolini INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Becoming a DBA questions
Actually, I passed it on to my supervisor with a brief (cynical) comment. Stephen>>> [EMAIL PROTECTED] 01/03/02 03:35PM >>>Paul, just goes to show how many people on the listserv have me in theirkillfile, since you're the only one that caught it.joePaul Baumgartel wrote:> > Wow, Joe, $1000K for taking the tests? That's what I call an> incentive! ;-)> > PB> --- Joe Testa <[EMAIL PROTECTED]> wrote:> > Kimberly, I'm with you and like you I only took the 8 test because at> >> > the time, my employer paid for the tests and gave me a bonus to pass> > them(like $250/test and $1000K when all done, if i remember> > correctly),> > so i had incentive :).> >> > Joe> >> >> > __> Do You Yahoo!?> Send your FREE holiday greetings online!> http://greetings.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)-- Joe Testa, Oracle DBAWant to have a good time with a bunch of geeks? Check out:http://www.geekcruises.com/standard_interface/future_cruises.htmlI'm presenting, when registering drop my name :)-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Joe Testa INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Template for documenting database
Rick, A while back, there was a document that a lister assembled and made available. It is a wider scope that just the data model itself. While not perfect, I have used it to get a handle on the whole system when I stepped in to do an analysis of a system. If you want it, send me an e-mail off-list. Stephen Andert [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 01/07 11:02 AM >>> Hi All, I have come into a situation where most of the database systems are not very well documented. Does anyone have any templates,resources,links that may provide either a template or example of what should be documented? Thanks Rick -- 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: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Problem with standby database & listener
Fellow dba's, We have come across a weird problem with a standby database. Every time we issue "alter database mount standby database" on the standby database, the primary database fails to connect through listener. It becomes OK after primary database is shutdown and restarted — of course this can is not an acceptable solution since the standby will be opened every week for reporting. Anyone experience this before? Any direction would be appreciated. Thanks Stephen AndertScottsdale, Arizona
RE: RMAN restore to different machine
More food for thought: There is a good chance that the hardware platform is different. I think that RMAN is not a valid way of changing to a new platform and you would need to export/import. I'm certain the experts on the list will correct me if I'm wrong. Thanks Stephen >>> [EMAIL PROTECTED] 11/24/03 11:54AM >>> Randy First, you may want to investigate your company's attitude toward recovering their proprietary data on your personal machine. I can give you some ideas on your task, but my experience is on 1)Unix, and 2) Oracle 8i. I would recommend you purchase Robert Freeman's book Oracle9i RMAN Backup & Recovery. Well worth the money. In Oracle8i I wasn't able to extract the control file from the RMAN backup, so I just backed that up separately. But I think Robert's book describes how to do that. I never worried about the init.ora file in Oracle8i, relying on the normal system backup to back that up. You could probably either copy the spfile from your production system (if you tell me you don't have access to that system, then you'll really concern me about what you are trying to do) or create a dummy init.ora to get the instance started. I don't know if you used the controlfile or catalog backup to create this RMAN backup. I use the catalog backup, but found it easier to recover using just the controlfile. The one sticky point is that RMAN will want its backup pieces in the same path that it backed them up. I haven't found any way of changing that. In Unix you can fool RMAN by creating a link. When you say that you couldn't get RMAN to look at the CD drive, that may be the problem you are encountering. If you are using Windows, perhaps you could find the drive letter used to create the backup and use that same drive letter on your personal machine. You can change the location where RMAN will restore the files with the SET NEWNAME command for each data file. RMAN will restore the database with the original instance name. Hope this is of some assistance. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 24, 2003 7:49 AM To: Multiple recipients of list ORACLE-L I have an online backup of my 9i production database on CD. I want to restore it to my home PC, which has a completely different file structure and an empty database. I did the backup with rman. I spent most of Saturday trying this and can not even get rman to look at the backup set on the CD. I'd be real happy if someone can just explain how to restore the spfile and the control file. Thanks Randy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steiner, Randy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Parse Vs Execute
Here is what I use to monitor my cursor use. If session_cached_cursors is at or near 100%, I increase is and continue to monitor. On the system I just checked I'm up to 500. This reduced my parse counts for some operations. The other thing is whether there are any compiler flags that need to be set to allow client connections to reuse cursors. Setting that and recompiling will make a huge impact. Good luck and Happy Thanksgiving. Stephen 1 select 2'session_cached_cursors' parameter, 3lpad(value, 5) value, 4decode(value, 0, ' n/a', to_char(100 * used / value, '990') || '%') usage 5 from 6( select 7max(s.value) used 8 from 9sys.v_$statname n, 10sys.v_$sesstat s 11 where 12n.name = 'session cursor cache count' and 13s.statistic# = n.statistic# 14), 15( select 16value 17 from 18sys.v_$parameter 19 where 20name = 'session_cached_cursors' 21) 22 union all 23 select 24'open_cursors', 25lpad(value, 5), 26to_char(100 * used / value, '990') || '%' 27 from 28( select 29max(sum(s.value)) used 30 from 31sys.v_$statname n, 32sys.v_$sesstat s 33 where 34n.name in ('opened cursors current', 'session cursor cache count') and 35s.statistic# = n.statistic# 36 group by 37s.sid 38), 39( select 40value 41 from 42sys.v_$parameter 43 where 44name = 'open_cursors' 45* ) >>> [EMAIL PROTECTED] 11/26/03 11:14AM >>> Hi List, Almost fro all SQLs I am getting Prase count is same as Execute count. How to reduce parse count? 1) We are using bind variable 2) session_cached_cursors set to 100 call count cpuelapsed disk querycurrent rows --- -- -- -- -- -- -- Parse 11 0.01 0.02 0 0 0 0 Execute 11 0.00 0.00 0 0 0 0 Fetch 22 0.01 0.00 0 33 44 110 --- -- -- -- -- -- -- total 44 0.02 0.02 0 33 44 110 Any somebody give more hint on this? Thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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).
Strange behavior
Greetings fellow-DBA-folk: When I run several queries, I am getting very strange results. Selecting * from apple returns the expected data records, but count(*) does not. Selecting anything other than * from apple says no records. The subquery for pear works fine on it's own. Selecting anything other than * from apple returns the expected records when about 900+ values are placed literally in the subquery as shown in example 4 below. Am I missing something? Anyone have a direction for me to look for the cause of this? Thanks Stephen EX 1 select rowid from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 2 select rownum from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 3 select * from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 4 select count(*) from common.apple where appleinter1 in ( 7009 , 7010 , 7011 , 7012 , 7013 , 7014 , 7015 , 7016 , 7017 , 7018 , 7019) and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 5 select count(*) from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Strange behavior
Mike, Thanks for the tip, but I have already prefixed the owner for both tables so that shouldn't be a problem. That did give me an idea for som additional testing. When I made a smaller copy of the PEAR table, all queries work correctly. This tells me there might be something "unique" about the original table. I'll be doing more testing. Stay tuned and I'll post updates as I make new discoveries. Thanks Stephen >>> [EMAIL PROTECTED] 01/07/04 01:29PM >>> A good first place to check is that there are no other objects (synonym is a frequent culprit). try: select object_name,object_type from dba_objects where object_name = 'APPLE'; This will tell you if there is anything else out there with the same name. HTH, Mike "Stephen Andert" <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> health.com> cc: Sent by:Subject: Strange behavior [EMAIL PROTECTED] m 01/07/2004 02:49 PM Please respond to ORACLE-L Greetings fellow-DBA-folk: When I run several queries, I am getting very strange results. Selecting * from apple returns the expected data records, but count(*) does not. Selecting anything other than * from apple says no records. The subquery for pear works fine on it's own. Selecting anything other than * from apple returns the expected records when about 900+ values are placed literally in the subquery as shown in example 4 below. Am I missing something? Anyone have a direction for me to look for the cause of this? Thanks Stephen EX 1 select rowid from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 2 select rownum from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 3 select * from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 4 select count(*) from common.apple where appleinter1 in ( 7009 , 7010 , 7011 , 7012 , 7013 , 7014 , 7015 , 7016 , 7017 , 7018 , 7019) and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 5 select count(*) from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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
RE: Strange behavior
alter session set sql_behavior = 'normal' * ERROR at line 1: ORA-02248: invalid option for ALTER SESSION Proof that there is nothing 'normal' about me I ran my subquery separately looking for null's and it doesn't look like I have any. Here is what I did. Let me know if you think this would report any nulls. select count(pearinternal) from common.pear where pear_clnt_src_cd = 'CCN'; COUNT(RPIINTERNAL) -- 5347 select count(pearinternal) from common.pear where pear_clnt_src_cd = 'CCN' and pearinternal is null; COUNT(PEARINTERNAL) -- 0 select count(pearinternal) from common.pear where pear_clnt_src_cd = 'CCN' and pearinternal is not null; COUNT(PEARINTERNAL) -- 5347 >>> [EMAIL PROTECTED] 01/07/04 02:04PM >>> alter session set sql_behavior = 'normal' / seriously ... me thinks that you have a NULL value returned by your subquery. Raj -Original Message- Sent: Wednesday, January 07, 2004 3:55 PM To: Multiple recipients of list ORACLE-L Mike, Thanks for the tip, but I have already prefixed the owner for both tables so that shouldn't be a problem. That did give me an idea for som additional testing. When I made a smaller copy of the PEAR table, all queries work correctly. This tells me there might be something "unique" about the original table. I'll be doing more testing. Stay tuned and I'll post updates as I make new discoveries. Thanks Stephen -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Strange behavior
Mark, Good idea, but no, the sub-select only returns numbers. Thanks Stephen >>> [EMAIL PROTECTED] 01/07/04 01:09PM >>> Stephen, Do any of your sub-selects (the queries inside the IN() clause) return NULL? If so, that will definitely cause zero rows to be returned by the outer query. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message- Sent: Wednesday, January 07, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Greetings fellow-DBA-folk: When I run several queries, I am getting very strange results. Selecting * from apple returns the expected data records, but count(*) does not. Selecting anything other than * from apple says no records. The subquery for pear works fine on it's own. Selecting anything other than * from apple returns the expected records when about 900+ values are placed literally in the subquery as shown in example 4 below. Am I missing something? Anyone have a direction for me to look for the cause of this? Thanks Stephen EX 1 select rowid from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 2 select rownum from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 3 select * from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 4 select count(*) from common.apple where appleinter1 in ( 7009 , 7010 , 7011 , 7012 , 7013 , 7014 , 7015 , 7016 , 7017 , 7018 , 7019) and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 5 select count(*) from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Oracle8i on Linux
Seema, Try this site. While it is about 9i, some of the same issues will appear in the 8.1.x install. http://www.puschitz.com/InstallingOracle9i.shtml Also, go to www.google.com/linux and search for +oracle +"error message" and look through the responses. HTH Stephen >>> [EMAIL PROTECTED] 01/13/04 10:04AM >>> Hi, I have 256mb RAM,60GB of hard disk,P3 MACHINE.I'm having installation of oracle 817 on linux 7.2. I got error during oracle relinking.DOes any one have such problem earlier? Let me know if some one had such installation in past.ANy thoughts are most welcome. thx -Seema _ Check out the new MSN 9 Dial-up ― fast & reliable Internet access with prime features! http://join.msn.com/?pgmarket=en-us&page=dialup/home&ST=1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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).
Strange behavior - update
Hello again, Sorry if this is the 2nd msg in a short time, but Oracle Support amazed me with their quick response this morning and I haven't seen many messages (or any from me) on the list this morning. I promised to keep you updated on this strangeness. After further testing, we have discovered that the queries returning the wrong values return the correct values when /*+rule */ is added. I don't like telling my developers that until I have a better solution, so we are still working a TAR with the folks at Oracle Support who have come up with this. UPDATE: === This appears to be related to the bugs referenced above. Bug 2700474 is fixed in the 9.2.0.4 patch set. ACTION PLAN: 1. Without the rule hint if you alter the session as listed below are the correct results returned? SQL>alter session set "_complex_view_merging"=false ; Then execute the query without the rule hint. 2. If this returns the correct results, the parameter can be set at the database level. or 3. To obtain a bug fix, the latest patch set (9.2.0.4) can be applied. "_complex_view_merging"=false did not work in my test, so it looks like we have more motivation to continue working towards 9.2.0.4. Thanks for your troubleshooting help. Stephen ->->->->->->->->->->->->->->-> Greetings fellow-DBA-folk: When I run several queries, I am getting very strange results. Selecting * from apple returns the expected data records, but count(*) does not. Selecting anything other than * from apple says no records. The subquery for pear works fine on it's own. Selecting anything other than * from apple returns the expected records when about 900+ values are placed literally in the subquery as shown in example 4 below. Am I missing something? Anyone have a direction for me to look for the cause of this? Thanks Stephen EX 1 select rowid from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 2 select rownum from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; no rows selected EX 3 select * from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 4 select count(*) from common.apple where appleinter1 in ( 7009 , 7010 , 7011 , 7012 , 7013 , 7014 , 7015 , 7016 , 7017 , 7018 , 7019) and appletermd is null and rownum < 10 ; --- 9 rows returned, I removed them for confidentiality reasons --- EX 5 select count(*) from common.apple where appleinter1 in (select pearinternal from common.pear where pear_clnt_src_cd = 'CCN') and appletermd is null; COUNT(*) 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Boligan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: List problems
Jared/Bruce: Is this still being worked on? I'm not seeing a lot of volume nor anything I've sent recently. Stephen >>> [EMAIL PROTECTED] 01/14/04 07:54AM >>> Folks, It seems that a fair number of emails are not being retransmitted to the list. Some of mine and a few others have not appeared in list traffic sent out to subscribers. Searching by author at fatcity.com reveals that the posts made it there, but either are not being sent out, or getting shanghaied along the way. I'll let you know when I find out. I am of course, assuming that some of you will get this one... Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: most practical 9iR2 features?
Brad, - External Tables have the potential to be WOW and when properly used instead of SQLLDR can meet #1 & 4. - Resumable transactions Stephen >>> [EMAIL PROTECTED] 01/15/04 10:14AM >>> Hey listers I am doing some research and would like to get (in very short answers) features of 9iR2 that folks have implemented that meet the following goals: 1. Ease administration 2. Are not marketing crap 3. Are not already in 8.1.7 4. Increase response time and or perfromance A quick bullet list would be way cool of stuff that make you puff up and say "...this is so cool" We are going to be moving our MRP system from 8.1.7 to 9iR2 this year and I'd like to get a feel for which items can help our old MRP app. Reply direct if you desire. We'll be implementing a new box with a SAN and so we already have some plans for actually using some features in 8i that were not feasible on our old AutoRAID. (There's nothing like getting a new box...) (I am already reading the new features doc and another doc by Howard Rogers) Thanks in advance Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: ADMIN: Status of list server systems (and update about
Bruce, My hat is off to your hard work to keep lists like this running. I know that I (and I'm sure many others) appreciate the huge brain trust that has come together here. Thanks and keep up the good work!!! Stephen >>> [EMAIL PROTECTED] 01/19/04 06:39PM >>> Folks -- I have good news and bad news. ;-) First the good news: Several people had mentioned that they've sent messages to some lists but have not seen the posts arrive back to them. These messages DID appear in the archives though. This started roughly 12-Jan-2004. I had previously researched this issue but could find no reason for it happening, nor a solution. Up until today, that is. The cuplrit was one of my load balancers for mailing list traffic. It was handling traffic correctly on some of the machines, but squirreling away messages sent to one specific server. I'd estimate about 1/8th of the messages sent to mailing lists since 12-Jan-2004 were not redistributed properly. I have since found and fixed the problem, so this shouldn't happen in the future. I suspect I was only able to re-send a portion of the missing messages, so my apologies for anyone who posted a message that didn't make it to a list. Also, my apologies to everyone who has to deal with the increased traffic of the old messages, plus current messages, plus the inevitable onslaught of re-posts that will occur in the next few days. Please be patient with each other. So the good news was: problem found, problem fixed, some catch up done, shouldn't happen again. The bad news is that this morning (roughly 7am PST), a construction crew near Fat City cut through a section of telecom cable that was critical for our connection to the net. They've been working feverishly on it all day, but Fat City was off the net most of the day. Until about 3pm PST. I believe things are about back to normal right now, but there's always a ramp-up time to truly get back to normal. My apologies to anyone who was affected by our downtime. If you have any questions or concerns about anything, please let me know. Thanks, Bruce Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: AQ
However... do not blindly treat SQL*Net messages as Idle waits. They can be important indicators of networking issues. Stephen >>> [EMAIL PROTECTED] 01/20/04 08:24AM >>> It is defined as below in the Reference Guide: "The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to arrive so that the session can dequeue that message." I would treat it as an Idle Wait, similar to, SQL*Net message from client. - Kirti --- "Ehresmann, David" <[EMAIL PROTECTED]> wrote: > > Is "queue message" an idle or an non-idle wait event? I have looked through > the docs at tahti and metalink and can't find much info on AQ. Does anybody > know where there are resources on this topic? > > thanks, > > David Ehresmann > > -- > __ Do you Yahoo!? Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-904 after table rename
One thing I've been looking for is a way to set a string parameter in another session, The two you mention handle INTEGER and BOOLEAN. I want a way to set TRACEFILE_IDENTIFIER to a string in another session to make it easier to identify trace files. Any ideas? Stephen >>> [EMAIL PROTECTED] 01/20/04 01:39PM >>> You can also use DBMS_SYSTEM.SET_INT_PARAM_IN_SESSION and DBMS_SYSTEM.SET_BOOL_PARAM_IN_SESSION, in lieu of oradebug. -Mark Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI "Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is." --Unknown -Original Message- Sent: Tuesday, January 20, 2004 3:25 PM To: Multiple recipients of list ORACLE-L On 01/20/2004 02:59:35 PM, Tanel Poder wrote: > Hi! > > Note that when you set an event with alter system, it will only apply > for > new sessions created, not for any existing ones. And that, exactly is the problem. First, when you set event using alter system, the setting is system wide. Second, if you want to inspect a session that is currently executing, you can't. Oradebug is a kludge, but it works. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bobak, Mark INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Metalink on the blink
I've just logged in and reviewed an old TAR and did a survey on a closed TAR. Maybe it's you :) >>> [EMAIL PROTECTED] 01/22/04 07:59AM >>> Is anyone else having problems with Metalink this morning or is it just us? We can't log in at all. Matt Matt Adams - GE Appliances - [EMAIL PROTECTED] "The swim only hurt once - from the beginning to the end" - Doc Counsilman on swimming the English Channel at age 58 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Startup Migrate
Joe, I didn't do that many, but the 6 or so times that I have used it, it worked fine. >From what I read, it basically does a startup restrict, IIRC. Have fun, Stephen >>> [EMAIL PROTECTED] 01/22/04 02:29PM >>> Joe - I just know that it works. I used it to upgrade about 20 instances. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 22, 2004 3:14 PM To: Multiple recipients of list ORACLE-L I'm looking at the notes to apply patch 4 to Oracle 9.2.0.3. After installing the products.jar file, one of the steps is to run startup migrate then run catpatch.sql I've looked on technet as well as the documentation CD and can not find any info on startup migrate. Can someone point me in a direction to find out about this? All I can find is that it's new in 9.2. Thanks, Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe LaCascio INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Solaris: Finding the cause for disk space growth
Naveen, Since you are new to Solaris, how new are you to unix/linux? If you are already aware of anything, I apoligize: spool the output of df -k to a file. I really like the script command for this. Wait some time (long enough for more disk to get used) and do it again (rename the first file if you used script). Then diff list1 list2 This should tell you which mount point changed. Since you are asking this in an Oracle forum, I'll guess that the mount point that is growing is related to an Oracle database. At a similar interval to the df command above, run something like this in your Oracle database. If you have more than one, do it in all, but spool to a instance_specific file name: spool begin (or end) select tablespace_name, sum(bytes)/1024 "Kb" from dba_extents group by tablespace_name order by 1 asc; spool off diff begin end will tell you which tablespace is growing. You can then modify the query above to see which object is growing in that tablespace. I won't write that one for you or you won't get a chance to learn anything from this Good luck and let us know how it goes. Stephen >>> [EMAIL PROTECTED] 01/23/04 01:44AM >>> Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing. Is there any way to find out? Regards Naveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: What to look for in STATSPACK report
I've tried to get ahold of Anjo off-list several times. I'm sure he is busy, but I really need to get ahold of him. Can someone off-list ask him to e-mail me at either/both of these addresses? [EMAIL PROTECTED] [EMAIL PROTECTED] Thanks Stephen >>> [EMAIL PROTECTED] 01/23/04 12:19AM >>> Hi Tim, Are you sure it's still owned by Veritas? Doesn't look that way when I checked it just now. Mogens Tim Gorman wrote: >Helmut, > >Register with "http://www.oraperf.com"; and run those STATSPACK reports >through the YAPP analyzer, which will reformat them in such a way that they >make sense. > >All of the ratio stuff on the STATSPACK report is ignored by the YAPP >analyzer, and instead the reformatting looks at things from the standpoint >of response-time analysis, as described in the white papers at >"http://www.oraperf.com/whitepapers.html";. > >Yes, I know OraPerf is now owned by Veritas and the real URLs are different, >but it'll always be just good old "oraperf.com" hopefully, no matter who >Anjo works for... :-) > >Hope this helps... > >-Tim > > >on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: > > > >>Hi! >> >>We want to introduce a performance monitoring policy here. We are using the >>STATSPACK utility. >> >>What are sections in statspack reports to look for? What are threshold >>numbers for these values? >> >>Does anybody have any power points or papers about it? >> >>This is 9.2 on HP-UX. >> >>Thanks, >>Helmut >> >> >> > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Multiple Listeners
Dick, Well, I've not seen the bug you describe and we have over 20 db's in one listener on several different boxes. We are in 8.1.6 on Compaq Tru64. We did have a problem trying to get one listener in 8.1.6 to listed for 8.0.x and 7.3.x databases and WWS discovered that a bug they thought was fixed in 8i was not fixed for Compaq. We're now looking at OID. Any horror/success stories out there? Stephen >>> [EMAIL PROTECTED] 07/16/01 04:47PM >>>Alex, This gets down to the amount of trust your damagement has in you. If theyare more tempted to listen to outside assertions that you have already heard,then it's time to move on because your being treated like a trained monkey. Mymanagement does ask questions on this type of subject when they've heardsomething new outside. It's normally just tossed in my direction as a "Hey Iheard that these folks are doing this. What do you think?". In which case Inormally find out what their doing & why and what Oracle says about it as well. If it does not make sense, it ends up in the round file & there is no morediscussion. It also helps to have management types who have some knowledge ofthe technology. The result is less of the problem you state. From a listener perspective, there is only one absolutely good reason thatI've found to run more than one listener per node & that is that after you pass10 DB's in one listener it appears to run out of memory & won't listen for theothers. I did find a bug on Metalink on the subject, but it was suppose to havebeen fixed in 8.0.6 though I've not verified that. Dick GouletReply SeparatorAuthor: "Hillman; Alex" <[EMAIL PROTECTED]>Date: 7/16/2001 3:01 PMBecause the more listeners you have - the better. If your damager ask youhow many listeners you are running and you answer one and he/she ( no sexizm:-)) heard that someone running 2 or 3 ( from another moro... err damager) -how would you explain why you are running only one. I hope that Ross can add more reasons to run at least 2 or better 3listeners.Alex Hillman-Original Message-Sent: Monday, July 16, 2001 6:21 PMTo: Multiple recipients of list ORACLE-LIt is possible to define 3 listeners on 3 different ports, each oneserving another database, but why would you do dat? You have 3 littledatabases and one big bad listener whichs huffs and puffs and connects your clients to the instance of their choice. What would you benefit fromhaving 3 listeners?> -Original Message-> From: Edward W. Carr [mailto:[EMAIL PROTECTED]]> Sent: Monday, July 16, 2001 5:42 PM> To: Multiple recipients of list ORACLE-L> > I am currently running Oracle 816 64bit on a Solaris 8 box. > I have three> databases on the system with one LISTENER for all of them. > Is it possible> to configure multiple listeners, one for each database? We > have tried in> the past with no success... If there is a document on the web > somebody could> point me to, that would be great! I have searched for one > but must not be> searching correctly.> > TIA,> --> Edward W. Carr> UNIX Systems Administrator> Qwest Communications> Broadband Services Inc.> > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Gogala, Mladen INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hillman, Alex INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
Steve, As far as speeding up the sqlldr process, you could take a look at an article on O'Reilly's web site. It's at http://oracle.oreilly.com/news/oraclesqlload_0401.html and documents the fairly painless process I used to speed up data loads we are doing here. HTH Stephen Andert >>> [EMAIL PROTECTED] 07/27/01 12:02PM >>>Does anyone know of a way to inhibit rollback from being generated for DML?We've got a data warehouse load process that we're trying to speed up(involving sqlldr and then some DML afterwards.) The staging tables it usesare entirely for this process -- there's no need to rollback if it fails;we'd truncate them and start again with that set of data.Aside from sqlldr direct mode and import direct mode, can anyone think ofways to do this? Thanks,Steve-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Austin, Steve S INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: sqlloader process dies
Lyuda, What are your settings (BINDSIZE, ROWS, etc)? Also how big and how many rollback segments do you have? How big is their tablespace? If you have any questions, please feel free to drop me a note. Stephen Andert>>> [EMAIL PROTECTED] 07/31/01 04:30PM >>>I could do it but the trick it to load it all at once...-Original Message-Sent: Tuesday, July 31, 2001 7:06 PMTo: Multiple recipients of list ORACLE-LWhy don't you try to divide this load in several parts.Alex Hillman-Original Message-Sent: Tuesday, July 31, 2001 6:26 PMTo: Multiple recipients of list ORACLE-LThank you Kevin.No, drive has plenty of space.Any one else has a guess?-Original Message-Sent: Tuesday, July 31, 2001 5:07 PMTo: Multiple recipients of list ORACLE-LSince it can't create a log file either ... how about space ??? running outof space on the machine ??-Original Message-Sent: Tuesday, July 31, 2001 3:42 PMTo: Multiple recipients of list ORACLE-LHi,I am experiencing a problem with sqlloader not being able to finish a largeload. It tries to load between 1 and 2 millions records. Sometime duringthe load it just dies. I see an attempt to create a log file but the filesize remains 0 bytes. It remains 0 size until the next day when new processkicks off. The described scenario occurs day after day. It is a cron jobkicked from a batch file running multiple loads simultaneously. There aretwo particular loads that die every day...Anyone has any idea?Thank you for your help Lyuda-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Kevin Lange INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Hillman, Alex INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: (Fwd) Oracle8i Database Administration Boot camp
Rachel, I did that when I worked at a bank where smokers took 2 10-15 minute breaks in the am and at least 2 in the pm. I went out with a buddy. One day my mgr walked in and said "Steve, I didn't know you smoked. What are you doing out here?" I said I was taking my second-hand smoke break since that was the only way to get away from my desk sometimes. It worked. Stephen Andert>>> [EMAIL PROTECTED] 07/31/01 10:10PM >>>there are times I regret giving up smoking -- I want the cigarette breaks.I wonder if I can get away with a non-smoking break hm.>From: Kimberly Smith <[EMAIL PROTECTED]>>Reply-To: [EMAIL PROTECTED]>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>>Subject: RE: (Fwd) Oracle8i Database Administration Boot camp>Date: Tue, 31 Jul 2001 14:26:18 -0800>>I go as often as possible. Gets me away from my desk.>>-Original Message->Sent: Tuesday, July 31, 2001 1:42 PM>To: Multiple recipients of list ORACLE-L>>>DBAs don't go to the bathroom. We're above that kind of thing. BARKEEP!>Get me another cold one!>>--- April Wells <[EMAIL PROTECTED]> wrote:> > You HAVE to add another 30 seconds for bathroom break from the beer...> > maybe> > said lunch hour... meant lunch min (1 min 7.395 seconds)???> >> > -Original Message-> > Sent: Tuesday, July 31, 2001 2:31 PM> > To: Multiple recipients of list ORACLE-L> >> >> > http://wearables.stanford.edu/> > -> >> > the campus *does* have a 40 foot high training wall and rope> > suspension tower complex built by the ROTC, so when they> > say "boot camp", maybe they really mean it?> >> > btw, what dbas take one hour to eat? i thought it only takes,> > on average, 37.395 seconds for a typical dba to swallow a> > jumbo pack of M&Ms and drink a beer (add one second to that> > if the dba is doing a hotbackup of OPS during the "lunch break").> >> > --> >> > From: "Page, Bruce" <[EMAIL PROTECTED]>> > Date: Mon, 30 Jul 2001 16:26:00 -0400> > Subject: RE: (Fwd) Oracle8i Database Administration Boot camp> > [small/Sacr> >> > > A USB port connection wired straight to earphones and special eye> > > wear.> >> > >> I would be curious how one can obtain to be "amoung the best"> > >> after a single> > >> 7.5 hour course which I assume has an 1 hour lunch when most> > >> training does> > >> similar in about 80-180 hours.> >> >> > --> >> > --> > Please see the official ORACLE-L FAQ: http://www.orafaq.com> > --> > Author: Eric D. Pierce> > INET: [EMAIL PROTECTED]> >> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> > San Diego, California -- Public Internet access / Mailing Lists> > > > To REMOVE yourself from this mailing list, send an E-Mail message> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> > the message BODY, include a line containing: UNSUB ORACLE-L> > (or the name of mailing list you want to be removed from). You may> > also send the HELP command for other information (like subscribing).> >> >> >> > The information contained in this e-mail is strictly confidential and> > for the intended use of the addressee only; it may also be legally> > privileged and/or price sensitive. Notice is hereby given that any> > disclosure, use or copying of the information by anyone other than the> > intended recipient is prohibited and may be illegal. If you have> > received this message in error, please notify the sender immediately by> > return e-mail.> >> > Corporate Systems, Inc. has taken every reasonable precaution to ensure> > that any attachment to this e-mail has been swept for viruses. We> > accept no liability for any damage sustained as a result of software> > viruses and advise you carry out your own virus checks before opening> > any attachment.> >> > --> > Please see the official ORACLE-L FAQ: http://www.orafaq.com> > --> > Author: April Wells> > INET: [EMAIL PROTECTED]> >> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> > San Diego, California -- Public Internet access / Mailing Lists> > > > To REMO
Re: Privileges
Laura, You need to do the grants directly to the user that is creating the procedure/package. Major pain. I didn't believe the developers when they told me that, but after adequate testing I realized they were right. Roles are still good for managing security of the rest of the db users, it's just managing the developers that is a pain because of this. Have fun. Stephen Andert>>> [EMAIL PROTECTED] 08/07/01 09:00AM >>> I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when developing a procedure/package in Procedure Builder under program units, and then dragging it down to the bottom as user1 procedures, an error stating 'insufficient privileges on owner1.tablename' is received. Any ideas?? I have researched the 'grant execute on procedure' privilege but I don't see why I would need to do this for the table owner. My understanding of this privilege is to grant another user access to the procedure and maintain security in this way, instead of having to grant access to each user individually. Laura
Re: sqlloader stops
Lyuda, I'll jump into the game of 20 questions. Is the batch file kicking off the jobs in serial (one after the other) or in parallel (maybe using & to put each one in the background)? Stephen Andert>>> [EMAIL PROTECTED] 08/08/01 07:06AM >>>If I execute one load at the time maually it loads fine. It gives me hardtime when I try to run multiple loads(one after another) through the batchfile.- Original Message -To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Tuesday, August 07, 2001 9:05 PM> How about using some GUI tool (or even SQL) to see what> SQL its running, if any, and what counters and waits are> incrementing...>> Good luck, keep in touch :-)>> Yosi>>> [EMAIL PROTECTED] wrote:>> > Thanks Yosi.> > No, that is not the case..:-(> >> > -Original Message-> > Sent: Tuesday, August 07, 2001 5:37 PM> > To: Multiple recipients of list ORACLE-L> >> > Silly ol' me. Are you out of space in your archive log destination?> >> > This is like a guessing game. :-)> >> > [EMAIL PROTECTED] wrote:> >> > > Hi List,> > > I have another problem.> > > I have a process that loads multiple (~ 20 ) files through sqlloader.It> > > works fine on other servers. There is this one server that is givingme a> > > hard time. It loads 3 files and then stops. I commented out thethird> > call> > > to sqlloader thinking may be there is something wrong with a thirdtext> > > file. It loaded 3 files again and stopped on the forth one.> > > There is nothing in alert log (no errors). Also, there is enoughspace on> > > the drive where the logs are going.> > > Oracle 7.3.4 on NT.> > > If anyone has any idea please let me know...> > >> > > Lyuda Hoska> > > (703)797-8656> >> > --> > Please see the official ORACLE-L FAQ: http://www.orafaq.com> > --> > Author: Yosi Greenfield> > INET: [EMAIL PROTECTED]> >> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> > San Diego, California -- Public Internet access / Mailing Lists> > > > To REMOVE yourself from this mailing list, send an E-Mail message> > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> > the message BODY, include a line containing: UNSUB ORACLE-L> > (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).>> --> Thanks,>> Yosi>>> -> Yosi Greenfield> Oracle Certified DBA> [EMAIL PROTECTED]>>> --> Please see the official ORACLE-L FAQ: http://www.orafaq.com> --> Author: Yosi Greenfield> INET: [EMAIL PROTECTED]>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051> San Diego, California -- Public Internet access / Mailing Lists> > To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (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: lyudah INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: STOP THE PRESS!!
To quote a movie line that rang true (I forget which movie), "I'm not worried about the guy with a dozen nuclear warheads, he's just in it for the money. The guy who just wants one is a fanatic." >>> [EMAIL PROTECTED] 09/11 12:00 PM >>> We need to be cool, calm, convinced and know what we want to hit - and utterly destroy it. Completely. We are not at risk from rougue states with nuclear missless. It's the terrorist fanatics with a suitcase and a warped purpose that's our biggest threat. -Original Message- Sent: Tuesday, September 11, 2001 10:16 AM To: Multiple recipients of list ORACLE-L friend of mine just saw Bush's plane, flying super low and surrounded by *stealth fighters* heading for Andrews' Man, I hope there is a R E S P O N S E to this, and soon. -Original Message- Sent: Tuesday, September 11, 2001 11:50 AM To: Multiple recipients of list ORACLE-L I am wondering whether this was an attack from outside, or from people like Timothy McVeigh. It seems to be awfully well co-ordinated, how could they breach security to that extent. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -- 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: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John 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: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT Terrorist Acts
Rachel, Glad to see you are ok! I was glad to see the message from Ross saying you were ok. Stephen Andert >>> [EMAIL PROTECTED] 09/11 6:35 PM >>> just because we will have to kill does not mean we have to like it. It's what separates us from animals. My heart is bleeding for the families of those lost in this tragedy. >From: "Thater, William" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: OT Terrorist Acts >Date: Tue, 11 Sep 2001 08:30:28 -0800 > >At 12:15 PM 9/11/2001, you wrote: >>Yes, I see that and wish i could remove it. Consider it done >> >>We've just heard the towers went downjust incredible..i had >>never thought that i'd be there at the start of World War III. >> >>And wanted very badly to fight in it. > > >to you all: > >someone once said "those who hate war the most are those best trained in >it's use". trust me, you DON'T want to fight in a war. you may end up >doing just that, but you don't want to. > >i had friends who's pentagon offices were where the impact was. > >and i wish death wasn't a friend of mine. > > > > >-- >Bill "Shrek" Thater 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. > >Stack Error: Lost on a cluttered desk... > > > >-- >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). _ 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: 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: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: The DBA in the IS organization
At my last job, my supervisor reported to the Manager of IT as did the manager of AppDev. Where I am now, there are so many levels of damanagement (ok some of them are managers not DAmanagers) that all I know is that the AppDevs, SAs and DBAs all report to a different VP. So when a group doesn't want to cooperate, it's pretty easy for them to hold up the show. But there are some groups of SAs, DBAs and AppDevs that work towards a common goal and don't let the overhead of management get in our way. And I'm logging in from home just to do some preventative maintenance. Whoever made the comment about VPN is right... it makes long hours and on-call tolerable. Have a nice weekend. Stephen >>> [EMAIL PROTECTED] 09/15 4:55 AM >>> I am wondering how my fellow DBA's fit into their IS organization. My situation is this. I was hired just a little over a year ago as a DBA but my official title is network programmer. Except for some job scripting I have not done any coding. I am the only DBA for 5 Oracle databases and 4 SQL Server installations. Currently my boss is the head of development. I work with the developers and with the network admins equally. I sometimes feel a bit of a conflict with me being under the developers. I have been thinking about approaching the VP of IS about having me be under him rather than being under development. I feel I need to have equal footing with the development managers and with the network admins. Right now I am kind in limbo with no real authority. So anyway, I am just wondering where you fit in your organization and what is the appropriate place for the DBA. And yes I got called into work. Sucks to be me today. :o) 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: {9i New Feature: Query Flashback }: This one is long
If he is preparing a presentation, it is definitly one I won't want to miss. Stephen Andert>>> [EMAIL PROTECTED] 10/23/01 02:40AM >>>I think Joe's just doing it to be helpfuland as a way of learning the 9i stuff... he has to play with it to beable to write about it--- Larry Elkins <[EMAIL PROTECTED]> wrote:> As always Joe, we appreciate these updates. And if it is never> ending,> that's fine by me. The way you have taken care to write up the> features,> issues, and caveats makes me think this series is destined for a> presentation?> > Technet also has a series going on regarding 9i features. It is> fairly> useful from a high level standpoint. Of course, it is Oracle's side> of the> story. A bit different from Joe's going through the features and> giving the> "real story" and experiences.> > Regards,> > Larry G. Elkins> The Elkins Organization Inc.> [EMAIL PROTECTED]> 214.954.1781> -Original Message-> Sent: Monday, October 22, 2001 12:05 PM> To: Multiple recipients of list ORACLE-L> > > Query Flashback> > This is part 3 of a what will seem to be a never-ending series on new> 9i> features. :)> > This topic follows up on last weeks on Automated Undo> Management(which is a> requirement for Query Flashback).> >> > > What is Query Flashback?> > Flashback Query lets you view and repair historical data. It offers> the> ability to perform queries on the database as of a certain wall clock> time(look under the limitations section about this) or> user-specified> system change number (SCN). Once the errors are identified, undoing> the> updates is a straightforward process that can be done without> intervention> from the database administrator. More importantly, the restoration> can be> achieved with no database downtime.> >> > > Setting Up the Database for Flashback Query> > Use automatic undo management to maintain read consistency, rather> than the> older technique using rollback segments.> > You MUST HAVE an undo tablespace to make this work. Now did I try it> with> Rollback segments, nope, but based on what I've read it would make no> sense> to even try it as we all know that RBS get reused.> > Set the UNDO_RETENTION init.ora parameter to a value that represents> how far> in the past you might want to query(it is in seconds). If you only> need to> recover data immediately after a mistaken change is committed, the> parameter> can be set to a small value. If you need to recover deleted data from> days> before, you might need to say 86400 * number of days(since 60 * 60> *24 => 86400).> > Now keep in mind, if you tell Oracle to keep like one days worth of> undo,> you set the UNDO_RETENTION to 86400 and there is not enough free> space in> the tablespace to keep that much, then Oracle will ignore that keep> time and> start reusing the oldest undo.> > Grant EXECUTE privilege on the DBMS_FLASHBACK package to whoever> needs it.> >> > > Potential applications of flashback query are:> > Recovering lost data or undoing incorrect changes, even after the> changes> are committed. For example, a user who deletes or updates rows and> then> commits can immediately repair a mistake.> > Comparing current data against the data at some time in the past. For> example, you might run a weekly report that shows the change from> last week,> rather than just the current aggregate data.> > Checking the state of transactional data at a particular time. For> example,> you might want to verify an account balance on a certain day.> >> > > Important notes about query flashback> > Flashback Query does NOT undo anything.> > Flashback Query does NOT tell you what changed thats what LogMiner> does(thats coming up in a few weeks).> > Flashback Query can be used to undo changes and can be very efficient> if you> know the rows that need to be moved back in time.> > Flashback Query does not work through DDL operations that modify> columns, or> drop or truncate tables.> > >> > > Limitations of Flashback Query> > Some DDLs that alter the structure of a table, such as drop/modify> column,> move table, drop
RE: i need check fragmentation of index
Watch out though! From the 8.1.6 documentation: "Validating the structure of an object prevents SELECT, INSERT, UPDATE, and DELETEstatements from concurrently accessing the object. Therefore, do not use this clause on thetables, clusters, and indexes of your production applications during periods of highdatabase activity." I didn't realize that until users started complaining when I tried this a while back. Stephen >>> [EMAIL PROTECTED] 10/26/01 04:10AM >>>Alex,This script is based around an analyze index . validate structure asmentined by Deepak---set verify offset pagesize 35set linesize 132set pause onset pause 'Hit enter to continue'set feedback offset showmode offset echo offset space 0set heading offset termout off pause offcolumn blsk new_value BLOCK_SIZE_Kselect value / 1024 blskfrom v$parameterwhere name = 'db_block_size';set termout on pause offPROMPTACCEPT USER_INPUT1 CHAR PROMPT 'Please enter a index to analyze:>'ACCEPT USER_INPUT2 CHAR PROMPT 'Please enter a owner to analyze:>'PROMPTPROMPT Working, Please wait.PROMPTanalyze index &USER_INPUT2..&USER_INPUT1 validate structure;col ROWS_PER_KEY format 999.99 heading ' 'col BLKS_GETS_PER_ACCESS format 99,999.99 heading ' 'select' Name of the index = ' || NAME,' Height of the b-tree = ' || HEIGHT,' Blocks allocated to the index = ' || BLOCKS,' Number of leaf rows (values in the index) = ' || LF_ROWS,' Number of leaf blocks in the b-tree = ' || LF_BLKS,' Sum of the lengths of all the leaf rows = ' || LF_ROWS_LEN,' Useable space in a leaf block = ' || LF_BLK_LEN,' Number of branch rows = ' || BR_ROWS,' Number of branch blocks in the b-tree = ' || BR_BLKS,'Sum of lengths of all the branch blocks in the b-tree = ' || BR_ROWS_LEN,' Useable space in a branch block = ' || BR_BLK_LEN,' Number of deleted leaf rows in the index = ' || DEL_LF_ROWS,' Total length of all deleted rows in the index = ' ||DEL_LF_ROWS_LEN,' Number of distinct keys in the index = ' || DISTINCT_KEYS,' How many times the most repeated key is repeated = ' ||MOST_REPEATED_KEY,' Total space currently allocated in the b-tree = ' || BTREE_SPACE,'Totl space that is currently being used in the b-tree = ' || USED_SPACE,'% of space allocated in the b-tree that is being used = ' || PCT_USED,' Average number of rows per distinct key = ' || ROWS_PER_KEY,'Expected number of consistent mode block gets per row = ' ||BLKS_GETS_PER_ACCESSfrom index_stats;col NAME format a30 fold_aftercol dummy_col_0 fold_aftercol dummy_col_1 fold_aftercol dummy_col_2 fold_aftercol LF_ROWS format 9,999,990 heading ' 'col DEL_LF_ROWS format 9,999,990 heading ' 'col BR_ROWS format 9,999,990 heading ' 'col DISTINCT_KEYS format 9,999,990 heading ' 'col MOST_REPEATED_KEY format 9,999,990 heading ' 'col ROWS_PER_KEY format 9,999,990 heading ' 'col HEIGHT format 0 fold_after heading ' 'col BLKS_GETS_PER_ACCESS format 99,999.99 fold_after heading ' 'col LF_BLK_LEN format 9,990 fold_after heading ' 'col lf_row_size format 990 fold_after heading ' 'col lf_row_per_blk format 990 fold_after heading ' 'col BR_BLK_LEN format 9,990 fold_after heading ' 'col br_row_size format 990 fold_after heading ' 'col br_row_per_blk format 990 fold_after heading ' 'col meg format 999.90 fold_after heading ' 'col lf_meg format 999.90 heading ' 'col lf_meg_pct format 99.90 fold_after heading ' 'col br_meg format 999.90 heading ' 'col br_meg_pct format 99.90 fold_after heading ' 'col uu_meg format 999.90 heading ' 'col uu_meg_pct format 99.90 fold_after heading ' 'col bt_meg format 999.90 heading ' 'col bt_meg_pct format 99.90 fold_after heading ' 'col btu_meg format 999.90 heading ' 'col btu_meg_pct format 99.90 fold_after heading ' 'col btuu_meg format 999.90 heading ' 'col btuu_meg_pct format 99.90 f
Re: Oracle related docs/OCP materials
Boy, this was sure a disappointment. No white papers that I could find. The What's News section is listing the 9i beta test offer which expired nearly a month ago. The only thing there was the change to spend money on your 2 products. :( >>> [EMAIL PROTECTED] 11/10/01 08:00AM >>>Hi, We created new site for all Oracle related Peoples..Oracle news, books, documents, OCP materials.. all of them in www.bazaarturk.com Please visit us.. ThanksBazaarTurk___Send a cool gift with your E-Cardhttp://www.bluemountain.com/giftcenter/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Bazaar Turk INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Oracle related docs/OCP materials
Yes, it is a big part of why I was able to pass my Performance Tuning OCP test. Stephen >>> [EMAIL PROTECTED] 11/13/01 09:55AM >>> Have you guys checkout out www.freeocp.com created by one of our own list members Mr. Ethan Post? -Original Message-From: Arslan Bahar [mailto:[EMAIL PROTECTED]]Sent: Tuesday, November 13, 2001 10:25 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Oracle related docs/OCP materials these sites contain some resources www.oraclenotes.com http://certcities.com/ http://www.oraclepower.com/ -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Santosh VarmaSent: Tuesday, November 13, 2001 9:55 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Oracle related docs/OCP materials I also found the site not useful. it did not have any documentation/tutorials at all. regards,Santosh Varma
Re: Help with a scripting problem
Ron, First of all, is echo a SQL*Plis command? Secondly, I think this will do what you want: select 'host "c:\program files\resource kit\robocopy"' from dual; as long as what you want is to execute the robocopy program from the SQL*Plus prompt. If you want to do something else, clarify your intentions on the list. Stephen >>> [EMAIL PROTECTED] 10/08/03 04:34PM >>> I am trying to issue the following command in SQL*PLUS but it doesn't like the space between 'program' and 'files'. Can anyone tell me how to get around this? echo select 'host c:\program files\resource kit\robocopy;' from dual; Thanks! Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Wow, Man, Flashbacks!
Bambi, Are you using automatic undo management or manual? I think that flashback can only be used with auto. Stephen >>> [EMAIL PROTECTED] 11/06/03 10:04AM >>> Hi Folks! I got waylaid(?) when I got in this morning and these user dudes were talking about using flashbacks, and I was like "Woah! Dudes! Let's just chill on this for a couple of minutes". So, I went back to my desk and checked out a cool article on it... http://www.oracle-base.com/Articles/9i/FlashbackQuery.asp And it looks like it's like, killer, yknow? So, I was thinking "well, we've got sufficiently large undo segments for this, I don't see a problem with it" but that didn't sound terribly cool, and anyway, before I go willy-nilly saying this is the niftiest thing Oracle's done in years, I thought I would run it by you guys and see if anybody out there is running with flashbacks and whether there have been any problems with it. Yer far-out pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bellow, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Change dedicated server to shared server
Well, I just paged through the front part and it says nothing about 9i coverage. I don't use MTS, so I'm not a good judge on what it covers that may apply to 9i or not. The rest of the book I can judge and find it (IMHO) to be a very good book on Oracle Network communication, both with good clear overviews as well as detailed references for troubleshooting and configuration. Stephen >>> [EMAIL PROTECTED] 11/07/03 09:19AM >>> The actual titile is "Oracle Net8: Configuration and Troubleshooting", but I remember a good start to 9i's Oracle Net features being included as well. Melanie -Original Message- Sent: Friday, November 07, 2003 10:58 AM To: '[EMAIL PROTECTED]' If you purchase "Oracle Networking (something or other) :-) " by Jonathan Gennick and Hugo Toledo, this should give you an excellent start. I can't recall, off the top of my head if the new MTS 9i init.ora parameters are included in this text. I believe that the latest edition of this book does include them, though ... HTH, Melanie -Original Message- Mauricio Vilez Sent: Friday, November 07, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Hi Can somebody tell me the steps for changing my server configuration from dedicated server to shared server? Thanks _ Do you Yahoo!? Protect <http://antispam.yahoo.com/whatsnewfree> your identity with Yahoo! Mail AddressGuard ** This email 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 the reader of this e-mail message is not the intended recipient, or the employee or agent responsible for delivery of the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is prohibited. If you have received this e-mail in error, please notify us immediately by telephone at (212) 686-6004 and also indicate the sender's name. Thank You www.proximo.com [EMAIL PROTECTED] * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Exam
First of all, I would check your calendar. According to mine, you missed it. >>> [EMAIL PROTECTED] 07/08/03 02:09PM >>> Hi list, I am going to give my Oracle 9i dba fundamentals II ( backup, recovery , networking) exam tomorrow (7th july) . Any last minute advice ? Really nervous about it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle security question
Don, Look at dba_tab_privs. Stephen >>> [EMAIL PROTECTED] 07/11/03 12:44PM >>> Hi, I have a security question about Oracle database. Recently I have taken full control an Oracle database in my department. Now I would like to make sure that no other people except myself can update data in that database. Can somebody tell me what it is necessary steps to do that? Any comments are highly appreciated. Thanks! Don -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: AIX 5.2 Or AIX 5.1 for Oracle 9.2 database server?
hi, Did you get any replies off-list? We are moving to Aix so I'm very interested in this topic. Thanks Stephen >>> [EMAIL PROTECTED] 07/15/03 10:44AM >>> Hi, friends: There is a project that migrate a 9.0.1.3 database on linux server to 9.2.0.3 on aix/p670 server, and I have some question about this project, hope friends in the list can share your idears. 1.Shall I use AIX 5.1 or AIX 5.2? According to pagev http://www-1.ibm.com/servers/aix/os/52features.html, the most attractive of 5.2 is the jfs2 and large page support,cpu-guard and virtual IP Address. But not sure whether Oracle 9.2 will support large page or not(9.2 on linux does support large page of 2MB).Multipath IO is also avaliable for aix5.2. But 5.2 is even newer than 5.1 and I am not sure whether it is stable or not? Does anyone here have experience running 9.2 on aix 5.2? What is the current ML level? Do I need to apply any special patch for database to intall and run smoothly? 2.If using AIX 5.2, we should use 64bit kernel, and according to document, by default it will use jfs2.In jfs2, there is a feature called concurrent IO.Concurrent IO provide much better performance while it is a rather new feature, shall we use it for better performance? Have anyone used it? 3.If using multipathing, will the same disk be recognized by aix as different hdiskN? If yes,How do i solve this problem? Thanks. Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: zhu chao INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: sqlnet.expire_time
Peter, What do you mean it is not working? Are you killing a client application and still seeing it's session in the database 10 minutes later? It does not kill a session just because it is idle, the client needs to have either killed the application, shutdown their pc or been disconnected from the network. Stephen >>> [EMAIL PROTECTED] 07/23/03 02:14PM >>> I am trying to use the sqlnet.expire_time parameter in my sqlnet.ora file to kill connections from dead processes. The entry looks like this: SQLNET.EXPIRE_TIME=10 It does not seem to be working. Any ideas. Oracle 8.1.7 AIX 4.3.3 Client is on w2k. Thanks, Peter Schauss -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Schauss, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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).
Metalink FTP Woes
I've been doing a lot (unfortunately) on Metastink lately and have been having trouble uploading files with their web interface. I've successfully uploaded several files and then when I try and upload another file, I get an error that says the link I'm going to doesn't exist or something about "method not supported". When I directly upload to their ftp site, it works fine. Another weird thing is that one of the files that I was getting errors on, the analyst said they got the file even though the web interface died on me. Anyone else have a similar problem and know if the answer is on Oracle's side or not? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Multiple DBs - Balancing Act
(trying again with "bad" word modified ) Mike, We rated our databases based on factors such as vocal customers, database size (larger database might require special handling), development stage (new, rapidly developed apps tend to cause more work) and daily troubleshooting (anything with a pipeline or materialized views requires more hand-holding, etc) and tried to balance things based on these. This balance also included our model of having a Primary database owner (dbo) and a Secondary dbo. For the most part, being secondary means that if the primary is o.u.t. o.f. t.h.e. o.f.f.i.c.e, you need to pay attention to pages or emails about those databases as well as your primary ones. Is it a fair balance? To some degree probably, but efforts to standardize, so that the on-call person can "plug-in" to any database and not spend a lot of time "learning" another database have been mixed. Some things are under pretty tight control like our Listener Change Control group and is very stable, Redo logs (number of members and groups) have been debated (do you need to mirror with Oracle if you are mirroring with the hardware?) and no consensus has been reached and so we need to do a bit more investigation in some areas when we need to cover for someone. I say give the new guy everything that the others don't want to do . Stephen >>> [EMAIL PROTECTED] 08/11/03 02:39PM >>> This question is for folks who are part of a team that manages multiple databases and multiple platforms. How do you balance the load among your team? We're struggling with this concept right now as we're about to add another DBA to the group. We've considered such things as quantity (how many DBs does each DBA handle), importance (to the company - each DBA has 'n' databases, load (this DB is used 'n' times as much as another one, experience (of the DBA...do we put a UNIX-familiar person in charge of DBs on Windows?) and on and on. But then we stumble on quantifying the terms - importance, load, etc. And we have had some DBs that we considered 'small' become a major PITA when we weren't looking! We just signed a deal making Oracle our DB of choice for the next several years, so we could see an explosion of stuff. So I'm asking...how do you do it? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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).
Merge patches
OK, maybe I'm going crazy or senile, but I seem to recall Oracle stating that if you needed to apply more than 1 patch, you would need to request a merge patch. I think this was about a year ago and caused us to downgrade a database to resolve a problem since the turn-around time for the merge patch was not going to beet our requirements. Does anyone else remember this? Are they still doing this or can multiple 1-off patches be applied now? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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 tell Oracle the directories of script files
export SQLPATH=/usr/users/oracle/dba/scripts:/app/oracle/admin before you run SQL*Plus HTH Stephen >>> [EMAIL PROTECTED] 08/14/03 11:09AM >>> Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user directories, I can load/execute the script by doing: SQL> @scriptname But what if I don't start sqlplus from that directories? How do I tell Oracle to find the scripts in /home/user, then if it's not there in /usr/local/bin, for example? So that I can be anywhere in the filesystem when starting sqlplus and can execute my SQL script. Just like the $PATH environment variables in *nix system that tell the shell where to find executables, is there a similar thing for Oracle? Thanks for any help. RDB -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - /"\ ASCII Ribbon Campaign against HTML \ / email and proprietary format X attachments. / \ - Have you been used by Microsoft today? Choose your life. Choose freedom. Choose LINUX. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Loader help
Rachel, I do not claim to be a guru, but I do happen to have Jonathan's book here. The first thing is what field type are you using for this memo field? The book says you should use CHAR for VARCHAR2, CHAR, LONG and other related. What error are you getting? Can you post the lines from the ctl? Is there a chance there are TAB's in the data? Stephen >>> [EMAIL PROTECTED] 08/29/03 09:24AM >>> I know that there are several sql loader gurus on this list. I'm having a problem loading data from a third party vendor. into what is basically a LONG column The file is ASCII, tab delimited. The specs on the input data say that this particular column is a "memo" field (the originating database is FoxPro.. joy) I'm trying to load this into a 9.2.0.2 database. And it's barfing. This is annoying me no end and so I'm asking for help. I don't have Jonathan's book here with me! (that would, of course, be easy) Rachel __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: sqlload
Syntax looks right. Does the operating system user have read privs on the csv file? Does the database user running this have insert privs on the table? If those are ok, then try retyping the first couple lines of the ctl file as there may be a hidden control character messing things up. Good luck Stephen >>> [EMAIL PROTECTED] 09/02/03 10:19AM >>> PLEASE Can someone help??I have a sqlloader control file below and I am getting the following error when I run it and I just cant see what is wrong!!! Rgds Fawzia [EMAIL PROTECTED]> sqlldr parfile=pants.ctl log=me.log LRM-00110: syntax error at 'LOAD' LRM-00113: error when processing file 'pants.ctl' Control file: LOAD DATA INFILE 'gazza2.csv' APPEND INTO TABLE olsr10_tlmif2.gazetteer1 fields terminated by ',' trailing nullcols (postcode_prefix_spaced char, filler1 char, postcode_prefix char, filler2 char, postcode_range char, filler3 char, town char, filler4 char, county char, valid_date char) ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Malik, Fawzia INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Copying statistics : used a lot ????
Stephane, No time to look at it enough to do it. Also, not a lot of time is spent tuning our test/dev environments. But I'd like to do it. Stephen >>> [EMAIL PROTECTED] 09/11/03 01:37PM >>> HI, I was wandering if a lot of people are copying statistics using dbms_stats from production to test environment to see what will be the access plan. If not used, why ? no time to look at it, bugged, not usefull ,... ? Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: archive old data
Nancy, As with so many things, it depends. If you *might* need some of the data back, then you need to be able to recover it. That means if you do an export, you need to know what version it is and track whether that table ever has any changes. If it does change, you will need to jump through more hoops to restore the data. If the version of oracle changes, you need to be aware of differences when importing data from older versions and should probably do a test before the older version of the database goes away. Safest would probably be to create a flat file (comma-delimited or something like that) and use SQL*Loader or external tables should you need to recover. I would try and get a "safe" date beyond which no one will ever expect recovered data. For example, do you really need line items for orders that are 5 years old? Do you need insurance policy information for policies that expired 10 years ago? Do you need information on employees that left 4 or more years ago? The sooner you can get that information from your business users, the sooner you'll be able to start enforcing data removal. If you can handle that in the database, then partitioning based on the removal date would be useful and let you use partitioning to accomplish the purge easily. Good luck. Stephen >>> [EMAIL PROTECTED] 09/12/03 09:49AM >>> We have some tables that have data for many years. We are going to archive the data that are older than 3 years. I would like to find out how you guys usually do this or a best way to do this. Thanks for any inputs in advance. Nancy _ Fast, faster, fastest: Upgrade to Cable or DSL today! https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nancy Hu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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).
Arizona User Group Meeting 10/2/03
If you are not in AZ, please feel free to press DEL now. It is time for another great AZORA user group meeting. The next meeting is Thursday October 2nd which if you haven't looked at a calendar lately is coming soon. For more information on times/location, please see our web page at www.azora.org. Topic #1: Oracle Selective Audit - Ray Kowalski is a Practice Manager with Oracle Corporation Topic #2: A Close Look at SQL Statement Tuning, Dan Hotka is a Training Specialist Thanks Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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: Client not using tnsnames.ora?
Scott, Where on the client machine is the tnsnames.ora file? Probably is in the $ORACLE_HOME\NETWORK\ADMIN directory or maybe a network drive. Your home is probably c:\ora817 or maybe If you only changed the tnsnames.ora on the server side (i.e. prod), you will also need to update the tnanames.ora file on the client. Good luck. (I'm sure you'll get it) Stephen >>> [EMAIL PROTECTED] 10/04/02 03:33PM >>> Hello all, DB=8.1.7.4.0 DB Server OS=HPUX 11i Client: Windows NT 4.0 I have 3 Oracle instances that were installed on one machine "prod". They are FPRD, FTRN and FTST. I moved FTST to a different machine "dev". I changed the tnsnames.ora files on the clients and the servers, and I changed the listener.ora on the servers. Now I cannot connect to the FTST instance on the "dev" machine from the clients. The TNS_ADMIN env variable is not set either. I tried to set it on one of the clients and it broke all of the other instances. When I do a TNSPING from the clients, it still shows that the client is trying to connect to the "prod" machine even though the tnsnames.ora file on the client is pointing to "dev". I don't know where the client is getting that the FTST database is still located on "prod". I checked the sqlnet.ora file on the clients and servers and they all have "names.directory_path=(TNSNAMES)" The twist to all of this is that if I try to connect using sqlplus from "prod" to "dev" and vice versa, I can connect all day long with no problems at all. So that leads me to believe the issue lies on the Client side. Example: C:\ tnsping ftst.harper.cc.il.us Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=prod)(PORT=1521)) and it should read: C:\ tnsping ftst.harper.cc.il.us Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=dev)(PORT=1521)) Because the tnsnames.ora file reads: FTST.HARPER.CC.IL.US = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = dev)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ftst) ) ) Please help a newbie!!! Thanks so much in advance! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick 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: Stephen Andert 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: Multiple Listeners
Test first We discovered a bug on Tru64 that prevented this from working correctly in at least a couple versions of Oracle. 8.1.7 was suppossed to fix this, but it didn't. 8.1.7.3 did *I think*. >>> [EMAIL PROTECTED] 10/16/02 11:39AM >>> You can use the 'higher' version of the listener for all databases running on <= higher version, unless you need multiple listeners for other reasons Net8 Admin Guide should have enough information. - Kirti -Original Message- Sent: Wednesday, October 16, 2002 1:13 PM To: Multiple recipients of list ORACLE-L DBAs, Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box? Scenario : I am in process of upgrading. There are two databases on a machine db6 and db7 db6 <-> 8.1.6 db7 <-> 8.1.6 db6 and db7 use the "listener" of version 8.1.6 Now, db7 migrated to 8.1.6 I am thinking of something like : db6 <-> listener of 8.1.6 (status quo) db7 <-> listener_817 of 8.1.7 (new version listener) Two separate listener.ora files lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener) Thanks in advance, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: RV: Nuestra Profesión Ing. Sistemas
Esto me dio mucha risa. Alguien lo va a traducir al ingles para el resto de la lista? Esteban >>> [EMAIL PROTECTED] 10/24/02 12:05PM >>> Ups colegas ! @lex Lic. Alexander Ordóñez Arroyo Soporte Tru64Unix & BD Oracle Caja Costarricense del Seguro Social Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] Celular 397-0532 The truth is out there in WWW Tomado de Un amigo Estoy pensando seriamente dejar de ser ingeniero en sistemas 1.- Trabajas en horas extrañas. !Como las putas! 2.- Te pagan para mantener al cliente feliz. !Como las putas! 3.- El cliente paga mucho mas pero tu jefe se queda con casi todo el dinero. !Como las putas! 4.- Cobras por hora pero tu tiempo se extiende hasta que termines. ! Como las putas! 5.- Si eres bueno, nunca estas orgulloso de lo que haces. !Como las putas! 6.- Te recompensan por satisfacer las fantasías de tus clientes. !Como las putas! 7.- Es difícil tener y mantener una familia. !Como las putas! 8.- Cuando te preguntan en que trabajas no lo puedes explicar. !Como las putas! 9.- Tus amigos se distancian de ti y tu solo andas con otros igual que tu. !Como las putas! 10.- El cliente paga tu cuenta del hotel y por horas trabajadas. !Como las putas! 11.- Tu jefe tiene un buen coche. !Como las putas! 12.- Cuando vas a hacer una "asistencia" al cliente estas óptimo. !Como las putas!. 13.- Pero cuando vuelves pareces haber salido del infierno. !Como las putas! 14.- Evalúan tu "capacidad" con horribles pruebas. !Como las putas! 15.- El cliente siempre quiere pagar menos y encima quiere que hagas maravillas. !Como las putas! 16.- Cada día al levantarte dices "!!!NO VOY A HACER ESTO TODA MI VIDA!!!". !Como las putas! 17.- Sin conocer nada de su problema los clientes esperan que les des el consejo que necesitan. !Como las putas! 18.- Si las cosas salen mal es siempre culpa tuya. !Como las putas! 19.- Tienes que brindarle servicios gratis a tu jefe, amigos y familiares. !Como las putas! !Puta! ¿¿Hasta cuándo?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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).
SQL*Net Message to client/SQL*Net more data to client
We have experienced a sudden and dramatic decrease in performance sometime over the weekend (after Sat but before Monday 4 am). In following Gaja's tuning philosophy, I've found that the top 2 waits are usually (always 2 of the top 3) SQL*Net Message to client/SQL*Net more data to client. Everybody swears there have been no changes. SA's say no harware or kernel changes. AppDev say no code changes. DBA (me) says no database changes. WAN folks say no WAN issues and ping is responding at expected speed. SA's say LAN card has had no errors during this time frame and is processing a good number of bytes but nowhere near it's capacity. The application has some very good timing points where there is no human element in response time, but there is a big "unknown" category that is a larger chunk of time than previously. We suspect that is machine wait time of some kind. We just bounced the instance because someone wanted to try it and after being back up for 20 minutes, early indicators are that performance is back to normal. We'll see how long that lasts. We have seen a few client sessions getting errors that indicate connectivity problems (listener not responding, etc) so we wrote a .com file that is repeatedly connecting to the database and will run overnight and stop if there are any errors. Metalink search for SQL*Net waits gives both "tuning advice" and "you can't tune much" notes. I strongly suspect some kind of hardware failure, but don't know where since everyone involved says everything is working fine. Environment Notes: Server 8.1.7.3 Tru64 5.1A (upgrade to A was done a few weeks ago) Compaq GS160 with 16 CPU's and 32 GB RAM (RAM is from memory, so that may be off) Client Open VMS version 7.2 Client is 8.0.5 Any ideas on a next step for finding out the cause (solution) to this drop in performance??? Help Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL*Net Message to client/SQL*Net more data to client
Anjo, They have reported the results of ping times and said that response times are "within spec". They have told me that the network card is handling "x bytes per second without errors" and that the card is capable of many times that throughput. They have swtiched network cards 8 times last week and "tested" each one without any errors. The reason for this testing/card switching was the errors that they were seeing that was causing the box to stop responding. I am asking our swat team to look into the network stats from the response time perspective instead of utilization. Thanks Stephen >>> [EMAIL PROTECTED] 10/29/02 06:23PM >>> This is called "Blame Storming". Every component works "fine" but response time sucks and the problem is some other area. So how do we turn "Blame Storming" into "Brain Storming"? Check out the network components. One of the problems is that the network people look at utilization, instead of response time. They will find that utilization of certain components may be low (due to some problem), and assume that the problem is some where else. Can they tell how long a packet is on your network connection? Anjo. -Original Message- Andert Sent: Wednesday, October 30, 2002 1:28 AM To: Multiple recipients of list ORACLE-L We have experienced a sudden and dramatic decrease in performance sometime over the weekend (after Sat but before Monday 4 am). In following Gaja's tuning philosophy, I've found that the top 2 waits are usually (always 2 of the top 3) SQL*Net Message to client/SQL*Net more data to client. Everybody swears there have been no changes. SA's say no harware or kernel changes. AppDev say no code changes. DBA (me) says no database changes. WAN folks say no WAN issues and ping is responding at expected speed. SA's say LAN card has had no errors during this time frame and is processing a good number of bytes but nowhere near it's capacity. The application has some very good timing points where there is no human element in response time, but there is a big "unknown" category that is a larger chunk of time than previously. We suspect that is machine wait time of some kind. We just bounced the instance because someone wanted to try it and after being back up for 20 minutes, early indicators are that performance is back to normal. We'll see how long that lasts. We have seen a few client sessions getting errors that indicate connectivity problems (listener not responding, etc) so we wrote a .com file that is repeatedly connecting to the database and will run overnight and stop if there are any errors. Metalink search for SQL*Net waits gives both "tuning advice" and "you can't tune much" notes. I strongly suspect some kind of hardware failure, but don't know where since everyone involved says everything is working fine. Environment Notes: Server 8.1.7.3 Tru64 5.1A (upgrade to A was done a few weeks ago) Compaq GS160 with 16 CPU's and 32 GB RAM (RAM is from memory, so that may be off) Client Open VMS version 7.2 Client is 8.0.5 Any ideas on a next step for finding out the cause (solution) to this drop in performance??? Help Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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
RE: SQL*Net Message to client/SQL*Net more data to client
Funny you should mention sunspots since that's what some of our people are saying along with the phase of the moon. When we find a solution (this is business critical, failure is not an option), I'll post a summary. Thanks to all for the suggestions. Stephen >>> [EMAIL PROTECTED] 10/30/02 08:14AM >>> For what it's worth, we had the same thing going on here recently and have not resolved it. In our case, it is a visual basic app running what is essentially a batch job (don't ask me why a batch job was written as a VB app; I just work here). The client is a PC, and the database is on Tru64 (again ... I just work here). Three different PC's were tried. It appears that the tcp_nodelay parameter worked on two of them but not the third (which, as you might guess, is the production box and the one on which it NEEDS to run faster ... Of course!). All the PC's are on the same subnet, going through same routers to get to the same database. If you get the problem resolved, I will be most interested in your solution. Thus far, we have only been able to attribute it either to sunspots or something about the W2K OS on the PC ... both of which, as we all know, are responsible for a lot of unexplained behavior. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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: Stephen Andert 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).
IOUG Papers
Does anyone know what the expected time-frame is for the IOUG paper seletion committee to select papers? I submitted a couple and am on pins and needles. Thanks Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: IOUG Papers
Thanks for the info. >>> [EMAIL PROTECTED] 11/12/02 05:38AM >>> The Focus Area Managers submitted their selections up to the Technical Session Chair and the Director of Educational Programming last week. They have to review the selections for each area and make any adjustments they feel necessary. I would think that notices would be going out to paper authors fairly soon, within the next two weeks possibly. Matt Adams Matt Adams - GE Appliances - [EMAIL PROTECTED] My computer beat me at chess, but I won when it came to kick boxing. -Original Message- Sent: Monday, November 11, 2002 4:09 PM To: Multiple recipients of list ORACLE-L Does anyone know what the expected time-frame is for the IOUG paper seletion committee to select papers? I submitted a couple and am on pins and needles. Thanks Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: Stephen Andert 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).
SUMMARY: SQL*Net Message to client/SQL*Net more data to client
Well, I thought I'd let everyone know what we came up with. First of all many thanks to all who helped, Cary, Jared, Dennis, Anjo and others. Everyone gave me more ammo to point the finger outside the database and some of the suggestions started a better dialogue between our different groups here. The best information I got was from Cary and company at hotsos.com who helped me see how to effectively use a 10046 trace file. The slowest job we had (that was impacting us the most) had a 1-1 parse to execute ratio and had nearly 90% of the trace time spent in SQL*Net wait. Simply by improving the parse to execute ratio, we should eliminate close to half of the waiting time. We did some research into why the application was parsing once per execute and convinced the developers to use the HOLD_CURSORS parameter in the Pro*C compilation. (I had asked a few months before and they said "no need"). Some of the programs worked without a problem, but others had problems due to attempting to reuse "implicit cursors". They are investigating that further and changed it where possible. We also turned on a second nic and changed the tnsnames.ora to use that nic for this db. Those actions together returned us to a reasonable performance, though I still feel that further work on the appdev side is needed to make significant performance improvements. Thanks again to all. Stephen >>> [EMAIL PROTECTED] 10/30/02 08:14AM >>> For what it's worth, we had the same thing going on here recently and have not resolved it. In our case, it is a visual basic app running what is essentially a batch job (don't ask me why a batch job was written as a VB app; I just work here). The client is a PC, and the database is on Tru64 (again ... I just work here). Three different PC's were tried. It appears that the tcp_nodelay parameter worked on two of them but not the third (which, as you might guess, is the production box and the one on which it NEEDS to run faster ... Of course!). All the PC's are on the same subnet, going through same routers to get to the same database. If you get the problem resolved, I will be most interested in your solution. Thus far, we have only been able to attribute it either to sunspots or something about the W2K OS on the PC ... both of which, as we all know, are responsible for a lot of unexplained behavior. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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: Stephen Andert 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: Sr. Oracle DBA Position- Must be 8i and 9i Certified-
I guess the response wasn't overwhelming if he is re-posting this again so soon. I wonder if they missed the whole discussion awhile back about the people who never heard from them after sending resumes. I use the frequency of these messages and the quality of the job as a barometer for the condition of the job market. Stephen >>> [EMAIL PROTECTED] 11/25/02 10:14AM >>> Great opportunity for a Sr. Oracle DBA with 8i AND 9i certification to join this software industry leader in Charlotte, North Carolina. Base salary is in the 90-120K range and depends on experience. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. Interested candidates will be required to complete a company questionnaire that must be submitted with the resume. *Description of duties: Production support of operations required to maintain 7x24 database/application availability. Logical Design and Physical Design in support of Production/Development Database operations and support in Solaris/Linux ORACLE 8i/9i environment. Essential Functions: Backup/recovery, RMAN, Performance tuning, Shell scripting in Korn and Bourne Shells. ORACLE Internet Directory, ORACLE Enterprise Manager, development/documentation of standards and procedures. ORACLE DBA duties to include user management data exports and imports, writing ORACLE scripts, general monitoring of system performance. Assisting users with SQL and PL/SQL needs in day-to-day operations and implementation of logical designs. * Requirements: -Oracle 8i and 9i Certification -7+Years in IT -5+ years of Production Oracle DBA experience..including 8i and 9i -Knowledge of OPS/RAC, OEM -Proficient with SQL, PL/SQL, unix shell scritping -Expert understanding of Oracle architecture -Full understanding of Database concepts -Knowledge of relational database design -Must be a Self-starter. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: One/Charlotte/Certified DBA/Carol We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff 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: Stephen Andert 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).
Database up longer that host?
I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. We had some maintenance last Wed night that bounced the host (Tru64 5.1a cluster) and naturally the database as well. But when I looked at the host uptime compared to the db_uptime.sql, it looks like the database has been up longer than the host. The db is 8.1.7.3. The host is a Tru64 Compaq (er HP) GS160 AlphaWildfire machine. We are in a cluster, but the databases are all still running on one node. 1* select STARTUP_TIME from v$instance SQL> / 27-NOV-2002 18:30:12 SQL> @db_uptime Database Uptime Host Name : dgrdb01.firsthealth.com Instance Name : CLAIM Uptime : 4days 21hours 53minutes SQL> !uptime 15:40 up 4 days, 14:52, 7 users, load average: 4.13, 6.93, 7.08 SQL> select sysdate from dual; SYSDATE 02-DEC-2002 15:40:39 SQL> Is there something wrong with the script or just a misalignment in the starts? Stephen Andert (confused in AZ) -- db_uptime.sql select 'Host Name : '||host_name||chr(10)|| 'Instance Name : '||instance_name||chr(10)|| 'Uptime : ' ||floor(xx)||'days ' ||floor((xx-floor(xx))*24)||'hours ' ||round(((xx-floor(xx)*24)-floor((xx-floor(xx)*24)))*60) ||'minutes' "Database Uptime" from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: Database up longer that host?
Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example "up 4 days, 21:08 hours". In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen >>> [EMAIL PROTECTED] 12/02/02 07:43PM >>> You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: > Stephen Andert wrote: > > > > I use a script named db_uptime.sql (I think I got it from the list here) > > to calculate how long the database has been up. The output compares > > nicely to the unix uptime command. > >I hope that the query doesn't come from the list, because it is > wrong. The error is to apply floor() before multiplying by 24 or 60 - > you have tremendous rounding errors. > My own database has not been up long enough to be 100% sure about it but > I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker 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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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: Database up longer that host?
With my luck and the damagement in my current workplace, I'd probably get a written warning for not having done this with all of our databases :) >>> [EMAIL PROTECTED] 12/02/02 07:24PM >>> Stephen, If I was in your position I would go and explain to your boss that your "mad DBA skillz" have resulted in a database that has better uptime than it's physical host even, and discuss a pay rise! Fixing the script will probably return your status to "mere mortal DBA". Meg Crocker rtrak.com>cc: Sent by: Subject: Re: Database up longer that host? [EMAIL PROTECTED] m 03/12/2002 12:33 Please respond to ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: > Stephen Andert wrote: > > > > I use a script named db_uptime.sql (I think I got it from the list here) > > to calculate how long the database has been up. The output compares > > nicely to the unix uptime command. > >I hope that the query doesn't come from the list, because it is > wrong. The error is to apply floor() before multiplying by 24 or 60 - > you have tremendous rounding errors. > My own database has not been up long enough to be 100% sure about it but > I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of
RE: Database up longer that host?
Give the man a cigar. (virtual one of course :) That is what I was looking for and makes unix uptime and db_uptime.sql report a compatible time frame. Thanks Jared. Stephen >>> [EMAIL PROTECTED] 12/03/02 04:02PM >>> Try: col uptime format a40 head 'UPTIME' select to_char(sysdate,'hh:miam') || ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, ' || trunc( (sysdate - trunc(sysdate)) *24 ,0) || ':' -- hours || trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', ' -- minutes || s.user_count || ' users' uptime from v$instance i, ( select count(*) user_count from v$session where username is not null ) s / "Stephen Andert" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/02/2002 07:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Database up longer that host? Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example "up 4 days, 21:08 hours". In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen >>> [EMAIL PROTECTED] 12/02/02 07:43PM >>> You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message----- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: > Stephen Andert wrote: > > > > I use a script named db_uptime.sql (I think I got it from the list here) > > to calculate how long the database has been up. The output compares > > nicely to the unix uptime command. > >I hope that the query doesn't come from the list, because it is > wrong. The error is to apply floor() before multiplying by 24 or 60 - > you have tremendous rounding errors. > My own database has not been up long enough to be 100% sure about it but > I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker 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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert 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
RE: Database up longer that host?
OK, since it's virtual anyway, >>> <[EMAIL PROTECTED]> 12/04/02 06:18PM >>> Thanks, but I'd rather have a nice shot of Scotch. :) Jared "Stephen Andert" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/04/2002 03:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Database up longer that host? Give the man a cigar. (virtual one of course :) That is what I was looking for and makes unix uptime and db_uptime.sql report a compatible time frame. Thanks Jared. Stephen >>> [EMAIL PROTECTED] 12/03/02 04:02PM >>> Try: col uptime format a40 head 'UPTIME' select to_char(sysdate,'hh:miam') || ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, ' || trunc( (sysdate - trunc(sysdate)) *24 ,0) || ':' -- hours || trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', ' -- minutes || s.user_count || ' users' uptime from v$instance i, ( select count(*) user_count from v$session where username is not null ) s / "Stephen Andert" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 12/02/2002 07:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Database up longer that host? Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example "up 4 days, 21:08 hours". In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen >>> [EMAIL PROTECTED] 12/02/02 07:43PM >>> You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: > Stephen Andert wrote: > > > > I use a script named db_uptime.sql (I think I got it from the list here) > > to calculate how long the database has been up. The output compares > > nicely to the unix uptime command. > >I hope that the query doesn't come from the list, because it is > wrong. The error is to apply floor() before multiplying by 24 or 60 - > you have tremendous rounding errors. > My own database has not been up long enough to be 100% sure about it but > I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker 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: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). Y