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 <[EMAIL PROTECTED]>
>To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
>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" <[EMAIL PROTECTED]>
>To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
>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" <[EMAIL PROTECTED]>
>To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]>
>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 [EMAIL PROTECTED]
>To subscribe: send a blank email to [EMAIL PROTECTED]
>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 [EMAIL PROTECTED]
>To subscribe: send a blank email to [EMAIL PROTECTED]
>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 [EMAIL PROTECTED]
>To subscribe: send a blank email to [EMAIL PROTECTED]
>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 [EMAIL PROTECTED]
To subscribe: send a blank email to [EMAIL PROTECTED]
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 [EMAIL PROTECTED]
To subscribe: send a blank email to [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
