oracleÉó¼ÆÏê½â
ÔÌû: http://blog.chinaunix.net/u2/66903/showart_2082884.html
OracleʹÓôóÁ¿²»Í¬µÄÉ󼯷½·¨À´¼à¿ØÊ¹ÓúÎÖÖȨÏÞ£¬ÒÔ¼°·ÃÎÊÄÄЩ¶ÔÏó¡£É󼯲»»á·ÀֹʹÓÃÕâЩȨÏÞ£¬µ«¿ÉÒÔÌṩÓÐÓõÄÐÅÏ¢£¬ÓÃÓÚ½ÒʾȨÏÞµÄÀÄÓúÍÎóÓá£
ϱíÖÐ×ܽáÁËOracleÊý¾Ý¿âÖв»Í¬ÀàÐ͵ÄÉ󼯡£
Éó ¼Æ Àà ÐÍ
˵ Ã÷
Óï¾äÉó¼Æ
°´ÕÕÓï¾äÀàÐÍÉó¼ÆSQLÓï¾ä£¬¶ø²»ÂÛ·ÃÎʺÎÖÖÌØ¶¨µÄģʽ¶ÔÏó¡£Ò²¿ÉÒÔÔÚÊý¾Ý¿âÖÐÖ¸¶¨Ò»¸ö»ò¶à¸öÓû§£¬Õë¶ÔÌØ¶¨µÄÓï¾äÉó¼ÆÕâЩÓû§
ȨÏÞÉó¼Æ
Éó¼ÆÏµÍ³È¨ÏÞ£¬ÀýÈçCREATE TABLE»òALTER INDEX¡£ºÍÓï¾äÉó¼ÆÒ»Ñù£¬È¨ÏÞÉó¼Æ¿ÉÒÔÖ¸¶¨Ò»¸ö»ò¶à¸öÌØ¶¨µÄÓû§×÷ΪÉ󼯵ÄÄ¿±ê
ģʽ¶ÔÏóÉó¼Æ
Éó¼ÆÌض¨Ä£Ê½¶ÔÏóÉÏÔËÐеÄÌØ¶¨Óï¾ä(ÀýÈ磬DEPARTMENTS±íÉϵÄUPDATEÓï¾ä)¡£Ä£Ê½¶ÔÏóÉó¼Æ×ÜÊÇÓ¦ÓÃÓÚÊý¾Ý¿âÖеÄËùÓÐÓû§
ϸÁ£¶ÈµÄÉó¼Æ
¸ù¾Ý·ÃÎʶÔÏóµÄÄÚÈÝÀ´É󼯱í·ÃÎʺÍȨÏÞ¡£Ê¹ÓóÌÐò°üDBMS_FGAÀ´½¨Á¢Ìض¨±íÉϵIJßÂÔ
ÏÂÃæ¼¸½Ú½éÉÜDBAÈçºÎ¹ÜÀíϵͳºÍ¶ÔÏóȨÏÞʹÓõÄÉ󼯡£µ±ÐèÒªÒ»¶¨µÄÁ£¶Èʱ£¬DBA¿ÉÒÔʹÓÃϸÁ£¶ÈµÄÉó¼ÆÀ´¼à¿Ø¶Ô±íÖÐijЩÐлòÁеķÃÎÊ£¬¶ø²»½ö½öÊÇÊÇ·ñ·ÃÎÊ±í¡£
ºÍÉó¼ÆÏà¹ØµÄÖ÷Òª²ÎÊý
SQL>show parameter audit
audit_file_dest
audit_sys_operations
audit_trail
audit_sys_operations£º
ĬÈÏΪfalse£¬µ±ÉèÖÃΪtrueʱ£¬ËùÓÐsysÓû§£¨°üÀ¨ÒÔsysdba,sysoperÉí·ÝµÇ¼µÄÓû§£©µÄ²Ù×÷¶¼»á±»¼Ç¼£¬audit trail²»»áдÔÚaud$±íÖУ¬Õâ¸öºÜºÃÀí½â£¬Èç¹ûÊý¾Ý¿â»¹Î´Æô¶¯aud$²»¿ÉÓã¬ÄÇôÏñconn /as sysdbaÕâÑùµÄÁ¬½ÓÐÅÏ¢£¬Ö»ÄܼǼÔÚÆäËüµØ·½¡£Èç¹ûÊÇwindowsƽ̨£¬audti trail»á¼Ç¼ÔÚwindowsµÄʼþ¹ÜÀíÖУ¬Èç¹ûÊÇlinux/unixƽ̨Ôò»á¼Ç¼ÔÚaudit_file_dest²ÎÊýÖ¸¶¨µÄÎļþÖС£
audit_trail£º
None£ºÊÇĬÈÏÖµ£¬²»×öÉ󼯣»
DB£º½«audit trail ¼Ç¼ÔÚÊý¾Ý¿âµÄÉó¼ÆÏà¹Ø±íÖУ¬Èçaud$£¬É󼯵Ľá¹ûÖ»ÓÐÁ¬½ÓÐÅÏ¢£»
DB,Extended£ºÕâÑùÉ󼯽á¹ûÀïÃæ³ýÁËÁ¬½ÓÐÅÏ¢»¹°üº¬Á˵±Ê±Ö´ÐеľßÌåÓï¾ä£»
OS£º½«audit trail ¼Ç¼ÔÚ²Ù×÷ϵͳÎļþÖУ¬ÎļþÃûÓÉaudit_file_dest²ÎÊýÖ¸¶¨£»
XML£º10gÀïÐÂÔöµÄ¡£
10g Values:
none
Disables database auditing.
os
Enables database auditing and directs all audit records to the operating system's audit trail.
db
Enables database auditing and directs all audit records to the database audit trail (the SYS.AUD$ table).
db,extended
Enables database auditing and directs all audit records
Ïà¹ØÎĵµ£º
¾ÍÊÇÓÉÆÕͨ×Ö·û£¨ÀýÈç×Ö·ûaµ½z£©ÒÔ¼°ÌØÊâ×Ö·û£¨³ÆÎªÔª×Ö·û£©×é³ÉµÄÎÄ×Öģʽ¡£¸ÃģʽÃèÊöÔÚ²éÕÒÎÄ×ÖÖ÷Ìåʱ´ýÆ¥ÅäµÄÒ»¸ö»ò¶à¸ö×Ö·û´®¡£ÕýÔò±í´ïʽ×÷Ϊһ¸öÄ£°å£¬½«Ä³¸ö×Ö·ûģʽÓëËùËÑË÷µÄ×Ö·û´®½øÐÐÆ¥Åä¡£
±¾ÎÄÏêϸµØÁгöÁËÄÜÔÚÕýÔò±í´ïʽÖÐʹÓã¬ÒÔÆ¥ÅäÎı¾µÄ¸÷ÖÖ×Ö·û¡£µ±ÄãÐèÒª½âÊÍÒ»¸öÏÖÓеÄÕýÔò±í´ïʽʱ£¬¿ÉÒÔ×÷Ϊһ¸ö¿ ......
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 ¹Ù·½½âÊÍ
Oracle managed file (OMF)
A file that is created automatically by the Oracle database server when it is needed and automatically deleted when it is no longer needed.
ÈçºÎÅжÏÄãµÄÊý¾Ý¿âÊÇ·ñΪ֧³ÖOMF
SQL> show parameter db_create_file_dest;
NAME & ......
×Ô´ÓѧORACLEÒÔÀ´¾Í´ÓÀ´Ã»Óз¢Éú¹ýʲô¹ÊÕÏ£¬±È½ÏÐÒÔË¡£ÆäʵҲ²»ÄÜËãÐÒÔË£¬ÒòΪÕâÑù¾ÍÉÙÁ˶ÍÁ¶µÄ»ú»áÁË£¬ºÇºÇ£¬Ôõô¾õµÃ×Ô¼ºÓеãÇó۵ÄÇãÏò……
¼´±ãÊÇÔÚѧϰbackup and recovery basicsµÄʱºò£¬Ò²Ö»ÊÇ×ö×ö±¸·ÝµÄʵÑ飬û×ö¹ý»Ö¸´£¬ÒòΪÉí±ßûÓÐÈËÖ¸µ¼£¬Ò²Ã»ÆäËûͬѧÔÚѧORACLE£¬ËùÒÔÅÂÒ»³öÎÊÌâ¿Ï¶¨ºÜÂé·³£¬½â ......
ÎÒÔÚhttp://zhidao.baidu.com/question/123262452.html?fr=msg¡¡ÌáµÄÎÊÌ⣬ÕûÀíµ½ÕâÀï¡¡·Ç³£¸Ðл zjwssg
µÄ»Ø´ð
ÅÅÐòÄÚ´æÉæ¼°µ½PGA¡£
ʲôʱºòʹÓÃ×Ô¶¯PGAÄÚ´æ¹ÜÀí£¿Ê²Ã´Ê±ºòʹÓÃÊÖ¶¯PGAÄÚ´æ¹ÜÀí£¿
°×ÌìϵͳÕý³£ÔËÐÐʱÊʺÏʹÓÃ×Ô¶¯PGAÄÚ´æ¹ÜÀí£¬ÈÃOracle¸ù¾Ýµ±Ç°¸ºÔØ×Ô¶¯¹ÜÀí¡¢·ÖÅäPGAÄÚ´æ¡£
Ò¹ÀïÓû§Êý ......