OracleÌåϵ½á¹¹£ºÄÚ´æ½á¹¹ºÍ½ø³Ì½á¹¹
OracleÌåϵ½á¹¹£ºÄÚ´æ½á¹¹ºÍ½ø³Ì½á¹¹
2009-11-24 21:48
¡¡£¨Ò»£©ÄÚ´æ½á¹¹ºÍ½ø³Ì½á¹¹ OracleÊý¾Ý¿âµÄ×ÜÌå½á¹¹ÈçÏÂͼ£º
1£ºOracleʵÀý£¨Instance£©
ÔÚÒ»¸ö·þÎñÆ÷ÖУ¬Ã¿Ò»¸öÔËÐеÄOracleÊý¾Ý¿â¶¼ÓëÒ»¸öÊý¾Ý¿âʵÀýÏàÁªÏµ£¬ÊµÀýÊÇÎÒÃÇ
·ÃÎÊÊý¾Ý¿âµÄÊֶΡ£
ʵÀýÔÚ²Ù×÷ϵͳÖÐÓÃORACLE_SIDÀ´±êʶ£¬ÔÚOracleÖÐÓòÎÊýINSTANCE_NAMEÀ´±êʶ£¬
ËüÃÇÁ½¸öµÄÖµÊÇÏàͬµÄ¡£Êý¾Ý¿âÆô¶¯Ê±£¬ÏµÍ³Ê×ÏÈÔÚ·þÎñÆ÷ÄÚ´æÖзÖÅäϵͳȫ¾ÖÇø£¨SGA£©£¬
¹¹³ÉÁËOracleµÄÄÚ´æ½á¹¹£¬È»ºóÆô¶¯Èô¸É¸ö³£×¤ÄÚ´æµÄ²Ù×÷ϵͳ½ø³Ì£¬¼´×é³ÉÁËOracleµÄ
½ø³Ì½á¹¹£¬ÄÚ´æÇøÓòºÍºǫ́½ø³ÌºÏ³ÆΪһ¸öOracleʵÀý¡£
Êý¾Ý¿âÓëʵÀýÖ®¼äÊÇ1¶Ô1/nµÄ¹Øϵ£¬ÔڷDz¢ÐеÄÊý¾Ý¿âϵͳÖÐÿ¸öOracleÊý¾Ý¿âÓëÒ»¸ö
ʵÀýÏà¶ÔÓ¦£»ÔÚ²¢ÐеÄÊý¾Ý¿âϵͳÖУ¬Ò»¸öÊý¾Ý¿â»á¶ÔÓ¦¶à¸öʵÀý£¬Í¬Ò»Ê±¼äÓû§Ö»ÓëÒ»¸ö
ʵÀýÏàÁªÏµ£¬µ±Ä³Ò»¸öʵÀý³öÏÖ¹ÊÕÏʱ£¬ÆäËûʵÀý×Ô¶¯·þÎñ£¬±£Ö¤Êý¾Ý¿âÕý³£ÔËÐС£ÔÚÈκÎ
Çé¿öÏ£¬Ã¿¸öʵÀý¶¼Ö»¿ÉÒÔ¶ÔÓ¦Ò»¸öÊý¾Ý¿â¡£
2£ºOracle 10g¶¯Ì¬ÄÚ´æ¹ÜÀí
ÄÚ´æÊÇÓ°ÏìÊý¾Ý¿âÐÔÄܵÄÖØÒªÒòËØ£¬Oracle8iʹÓþ²Ì¬ÄÚ´æ¹ÜÀí£¬Oracle 10gʹÓö¯Ì¬
ÄÚ´æ¹ÜÀí¡£Ëùν¾²Ì¬ÄÚ´æ¹ÜÀí£¬¾ÍÊÇÔÚÊý¾Ý¿âϵͳÖУ¬ÎÞÂÛÊÇ·ñÓÐÓû§Á¬½Ó£¬Ò²ÎÞÂÛ²¢·¢ÓÃ
Á¿´óС£¬Ö»ÒªÊý¾Ý¿â·þÎñÔÚÔËÐУ¬¾Í»á·ÖÅä¹Ì¶¨´óСµÄÄڴ棻¶¯Ì¬ÄÚ´æ¹ÜÀíÔÊÐíÔÚÊý¾Ý¿â·þ
ÎñÔËÐÐʱ¶ÔÄÚ´æµÄ´óС½øÐÐÐ޸ģ¬¶ÁÈ¡´óÊý¾Ý¿éʱʹÓôóÄڴ棬СÊý¾Ý¿éʱʹÓÃСÄڴ棬¶Á
È¡±ê×¼ÄÚ´æ¿éʱʹÓñê×¼ÄÚ´æÉèÖá£
°´ÕÕϵͳ¶ÔÄÚ´æʹÓ÷½·¨µÄ²»Í¬£¬OracleÊý¾Ý¿âµÄÄÚ´æ¿ÉÒÔ·ÖΪÒÔϼ¸¸ö²¿·Ö£º
•ÏµÍ³È«¾ÖÇø£ºSGA£¨System Global Area£©
•³ÌÐòÈ«¾ÖÇø£ºPGA£¨Programe Global Area£©
•ÅÅÐò³Ø£º£¨Sort Area£©
•´ó³Ø£º£¨Large Pool£©
•Java³Ø£º£¨Java Pool£©
2-1£ºÏµÍ³È«¾ÖÇøSGA£¨System Global Area£©
SGAÊÇÒ»×éΪϵͳ·ÖÅäµÄ¹²ÏíµÄÄÚ´æ½á¹¹£¬¿ÉÒÔ°üº¬Ò»¸öÊý¾Ý¿âʵÀýµÄÊý¾Ý»ò¿ØÖÆÐÅ
Ï¢¡£Èç¹û¶à¸öÓû§Á¬½Óµ½Í¬Ò»¸öÊý¾Ý¿âʵÀý£¬ÔÚʵÀýµÄSGAÖУ¬Êý¾Ý¿ÉÒÔ±»¶à¸öÓû§¹²Ïí¡£
µ±Êý¾Ý¿âʵÀýÆô¶¯Ê±£¬SGAµÄÄÚ
Ïà¹ØÎĵµ£º
row_number() OVER (PARTITION BY COL1 ORDER BY COL2) ±íʾ¸ù¾ÝCOL1·Ö×飬ÔÚ·Ö×éÄÚ²¿¸ù¾Ý COL2ÅÅÐò£¬¶ø´Ëº¯Êý¼ÆËãµÄÖµ¾Í±íʾÿ×éÄÚ²¿ÅÅÐòºóµÄ˳Ðò±àºÅ£¨×éÄÚÁ¬ÐøµÄΨһµÄ).
ÓërownumµÄÇø±ðÔÚÓÚ£ºÊ¹ÓÃrownum½øÐÐÅÅÐòµÄʱºòÊÇÏȶԽá¹û¼¯¼ÓÈëαÁÐrownumÈ»ºóÔÙ½øÐÐÅÅÐò£¬¶ø´Ëº¯ÊýÔÚ°üº¬ÅÅÐò´Ó¾äºóÊÇÏÈÅÅÐòÔÙ¼ÆËãÐкÅ ......
¿ªÔ´¿çƽ̨±à³ÌÓïÑÔJava¼ÓÉÏ¿ªÔ´Êý¾Ý¿âMySQL£¡×ÔSunÊÕ¹ºMySQL¿ªÊ¼£¬±¾ÒÔΪSun½«´óÕ¹ºêͼ¡£È»SunȴûÓаÑÎÕ»ú»á£¬·´¶øûÓнûµÃס½ðÈÚΣ»úµÄ³å»÷¡£ÂäµÃ¸öÃæÁÙÊÕ¹ºµÄ¾ÖÃæ¡£»òÐíMySQLÖ®¸¸Richard StallmanÒ²¾ø¶ÔûÓÐÏëµ½£¬ÈÃSunÊÕ¹ºMySQL£¬È´ÊÇ°ÑMySQLÍÆÏòÁËÉîÔ¨¡£MySQLµÄºÎÈ¥ºÎ´Ó£¡
Ãæ¶ÔÕâ¸öÎÊÌ⣬MySQLÖ ......
ʹÓÃ
set
pagesize 1000
set
linesize 132
col
TS_NAME form a24
col
PIECES form 9999
col
PCT_FREE form 999.9
col
PCT_USED form 999.9
select
*
from (select Q2.OTHER_TNAME TS_NAME,
PIECES,
& ......
Èí¼þ: VMware Workstation 6.0.2 build-59824
10201_database_linux32.zip
rhel.5.0.server.centoschina.com.dvd.iso
Îĵµ:ORACLE10G¹Ù·½°²×°Îĵµ B19306_01_Oracle10gR2.chm
²Î¿¼:Öܾ¼ÀÏʦµÄORACLE10G OCPÊÓƵ(½²µÄÕæµÄ ......