oracle sql 备忘

select userenv('language') from dual;

 

select * from v$version;

 

select * from nls_session_parameters;     // 来源于v$nls_parameters

 

select * from nls_instance_parameters;    // 来源于v$parameter

 

select * from nls_database_parameters;  // 来源于props$

 

Startup nomount;
Alter database mount exclusive;
Alter system enable restricted session;
Alter system set job_queue_process=0;
Alter database open;
Alter database character set zhs16gbk;