oracle:
授权Debug:
grant debug any procedure, debug connect session to NFS_XX;
Create dba user:
create user farex identified by “farex”;
grant connect, dba to farex;
grant create any trigger, create any view, create table, drop any view to farex;
grant exp_full_database, imp_full_database, resource, create any sequence to farex;
connect farex/farex@farexdev
select name from v$database; 查看所有database
select instance_name from v$instance; 查看当前实例
man 查看命令帮助信息
#date 查看当前系统时间
#date mmddHHMMyyyy 修改系统时间 月日时分年
创建oracle spfile
create spfile from pfile;
restart db
alter system set processes=300 scopt=spfile;
restart db
select count(*) from v$process;
select value from v$parameter where name=”processes”;
nvl(v1,v2) v1不为空则返回v1,否则返回v2
Decode(表达式,值1,返回值1,值2,返回值2,...,default)
select NUM_ROWS,TABLE_NAME from dba_all_tables t where t.owner=’USER’;