Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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


Ïà¹ØÎĵµ£º

ORACLE ÕýÔò±í´ïʽ

¾ÍÊÇÓÉÆÕͨ×Ö·û£¨ÀýÈç×Ö·ûaµ½z£©ÒÔ¼°ÌØÊâ×Ö·û£¨³ÆÎªÔª×Ö·û£©×é³ÉµÄÎÄ×Öģʽ¡£¸ÃģʽÃèÊöÔÚ²éÕÒÎÄ×ÖÖ÷Ìåʱ´ýÆ¥ÅäµÄÒ»¸ö»ò¶à¸ö×Ö·û´®¡£ÕýÔò±í´ïʽ×÷Ϊһ¸öÄ£°å£¬½«Ä³¸ö×Ö·ûģʽÓëËùËÑË÷µÄ×Ö·û´®½øÐÐÆ¥Åä¡£
±¾ÎÄÏêϸµØÁгöÁËÄÜÔÚÕýÔò±í´ïʽÖÐʹÓã¬ÒÔÆ¥ÅäÎı¾µÄ¸÷ÖÖ×Ö·û¡£µ±ÄãÐèÒª½âÊÍÒ»¸öÏÖÓеÄÕýÔò±í´ïʽʱ£¬¿ÉÒÔ×÷Ϊһ¸ö¿ ......

oracleÊ÷½á¹¹²éѯ

 
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 OMF½éÉÜ

ÏÈ¿´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ÎóɾÊý¾ÝÎļþµ¼ÖÂORA

×Ô´ÓѧORACLEÒÔÀ´¾Í´ÓÀ´Ã»Óз¢Éú¹ýʲô¹ÊÕÏ£¬±È½ÏÐÒÔË¡£ÆäʵҲ²»ÄÜËãÐÒÔË£¬ÒòΪÕâÑù¾ÍÉÙÁ˶ÍÁ¶µÄ»ú»áÁË£¬ºÇºÇ£¬Ôõô¾õµÃ×Ô¼ºÓеãÇó۵ÄÇãÏò……
¼´±ãÊÇÔÚѧϰbackup and recovery basicsµÄʱºò£¬Ò²Ö»ÊÇ×ö×ö±¸·ÝµÄʵÑ飬û×ö¹ý»Ö¸´£¬ÒòΪÉí±ßûÓÐÈËÖ¸µ¼£¬Ò²Ã»ÆäËûͬѧÔÚѧORACLE£¬ËùÒÔÅÂÒ»³öÎÊÌâ¿Ï¶¨ºÜÂé·³£¬½â ......

oracle ÅÅÐòÄÚ´æ

ÎÒÔÚhttp://zhidao.baidu.com/question/123262452.html?fr=msg¡¡ÌáµÄÎÊÌ⣬ÕûÀíµ½ÕâÀï¡¡·Ç³£¸Ðл zjwssg
µÄ»Ø´ð
ÅÅÐòÄÚ´æÉæ¼°µ½PGA¡£
ʲôʱºòʹÓÃ×Ô¶¯PGAÄÚ´æ¹ÜÀí£¿Ê²Ã´Ê±ºòʹÓÃÊÖ¶¯PGAÄÚ´æ¹ÜÀí£¿
  °×ÌìϵͳÕý³£ÔËÐÐʱÊʺÏʹÓÃ×Ô¶¯PGAÄÚ´æ¹ÜÀí£¬ÈÃOracle¸ù¾Ýµ±Ç°¸ºÔØ×Ô¶¯¹ÜÀí¡¢·ÖÅäPGAÄÚ´æ¡£
  Ò¹ÀïÓû§Êý ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ