ORACLEÊý¾Ý×Öµä
²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
SQL>select username,default_tablespace from user_users;
²é¿´µ±Ç°Óû§µÄ½ÇÉ«
SQL>select * from user_role_privs;
²é¿´µ±Ç°Óû§µÄϵͳȨÏÞºÍ±í¼¶È¨ÏÞ
SQL>select * from user_sys_privs;
SQL>select * from user_tab_privs;
²é¿´Óû§ÏÂËùÓеıí
SQL>select * from user_tables;
ÏÔʾÓû§ÐÅÏ¢(ËùÊô±í¿Õ¼ä)
select default_tablespace,temporary_tablespace
from dba_users where username='GAME';
1¡¢Óû§
²é¿´µ±Ç°Óû§µÄȱʡ±í¿Õ¼ä
SQL>select username,default_tablespace from user_users;
²é¿´µ±Ç°Óû§µÄ½ÇÉ«
SQL>select * from user_role_privs;
²é¿´µ±Ç°Óû§µÄϵͳȨÏÞºÍ±í¼¶È¨ÏÞ
SQL>select * from user_sys_privs;
SQL>select * from user_tab_privs;
ÏÔʾµ±Ç°»á»°Ëù¾ßÓеÄȨÏÞ
SQL>select * from session_privs;
ÏÔʾָ¶¨Óû§Ëù¾ßÓеÄϵͳȨÏÞ
SQL>select * from dba_sys_privs where grantee='GAME';
ÏÔÊ¾ÌØÈ¨Óû§
select * from v$pwfile_users;
ÏÔʾÓû§ÐÅÏ¢(ËùÊô±í¿Õ¼ä)
&nb
Ïà¹ØÎĵµ£º
http://www.builder.com.cn/2007/1027/583048.shtml
ÔÚphp3.0ÒÔÉϰ汾ÖУ¬phpÄÚÖÃÁ˼¸ºõĿǰËùÓеÄÊý¾Ý¿â´¦Àíº¯Êý£¬°üÀ¨Oracle;ÔÚ±¾ÎÄÖÐÎÒÃÇͨ¹ýÒ»¸öʵÀýÀ´½éÉÜÁËÈçºÎʹÓÃÕâЩº¯ÊýÀ´²Ù×÷OracleÊý¾Ý¿â¡£
PHPÌṩÁË2´óÀàAPI(Ó¦ÓóÌÐò½Ó¿Ú)À´²Ù×÷OracleÊý¾Ý¿â¡£Ò»¸öÊDZê×¼µÄOracle´¦Àíº¯Êý(ORA) ÁíÒ»¸öÊÇOracle 8µ÷Óýӿں¯ ......
½ñÌì×ö¸ß¼¶¸´ÖÆÊµÑ飬ִÐе½Ìí¼Ómaster siteʱÓöµ½´ËÎÊÌ⣬ÉÏÍøËÑÁËËÑ£¬ÓÐÈçϼ¸ÖÖÒâ¼û£º
1.ÊÚȨ¹ý³Ì²»¶Ô——Çë×Ðϸ°´ÕÕÎĵµÉϵÄ˵Ã÷½øÐС£
2.°æ±¾ÎÊÌâ——¿É²é¿´v$optionÊÓͼÖÐÏà¹Ø²ÎÊýÊÇ·ñΪtrue¡£
3.°æ±¾ÎÊÌâ——ÓиöתÌùmetalinkµÄÎÄÕÂÉÏ˵ֻÓÐoracleÆóÒµ°æÖ§³Ö¸ß¼¶¸´ÖÆ¡£
¶¼Ã»Óн⾠......
ORACLEÊý¾Ý¿âÆô¶¯Ê±·ÖÅäÒ»´ó¿é·Ç³£´óµÄÄÚ´æÇøÓò¡£ORACLEÔËÐйý³ÌÖÐËùÓеIJÙ×÷¶¼ÔÚÕâÀï½øÐС£
ORACLEÄÚ´æ=SGA+PGA¡£
SGA=Êý¾Ý¸ßËÙ»º³åÇø+ÈÕÖ¾»º³åÇø+¹²Ïí³Ø+´ó³Ø+Java³Ø¡£
Êý¾Ý¸ßËÙ»º³åÇø£ºÊý¾Ý¸ßËÙ»º³åÇøÊÇ×î½ü´ÓÊý¾ÝÎļþÖмìË÷³öÀ´µÄÊý¾Ý£¬»º´æÆðÀ´¹©ËùÓÐÓû§¹²Ïí¡£
ÈÕÖ¾»º³åÇø£º»º´æÓû§¶ÔÊý¾Ý¿âÖ´Ðеĸ÷Àà²Ù×÷µÄÖØ×ö ......
ÔÎĵØÖ·£ºhttp://www.cnblogs.com/wangxiaohuo/archive/2008/04/20/1162631.html
±¾ÎĵµÖ÷Òª´ÓoracleÓësql serverÓï·¨ÉϽøÐвîÒìÐԱȽϣ¬ÖîÈçÁ½ÕßÔÚ¹ÜÀí£¬ÐÔÄÜ£¬ÓÅ»¯µÈ·½ÃæµÄ²îÒì²»×÷±È½Ï¡£
¡ñ¸ÅÄîÉÏÇø±ð
1.Oracle ÊÇÒ»ÖÖ¶ÔÏó¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨ORDBMS),¶øSql server Ö»ÊǹØÏµÐÍÊý¾Ý¿â¹Ü
&nbs ......
ͨ¹ýJDBC£¬ÎÒÃÇ¿ÉÒÔÏòoracle²åÈë´ó¶ÔÏó£¬ÈçͼƬ£¬ÒôƵ£¬³¤Îı¾µÈ£¬Æä²åÈë·½·¨Óкܶ࣬ÕâÀïÑÝʾһÏÂͨ¹ýÁ÷¸üиüеÄÐÎʽ²åÈëCLOB´ó¶ÔÏó¡£
ÕâÊÇÒ»¸ö´æ´¢Îı¾µÄÀý×Ó£¬½âÊÍÎÒ»áÔÚ³ÌÐòÖÐÒÔ×¢Ê͵ÄÐÎʽд³ö
/**
* ½«Éú³ÉµÄ±íÑù´æ´¢µ½Êý¾Ý¿â
*
* @param htmlParam
* @return
*/
  ......