ORACLEµÄ±í·ÖÎö²ßÂÔ
¶Ô±í½øÐзÖÎö£¬Í¨³£Çé¿öÏ¿ÉÒÔ¶Ô±í£¬Ë÷Òý£¬ÁнøÐе¥¶À·ÖÎö£¬»òÕß½øÐÐ×éºÏ·ÖÎö£¬µ«ÕâÈýÕßÄÄЩÊÇÏà¶ÔÖØÒªµÄ£¬ÄÄЩ·ÖÎöÏԵò»ÄÇôÖØÒª£¿Í¨¹ý±¾ÆªÎÄÕµÄʵÑéÏàÐÅ´ó¼ÒÒ²»á¶ÔÖ±·½Í¼ÓиüÒ»²½µÄÁ˽â.
1.Ê×ÏÈ´´½¨²âÊÔ±í,²¢²åÈë100000ÌõÊý¾Ý
SQL> create table test(id number,nick varchar2(30));
Table created.
SQL> begin
2 for i in 1..100000 loop
3 insert into test(id) values(i);
4 end loop;
5 commit;
6 end;
7 /
PL/SQL procedure successfully completed.
¸üÐÂnick×ֶΣ¬Ê¹Êý¾Ý·¢ÉúÑÏÖØÇãб
SQL> update test set nick='abc' where rownum<99999;
99998 rows updated.
SQL> commit;
Commit complete.
SQL> create index idx_test_nick on test(nick);
Index created.
SQL> update test set nick='def' where nick is null;
2 rows updated.
SQL> commit;
Commit complete.
--Ö»¶ÔË÷Òý½øÐзÖÎö
SQL> analyze index idx_test_nick compute statistics;
Index analyzed.
SQL> select index_name,LEAF_BLOCKS,DISTINCT_KEYS,NUM_ROWS from user_indexes where index_name='IDX_TEST_NICK';
INDEX_NAME LEAF_BLOCKS DISTINCT_KEYS NUM_ROWS
------------------------------ ----------- ------------- ----------
IDX_TEST_NICK 210 2 100000
SQL> select COLUMN_NAME,NUM_BUCKETS,num_distinct from USER_tab_columns where table_name='TEST';
COLUMN_NAME NUM_BUCKETS NUM_DISTINCT
------------------------------
Ïà¹ØÎĵµ£º
extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î» --segment management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......
SELECT
T.ELES_FLG,
T.SENDUNIT_NAME,
T.ROM_SEQNO,
LTRIM(MAX(SYS_CONNECT_BY_PATH(T.MODEL, ',')), ',') MODEL
from (SELECT
......
Õâ¶Îʱ¼ä£¬½ÓµÄ¶àÊÇRACµÄά»¤ºÍ»Ö¸´ÎÊÌâ¡£ËùÒÔÿÌ춼ÊÇÔÚºÍRAC´ò½»µÀ¡£
RACÕæµÄºÜºÃÍæ¡£
´ó¼ÒÓжÔRAC¸ÐÐËȤµÄÓÐÎÊÌâµÄ£¬»òÕßÊÇÓöµ½RACά»¤ÉÏÃæµÄ³öÏÖÎÊÌâµÄ£¬¿ÉÒÔ·¢ÓʼþÖÁinthirties@gmail.comÒ»Æð½»Á÷Ñо¿¡£
ÕæµÄºÜÏ£ÍûÍæOracle ......
SQL> alter tablespace myalan
2 add datafile 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\IRMDB\myspace02.dbf' size 10m;
±í¿Õ¼äÒѸü¸Ä¡£
SQL> select file_name from dba_data_files where tablespace_name='MYALAN';
FILE_NAME
-------------------------------------------------------------------- ......