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 ÏòÒ»¸ö±íÖвåÈëÊý¾ÝµÄÁ½ÖÖ·½Ê½£º
Conventional Insert Operations£º´«Í³²åÈë»áÓÅÏÈʹÓøßˮλ֮Ï£¬»á±£Ö¤Êý¾ÝÓ¦ÓÃÍêÕûÐÔ£º¸ßˮλ֮ÏÂÊÇÖ¸£ºÉ¾³ýÖ®ºóµÄÊ£Óà¿Õ¼ä£¬¸ßˮλ֮ÉÏÊÇÖ¸£º´ÓÀ´Ã»ÓÐÓùýµÄ´¦Å®¿é¡£
Direct-path Insert Operatio ......
1. ϵͳÅäÖùý³Ì
2.1. oracle°²×°Ìõ¼þ¼ì²é
2.1.1. Ó²¼þ¼ì²é
¼ì²éÓ²¼þÇé¿öÊÇ·ñ·ûºÏoracle 10g µÄ°²×°ÒªÇó¡£ÒÔrootµÇ¼ϵͳ£¬ÓÃϱíÃüÁîÊä³öµÄÖµÓ¦´óÓÚ»òµÈÓÚ½¨ÒéÖµ¡£
¼ì²éÏîÄ¿
ÃüÁî ......
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;
¼òµ ......
http://www.ej38.com/showinfo/Oracle-108709.html
Oracle 10g statisticÊý¾Ýͳ¼Æ,Oracle»á¸ù¾ÝÕâЩͳ¼ÆÐÅÏ¢À´¾ö¶¨ÊÇ×ßRBO(Rule-BasedOptimization)£¬»¹ÊÇ×ßCBO(Cost-BasedOptimization)£¬»áȥѡÔñÄÄÖÖÖ´Ðмƻ®¸ü»®Ëã,Ó°ÏìÊÇ·ñ×ßÏà¹ØµÄË÷ÒýµÈ.Èç¹ûÊÇCBOµÄ»°£¬ËüÒÀ¿¿×¼È·µÄ£¨»òÕß˵±È½Ï׼ȷµÄ£©Í³¼ÆÐÅÏ¢À´²úÉúÓÅ»¯µÄÖ ......