Oracle Database基本知识计量单位1

1、oracle database 基本知识-计量单位 2021-5-62/55 内容提要 2021-5-63/55 存储容量单位 存储容量单位-英语命名法英语命名法 2021-5-65/55 存储容量单位-常用前缀及其意义 103210 mega-m106220 giga-g109230 tera-t1012240 peta-p1015250 exa-e1018260 2021-5-66/55 存储容量单位-存储计量单位 210 bytes=1024 bytes约为103bytes 220 bytes=10242 bytes约为106bytes（百万） 230 bytes=10243 bytes

2、约为109bytes（十亿） 240 bytes=10244 bytes约为1012bytes（一兆） 2021-5-67/55 存储转换单位 2021-5-68/55 存储容量单位-新名词 zettabyte: 1,000,000,000,000,000,000,000 字节字节 现在出现现在出现“zettabyte file system ”产品产品-sun microsystems公司公司 2021-5-69/55 内容提要 2021-5-610/55 时间速度单位 ms= millisecond 10-3 秒，毫秒，千分之一秒 us=microsecond10-6 秒，微秒，百万分之一

3、秒 ns=nanosecond10-9 秒，奈秒，十亿分之一秒 ps=picosecond10-12 秒，微微秒，兆分之一秒 2021-5-611/55 时间速度单位 2021-5-612/55 速度单位转换 2021-5-613/55 时间速度单位 2021-5-614/55 时间速度单位-oracle动态视图 2021-5-615/55 时间速度单位-oracle动态视图 2021-5-616/55 内容提要 2021-5-617/55 数据文件大小 sql show parameter db_block_size name type value - - - db_block_size i

4、nteger 8192 2021-5-618/55 数据文件大小 sql select to_char(4194303*value,999,999,999,999)| bytes max_file_size 2 from v$parameter where name=db_block_size; max_file_size - 34,359,730,176 bytes sql select to_char(4194303*value,999,999,999,999) max_bytes, 2 to_char(trunc(4194303*value/1024),999,999,999)| kb

5、max_kb, 3 to_char(trunc(4194303*value/1024/1024),999,999)| mb max_mb 4 from v$parameter where name=db_block_size; max_bytes max_kb max_mb - - - 34,359,730,176 33,554,424 kb 32,767 mb 2021-5-619/55 9i数据文件大小 2021-5-620/55 10g/11g数据文件大小 2021-5-621/55 10g/11g数据文件大小 create bigfile tablespace bigtbs dataf

6、ile /u02/oracle/data/bigtbs01.dbf size 50g extent management local segment space management auto; 2021-5-622/55 10g/11g数据文件大小 create database rbdb1 set default bigfile tablspace . smallfile default temporary tablespace tempts1 tempfile /u01/oracle/oradata/mynewdb/temp01.dbf size 20m reuse 2021-5-623

7、/55 10g/11g数据文件大小 2021-5-624/55 oracle 11g 支持64bit u表空间大小为表空间大小为exabytes 2021-5-625/55 数据文件大小限制 sql alter tablespace users add datafile f:user02.dbf size 8192m; alter tablespace users add datafile f:user02.dbf size 8192m * error 位于第位于第 1 行行: ora-01144: 文件大小文件大小 (4194304 块块) 超出超出 4194303 块的最大数块的最大数 s

8、ql alter tablespace users add datafile f:user02.dbf size 8191m reuse; 表空间已更改。表空间已更改。 2021-5-626/55 数据文件大小限制 sql alter database 2 datafile /u01/app/oracle/oradata/rmanrep/users01.dbf resize 15m; database altered. sql alter database 2 datafile /u01/app/oracle/oradata/rmanrep/users01.dbf resize 10m; da

9、tabase altered. sql alter database 2 datafile /u01/app/oracle/oradata/rmanrep/users01.dbf resize 1m; alter database * error at line 1: ora-03297: file contains used data beyond requested resize value sql alter database 2 datafile /u01/app/oracle/oradata/rmanrep/users01.dbf resize 100t; alter databas

10、e * error at line 1: ora-00740: datafile size of blocks exceeds maximum file size sql alter database 2 datafile /u01/app/oracle/oradata/rmanrep/users01.dbf resize 50g; alter database * error at line 1: ora-01144: file size (6553600 blocks) exceeds maximum of 4194303 blocks 2021-5-627/5

11、5 内容提要 oracle支持主要平台 cluster single user smp desktop server uniprocessor windows linux solaris sparc hp-ux hp tru64 os/390 aix blade servers 2021-5-629/55 2021-5-630/55 windows 32-bit platform support planned latest db patchset available at the time 2021-5-631/55 windows 64-bit platform support tbd t

12、o be determined. will be announced later. 2021-5-632/55 32bit vs 64bit n计算机位数计算机位数 u4 bit=(16 bytes) u8 bit=(65,536 bytes) u16-bit=(4,294,967,296 bytes) u32 bit=(4,294,967,296 bytes) u64 bit =(18,446,744,073,709,551,616 bytes) n64 bit可访问的内存地址可访问的内存地址 u64bit allows directly addressing 16 exabytes of

13、memory 2021-5-633/55 architecture: thread model oracle process 3gb or 8tb total code sga sga contains db buffers, log buffers shared pool, other memory allocations each thread consists of pga, stack, other memory allocations background and foreground threads 2021-5-634/55 10g 在windows内存大小 u32 bit 每个

14、实例可分配3gb 大小内存 u32 bit 的vlm可超过3gb大小 u64 bit 每个实例可分配8tb大小内存 2021-5-635/55 32-bit: very large memory (vlm)支持 sga code rest of ram for o/s, other apps 3gb windows server 2003 memory limits (32-bit) standard edition: 4gb enterprise edition: 32gb datacenter edition: 64gb database threads/ memory 2021-5-63

15、6/55 32-bit: vlm 支持 rest of ram sga minus db buffers code memory from awe calls used for db buffers only. the amount of awe memory allocated equals db_block_size times db_block_buffers. for o/s, other apps 3gb window on db buffers in awe mem extended memory available for db buffers via awe calls ora

16、cle operating system process. normally limited to 3gb of address space. with vlm, oracle can get up to 12gb of database buffers. 2021-5-637/55 awe( address windowing extensions) 实现 2021-5-638/55 32-bit 内存实践 2021-5-639/55 oracle 10g 在windows very large memory 支持 nt可达 16 gb, windows 2000可达 64 gb windo

17、ws server 2003 memory limits (32-bit) standard edition: 4gb enterprise edition: 32gb datacenter edition: 64gb 10tb database in production 2021-5-640/55 32 bit vs 64bit memory limits (1)product names listed are for general reference only and do not reflect actual product names. 64-bit windows server

18、standard edition will be available for x64 only. 2021-5-641/55 oracle 10g 在windows-文件大小 nntfs/raw untfs支持 单个文件最大 64 gb. u数据库大小 4 petabytes. 现在数据库大小实现 10 tb. 64bit 2021-5-642/55 内容提要 2021-5-643/55 oracle rdbms 在 linux file(s) database log files 2021-5-644/55 oracle 10g 在 red hat 2021-5-645/55 内容提要 20

19、21-5-646/55 oracle 10g 在unix 2021-5-647/55 oracle 10g 在unix 2021-5-648/55 内容提要 2021-5-649/55 主要unix 文件大小-aix default:default: fsizefsize = -1 = -1 core = 2097151core = 2097151 cpucpu = -1 = -1 data = 262144data = 262144 2021-5-650/55 主要unix 文件大小-hp-ux 2021-5-651/55 主要unix 文件大小-linux #设置设置oracle对文件的要

20、求：对文件的要求： #编辑文件：编辑文件：vi /etc/security/limits.conf 加入以下语句：加入以下语句： oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 2021-5-652/55 主要unix 文件大小 . . exporting table bigexport exp-00015: error on row 10660 of table bigexport, column mycol, datatype 96 exp-00002: error in writing to export file exp-00002: error in writing to export file exp-00000: export terminated unsuccessfully 2021-5-653/55 主要unix 文件大小 sql*loader-500: unable