Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle·ÖÇø±í×ܽá

ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£

1.1 ·ÖÇø±íPARTITION table
ÔÚORACLEÀïÈç¹ûÓöµ½Ìرð´óµÄ±í£¬¿ÉÒÔʹÓ÷ÖÇøµÄ±íÀ´¸Ä±äÆäÓ¦ÓóÌÐòµÄÐÔÄÜ¡£
1.1.1 ·ÖÇø±íµÄ½¨Á¢£º
ij¹«Ë¾µÄÿÄê²úÉú¾Þ´óµÄÏúÊۼǼ£¬DBAÏò¹«Ë¾½¨Òéÿ¼¾¶ÈµÄÊý¾Ý·ÅÔÚÒ»¸ö·ÖÇøÄÚ£¬ÒÔÏÂʾ·¶µÄÊǸù«Ë¾1999ÄêµÄÊý¾Ý(¼ÙÉèÿÔ²úÉú30MµÄÊý¾Ý)£¬²Ù×÷ÈçÏ£º
·¶Î§·ÖÇø±í£º
CREATE TABLE sales
(invoice_no NUMBER,
...
sale_date DATE NOT NULL )
PARTITION BY RANGE (sale_date)
(PARTITION sales1999_q1
VALUES LESS THAN (TO_DATE(‘1999-04-01','YYYY-MM-DD')
TABLESPACE ts_sale1999q1,
PARTITION sales1999_q2
VALUES LESS THAN (TO_DATE(‘1999-07-01','YYYY-MM-DD')
TABLESPACE ts_sale1999q2,
PARTITION sales1999_q3
VALUES LESS THAN (TO_DATE(‘1999-10-01','YYYY-MM-DD')
TABLESPACE ts_sale1999q3,
PARTITION sales1999_q4
VALUES LESS THAN (TO_DATE(‘2000-01-01','YYYY-MM-DD')
TABLESPACE ts_sale1999q4 );
--values less than (maxvalue)
Áбí·ÖÇø±í£º
create table emp (
empno number(4),
ename varchar2(30),
location varchar2(30))
partition by list (location)
(partition p1 values ('±±¾©'),
partition p2 values ('ÉϺ£','Ìì½ò','ÖØÇì'),
partition p3 values ('¹ã¶«','¸£½¨')
partition p0 values (default)
);
¹þÏ£·ÖÇø£º
create table emp (
empno number(4),
ename varchar2(30),
sal number)
partition by hash (empno)
partitions 8
store in (emp1,emp2,emp3,emp4,emp5,emp6,emp7,emp8);
×éºÏ·ÖÇø£º
·¶Î§¹þÏ£×éºÏ·ÖÇø£º
create table emp (
empno number(4),
ename varchar2(30),
hiredate date)
partition by range (hiredate)
subpartition by hash (empno)
subpartitions 2
(partition e1 values less than (to_date('20020501','YYYYMMDD')),
partition e2 values less than (to_date('20021001','YYYYMMDD')),
partition e3 values less than (maxvalue));
·¶Î§Áбí×éºÏ·ÖÇø£º
CREATE TABLE customers_part (
customer_id NUMBER(6),
cust_first_name VARCHAR2(20),
cust_last_name VARCHAR2(20),
nls_territory VARCHAR2(30),
credit_limit NUMBER(9,2))
PARTITION BY RANGE (credit_limit)
SUBPARTITION BY LIST (nls


Ïà¹ØÎĵµ£º

ORACLEÖд¥·¢DBWR½ø³ÌµÄʼþ~

½ñÌìÔÚÒ»±¾ÊéÉÏ¿´µ½µÄ£¬¸Ð¾õͦȫµÄ¡£Ó¡ÏóÖÐ×Ô¼ºÒѾ­²»ÖªµÀ°Ù¶ÈÁ˶àÉÙ´ÎÕâ¸öÎÊÌ⣬½ñÌì¾Í¼ÇÏÂÀ´°É£¬·½±ãÒÔºó²éѯ¡£
Êý¾Ý¿âд½ø³ÌÔÚÒÔÏÂʼþÖ®Ò»·¢Éúʱ°ÑÊý¾Ý¿â¸ßËÙ»º³åÇøµÄÊý¾Ýдµ½Êý¾ÝÎļþÉÏ:
µ±Ô໺³åÇøµÄÊýÁ¿³¬¹ýÁËËùÉ趨µÄÏÞ¶î
µ±ËùÉ趨µÄʱ¼ä¼ä¸ôÒѵ½
µ±Óнø³ÌÐèÒªÊý¾Ý¿â¸ßËÙ»º³åÇøÈ´ÕÒ²»µ½¿ÕÏеĻº³åÇøÊ±
µ±¼ì²éµ ......

oracle¼àÌýÆô¶¯²»ÁË

1 ÎÊÌâÃèÊö
oracleÊý¾Ý¿âÔÚ·þÎñÆ÷ÉÏÔËÐÐÕý³££¬µ«ÊDz»ÄÜͨ¹ýÍøÂçÁ¬½Ó£¨¼´Ê¹Óÿͻ§¶Ë²»ÄÜÁ¬½ÓÊý¾Ý¿â£¬ÔÚ·þÎñÆ÷¶ËÕý³££¬Õï¶ÏµÄ³õ²½Ô­ÒòΪ¼àÌýÆ÷ÎÊÌ⣩¡£ÔÚ·þÎñÆ÷¶ËʹÓÃÒÔÏÂÃüÁ
bash-3.1$ cd $ORACLE_HOME/bin
bash-3.1$ ./lsnrctl
LSNRCTL> status
½á¹û³öÏÖ£º
CONNECT (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=E ......

Oracle 8i.9i.10g.11g ²»Í¬°æ±¾µÄÐÂÌØÐԱȽÏ


Oracle 9i±È8i¶àÁËÄÄЩÐÂÌØÐÔ£¿
¼òҪ˵£º
   9i¸üÒ×ÓÚ¹ÜÀí¡£
Ïêϸ˵£º
    ²¢·¢¼¯Èº£¬8i OPSÉý¼¶Îª9i RAC£¬8i½áµã¼äÓÃÓ²Å̽»»»ÐÅÏ¢£¬9i½áµã¼ä²ÉÓøßËÙÍøÏߵĻº´æÈÛºÏ(Cache Fusion)¼¼Êõ½»»»ÐÅÏ¢£¬½»»»ËÙ¶ÈÌá¸ß100±¶ÒÔÉÏ¡£
     9i¿ÉÒÔÔÚÏßÐÞ¸ÄÄں˲ÎÊýºÍÄÚ´ ......

Oracle10g r1ÔÚLINUX OS4Éϵݲװ

°²×°oralce10g R1(10.1)²½Öè·½·¨£º
µÚÒ»²¿·Ö£º
Ò».  Ó²¼þ»·¾³£º
   1. RAM£ºÖÁÉÙ512M
    2.  ½»»»·ÖÇø´óСÖÁÉÙ1G£¨»òÕßÊÇÄÚÔÚµÄ2±¶£©
   3./tmpĿ¼ ÖÁÉÙÓÐ400M¿ÕÏпռä
   4. oracleÈí¼þ°²×°¿Õ¼äÖÁÉÙÔÚ1.5G--3GÖ®¼ä£¨ÒÀ¾Ý°²×°oracleÀàÐͶø¶¨£©
 &nbs ......

OracleÒÆÖ²µ½MySQL×¢ÒâÊÂÏî

¡¡¡¡¿Í»§ÓõÄÊý¾Ý¿âÊÇmysql£¬¶øÑз¢ºÃµÄ²úÆ·Ö§³Öoracle£¬ÎªÁËÈÿͻ§ÌÍÑü°ü£¬ÎÒÃDZØÐë°ÑÊý¾Ý¿â»·¾³´ÓoracleתÏòmysql¡£ÎÒÃÇÔÚת»»µÄ¹ý³ÌÖÐÅöµ½ÁËÏÂÃæÒ»Ð©ÎÊÌ⣬ϣÍûÄܸøÍ¬ÑùÔâÓöµÄͬÈÊÃÇһЩ½è¼ø¡£Èç¹ûÎÒÃÇÔÚ×î³õµÄÉè¼Æ¡¢±àÂë¹ý³ÌÖÐ×¢ÒâÊý¾Ý¿âµÄÒÆÖ²ÐÔ£¬ÕâÖÖÇé¿öÏ¿ÉÒÔÍêÈ«²»ÐèÒª×÷¶îÍ⹤×÷¡£
¡¡¡¡Ò»¡¢Êý¾Ý¿â»·¾³´Óoracleת ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ