Oracle-L: RE: ????How to find Os Block Size????

From: Reddy, Madhusudana <Madhusudana.Reddy_at_bestbuy.com>
Date: Wed, 17 Apr 2002 08:23:34 -0800
Message-ID: <F001.00446A10.20020417082334@fatcity.com>

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

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

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 más 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.

-- 
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).

Received on Wed Apr 17 2002 - 11:23:34 CDT