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

ÔÚOracleÖвéѯ±íµÄ´óСºÍ±í¿Õ¼äµÄ´óС

 ÓÐÁ½ÖÖº¬ÒåµÄ±í´óС¡£Ò»ÖÖÊÇ·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹Ó᣿ÉÒÔÕâÑù²éѯ»ñµÃ×Ö½ÚÊý£º
select segment_name, bytes
from user_segments
where segment_type = 'TABLE';
»òÕß
   Select Segment_Name,Sum(bytes)/1024/1024 from User_Extents Group By Segment_Name
ÁíÒ»ÖÖ±íʵ¼ÊʹÓõĿռ䡣ÕâÑù²éѯ£º
analyze table emp compute statistics;
select num_rows * avg_row_len
from user_tables
where table_name = 'EMP';
²é¿´Ã¿¸ö±í¿Õ¼äµÄ´óС
Select Tablespace_Name,Sum(bytes)/1024/1024 from Dba_Segments Group By Tablespace_Name
1.²é¿´Ê£Óà±í¿Õ¼ä´óС
 
SELECT tablespace_name ±í¿Õ¼ä,sum(blocks*8192/1000000) Ê£Óà¿Õ¼äM from dba_free_space GROUP BY tablespace_name;
 
2.¼ì²éϵͳÖÐËùÓбí¿Õ¼ä×ÜÌå¿Õ¼ä
select b.name,sum(a.bytes/1000000)×Ü¿Õ¼ä from v$datafile a,v$tablespace b where a.ts#=b.ts# group by b.name;
¡¡¡¡1¡¢²é¿´OracleÊý¾Ý¿âÖбí¿Õ¼äÐÅÏ¢µÄ¹¤¾ß·½·¨£º
¡¡¡¡Ê¹ÓÃoracle enterprise manager console¹¤¾ß£¬ÕâÊÇoracleµÄ¿Í»§¶Ë¹¤¾ß£¬µ±°²×°oracle·þÎñÆ÷»ò¿Í»§¶Ëʱ»á×Ô¶¯°²×°´Ë¹¤¾ß£¬ÔÚwindows²Ù×÷ϵͳÉÏÍê³Éoracle°²×°ºó£¬Í¨¹ýÏÂÃæµÄ·½·¨µÇ¼¸Ã¹¤¾ß£º¿ªÊ¼²Ëµ¥——³ÌÐò——Oracle-OraHome92——Enterprise Manager Console(µ¥»÷)——oracle enterprise manager consoleµÇ¼——Ñ¡Ôñ‘¶ÀÁ¢Æô¶¯’µ¥Ñ¡¿ò——‘È·¶¨’ —— ‘oracle enterprise manager console£¬¶ÀÁ¢’ ——Ñ¡ÔñÒªµÇ¼µÄ‘ʵÀýÃû’ ——µ¯³ö‘Êý¾Ý¿âÁ¬½ÓÐÅÏ¢’ ——ÊäÈë’Óû§Ãû/¿ÚÁî’ (Ò»°ãʹÓÃsysÓû§)£¬’Á¬½ÓÉí·Ý’Ñ¡ÔñÑ¡ÔñSYSDBA——‘È·¶¨’£¬ÕâʱÒѾ­³É¹¦µÇ¼¸Ã¹¤¾ß£¬Ñ¡Ôñ‘´æ´¢’ ——±í¿Õ¼ä£¬»á¿´µ½ÈçϵĽçÃ棬¸Ã½çÃæÏÔʾÁ˱í¿Õ¼äÃû³Æ£¬±í¿Õ¼äÀàÐÍ£¬Çø¹ÜÀíÀàÐÍ£¬ÒÔ”ÕהΪµ¥Î»µÄ±í¿Õ¼ä´óС£¬ÒÑʹÓõıí¿Õ¼ä´óС¼°±í¿Õ¼äÀûÓÃÂÊ¡£
¡¡¡¡Í¼1 ±í¿Õ¼ä´óС¼°Ê¹ÓÃÂÊ
¡¡¡¡2¡¢²é¿´OracleÊý¾Ý¿âÖбí¿Õ¼äÐÅÏ¢µÄÃüÁî·½·¨£º
¡¡¡¡Í¨¹ý²éѯÊý¾Ý¿âϵͳÖеÄÊý¾Ý×Öµä±í(data dictionary tables)»ñÈ¡±í¿Õ¼äµÄÏà¹ØÐÅÏ¢£¬Ê×ÏÈʹÓÿͻ§¶Ë¹¤¾ßÁ¬½Óµ½Êý¾


Ïà¹ØÎĵµ£º

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 11g R2ÐÂÌØÐÔ¸ÅÊö£¨×ª£©

 µ¼¶Á£º
¡¡¡¡2009Äê9ÔÂOracle¹«Ë¾·¢²¼ÁËÆÚ´ýÒѾõÄOracle 11g R2£¬±¾ÏµÁÐÎÄÕ½«¸ø¶ÁÕßÒ»Ò»½Ò¿ªÐ°汾ÖеÄÐÂÌØÐÔ£¬²¢»á½éÉÜÆóÒµÈçºÎÀûÓÃÕâЩÐÂÌØÐÔ½«ÏÖÓеÄOracle 9i£¬10g£¬11g R1Éý¼¶µ½Oracle 11g R2.
¡¡¡¡¾­ÀúÁËÄÑÒÔÈÌÊܵij¤Ê±¼äµÈ´ý£¬Oracle¹«Ë¾Í»È»ÔÚ9ÔÂ1·¢²¼ÁËOracle 11g R2£¬ÎÒ²»µÃ²»³ÐÈÏOracleµÄ±£Ãܹ¤×÷×öµÃ ......

Oracle±¸·Ý¹ÜÀí ÌåÑé°æ

Oracle±¸·Ý¹ÜÀí
×î¼òµ¥µÄOracle Âß¼­±¸·ÝÈí¼þ£¬Ç¿´óµÄ¼Æ»®±¸·Ý¼°ÈßÓ౸·Ý¹¦ÄÜ
Èí¼þÌØÉ«£º
1.ÂéȸËäС£¬ÎåÔà¾ãÈ«¡£±¾×ÅʵÓõĽǶȿª·¢Õâ¸öÈí¼þ£¬Í¬Ê±¼æ¹Ë½çÃæÓ빦ÄÜ
2.ÖÇÄÜ»¯±¸·Ý¹¦ÄÜ£¬µ÷ÓÃOracle µÄexp±¸·Ý¹¦ÄÜ£¬ÖÇÄܼì²â±¸·Ý²ÎÊý
3.ÖÇÄÜѹËõ±¸·ÝÎļþ£¬²»Óõ£Ðı¸·ÝÊý¾Ý¹ý´ó¶øÓ²Å̳ÔÁ¦
4.¼°Æä¼òµ¥µÄ²Ù×÷½çÃ棬¼¸·ÖÖÓ¼ ......

Oracle¶¯Ì¬ÐÔÄܱí(1)

±¾ÊÓͼ³ÖÐø¸ú×ÙËùÓÐshared poolÖеĹ²Ïícursor£¬ÔÚshared poolÖеÄÿһÌõSQLÓï¾ä¶¼¶ÔÓ¦Ò»ÁС£±¾ÊÓͼÔÚ·ÖÎöSQLÓï¾ä×ÊԴʹÓ÷½Ãæ·Ç³£ÖØÒª¡£
V$SQLAREAÖеÄÐÅÏ¢ÁÐ
HASH_VALUE£ºSQLÓï¾äµÄHashÖµ¡£
ADDRESS£ºSQLÓï¾äÔÚSGAÖеĵØÖ·¡£
ÕâÁ½Áб»ÓÃÓÚ¼ø±ðSQLÓï¾ä£¬ÓÐʱ£¬Á½Ìõ²»Í¬µÄÓï¾ä¿ÉÄÜhashÖµÏàͬ¡£Õâʱºò£¬±ØÐëÁ¬Í¬ADDRESSÒ ......

OracleÖÐdateÐÍÊý¾Ý¼ìË÷

 
ÓÃdateÐÍ×ֶνøÐÐÊý¾Ý¼ìË÷ʱÐèҪעÒ⣺Êý¾Ý¸ñʽ»¯£¡
´ËÊý¾Ý¸ñʽ»¯²»Í¬ÓÚÓÃSimpleDateFormat("yyyy-MM-dd")¶ÔÏó½øÐиñʽ»¯£¬¶øÊÇÓÃOracleµÄÄÚÖú¯Êýto_date()
»ò±êʶ·ûdateÀ´¸ñʽ»¯¡£
ÀýÈ磺
        Óиö×Ö¶ÎÊÇdateÊý¾Ý£¬ÎÒÏë²éѯijijÄê¶ÈµÄÊý¾Ý¡£
´íÎóд·¨£ºs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ