RE: service name

2003-06-29 Thread Sinardy Xing
connect descriptor is more like it, since you may load balance the listener. what is the different any way with destination address? is this an exam question or what? -Original Message- Sent: 29 June 2003 02:44 To: Multiple recipients of list ORACLE-L Hello list does a service name be

RE: Dedicated Server problem ORA-03113

2003-06-29 Thread Denham Eva
That is the whole problem, there is no logged errors, or trace files. Everyone can connect via the MTS servers, no problem, however no one can connect via dedicated server. Go figure. Regards Denham -Original Message- Sent: Saturday, June 28, 2003 6:54 PM To: Multiple recipients of list O

RE: Intresting Statistics -- DB FILE SEQUENTIAL READ waits

2003-06-29 Thread Madhavan Amruthur
Hi Cary, Thanks for the mail. We were thinking that clusters was the next option if this did not make a difference. Regards, Madhavan On Fri, 27 Jun 2003 21:49:39 -0800, "Cary Millsap" <[EMAIL PROTECTED]> said: > Two features already exist that will preserve table physical order even > through var

Re: Filesystem for Linux production database server?

2003-06-29 Thread zhu chao
Hi, Gogala: Thanks very much for your suggestions. some points: 1.Oracle 9i on linux 2.4 does support 64GB datafile/raw device. Linux 2.4 kernel support 2GB+ files and oracle 9i have 64bit filesystem io support.I have a rac database on raw with some datafiles 20Gb. 2.Maybe I will choose

Re: Filesystem for Linux production database server?

2003-06-29 Thread Mladen Gogala
Linux file systems usually do not support direct I/O (bypassing the buffer cache), which means that you're going to have double caching with almost everything except raw devices. You can have up to 256 raw devices on a Linux box and if your database is small enough (32-bit system, 2G limit applies

Re: TSPITR or PITR

2003-06-29 Thread M Rafiq
In this given simple situation the best option is B. Besides in OCP test, they just ask for best option of given options. Sometime in practice all of them may be wrong but still you have to select 'least' wrong. While doing ONLINE DBA test due to job search or even in OCP practice test question

Re: Fw: controlfile backup obsolete above 2 days

2003-06-29 Thread M Rafiq
Congrats, Finally you found answer to your question...SPFILE is still not that much reliable Regards Rafiq Reply-To: [EMAIL PROTECTED] Date: Sat, 28 Jun 2003 23:09:22 -0800 Hello List, here is what metalink says fact: Oracle Server - Enterprise Edition 9.2.0 fact: Recovery Manager (RMAN

Re: TSPITR or PITR

2003-06-29 Thread Hemant K Chitale
I agree that we really can't differentiate between options A, B and D -- they are all Incomplete Database Recoveries. However, option C IS different. Since we are much more likely to know the "wall clock time" as to when the table was dropped than the SCN, B makes more sense than A. B also makes

Filesystem for Linux production database server?

2003-06-29 Thread zhu chao
Hi, friends that run oracle on linux: We are running some database on linux, some with UPS protection and some not, all using ext2. Currently we have a DW server running oracle 817/Redhat 7.2/Ext2. When server crash because of power supply, fsck took rather long time! And we are planning mi

Re: TSPITR or PITR

2003-06-29 Thread Tim Gorman
Silly me! With a bunch of years of production DBA experience encountering problems exactly like this one (except it was someone else dropping the important table) as well as problems far more complicated, I can't decide what answer they are seeking here! What's more, I would have chosen the wrong

Re: TSPITR or PITR

2003-06-29 Thread Hemant K Chitale
No, TSPITR should not be the preferred method. Why not ? Because it doesn't guarantee that you have achieved consistency of data across objects. You must still export the "related objects" and bring them in. Suppose you have a transactions which updates tables in three different tablespaces. A TS

Fw: controlfile backup obsolete above 2 days

2003-06-29 Thread bulbultyagi
Hello List, here is what metalink says fact: Oracle Server - Enterprise Edition 9.2.0 fact: Recovery Manager (RMAN) symptom: Backupsets are incorrectly reported as obsolete cause: "RMAN thinks backups with SPFILE are OBSOLETE" fix: Ver. 9.2.0 is the first version that

Advice

2003-06-29 Thread bulbultyagi
Hello list , I am planning to appear for my Oracle 9i database fundamentals II exam ( 1z0-032 ) on the 7th . I would be grateful for any advice , pointers ,etc. Bit nervous cause it looks tougher than 1z0-031 ( dba fundamentals 1 ) thanks ... -- Please see the official ORACLE-L FAQ: http://w