oracleÖÐÒ»¸öÊý¾ÝÎļþµÄ×î´óÖµ(·Çlob)
ORACLEµÄÒ»¸öÊý¾ÝÎļþµÄ×î´óÖµÊǶàÉÙÄØ£¿
ÎÒÃÇÖªµÀORACLEµÄ×îСµÄÎïÀíµ¥Î»ÊÇBLOCK£¬Êý¾ÝÎļþµÄ×é³ÉµÄ×îÖÕÐÎʽҲÊÇblock£¬ÄÇôÊý¾ÝÎļþµÄ´óСÏÞÖƾÍÓ¦¸ÃÊÇblockÊýÁ¿µÄÏÞÖÆ£¬ÄÇô¾¿¾¹blockµÄÊýÁ¿ÓкÎÏÞÖÆ£¬ÕâÀï¾ÍÒªÌáµ½Ò»¸öORACLEÄÚ²¿ÊõÓïDBA(´Ëdba·ÇÊý¾Ý¿â¹ÜÀíÔ±£¬¶øÊÇdata block address)
Extent 0 : L1 dba: 0x01800009 Data dba: 0x0180000d
Extent 1 : L1 dba: 0x01800089 Data dba: 0x0180008b
Extent 2 : L1 dba: 0x01800109 Data dba: 0x0180010b
Extent 3 : L1 dba: 0x01800189 Data dba: 0x0180018b
Extent 4 : L1 dba: 0x01800209 Data dba: 0x0180020b
Extent 5 : L1 dba: 0x01800289 Data dba: 0x0180028b
dbaÊÇÒÔ16½øÖƱíʾµÄ(ÒòΪÓÐ0X)£¬×¢Òâ¿´Ò»¹²ÓÃÁË8ΪµÄ16½øÖÆ£¬»»Ëã³É¶þ½øÖƾÍÊÇ32bit£¬¶øÆäÖÐDBAÓÖÓÃ10λÀ´¼Ç¼file_id£¬22bitÀ´¼Ç¼block_id,ÄÇôÔÚÒ»¸öÊý¾ÝÎļþÖÐ×î¶àÄܹ»¼Ç¼2^22¸öblock,Èç¹ûÒ»¸öblock_size=8k,ÄÇôÕâ¸öÊý¾ÝÎļþµÄ×î´óÖµ¾ÍÊÇ8K*2^22,Ò²¾ÍÊÇ32G£¬ËùÒÔÊý¾ÝÎļþµÄ×î´óÖµÓ¦¸ÃÈ¡¾öÓÚ¿é´óС£¬¶øoracle¿é×î´óÖµÊÇ32K£¬Ò²¾ÍÊÇ32G*4=128G¡£
SQL> select power(2,22)*8/1024/1024 from dual;
POWER(2,22)*8/1024/1024
-----------------------
32
Ïà¹ØÎĵµ£º
²»ÄÜÁ¬½ÓOracleÊý¾Ý¿âÁË,ÌáʾÏà¹ØµÄ´íÎó
OERR: ORA-12519 TNS:no appropriate service handler found
¿Í»§¶ËÁ¬½Ó¼äЪÐÔʧ°Ü£¬±¨´íORA-12519
Cause: the listener could not find any available service handlers that are
appropriate fo ......
.½¨Á¢²âÊÔÊý¾Ý±í
CREATE TABLE TEST
(
ID NUMBER PRIMARY KEY,
NAME VARCHAR2(20)
);
2.´´½¨ÐòÁÐ
CREATE SEQUENCE SEQ_TEST;
3.´´½¨´¥·¢Æ÷
CREATE OR REPLACE TRIGGER AUTOINCREMENT
BEFORE INSERT ON TEST
FOR EACH ROW
WHEN (NEW.ID IS NULL)
BEGIN
SELECT SEQ_TEST.NEXTVAL INTO :NEW.ID from DUAL;
END; ......
LOB´ó¶ÔÏó´¦Àí£º Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£ Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
Ò». OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
¢Ù×Ö·ûÀàÐÍ£º
  ......
drop table test;
select count(*) from test;
--´´½¨²âÊÔ±í
create table test
(
id number(9),
nick varchar2(30)
);
--²åÈë²âÊÔÊý¾Ý
begin
for i in 1..100000 loop
insert into test(id) values(i);
end loop;
commit;
end;
select * ......
Oracle PGA²ÎÊý
PGA: ³ÌÐòÈ«¾ÖÇø£¬·þÎñÆ÷½ø³ÌʹÓõÄÄÚ´æÇøÓò£¬°üÀ¨Ìض¨·þÎñÆ÷½ø³ÌµÄÊý¾ÝºÍ¿ØÖÆÐÅÏ¢£¬ÀýÈçʹÓõIJÙ×÷ϵͳ×ÊÔ´µÈ¡£
UGA: Óû§È«¾ÖÇø£¬Ìض¨SessionʹÓõÄÄÚ´æÇøÓò£¬ÀýÈçSessionµÄSQL¹¤×÷Çø¡¢µÇ½ÈÏÖ¤ÐÅÏ¢µÈ¡£SessionµÄSQL¹¤×÷Çø´óС¶Ô²éѯÐÔÄܵÄÓ°Ïì±È½Ï¹Ø¼ü£¬shared serverģʽʱUGA´ÓSGAµÄlarge pool£¨Èç¹ ......