¹ØÓÚORACLE Éó¼ÆµÄһЩÊÓͼºÍ½Å±¾
Éó¼ÆÊÓͼ
STMT_AUDIT_OPTION_MAP -- Éó¼ÆÑ¡ÏîÀàÐÍ´úÂë
AUDIT_ACTIONS -- action´úÂë
ALL_DEF_AUDIT_OPTS -- ¶ÔÏó´´½¨Ê±Ä¬ÈϵĶÔÏóÉó¼ÆÑ¡Ïî
DBA_STMT_AUDIT_OPTS -- µ±Ç°Êý¾Ý¿âϵͳÉó¼ÆÑ¡Ïî
DBA_PRIV_AUDIT_OPTS -- ȨÏÞÉó¼ÆÑ¡Ïî
DBA_OBJ_AUDIT_OPTS
USER_OBJ_AUDIT_OPTS -- ¶ÔÏóÉó¼ÆÑ¡Ïî
DBA_AUDIT_TRAIL
USER_AUDIT_TRAIL -- Éó¼Æ¼Ç¼
DBA_AUDIT_OBJECT
USER_AUDIT_OBJECT -- Éó¼Æ¶ÔÏóÁбí
DBA_AUDIT_SESSION
USER_AUDIT_SESSION -- sessionÉó¼Æ
DBA_AUDIT_STATEMENT
USER_AUDIT_STATEMENT -- Óï¾äÉó¼Æ
DBA_AUDIT_EXISTS -- ʹÓÃBY AUDIT NOT EXISTSÑ¡ÏîµÄÉó¼Æ
DBA_AUDIT_POLICIES -- Éó¼ÆPOLICIES
DBA_COMMON_AUDIT_TRAIL -- ±ê×¼Éó¼Æ+¾«Ï¸Éó¼Æ
һЩ½Å±¾
ÏÂÃæÕâ¸ö½Å±¾¿ÉÒÔÕÒ³öϵͳ¿ªÁËÄÄЩ ϵͳÉó¼Æ¹¦ÄÜ(·Çobject Éó¼Æ)
select nvl(user_name,'SYSTEM WIDE AUDITING')"User_Name",proxy_name "Proxy_Name",audit_option "Audit_Option",
success "Success?",failure "Failure?" from DBA_STMT_AUDIT_OPTS;
Àý×Ó£º
SQL> select nvl(user_name,'SYSTEM WIDE AUDITING')"User_Name",proxy_name "Proxy_Name",audit_option "Audit_Option",
2 success "Success?",failure "Failure?" from DBA_STMT_AUDIT_OPTS;
User_Name Proxy_Name Audit_Option Success? Failure?
------------------------------ ------------------------------ ---------------------------------------- ---------- -----
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
ÕâÀïÊ×ÏÈ˵ÏÂoracle·ÖÒ³²»Ïñmysql·ÖÒ³ÄÇô¼òµ¥Ö±½Ólimit ¾Í¿ÉÒÔÁË.
mysql£ºsql ="select * from talbe limit 0,10";
µÚÒ»¸öÊý±íʾϱ꣬¾ÍÊÇ´ÓµÚ¼¸ÌõÊý¾Ý¿ªÊ¼£¬
µÚ¶þ¸öÊý±íʾÿҳÏÔʾ¶àÉÙÌõÊý¾Ý£¬¿ÉÒÔ˵Êǵ±ÄãÈ·¶¨Ã¿Ò³ÏÔʾ¶àÉÙÐÐʱºò£¬Ëü¾ÍÊÇÒ»¸ö¹Ì¶¨µÄÊý¡£
ÕâÀïÐèҪעÒâµÄÊÇ£¬mysqlµÄ·ÃÎÊϱêÊÇ´Ó0¿ªÊ¼µÄ¡£Õ ......
C:\Documents and Settings\Administrator>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on ÐÇÆÚ¶þ 10ÔÂ 13 15:26:31 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Á¬½Óµ½:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partition ......
½ñÌì¼ÌÐøÊÔÑéÊ®·ÖÖÓ¿ÉÒÔ¸Éʲô£¬Ñ¡È¡Á˶ÔOracleË÷ÒýµÄ½éÉÜ£¬½á¹ûÈçÏ£º
´ÓgoogleÉÏÑ°ÕÒ×ÊÁÏ£º1:15Ãë¡£
ÔĶÁ¸ÅÊö²¿·Ö£º3:15Ãë¡£
OracleµÄË÷ÒýÖ÷Òª°üº¬Á½ÀࣺBTreeºÍλͼË÷Òý¡£Ä¬ÈÏÇé¿öÏ´ó¶àʹÓÃBtreeË÷Òý£¬¸ÃË÷Òý¾ÍÊÇͨ³£Ëù¼û ΨһË÷Òý¡¢¾Û´ØË÷ÒýµÈµÈ£¬BtreeÓÃÔÚOLTP£¬¼Ó¿ì²éѯËٶȡ£Î»Í¼Ë÷ÒýÊÇOracleµÄ±È½ÏÒýÈËעĿµÄµØ ......