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
Ïà¹ØÎĵµ£º
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 ......
SELECT a.ADDRESS,
sql_text,
executions,
rows_processed,
cpu_time,
a.DISK_READS,
  ......
½ñÌì¿´µ½Ò»Æª¹ØÓÚORA_ROWSCNµÄÎÄÕ£¬ËäÈ»¼ò¶Ì£¬Ã»ÓÐʲôʵÀý£¬µ«ÊÇÒѾ°ÑORA_ROWSCN´ó¸ÅÊÇÔõô»ØʽéÉÜÇå³þÁË¡£¼Ç¼һÏ¡£
=================================================================================
ĬÈϵÄÇé¿öÏ£¬Ã¿¸ö¿éÖÐËùÓеļǼµÄORA_ROWSCN¶¼ÊÇÏàͬµÄ£¬µ±¿éÖÐÈÎÒâÒ»Ìõ¼Ç¼·¢Éú¸Ä±äµÄÇé¿öÏ£¬¿éÖÐËùÓм ......
ʹÓõÄÊÇ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 ......