常用sql script

王朝mssql·作者佚名  2008-05-31
窄屏简体版  字體: |||超大  

CREATE TABLESPACE "apps"

DATAFILE '/db/oradata/apps01.dbf' SIZE 1000M,

'/db/oradata/apps02.dbf' SIZE 1000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENTAUTO ;

CREATE TEMPORARY TABLESPACE "TEMP"

TEMPFILE '/db/oradata/temp01.dbf' SIZE 1000M EXTENT MANAGEMENT

LOCAL UNIFORM SIZE 1M;

CREATE USER "apps" IDENTIFIED BY "apps"

DEFAULT TABLESPACE "apps"

TEMPORARY TABLESPACE "TEMP"

ACCOUNT UNLOCK;

GRANT "CONNECT" TO "INTEGRATION";

GRANT "RESOURCE" TO "INTEGRATION";

alter database add logfile group 1 ('D:\Oracle\ORADATA\orcl1\REDO01.LOG') size 1M;

alter database drop logfile group 1;

alter system switch logfile;

alter database backup controlfile to trace ;

select a.name,a.value,b.name,b.value,(a.value*100)/b.value'%' "radio"

from v$sysstat a,v$sysstat b

where a.name='redo buffer allocation retries'

and b.name='redo entries';

这个比率小于1%才好,否则增加log_buffer的大小

select * from v$nls_parameters

select banner from sys.v_$version

set long 20000

十进制转十六进制 select to_char(33,'xxxx') from dual

drop table table_name cascade constraints;

alter table test move tablespace apps

/*索引重建*/

alter index index_name rebuild tablespace tablespace_name;

select /*+ index(tablename index_name)*/ from tablename

 
 
 
免责声明:本文为网络用户发布,其观点仅代表作者个人观点,与本站无关,本站仅提供信息存储服务。文中陈述内容未经本站证实,其真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
© 2005- 王朝網路 版權所有 導航