28.4.3 ¼ì²âOracleÊý¾Ý¿â״̬
28.4.3 ¼ì²âOracleÊý¾Ý¿â״̬
OracleÆô¶¯ºó£¬Îª¼ì²âOracle·þÎñµÄÔËÐÐÊÇ·ñÕý³££¬¿ÉÒÔÖ´ÐÐpsÃüÁî¼ì²éÏà¹ØµÄOracle·þÎñ½ø³Ì£¬Ò²¿ÉÒÔͨ¹ýOracleËùÌṩµÄÃüÁî½øÐмì²é¡£¾ßÌå½éÉÜÈçÏÂËùʾ¡£
£¨1£©Ö´ÐÐpsÃüÁî²é¿´Êý¾Ý¿â½ø³ÌÇé¿ö¡£
ps -ef | grep oracle
£¨2£©ÔÚsqlplusÖÐÖ´ÐÐÃüÁî²é¿´Êý¾Ý¿â״̬¡£
$ export ORACLE_SID=orcl //ÉèÖÃORACLE_SID»·¾³±äÁ¿
$ sqlplus /nolog //Ö´ÐÐsqlplusÃüÁî
SQL*Plus: Release 11.1.0.6.0 - Production on Wed Oct 29 16:27:36 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
SQL> conn sys@orcl as sysdba //Á¬½ÓÊý¾Ý¿â
Enter password:
Connected.
SQL> select open_mode from v$database; //Ö´ÐÐSQL²é¿´Êý¾Ý¿âµÄ´ò¿ª·½Ê½
OPEN_MODE
----------
READ WRITE //“READ WRITE”±íʾÊý¾Ý¿â״̬Õý³£
Èç¹ûÁ¬½ÓÊý¾Ý¿âʱ¿´µ½ÈçÏÂÌáʾ£¬ÄÇô±íʾÊý¾Ý¿â²¢Î´Æô¶¯¡£
SQL> conn sys as sysdba
Enter password:
Connected to an idle instance. //Êý¾Ý¿âδÆô¶¯
£¨3£©Ö´ÐÐlsnrctl statusÃüÁî²é¿´ÍøÂç¼àÌý³ÌÐòµÄ״̬£¬Õý³£Çé¿öÏÂÓ¦¸ÃÄܹ»¿´µ½ÈçÏÂÌáʾÐÅÏ¢¡£
$ lsnrctl status //²é¿´oracle¼àÌý³ÌÐòµÄ״̬
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 29-OCT-2008 16:35:11
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=demoserver)(PORT=
1521)))
STATUS of the LISTEN
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂÆµÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄ ......
28.1 Oracle 11g¼ò½é
¾¹ýÁËÈýÄêµÄ×¼±¸£¬Oracle£¨¼×¹ÇÎÄ£©¹«Ë¾ÓÚ2007Äê7ÔÂ12ÈÕÔÚÈ«Çò·¶Î§ÄÚͬ²½ÍƳöÁËÆä×îа汾µÄÊý¾Ý¿â²úÆ·——Oracle 11g¡£ÐµÄOracleÊý¾Ý¿âÈÔÈ»ÒÔg×÷Ϊ°æ±¾ºó׺£¬ÒÔ´ú±íÕâÊÇÒ»¸ö°üº¬ÁËÍø¸ñ¼ÆËã¼¼ÊõµÄÊý¾Ý¿âÈí¼þ£¨Oracle×Ô10°æ±¾¿ªÊ¼ÒÔg×÷Ϊ°æ±¾ºó׺£¬¶øÔÚÕâ֮ǰÊÇʹÓÃi£¬ÈçOracle 8i¡¢ ......
28.2 OracleÊý¾Ý¿â·þÎñÆ÷µÄ°²×°
Óû§¿ÉÒÔͨ¹ýOracleµÄ¹Ù·½ÍøÕ¾ÏÂÔØµ½×îеÄOracleÊý¾Ý¿â²úÆ·µÄÈí¼þ°²×°°ü£¬ÔÚ°²×°Oracle 11gǰÐèÒª¼ì²éϵͳµÄÈíÓ²¼þ»·¾³ÊÇ·ñ·ûºÏ°²×°ÒªÇó¡£Oracle 11gÌṩͼÐλ¯µÄ°²×°³ÌÐò½çÃæ£¬Óû§¿ÉÒÔͨ¹ýµ¥»÷Êó±êÍê³ÉOracleµÄ°²×°¡£ ......
ÔÎĵØÖ·£ºhttp://fandayrockworld.javaeye.com/blog/540509
»Ø¹Ë£º
Ò»¡¢ ROWIDµÄ¸ÅÄî
¡¡¡¡´æ´¢ÁËrowÔÚÊý¾ÝÎļþÖеľßÌåλÖãº64λ±àÂëµÄÊý¾Ý£¬A-Z, a-z, 0-9, +, ºÍ /£¬
¡¡¡¡rowÔÚÊý¾Ý¿éÖеĴ洢·½Ê½
¡¡¡¡SELECT ROWID, last_name from hr.employees WHERE department_id = 20;
¡¡¡¡±ÈÈ磺OOOOOOFFFBBBBBBRRR
......