oracle ¼ì²é±»ËøµÄ±í¼°½âËø
ÔÎĵØÖ·£ºhttp://tech.e800.com.cn/articles/2009/710/1247207067745_1.html
´¦Àí·½·¨Ò» £º
¼ì²éÄĸö±í±»Ëø
select sess.sid,sess.serial#,
lo.oracle_username,lo.os_user_name,ao.object_name,lo.locked_mode
from
v$locked_object lo,dba_objects ao,v$session sess
where ao.object_id =
lo.object_id
and lo.session_id = sess.sid;
½âËø
alter
system kill session 'xxx,yyy';
×¢£º'xxx,yyy'ÊÇÉÏÃæ¼ìË÷µÃµ½µÄsess.sid,sess.serial#
´¦Àí·½·¨¶þ £º
ÕÒµ½ÄãҪɱµôµÄÄǸöSESSION,
²¢¼ÇÏÂpaddr
SELECT sid, username, paddr, status from v$session WHERE
username = 'JCUSER' and sid=ÉÏÃæ²é³öÀ´µÄsid;
ÕÒµ½Õâ¸öSESSIONËù¶ÔÓ¦µÄspid
SELECT
ADDR,PID,SPID,USERNAME,SERIAL#,TERMINAL from v$process WHERE addr¡¡=
'ÉÏÃæµÄPADDR';
ɱµôspidËù±êʶµÄÄǸö½ø³Ì
orakill sid spid
Ïà¹ØÎĵµ£º
Óû§µÄ¹ÜÀí
Ò»¡¢ORACLEµÄ°²È«Óò
1¡¢TABLESPACE QUOTAS£º±í¿Õ¼äµÄʹÓö¨¶î
2¡¢DEFAULT TABLESPACE£ºÄ¬Èϱí¿Õ¼ä
3¡¢TEMPORARY TABLESPACE£ºÖ¸¶¨ÁÙʱ±í¿Õ¼ä¡£
4¡¢ACCOUNT LOCKING£ºÓû§Ëø
5¡¢RESOURCE LIMITE£º×ÊÔ´ÏÞÖÆ
6¡¢DIRECT PRIVILEGES£ºÖ±½ÓÊÚȨ
7¡¢ROLE PRIVILEGES£º½ÇÉ«ÊÚȨÏȽ«Ó¦ÓÃÖеÄÓû§»®Îª²»Í¬µÄ½ÇÉ«£¬ ......
¾°£ºÔÚwindows xp serverÉϰ²×°ÁËOracle 9.2.0.1£¬ÏÖʹÓÃp4547809_92080_WINNT.zip½«ÆäÉý¼¶µ½9.2.0.8°æ±¾£¬²¢´òÉÏ×î
Ðµİ²È«²¹¶¡April 2008°æ¡£
1.Éý¼¶oracle£¨administratorÓû§È¨ÏÞ£©£¨ÏÂÔØp4547809_92080_WINNT.zipÍøÖ·£º
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip£©
£¨1£©¡¢Ñ¹Ëõ°üÃû³ÆÎª p45478 ......
1.»ù±¾½á¹¹
CREATE OR REPLACE PROCEDURE ´æ´¢¹ý³ÌÃû×Ö
(
²ÎÊý1 IN NUMBER,
²ÎÊý2 IN NUMBER
) IS
±äÁ¿1 INTEGER :=0;
±äÁ¿2 DATE;
BEGIN
END ´æ´¢¹ý³ÌÃû×Ö
2.SELECT INTO STATEMENT
½«select²éѯµÄ½á¹û´æÈëµ½±äÁ¿ÖУ¬¿ÉÒÔͬʱ½«¶à¸öÁд洢¶à¸ö±äÁ¿Ö ......
public ActionForward backUpAction(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
&n ......