±ØÐëÒýÆðDBAÖØÊÓµÄOracleÊý¾Ý¿âË鯬
À´Ô´£º[url]http://www.wangchao.net.cn/bbsdetail_1788053.html[/url]
Ŀǰ£¬OracleÒѾ¹ã·ºµÄÓ¦ÓÃÓÚ¸÷¸öÐÐÒµ¡£×÷ΪһÃûDBA£¬¼°Ê±·¢ÏÖ²¢ÕûÀíË鯬ÒѾ³ÉΪDBAÈÕ³£¹¤×÷ÖеÄÒ»ÏîÖØÒªÎ¬»¤ÄÚÈÝ¡£ 1¡¢Ë鯬ÊÇÈçºÎ²úÉúµÄ µ±Éú³ÉÒ»¸öÊý¾Ý¿âʱ£¬Ëü»á·Ö³É³ÆÎª±í¿Õ¼ä(tablespace)µÄ¶à¸öÂß¼¶Î(segment)£¬Èçϵͳ(system)±í¿Õ¼ä,ÁÙʱ(temporary)±í¿Õ¼äµÈ¡£Ò»¸ö±í¿Õ¼ä¿ÉÒÔ°üº¬¶à¸öÊý¾Ý·¶Î§(extent)ºÍÒ»¸ö»ò¶à¸ö×ÔÓÉ·¶Î§¿é£¬¼´×ÔÓɿռä(free space)¡£ ±í¿Õ¼ä¡¢¶Î¡¢·¶Î§¡¢×ÔÓɿռäµÄÂß¼¹ØÏµÈçÏÂ: µ±±í¿Õ¼äÖÐÉú³ÉÒ»¸ö¶Îʱ£¬½«´Ó±í¿Õ¼äÓÐЧ×ÔÓɿռäÖÐΪÕâ¸ö¶ÎµÄ³õʼ·¶Î§·ÖÅä¿Õ¼ä¡£ÔÚÕâЩ³õʼ·¶Î§³äÂúÊý¾Ýʱ£¬¶Î»áÇëÇóÔö¼ÓÁíÒ»¸ö·¶Î§¡£ÕâÑùµÄÀ©Õ¹¹ý³Ì»áÒ»Ö±¼ÌÐøÏÂÈ¥£¬Ö±µ½´ïµ½×î´óµÄ·¶Î§Öµ£¬»òÕßÔÚ±í¿Õ¼äÖÐÒѾûÓÐ×ÔÓɿռäÓÃÓÚÏÂÒ»¸ö·¶Î§¡£×îÀíÏëµÄ״̬¾ÍÊÇÒ»¸ö¶ÎµÄÊý¾Ý¿É±»´æÔÚµ¥Ò»µÄÒ»¸ö·¶Î§ÖС£ÕâÑù£¬ËùÓеÄÊý¾Ý´æ´¢Ê±¿¿½ü¶ÎÄÚÆäËüÊý¾Ý£¬²¢ÇÒѰÕÒÊý¾Ý¿ÉÉÙÓÃһЩָÕë¡£µ«ÊÇÒ»¸ö¶Î°üº¬¶à¸ö·¶Î§µÄÇé¿öÊÇ´óÁ¿´æÔڵģ¬Ã»ÓÐÈκδëÊ©¿ÉÒÔ±£Ö¤ÕâЩ·¶Î§ÊÇÏàÁÚ´æ´¢µÄ£¬Èçͼ¡´1¡µ¡£µ±ÒªÂú×ãÒ»¸ö¿Õ¼äÒªÇóʱ£¬Êý¾Ý¿â²»Ôٺϲ¢ÏàÁÚµÄ×ÔÓÉ·¶Î§(³ý·Ç±ðÎÞÑ¡Ôñ)£¬ ¶øÊÇѰÕÒ±í¿Õ¼äÖÐ×î´óµÄ×ÔÓÉ·¶Î§À´Ê¹Óá£ÕâÑù½«Öð½¥ÐγÉÔ½À´Ô½¶àµÄÀëÉ¢µÄ¡¢·Ö¸ôµÄ¡¢½ÏСµÄ×ÔÓɿռ䣬¼´Ë鯬¡£ 2¡¢Ë鯬¶ÔϵͳµÄÓ°Ïì Ëæ×Åʱ¼äÍÆÒÆ£¬»ùÓÚÊý¾Ý¿âµÄÓ¦ÓÃϵͳµÄ¹ã·ºÊ¹Ó㬲úÉúµÄË鯬»áÔ½À´Ô½¶à£¬½«¶ÔÊý¾Ý¿âÓÐÒÔÏÂÁ½µãÖ÷ÒªÓ°Ïì: (1)µ¼ÖÂϵͳÐÔÄܼõÈõ ÈçÉÏËùÊö£¬µ±ÒªÂú×ãÒ»¸ö¿Õ¼äÒªÇóʱ£¬Êý¾Ý¿â½«Ê×ÏȲéÕÒµ±Ç°×î´óµÄ×ÔÓÉ·¶Î§£¬¶ø"×î´ó"×ÔÓÉ·¶Î§Öð½¥±äС£¬ÒªÕÒµ½Ò»¸ö×ã¹»´óµÄ×ÔÓÉ·¶Î§ÒѱäµÃÔ½À´Ô½À§ÄÑ£¬´Ó¶øµ¼Ö±í¿Õ¼äÖеÄËÙ¶ÈÕϰ£¬Ê¹Êý¾Ý¿âµÄ¿Õ¼ä·ÖÅäÓú·¢Ô¶ÀëÀíÏë״̬; (2)ÀË·Ñ´óÁ¿µÄ±í¿Õ¼ä ¾¡¹ÜÓÐÒ»²¿·Ö×ÔÓÉ·¶Î§(Èç±í¿Õ¼äµÄpctincreaseΪ·Ç0)½«»á±»smon(ϵͳ¼à¿Ø)ºǫ́½ø³ÌÖÜÆÚÐԵغϲ¢£¬µ«Ê¼ÖÕÓÐÒ»²¿·Ö×ÔÓÉ·¶Î§ÎÞ·¨µÃÒÔ×Ô¶¯ºÏ²¢£¬ÀË·ÑÁË´óÁ¿µÄ±í¿Õ¼ä¡£ 3¡¢×ÔÓÉ·¶Î§µÄË鯬¼ÆËã ÓÉÓÚ×ÔÓɿռäË鯬ÊÇÓɼ¸²¿·Ö×é³É£¬È緶ΧÊýÁ¿¡¢×î´ó·¶Î§³ß´çµÈ£¬ÎÒÃÇ¿ÉÓÃfsfi--free space fragmentation index(×ÔÓɿռäË鯬Ë÷Òý)ÖµÀ´Ö±¹ÛÌåÏÖ: fsfi=100*sqrt(max(extent)/sum(extents))*1/sqrt(sqrt(count(extents))) ¿ÉÒÔ¿´³ö£¬fsfiµÄ×î´ó¿ÉÄÜֵΪ100(Ò»¸öÀíÏëµÄµ¥Îļþ±í¿Õ¼ä)¡£Ëæ×Å·¶Î§µÄÔö¼Ó£¬fsfiÖµ»ºÂýϽµ£¬¶øËæ×Å×î´ó·¶Î§³ß´çµÄ¼õÉÙ£¬fsfiÖµ»áѸËÙϽµ¡£ ÏÂÃæµÄ½Å±¾¿ÉÒÔÓÃÀ´¼ÆËãfsfiÖµ: rem fsfi value compute rem fsfi.sql
Ïà¹ØÎĵµ£º
sqlplus sys/password as sysdba;ϵͳ¹ÜÀíÔ±µÇ¼
alter user scott account unlock; ¸ü¸ÄÓû§
desc £¨±íÃû£©
select * from (table name);
select distinct ename from emp;
select ename,sal from emp;
select ename,sal*12 'annual_sal' from emp;
select ename,sal from emp where sal>1000;
select ......
Ò»¡¢³£ÓÃÓï·¨ --1. ɾ³ý±íʱ¼¶ÁªÉ¾³ýÔ¼Êø
drop table ±íÃû cascade constraint
--2. µ±¸¸±íÖеÄÄÚÈݱ»É¾³ýºó£¬×Ó±íÖеÄÄÚÈÝÒ²±»É¾³ý
on delete casecade
--3. ÏÔʾ±íµÄ½á¹¹
desc ±íÃû
--4. ´´½¨ÐµÄÓû§
create user [username] identified by [password]
--5. ¸øÓû§·ÖÅäȨÏÞ
grant ȨÏÞ1¡¢È¨ÏÞ2...to Óû§ ......
MViewÖØÒªÊÓͼÔÚÔ´Êý¾Ý¿â¶ËµÄÏà¹ØÊÓͼDBA_BASE_TABLE_MVIEWSDBA_REGISTERED_MVIEWSDBA_MVIEW_LOGSÔÚMViewÊý¾Ý¿â¶ËµÄÏà¹ØÊÓͼDBA_MVIEWSDBA_MVIEW_REFRESH_TIMESDBA_REFRESHºÍDBA_REFRESH_CHILDRENMViewÏà¹Ø°üһЩMViewά»¤µÄÏà¹ØÎÊÌâSNAPSHOT vs. Materialized ViewÇåÀíÎÞЧµÄMView Log²éѯMView LogµÄ´óС¼ì²éMVµÄˢмæ ......
http://space.itpub.net/4227/viewspace-68592
ÎﻯÊÓͼµÄ¿ìËÙË¢ÐÂÒªÇó»ù±¾±ØÐ뽨Á¢ÎﻯÊÓͼÈÕÖ¾£¬ÕâÆªÎÄÕ¼òµ¥ÃèÊöÒ»ÏÂÎﻯÊÓͼÈÕÖ¾Öи÷¸ö×ֶεĺ¬ÒåºÍÓÃ;¡£
ÎﻯÊÓͼÈÕÖ¾µÄÃû³ÆÎªMLOG$_ºóÃæ¸ú»ù±íµÄÃû³Æ£¬Èç¹û±íÃûµÄ³¤¶È³¬¹ý20룬Ôòֻȡǰ20룬µ±½Ø¶Ìºó³öÏÖÃû³ÆÖظ´Ê±£¬Oracle»á×Ô¶¯ÔÚÎﻯÊÓͼÈÕÖ¾Ãû³ÆºóÃæ¼ ......