oracle Ë÷Òý
2009-07-16 10:59
Ë÷Òý´´½¨²ßÂÔ
1.µ¼ÈëÊý¾ÝºóÔÙ´´½¨Ë÷Òý
2.²»ÐèҪΪºÜСµÄ±í´´½¨Ë÷Òý
3.¶ÔÓÚÈ¡Öµ·¶Î§ºÜСµÄ×ֶΣ¨±ÈÈçÐÔ±ð×ֶΣ©Ó¦µ±½¨Á¢Î»Í¼Ë÷Òý
4.ÏÞÖƱíÖеÄË÷ÒýµÄÊýÄ¿
5.ΪË÷ÒýÉèÖúÏÊʵÄPCTFREEÖµ
6.´æ´¢Ë÷ÒýµÄ±í¿Õ¼ä×îºÃµ¥¶ÀÉ趨
´´½¨²»Î¨Ò»Ë÷Òý
create index emp_ename on employees(ename)
tablespace users
storage(......)
pctfree 0;
´´½¨Î¨Ò»Ë÷Òý
create unique index emp_email on employees(email)
tablespace users;
´´½¨Î»Í¼Ë÷Òý
create bitmap index emp_sex on employees(sex)
tablespace users;
´´½¨·´ÐòË÷Òý
create unique index order_reinx on orders(order_num,order_date)
tablespace users
reverse;
´´½¨º¯ÊýË÷Òý(º¯ÊýË÷Òý¼´¿ÉÒÔÊÇÆÕͨµÄBÊ÷Ë÷Òý£¬Ò²¿ÉÒÔÊÇλͼË÷Òý)
create index emp_substr_empno
on employees(substr(empno,1,2))
tablespace users;
ÐÞ¸ÄË÷Òý´æ´¢²ÎÊý(Óë±íÀàËÆ£¬INITIALºÍMINEXTENTS²ÎÊýÔÚË÷Òý½¨Á¢ÒÔºó²»ÄÜÔٸıä)
alter index emp_ename storage(pctincrease 50); ÓÉÓÚ¶¨ÒåÔ¼ÊøʱÓÉoracle×Ô¶¯½¨Á¢µÄË÷Òýͨ³£ÊDz»ÖªµÀÃû³ÆµÄ£¬¶ÔÕâÀàË÷ÒýµÄÐ޸ľ³£ÊÇÀûÓÃalter table ..using indexÓï¾ä½øÐеÄ,¶ø²»ÊÇalter indexÓï¾ä
ÀûÓÃÏÂÃæµÄÓï¾ä½«employees±íÖÐprimary keyÔ¼Êø¶ÔÓ¦µÄË÷ÒýµÄPCTFREE²ÎÊýÐÞ¸ÄΪ5
alter table employees enable primary key using index pctfree 5;
ÇåÀíË÷ÒýËéƬ
1.ºÏ²¢Ë÷Òý(Ö»ÊǼòµ¥µÄ½«BÊ÷Ò¶½áµãÖеĴ洢ËéƬºÏ²¢ÔÚÒ»Æ𣬲¢²»»á¸Ä±äË÷ÒýµÄÎïÀí×éÖ¯½á¹¹£©
alter index emp_pk coalesce;
2.Öؽ¨Ë÷Òý(²»½öÄܹ»Ïû³ý´æ´¢ËéƬ,»¹¿ÉÒԸıäË÷ÒýµÄÈ«²¿´æ´¢²ÎÊýÉèÖ㬲¢ÇÒ¿ÉÒÔ½«Ë÷ÒýÒƶ¯µ½ÆäËüµÄ±í¿Õ¼äÖÐ,Öؽ¨Ë÷Òý
ʵ¼ÊÉϾÍÊÇÔÙÖ¸¶¨µÄ±í¿Õ¼äÖÐÖØн¨Á¢Ò»¸öеÄË÷Òý,È»ºóɾ³ýÔÀ´µÄË÷Òý)
alter index emp_pk rebuild;
ɾ³ýË÷Òý
drop index emp_ename;
Èç¹ûË÷ÒýÖаüº¬Ë𻵵ÄÊý¾Ý¿é£¬»òÕß°üº¬¹ý¶àµÄ´æ´¢ËéƬ£¬ÐèÒªÊ×ÏÈɾ³ýÕâ¸öË÷Òý£¬È»ºóÔÙÖؽ¨Ëü.
Èç¹ûË÷ÒýÊÇÔÚ´´½¨Ô¼ÊøʱÓÉoracle×Ô¶¯²úÉúµÄ,¿ÉÒÔͨ¹ý½ûÓÃÔ¼Êø»òɾ³ýÔ¼ÊøµÄ·½·¨À´É¾³ý¶ÔÓ¦µÄË÷Òý.
ÔÚɾ³ýÒ»¸ö±íʱ,oracle»á×Ô¶¯É¾³ýËùÓÐÓë¸Ã±íÏà¹ØµÄË÷Òý.
Ë÷ÒýÊý¾Ý×Öµä
all_indexes/dba_indexes/user_indexes Ë÷ÒýµÄ»ù±¾ÐÅÏ¢
all_ind_columns/dba_ind_columns/user_ind_columns Ë÷Òý¶ÔÓ¦µÄ×Ö¶ÎÐÅÏ¢
create unique index Ë÷ÒýÃû on ±íÃû(×Ö¶ÎÃû)
create
Ïà¹ØÎĵµ£º
1¡¢ÅäÖÃhibernate£º
1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ
org.springframework.orm.hibernate3.support.BlobByteArray ......
Êý¾Ý¿â¶ÔÏó
<1>±í(Ô¼Êø)
<2>ÈçºÎ×Ô¶¯±àºÅ
SQLserver
--IDENTITYÊôÐÔ
create table test(
xh int identity(1,2) primary key,
name varchar(20)
);
insert into test(name) values ('mike');
ORACLE
Ò»¸ö¶ÔÏó(ÐòÁÐsequenc ......
a)Êý¾Ý¿â±¾ÉíµÄÓÅ»¯
³õʼ»¯Îļþ init.ora
open_cursors = 150 ´ò¿ªµÄÓαêµÄ¸öÊý
ºÜ¶àµÄ´æ´¢¹ý³ÌµÄʱºò ¿ÉÒÔ°ÑËüµ÷´óЩ
......
<1>Âß¼±¸·Ý
²»ÓÃÈ¥¿½±´Êý¾Ý¿âµÄÎïÀíÎļþ
±¸·ÝÂß¼ÉϵĽṹ
ÍⲿµÄ¹¤¾ß:µ¼³öºÍµ¼ÈëµÄ¹¤¾ß
DOSϵÄÃüÁî cmdÏÂÖ´ÐÐ
µ¼³öexp exportËõдÐÎʽ
²é¿´°ïÖú exp help=y
ʹÓòÎÊýÎļþµ¼³ö
exp parfile=c:\ab ......
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄÖµ¡ ......