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

²ËÄñÇó½âÒ»Ìõ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      ¾Í²»ÓÃ˵Á˰ɣ¬Á½Õß¶¼Á¢¼´ÉúЧ¡£


Ïà¹ØÎÊ´ð£º

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

MS SQL×÷ÒµÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP

²Î¿¼:http://hi.baidu.com/toiota ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ