|
prompt <a name="Parameter_name"></a>
prompt <font size="+2" face="Arial,sans-serif" color="#336699"><b>Parameter name</b></font><hr align="left" width="460">
select count(*) as process_count from v$process;
select value as process_value from v$parameter where name = ‘processes‘;
select count(*) as session_count from v$session;
select value as session_value from v$parameter where name = ‘sessions‘;
select count(*) num_curs from v$open_cursor o,v$session s where o.sid=s.sid;
select t.NAME,t.VALUE,t.DISPLAY_VALUE,t.ISDEFAULT,t.ISDEPRECATED from v$parameter t where t.NAME like ‘%cursor%‘;
prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
prompt <a name="Timezone"></a>
prompt <font size="+2" face="Arial,sans-serif" color="#336699"><b>Timezone of db and session</b></font><hr align="left" width="460">
select dbtimezone from dual;
select sessiontimezone from dual;
prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
prompt <a name="SCHEDULER_STIME"></a>
prompt <font size="+2" face="Arial,sans-serif" color="#336699"><b>SCHEDULER JOB STIME</b></font><hr align="left" width="460">
select DBMS_SCHEDULER.STIME from dual;
prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p>
prompt <a name="Component_name"></a>
prompt <font size="+2" face="Arial,sans-serif" color="#336699"><b>Component name</b></font><hr align="left" width="460">
SELECT t.comp_id,t.comp_name,t.status,t.schema,t.procedure,t.modified FROM dba_registry t;
prompt <center>[<a class="noLink" href="#top">Top</a>]</center><p> （编辑：网站开发网_盐城站长网 ）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
