Oracle: db_block_size
Jul282019
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
SYS@orcl AS SYSDBA> select distinct bytes/blocks from user_segments; BYTES/BLOCKS ------------ 8192 SYS@orcl AS SYSDBA> SYS@orcl AS SYSDBA> select block_size, tablespace_name from dba_tablespaces; BLOCK_SIZE TABLESPACE_NAME ---------- ------------------------------ 8192 SYSTEM 8192 SYSAUX 8192 UNDOTBS1 8192 TEMP 8192 USERS 8192 ZJK 8192 ZJK_TEMP 7 rows selected. SYS@orcl AS SYSDBA> show parameter block NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_block_buffers integer 0 db_block_checking string FALSE db_block_checksum string TYPICAL db_block_size integer 8192 db_file_multiblock_read_count integer 128 |
【上一篇】ORA-00312: online log 1 thread 1: ‘/u01/app/oracle/oradata/orcl/redo01.log’
【下一篇】echo 开始时间：2019年8月26日%-%time% >> c:\ddve.txt
【下一篇】echo 开始时间：2019年8月26日%-%time% >> c:\ddve.txt
Oracle: db_block_size：等您坐沙发呢！
发表评论
最新评论
Star Guo:
Do you use OL7 U