SQL 實例

查 DataBase 的語系

2013-07-29 18:27
  SQL> col PARAMETER format a30 SQL> col VALUE format a50 SQL> set pages 5000 line 200 SQL> select * from v$nls_parameters;   PARAMETER       VALUE ------------------------------ -------------------------------------------------- NLS_LANGUAGE ...

查使用者自己的 table

2013-07-29 18:24
SQL> select * from tab;   TNAME                          TABTYPE  CLUSTERID ------------------------------ ------- ---------- CALL                      ...

查某一位使用者所擁有的 Table

2013-07-26 13:42
SQL> set pagesize 100 SQL> column owner format a20 SQL> column OBJECT_NAME format a20 SQL> select owner,object_name from dba_objects where owner='VOIP' and object_type='TABLE';   OWNER              ...

查 Datafile 大小

2013-07-26 13:34
[oracle@SIPDB ~]$ sqlplus / as sysdba   SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 26 13:31:48 2013   Copyright (c) 1982, 2009, Oracle.  All rights reserved.     Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit...

查目前各 user 的 session 數

2013-06-26 17:02
select nvl(username,0),count(*) from v$session group by username order by count(*);  
<< 1 | 2 | 3