對dbfsize輸出的解釋,dbfsize輸出解釋

來源:互聯網
上載者:User

對dbfsize輸出的解釋,dbfsize輸出解釋

[oracle@rhel63single test]$ which dbfsize/u02/app/oracle/product/11.2.0.4/db_1/bin/dbfsize[oracle@rhel63single test]$ [oracle@rhel63single test]$ [oracle@rhel63single test]$ [oracle@rhel63single test]$ dbfsize control01.ctl Database file: control01.ctlDatabase file type: file systemDatabase file size: 594 16384 byte blocks[oracle@rhel63single test]$ ll control01.ctl -rw-r-----. 1 oracle oinstall 9748480 Jan  9 04:42 control01.ctl對control01.ctl計算如下:  9748480-16384*594=16384, 也就是說 os命令顯示的control01.ctl 大小要比 oracle層面“認為”的 control01.ctl大小要 多 一個 16384 byte [oracle@rhel63single test]$ dbfsize redo01.log Database file: redo01.logDatabase file type: file systemDatabase file size: 102400 512 byte blocks[oracle@rhel63single test]$ [oracle@rhel63single test]$ ll redo01.log -rw-r-----. 1 oracle oinstall 52429312 Jan  9 04:42 redo01.log對redo01.log計算如下:  52429312-512*102400 =512,也就是說 os命令顯示的redo01.log 大小要比 oracle層面“認為”的 redo01.log大小要 多 一個 512 byte [oracle@rhel63single test]$ dbfsize users01.dbf Database file: users01.dbfDatabase file type: file systemDatabase file size: 960 8192 byte blocks[oracle@rhel63single test]$ [oracle@rhel63single test]$ ll users01.dbf -rw-r-----. 1 oracle oinstall 7872512 Jan  9 03:15 users01.dbf對users01.dbf計算如下:  7872512-8192*960 =8192,也就是說 os命令顯示的redo01.log 大小要比 oracle層面“認為”的 redo01.log大小要 多 一個 8192 byte


 

相關文章

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.