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
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
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
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
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
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
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
:(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
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
-
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
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
11 matches
Mail list logo