Oracle ÃÜÂëÎļþѧϰ
½ñÌìÔÚÍøÉÏÂҹ䣬¿´µ½Ò»Æª²»´íµÄÎÄÕ£¬¹ØÓÚORACLEÃÜÂëÎļþµÄ£¬ÀíÂÛѧϰ+¸öÈËʵ¼ù£¬ºÇºÇ£¬¸´ÖƹýÀ´£¬·½±ãÒÔºóѧϰ¡£
===============================================================================
ÀíÂÛ²¿·Ö
Oracle¹ØϵÊý¾Ý¿âϵͳÒÔÆä׿ԽµÄÐÔÄÜ»ñµÃÁ˹㷺µÄÓ¦Ó㬶ø±£Ö¤Êý¾Ý¿â°²È«ÐÔÊÇÊý¾Ý¿â¹ÜÀí¹¤×÷µÄÖØÒªÄÚÈÝ¡£±¾ÎÄÔÚ×ܽáOracleÊý¾Ý¿â°²È«¹ÜÀí¹¤×÷µÄ»ù´¡ÉÏ£¬¶ÔOracleÊý¾Ý¿âϵͳÃÜÂëÎļþµÄ´´½¨¡¢Ê¹ÓúÍά»¤×÷ÁËÏêϸµÄ½éÉÜ£¬¹©´ó¼Ò²Î¿¼¡£
ÔÚOracleÊý¾Ý¿âϵͳÖУ¬Óû§Èç¹ûÒªÒÔÌØȨÓû§Éí·Ý£¨INTERNAL£¯SYSDBA£¯SYSOPER£©µÇ¼OracleÊý¾Ý¿â¿ÉÒÔÓÐÁ½ÖÖÉí·ÝÑéÖ¤µÄ·½·¨£º¼´Ê¹ÓÃÓë²Ù×÷ϵͳ¼¯³ÉµÄÉí·ÝÑéÖ¤»òʹÓÃOracleÊý¾Ý¿âµÄÃÜÂëÎļþ½øÐÐÉí·ÝÑéÖ¤¡£Òò´Ë£¬¹ÜÀíºÃÃÜÂëÎļþ£¬¶ÔÓÚ¿ØÖÆÊÚȨÓû§´ÓÔ¶¶Ë»ò±¾»úµÇ¼OracleÊý¾Ý¿âϵͳ£¬Ö´ÐÐÊý¾Ý¿â¹ÜÀí¹¤×÷£¬¾ßÓÐÖØÒªµÄÒâÒå¡£
OracleÊý¾Ý¿âµÄÃÜÂëÎļþ´æ·ÅÓг¬¼¶Óû§INTERNAL£¯SYSµÄ¿ÚÁî¼°ÆäËûÌØȨÓû§µÄÓû§Ãû£¯¿ÚÁËüÒ»°ã´æ·ÅÔÚORACLE_HOME£ÜDATABASEĿ¼Ï¡£
Ò»¡¢ÃÜÂëÎļþµÄ´´½¨
ÔÚʹÓÃOracle Instance Manager´´½¨Ò»Êý¾Ý¿âʵÀýµÄʱºî£¬ÔÚORACLE_HOME£ÜDATABASEĿ¼Ï»¹×Ô¶¯´´½¨ÁËÒ»¸öÓëÖ®¶ÔÓ¦µÄÃÜÂëÎļþ£¬ÎļþÃûΪPWDSID.ORA£¬ÆäÖÐSID´ú±íÏàÓ¦µÄOracleÊý¾Ý¿âϵͳ±êʶ·û¡£´ËÃÜÂëÎļþÊǽøÐгõʼÊý¾Ý¿â¹ÜÀí¹¤×÷µÄ»ù´£ÔÚ´ËÖ®ºó£¬¹ÜÀíÔ±Ò²¿ÉÒÔ¸ù¾ÝÐèÒª£¬Ê¹Óù¤¾ßORAPWD.EXEÊÖ¹¤´´½¨ÃÜÂëÎļþ£¬ÃüÁî¸ñʽÈçÏ£º
C:£Ü >ORAPWD FILE=£¼FILENAME £¾ PASSWORD =£¼PASSWORD £¾ ENTRIES=< MAX_USERS >
¸÷ÃüÁî²ÎÊýµÄº¬ÒåΪ£º
FILENAME£ºÃÜÂëÎļþÃû£»
PASSWORD£ºÉèÖÃINTERNAL£¯SYSÕʺŵĿÚÁ
MAX_USERS£ºÃÜÂëÎļþÖпÉÒÔ´æ·ÅµÄ×î´óÓû§Êý£¬¶ÔÓ¦ÓÚÔÊÐíÒÔSYSDBA£¯SYSOPERȨÏ޵ǼÊý¾Ý¿âµÄ×î´óÓû§Êý¡£ÓÉÓÚÔÚÒÔºóµÄά»¤ÖУ¬ÈôÓû§Êý³¬³öÁË´ËÏÞÖÆ£¬ÔòÐèÒªÖؽ¨ÃÜÂëÎļþ£¬ËùÒԴ˲ÎÊý¿ÉÒÔ¸ù¾ÝÐèÒªÉèÖõôóһЩ¡£
ÓÐÁËÃÜÂëÎļþÖ®ºó£¬ÐèÒªÉèÖóõʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILEÀ´¿ØÖÆÃÜÂëÎļþµÄʹÓÃ״̬¡£
¶þ¡¢ÉèÖóõʼ»¯²ÎÊýREMOTE_LOGIN_PASSWORDFILE
ÔÚOracleÊý¾Ý¿âʵÀýµÄ³õʼ»¯²ÎÊýÎļþÖУ¬´Ë²ÎÊý¿ØÖÆ×ÅÃÜÂëÎļþµÄʹÓü°Æä״̬¡£Ëü¿ÉÒÔÓÐÒÔϼ¸¸öÑ¡Ï
NONE£ºÖ¸Ê¾Oracleϵͳ²»Ê¹ÓÃÃÜÂëÎļþ£¬ÌØȨÓû§µÄµÇ¼ͨ¹ý²Ù×÷ϵͳ½øÐÐÉí·ÝÑéÖ¤£»
EXCLUSIVE£ºÖ¸Ê¾Ö»ÓÐÒ»¸öÊý¾Ý¿âʵÀý¿ÉÒÔʹÓôËÃÜÂëÎļþ¡£Ö»ÓÐÔÚ´ËÉèÖÃϵÄÃÜÂëÎļþ¿ÉÒÔ°üº¬ÓгýINTERNAL£¯SYSÒÔÍâµÄÓû§ÐÅÏ¢£¬¼´ÔÊÐí½«ÏµÍ³È¨ÏÞSYSOPER£¯SYSDBAÊ
Ïà¹ØÎĵµ£º
Oracle×Ô8iÆð¾ÍÈ«ÃæÖ§³Öjava£¬µ«¸÷¸ö°æ±¾µÄoracleÖÐĬÈÏjdk°æ±¾¾ù²»Ïàͬ£¬oracle8iÖÐΪ jdk1.2,oracle9iÖÐΪjdk1.3,oracle10gÖÐΪjdk1.4~~ÖÁ±ÊÕßÐÐΪ֮¼Ê£¬µ±Ç°µÄ×îа汾Ϊjdk1.5 update 11.
Òò±ÊÕßjava¿ª·¢³öÉí£¬ÔÚ×öoracle¿ª·¢Öо³£»áÓÃjavaÀ´À©Õ¹ oracle¹¦ÄÜ£¬µ«ÊÇÓÉÓÚoracle×Ô´øjdk°æ±¾¹ýµÍ£¬¿ÉÄÜ»áÔì³ÉһЩ ......
±¾ÊÓͼ°üÀ¨Shared poolÖÐSQLÓï¾äµÄÍêÕûÎı¾£¬Ò»ÌõSQLÓï¾ä¿ÉÄֳܷɶà¸ö¿é±»±£´æÓÚ¶à¸ö¼Ç¼ÄÚ¡£
V$SQLTEXTÖеij£ÓÃÁÐ
HASH_VALUE£ºSQLÓï¾äµÄHashÖµ
ADDRESS£ºsqlÓï¾äÔÚSGAÖеĵØÖ·
SQL_TEXT£ºSQLÎı¾¡£
PIECE£ºSQLÓï¾ä¿éµÄÐòºÅ
V$SQLTEXTÖеÄÁ¬½ÓÁÐ
Column View   ......
ÓÃdateÐÍ×ֶνøÐÐÊý¾Ý¼ìË÷ʱÐèҪעÒ⣺Êý¾Ý¸ñʽ»¯£¡
´ËÊý¾Ý¸ñʽ»¯²»Í¬ÓÚÓÃSimpleDateFormat("yyyy-MM-dd")¶ÔÏó½øÐиñʽ»¯£¬¶øÊÇÓÃOracleµÄÄÚÖú¯Êýto_date()
»ò±êʶ·ûdateÀ´¸ñʽ»¯¡£
ÀýÈ磺
Óиö×Ö¶ÎÊÇdateÊý¾Ý£¬ÎÒÏë²éѯijijÄê¶ÈµÄÊý¾Ý¡£
´íÎóд·¨£ºs ......
--»ñÈ¡Á½Ê±¼äµÄÏà²îºÀÃëÊý
select ceil((To_date('2008-05-02 00:00:00' , 'yyyy-mm-dd hh24-mi-ss') - To_date('2008-04-30 23:59:59' , 'yyyy-mm-dd hh24-mi-ss')) * 24 * 60 * 60 * 1000) Ïà²îºÀÃëÊý from DUAL;
/*
Ïà²îºÀÃëÊý
----------
86401000
1 row selected
*/
--»ñÈ¡Á½Ê±¼äµÄÏà²îÃëÊý
select ce ......
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
¡¡¡¡1¡¢Óû§£º
¡¡¡¡¡¡select username from dba_users;
¡¡¡¡¸Ä¿ÚÁî
¡¡¡¡¡¡alter user spgroup identified by spgtest;
¡¡¡¡2¡¢±í¿Õ¼ä£º
¡¡¡¡¡¡select * from dba_data_files;
¡¡¡¡¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡¡¡¡¡select tablespace_name,sum(bytes), sum(b ......