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

Oracleϵͳ±í²éѯ

 Êý¾Ý×Öµä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_free_space group by tablespace_name;//¿ÕÏбí¿Õ¼ä  
  
¡¡¡¡¡¡select * from dba_data_files  
¡¡¡¡¡¡¡¡where tablespace_name=’RBS’;//±í¿Õ¼ä¶ÔÓ¦µÄÊý¾ÝÎļþ  
  
¡¡¡¡¡¡select * from dba_segments  
¡¡¡¡¡¡¡¡where tablespace_name=’INDEXS’;  
¡¡¡¡3¡¢Êý¾Ý¿â¶ÔÏ󣺠 
¡¡¡¡¡¡select * from dba_objects;  
¡¡¡¡¡¡CLUSTER¡¢DATABASE LINK¡¢FUNCTION¡¢INDEX¡¢LIBRARY¡¢PACKAGE¡¢PACKAGE BODY¡¢  
¡¡¡¡¡¡PROCEDURE¡¢SEQUENCE¡¢SYNONYM¡¢TABLE¡¢TRIGGER¡¢TYPE¡¢UNDEFINED¡¢VIEW¡£  
¡¡¡¡4¡¢±í£º  
¡¡¡¡¡¡select * from dba_tables;  
¡¡¡¡¡¡analyze my_table compute statistics;->dba_tablesºó6ÁР 
¡¡¡¡¡¡select extent_id,bytes from dba_extents  
¡¡¡¡¡¡where segment_name=’CUSTOMERS’ and segment_type=’TABLE’  
¡¡¡¡¡¡order by extent_id;//±íʹÓõÄextentµÄÐÅÏ¢¡£segment_type=’ROLLBACK’²é¿´»Ø¹ö¶ÎµÄ¿Õ¼ä·ÖÅäÐÅÏ¢  
¡¡¡¡¡¡ÁÐÐÅÏ¢£º  
¡¡¡¡¡¡¡¡select distinct table_name  
¡¡¡¡¡¡¡¡from user_tab_columns  
¡¡¡¡¡¡¡¡where column_name=’SO_TYPE_ID’;  
¡¡¡¡5¡¢Ë÷Òý£º¡¡  
¡¡¡¡¡¡select * from dba_indexes;//Ë÷Òý£¬°üÀ¨Ö÷¼üË÷Òý  
¡¡¡¡¡¡select * from dba_ind_columns;//Ë÷ÒýÁР 
¡¡¡¡¡¡select i.index_name,i.uniqueness,c.column_name  
¡¡¡¡¡¡¡¡from user_indexes i,user_ind_columns c  
¡¡¡¡¡¡¡¡¡¡where i.inde


Ïà¹ØÎĵµ£º

OracleÊý¾Ý¿âµÄ±¸·Ý¼°»Ö¸´²ßÂÔÑо¿

1¡¢¶à¹¤Áª»úÖØ×÷ÈÕÖ¾Îļþ
¡¡¡¡Ã¿¸öÊý¾Ý¿âʵÀý¶¼ÓÐÆä×Ô¼ºµÄÁª»úÖØ×÷ÈÕÖ¾×飬ÔÚ²Ù×÷Êý¾Ý¿âʱ£¬OracleÊ×ÏȽ«Êý¾Ý¿âµÄÈ«²¿¸Ä±ä±£´æÔÚÖØ×÷ÈÕÖ¾»º³åÇøÖУ¬ËæºóÈÕÖ¾¼Ç¼Æ÷½ø³Ì£¨LGWR£©½«Êý¾Ý´Óϵͳ¹²ÓÃÇøSGA£¨System Global Area£©µÄÖØ×÷ÈÕÖ¾»º³åÇøдÈëÁª»úÖØ×÷ÈÕÖ¾Îļþ£¬ÔÚ´ÅÅ̱ÀÀ£»òʵÀýʧ°Üʱ£¬¿ÉÒÔͨ¹ýÓëÖ®Ïà¹ØµÄÁª»úÖØ×÷ÈÕÖ¾ ......

toad for oracle(µ¼Èëµ¼³öʵÀý)

Àý£º
create user his identified by his default tablespace users temporary tablespace temp;
grant connect,resource,dba to his;
create tablespace his
logging
datafile 'd:\oracle\product\10.2.0\oradata\zjxsh\his.ora' size 100M extent
management local segment space management auto;
exp his/ny@ny ......

spring+hibernateÖд¦Àíoracle BLOB

 1¡¢ÅäÖÃhibernate£º
    1.1¡¢ÅäÖÃhibernateµÄ³Ö¾ÃÀàÎļþÖжÔÓ¦µÄ×Ö¶ÎΪbyte[]ÀàÐÍ
    2.2¡¢ÅäÖÃhibernateµÄÀàÓ³ÉäÎļþÖжÔÓ¦µÄ×Ö¶ÎtypeΪ 
            org.springframework.orm.hibernate3.support.BlobByteArray ......

Oracle Job Óï·¨ºÍʱ¼ä¼ä¸ôµÄÉ趨

³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000 ;job_queue_interval = 10 //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
job_queue_process ±íʾoracleÄܹ»²¢·¢µÄjobµÄÊýÁ¿£¬¿ÉÒÔͨ¹ýÓï¾ä¡¡¡¡
show parameter job_queue_process;
À´²é¿´oracleÖÐjob_queue_processµÄÖµ¡ ......

OracleºÍTomcat¶Ë¿Ú³åÍ»

OracleºÍTomcat¶Ë¿Ú³åÍ»
Ô­Òò:
    Oracle 9i¿ªÊ¼£¬´´½¨Êý¾Ý¿âʱĬÈÏ°üº¬ÁËXDBÌØÐÔ¡£Ò»µ©Æô¶¯ÁËÊý¾Ý¿âºÍListener£¬Oracle XDBµÄhttp·þÎñ¾ÍÕ¼ÓÃ8080¶Ë¿Ú£¬¸ÕºÃºÍJBoss¡¢TomcatµÈĬÈ϶˿ڳåÍ»¡£
½â¾ö·½·¨
 1¡¢¸Ä¶¯tomcat¶Ë¿Ú£¬
´ò¿ªD:\Tomcat5\conf\server.xml£¬²éÕÒÈçÏÂÎı¾Î»Öãº
<!-- Def ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ