TSPITR or PITR

2003-06-28 Thread bulbultyagi
Hello list I came across the following question in the TMH exam guide for 1z0-032: Chris, a DBA, while performing maintenance tasks accidentally drops a very important table. What is the best method available for Chris to recover this table if he is aware of the time when the table was dropped? A

Re: Deleting Statspack tables.

2003-06-28 Thread Tim Gorman
Not quite true that my stuff has been "moved"; just "copied". Think of "cp" instead of "mv" commands... on 6/11/03 3:49 AM, Ranganath K at [EMAIL PROTECTED] wrote: > Hi John, > > Tim Gorman's site has been moved to http://www.sagelogix.com. So one > can find all the UNIX and SQL scripts in s

Re: Performance

2003-06-28 Thread M Rafiq
Mladen, Why do you feel old at the magic age of 42. May be 43 Years now. The book name is ORACLE 101 Performance Tuning by Gaja Krishna Vaidyanatha, Kirtikumar Deshpande and John A. Kostelac Jr. Regards Rafiq Oracle Financial GL, AP, AR, PA, Reporting NJ Morristown 1 - 3

Re: Too many extents....

2003-06-28 Thread M Rafiq
Still 30 minutes is bad with this size and with LMT. Try to increase your uniform extent size of your tablespace and try again. Besides emc storage is much slower then Hitachi 9600 series storage. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTE

Too many extents....

2003-06-28 Thread Darrell Landrum
Scads of extents in a dictionary managed tablespace...BAD! In a dictionary managed tablespace with default storage of 104K/104K (I didn't know this until way later / too late), I created a table (without specifying storage) and loaded that thing up. It was taking up 7.5 GB on disk when complete.

service name

2003-06-28 Thread bulbultyagi
Hello list does a service name best represent a connect descriptor or a destination address ? ... -- 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.c

Re: Dedicated Server problem ORA-03113

2003-06-28 Thread Tanel Poder
Hi! What does your alert log say? Or event log then? Maybe, for some reason, Oracle is unable to start new processes on your system. For MTS connection, no new processes are needed, but for dedicated, there are. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMA

Re: Performance

2003-06-28 Thread Rachel Carmichael
Mladen, There is no tone in email messages... I was not annoyed at all! And you really do not want to hear me sing, small children weep and dogs howl :) I just wanted (at the expense of the oh so massive royalties all authors get) to make sure that the person you were helping bought the book he r

Re: Performance

2003-06-28 Thread Rachel Carmichael
I can and do get annoyed - but rarely show it. Not worth the effort or stress on me. however, show me someone spouting "hit ratios are the only way to tune" and "raid-5 rules" and you will see annoyance. :) --- Mogens_Nørgaard <[EMAIL PROTECTED]> wrote: > I very seriously doubt that Rachel is a

RE: Performance

2003-06-28 Thread Rachel Carmichael
well, perhaps he writes under the name Vaidyanatha.. and uses his true name for his new career? --- Pete Sharman <[EMAIL PROTECTED]> wrote: > Surely not? I was told just last week by the inestimable Mr. Mogens > Norgaard (who we all know as the source of truth) that Gaja's real > name is > Gaja

Re: Friday Humor - RMAN

2003-06-28 Thread Hemant K Chitale
Methinks the backup won't fail but the datafile would certainly be ovewritten ! The DBWR verifies the file header before writing in a dirty block to the file and should fail writes to the file once the backup to the file has begun -- so the DBWR should error out ! or am I wrong and would

Re: Performance

2003-06-28 Thread Mogens Nørgaard
I very seriously doubt that Rachel is annoyed. On the contrary. Never experienced it, never will, I think. I believe it's spelled Gaja Vahatneyhatneyhatney, but I could be wrong. Mladen Gogala wrote: Oh, and to grant you Elvis or Cher status, I'd have to hear you sing first. Can you do "Heartb

Re: Performance

2003-06-28 Thread Mogens Nørgaard
It's true. Gaja Vayanahneenahneeheyheyheyhey (sp?) will star in "BAARF. The Musical." Also - this might come as a surprise to Pete Sharman - the OakTable Choir will be part of the musical, and Pete (who, by the way, is a fantastic baryton singer) will sing one verse of a certain song (lyrics sl

Dedicated Server problem ORA-03113

2003-06-28 Thread Denham Eva
Hello Gurus, I am at wits end. The enviroment is Windows 2000 SP3. Oracle 817, MTS is also set up. The server has been up for 32 days. Everything fine and then suddenly all the "power" users using dedicated server because of their resource intensive sql etc just cann't connect. We get this error:

Re: Performance

2003-06-28 Thread Mladen Gogala
Oh, and to grant you Elvis or Cher status, I'd have to hear you sing first. Can you do "Heartbreak Hotel" for me? As I have said, I don't have the book with me and I'm equally adept at spelling french names as at spelling indian names, so I decided to give it up. From the tone of your message, yo

Re: Performance

2003-06-28 Thread Mladen Gogala
I didn't have the book with me at the time, so I was talking by heart, from my head. As I am getting older, my memory is obviously playing tricks on me. I humbly apologize to everybody whom I might have offended by my bad spelling, distorting title or forgetting co-authors altogether. I didn't want