RE: Outsourcing's dirty secret

This is totally inappropriate. You should be banned from the list. The reality is that companies only look at the bottom line and not the long term effects of hiring anyone who can spell Oracle right on thier resume. Frank -Original Message- hrishy Sent: Saturday, November 01, 2003 6:19

RE: Outsourcing's dirty secret

You the man!!! who has the right to an opinion ? -Original Message- Sent: Sunday, November 02, 2003 10:09 AM To: Multiple recipients of list ORACLE-L This is totally inappropriate. You should be banned from the list. The reality is that companies only look at the bottom line and not

RE: Outsourcing's dirty secret

Hi Frank why do you think i should be banned...:-)..everybody is entitled to his opinion... say i go on a consulting assignement to a company that hosts por sites should i reccommend him Oracle10g or mysql..Mysql right..but being a oracle DBA and to save my job i can always recommend oracel

Re: Performance Issue w/ Blob Data

Hi! Maybe it's a delayed commit cleanout issue, due massive deletes, so during your first select most of your buffers involved in delete have to be cleaned out (thus becoming dirty and generating extra redo). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: char(1) VS varchar2(1)

Hi! Just for the record, every column in a table has a length byte (or three, depending on column size). This works so even in clusters, where rows are split vertically, but column structures remain the same. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: memory usage by dbw very high

Thanks Mladen, that was a good tip about linux kernel enhancement, however OP still uses 2.4.9 as stated in original post. I just wanted to know whether OP actually sees excessive paging or just memory being full, the latter one, as you know, isn't really a problem. Tanel. - Original

Re: I wanna know how Oracle uses file organization in their DB

Hi! If I recall correctly, a simple B-tree leafs didn't have pointers to last and next leaf in them, whilst B+tree and B*-tree did... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, October 31, 2003 6:44 PM A B-tree is not a

Re: Table partitioning Oracle 9.2

Hi! No, data blocks below partitions high-high water mark can never be used for another segment. Unformatted blocks above (high)-high water mark can be used for another segment only when you trim the extent(s) using alter table deallocate unused (but this feature is useful only if you have lots

BR Benchmarks

Does anyone have any benchmark numbers for a BR operationof a 3TB Oracle database? I understand this depends on several environmental conditions. If anyone of you has had a need to do a restore of 3-4TB Oracle database and would not mind sharing some of your thoughts that would be wonderful.

Re: BR Benchmarks

I know when i'd worked on that size, we use the concept of multiple mirrors of the data and broke the mirror, and used that as the backup(it went to tape also but we never had to recover from tape) :) joe Murali Vallath wrote: Does anyone have any benchmark numbers for a BR operation of a

RE: Outsourcing's dirty secret

Ok, please take this offline or to an OT list. Thanks, Jared ( the list owner ) On Sun, 2003-11-02 at 07:44, hrishy wrote: Hi Frank why do you think i should be banned...:-)..everybody is entitled to his opinion... say i go on a consulting assignement to a company that hosts por sites

Re: I wanna know how Oracle uses file organization in their DB

There is quite some important difference between theoretical definition of the B*/+ trees and their implementation, in particular underflow and overflow could be implemented not as defined -- a trade off, as usually -- however those two operations are major ones in the index data management.

Re: char(1) VS varchar2(1)

Trailing columns with NULL values do not occupy any space, not even a length byte. Non-trailing columns with NULL values have a constant value of 0xFF (255) in the length byte consuming just the one byte. Column values with a length of 0-254 bytes have one length byte, and values with a length

RE: Re: char(1) VS varchar2(1)

Extremely precious info. Thanks a lot for sharing this !!! Rajesh Dayal Senior Oracle DBA (OCP 8,8i,9i) International Information Technology Company LLC -Original Message- Sent: Monday, November 03, 2003 7:14 AM To: Multiple recipients of list ORACLE-L Subject:Fwd: