Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 PL/SQL ¼Ç¼(Record)ѧϰ±Ê¼Ç(Ò»)

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

ORACLE PL/SQL ¼Ç¼(Record)ѧϰ±Ê¼Ç(¶þ)

¶þ¡¢ÒÔÐβεÄÐÎʽ¶¨ÒåºÍʹÓüǼ¡¢¶ÔÏóÀàÐÍ
ÔÚÓÃ×÷ÐÎʽ²ÎÊýʱ£¬¼Ç¼ÀàÐͺͶÔÏóÀàÐÍÓкܶàÏà֮ͬ´¦¡£ÔÚ½«ËüÃÇ×÷ΪÓαꡢº¯Êý»ò¹ý³ÌµÄÐÎʽ²ÎÊýÒÔÇ°£¬ÊÂÏȶ¼±ØÐ붨ÒåÒ»¸ö¼Ç¼ÀàÐÍ»òÕ߶ÔÏóÀàÐÍ¡£
ÈçÏÂÀýËùʾ£º
 
¼Ç¼
DECLARE

-- Define a record type.
TYPE individual_record IS RECORD
(individual_id ......

ORACLE PL/SQL ¼¯ºÏѧϰ±Ê¼Ç(Èý)

ËÄ¡¢ÁªºÏÊý×éµÄʹÓ÷½·¨
ÁªºÏÊý×éÒÔÇ°±»³ÆΪPL/SQL±í¡£ÔÚ±íÖв»ÄÜʹÓÃÁªºÏÊý×飬ֻÄܽ«ËüÃÇÓÃ×÷³ÌÐòÉè¼ÆµÄ½á¹¹Ìå¡£Ö»ÄÜÔÚPL/SQLÖзÃÎÊÁªºÏÊý×é¡£
×¢Òâµ½ÁªºÏÊý×é´øÀ´µÄһЩ¹Ø¼üÎÊÌâÊǷdz£ÖØÒªµÄ¡£ÕâЩÎÊÌâʹÎÒÃǽéÉÜËüÃǵÄÓ÷¨Ê±£¬ÐèÒª²ÉȡһЩÌرðµÄ·½·¨¡£ÕâЩÎÊÌâ°üÀ¨£º
ÁªºÏÊý×é²»ÐèÒª³õʼ»¯£¬Ò²Ã»Óй¹Ô캯ÊýÓï·¨¡£ÔÚ ......

OracleÊý¾Ý¿âÃæÊÔÎÊÌ⼯ºÏ¼°¼¼ÇÉ

 
ÕâƪÎÄÕÂÊÇORACLEÃæÊÔµÄÎÊÌâ½õ¼¯£¬ËäÈ»²»È«Ã棬µ«ÊÇÕâƪÎÄÕ»áÈÃÄãÖªµÀÈçºÎÈÃÃæÊÔ¿¼¹ÙÁ˽âÄã¶ÔORACLE¸ÅÄîµÄÊìϤ³Ì¶È¡£
 
1.½âÊÍÀ䱸·ÝºÍÈȱ¸·ÝµÄ²»Í¬µãÒÔ¼°¸÷×ÔµÄÓŵã
 
½â´ð£ºÈȱ¸·ÝÕë¶Ô¹éµµÄ£Ê½µÄÊý¾Ý¿â£¬ÔÚÊý¾Ý¿âÈԾɴ¦ÓÚ¹¤×÷״̬ʱ½øÐб¸·Ý¡£¶øÀ䱸·ÝÖ¸ÔÚÊý¾Ý¿â¹Ø±Õºó£¬½øÐб¸·Ý£¬ÊÊÓÃÓÚËùÓÐÄ£Ê ......

oracle ±Ê¼Ç

 1. SQL  Óï¾äÓëSQL*Plus ÃüÁî
 
 SQL
SQL*Plus
Ò»ÖÖÓïÑÔ
Ò»ÖÖ»·¾³
ANSI±ê×¼
Oracle µÄÌØÐÔÖ®Ò»
¹Ø¼ü×Ö²»ÄÜËõд
¹Ø¼ü×Ö¿ÉÒÔËõд
ʹÓÃÓï¾ä¿ØÖÆÊý¾Ý¿âÖеıíµÄ¶¨ÒåÐÅÏ¢
ºÍ±íÖеÄÊý¾Ý
ÃüÁî²»ÄܸıäÊý¾Ý¿âÖеÄÊý¾ÝµÄÖµ
 
¼¯ÖÐÔËÐÐ
2.ÒÔϼ¸¸ö²éѯºÜÖØÒª£¬×ÐϸÌå»á
1  (ÓÐÔ±¹¤µÄ³ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ