RE: ????How to find Os Block Size????

2002-04-17 Thread Reddy, Madhusudana
Discussion on unix system : df -g on nt : correct me if i am wrong but i think it is allways 512 bytes From: paresh mehta [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Subject: How to find Os Block Size Date: Wed, 17 Apr 2002 14:18:38 + Hi Friend thanks for help.infact i

Re: ????How to find Os Block Size????

2002-04-17 Thread Anjo Kolk
Discussion [EMAIL PROTECTED] Subject: How to find Os Block Size Date: Wed, 17 Apr 2002 14:18:38 + Hi Friend thanks for help.infact i want to know the OS Block Size not DB block size can u tell me from where i can get this info.?? regards Paresh -Original Message

RE: ????How to find Os Block Size????

2002-04-17 Thread Reddy, Madhusudana
system Database file size: 102400 512 byte blocks bbuxdv01:/db02/oradata/tstd1 and I also did ORACLE BBED1 select lebsz from x$kccle; LEBSZ -- 512 512 512 0 0 0 0 0 8 rows select SO MY OS BLOCK SIZE

Re: ????How to find Os Block Size????

2002-04-17 Thread Anjo Kolk
0 0 8 rows select SO MY OS BLOCK SIZE IS 512 K , AM I RIGHT AND THANKS A BUNCH FOR YOUR TIME --MADHU -Original Message- Sent: Wednesday, April 17, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Madhu, Oracle has a fixed (at compile time

RE: Re[2]: os block size versus oracle bock size

2001-10-29 Thread GKor
ok, thanks for your explanation. -Oorspronkelijk bericht- Van: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Verzonden:dinsdag 23 oktober 2001 17:50 Aan: Multiple recipients of list ORACLE-L Onderwerp:Re[2]: os block size versus oracle bock size WHOA

Re: os block size versus oracle bock size

2001-10-24 Thread Edward Shevtsov
block size of 8k and i believe our W2K server has a default os block size of 4k. Is this a problem with the performance ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services

os block size versus oracle bock size

2001-10-23 Thread GKor
hi all we have an oracle block size of 8k and i believe our W2K server has a default os block size of 4k. Is this a problem with the performance ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat

Re: os block size versus oracle bock size

2001-10-23 Thread nlzanen1
:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) hi all we have an oracle block size of 8k and i believe our W2K server has a default os block size of 4k. Is this a problem with the performance ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re[2]: os block size versus oracle bock size

2001-10-23 Thread dgoulet
WHOA, No that is not a performance problem. The Oracle block size needs to always be a multiple of the OS block size. Most operating systems today, W2K being no exception, do not simply read the number of OS blocks that you request. They always 'read ahead' in the anticipation that you'll want

RE: os block size versus oracle bock size

2001-10-23 Thread Steve Adams
- hi all we have an oracle block size of 8k and i believe our W2K server has a default os block size of 4k. Is this a problem with the performance ? thanks g.g. kor rdw ict groningen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL

Os block size

2001-05-02 Thread Mujeeb Chowdhry
Could someone please tell what is OS block size on solaris 8 Mujeeb Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mujeeb Chowdhry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California