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

512 bytes

"Reddy, Madhusudana" wrote:

> I have ran this on a test database
>
> bbuxdv01:/db02/oradata/tstd1> dbfsize tstd1_1.ctl
>
> Database file: tstd1_1.ctl
> Database file type: file system
> Database file size: 232 8192 byte blocks
> bbuxdv01:/db02/oradata/tstd1> dbfsize tstd1_0101.rlg
>
> Database file: tstd1_0101.rlg
> Database file type: file 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 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) (OS) physical blocksize to work with.
> That blocksize is basically the minimum blocksize the control file and the
> redo log file get accessed in. So by doing 'dbfsize <controlfile>' you can
> see
> what the physical blocksize is. Or check from x$kccle. Now Veritas or the
> OS
> may have some other ideas what they think is the physical blocksize.
>
> Anjo.
>
> "Reddy, Madhusudana" wrote:
>
> > Rao,
> > This following is the one I am seeing on my m/c
> >
> > ORACLE BBED1> !df -g .
> > /db01 (/dev/vx/dsk/root2dg/db01): 8192 block size
> > 1024 frag size
> > 12582912 total blocks 8284512 free blocks 7766758 available
> > 1089844 total files
> > 1035561 free files 53554381 filesys id
> > vxfs fstype 0x00000004 flag 255 filename length
> >
> > ORACLE BBED1> connect internal;
> > Connected.
> > ORACLE BBED1> select lebsz from x$kccle;
> >
> > LEBSZ
> > ----------
> > 512
> > 512
> > 512
> > 0
> > 0
> > 0
> > 0
> > 0
> >
> > 8 rows selected.
> >
> > Which one of the above is correct ???
> >
> > --Madhu
> >
> > -----Original Message-----
> > Sent: Wednesday, April 17, 2002 9:47 AM
> > To: LazyDBA.com Discussion
> >
> > login as sys and do give this
> > select lebsz from x$kccle--w ould give the O/S block size
> >
> > Venkat
> >
> > -----Original Message-----
> > Sent: 17 April 2002 15:40
> > To: LazyDBA.com 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 <pvm46_at_myrealbox.com>
> > >To: "LazyDBA.com Discussion" <oracledba_at_lazydba.com>
> > >Subject: ????How to find Os Block Size????
> > >Date: Wed, 17 Apr 2002 14:18:38 +0000
> > >
> > >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-----
> > >From: "Yustiono" <tekait11_at_bni.co.id>
> > >To: "LazyDBA.com Discussion" <oracledba_at_lazydba.com>
> > >Date: Wed, 17 Apr 2002 07:17:55 +0700
> > >Subject: Re: *** Urgent Help Plz ***
> > >
> > >(1) use "show parameter db_block_size" or "select name, value from
> > >v$parameter where name = 'db_block_size'; ". I assume your Oracle version
> > >is
> > >prior to 9i or has uniform database size.
> > >(2) Yes, you can. The recovery steps depend on many things:
> > >- what do you lose; datafile, control file, whole database?
> > >- how did you make the backup; using RMAN, OS command?
> > >- your RAID configuration?
> > >
> > >----- Original Message -----
> > >From: "paresh mehta" <pvm46_at_myrealbox.com>
> > >To: "LazyDBA.com Discussion" <oracledba_at_lazydba.com>
> > >Sent: Wednesday, April 17, 2002 1:56 AM
> > >Subject: *** Urgent Help Plz ***
> > >
> > >
> > >Hello Friends,
> > >I have some queries, for solving i need ur help
> > >(1) How can i find my OS Block Size??? is there any Dynamic Performance
> > >view?
> > >(2) Can i make complete recovery upto the time of media failure, if i
> have
> > > * last latest cold backup
> > > * and set of all redo logs from last cold backup to failure time
> > >
> > >Thanking u in advance
> > >
> > >Regards
> > >Paresh Mehta
> > >
> > >
> > >--------
> > >Oracle documentation is here:
> > >http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > >To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > >To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > >Tell yer mates about http://www.farAwayJobs.com
> > >By using this list you agree to these
> > >terms:http://www.lazydba.com/legal.html
> > >
> > >
> > >
> > >--------
> > >Oracle documentation is here:
> > >http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > >To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > >To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > >Tell yer mates about http://www.farAwayJobs.com
> > >By using this list you agree to these
> > >terms:http://www.lazydba.com/legal.html
> > >
> > >
> > >
> > >
> > >
> > >--------
> > >Oracle documentation is here:
> > >http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > >To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > >To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > >Tell yer mates about http://www.farAwayJobs.com
> > >By using this list you agree to these
> > >terms:http://www.lazydba.com/legal.html
> > >
> >
> > _________________________________________________________________
> > MSN Photos es la manera mas sencilla de compartir e imprimir sus fotos:h
> > ttp://photos.latam.msn.com/Support/WorldWide.aspx
> >
> > --------
> > Oracle documentation is here:
> > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> > The information contained in this communication is
> > confidential, is intended only for the use of the recipient
> > named above, and may be legally privileged. If the reader
> > of this message is not the intended recipient, you are
> > hereby notified that any dissemination, distribution or
> > copying of this communication is strictly prohibited.
> > If you have received this communication in error, please
> > re-send this communication to the sender and delete the
> > original message or any copy of it from your computer
> > system.
> >
> > --------
> > Oracle documentation is here:
> > http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> > To unsubscribe: send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> > To subscribe: send a blank email to oracledba-subscribe_at_LAZYDBA.com
> > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about http://www.farAwayJobs.com
> > By using this list you agree to these
> > terms:http://www.lazydba.com/legal.html
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Reddy, Madhusudana
> > INET: Madhusudana.Reddy_at_bestbuy.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Anjo Kolk
> INET: anjo_at_oraperf.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Reddy, Madhusudana
> INET: Madhusudana.Reddy_at_bestbuy.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Anjo Kolk
  INET: anjo_at_oraperf.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).