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

¹ØÓÚORACLE¸¨ÖúÓï¾ä

--JOBS
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT(job => X,
what => 'sp_test();',
next_date => to_date('28-04-2009 11:58:00',
'dd/mm/yyyy hh24:mi:ss'),
interval => 'SYSDATE+1');
END;
/
commit;
select to_char(sysdate-90,'yyyymmdd') from dual;  --Ñ¡ÔñÈÕÆÚ
select * from dba_jobs;--²é¿´×÷Òµ
CREATE USER SLCARD  PROFILE DEFAULT
    IDENTIFIED BY slcard DEFAULT TABLESPACE USERS
    ACCOUNT UNLOCK;
GRANT CONNECT TO SLCARD;
GRANT DBA TO SLCARD;
GRANT RESOURCE TO SLCARD;
--REVOKE DBA,CONNECT,RESOURCE from SLCARD;
1.²é¿´ËùÓÐÓû§£º
  select * from dba_users;
  select * from all_users;
  select * from user_users;
2.²é¿´Óû§»ò½ÇɫϵͳȨÏÞ£º
  select * from dba_sys_privs;
  select * from user_sys_privs;
3.²é¿´Óû§¶ÔÏóȨÏÞ£º
  select * from dba_tab_privs;
  select * from all_tab_privs;
  select * from user_tab_privs;
4.²é¿´ËùÓнÇÉ«£º
  select * from dba_roles;
5.²é¿´Óû§»ò½ÇÉ«ËùÓµÓеĽÇÉ«£º
  select * from dba_role_privs;
  select * from user_role_privs;
6.²é¿´Á¬½ÓÊý
select username,count(username) from v$session where username is not null group by username
-- È·¶¨½ÇÉ«µÄȨÏÞ
select * from role_tab_privs ;  Êý¾Ý×ÖµäÊÓͼ°üº¬ÁËÊÚÓè½ÇÉ«µÄ¶ÔÏóȨÏÞ
select * from role_role_privs ;             °üº¬ÁËÊÚÓèÁíÒ»½ÇÉ«µÄ½ÇÉ«
select * from role_sys_privs ;              °üº¬ÁËÊÚÓè½ÇÉ«µÄϵͳȨÏÞ
-- È·¶¨Óû§ÕÊ»§ËùÊÚÓèµÄȨÏÞ
select * from DBA_tab_privs ;   Ö±½ÓÊÚÓèÓû§ÕÊ»§µÄ¶ÔÏóȨÏÞ
select * from DBA_role_privs ;  ÊÚÓèÓû§ÕÊ»§µÄ½ÇÉ«
select * from DBA_sys_privs ;   ÊÚÓèÓû§ÕÊ»§µÄϵͳȨÏÞ
²é¿´µ±Ç°Óû§È¨ÏÞ:
select * from session_privs;¡¢
--¸ü¸ÄÁÙʱ±í¿Õ¼ä
ALTER database TEMPFILE 'I:\oracle\oradata\sldev\temp02.dbf' reSIZE 300M;
ALTER TABLESPACE TEMP ADD TEMPFILE 'I:\oracle\oradata\sldev\temp02.db


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

ORACLEÆô¶¯

 
ORACLEÖ÷ÒªÓÉÁ½²¿·Ö×é³É£ºInstanceºÍDatabase¡£InstanceÊÇÖ¸Ò»×éºǫ́½ø³Ì/Ï̺߳ÍÒ»¿é¹²ÏíÄÚ´æÇøÓò£¬¶øDatabaseÊÇÖ¸´æ´¢ÔÚ´ÅÅÌÉϵÄÒ»×éÎïÀíÎļþ¡£
ORACLEÊý¾Ý¿âµÄÆô¶¯Ö÷Òª·Ö3¸ö²½Ö裺
1¡¢Æô¶¯µ½nomount״̬£»
2¡¢Æô¶¯µ½mount״̬£»
3¡¢Æô¶¯µ½open״̬¡£
ÏÂÃæ·ÖÎöÒ»ÏÂÆô¶¯µÄ¸÷¸ö²½Ö裺
Ò»¡¢Æô¶¯µ½nomount״̬
......

oracleÒþ²Ø²ÎÊý²éѯ

ËäÈ»ÍøÉÏÓкܶ࣬µ«»¹ÊÇÔÚÕâÀï¼ÇÏ·½±ã²éÕÒ£º
SELECT i.ksppinm NAME, i.ksppity TYPE, v.ksppstvl VALUE, v.ksppstdf isdefault
  from x$ksppi i, x$ksppcv v
 WHERE i.indx = v.indx
   AND i.ksppinm LIKE '\_%&par%' ESCAPE '\';
......

ѧϰ¡¶Oracle 9i10g±à³ÌÒÕÊõ¡·µÄ±Ê¼Ç (Æß) Îļþ

 ÕâÒ»ÕÂÖУ¬ÎÒÃǽ«·ÖÎö¹¹³ÉÊý¾Ý¿âºÍʵÀýµÄ8 ÖÖÎļþÀàÐÍ¡£
ÓëʵÀýÏà¹ØµÄÎļþÖ»ÓУº
²ÎÊýÎļþ£¨parameter file£©£ºÕâЩÎļþ¸æËßOracle ʵÀýÔÚÄÄÀï¿ÉÒÔÕÒµ½¿ØÖÆÎļþ£¬²¢ÇÒÖ¸
¶¨Ä³Ð©³õʼ»¯²ÎÊý£¬ÕâЩ²ÎÊý¶¨ÒåÁËijÖÖÄÚ´æ½á¹¹Óжà´óµÈÉèÖá£ÎÒÃÇ»¹»á½éÉÜ´æ´¢Êý¾Ý¿â²Î
ÊýÎļþµÄÁ½ÖÖÑ¡Ôñ¡£
¸ú×ÙÎļþ£¨trace file£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ