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

ÔõôÉèÖÃ×Ô¶¯¹ÜÀíORACLE 10GÄÚ´æ

а²×°µÄORACLE 10G£¬ÏÖÔÚÎÞ·¨Í¨¹ýWEB½çÃæµÇ¼EM£¬Ôõôͨ¹ýÆäËü·½Ê½ÉèÖÃ×Ô¶¯¹ÜÀíÄÚ´æ¡£
TOAD
»òÕß
ÃüÁîÐÐ

ÅäÖÃÒ»¸öOEMÂï
SGA
PGA·Ö±ð¶¼ÒªÅäÖá£


1. ÏÖÔÚÎÞ·¨Í¨¹ýWEB½çÃæµÇ¼EM
-- OEM µÄ·þÎñÆô¶¯Ã»ÓУ¿¡¡
emctl start dbconsole

2. ÔÚpfile ÀïÃæÆôÉèÖòÎÊý£º
sga_target ºÍ sga_max_size¡£ Ö»Òª¸øÒ»¸ö×ÜÖµ¾Í¿ÉÒÔÁË£¬ÕâÑùOracle¾Í»áÔÚsga_target µÄ·¶Î§ÄÚ×Ô¼º¹ÜÀíSGA ÄÚ²¿¶ÔÏóµÄ´óС¡£ ±ÈÈçshare pool£¬java poolÖ®ÀàµÄ¡£ 




------------------------------------------------------------------------------ 
Blog£º http://blog.csdn.net/tianlesoftware 
ÍøÉÏ×ÊÔ´£º http://tianlesoftware.download.csdn.net 
Ïà¹ØÊÓÆµ£ºhttp://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx 
DBA1 Ⱥ£º62697716(Âú); DBA2 Ⱥ£º62697977

Ò»°ãÀ´Ëµ
ORACLEʵÀýÄÚ´æ=ÎïÀíÄÚ´æ*80%

¶ÔÓÚOLTPϵͳ:
PGA=ʵÀýÄÚ´æ*20%
SGA=ʵÀýÄÚ´æ*80%

¶ÔÓÚOLAPϵͳ:
PGA=ʵÀýÄÚ´æ*50%
SGA=ʵÀýÄÚ´æ*50%

»ìºÏÐÍϵͳÔÚ¶þÕßÖ®¼ä

È·¶¨ÄÚ´æÈÝÁ¿ºó£¬
¶ÔÓÚPGA£ºÊ¹ÓÃWORKAREA_SIZE_POLICYÉèÖÃΪAUT£¬±íʾPGA×Ô¶¯¹ÜÀí
ÓÃPGA_AGREGGATE_TARGET²ÎÊý·ÖÅäPGA

ÓÃSGA_TARGET²ÎÊý·ÖÅäSGAÄ¿±êÖµ
ÓÃSGA_MAX_SIZE·ÖÅäSGA×î´óÖµ




ÒýÓÃ
1. ÏÖÔÚÎÞ·¨Í¨¹ýWEB½çÃæµÇ¼EM
-- OEM µÄ·þÎñÆô¶¯Ã»ÓУ¿¡¡
emctl start dbconsole

2. ÔÚpfile ÀïÃæÆôÉèÖòÎÊý£º
sga_target ºÍ sga_max_size¡£ Ö»Òª¸øÒ»¸


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

Oracle Êý¾Ýµ¼³öÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

exp user/password@dbname file=c:\table.dmp tables=jbitaku,jbitakum grants=y
È»áá°´»Ø車鍵 說Ã÷:¡¡ user/password@dbname ¡¡·Ö別±íʾÓÃ戶Ãû£¬ÃÜ碼ºÍ·þ務Ãû f ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
    ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ