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

OracleÓû§¹ÜÀí³£ÓòÙ×÷

 
ÒÔÏÂÁгöµÄÊÇOracle
Óû§¹ÜÀí¹ý³ÌÖг£ÓõÄһЩָÁÒÔ¹©´ó¼Ò²Î¿¼¡£
Oracle
Óû§¹ÜÀíÖ®Ò»¡¢´´½¨profile
Îļþ¡£

1.          
SQL>Create
profile
ÎļþÃû limit
2.          
   FAILED_LOGIN_ATTEMPTS
£ºÖ¸¶¨Ëø¶¨Óû§µÄµÇ¼ʧ°Ü´ÎÊý  
3.          
   PASSWORD_LOCK_TIME
£ºÖ¸¶¨Óû§±»Ëø¶¨ÌìÊý  
4.          
   PASSWORD_LIFE_TIME
£ºÖ¸¶¨¿ÚÁî¿ÉÓÃÌìÊý  
5.          
   PASSWORD_REUSE_TIME
£ºÖ¸¶¨Ôڶ೤ʱ¼äÄÚ¿ÚÁî²»ÄÜÖØÓà  
6.          
   PASSWORD_REUSE_MAX
£ºÖ¸¶¨ÔÚÖØÓÿÚÁîÇ°¿ÚÁîÐèÒª¸Ä±äµÄ´ÎÊý   
7.          
   SESSIONS_PER_USER
£ºÏÞÖÆÓû§²¢·¢»á»°¸öÊý  
8.          
   CPU_PER_SESSION
£ºÏÞÖƻỰËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩  
9.          
   CPU_PER_CALL
£ºÏÞÖÆÿ´Îµ÷ÓÃËùÕ¼ÓõÄCPU
ʱ¼ä£¨°Ù·ÖÖ®Ò»Ã룩  
10.      
   CONNECT_TIME
£ºÏÞÖƻỰµÄ×ܼÆÁ¬½Óʱ¼ä£¨·ÖÖÓ£©  
11.      
   IDLE_TIME
£ºÏÞÖƻỰµÄ¿ÕÏÐʱ¼ä£¨·ÖÖÓ£©);  
Oracle
Óû§¹ÜÀíÖ®¶þ¡¢´´½¨Óû§£¨°üÀ¨´´½¨½ÇÉ«£©:

1.          
SQL>Create
user
  
Óû§Ãû  
2.          
   IDENTIFIED  BY
  
¿ÚÁî  
3.          
   Default
  tablespace &nb


Ïà¹ØÎĵµ£º

oracle Ëø£¬½âËø

http://hi.baidu.com/fyears/blog/item/5ef68ac3feb9a45db219a836.html
select object_id,session_id,locked_mode from v$locked_object;
¡¡¡¡select t2.username,t2.sid,t2.serial#,t2.logon_time
¡¡¡¡from v$locked_object t1,v$session t2
¡¡¡¡where t1.session_id=t2.sid order by t2.logon_time;
alter system ki ......

oracleͨ¹ýÊý¾Ý×Öµä²éѯ¿´Ö´Ðмƻ®

SELECT a.ADDRESS,
       sql_text,
       executions,
       rows_processed,
       cpu_time,
       a.DISK_READS,
      ......

Oracle ORA_ROWSCN

½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ­°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØʽéÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......

PHPÁ¬½ÓOracle²¢·ÖÒ³·ÃÎÊ

ʹÓõÄÊÇADODB¿â,ÐèÒªÓÐOCI8¿â.
<?php

//require("adodb5/adodb-exceptions.inc.php");
require("adodb5/adodb.inc.php");
$conn = NewADOConnection("oci8");
$conn->Connect($url, $user, $password, $service_name);
$rs;
try {
$rs = $conn->Execu ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ