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

Oracle 10.1 Statistics

Oracle 10.1 Statistics£º
In Oracle 9.2 there were 264 statistics; in Oracle 10.1 there are 332 statistics
The following table shows the 106 statistics that were added in Oracle 10.1:
 
Name
application wait time
cluster wait time
concurrency wait time
consistent gets direct
consistent gets from cache
db block gets direct
db block gets from cache
DB time
DBWR object drop buffers written
DBWR parallel query checkpoint buffers written
DBWR tablespace checkpoint buffers written
DBWR thread checkpoint buffers written
doubling up with imu segment
flashback log writes
frame signature mismatch
gc blocks corrupt
gc blocks lost
gc claim blocks lost
gc CPU used by this session
gc cr block build time
gc cr block flush time
gc cr block receive time
gc cr block send time
gc cr blocks received
gc cr blocks served
gc current block flush time
gc current block pin time
gc current block receive time
gc current block send time
gc current blocks received
gc current blocks served
global enqueue CPU used by this session
global enqueue get time
global enqueue gets async
global enqueue gets sync
global enqueue releases
heap block compress
IMU bind flushes
IMU commits
IMU contention
IMU CR rollbacks
IMU Flushes
IMU ktichg flush
IMU mbu flush
IMU pool not allocated
IMU recursive-transaction flush
IMU Redo allocation size
IMU undo allocation size
IMU undo retention flush
IMU- failed to get a private strand
IPC CPU used by this session
java call heap collected bytes
java call heap collected count
java call heap gc count
java call heap live object count
java call heap live object count max
java call heap live size
java call heap live size max
java call heap object count
java call heap object count max
java call heap total size
java call heap total size max
java call heap used size
java call heap used size max
java session heap collected bytes
java session heap collected count
java session heap gc count
java session heap


Ïà¹ØÎĵµ£º

jboss oracle rac Ïê½â!

Ò».ÔÚWEBLOGICÉÏÅ䱸ÁËÒ»¸ö¶à³Ø£¬ÀûÓÃWEBLOGICÌṩµÄ¸ººÉ¾ùºâıÂÔ£¬½«²¢·¢¾ùºâµÄ¾÷±ðµ½Á½¸ö½ÚµãÉÏ¡£ÏêϸÅ䱸ÔÚÈç´Î²Î¿¼×ÊÁÏ»ò¸½¼þÖС£
²Î¿¼×ÊÁÏ:http://www.oracle.com/technology/products/weblogic/howto/rac/index.html
¶þ.Ö±½ÓÊ©ÓÃÁËRACµÄÔغɾùºâ¶Ô²ß¡£
ÔÚOracleÖÐÕÒ³ötnsnames.oraÕâ¸ö×ÊÁÏ¡£ÔÚÅ䱸Êý¾ÝԴʱ£¬UR ......

Oracle ÓÅ»¯²ßÂÔ(¶þ) »ù±íµÄÑ¡Ôñ

»ù´¡±í(Driving Table)ÊÇÖ¸±»×îÏÈ·ÃÎʵıí(ͨ³£ÒÔÈ«±íɨÃèµÄ·½Ê½±»·ÃÎÊ). ¸ù¾ÝÓÅ»¯Æ÷µÄ²»Í¬, SQLÓï¾äÖлù´¡±íµÄÑ¡ÔñÊDz»Ò»ÑùµÄ.
Èç¹ûÄãʹÓõÄÊÇCBO (COST BASED OPTIMIZER),ÓÅ»¯Æ÷»á¼ì²éSQLÓï¾äÖеÄÿ¸ö±íµÄÎïÀí´óС,Ë÷ÒýµÄ״̬,È»ºóÑ¡Óû¨·Ñ×îµÍµÄÖ´Ðз¾¶.
Èç¹ûÄãÓÃRBO (RULE BASED OPTIMIZER) , ²¢ÇÒËùÓеÄÁ¬½ÓÌõ¼þ¶ ......

ÔÚLinuxϵͳÉÏʵÏÖÓÃPythonÔ¶³Ì·ÃÎÊOracleÊý¾Ý¿â

1¡¢ÏÂÔØoracleÈí¼þ
http://www.oracle.com/technology/software/tech/oci/instantclient/index.html
oracle-instantclient-basic-10.2.0.4-1.i386.rpm
oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
oracle-instantclient-devel-10.2.0.4-1.i386.rpm
2¡¢°²×°rpm°ü
rpm -ivh oracle-instantclient-basic-10.2.0.4 ......

Oracle EBS ÈçºÎÔ½áÖ®Ó¦¸¶(AP)¶ÔÕËÏê½â

Ó¦¸¶Ä£¿éµÄ¶àÊýÒµÎñ»ùÓڲɹººÍ¿â´æµÄ²Ù×÷£¬Òò´ËÓ¦¸¶Ä£¿éµÄÔ½áÓ¦¸ÃÔڲɹºÄ£¿éºÍ¿â´æÄ£¿éÔ½áºó²ÅÄܹرջá¼ÆÆÚ¡£
Ô½ᲽÖè
ÔÚÿ¸ö»á¼ÆÆÚÄ©£¬Ó¦¸¶Ä£¿éµÄÔ½áÓ¦×ñÑ­ÒÔÏÂÁ÷³Ì£º
1.¼ì²éÒµÎñÊÇ·ñÈ«²¿Â¼Èë;
2.¼ì²éÊÇ·ñÓÐδÑéÖ¤¡¢Ôݹҷ¢Æ±;
3.¸üе½ÆÚµÄÔ¶ÆÚ¸¶¿î״̬;
4.¼ì²éÓ¦¸¶ÒµÎñÊÇ·ñÉú³É·Ö¼;
5.Ó¦¸¶ÒµÎñ´«Ë͵½×ÜÕÊ;
6 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ