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

ÔËÐÐÁËOracleµÄLinux·þÎñÆ÷¸ü¸ÄÖ÷»úÃû

ÔËÐÐÁËOracleµÄLinux·þÎñÆ÷¸ü¸ÄÖ÷»úÃû
¼ÙÈçÒª°ÑÖ÷»úÃû¸ÄΪoratest¡£
$±íʾoracleÓû§²Ù×÷£»
#±íʾrootÓû§²Ù×÷¡£
DB£ºoracle10.2
OS£ºRHEL4.5
µÚÒ»²½£¬¹Ø±ÕÊý¾Ý¿âºÍ¼àÌý£¬dbconsole£º
$ dbshut
$ lsnrctl stop
µÚ¶þ²¿£º
# hostname oratest
µÚÈý²½£º
# vi /etc/sysconfig/network
¸ü¸Ähostname²ÎÊý¡£
µÚËIJ½£º
# vi /etc/hosts
¸ü¸ÄÖ÷»úÃû¡£
µÚÎå²½£¬ÐÞ¸Ätnsnames.oraºÍlistener.ora£º
ÔÚ$TNS_ADMIN»ò$ORACLE_HOME/network/adminĿ¼Ï£¬ÐÞ¸Ähost²ÎÊý¡£
µÚÁù²½£¬ÖØÆô·þÎñÆ÷£º
# reboot
µÚÆß²½£¬Æô¶¯Êý¾Ý¿âºÍ¼àÌý£¬dbconsole£º
$ dbstart
$ lsnrctl start
ÍêÊ¡£


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì£¨ËÄ£© L2CAP²ã±à³Ì

£¨L2CAPЭÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPЭÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼­Á¬½Ó¿ØÖƺÍÊÊÅäЭÒé (L2CAP) ΪÉϲãЭÒéÌṩÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àЭÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãЭÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......

Oracle9ÖÐXML SQL Utility¼¼ÊõÖ¸µ¼(java)

¡ö     ¿ª·¢Ç°ÒªÇóÅäÖÃ
¡ö     Select XML¸ñʽÊý¾Ý
¡ö     Insert XML¸ñʽÊý¾Ý
¡ö     Updata XML¸ñʽÊý¾Ý
¡ö     Delete XML¸ñʽÊý¾Ý
¿ª·¢Ç°ÒªÇóÅäÖÃ
±ØÐë°²×°Oracle¿Í»§¶Ë
°ÑClasspathÖ¸Ïò
classes111.zip ......

oracle´¥·¢redoдµÄËĸöÌõ¼þ

µ±LGWR´¦ÓÚ¿ÕÏÐ״̬ʱ£¬ËüÒÀÀµÓÚrdbms rpc messageµÈ´ýʼþ£¬´¦ÓÚÐÝÃß״̬£¬Ö±µ½ÈýÃëʱ¼äµ½£¬Èç¹ûÕâ¸öʱºòLGWR·¢ÏÖÓÐRedoÐÅÏ¢ÐèҪд³öµÄ»°£¬ÄÇôLGWR½«Ö´ÐÐдµÄ²Ù×÷£¬log file parallel writeµÈ´ýʼþ½«»á³öÏÖ¡£
¡¡¡¡×ܽáÒ»ÏÂRedoдµÄ´¥·¢Ìõ¼þ£º
¡¡¡¡1£¬Ã¿ÈýÃëÖÓ³¬Ê±(timeout)£º
µ±LGWR´¦ÓÚ¿ÕÏÐ״̬ʱ£¬ËüÒÀÀµÓÚrdbms r ......

oracleÓαê

SET NEWPAGE NONE HEADING OFF SPACE 0 PAGESIZE 0 TRIMOUT ON TRIMSPOOL ON LINESIZE 2500 colsep | feedback off termout off pages 0
set colsep |
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
set feedback on
declare cursor cur_no is
select  beginno,endno  from hm where 1=1;
b ......

ORACLEÎﻯÊÓͼ Query RewriteµÄÒ»°ãÀí½âÖ®Èý


  ÔÚQuery RewriteÖдó¼Ò¿´µ½Õâ¸ö¼¼ÊõÀë²»¿ªÒ»Ñù¶«Î÷, ʵÌ廯ÊÓͼ, ¼ò³ÆMVIEW. ÕâÊÇOracleÔÚ8iÖÐÊ×ÏÈÍƳöµÄ¼¼Êõ, MVIEW³ýÁËÔÚQuery RewriteÖÐʹÓÃÍâ, »¹ÔÚMaster - Slave¸´ÖÆÖÐÓкÜÖØÒªµÄ×÷ÓÃ, ÔÚÕâ¶ùÎÒÃÇÖ÷Òª¹ØÐÄQuery RewriteÏà¹ØµÄµØ·½, OracleÔÚQuery Rewrite·½ÃæÔ½À´Ô½Ç¿ÁË, ÔÚOracle 8iÖлù±¾ÉÏÊÇText Ma ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ