OracleÉó¼Æ¹¦ÄÜ
OracleÉó¼Æ¹¦ÄÜ
Éó¼ÆÊǶÔÑ¡¶¨µÄÓû§¶¯×÷µÄ¼à¿ØºÍ¼Ç¼£¬Í¨³£ÓÃÓÚ£º
u Éó²é¿ÉÒɵĻ¡£ÀýÈ磺Êý¾Ý±»·ÇÊÚȨÓû§Ëùɾ³ý£¬´Ëʱ°²È«¹ÜÀíÔ±¿É¾ö¶¨¶Ô¸Ã Êý¾Ý¿âµÄËùÓÐÁ¬½Ó½øÐÐÉó¼Æ£¬ÒÔ¼°¶ÔÊý¾Ý¿âµÄËùÓбíµÄ³É¹¦µØ»ò²»³É¹¦µØɾ³ý½øÐÐÉó¼Æ¡£
u ¼àÊÓºÍÊÕ¼¯¹ØÓÚÖ¸¶¨Êý¾Ý¿â»î¶¯µÄÊý¾Ý¡£ÀýÈ磺DBA¿ÉÊÕ¼¯ÄÄЩ±»Ð޸ġ¢Ö´ÐÐÁ˶àÉÙ´ÎÂß¼µÄI/OµÈͳ¼ÆÊý¾Ý¡£
ORACLEÖ§³ÖÈýÖÖÉó¼ÆÀàÐÍ£º
u Óï¾äÉó¼Æ£¬¶ÔijÖÖÀàÐ͵ÄSQLÓï¾äÉó¼Æ£¬²»Ö¸¶¨½á¹¹»ò¶ÔÏó¡£
u ÌØȨÉó¼Æ£¬¶ÔÖ´ÐÐÏàÓ¦¶¯×÷µÄϵͳÌØȨµÄʹÓÃÉó¼Æ¡£
u ¶ÔÏóÉó¼Æ£¬¶ÔÒ»ÌØÊâģʽ¶ÔÏóÉϵÄÖ¸¶¨Óï¾äµÄÉó¼Æ¡£
ORACLEËùÔÊÐíµÄÉó¼ÆÑ¡ÔñÏÞÓÚÏÂÁз½Ã棺
u Éó¼ÆÓï¾äµÄ³É¹¦Ö´ÐС¢²»³É¹¦Ö´ÐУ¬»òÕßÆäÁ½Õß¡£
u ¶ÔÿһÓû§»á»°Éó¼ÆÓï¾äÖ´ÐÐÒ»´Î»òÕ߶ÔÓï¾äÿ´ÎÖ´ÐÐÉó¼ÆÒ»´Î¡£
u ¶ÔÈ«²¿Óû§»òÖ¸¶¨Óû§µÄ»î¶¯µÄÉó¼Æ¡£
µ±Êý¾Ý¿âµÄÉó¼ÆÊÇʹÄܵģ¬ÔÚÓï¾äÖ´Ðн׶βúÉúÉó¼Æ¼Ç¼¡£Éó¼Æ¼Ç¼°üº¬ÓÐÉó¼ÆµÄ²Ù×÷¡¢Óû§Ö´ÐеIJÙ×÷¡¢²Ù×÷µÄÈÕÆÚºÍʱ¼äµÈÐÅÏ¢¡£Éó¼Æ¼Ç¼¿É´æÔÚÊý¾Ý×Öµä±í£¨³ÆΪÉó¼Æ¼Ç¼£©»ò²Ù×÷ϵͳÉó¼Æ¼Ç¼ÖС£Êý¾Ý¿âÉó¼Æ¼Ç¼ÊÇÔÚSYSģʽµÄAUD$±íÖС£
ÉèÖÃORACLEÉó¼Æ
ÏÂÁв½Öè¿ÉÒÔÉèÖÃORACLEµÄÉó¼Æ¹¦ÄÜ£º
1. Ð޸IJÎÊýÎļþ£¨init<sid>.ora£¬Èç¹ûʹÓ÷þÎñÆ÷²ÎÊýÎļþʹÓÃalter system set <parameter>=<value> scope=spfile|both£¬ÏêÇé²ÎÕÕ1.1½ÚÖйØÓÚ²ÎÊýÎļþµÄ½éÉÜ£©£¬ÉèÖà AUDIT_TRAIL²ÎÊý£¬²¢ÇÒÖØÆôÊý¾Ý¿â¡£AUDIT_TRAILµÄÈ¡ÖµÈçÏ£º
l DB/TRUE£ºÆô¶¯Éó¼Æ¹¦ÄÜ£¬²¢ÇÒ°ÑÉó¼Æ½á¹û´æ·ÅÔÚÊý¾Ý¿âµÄ SYS.AUD$ ±íÖÐ
l OS£ºÆô¶¯Éó¼Æ¹¦ÄÜ£¬²¢°ÑÉó¼Æ½á¹û´æ·ÅÔÚ²Ù×÷ϵͳµÄÉó¼ÆÐÅÏ¢ÖÐ
l DB_EXTENDED£º¾ßÓÐDB/TRUEµÄ¹¦ÄÜ£¬ÁíÍâÌîдAUD$µÄSQLBINDºÍSQLTEXT×Ö¶Î
l &n
Ïà¹ØÎĵµ£º
--²é³öËùÓб»ËøסµÄ±í
select b.owner TABLEOWNER, b.object_name TABLENAME, c.OSUSER LOCKBY, c.USERNAME LOGINID, c.sid SID, c.SERIAL# SERIAL
from v$locked_object a,dba_objects b, v$session c
where b.object_id = a.object_id AND a.SESSION_ID =c.sid;
--ͨ¹ýSID, SERIAL½âËø
--alter system kill sessio ......
pl/sql ±í
ÔÚpl/sql¿éÖÐÁÙʱʹÓá¢ÏñÊý×éÒ»ÑùµÄ¶ÔÏó
°üº¬Ò»ÁкÍÒ»¸öÖ÷¼ü
²»ÄܶÔÁкÍÖ÷¼ü½øÐÐÃüÃû
ÁпÉÒÔÊÇÈκαêÁ¿Êý¾ÝÀàÐÍ
Ö÷¼ü±ØÐëÊÇbinary_integerÀàÐÍ
´óСûÓÐÏÞÖÆ
ÉùÃ÷pl/sql±í
¶¨Òå±íµÄÀàÐÍ
type ÀàÐÍÃû is table of ÁÐÀàÐÍ|±äÁ¿Êý¾ÝÀàÐÍ ......
ÎÒ¶ÔORACLE BI µÄETLµÄһЩ×ܽᣨԣ© ÊÕ²Ø
http://blog.chinaunix.net/u/25176/showart_2036107.html
Êý¾Ý²Ö¿âÖеÄETLÏêϸµÄ·ÖΪËĸö½×¶Î£ºÌáÈ¡£¬´«Ê䣬ת»»£¬×°ÔØ¡£ÎÒÏȼòµ¥µÄ½éÉÜÒ»ÏÂÌáÈ¡ºÍ´«ÊäµÄ·ÖÀàºÍ·½·¨£º
Ò»£ºÌáÈ¡
ÌáÈ¡¿ÉÒÔ·ÖΪÂß¼ÌáÈ¡£¬ºÍÎïÀíÌáÈ¡¡£
1£ºÂß¼ÌáÈ¡°´ÕÕ¹æÄ£·ÖΪ£ºÍ ......
oracleµÄµ¼Èëµ¼³öÃüÁîÖ±½ÓÓÃcmd¾Í¿ÉÒÔÍê³É£¬µ¼³öµÄÎļþµØÖ·¾ÍÊÇcmdµÄµØÖ·£¬cmdµÄÔʼµØÖ·¿ÉÒԸģ¬ÔËÐÐcd ..Í˻ص½Éϼ¶Ä¿Â¼ cd¿Õ¸ñ¼ÓĿ¼Ãû Êǵ½Ï¼¶Ä¿Â¼ ÊäÈëD£º»Ø³µ¾Í¿ÉÒÔÖ±½Óµ½dÅÌ
exp Óû§Ãû/ÃÜÂë@Êý¾Ý¿âÃû file=ÐèÒª±£´æµÄÎļþ.dmp tables=£¨A±í,B±í....£© log=ÈÕÖ¾.log
exp jjeto_eim_user/jjetoeimuser@EIM ......
Oracle²ã´Î²éѯºÍ·ÖÎöº¯ÊýÔںŶÎÑ¡È¡ÖеÄÓ¦ÓÃ
ÕªÒª
Ò»×éÁ¬ÐøµÄÊý£¬È¥µôÖмäһЩÊý£¬ÈçºÎÇó³öʣϵÄÊýµÄÇø¼ä£¨¼´ºÅ¶Î£©£¿ÖªµÀºÅ¶ÎµÄÆðÖ¹£¬ÈçºÎÇó³ö¸ÃºÅ¶ÎÄÚËùÓеÄÊý£¿ÖªµÀÒ»¸ö´óµÄºÅ¶Î·¶Î§ºÍÒѾȡ¹ýµÄºÅ¶Î£¬ÈçºÎÇó³ö¿ÉÓõĺŶΣ¿ÀûÓÃOracleÌṩµÄÇ¿´óµÄ²éѯ¹¦ÄÜÒÔ¼°·ÖÎöº¯Êý£¬ÎÒÃÇ¿ÉÒÔºÜÇáËɵĽâ¾öÉÏÊöÎÊÌâ¡£
¹Ø¼ü´Ê£º
......