Re: Raw devices and redo

I'm sure that each source is accompanied by some type of explanation? Surely neither would make such a bald sweeping statement without some substantiation? I would agree with your summarization of Mr. Lewis's position. The type of I/O activity associated with online redo log files (i.e. high vol

Re: raw devices

PCM locks on the LMT datafile bitmap header blocks, just like those used for enqueues. Difference is, there can be many such blocks and locks, instead of just one... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, August 13, 2002 12:50 P

RE: raw devices

Hi, Following on from this has anyone else had negative experiences with LMT??? Rgds -Original Message- Sent: 13 August 2002 16:24 To: Multiple recipients of list ORACLE-L Hello, Some may not agree with this sentiment, but unless there is an overriding reason for your needing to swit

RE: raw devices

But probably there is some other resource that replaces the ST enqueue to control concurrency in case of LMT tablespaces and the update of the bitmap headers. Waleed -Original Message- Sent: Tuesday, August 13, 2002 2:35 PM To: Multiple recipients of list ORACLE-L On OPS and RAC, the i

Re: raw devices

On OPS and RAC, the issue is not really the contention for the UET$ and FET$ tables themselves. It is the contention for the "ST" enqueue/lock which is global across all instances. Only one session on one instance can hold "ST" across all instances in the OPS/RAC database. Essentially, all dict

RE: raw devices

Title: RE: Which index need rebuilding? thankyou!! -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: 13 August 2002 15:19To: Multiple recipients of list ORACLE-LSubject: Re: raw devices You are correct; drop and recreate the tablespace and don'

RE: raw devices

Hello, Some may not agree with this sentiment, but unless there is an overriding reason for your needing to switch from dictionary-based tablespaces to locally-managed, I would leave well enough alone. Our OPS started out doing many things wrong, which we straightened out as we got more sophistic

Re: raw devices

Title: RE: Which index need rebuilding? You are correct; drop and recreate the tablespace and don't do anything at UNIX level, as the contents of the logical volume (a.k.a. raw device) will just be overwritten... - Original Message - From: Malik, Fawzia To: Multiple reci

Re: raw devices

Title: RE: Which index need rebuilding? Yes, I believe it to be so. Just drop and recreate with the same size and filename. - Original Message - From: Malik, Fawzia To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 13, 2002 4:38 PM Subject: raw device

RE: raw devices

You do not have to do anything on Unix. Once you drop the Tablespace the raw file (device) could be used immediately in a new TS. Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 8/13/02 9:38 AM Hi, Wondering if anyone can help me with this question.

Re: RE: raw devices

Hi! With support for different file systems apart from 'ufs' like jfs and vxfs Much of the perfomance issues have been covered. In fact apart from Oracle Parallel Server having datafiles,redo log files and controlfiles on raw devices does NOT make much sense. Particularly with 'feat

Re: raw devices

Raw versus filesystem is almost a religious issue. There are very good arguments both ways. The main advantages of filesystems are ease of use and flexibility. I tend to favor raw devices for critical production systems - for write-intensive OLTP at least. For development and functional test s

RE: raw devices

Don & Oracle Gurus, Going by your answers, I have a question for you? What you have explained is excatly the same environment we had back in our previous work place. But here we have everything what you have MINUS the raw devices. The question I have for Don and the forum folks is, What is the

RE: raw devices

Thanks a lot for your incedible answer , Don ! -Original Message- Sent: Monday, August 20, 2001 4:46 PM To: Multiple recipients of list ORACLE-L I don't know about NT, but on Solaris you should have some sort of cluster volume manager - Veritos is the most common. Rather than repeat a

RE: raw devices

Thanks a lot ! I always concentrate on mice and don't see the elephant :-( -Original Message- Sent: Monday, August 20, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Andrey, All your answers are in the Oracle manuals. I am currently preparing for an NT OPS install. The Or

Re: raw devices

I don't know about NT, but on Solaris you should have some sort of cluster volume manager - Veritos is the most common. Rather than repeat all the information for vxva, vxprint, etc. here, just read the manuals - "$ man vxva". Another option is to run the vxva GUI and capture the commands it is

RE: raw devices

Andrey, All your answers are in the Oracle manuals. I am currently preparing for an NT OPS install. The Oracle8i Parallel Server for NT Guide has all your answers for OPS on NT. And, of course, these docs are available via technet.oracle.com. Have fun!! This is cool stuff. Chris "May Oracle