oracle Êý¾Ý¹ÜÀí

 Ò»£º
ʹÓÃProfile¶ÔÓû§Session»á»°½øÐÐ×ÊÔ´ÏÞÖÆ
--µ«ÊÇÈç¹ûʹÓÃÁËÁ¬½Ó³ØÖ®ÀàµÄ¶«¶«£¬¾Í»á³öЩÎÊÌ⣬±ÈÈçǰ̨Á¬½Ó²»ÉÏÖ®ÀàµÄ
--http://www.eygle.com/archives/2008/10/profile_session_limit.html
sqlplus "/ as sysdba"
SQL> show parameter resource
SQL> alter system set resource_limit=true;
SQL> SELECT * from DBA_PROFILES;
--´´½¨Ò»¸öÔÊÐí3·ÖÖÓIDLEʱ¼äµÄPROFILE£º
SQL> CREATE PROFILE KILLIDLE LIMIT IDLE_TIME 3;
Profile created.
SQL> col limit for a10
SQL> select * from dba_profiles where profile='KILLIDLE';
SQL> alter user eygle profile killidle;
SQL> select username,profile from dba_users where username='EYGLE';
¶þ£º
ÈçºÎ°ÑÊý¾Ýµ¼È벻ͬµÄ±í¿Õ¼ä
--http://www.eygle.com/archives/2005/04/ecineeeeiaeioae.html
»ØÊÕÓû§unlimited tablespaceȨÏÞ
ÕâÑù¾Í¿ÉÒÔµ¼Èëµ½Óû§È±Ê¡±í¿Õ¼ä
SQL> create user bjbbs identified by passwd
  2  default tablespace bjbbs
  3  temporary tablespace temp
  4  /
User created.
SQL> grant connect,resource to bjbbs;
Grant succeeded.
SQL> grant dba to bjbbs;
Grant succeeded.
SQL> revoke unlimited tablespace from bjbbs;
Revoke succeeded.
SQL> alter user bjbbs quota 0 on users;
User altered.
SQL> alter user bjbbs quota unlimited on bjbbs;
User altered.
SQL> exit
ÖØе¼ÈëÊý¾Ý
$ imp bjbbs/passwd file=bj_bbs.dmp fromuser=jive touser=bjbbs grants=n
SQL> select table_name,tablespace_name from user_tables;
Ôò¿ÉÒԲ鿴µ½Êý¾Ýµ¼ÈëÁËbjbbs
Èý£º
OracleÖÐÄ£Äâ¼°ÐÞ¸´Êý¾Ý¿éËð»µ
--http://www.eygle.com/faq/Block_corruption.htm
Ò»¸öÊý¾Ý¿éË𻵺ó²éѯ»á³öÏÖÈçÏ´íÎóÌáʾ
SQL> select count(*) from eygle.t;
select count(*) from eygle.t
*
ERROR λÓÚµÚ 1 ÐÐ:
ORA-01578: ORACLE Êý¾Ý¿éË𻵣¨ÎļþºÅ4£¬¿éºÅ35£©
ORA-01110: Êý¾ÝÎļþ 4: 'E:\ORACLE\ORADATA\EYGLE\BLOCK.DBF'
SQL>
ÓиöÄÚ²¿¹¤¾ßBBEDÒ²¿ÉÒÔÓÃÀ´±à¼­Êý¾Ý¿éµÄÄÚÈÝ
ʹÓÃDBV¼ì²éÊý¾ÝÎļþ
E:\Oracle\oradata\eygle>dbv file=block.dbf blocksize=8192
DBVERIFY: Release 9.2.0.4.0 - Production on ÐÇÆÚÒ» 3ÔÂ 8 20:48