Table of Contents
Oracle Database 12c Data Temp RedoLog Files
Container Temporary Data FIles
Pluggable Temporary Data Files
select con_id,name,open_mode from v$pdbs;
|
CON_ID |
NAME |
OPEN_MODE |
|
2 |
PDB$SEED |
READ ONLY |
|
3 |
PDBDEV1 |
READ WRITE |
|
4 |
PDBDEV1NEW1 |
READ ONLY |
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
SQL> select instance_name,host_name,version,platform_name from v$instance,V$database where upper(v$instance.instance_name)=V$database.NAME
INSTANCE_NAME, HOST_NAME, VERSION, PLATFORM_NAME
mof, trezor, 12.1.0.2.0, Solaris[tm] OE (64-bit)
SQL> select file#, creation_time, bytes/(1024*1024*1024) SizeInGb,name, con_id from v$datafile;
|
FILE# |
CREATION_TIME |
SIZEINGB |
NAME |
CON_ID |
||||
|
1 |
08-Jul-14 07:15:40 |
0.791015625 |
/u01/app/oracle/oradata/mof/system01.dbf |
1 |
||||
|
3 |
08-Jul-14 07:16:50 |
1.5234375 |
/u01/app/oracle/oradata/mof/sysaux01.dbf |
1 |
||||
|
4 |
08-Jul-14 11:41:46 |
0.2978515625 |
/u01/app/oracle/oradata/mof/undotbs01.dbf |
1 |
||||
|
5 |
11-Sep-15 17:40:08 |
0.244140625 |
/u01/app/oracle/oradata/mof/pdbseed/system01.dbf |
2 |
||||
|
6 |
08-Jul-14 07:18:37 |
0.0048828125 |
/u01/app/oracle/oradata/mof/users01.dbf |
1 |
||||
|
7 |
11-Sep-15 17:40:08 |
0.537109375 |
/u01/app/oracle/oradata/mof/pdbseed/sysaux01.dbf |
2 |
||||
|
8 |
11-Sep-15 17:58:20 |
0.2734375 |
/u01/app/oracle/oradata/mof/pdbdev1/system01.dbf |
3 |
||||
|
9 |
11-Sep-15 17:58:20 |
0.634765625 |
/u01/app/oracle/oradata/mof/pdbdev1/sysaux01.dbf |
3 |
||||
|
10 |
11-Sep-15 17:58:20 |
0.0048828125 |
/u01/app/oracle/oradata/mof/pdbdev1/SAMPLE_SCHEMA_users01.dbf |
3 |
||||
|
11 |
11-Sep-15 17:58:20 |
1.2554931640625 |
/u01/app/oracle/oradata/mof/pdbdev1/example01.dbf |
3 |
||||
|
13 |
11-Sep-15 18:57:01 |
4 |
/u01/app/oracle/oradata/mof/pdbdev1/dev1.dbf |
3 |
||||
|
14 |
04-Dec-15 16:57:13 |
0.2734375 |
/u01/app/oracle/oradata/mof/pdbdev1new1/system01.dbf |
4 |
||||
|
15 |
04-Dec-15 16:57:13 |
0.634765625 |
/u01/app/oracle/oradata/mof/pdbdev1new1/sysaux01.dbf |
4 |
||||
|
16 |
04-Dec-15 16:57:13 |
0.0048828125 |
/u01/app/oracle/oradata/mof/pdbdev1new1/SAMPLE_SCHEMA_users01.dbf |
4 |
||||
|
17 |
04-Dec-15 16:57:13 |
1.2554931640625 |
/u01/app/oracle/oradata/mof/pdbdev1new1/example01.dbf |
4 |
||||
|
18 |
04-Dec-15 16:57:13 |
4 |
/u01/app/oracle/oradata/mof/pdbdev1new1/dev1.dbf |
4 |
||||
SQL> select file_id,TABLESPACE_NAME,FILE_NAME from dba_data_files;
|
FILE_ID |
TABLESPACE_NAME |
FILE_NAME |
|
6 |
USERS |
/u01/app/oracle/oradata/mof/users01.dbf |
|
4 |
UNDOTBS1 |
/u01/app/oracle/oradata/mof/undotbs01.dbf |
|
1 |
SYSTEM |
/u01/app/oracle/oradata/mof/system01.dbf |
|
3 |
SYSAUX |
/u01/app/oracle/oradata/mof/sysaux01.dbf |
SQL> select file_id,TABLESPACE_NAME,FILE_NAME,con_id
from cdb_data_files order by 1;
|
FILE_ID |
TABLESPACE_NAME |
FILE_NAME |
CON_ID |
||
|
1 |
SYSTEM |
/u01/app/oracle/oradata/mof/system01.dbf |
1 |
||
|
3 |
SYSAUX |
/u01/app/oracle/oradata/mof/sysaux01.dbf |
1 |
||
|
4 |
UNDOTBS1 |
/u01/app/oracle/oradata/mof/undotbs01.dbf |
1 |
||
|
6 |
USERS |
/u01/app/oracle/oradata/mof/users01.dbf |
1 |
||
|
8 |
SYSTEM |
/u01/app/oracle/oradata/mof/pdbdev1/system01.dbf |
3 |
||
|
9 |
SYSAUX |
/u01/app/oracle/oradata/mof/pdbdev1/sysaux01.dbf |
3 |
||
|
10 |
USERS |
/u01/app/oracle/oradata/mof/pdbdev1/SAMPLE_SCHEMA_users01.dbf |
3 |
||
|
11 |
EXAMPLE |
/u01/app/oracle/oradata/mof/pdbdev1/example01.dbf |
3 |
||
|
13 |
DEV1 |
/u01/app/oracle/oradata/mof/pdbdev1/dev1.dbf |
3 |
||
|
14 |
SYSTEM |
/u01/app/oracle/oradata/mof/pdbdev1new1/system01.dbf |
4 |
||
|
15 |
SYSAUX |
/u01/app/oracle/oradata/mof/pdbdev1new1/sysaux01.dbf |
4 |
||
|
16 |
USERS |
/u01/app/oracle/oradata/mof/pdbdev1new1/SAMPLE_SCHEMA_users01.dbf |
4 |
||
|
17 |
EXAMPLE |
/u01/app/oracle/oradata/mof/pdbdev1new1/example01.dbf |
4 |
||
|
18 |
DEV1 |
/u01/app/oracle/oradata/mof/pdbdev1new1/dev1.dbf |
4 |
||
SQL> alter session set container=PDBDEV1;
SQL> show con_name
CON_NAME
------------------------------
PDBDEV1
SQL> select file_id,TABLESPACE_NAME,FILE_NAME from dba_data_files;
|
FILE_ID |
TABLESPACE_NAME |
FILE_NAME |
|
8 |
SYSTEM |
/u01/app/oracle/oradata/mof/pdbdev1/system01.dbf |
|
9 |
SYSAUX |
/u01/app/oracle/oradata/mof/pdbdev1/sysaux01.dbf |
|
10 |
USERS |
/u01/app/oracle/oradata/mof/pdbdev1/SAMPLE_SCHEMA_users01.dbf |
|
11 |
EXAMPLE |
/u01/app/oracle/oradata/mof/pdbdev1/example01.dbf |
|
13 |
DEV1 |
/u01/app/oracle/oradata/mof/pdbdev1/dev1.dbf |
SQL> alter session set container=CDB$ROOT
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
select file#, creation_time, bytes/(1024*1024*1024) SizeInGb,name, con_id from v$tempfile
|
FILE# |
CREATION_TIME |
SIZEINGB |
NAME |
CON_ID |
|
1 |
11-Sep-15 17:39:16 |
0.1923828125 |
/u01/app/oracle/oradata/mof/temp01.dbf |
1 |
|
2 |
11-Sep-15 17:40:08 |
0.09765625 |
/u01/app/oracle/oradata/mof/pdbseed/pdbseed_temp012015-09-11_05-40-07-PM.dbf |
2 |
|
3 |
11-Sep-15 17:58:20 |
0.1923828125 |
/u01/app/oracle/oradata/mof/pdbdev1/pdbdev1_temp012015-09-11_05-58-20-PM.dbf |
3 |
|
4 |
04-Dec-15 16:57:13 |
0.01953125 |
/u01/app/oracle/oradata/mof/pdbdev1new1/pdbdev1_temp012015-09-11_05-58-20-PM.dbf |
4 |
select file_id,TABLESPACE_NAME,FILE_NAME from DBA_TEMP_FILES;
|
FILE_ID |
TABLESPACE_NAME |
FILE_NAME |
|
1 |
TEMP |
/u01/app/oracle/oradata/mof/temp01.dbf |
SQL> alter session set container=PDBDEV1;
SQL> show con_name
CON_NAME
------------------------------
PDBDEV1
select file_id,TABLESPACE_NAME,FILE_NAME from DBA_TEMP_FILES
|
FILE_ID |
TABLESPACE_NAME |
FILE_NAME |
|
3 |
TEMP |
/u01/app/oracle/oradata/mof/pdbdev1/pdbdev1_temp012015-09-11_05-58-20-PM.dbf |
,/u01/app/oracle/oradata/mof/pdbdev1/pdbdev1_temp012015-09-11_05-58-20-PM.dbf
SQL> alter session set container=CDB$ROOT
SQL> show con_name
CON_NAME
------------------------------
CDB$ROOT
select MEMBER from v$logfile;
V$DATAFILE - http://docs.oracle.com/database/121/REFRN/GUID-7BF7955C-9705-40F4-B2F6-5D7F3A32DD30.htm#REFRN30050
V$LOGFILE - http://docs.oracle.com/database/121/REFRN/GUID-AE0B85B3-6B51-4FBD-A460-2D7090D9E0B5.htm#REFRN30129
DBA_DATA_FILES - http://docs.oracle.com/database/121/REFRN/GUID-0FA17297-73ED-4B5D-B511-103993C003D3.htm#REFRN23049