¡¾×ª¡¿oracle´óÊý¾ÝÁ¿µÄµ¼ÈëºÍµ¼³ö
ÔÚoracleÖÐÅúÁ¿Êý¾ÝµÄµ¼³öÊǽèÖúsqlplusµÄspoolÀ´ÊµÏֵġ£ÅúÁ¿Êý¾ÝµÄµ¼ÈëÊÇͨ¹ýsqlloadÀ´ÊµÏֵġ£
´óÁ¿Êý¾ÝµÄµ¼³ö²¿·ÖÈçÏ£º
/***************************
* sql½Å±¾²¿·Ö demo.sql begin
**************************/
/**************************
* @author meconsea
* @date 20050413
* @msn meconsea@hotmail.com
* @Email meconsea@163.com
**************************/
//##--markup html£ºhtml¸ñʽÊä³ö£¬È±Ê¡Îªoff
//##--autocommit£º×Ô¶¯Ìá½»insert¡¢update¡¢delete´øÀ´µÄ¼Ç¼¸Ä±ä£¬È±Ê¡Îªoff
//##--define£ºÊ¶±ðÃüÁîÖеıäÁ¿Ç°×º·û£¬È±Ê¡Îªon£¬Ò²¾ÍÊÇ'&'£¬Åöµ½±äÁ¿Ç°×º·û£¬ºóÃæµÄ×Ö·û´®×÷Ϊ±äÁ¿´¦Àí.
set colsep' '; //##--ÓòÊä³ö·Ö¸ô·û
set echo off; //##--ÏÔʾstartÆô¶¯µÄ½Å±¾ÖеÄÿ¸ösqlÃüÁȱʡΪon
set feedback off; //##--»ØÏÔ±¾´ÎsqlÃüÁî´¦ÀíµÄ¼Ç¼ÌõÊý£¬È±Ê¡Îªon
set heading off; //##--Êä³öÓò±êÌ⣬ȱʡΪon
set pagesize 0; //##--Êä³öÿҳÐÐÊý£¬È±Ê¡Îª24,ΪÁ˱ÜÃâ·ÖÒ³£¬¿ÉÉ趨Ϊ0¡£
set linesize 80; //##--Êä³öÒ»ÐÐ×Ö·û¸öÊý£¬È±Ê¡Îª80
set numwidth 12; &nb
Ïà¹ØÎĵµ£º
Ò»¡¢ÉèÖóõʼ»¯²ÎÊý job_queue_processes
¡¡¡¡sql> alter system set job_queue_processes=n;£¨n>0£©
¡¡¡¡job_queue_processes×î´óֵΪ1000
¡¡¡¡
¡¡¡¡²é¿´job queue ºǫ́½ø³Ì
¡¡¡¡sql>select name,description from v$bgprocess;
¡¡¡¡
¡¡¡¡¶þ£¬dbms_job package Ó÷¨½éÉÜ
¡¡¡¡°üº¬ÒÔÏÂ×Ó¹ý³Ì£º
¡¡¡¡
¡¡ ......
ÔÚJ2EEÓ¦ÓóÌÐò¿ª·¢ÖУ¬Ó¦ÓóÌÐòÓëÊý¾Ý¿âÁ¬½ÓµÄ½¨Á¢ÊÇÎÒÃǾ³£Óöµ½µÄÎÊÌâÖ®Ò»¡£ÔÚÕâÀïÎÒÖ÷Ҫ̸̸ÔÚ±¾µØÓ¦ÓóÌÐòÖÐͨ¹ýOCI·½Ê½¡¢thin·½Ê½ºÍJdbcOdbcÇÅ·½Ê½Á¬½ÓOracleÊý¾Ý¿â£¬ÔÚiPlanet Application Server 6.5ºÍSun Java System Application Server 7ÖжÔOracleÊý¾Ý¿âÁ¬½Ó³ØµÄÅäÖÃÒÔ¼°Ó¦ÓÃÖÐÈçºÎ´ÓÁ¬½Ó³ØÖлñµÃÁ¬½Ó
Ò»¡¢±¾µ ......
ÔÚlinuxϰ²×°oracleÊǼþ·±ËöµÄÊÂÇé¡£¾ßÌåÀ´½²·ÖΪһϼ¸´ó²½£º
1.ÐÞ¸Äϵͳ°æ±¾
vi /etc/redhat-release
×¢Ê͵ôµÚÒ»ÐУ¬Ìí¼ÓÒ»ÐУºredhat-4
2.°²×°Èí¼þ°ü
rpm -Uvh setarch-2*
rpm -Uvh make-3*
rpm -Uvh glibc-2*
rpm -Uvh libaio-0*
rpm -Uvh compat-libstdc++-33-3*
rpm -Uvh compat-gcc-34-3*
rpm -Uvh comp ......
Oracle RAC ͬʱ¾ß±¸HA(High Availiablity) ºÍLB(LoadBalance). ¶øÆä¸ß¿ÉÓÃÐԵĻù´¡¾ÍÊÇFailover(¹ÊÕÏ×ªÒÆ). ËüÖ¸¼¯ÈºÖÐÈκÎÒ»¸ö½ÚµãµÄ¹ÊÕ϶¼²»»áÓ°ÏìÓû§µÄʹÓã¬Á¬½Óµ½¹ÊÕϽڵãµÄÓû§»á±»×Ô¶¯×ªÒƵ½½¡¿µ½Úµã£¬´ÓÓû§¸ÐÊܶøÑÔ£¬ ÊǸоõ²»µ½ÕâÖÖÇл»¡£
Oracle&nbs ......
Ò».ÅäÖñ¾µØNet·þÎñÃûÊǸÉʲôÓõģ¿
Èç¹ûҪͨ¹ýÍøÂç·ÃÎÊOracleÊý¾Ý¿â»òÆäËû·þÎñ£¬¾Í»áÓõ½Net·þÎñÃû¡£Oracle Net
Configuration AssistantÔÊÐíʹÓÃÓɱ¾µØÃüÃû½âÎöµÄÍøÂç·þÎñÃû¡£
¶þ.ÔõÑùÅäÖñ¾µØNet·þÎñÃû£¿
1.´ò¿ª->³ÌÐò/Oracle - OraClient10g_home1/ÅäÖúÍÒÆÖ²¹¤¾ß/Net
Configuration Assistant´ò¿ªNet Co ......