Re: Rebuilding Indexes...

[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: (bcc: John Dailey/NAC/ING-FSI-NA

Re: Oracle and Peoplesoft

will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA

RE: partial restore of a database

than exporting it. I don't drop the datafiles I don't need - just let them get marked as missing. This is obviously a *very* temporary database and after I get what I need I blow it up. I'm sure there are other methods of doing this - this works for me. HTH John Dailey Oracle DBA ING

disk subsystem performance question

as well if anyone is interested - despite the fact I will probably bore you to death :-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

Re: disk subsystem performance question

are fighting a lot of marketing hype. If anyone has additional experiences or feedback with Hitachi or EMC they would like to share or comments (agree/disagree) with my thoughts, I'd love to hear them. I'm open for learning! Thanks, John Dailey Oracle DBA ING Americas - Application

recovery scenario - partial database - help

required to do this. Oracle 8.1.7.0 AIX 4.3.3 Any and all help is welcomed - thanks! John Dailey Corporate Systems DBA ING Americas Atlanta, GA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: job opportunity - huh?

PROTECTED] Please note candidates who are outside the range of 175-175.4 pounds, cannot recite the Cyrillic alphabet backwards while intoxicated or live more than 150 feet from our offices will not be considered. All in good fun. Have a good weekend everyone! John Dailey Oracle DBA Atlanta, GA

Re: Perf tuning OPTIMIZER_INDEX_COST_ADJ

you touch these parameters. You'll get more bang for your buck and I'm sure there's lots of queries that ran good under RBO that are suddenly going to be dogs in CBO and vice-versa. Good old-fashioned tuning fun! HTH and YMMV John Dailey Oracle DBA Atlanta, GA All opinions are my own yadda

RE: Dangerous AIX Bug!

Ross, we are also running AIX 4.3.3 with a mix of 8.0.5.2.1 and 8.1.7 databases, headed to all 8.1.7. We are mostly running S80s here. Just shoot me a note and we'll talk. John D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL

Re: get rid of carriage return in vi

Sorry if I'm taking this too far, but I sometimes get those ^M characters in files when I FTP in the wrong mode (ascii vs. binary). If this file has been recently transferred to your Unix box, try re-FTPing it in a different mode and those ^M characters may go away. If this doesn't apply to

Re: Batch updates

Sean, perhaps I am missing something from your question, but this sounds like a job for Oracle Lite (whatever name the marketing folks call it now, it used to be Oracle Lite anyway). I had an environment similar to your scenario engineers in the field would use their laptops all day

Re: initsid.ora problem

occur without a log switch but not vice-versa.A log switch has an implicit checkpoint within it, but if you have checkpoints between log switches you will get more checkpoints in your alert file than log switches. HTH, John Dailey Corporate Systems DBA All-Around Nice Guy

OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING

Oracle 8.0.5.2.1 -- yeah, I know I know... we are going to 8.1.7 eventually AIX 4.3.3 Hey allLooking at our init parameters today after reading Tim Gorman's White Paper The Search for Intelligent Life in the Cost Based Optimizer and these 2 stood out like a sore thumb. Both are at

Re: friday fun early, vote for favorites / Re: COLLECTION ITERATOR PICKLER

Eric, I'm torn between 2: A RICOCHET FRITTER KELP -- nothing like kelp fritters! yummy! and A CORRECT ETHER FLIP KIT -- what Oracle needs to install to get Metalink to work properly That's my 2 pesos for today :-) John Dailey ING Corporate Systems DBA Atlanta, GA -- Please see

RE: changing passwords - Boneheads at MetaStink

ant to run, then inserts the sysdate again (end time) into the table. I've used this before w/ great success. Sorry, I'm about ot leave for the day, so I couldn't be more precise. Let me know if you have any questions and I'll be more specific. John Dailey Consultant Concept Solutions, LLC ---

RE: Oracle Lite and Palm Synchronization

on this, perhaps someone else can shed some more light on the subject. HTH and HAND! John Dailey Consultant Concept Solutions, LLC -Original Message- Dave Sent: Monday, March 12, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Has anyone got this to work? I'm using the latest oracle

list of common ORA errors users get

wer each request, but I'll save that functionality for later :-) TIA John Dailey, MCSE/MCP+I Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dailey INET: [EMAI

RE: ORA-00059: maximum number of DB_FILES exceeded

of any other way to check it; somebody else may have a better method. BTW... is San Diego still as sunny as ever? I'm still hooking and jabbing here in DC... send me some more pictures of the Pacific. :-) John Dailey, MCSE/MCP+I Consultant Concept Solutions, LLC *Your Business Intelligence Partner

Re: RE: Mailing frm Oracle

Yes, and dbms_ijob will allow you to manage jobs that are not owned by you. I had to do the same thing as Regs... those jobs can be very persistent little guys. Break them first, then kill the session ID running the job. This will stop them. John Dailey Consultant Concept Solutions, LLC

RE: peoplesoft

Unfortunately, I think that's it Eric... and last I remember, Informix was hanging by a thread. (Pun intended) John Dailey Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -Original Message- Pierce Sent: Friday, February 23, 2001 12

RE: Shell scripting question

had 0 bits for group and other permissions in the user's home directory. Thanks again to the list. John Dailey -Original Message- Sent: Friday, February 23, 2001 3:26 PM To: Multiple recipients of list ORACLE-L check out this link for some info www.datafocus.com/docs/man1/rexec.1.asp ---

Shell scripting question

not to bother the list with questions if I can help it, but I'm stuck on this one and don't want to throw in the towel. Thanks! John Dailey Consultant Concept Solutions, LLC *Your Business Intelligence Partner* www.concept-solutions.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com