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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
¡¡¡¡Ò»¡¢Ê²Ã´ÊÇMTS
¡¡¡¡MTS = Multi-Threaded ServerMTSÊÇORACLE SERVERµÄÒ»¸ö¿ÉÑ¡µÄÅäÖÃÑ¡Ôñ£¬ÊÇÏà¶ÔDEDICATE·½Ê½¶øÑÔ£¬Ëü×î´óµÄÓŵãÊÇÔÚÒÔ²»ÓÃÔö¼ÓÎïÀí×ÊÔ´(ÄÚ´æ)µÄÇ°ÌáÏÂÖ§³Ö¸ü¶àµÄ²¢·¢µÄÁ¬½Ó¡£Joseph C.JohnsonÒԲ͹ݸø³öÒ»¸öMTSµÄÐÎÏóµÄ±ÈÓ÷
¡¡¡¡¼ÙÉèORACLEÊÇÒ»¼Ò²Í¹Ý£¬µ±Äã×ß½øÒ»¼Ò²Í¹ÝʱÄã¸Ð¾õ×îÊæ·þµÄ·þÎñ·½Ê½¾ÍÊ ......
Èý¡¢Ç¶Ì×±íµÄʹÓ÷½·¨
1¡¢½«Ç¶Ì×±í¶¨ÒåΪPL/SQLµÄ³ÌÐò¹¹Ôì¿é
TYPE type_name IS TABLE OF element_type[NOT NULL];
ÈçÏÂÀýËùʾ£º
DECLARE
-- Define a nested table of variable length strings.
TYPE card_table IS TABLE OF VARCHAR2(5 CHAR);
-- Declare and initialize a n ......
Oracle×Ô8iÆð¾ÍÈ«ÃæÖ§³Öjava£¬µ«¸÷¸ö°æ±¾µÄoracleÖÐĬÈÏjdk°æ±¾¾ù²»Ïàͬ£¬oracle8iÖÐΪ jdk1.2,oracle9iÖÐΪjdk1.3,oracle10gÖÐΪjdk1.4~~ÖÁ±ÊÕßÐÐΪ֮¼Ê£¬µ±Ç°µÄ×îа汾Ϊjdk1.5 update 11.
Òò±ÊÕßjava¿ª·¢³öÉí£¬ÔÚ×öoracle¿ª·¢Öо³£»áÓÃjavaÀ´À©Õ¹ oracle¹¦ÄÜ£¬µ«ÊÇÓÉÓÚoracle×Ô´øjdk°æ±¾¹ýµÍ£¬¿ÉÄÜ»áÔì³ÉһЩ ......
Êý¾Ý×Öµädict×ÜÊÇÊôÓÚOracleÓû§sysµÄ¡£
1¡¢Óû§£º
¡¡select username from dba_users;
¸Ä¿ÚÁî
¡¡alter user spgroup identified by spgtest;
2¡¢±í¿Õ¼ä£º
¡¡select * from dba_data_files;
¡¡select * from dba_tablespaces;//±í¿Õ¼ä
¡¡select tablespace_name,sum(bytes), sum(blocks)
from dba_ ......