oracle 10gÈçºÎ¹Ø±ÕºÍ´ò¿ª×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢
http://www.51testing.com/?uid-16403-action-viewspace-itemid-101605
Ò»¡¢ORACLE10g×Ô¶¯ÊÕ¼¯Í³¼ÆÐÅÏ¢--×Ô¶¯analyze
´ÓOracle Database 10g¿ªÊ¼£¬OracleÔÚ½¨¿âºó¾ÍĬÈÏ´´½¨ÁËÒ»¸öÃûΪGATHER_STATS_JOBµÄ¶¨Ê±ÈÎÎñ£¬ÓÃÓÚ×Ô¶¯ÊÕ¼¯CBOµÄͳ¼ÆÐÅÏ¢¡£
Õâ¸ö×Ô¶¯ÈÎÎñĬÈÏÇé¿öÏÂÔÚ¹¤×÷ÈÕÍíÉÏ10£º00-6£º00ºÍÖÜÄ©È«Ì쿪Æô¡£µ÷ÓÃDBMS_STATS.GATHER_DATABASE_STATS_JOB_PROCÊÕ¼¯Í³¼ÆÐÅÏ¢¡£¸Ã¹ý³ÌÊ×Ïȼì²âͳ¼ÆÐÅϢȱʧºÍ³Â¾ÉµÄ¶ÔÏó¡£È»ºóÈ·¶¨ÓÅÏȼ¶£¬ÔÙ¿ªÊ¼½øÐÐͳ¼ÆÐÅÏ¢¡£
¿ÉÒÔͨ¹ýÒÔϲéѯÕâ¸öJOBµÄÔËÐÐÇé¿ö£º
select * from Dba_Scheduler_Jobs where JOB_NAME ='GATHER_STATS_JOB'
ÆäʵͬÔÚ10µãÔËÐеÄJob»¹ÓÐÒ»¸öAUTO_SPACE_ADVISOR_JOB£º
SQL> select JOB_NAME,LAST_START_DATE from dba_scheduler_jobs;
JOB_NAME LAST_START_DATE
------------------------------ --------------------------------------
AUTO_SPACE_ADVISOR_JOB 04-DEC-07 10.00.00.692269 PM +08:00
GATHER_STATS_JOB 04-DEC-07 10.00.00.701152 PM +08:00
FGR$AUTOPURGE_JOB
PURGE_LOG 05-DEC-07 03.00.00.169059 AM PRC
È»¶øÕâ¸ö×Ô¶¯»¯¹¦ÄÜÒѾӰÏìÁ˺ܶàϵͳµÄÕý³£ÔËÐУ¬ÍíÉÏ10µã¶ÔÓڴ󲿷ÖÉú²úϵͳҲ²¢·Ç¿ÕÏÐʱ¶Î¡£
¶ø×Ô¶¯·ÖÎö¿ÉÄܵ¼Ö¼«ÎªÑÏÖصÄãÅËø¾ºÕù£¬½ø¶ø¿ÉÄܵ¼ÖÂÊý¾Ý¿âHang»òÕßCrash¡£
ËùÒÔ½¨Òé×îºÃ¹Ø±ÕÕâ¸ö×Ô¶¯Í³¼ÆÐÅÏ¢ÊÕ¼¯¹¦ÄÜ£º
exec DBMS_SCHEDULER.DISABLE('GATHER_STATS_JOB');
×Ô¶¯»¯ÓÀÔ¶¶øÑÏÖصÄÒþ»¼Ïà°éË棡
¹Ø±Õ¼°¿ªÆô×Ô¶¯ËѼ¯¹¦ÄÜ£¬ÓÐÁ½ÖÖ·½·¨£¬·Ö±ðÈçÏ£º
·½·¨Ò»£º
exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB');
exec dbms_scheduler.enable('SYS.GATHER_STATS_JOB');
·½·¨¶þ£º
alter system set "_optimizer_autostats_job"=false scope=spfile;
alter system set "_optimizer_autostats_job"=true scope=spfile;
Pfile¿ÉÒÔÖ±½ÓÐ޸ijõʼ»¯²ÎÊýÎļþ£¬ÖØÐÂÆô¶¯Êý¾Ý¿â¡£
¶þ¡¢AWRĬÈÏͨ¹ýMMON¼°MMNL½ø³ÌÀ´Ã¿Ð¡×Ô¶¯ÔËÐÐÒ»´Î£¬ÎªÁ˽ÚÊ¡¿Õ¼ä£¬²É¼¯µÄÊý¾ÝÔÚ 7 Ììºó×Ô¶¯Çå³ý¡£
¿ìÕÕƵÂʺͱ£Áôʱ¼ä¶¼¿ÉÒÔÓÉÓû§Ð޸ġ£Òª²é¿´µ±Ç°µÄÉèÖã¬Äú¿ÉÒÔʹÓÃÏÂÃæµÄÓï¾ä£º
select s
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¿ª·¢»·¾³ VS2008+NET3.5+ORACLE10G
Êý¾Ý¿âÖбíÉè¼Æ
CREATE TABLE CCOP (
A CHAR(20) NULL,
B CHAR(20) NULL,
C CHAR(20) NULL,
D CHAR(20) NULL
)
EXCELµÄµÚÒ»ÐÐÇ°ËÄÁÐÁÐÃûΪ A B C D
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using Sys ......
1. ϵͳÅäÖùý³Ì
2.1. oracle°²×°Ìõ¼þ¼ì²é
2.1.1. Ó²¼þ¼ì²é
¼ì²éÓ²¼þÇé¿öÊÇ·ñ·ûºÏoracle 10g µÄ°²×°ÒªÇó¡£ÒÔrootµÇ¼ϵͳ£¬ÓÃϱíÃüÁîÊä³öµÄÖµÓ¦´óÓÚ»òµÈÓÚ½¨ÒéÖµ¡£
¼ì²éÏîÄ¿
ÃüÁî ......
OracleÖÐstart with...connect by prior×Ó¾äÓ÷¨
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ ......
http://tianzt.blog.51cto.com/459544/171759
´ËÎÄ´ÓÒÔϼ¸¸ö·½ÃæÀ´ÕûÀí¹ØÓÚ·ÖÇø±íµÄ¸ÅÄî¼°²Ù×÷:
1.±í¿Õ¼ä¼°·ÖÇø±íµÄ¸ÅÄî
2.±í·ÖÇøµÄ¾ßÌå×÷ÓÃ
3.±í·ÖÇøµÄÓÅȱµã
&nbs ......