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

Oracle´æ´¢¿Õ¼ä¹ÜÀí

Oracle´æ´¢¿Õ¼ä¹ÜÀí
1.²é¿´Ã¿¸öÊý¾ÝÎļþµÄÊ£Óà±í¿Õ¼ä£¨Ò»¸ö±í¿Õ¼äÖ»¶ÔÓ¦N¸öÊý¾ÝÎļþ,NÒ»°ãµÈÓÚ1£©
Ö÷ÒªÊÇÀûÓñídba_free_space£¨±í¿Õ¼äÊ£Óà¿Õ¼ä×´¿ö£©ºÍdba_data_files£¨Êý¾ÝÎļþ¿Õ¼äÕ¼ÓÃÇé¿ö£©
    select b.file_id¡¡¡¡"ÎļþID",
¡¡¡¡b.tablespace_name¡¡¡¡"±í¿Õ¼äÃû",
¡¡¡¡b.file_name¡¡¡¡¡¡¡¡¡¡"ÎïÀíÎļþÃû",
¡¡¡¡b.bytes/1024/1024¡¡¡¡"×Ü×Ö½ÚÊý(M)",
¡¡¡¡(b.bytes-sum(nvl(a.bytes,0)))/1024/1024 "ÒÑʹÓÃ(M)",
¡¡¡¡sum(nvl(a.bytes,0))/1024/1024¡¡"Ê£Óà(M)",
¡¡¡¡sum(nvl(a.bytes,0))/(b.bytes)*100¡¡"Ê£Óà%"
¡¡¡¡from dba_free_space a,dba_data_files b
¡¡¡¡where a.file_id=b.file_id
¡¡¡¡group by b.tablespace_name,b.file_name,b.file_id,b.bytes
¡¡¡¡--order by b.tablespace_name
    order by "Ê£Óà%";
2.²é¿´·ÖÅä¸øÒ»¸ö±íµÄÎïÀí¿Õ¼äÊýÁ¿£¬¶ø²»¹Ü¿Õ¼äÊÇ·ñ±»Ê¹ÓÃ
·½·¨Ò»£º
 select segment_name, bytes/1024/1024 "¿Õ¼ä´óС(M)"
 from user_segments
 where segment_type = 'TABLE'
 and segment_name='TAS_AUDIT_HISTORY';
·½·¨¶þ£º
   Select Segment_Name,Sum(bytes)/1024/1024  "¿Õ¼ä´óС(M)"
   from User_Extents
   where segment_name='TAS_AUDIT_HISTORY'
   Group By Segment_Name;
3.²é¿´±íʵ¼ÊʹÓõĿռä
ÐèÒªÏÈ·ÖÎö£¬È»ºó²ÅÄܲ鿴¡£
·ÖÎöËùÓÐ±í£º
begin
 FOR emm IN ( select table_name from user_tables )
 LOOP
  execute immediate 'analyze table '|| emm.table_name|| ' compute statistics';
 END LOOP;
end;
·½·¨Ò»£º
 analyze table emp compute statistics;
 select table_name "±íÃû", num_rows "¼Ç¼Êý",avg_row_len "¼Ç¼ƽ¾ù³¤¶È",num_rows * avg_row_len "¼Ç¼×ܳ¤¶È"
 from user_tables
 where table_name = 'EMP';
 
·½·¨¶þ£ºÀûÓÃdata blockÀ´Í³¼Æ¿ÉÄܱȽϿɿ¿£¬ÒªÏȲ鿴block_size£¬ÕâÀï²é³öÀ´ÊÇ8192
--²é¿´±í¿Õ¼äµÄblock_size
select tablespace_name,block_size,status,ALLOCATION_TYPE
from dba_tablespaces;
select table_name,blocks*8192/1024/1024 size_m
from user_tables;
4.Oracle¶ÔÊý¾ÝÎļþµÄ´óСÏÞÖÆ
OracleÊý¾ÝÎļþµÄ´óС´æÔÚÒ»¸öÄÚ²¿ÏÞÖÆ£¬Õâ¸öÏÞÖÆÊÇ£º
ÿ¸ö


Ïà¹ØÎĵµ£º

oracleÖÐ ÕýÔÚÁ¬½Ó...ORA 12541: TNS: ûÓмàÌý³ÌÐò

¶ÔÓÚ×°ºÃÁ˸ÃÈí¼þºó,ÀûÓÃsystemÊÇÄܵǽøÈ¥µÄ,»ú×ÓÖØÆôºó,³öÏֵĸÃÎÊÌ⣺
    ¿ÉÄÜÄú ÔËÐÐ--sqlplusw  ÊÇÄܵÇÉÏÈ¥µÄ  ¶ø»»³ÉPL/SQL Developer È´Á¬²»ÉÏ ·þÎñÆ÷,Èç¹ûÄúÈ·¶¨ÄãµÄ·þÎñ¿ªÆôÁË
    ËÑË÷ÕÒµ½tnsnames.oraºÍlistener.oraÎļþ, °ÑÆäÖеÄHOST=ºóµÄÖ÷»úÃû»òip¸ÄΪµ±Ç°µ ......

iis7 asp ado oracle ÂÒÂëÎÊÌâ

»·¾³£ºÊý¾Ý¿â oracle 64bit ϵͳ win2008 64bit IIS7 ÔÚasp ÍøÒ³ÖÐʹÓÃadoÁ¬½ÓÊý¾Ý¿â ODBCÓõÄÊÇMicrosft ODBC for oracle
Çé¿ö£ºÔÚÍøÒ³µÄ²éѯÓï¾äÖв»º¬ÖÐÎĵĿÉÒÔ£¬Ö»ÒªÓï¾äÖк¬ÓÐÖÐÎľͻ᷵»Ø´íÎó½á¹û¡£
Èç:select 'Ò»¶þÈý' from dual;ÕâÑùµÄÓï¾ä ·µ»Ø»ØÀ´¾ÍÊÇ£¿£¿£¿
»¹ÒªËµÃ÷µÄÊÇoracleµÄ×Ö·û¼¯ÊÇAMERICAN_AMERICA.U ......

Oracle 10g RAC On Linux Using NFS

http://inthirties.com:90/thread-918-3-1.html
This article describes the installation of
Oracle 10g release 2 (10.2.0.1) RAC on Linux (Oracle Enterprise Linux
4.5) using NFS to provide the shared storage.
Introduction
Download Software
Operating System Installation
Oracle Installation Prereq ......

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È

SQLServerºÍOracleµÄ³£Óú¯Êý¶Ô±È
 
1.¾ø¶ÔÖµ
S:select abs(-1) value
O:select abs(-1) value from dual
 
2.È¡Õû(´ó)
S:select ceiling(-1.001) value
O:select ceil(-1.001) value from dual
 
3.È¡Õû£¨Ð¡£©
S:select floor(-1.001) value
O:select floor(-1.001) value from dual ......

oracle UPDATE ¶à±í¹ØÁª¸üÐÂ

update customers a
set city_name=(select b.city_name from tmp_cust_city b where b.customer_id=a.customer_id)
where exists (select 1
from tmp_cust_city b
where b.customer_id=a.customer_id
)
-- update ³¬¹ý2¸öÖµ
update customers a
set (city_name,customer_type)=(select b.city_name,b.customer_ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ