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

oracleѹÁ¦²âÊÔÖ®orabm

Êý¾Ý¿âѹÁ¦²âÊÔ
Ò»¡¢ÓÃorabm²âÊÔÊý¾Ý¿âCPU
Orabmͨ¹ýÔÚÓû§Ö¸¶¨µÄ²¢·¢ÏÂÔËÐÐÖ¸¶¨ÊýÁ¿µÄÊÂÎñÀ´²âÊÔϵͳÐÔÄÜ.ËüÖ÷Òª²âÊÔÊý¾Ý¿â·þÎñÆ÷µÄCPUÐÔÄܺÍÄÚ´æ¡£
orabmʵ¼ÊÉÏÊÇÒ»¶ÑsqlµÄ¼¯ºÏ¡£
orabm¿ÉÒÔÓÃÔÚlinux/windows/solarisÏÂʹÓá£
orabm²»Ò»¶¨ÐèÒªÔËÐÐÔÚÊý¾Ý¿âËùÔÚ·þÎñÆ÷ÉÏ£¬Ëü¿ÉÒÔÔËÐÐÔÚÈκΰ²×°ÁË9i¿Í»§¶ËµÄÖÕ¶ËÉÏ¡£Äã¿ÉÒÔÓÿͻ§¶ËÁ¬½Óµ½Ô¶³ÌÊý¾Ý¿âÀ´²âÊÔÔ¶³ÌÊý¾Ý¿âµÄÐÔÄÜ×´¿ö¡£
Òò
ΪorabmÖ÷Òª²âÊÔµÄÊÇCPUºÍÄڴ棬ËùÒÔÓ¦¸Ã¾¡Á¿±ÜÃâÆäËûÒòËØÓ°Ïì²âÊÔ£¬¹ÊʹÓÃorabmʱ£¬ÎªÁ˸üºÃµÄ²âÊÔCPUºÍÄÚ´æµÄÐÔÄÜ£¬×îºÃ°Ñ
db_cache_sizeÉè³É´óÓÚ200M£¬ÕâÑù£¬ËùÓеÄÊý¾Ý¶¼¿ÉÒÔ·ÅÔÚÄÚ´æÖУ¬²»»áÒòΪÎïÀíI/O¶øʹµÃ²âÊÔ²»×¼È·¡£Ê¹ÓÃorabmµÄÒ»¸ö²½Öè¾ÍÊÇ°Ñ
ËùÓеıíºÍË÷Òý¶¼·Åµ½data bufferÖС£
1¡¢ÏÂÔØÈí¼þ
orabmÊDzâÊÔCPUµÃ
http://www.linxcel.co.uk/orabm/orabm.tar
2¡¢°²×°
°²×°Ö÷Òª·Ö7¸ö²½Ö裬·Ö±ð¶ÔÓ¦6¸ösql½Å±¾ºÍÒ»¸öµ¼ÈëÊý¾ÝµÄС¹¤¾ß¡£ÈçÏÂËùÓнű¾³ýµÚÒ»¸ö±ØÐëÓÃÓµÓÐdbaȨÏÞµÄÓû§Ö´ÐÐÍ⣬ÆäËûµÄ¶¼¿ÉÒÔÓÃн¨orabmÓû§Ö´ÐС£ÎªÁ˱ÜÃâÂé·³£¬×îºÃ¶¼ÓÃsystem»òÕßsysÔËÐÐ
1) create the ORABM user (assumes TOOLS tablespace, TEMP temporary tablespace)
µÚ
Ò»²½ÊÇ´´½¨orabmÓû§£¬²¢×÷ÏàÓ¦ÊÚȨ¡£×¢Ò⣬ĬÈÏÇé¿öÏ£¬orabmÓû§µÄĬÈϱí¿Õ¼äÊÇtools£¬ÁÙʱ±í¿Õ¼äÊÇtemp¡£µ¼ÈëÒ»¸ö
WarehousesµÄÊý¾ÝÁ¿´ó¸ÅÊÇ100M£¬ËùÒÔ£¬ÄãÓ¦¸Ã±£Ö¤tools±í¿Õ¼ä´óÓÚ150m£¬»òÕßн¨Ò»¸ö±í¿Õ¼ä£¬È»ºóÐÞ¸Ä
orabm_user.sqlÀïµÄÏà¹ØÐÅÏ¢¡£
sqlplus system/pwd @orabm_user
Ô¶³ÌÊý¾Ý¿âʹÓãº
sqlplus
system/pwd@tnsname
@orabm_user
2) create the tables
ÕâÒ»²½Ö÷Òª´´½¨orabm²âÊÔÐèÒªµÄ±í¡£
sqlplus system/pwd @orabm_tab
Ô¶³ÌÊý¾Ý¿âʹÓãº
sqlplus
system/pwd@tnsname
@orabm_tag
3) Load the data
µ¼Èë²âÊÔËùÐèµÄÊý¾Ý£¨orabmloadÔÚOSµÄ¶ÔÓ¦°æ±¾µÄbinĿ¼Ï£©
$ orabmload Warehouses 1
Ô¶³ÌÊý¾Ý¿âʹÓãº
Èç¹ûÒª²âÊÔµÄÊÇÔ¶³ÌÊý¾Ý¿âµÄ»°£¬
windowsÐèÒªÏÈset local=tnsname£¬tnsnameÊÇÔÚtnsname.oraÖÐÅäÖõÄÔ¶³ÌÊý¾Ý¿âµÄ±ðÃû¡£
UNIX/LIINUX£¬ÐèÒªÏÈTWO_TASK=tnsname
$ orabmload Warehouses 1
4) create the indexes
ÕâÒ»²½´´½¨Ë÷Òý
sqlplus system/pwd @orabm_ind
Ô¶³ÌÊý¾Ý¿âʹÓãº
sqlplus
system/pwd@tnsname
@orabm_ind
5) analyze the tables and indexes
·ÖÎö±íºÍË÷Òý
sqlplus system/pwd @orabm_analyze
Ô¶³


Ïà¹ØÎĵµ£º

Oracle±í·ÖÇø

 
 
      ¹ú¶¼ºÅÂëÊý¾Ý¿âÉè¼Æ˵Ã÷
 
                V1 
 
 
 
Îĵµ±ä¸ü¼Ç¼
   
ÐòºÅ
±ä¸üÄÚÈÝ˵Ã÷
°æ±¾ºÅ
°æ±¾ÈÕÆÚ
Ö´±ÊÈË
1
³õ¸å
V ......

OracleÈÏÖ¤½éÉÜ

ORACLEÅàѵ(OCA)ÈÏÖ¤½éÉÜ 
Oracle10g Certified Associate (OCA) Oracle ÈÏ֤רԱ¡£
¿¼ÊԳɼ¨Í¨¹ýÄÜ»ñµÃOracle¹«Ë¾ÎªÄú°ä·¢µÄÈ«ÇòÈÏÖ¤µÄÓ¢ÎÄOCAÖ¤Êé¡£OCAÓÉOracle¹«Ë¾³öÌâ¡£
¸ÃÖ¤Êé¿É×÷Ϊ¸÷ÆóÊÂÒµµ¥Î»Êý¾Ý¿â¹ÜÀíÈËÔ±ÉϸڵÄÒÀ¾Ý¡£
Ä¿Ç°ÒѳÉΪ¸÷IT¹«Ë¾¼°Ïà¹ØÆóÒµÕùÏྺƸµÄÊý¾Ý¿â¹ÜÀíά»¤È˲ţ¬ÊÇÊý¾Ý¿âά»¤¹ÜÀíÈËÔ ......

oracleÊý¾Ý¿âλÖÃǨÒÆ

ÓÉÓÚÊý¾Ý¿âԭʼ°²×°µÄÔ­ÒòÔì³ÉÊý¾Ý¿â»òÕû¸ö²Ù×÷ϵͳµÄ²»°²È«»òÕßÓÉÓÚ´ÅÅÌ¿Õ¼ä±ä»¯ÔÙ»òÕßÓÉÓÚÒµÎñ±ä»¯Ôì³ÉµÄI/OÐÔÄÜÐèÒªµ÷ÕûµÈµÈÔ­ÒòÐèÒªÊý¾Ý¿â¹ÜÀíÔ±½øÐÐÊý¾Ý¿âÎļþλÖõĵ÷Õû.ÏÂÃæͨ¹ýÒ»¸öWINDOWSƽ̨µÄORACLEÊý¾ÝÎļþÒƶ¯ÎªÀý×ÓÌÖÂÛÒ»ÏÂÊý¾Ý¿âÎļþÒƶ¯µÄ·½·¨,Çë´ó¼ÒÖ¸Õý.
Ò».Òƶ¯Êý¾ÝÎļþ
Òƶ¯Êý¾ÝÎļþ±ÊÕßĿǰʹÓõÄÓÐ ......

Access¡¢SQLServer¡¢Oracle³£¼ûSQLÓï¾äÓ¦ÓÃÇø±ð


Access¡¢SQLServer¡¢Oracle³£¼ûSQLÓï¾äÓ¦ÓÃÇø±ð
¹Ø¾¢ËÉ PMP
Èç¹ûÒª¼æÈÝAccess¡¢SQL Server¡¢OracleÈý¸öÊý¾Ý¿â°æ±¾£»ÎÒÃÇÔÚ±àдSQLÓï¾äµÄ¹ý³ÌÖУ¬¾¡Á¿Ê¹ÓÃһЩͨÓõÄÓï¾ä£¬µ«»¹ÊÇÓÐЩ·½ÃæÓÐЩÇø±ð±ÜÃâ²»ÁË£¬ÏÖ¼òµ¥×ܽáһϡ£
ÒÔÏÂA´ú±íAccess,S´ú±íSQL Server,O´ú±íOracle
1¡¢È¡µ±Ç°ÏµÍ³Ê±¼ä
A:Select Now()
S:Selec ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ