RE: Jobs are not working

ostic error messages, or any other documentation you wish to provide to give us more detail.     Michael Fontana Sr. DBA NTT/Verio   -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mauricio VXlezSent: Friday, January 23, 2004 11:04 AMTo: Mul

RE: most practical 9iR2 features?

't used much flashback or query rewrite features yet. At least not directly (some vendor code may use them). I am sure interested in seeing what others have to say. Michael Fontana Sr. DBA NTT/Verio -Original Message- Odland, Brad Sent: Thursday, January 15, 2004 11:15 AM To: Multip

Perpetually Spinning Job

refresh interval stored in dba_mviews is a relative date/time calculation, and does not lend it self to comparative testing.   I can provide more detail on this dilemma if anyone needs them.    Any ideas?   Michael Fontana Sr. DBA NTT/Verio <>The previous attachment was filter

Re: SYSOPER?

At 12:03 PM 11/28/2002 -0800, Tim Gorman wrote: Q: How many people use the SYSOPER privilege?   ...just curious...   Please respond only if the answer is affirmative -- I suspect the number of responses will be quite small...   P.S.    I have never worked at an place where it is used, of which I'm

Re: 2k and 8k block size

Reading my oracle 9i new features , there is now something called: Multiple Database Block Size Support.  In other words, it is no longer necessary to commit to a single block size for your database.  I'd suggest looking into this, as it may now be possible to test using different blocksizes for d

RMAN: I don't trust it

As a longtime Oracle DBA who has used many products, including RMAN, I find myself guilty of a paradoxical mistrust of RMAN, dating back from the time when Oracle has tried several products, including integration with Legato and other hardware/software backup vendors, without a consistent directi

Re: Oracle, Siebel and rule-based optimization

At 01:53 AM 1/31/2003 -0800, Ferenc Mantfeld wrote: Connor You're ass-u-ming that what worked for SAP will work for Siebel. Not a good assumption. Been there, done it, it does not work ! What you're advocating, I did similar measures when supporting Ora-Apps when we went from 9.6 to 10.5 (Oracle 7

RE: "Take Care of your DBAs"

At 08:00 AM 1/30/2003 -0800, Ron Rogers wrote: You gentlemen do not know what it is like to have snow related traffic problems. In Atlanta a snow flake can cause a multi-car pileup with a 3 hour commute delay. Why just having cold weather (20 degrees F) will cause schools to close. I've got you be

RE: Debate on rc commands Solaris and Oracle

At 08:10 AM 1/30/2003 -0800, Fink, Dan wrote: I know I am going to catch major grief for this, but I avoid shutdown abort when possible. Shutdown immediate can take some time, as it will do transaction rollback in serial (where recovery at startup can do it in parallel and as needed). The main rea

Oracle, Siebel and rule-based optimization

I would like to ask a question of this esteemed and knowledgeable audience about running SIEBEL applications on Oracle.  Siebel insists that their CRM application will only run with acceptable performance if rule-based optimization is chosen, yet, as we all know, there are documented examples of

re: Slient Install

> >>> [EMAIL PROTECTED] 01/17/03 09:24AM > >>> > Hey guys- > Have any of you all messed around with the silent > install/response files? > I'm looking for tips, advice, do's, don'ts,etc,etc > Just wanted to point out that "silent install" is not a solution if you lack X-windows connectivity t

Re: Conversion from CLOB to RAW

At 11:30 AM 1/10/2003 -0800, Burke, William F (Bill) wrote: Here's where I get to ask the most likely simple question. I've inherited a database where it was built using a CLOB to hold XML data but we have now determined that was total overkill and want to move it to a RAW column or other suitable

Re: View Question?

At 02:45 PM 1/7/2003 -0800, Hamid Alavi wrote: List, Oracle8i support insert/updatable view or NOT? From Oracle's Metalink: you can update a multiple base table view from 7.3.x onwards, provided columns you are updating are not primary keys for these tables.

Re:Feliz Navidad

At 11:08 AM 12/24/2002 -0800, [EMAIL PROTECTED] wrote: Merry Christmas to all & To All  A Good Night! Dick Goulet Ditto.

Re: SQL tuning question.

At 11:26 AM 12/18/2002 -0800, Jibo John wrote: Hello DBAs, I am currently involved in improving the search performance for a tool which queries a table having a million records (and the table is growing at a rate of 3000 records per day). So sounds like, in the next year, it will at least 2 millio

Re: OT: Guidelines/Standards for supporting non-oracle

At 01:15 PM 12/10/2002 -0800, [EMAIL PROTECTED] wrote: Hi, We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other "small" databases such as Access,etc within our company.  My question is if you were asked to