View Oracle 10g View

oracle| View
View Oracle 10g View



1, view the name of the database and file status



Sql> select Name,log_mode from V$database;



NAME Log_mode

--------- ------------

HB130000 Archivelog





2, view the database instance name and status



Sql> select Instance_name,status from V$instance;



instance_name STATUS

---------------- ------------

hb130000 OPEN



3, view the table space name, status and Management methods



Sql> select Tablespace_name,status,extent_management from Dba_tablespaces;



Tablespace_name STATUS Extent_man

------------------------------ --------- ----------

SYSTEM ONLINE Local

UNDOTBS1 ONLINE Local

Sysaux ONLINE Local

TEMP ONLINE Local

USERS ONLINE Local

GFB ONLINE Local

YSZX130000002004 ONLINE Local

RMAN ONLINE Local



8 rows selected.

4. View the location and name of the control file



Sql> select name from V$controlfile;



NAME

/oracle/app/oracle/orahome/dbs/hb130000/control01.ctl

/oradata/hb130000/control02.ctl

/oradata/hb130000/control03.ctl



5. View the group name, number of members, status, and size of the log file



Sql> select Group#,members,bytes,status from V$log;



group# members BYTES STATUS

---------- ---------- ---------- ----------------

1 2 52428800 INACTIVE

2 2 52428800 INACTIVE

3 2 52428800 Current



6, view the location of the log files



Sql> select Group#,member from V$logfile;



group#

----------

Member

3

/oradata/hb130000/redo03.log



3

/oracle/app/oracle/orahome/dbs/hb130000/redo03.rdo



2

/oradata/hb130000/redo02.log





group#

----------

Member

2

/oracle/app/oracle/orahome/dbs/hb130000/redo02.rdo



1

/oradata/hb130000/redo01.log



1

/oracle/app/oracle/orahome/dbs/hb130000/redo01.rdo





6 rows selected.



7. View the location and size of the data file



Sql> select Name,bytes from V$datafile;



NAME

BYTES

----------

/oradata/hb130000/system01.dbf

492830720



/oradata/hb130000/undotbs01.dbf

41943040



/oradata/hb130000/sysaux01.dbf

346030080





NAME

BYTES

----------

/oradata/hb130000/users01.dbf

5242880



/oradata/hb130000/gfb. Dbf

20971520



/oradata/hb130000/yszx130000002004. Dbf

176160768





NAME

BYTES

----------

/oradata/hb130000/rman.dbf

104857600





7 rows selected.



8. View user-owned objects and types



Sql> Select Object_name,object_type from dba_objects where owner= ' SCOTT ';



object_name

Object_type

--------------------------------------------------------------------------------

------------------------------------------------ -------------------

DEPT

TABLE

Pk_dept

INDEX

Emp

TABLE

Pk_emp

INDEX

BONUS

TABLE

Salgrade

TABLE



6 rows selected.



9, view the temporary file information



Sql> select Name,bytes from V$tempfile;



NAME

BYTES

----------

/oradata/hb130000/temp01.dbf

20971520



10. View archived Log Information



Sql> select Name, first_change#,next_change# from V$archived_log;



NAME

--------------------------------------------------------------------------------

first_change# next_change#

------------- ------------

/oracle/app/oracle/orahome/dbs/archive/hb130000_1_53_532853380.dbf

1669178 1707392



/oracle/app/oracle/orahome/dbs/archive/hb130000_1_54_532853380.dbf

1707392 1734524



/oracle/app/oracle/orahome/dbs/archive/hb130000_1_55_532853380.dbf

1734524 1772848





NAME

--------------------------------------------------------------------------------

first_change# next_change#

------------- ------------

/oracle/app/oracle/orahome/dbs/archive/hb130000_1_56_532853380.dbf

1772848 1798092



/oracle/app/oracle/orahome/dbs/archive/hb130000_1_57_532853380.dbf

1798092 1831478



/oracle/app/oracle/orahome/dbs/archive/hb130000_1_58_532853380.dbf

1831478 1865033