Oracle Database基本知识计量单位1

《Oracle Database基本知识计量单位1》由会员分享，可在线阅读，更多相关《Oracle Database基本知识计量单位1（57页珍藏版）》请在装配图网上搜索。

1、Oracle Database基本知识-计量单位2022-12-172/55内容提要2022-12-173/55存储容量单位存储容量单位-英语命名法英语命名法2022-12-175/55存储容量单位-常用前缀及其意义103210mega-M106220giga-G109230tera-T1012240Peta-P1015250exa-E10182602022-12-176/55存储容量单位-存储计量单位 210 Bytes=1024 Bytes约为103Bytes 220 Bytes=10242 Bytes约为106Bytes（百万）230 Bytes=10243 Bytes约为109Byte

2、s（十亿）240 Bytes=10244 Bytes约为1012Bytes（一兆）2022-12-177/55存储转换单位2022-12-178/55存储容量单位-新名词Zettabyte:1,000,000,000,000,000,000,000 字节字节现在出现现在出现“Zettabyte File System”产品产品-Sun Microsystems公司公司 2022-12-179/55内容提要2022-12-1710/55时间速度单位 ms=millisecond 10-3 秒，毫秒，千分之一秒us=microsecond10-6 秒，微秒，百万分之一秒ns=nanosecond1

3、0-9 秒，奈秒，十亿分之一秒ps=picosecond10-12 秒，微微秒，兆分之一秒2022-12-1711/55时间速度单位 2022-12-1712/55速度单位转换2022-12-1713/55时间速度单位2022-12-1714/55时间速度单位-Oracle动态视图 2022-12-1715/55时间速度单位-Oracle动态视图 2022-12-1716/55内容提要2022-12-1717/55数据文件大小SQL show parameter db_block_size NAME TYPE VALUE-db_block_size integer 81922022-12-17

4、18/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 bytesSQL SELECT to_char(4194303*value,999,999,999,999)MAX_BYTES,2 to_char(trunc(4194303*value/1024),999,999,999)|Kb MAX_KB,3 to_char(trunc(4194303

5、*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 Mb2022-12-1719/559i数据文件大小 2022-12-1720/5510g/11g数据文件大小2022-12-1721/5510g/11g数据文件大小CREATE BIGFILE TABLESPACE bigtbs DATAFILE/u02/oracle/data/bigtbs01.dbf SIZE 5

6、0G EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;2022-12-1722/5510g/11g数据文件大小CREATE DATABASE rbdb1SET DEFAULT BIGFILE TABLSPACE.SMALLFILE DEFAULT TEMPORARY TABLESPACE tempts1TEMPFILE/u01/oracle/oradata/mynewdb/temp01.dbfSIZE 20M REUSE2022-12-1723/5510g/11g数据文件大小2022-12-1724/55Oracle 11g 支持64

7、Bit u表空间大小为表空间大小为Exabytes2022-12-1725/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 块的最大数块的最大数SQL alter tablespace users add datafile f:user02.dbf siz

8、e 8191M reuse;表空间已更改。表空间已更改。2022-12-1726/55数据文件大小限制SQL alter database2 datafile/u01/app/oracle/oradata/rmanrep/users01.dbf resize 15m;Database altered.SQL alter database2 datafile/u01/app/oracle/oradata/rmanrep/users01.dbf resize 10m;Database altered.SQL alter database2 datafile/u01/app/oracle/orada

9、ta/rmanrep/users01.dbf resize 1m;alter database*ERROR at line 1:ORA-03297:file contains used data beyond requested RESIZE valueSQL alter database2 datafile/u01/app/oracle/oradata/rmanrep/users01.dbf resize 100t;alter database*ERROR at line 1:ORA-00740:datafile size of(13421772800)blocks exceeds maxi

10、mum file sizeSQL alter database2 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 blocks2022-12-1727/55内容提要Oracle支持主要平台ClusterSingle UserSMPDesktop ServerUniprocessorWindowsLinuxSolaris SPARCHP

11、-UXHP Tru64OS/390AIXBlade Servers 2022-12-1729/552022-12-1730/55Windows 32-bit Platform SupportPlanned Latest DB patchset available at the time2022-12-1731/55Windows 64-bit Platform SupportTBD To be determined.Will be announced later.2022-12-1732/5532Bit Vs 64Bit n计算机位数计算机位数u4 Bit=(16 Bytes)u8 Bit=(

12、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 Memory2022-12-1733/55Architecture:Thread ModelOracle process 3GB or8TBtotalCodeSGASGA containsDB buffers,log buffer

13、sshared pool,other memoryallocationsEach threadconsists ofPGA,stack,other memoryallocationsBackground and foreground threads2022-12-1734/5510g 在Windows内存大小 u32 bit 每个实例可分配3GB 大小内存u32 bit 的VLM可超过3GB大小u64 bit 每个实例可分配8TB大小内存2022-12-1735/5532-bit:Very Large Memory(VLM)支持SGACodeRest of RAMFor O/S,other a

14、pps3GB Windows Server 2003 Memory Limits(32-bit)Standard Edition:4GB Enterprise Edition:32GBDatacenter Edition:64GBdatabase threads/memory2022-12-1736/5532-bit:VLM 支持Rest of RAMSGA minus DB buffersCodeMemory from AWE callsused for DB buffers only.The amount of AWE memory allocatedequals db_block_siz

15、etimes db_block_buffers.For O/S,other apps3GB Window on DBbuffers in AWE mem Extended memoryavailable for DB buffers via AWE callsOracle operating system process.Normally limited to 3GB of address space.With VLM,Oracle can get up to 12GB of database buffers.2022-12-1737/55AWE(Address Windowing Exten

16、sions)实现2022-12-1738/5532-Bit 内存实践2022-12-1739/55Oracle 10g 在WindowsVery Large Memory 支持NT可达 16 GB,Windows 2000可达 64 GB Windows Server 2003 Memory Limits(32-bit)Standard Edition:4GB Enterprise Edition:32GBDatacenter Edition:64GB10TB database in production2022-12-1740/5532 bit Vs 64bit Memory Limits(

17、1)Product names listed are for general reference only and do not reflect actual product names.64-bitWindows Server Standard Edition will be available for x64 only.2022-12-1741/55Oracle 10g 在Windows-文件大小nNTFS/RAWuNTFS支持 单个文件最大 64 GB.u数据库大小 4 petabytes.现在数据库大小实现 10 TB.64bit2022-12-1742/55内容提要2022-12-1

18、743/55Oracle RDBMS 在 Linux File(s)DatabaseLog Files2022-12-1744/55Oracle 10g 在 Red Hat 2022-12-1745/55内容提要2022-12-1746/55Oracle 10g 在UNIX 2022-12-1747/55Oracle 10g 在UNIX 2022-12-1748/55内容提要2022-12-1749/55主要UNIX 文件大小-AIX default:default:fsizefsize=-1=-1core=2097151core=2097151cpucpu=-1=-1data=262144d

19、ata=2621442022-12-1750/55主要UNIX 文件大小-HP-UX 2022-12-1751/55主要UNIX 文件大小-Linux#设置设置oracle对文件的要求：对文件的要求：#编辑文件：编辑文件：vi/etc/security/limits.conf 加入以下语句：加入以下语句：oracle soft nproc 2047oracle hard nproc 16384oracle soft nofile 1024oracle hard nofile 65536 2022-12-1752/55主要UNIX 文件大小.exporting table BIGEXPORTEX

20、P-00015:error on row 10660 of table BIGEXPORT,column MYCOL,datatype 96EXP-00002:error in writing to export fileEXP-00002:error in writing to export fileEXP-00000:Export terminated unsuccessfully2022-12-1753/55主要UNIX 文件大小 SQL*Loader-500:Unable to open file(bigfile.dat)SVR4 Error:79:Value too large fo

21、r defined data type2022-12-1754/55主要UNIX 文件大小 CREATE TABLESPACE DATAFILE.SIZE xxxxxxORA-02237:invalid file sizeALTER USER QUOTA 2500M ON“ORA-2187:invalid quota specification.”2022-12-1755/55主要UNIX 文件大小限制 SELECT f.ts#,f.file#,f.status$,f.blocks,v.nameFROM file$f,v$datafile vWHERE f.blocks 4194303AND f.file#=v.file#;2022-12-1756/55主要UNIX 文件大小限制 SELECT x.file#,x.maxextend,v.nameFROM filext$x,v$datafile vWHERE x.maxextend 4194303and v.file#=x.file#;2022-12-1757/55主要UNIX 文件大小限制 SELECT f.ts#,f.file#,f.status$,f.blocks,v.nameFROM file$f,v$datafile vWHERE f.blocks=0AND f.file#=v.file#;