OracleµÄ³õʼ»¯²ÎÊýÎļþ
oracleʵÀýÆô¶¯Ê±¶ÁÈ¡pfile²ÎÊýÎļþ£¬ÐÞ¸Äpfile³õʼ»¯²ÎÊýÎļþºó£¬±ØÐëÖØÐÂÆô¶¯ÊµÀý²ÅÄÜÉúЧ¡£
pfile²ÎÊýÎļþÓëspfile²ÎÊýÎļþ¶¼ÊÇÓÃÀ´´æ·Å³õʼ»¯²ÎÊýµÄÎïÀíÎļþ£¬pfileÒÔÎı¾ÎļþµÄÐÎʽ´æ´¢£¬ÓŵãÊÇÒ×Óڲ鿴ÓëÐ޸ģ»spfileÒÔ¶þ½øÖƵÄÐÎʽ´æ´¢£¬ËäÈ»ÄÜʵÏÖÒÔʵÀý²ÎÊýµÄ¶¯Ì¬Ð޸ģ¬µ«²»ÄÜÖ±½ÓÐ޸ģ¬Ö±½ÓÐ޸ĻáËð»µspfile²ÎÊýÎļþ£¬´Ó¶øÒýÆðʵÀýÆô¶¯Ê§°Ü¡£
pfileÎļþµÄĬÈÏÃû³ÆΪ init<SID>.ora
spfileÎļþµÄĬÈÏÃû³ÆΪ spfile<SID>.ora
Á©ÎļþµÄλÖÃÔÚ <$oracle_home>/product/10.2.1/db_1/dbs/
³õʼ»¯²ÎÊýÎļþµÄÓÅÏȼ¶Îª spfile<sid>.ora ----> spfile.ora ----> init<SID>.ora
¿ÉÒÔʹÓà show parameter spfile ²é¿´µ±Ç°¿´ÕýÔÚʹÓõijõʼ»¯²ÎÊýÎļþÊÇÄĸö
spfileÓëpfileµÄ»¥Ïàͬ²½
create pfile from spfile »ò
create pfile = <pfilename> from spfile = <spfilename>
create spfile from pfile »ò
create spfile = <spfilename> from pfile = <pfilename>
Ö»ÄÜÔÚÊý¾Ý¿â¹Ø±ÕµÄÇé¿öϽøÐÐcreate spfile²Ù×÷£¬ÇÒÎļþÃû²»ÄÜÓëÕýÔÚʹÓõÄÊý¾Ý¿âµÄspfileÏàͬ£¬·ñÔò»á´´½¨Ê§°Ü¡£
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
µ¥Ðк¯Êý ·µ»ØÖµÖ»ÓÐÒ»¸ö
·Ö×麯Êý ·µ»ØÖµÊǶàÌõ¼Ç¼
group by
sum
avg   ......
ÓÃ;: <1>Ä£¿é»¯
<Àý×Ó> --¹«Ë¾µÄÔ±¹¤µÄ¹ÜÀí
1.Ôö¼ÓÒ»¸öÔ±¹¤
2.Ô±¹¤ÀëÖ°
Óô洢¹ý³ÌºÍº¯ÊýÀ´ÊµÏÖ
1.Ôö¼ÓÒ»¸öÔ±¹¤
create sequence seq1 start with 7935;
create or replace function insert ......
<1>Âß¼±¸·Ý
²»ÓÃÈ¥¿½±´Êý¾Ý¿âµÄÎïÀíÎļþ
±¸·ÝÂß¼ÉϵĽṹ
ÍⲿµÄ¹¤¾ß:µ¼³öºÍµ¼ÈëµÄ¹¤¾ß
DOSϵÄÃüÁî cmdÏÂÖ´ÐÐ
µ¼³öexp exportËõдÐÎʽ
²é¿´°ïÖú exp help=y
ʹÓòÎÊýÎļþµ¼³ö
exp parfile=c:\ab ......
³õʼ»¯Ïà¹Ø²ÎÊý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µÄÖµ¡ ......