¡¾×ª¡¿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.index_name=c.index_name
¡¡and i.table_name ='ACC_NBR';//Áª½ÓʹÓÃ
6¡¢ÐòÁУº
¡¡select * from dba_sequences;
7¡¢ÊÓͼ£º
¡¡select * from dba_views;
¡¡select * from all_views;
text ¿ÉÓÃÓÚ²éѯÊÓͼÉú³ÉµÄ½Å±¾
8¡¢¾Û´Ø£º
¡¡select * from dba_clusters;
9¡¢¿ìÕÕ£º
¡¡select * from dba_snapshots;
¿ìÕÕ¡¢·ÖÇøÓ¦´æÔÚÏàÓ¦µÄ±í¿Õ¼ä¡£
10¡¢Í¬Òå´Ê£º
¡¡select * from dba_synonyms
where table_owner='SPGROUP';
//if owner is PUBLIC,then the synonyms is a public synonym.
¡¡if owner is one of users,then the synonyms is a private synonym.
11¡¢Êý¾Ý¿âÁ´£º
¡¡select * from dba_db_links;
ÔÚspbaseϽ¨Êý¾Ý¿âÁ´
¡¡create database link dbl_spnew
¡¡connect to spnew identified by spnew u
Ïà¹ØÎĵµ£º
ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
Ê×ÏÈ£¬Ô ......
µ±Ê¹ÓÃ'for update' Ôì³É±íËøסÁË.¿ÉÒÔÓÃDBAµÇ½°´ÕÕÏÂÃæ²½Öè:
1.²é¿´Äĸö±í±»Ëø:
select b.owner,b.object_name,l.session_id,l.locked_mode
from v$locked_object l, dba_objects b
where b.object_id=l.object_id;
2.²é¿´±»Ëø±íµÄsid ºÍserial# :
select t2.username,t2.sid,t2.serial#,t2.logon_time
from v$lo ......
OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹ÔÓ뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
Ö´Ðл·¾³£º¿ÉÒÔÔÚSQLPLUS.EXE»òÕßDOS£¨ÃüÁîÐУ©ÖÐÖ´Ð ......
ORACLE±¸·Ý²ßÂÔ(ORACLE BACKUP STRATEGY)
2007Äê11ÔÂ02ÈÕ ÐÇÆÚÎå 16:03
¸ÅÒª
1¡¢Á˽âʲôÊDZ¸·Ý
2¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
3¡¢Àí½âÊý¾Ý¿âµÄÁ½ÖÖÔËÐз½Ê½
4¡¢Àí½â²»Í¬µÄ±¸·Ý·½Ê½¼°ÆäÇø±ð
5¡¢Á˽âÕýÈ·µÄ±¸·Ý²ßÂÔ¼°ÆäºÃ´¦
Ò»¡¢Á˽ⱸ·ÝµÄÖØÒªÐÔ
¿ÉÒÔ˵£¬´Ó¼ÆËã»úϵͳ³öÊÀµÄÄÇÌìÆ𣬾ÍÓÐÁ˱¸·ÝÕâ¸ö¸ÅÄ ......