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

Oracle¶¯Ì¬ÐÔÄܱí

°´ÕÕOracleDocumentÖеÄÃèÊö£¬v$sysstat´æ´¢×ÔÊý¾Ý¿âʵÀýÔËÐÐÄÇ¿ÌÆð¾Í¿ªÊ¼ÀÛ¼ÆȫʵÀý(instance-wide)µÄ×ÊԴʹÓÃÇé¿ö¡£
ÀàËÆÓÚv$sesstat£¬¸ÃÊÓͼ´æ´¢ÏÂÁеÄͳ¼ÆÐÅÏ¢£º
1>.ʼþ·¢Éú´ÎÊýµÄͳ¼Æ(È磺user commits)
2>.Êý¾Ý²úÉú£¬´æÈ¡»òÕß²Ù×÷µÄtotalÁÐ(È磺redo size)
3>.Èç¹ûTIMED_STATISTICSֵΪtrue,Ôòͳ¼Æ»¨·ÑÔÚÖ´ÐвÙ×÷ÉϵÄ×Üʱ¼ä(È磺CPU used by this session)
v$sysstatÊÓͼ³£ÓÃÁнéÉÜ£º
l         STATISTIC#: ±êʶ
l         NAME: ͳ¼ÆÏîÃû³Æ
l         VALUE: ×ÊԴʹÓÃÁ¿
¸ÃÊÓͼ»¹ÓÐÒ»ÁÐclass-ͳ¼ÆÀà±ðµ«¼«ÉٻᱻʹÓ㬸÷ÀàÐÅÏ¢ÈçÏ£º
1 ´ú±íÊÂÀý»î¶¯
2 ´ú±íRedo buffer»î¶¯
4 ´ú±íËø
8 ´ú±íÊý¾Ý»º³å»î¶¯
16 ´ú±íOS»î¶¯
32 ´ú±í²¢Ðл
64 ´ú±í±í·ÃÎÊ
128 ´ú±íµ÷ÊÔÐÅÏ¢
×¢Ò⣺Statistic#µÄÖµÔÚ²»Í¬°æ±¾Öи÷²»Ïàͬ£¬Ê¹ÓÃʱҪÓÃName×öΪ²éѯÌõ¼þ¶ø²»ÒªÒÔstatistic#µÄÖµ×öΪÌõ¼þ¡£
ʹÓÃv$sysstatÖеÄÊý¾Ý
¡¡¡¡¸ÃÊÓͼÖÐÊý¾Ý³£±»ÓÃÓÚ¼à¿ØϵͳÐÔÄÜ¡£Èçbuffer cacheÃüÖÐÂÊ¡¢Èí½âÎöÂʵȶ¼¿É´Ó¸ÃÊÓͼÊý¾Ý¼ÆËãµÃ³ö¡£
¡¡¡¡¸ÃÊÓͼÖеÄÊý¾ÝÒ²±»ÓÃÓÚ¼à¿Øϵͳ×ÊԴʹÓÃÇé¿ö£¬ÒÔ¼°ÏµÍ³×ÊÔ´ÀûÓÃÂʵı仯¡£ÕýÒòÈç´Ë¶àµÄÐÔÄÜÊý¾Ý£¬¼ì²éijÇø¼äÄÚϵͳ×ÊԴʹÓÃÇé¿ö¿ÉÒÔÕâÑù×ö£¬ÔÚÒ»¸öʱ¼ä¶Î¿ªÊ¼Ê±´´½¨Ò»¸öÊÓͼÊý¾Ý¿ìÕÕ£¬½áÊøʱÔÙ´´½¨Ò»¸ö£¬¶þÕßÖ®¼ä¸÷ͳ¼ÆÏîÖµµÄ²»Í¬(end value - begin value)¼´ÊÇÕâһʱ¼ä¶ÎÄÚµÄ×ÊÔ´ÏûºÄÇé¿ö¡£ÕâÊÇoracle¹¤¾ßµÄ³£Ó÷½·¨£¬ÖîÈçStatspackÒÔ¼°BSTAT/ESTAT¶¼ÊÇÈç´Ë¡£
¡¡¡¡ÎªÁ˶ԱÈij¸öÇø¼ä¶ÎµÄÊý¾Ý£¬Ô´Êý¾Ý¿ÉÒÔ±»¸ñʽ»¯£¨Ã¿´ÎÊÂÎñ£¬Ã¿´ÎÖ´ÐУ¬Ã¿ÃëÖÓ»òÿ´ÎµÇ½£©£¬¸ñʽ»¯ºóÊý¾Ý¸üÈÝÒ×´ÓÁ½ÕßÖмø±ð³ö²îÒì¡£ÕâÀàµÄ¶Ô±ÈÔÚÉý¼¶Ç°£¬Éý¼¶ºó»ò½ö½öÏë¿´¿´Ò»¶Îʱ¼äÄÚÓû§ÊýÁ¿Ôö³¤»òÊý¾ÝÔö¼ÓÈçºÎÓ°Ïì×ÊԴʹÓ÷½Ãæ¸ü¼ÓʵÓá£
¡¡¡¡ÄãÒ²¿ÉÒÔʹÓÃv$sysstatÊý¾Ýͨ¹ý²éѯv$system_eventÊÓͼÀ´¼ì²é×ÊÔ´ÏûºÄºÍ×ÊÔ´»ØÊÕ¡£
V$SYSSTATÖеij£ÓÃͳ¼Æ
¡¡¡¡V$SYSSTATÖаüº¬¶à¸öͳ¼ÆÏÕⲿ·Ö½éÉÜÁËһЩ¹Ø¼üµÄv$sysstatͳ¼ÆÏÔÚµ÷ÓÅ·½ÃæÏ൱ÓÐÓá£ÏÂÁа´×ÖĸÏȺóÅÅÐò£º
Êý¾Ý¿âʹÓÃ״̬µÄһЩ¹Ø¼üÖ¸±ê£º
l         CPU used by this session£ºËùÓÐsessionµÄcpuÕ¼ÓÃÁ¿£¬²»°üÀ¨ºǫ́½ø³Ì¡£ÕâÏîͳ¼ÆµÄµ¥Î»ÊÇ°Ù·ÖÖ®xÃë.ÍêÈ«µ÷ÓÃÒ»´Î²»³¬¹ý10ms
l  


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

OracleÊý¾Ý¿â±¸·Ý¼¼ÇÉ

¡¡¡¡oracle% sqlplus /nolog
¡¡¡¡SQL> conn / as sysdba
¡¡¡¡Êý¾Ý¿âµÄÎïÀíÎļþ
¡¡¡¡Êý¾ÝÎļþ
¡¡¡¡select file_name from dba_data_files;
¡¡¡¡¿ØÖÆÎļþ
¡¡¡¡select name from v$controlfile;
¡¡¡¡ÈÕÖ¾Îļþ
¡¡¡¡select member from v$logfile;
¡¡¡¡---------------------------------------------------------
......

oracle 10.2g ÔÚCentOS 5.1µÄ°²×°¹ý³Ì

µÚÒ»²½¡¢¼ì²é²Ù×÷ϵͳ»·¾³
rpm -q gcc make binutils openmotif glibc setarch compat-db compat-gcc-34 openmotif compat-gcc-34-c++ compat-libstdc++-33
Èç¹û¼ì²âµ½Äĸö°üûÓÐ×°£¬Ôò·Ö±ðÔÚISO¾µÏñÎļþÖÐÕÒµ½½øÐа²×°
¹ÒÔØ6ÕÅ»ò7ÕÅISOÎļþ£¬
±ÈÈç˵£ºrpm -ivh /mnt/iso/3/CentOS/openmotif*
Ö»ÒªÊÇûÓÐ×°µÄ¶¼Òª½øÐа ......

ORACLE PL/SQL ¼Ç¼(Record)ѧϰ±Ê¼Ç(Ò»)

ÔÚPL/SQL³ÌÐòÉè¼ÆÖУ¬ÓÐÈýÖÖ¶¨Òå¼Ç¼ÀàÐ͵ķ½·¨£ºÒ»ÖÖÊÇʹÓÃ%ROWTYPEÊôÐÔ£»ÁíÒ»ÖÖÊÇÔÚPL/SQL³ÌÐòµÄÉùÃ÷²¿·ÖÏÔʾ¶¨Òå¼Ç¼ÀàÐÍ£»×îºóÒ»ÖÖ·½·¨Êǽ«¼Ç¼ÀàÐͶ¨ÒåΪÊý¾Ý¿â½á¹¹»ò¶ÔÏóÀàÐÍ¡£
ÎÒÏȼòµ¥µÄ½éÉÜÒ»¸öÏÂÃæÒªÓõ½µÄ±íµÄ½á¹¹£¨ºÚÌå±êÃ÷µÄ×Ö¶ÎΪÖ÷¼ü£©£º
INDIVIDUALS±í
 
INDIVIDUAL ID
FIRST NAME
MIDDLE_INITI ......

ORACLE PL/SQL ¼¯ºÏAPI ×ܽá

ORACLE 10GµÄ¼¯ºÏAPI
 
¼¯ºÏAPI·½·¨×îÔçÊÇÔÚORACLE 8IÖÐÒýÈëµÄ¡£¼¯ºÏAPIÌṩÁ˼ò»¯·ÃÎʼ¯ºÏµÄ·½·¨¡£ÔÚORACLE 10GÒÔÇ°£¬ÕâЩ·½·¨È·Êµ¼ò»¯Á˶Լ¯ºÏµÄ·ÃÎÊ¡£µ«ÊÇ£¬²¢²»ÊÇ·ÇÒªÇóÕÆÎÕÕâЩ·½·¨²»¿É¡£´ÓORACLE 9IµÄINDEX-BY±íµ½ORACLE 10GµÄÁªºÏÊý×éµÄת»»£¬Ê¹ËüÃdzÉΪ±ØÐëÕÆÎյķ½·¨¡£
 
ÏÂÃæÊÇÎÒ´ÓÊéÉÏժ¼ÏµÄһР......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ