²ËÄñÇó½âÒ»ÌõOracle Éó¼ÆÏà¹ØµÄSQLÓï¾ä
SQL > alter system set audit_sys_operations=TRUE scope=spfile; ÕâÀïµÄscope=spfileÉèÖÃÊÇʲôÒâË¼ÄØ£¿
²ÎÊýÉèÖõÄÓ°Ï췶Χ scope=spfile±íʾÉèÖöÔspfileÉúЧ£¨¼´Ï´ÎÊý¾Ý¿âÆô¶¯Ê±ÉúЧ£©£¬¶ø¶Ôµ±Ç°SGA²»ÉúЧ¡£ÒýÓà ²ÎÊýÉèÖõÄÓ°Ï췶Χ scope=spfile±íʾÉèÖöÔspfileÉúЧ£¨¼´Ï´ÎÊý¾Ý¿âÆô¶¯Ê±ÉúЧ£©£¬¶ø¶Ôµ±Ç°SGA²»ÉúЧ¡£ Ö§³ÖÒýÓà ²ÎÊýÉèÖõÄÓ°Ï췶Χ scope=spfile±íʾÉèÖöÔspfileÉúЧ£¨¼´Ï´ÎÊý¾Ý¿âÆô¶¯Ê±ÉúЧ£©£¬¶ø¶Ôµ±Ç°SGA²»ÉúЧ¡£ ŶÃ÷°×ÁË£¬ÄÇÔÙÇë½Ì£¬scope»¹¿ÉÒÔÊÇÄÄЩֵ£¿·Ö±ð´ú±íÁËʲô·¶Î§°¡£¿ »¹ÓÐÁ©Öµ memory ºÍspfileÏà·´£¬¶Ôµ±Ç°SGAÉúЧ£¬¶ø²»¼Ç¼½øspfile both ¾Í²»ÓÃ˵Á˰ɣ¬Á½Õß¶¼Á¢¼´ÉúЧ¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ ÀýÈç£ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬ »òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡ ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡 ֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡ °ïUP ²Î¿¼:http://hi.baidu.com/toiota ......