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

Oracle±í¿Õ¼äºÍÊý¾ÝÎļþµÄ³£ÓòÙ×÷

±í¿Õ¼ä×ÊÁϲéѯ
SELECT tablespace_name, block_size, extent_management, segment_space_management from dba_tablespaces;
ÅäºÍ
SELECT tablespace_name, initial_extent, next_extent, max_extents, pct_increase, min_extlen from dba_tablespaces;
ÅäºÏ
SELECT tablespace_name, status, contents from dba_tablespaces; ±í¿Õ¼ä¶ÔÓ¦Êý¾ÝÎļþ×ÊÁϲéѯ
SELECT file_id, file_name, tablespace_name, autoextensible, bytes from dba_data_files; ´´½¨Êý¾Ý×Öµä¹ÜÀíµÄ±í¿Õ¼ä(Ö»ÓÐSYSTEM±í¿Õ¼äΪÊý¾Ý×Öµä¹ÜÀí[Dictionary]ʱ²ÅÄÜ´´½¨,10gÒÔºóµÄSYSTEMĬÈ϶¼ÊDZ¾µØ¹ÜÀí[Local].ʵÖÊÉÏÊý¾Ý×Öµä¹ÜÀí±í¿Õ¼äµÄ×ö·¨»ù±¾²»¿ÉÐÐÁË.¶øÇÒ±¾¼¼Êõ¼ÈÂäºóÒ²µÍЧ)
CREATE TABLESPACE xxx DATAFILE 'c:\zzz\yyy.dbf' SIZE 50M, 'c:\mmm\nnn.dbf' SIZE 50M MINIMUM EXTENT 50K EXTENT MANAGEMENT DICTIONARY DEFAULT STORAGE (INITIAL 50K NEXT 50K MAXENTENTS 100 PCTINCREASE 0);

µÚÒ»¸öextentΪ50k,µÚ¶þ¸ö50k.´ÓµÚÈý¸ö¿ªÊ¼´óСΪNEXT * ((1 + PCTINCREASE/100)µÄn-2´Î·½) ´´½¨±¾µØ¹ÜÀíµÄ±í¿Õ¼ä
CREATE TABLESPACE xxx DATAFILE 'c:\zzz\yyy.dbf' SIZE 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

ÿ¸öextent¶¼ÊÇ1Õ×´óС ´´½¨»¹Ô­±í¿Õ¼ä (Ö»ÄÜʹÓÃDATAFILEºÍEXTENT MANAGEMENT×Ó¾ä)
CREATE UNDO TABLESPACE xxx_undo DATAFILE 'c:\zzz\yyy_undo.dbf' SIZE 20M; ²éѯÁÙʱ±í¿Õ¼ä×ÊÁÏ
SELECT f.file#, t.ts# "TableSpace#", f.name "File", t.name "TableSpace" from v$tempfile f, v$tablespace t WHERE f.ts# = t.ts#; ´´½¨ÁÙʱ±í¿Õ¼ä
CREATE TEMPORARY TABLESPACE xxx_temp TEMPFILE 'C:\YYY\ZZZ_TEMP.DBF' SIZE 10M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2M;

ΪÁËÌá¸ßЧÂÊ,UNIFORM SIZE×îºÃÊÇSORT_AREA_SIZE(PGAÖеÄÅÅÐòÇø´óС)µÄÕûÊý±¶. ĬÈϱí¿Õ¼ä
a.) µ±Êý¾Ý¿âûÓÐĬÈÏÁÙʱ±í¿Õ¼äʱ,½«Ê¹ÓÃSYSTEM±í¿Õ¼ä×÷ΪÅÅÐòÇø,´Ó¶øʹÆäËéƬ»¯.
b.) ²éѯµ±Ç°Ä¬ÈÏÁÙʱ±í¿Õ¼ä
     SELECT * from DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DEFAULT_TEMP_TABLESPACE';
c.) ±ä¸üĬÈÏÁÙʱ


Ïà¹ØÎĵµ£º

Oracle ²åÈë×ܽá

Oracle ÏòÒ»¸ö±íÖвåÈëÊý¾ÝµÄÁ½ÖÖ·½Ê½£º
       Conventional Insert Operations£º´«Í³²åÈë»áÓÅÏÈʹÓøßˮλ֮Ï£¬»á±£Ö¤Êý¾ÝÓ¦ÓÃÍêÕûÐÔ£º¸ßˮλ֮ÏÂÊÇÖ¸£ºÉ¾³ýÖ®ºóµÄÊ£Óà¿Õ¼ä£¬¸ßˮλ֮ÉÏÊÇÖ¸£º´ÓÀ´Ã»ÓÐÓùýµÄ´¦Å®¿é¡£
       Direct-path Insert Operatio ......

LinuxÏÂOracleµÄ°²×°Ïêϸ²½Öè

 
1.       ϵͳÅäÖùý³Ì
2.1. oracle°²×°Ìõ¼þ¼ì²é
2.1.1.               Ó²¼þ¼ì²é
¼ì²éÓ²¼þÇé¿öÊÇ·ñ·ûºÏoracle 10g µÄ°²×°ÒªÇó¡£ÒÔrootµÇ¼ϵͳ£¬ÓÃϱíÃüÁîÊä³öµÄÖµÓ¦´óÓÚ»òµÈÓÚ½¨ÒéÖµ¡£
¼ì²éÏîÄ¿
ÃüÁî ......

OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

 
OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨

connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ ......

Oracle 10g StatisticÊý¾Ýͳ¼Æ

http://www.ej38.com/showinfo/Oracle-108709.html
 Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ