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 |