oracle Ïà關µÄsql語¾ä
Êý¾Ý×Öµä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
Ïà¹ØÎĵµ£º
--´´½¨Óû§
create user iagent identified by ia
--profile default
default tablespace users
temporary tablespace temp;
--account unlock;
--ɾ³ýÓû§
drop user iagent cascade;
--ÐÞ¸ÄÓû§ÃÜÂë
alter user iagent identified by ia;
--¸ø´´½¨µ ......
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......
GSD global services daemon (GSD)
ÓëracµÄ¹ÜÀí¹¤¾ßdbca srvctl
oem½øÐн»»¥£¬ÓÃÀ´Íê³ÉʵÀýµÄÆô¶¯¹Ø±ÕµÈ¹ÜÀíÈÎÎñ¡£
ΪÁ˱£Ö¤ÕâЩ¹ÜÀí¹¤¾ßÔËÐÐÕý³£±ØÐëÔÚËùÓеĽڵãÉÏÏÈstart
gsd,²¢ÇÒÒ»¸öGSD½ø³ÌÖ§³ÖÔÚ
Ò»¸ö½ÚµãµÄ¶à¸örac.gsd½ø³ÌλÓÚ$ORACLE_HOME/binĿ¼Ï£¬ÆälogÎļþ
Ϊ$oracle_home
/srvm/log/gsdaemon.log
À ......
½Å±¾1£º
SELECT NAME
,value
,description
from ( --GV$SYSTEM_PARAMETER
SELECT x.inst_id as instance
,x.indx+1
,ksppinm as NAME
,ksppity
,ksppstvl as value
,ksppstdf as isdefault& ......
1.´´½¨²âÊÔ±í
create table users(
userid int primary key,
username varchar2(20),
userpwd varchar2(20)
);
insert into users values(1,'test','test');
insert into users values(2,'test','test');
insert into users values(3,'test','test');
insert into users values(4,'test','test');
insert i ......