Tuesday, December 24, 2013

decode/unwrap .plb file

find a useful link http://www.codecrete.net/UnwrapIt/, helped to see what is inside the hotfix in .plb format.

With this we are have a bit confidence to roll it out to production, while waiting for further detail explanation from vendor.



to relevant utility to create plb file is  DBMS_DDL.CREATE_WRAPPED.

more info http://www.orafaq.com/wiki/PL/SQL_FAQ

How can I protect my PL/SQL source code?

Oracle provides a binary wrapper utility that can be used to scramble PL/SQL source code. This utility was introduced in Oracle7.2 (PL/SQL V2.2) and is located in the ORACLE_HOME/bin directory.
The utility use human-readable PL/SQL source code as input, and writes out portable binary object code (somewhat larger than the original). The binary code can be distributed without fear of exposing your proprietary algorithms and methods. Oracle will still understand and know how to execute the code. Just be careful, there is no "decode" command available. So, don't lose your source!
The syntax is:
wrap iname=myscript.pls oname=xxxx.plb
Please note: there is no legal way to unwrap a *.plb binary file. You are supposed to backup and keep your *.pls source files after wrapping them. However it is possible for skilled hackers to unwrap your wrapped Oracle PL/SQL code.

How can I know which stored PL/SQL code is wrapped?

The following query gives the list of all wrapped PL/SQL code:
select owner, name, type
from dba_source
where line = 1
  and instr(text, ' wrapped'||chr(10))+instr(text, ' wrapped '||chr(10)) > 0
order by 1, 2, 3
/


Monday, November 18, 2013

ORA-14064: Index with Unusable partition exists on unique/primary constraint key

Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
ORA-39083: Object type CONSTRAINT failed to create with error:
ORA-14064: Index with Unusable partition exists on unique/primary constraint key
Failing sql is:...

hit above error with datapump import.

check STATUS in dba_ind_partitions , where some partitions are in  UNUSABLE state.

select index_owner,index_name, PARTITION_name,status from dba_ind_partitions where  status <>'USABLE' ORDER BY 1;


P2013_09_19                    USABLE
P2013_09_22                    USABLE
P2013_10_01                    UNUSABLE
P2013_10_07                    USABLE
P2013_10_11                    USABLE
P2013_10_14                    UNUSABLE
P2013_10_19                    USABLE

...

rebuild the index partition

Select 'ALTER INDEX '||index_owner||'.'|| index_name ||' rebuild partition ' || PARTITION_NAME ||';' from dba_ind_partitions where  status <>'USABLE' ORDER BY 1;

re-export the dump.

Monday, October 28, 2013

Drop PRIMARY KEY constraint

1. create the test tables with primary key and foreign key

SYS@testdb> CONN user1
Connected.

user1@testdb>
user1@testdb> create table emp (emp_id number constraint emp_pk primary key );

Table created.

user1@testdb> create table empinfo ( emp_name varchar2(10), emp_id number references emp(emp_id));

Table created.

user1@testdb> drop table emp;
drop table emp
           *
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys



user1@testdb> insert into emp values(1);

1 row created.

user1@testdb> insert into empinfo values ('li',2);
insert into empinfo values ('li',2)
*
ERROR at line 1:
ORA-02291: integrity constraint (user1.SYS_C0044749) violated - parent key
not found


user1@testdb>  insert into empinfo values ('li',1);

1 row created.

user1@testdb> commit;

Commit complete.


2. attemp to drop parent table emp, even failed after diable both primary and foreign key constraints.

user1@testdb> drop table emp;
drop table emp
           *
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys




user1@testdb> select table_name, constraint_name, constraint_type, r_constraint_name, status from dba_constraints
  2  where table_name in ('EMP','EMPINFO');

TABLE_NAME                     CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
R_CONSTRAINT_NAME              STATUS
------------------------------ --------
EMPINFO                        SYS_C0044749                   R
EMP_PK                         ENABLED

EMP                            EMP_PK                         P
                               ENABLED


user1@testdb>  alter table empinfo disable constraint SYS_C0044749 ;

Table altered.

user1@testdb> drop table emp;
drop table emp
           *
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys


user1@testdb>  alter table emp  disable constraint EMP_PK;

Table altered.

user1@testdb>  drop table emp;
 drop table emp
            *
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys


user1@testdb>  drop table emp cascade constraint;

Table dropped.

user1@testdb> select table_name, constraint_name, constraint_type, r_constraint_name, status from dba_constraints where table_name in ('EMP','EMPINFO');

no rows selected

user1@testdb> select * from empinfo;

EMP_NAME       EMP_ID
---------- ----------
li                  1


3. create backup the parent table after changes made to it. e.g partition it.

user1@testdb>  create table emp (emp_id number constraint emp_pk primary key );

Table created.



user1@testdb>  alter table empinfo add constraint empinfo_fk foreign key (emp_id) references emp(emp_id);
 alter table empinfo add constraint empinfo_fk foreign key (emp_id) references emp(emp_id)
                                    *
ERROR at line 1:
ORA-02298: cannot validate (user1.EMPINFO_FK) - parent keys not found


user1@testdb> insert into emp values(1);

1 row created.

user1@testdb>  alter table empinfo add constraint empinfo_fk foreign key (emp_id) references emp(emp_id);

Table altered.

user1@testdb> select table_name, constraint_name, constraint_type, r_constraint_name, status from dba_constraints
  2   where table_name in ('EMP','EMPINFO');

TABLE_NAME                     CONSTRAINT_NAME                C
------------------------------ ------------------------------ -
R_CONSTRAINT_NAME              STATUS
------------------------------ --------
EMPINFO                        EMPINFO_FK                     R
EMP_PK                         ENABLED

EMP                            EMP_PK                         P
                               ENABLED


Conclusion:

drop table with cascade constraint is the must.

Thursday, October 24, 2013

How To Convert .MTS Video Files (AVCHD) To Other Formats On Ubuntu

x-terminal-emulator: error: Additional unexpected arguments found: ['&']
ConfigBase::load: Unable to open /home/hmc/.config/terminator/config ([Errno 2] No such file or directory: '/home/hmc/.config/terminator/config')
Usage: x-terminal-emulator [options]

x-terminal-emulator: error: Additional unexpected arguments found: ['&']


http://www.upubuntu.com/2011/11/how-to-convert-mts-video-files-avchd-to.html
http://ubuntuforums.org/showthread.php?t=1541808


Look in WinFF's edit > preferences > linux > set terminal options
Change it from e to x, or vice versa. Then try it again.

 Size
hmc@hmc-P55A-UD3:~/Desktop/20131023/STREAM$ ls -l 00008.MTS
-rw-r--r-- 1 hmc hmc 83171328 Oct 23 20:02 00008.MTS

hmc@hmc-P55A-UD3:~/Desktop/20131023/STREAM$ ls -l ../
total 276068
-rw-rw-r-- 1 hmc hmc   8104429 Oct 24 00:43 00008_high.mp4
-rw-rw-r-- 1 hmc hmc 238273943 Oct 24 00:55 00008_superhigh.mp4
-rw-rw-r-- 1 hmc hmc  36299619 Oct 24 01:02 00008_very_high.mp4


Conclusion: the best video quality is the .MTS

Wednesday, October 23, 2013

CreateOUIProcess(): 13 : Permission denied

Hit the error when install 11.2.0.3 client on Redhat 5.4 x64

[oracle@test01 client]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 664 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2001-07-23_06-31-05AM. Please wait ...Error in CreateOUIProcess(): 13 : Permission denied


[oracle@test01 client]$ cd /tmp/OraInstall2001-07-23_06-31-05AM
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l
total 44
-rwxr-x--- 1 oracle dba 8218 Jul 23 06:31 command_output_8385
drwxr-x--- 3 oracle dba 4096 Jul 23 06:31 diagnostics
drwxrwx--- 3 oracle dba 4096 Jul 23 06:31 ext
drwxr-x--- 2 oracle dba 4096 Jul 23 06:31 images
-rwxr-x--- 1 oracle dba 4855 Jul 23 06:31 installActions2001-07-23_06-31-05AM.log
drwxr-x--- 6 oracle dba 4096 Jul 23 06:31 jdk
drwxr-x--- 8 oracle dba 4096 Jul 23 06:31 oui
drwxr-x--- 3 oracle dba 4096 Jul 23 06:31 srvm
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ find ./ -name java
./jdk/jre/bin/java
./jdk/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l ./jdk/jre/bin/java
-rwxr-xr-x 1 oracle dba 66432 Jul 11  2011 ./jdk/jre/bin/java
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ls -l ./jdk/bin/java
-rwxr-x--- 1 oracle dba 66432 Jul 11  2011 ./jdk/bin/java

[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ./jdk/jre/bin/java -version
-bash: ./jdk/jre/bin/java: Permission denied
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ ./jdk/bin/java  -version
-bash: ./jdk/bin/java: Permission denied
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ file ./jdk/bin/java
./jdk/bin/java: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), for GNU/Linux 2.4.0, stripped
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ file ./jdk/bin/java
./jdk/bin/java: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), for GNU/Linux 2.4.0, stripped
[oracle@test01 OraInstall2001-07-23_06-31-05AM]$ grep tmp /etc/fstab
/dev/vgvolume/lv_tmp    /tmp                    ext3    defaults,nodev,nosuid,noexec  1 2
/tmp                    /var/tmp                none    bind            0 0
tmpfs                   /dev/shm                tmpfs   defaults,nodev,nosuid,noexec  0 0

problem solved by following below URL

http://muthuappsdba.blogspot.sg/2013/02/error-in-createouiprocess-13-permission.html
http://pythianpang.wordpress.com/2010/06/03/oracle-runinstaller-createouiprocess-13-permission-denied/
http://kb.dbatoolz.com/tp/2817.error_in_createouiprocess_13.html

Solution :

 temporarily remove noexec option from /tmp

Or redirect TMP and TMPDIR environment variables to other directory
  


 

Tuesday, October 22, 2013

Some info about initrans fround from blogs and Oracle docs

From internet blogs

When a session requires a slot but all the available ones are in use by other ac􀀠ve transac􀀠ons, the database engine tries to dynamically create a new
slot. This is of course only possible when a) the maximum number of slots was not already allocated b) enough free space (one slot occupies 24 bytes) is
available in the block itself. If a new slot cannot be created, the session requiring it hits a so-called ITL wait. Note that the name of the actual wait event is
called “enq: TX – allocate ITL entry”.
It is essen􀀠al to point out that a session does not wait on the first slot becoming free. Instead, it probes, round-robin, the available slots to find out one
that becomes free. And, while doing so, it waits few seconds on every one it probes. When during this short wait the slot becomes free, it uses it.
Otherwise, it tries with another slot.


http://www.oracle-base.com/forums/viewtopic.php?f=1&t=4078  , says

Let's say you have a block that has five records in it. Let's also say that simultaneously five people update each of the records in the block. The block is taking part in 5 transactions. Space is required in the block to keep track of all this stuff. That's was these parameters are for. The initrans reserves a minimum amount of space in the block that can be used, the maxtrans specifies the maximum amount of space in the block that can be used to hold this information.

If you use locally managed tablespaces with automatic segment space management you can more or less forget about these parameters as Oracle takes care of it for you. In the past they were much more important that they are now. 


Is above in red true ? Can experts advise ?


Searched from Entire Library of 11gR2 Oracle docs

Database Performance Tuning Guide

10 Instance Tuning Using Performance Views



  • Waits for TX in mode 4 can occur if the session is waiting for an ITL (interested transaction list) slot in a block. This happens when the session wants to lock a row in the block but one or more other sessions have rows locked in the same block, and there is no free ITL slot in the block. Usually, Oracle Database dynamically adds another ITL slot. This may not be possible if there is insufficient free space in the block to add an ITL. If so, the session waits for a slot with a TX enqueue in mode 4. This type of TX enqueue wait corresponds to the wait event enq: TX - allocate ITL entry.
    The solution is to increase the number of ITLs available, either by changing the INITRANS or MAXTRANS for the table (either by using an ALTER statement, or by re-creating the table with the higher values).

Data Guard Concepts and Administration

A Troubleshooting Data Guard


Troubleshooting ITL Pressure
Interested transaction list (ITL) pressure is reported in the alert log of the SQL Apply instance. Example A-3 shows an example of the warning messages.
 ...
Resolving ITL Pressure
To increase the INITRANS integer for a particular database object, it is necessary to first stop SQL Apply.


Database VLDB and Partitioning Guide
11g Release 2 (11.2)

Miscellaneous Parallel Execution Tuning Tips

Increasing INITRANS

If you have global indexes, a global index segment and global index blocks are shared by server processes of the same parallel DML statement. Even if the operations are not performed against the same row, the server processes can share the same index blocks. Each server transaction needs one transaction entry in the index block header before it can make changes to a block. Therefore, in the CREATE INDEX or ALTER INDEX statements, you should set INITRANS, the initial number of transactions allocated within each data block, to a large value, such as the maximum DOP against this index.

Database Concepts
11g Release 2 (11.2)

9 Data Concurrency and Consistency


Read Consistency and Transaction Tables
The database uses information in the block header, also called an interested transaction list (ITL), to determine whether a transaction was uncommitted when the database began modifying the block. The block header of every segment block contains an ITL.
Entries in the ITL describe which transactions have rows locked and which rows in the block contain committed and uncommitted changes. The ITL points to the transaction table in the undo segment, which provides information about the timing of changes made to the database.
In a sense, the block header contains a recent history of transactions that affected each row in the block. The INITRANS parameter of the CREATE TABLE and ALTER TABLE statements controls the amount of transaction history that is kept.

Database Performance Tuning Guide
11g Release 2 (11.2)

8 I/O Configuration and Design


8.2.6.2 Writes

For high-concurrency OLTP systems, consider appropriate values for INITRANS, MAXTRANS, and FREELISTS when using a larger block size. These parameters affect the degree of update concurrency allowed within a block. However, you do not need to specify the value for FREELISTS when using automatic segment-space management.
If you are uncertain about which block size to choose, then try a database block size of 8 KB for most systems that process a large number of transactions. This represents a good compromise and is usually effective. Only systems processing LOB data need more than 8 KB.

Object type of Foreign Key in DBMS_METADATA.GET_DDL

It is REF_CONSTRAINT  for referential constraint, not CONSTRAINT

Wednesday, October 09, 2013

Forgot to backup REDO files for a NOARCHIVELOG database

1. startup database after restore from cold backup but failed.

testdb05d:/oradata/dmdb> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:21:54 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  638947328 bytes
Fixed Size                  2224008 bytes
Variable Size             515899512 bytes
Database Buffers          104857600 bytes
Redo Buffers               15966208 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 30933094
Session ID: 254 Serial number: 3


SYS@dmdb> exit



ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_lgwr_23199918.trc:
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
ORA-00338: log 1 of thread 1 is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
Errors in file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_ora_30933094.trc:
ORA-00338: log 1 of thread  is more recent than control file
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1a_spda.log'
ORA-00312: online log 1 thread 1: '/oralog/redo/dmdb/redo_1b_spda.log'
USER (ospid: 30933094): terminating the instance due to error 338
System state dump requested by (instance=1, osid=30933094), summary=[abnormal instance termination].
System State dumped to trace file /oradump/diag/rdbms/dmdb/dmdb/trace/dmdb_diag_9502970.trc
Dumping diagnostic data in directory=[cdmp_20131002112203], requested by (instance=1, osid=30933094), summary=[abnormal insta
nce termination].
Instance terminated by USER, pid = 30933094



2. investigate and realized the cold backup set didn't include REDO files

testdb05d:/oralog/redo/dmdb> ls -l
total 2457696
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:48 redo_1a_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:48 redo_1b_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:55 redo_2a_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:55 redo_2b_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:33 redo_3a_spda.log
-rw-rw----    1 oracle8  dba       209715712 Oct 02 10:33 redo_3b_spda.log
testdb05d:/oralog/redo/dmdb> ps -fe |grep dmdb
 oracle8 21758072  5505062   0 11:26:53  pts/0  0:00 grep dmdb
testdb05d:/oralog/redo/dmdb> df -k  ./
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/oralog       5242880   4012868   24%       25     1% /oralog


3. continue to clear REDO files and succeeded.

testdb05d:/oralog/redo/dmdb> cd ..
testdb05d:/oralog/redo> ls
dmdb
testdb05d:/oralog/redo> mv dmdb dmdb_1002
testdb05d:/oralog/redo> mkdir dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:28:54 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option

SYS@blus> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> dmdb
testdb05d:/oralog/redo> sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Oct 2 11:29:00 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SYS@dmdb> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  638947328 bytes
Fixed Size                  2224008 bytes
Variable Size             515899512 bytes
Database Buffers          104857600 bytes
Redo Buffers               15966208 bytes
Database mounted.
SYS@dmdb> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SYS@dmdb> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES  BLOCKSIZE    MEMBERS ARC
---------- ---------- ---------- ---------- ---------- ---------- ---
STATUS           FIRST_CHANGE# FIRST_TIME          NEXT_CHANGE#
---------------- ------------- ------------------- ------------
NEXT_TIME
-------------------
         1          1       6070  209715200        512          2 NO
INACTIVE               3703950 2013-09-27 22:18:32      3704357
2013-09-27 22:33:33

         3          1       6072  209715200        512          2 NO
CURRENT                3704765 2013-09-27 22:48:34   2.8147E+14


         2          1       6071  209715200        512          2 NO
INACTIVE               3704357 2013-09-27 22:33:33      3704765
2013-09-27 22:48:34


SYS@dmdb> alter database clear logfile group 1;

Database altered.

SYS@dmdb> alter database clear logfile group 2;

Database altered.

SYS@dmdb> alter database clear logfile group 3;

Database altered.

SYS@dmdb> select member from V$logfile;

MEMBER
--------------------------------------------------------------------------------
/oralog/redo/dmdb/redo_1a_spda.log
/oralog/redo/dmdb/redo_1b_spda.log
/oralog/redo/dmdb/redo_2a_spda.log
/oralog/redo/dmdb/redo_2b_spda.log
/oralog/redo/dmdb/redo_3a_spda.log
/oralog/redo/dmdb/redo_3b_spda.log

6 rows selected.

SYS@dmdb> alter database open;

Database altered.

SYS@dmdb> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SYS@dmdb> startup
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area  638947328 bytes
Fixed Size                  2224008 bytes
Variable Size             515899512 bytes
Database Buffers          104857600 bytes
Redo Buffers               15966208 bytes
Database mounted.
Database opened.
SYS@dmdb> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning option
testdb05d:/oralog/redo> df -k  /oralog
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/oralog       5242880   2784004   47%       32     1% /oralog



MMNL started with pid=16, OS id=24379452
ORACLE_BASE from environment = /oracle/product
Wed Oct 02 11:37:59 2013
ALTER DATABASE   MOUNT
Successful mount of redo thread 1, with mount id 2345657111
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: ALTER DATABASE   MOUNT
Wed Oct 02 11:38:03 2013
ALTER DATABASE OPEN
Block change tracking file is current.
Thread 1 opened at log sequence 6074
  Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
  Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Successful open of redo thread 1
Starting background process CTWR
Wed Oct 02 11:38:03 2013
CTWR started with pid=18, OS id=30933216
Block change tracking service is active.
SMON: enabling cache recovery
[13893792] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:3198839111 end:3198839153 diff:42 (0 seconds)
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Oct 02 11:38:04 2013
QMNC started with pid=19, OS id=8323112
Completed: ALTER DATABASE OPEN
Starting background process CJQ0
Wed Oct 02 11:38:04 2013
CJQ0 started with pid=22, OS id=19988686
Incremental checkpoint up to RBA [0x17ba.f88e.0], current log tail at RBA [0x17ba.f8e2.0]
Wed Oct 02 11:38:34 2013
Thread 1 cannot allocate new log, sequence 6075
Private strand flush not complete
  Current log# 2 seq# 6074 mem# 0: /oralog/redo/dmdb/redo_2a_spda.log
  Current log# 2 seq# 6074 mem# 1: /oralog/redo/dmdb/redo_2b_spda.log
Beginning log switch checkpoint up to RBA [0x17bb.2.10], SCN: 3718854
Thread 1 advanced to log sequence 6075 (LGWR switch)
  Current log# 3 seq# 6075 mem# 0: /oralog/redo/dmdb/redo_3a_spda.log
  Current log# 3 seq# 6075 mem# 1: /oralog/redo/dmdb/redo_3b_spda.log

Monday, October 07, 2013

flashback db log size 3 times of AL size

interesting finding.

> du -sk *
10786344        archivelog
30174024        flashback
> ls -lR
total 48
drwxrwx---  50 oracle1    dba1          8192 Oct  1 17:54 archivelog
drwxrwx---   2 oracle1    dba1         16384 Oct  2 00:06 flashback

...

./archivelog/2013_10_01:
total 21572480
-rw-r-----   1 oracle1    dba1       1854297088 Oct  1 17:55 o1_mf_1_166081_94o6yvnp_.arc
-rw-r-----   1 oracle1    dba1       1819378688 Oct  1 17:56 o1_mf_1_166082_94o71ffv_.arc
-rw-r-----   1 oracle1    dba1       1821615104 Oct  1 17:58 o1_mf_1_166083_94o75onb_.arc
-rw-r-----   1 oracle1    dba1       1855338496 Oct  1 18:35 o1_mf_1_166084_94o9cf4t_.arc
-rw-r-----   1 oracle1    dba1       1833089024 Oct  1 19:15 o1_mf_1_166085_94oco8mm_.arc
-rw-r-----   1 oracle1    dba1       1861282816 Oct  1 19:30 o1_mf_1_166086_94odl28d_.arc

./flashback:
total 60348016
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94dzgovx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94dzgzbj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94dzh8rz_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94dzhlfl_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94dzhw0k_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94dzj69y_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:16 o1_mf_94dzjj9z_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:17 o1_mf_94dzjt58_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:17 o1_mf_94dzk3nv_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:18 o1_mf_94dzkfrn_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:18 o1_mf_94dzkn9c_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:24 o1_mf_94f001p7_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:25 o1_mf_94f00c9r_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  2 00:06 o1_mf_94f00nyx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f00vkj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f01c1v_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f01njr_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f01v26_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f024kh_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f02c0j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f02nm9_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94f02v7w_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:00 o1_mf_94f034tl_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:00 o1_mf_94f03ck6_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:00 o1_mf_94f03oc2_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:00 o1_mf_94f03vxc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:00 o1_mf_94f045dx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:00 o1_mf_94f04cwq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:00 o1_mf_94f04ll8_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:01 o1_mf_94f04w2z_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:01 o1_mf_94f052oc_.flb
-rw-r-----   1 oracle1    dba1       49594368 Oct  1 19:01 o1_mf_94gndrfg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:01 o1_mf_94lpmmx3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:01 o1_mf_94lpmqnr_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:01 o1_mf_94lpmyh1_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:01 o1_mf_94lpn5ls_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:01 o1_mf_94lpnd9r_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpnlxw_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpnwoh_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpo3cj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpo9wk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpokfj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpor3v_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpoyvc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpp8kv_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:02 o1_mf_94lpphnw_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lppphc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lppxnb_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lpq7hj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lpqbmy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lpqg40_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lpqj9t_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lpqk7j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lpqn44_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:03 o1_mf_94lpqoh2_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:04 o1_mf_94lpqr3t_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:04 o1_mf_94lpqt1n_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:04 o1_mf_94lqbnrh_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:04 o1_mf_94ls3hls_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:04 o1_mf_94ls3pd8_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:04 o1_mf_94ls3wyr_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:04 o1_mf_94ls43y6_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:05 o1_mf_94ls4c9p_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:05 o1_mf_94ls4kwp_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:05 o1_mf_94ls95x6_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:05 o1_mf_94lsyr3h_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:05 o1_mf_94ltpf7t_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:05 o1_mf_94lttdcg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:05 o1_mf_94lttpcp_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94ltww9c_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94ltx68t_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94ltxp22_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94ltxzop_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94lty9d9_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94ltyj7x_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94ltymtx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:06 o1_mf_94lv20oq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv2bh4_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv2k4o_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv2trd_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv31g4_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv3c1p_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv3no8_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv3vs9_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:07 o1_mf_94lv45r3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:08 o1_mf_94lv4hjq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:08 o1_mf_94lv4s86_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:08 o1_mf_94lv52vy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:08 o1_mf_94lv5dlj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:08 o1_mf_94lv5mgy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:08 o1_mf_94lv5wyv_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:08 o1_mf_94lv66k9_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lv8rr2_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lv8zj7_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lv965y_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lvbc0w_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lvbtlh_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lvc4hj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lvcg2m_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:09 o1_mf_94lvcnk7_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvcv3r_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvd1sm_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvd8d9_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvdh8m_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvdp5q_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvdwxc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvfdn1_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:10 o1_mf_94lvmt24_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:11 o1_mf_94lvsdob_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:11 o1_mf_94lvsmct_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:11 o1_mf_94lvsxgk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:11 o1_mf_94lvt4rm_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:11 o1_mf_94lvtgx7_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:11 o1_mf_94lvtotj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:11 o1_mf_94lw81xf_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:12 o1_mf_94lw8cg2_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:12 o1_mf_94lw8hk6_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:12 o1_mf_94lw8sg1_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:12 o1_mf_94lx3t9c_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:12 o1_mf_94lx3y66_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:12 o1_mf_94lx8lo0_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:12 o1_mf_94lx8p0g_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lx8pd0_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lx8trz_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lx8yg6_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lx92b8_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lx95xp_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lx9hyv_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lxdt6s_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:13 o1_mf_94lxf42m_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94ngfghc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94ngfo8n_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94ngfvqx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94o6z4ho_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94o6z9dy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94o6zjvm_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7h8fh_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7k1cj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7kc2m_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7kv7r_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7lqm1_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7m4bt_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7mkcj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:15 o1_mf_94o7n14o_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:16 o1_mf_94o7o9gk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:16 o1_mf_94o7osd3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:16 o1_mf_94o7pbdl_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:16 o1_mf_94o7pt7w_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:17 o1_mf_94o7r52m_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:17 o1_mf_94o7rnwg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:18 o1_mf_94o7s7lk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:18 o1_mf_94o7t0sg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:19 o1_mf_94o7tx2m_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:19 o1_mf_94o7v72h_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:19 o1_mf_94o7vmss_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:19 o1_mf_94o7w3yc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:20 o1_mf_94o7wjoh_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:20 o1_mf_94o7x0cd_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:20 o1_mf_94o7xf51_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:21 o1_mf_94o7xqdy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:21 o1_mf_94o7y7cj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:21 o1_mf_94o7yn2j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:22 o1_mf_94o7z3po_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:22 o1_mf_94o7zmjj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:22 o1_mf_94o800b0_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:22 o1_mf_94o80jcy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:22 o1_mf_94o80xq9_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:23 o1_mf_94o81fmy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:23 o1_mf_94o81xc5_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:24 o1_mf_94o82b47_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:24 o1_mf_94o8363v_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:24 o1_mf_94o83orx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:24 o1_mf_94o842fg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:24 o1_mf_94o84d43_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:25 o1_mf_94o88khc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  2 09:13 o1_mf_94o8p9nx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  2 11:09 o1_mf_94o8z5go_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o8z9fd_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o8zdx0_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o8zjny_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o8znpq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o8zs5j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o9007o_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o906yr_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:29 o1_mf_94o90fpd_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:30 o1_mf_94o90qjk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:30 o1_mf_94o91171_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:30 o1_mf_94o91fyk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:30 o1_mf_94o91qqg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:30 o1_mf_94o9220s_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:30 o1_mf_94o92ct3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:31 o1_mf_94o92oh3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:31 o1_mf_94o92w6n_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:31 o1_mf_94o93r23_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:31 o1_mf_94o93ysb_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:31 o1_mf_94o945cp_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:31 o1_mf_94o94h3k_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:32 o1_mf_94o94p3y_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:33 o1_mf_94o94zs5_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:33 o1_mf_94o96q5k_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:49 o1_mf_94o970vx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:49 o1_mf_94o977r8_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:49 o1_mf_94ob66mw_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:49 o1_mf_94ob6g0m_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob6ntq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob6rdl_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob6zmw_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob73by_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob7c3w_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob7grs_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob7p29_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob7wpp_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob80fw_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:50 o1_mf_94ob872w_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob8bng_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob8kdr_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob8o5j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob8vxm_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob8zrd_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob96bs_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob9f12_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob9jod_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob9q94_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94ob9z2t_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:51 o1_mf_94obb2qg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obb9ol_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obbfh4_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obbn36_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obbqt5_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obbydv_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obc21r_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obc8sx_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obcddk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obcm0x_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obcplv_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obcxbl_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:52 o1_mf_94obd12f_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obd7ob_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obdgco_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obdl6j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obdrrb_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obdwm9_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obf3hj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obf7kz_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obfc68_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obfktg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obfokq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:53 o1_mf_94obfw6l_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obfzqk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obg6f7_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obg9xq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obgjg3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obgn25_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obgqr1_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obgyov_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obh284_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obh605_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obhdlp_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obhj7b_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obhmt2_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:54 o1_mf_94obhtfb_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obhy5w_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obj4tm_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obj8kq_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94objd7n_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94objj4v_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94objpr6_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94objtdb_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obk112_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obk4qd_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obk8nj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obkh5c_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obklv2_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:55 o1_mf_94obkpm3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obkxc5_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obl0xc_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obl7sk_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94oblcdp_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94oblkwg_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94oblohn_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obls29_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obm00r_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obm3lr_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obmf2s_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:56 o1_mf_94obmn5q_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obmrhy_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obmw4j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obn2t3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obn6d7_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obn9wh_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obnjhn_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obnn70_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obntvo_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obnyck_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obo1y3_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obo8hf_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:57 o1_mf_94obod7w_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obolt4_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obopp5_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obotcn_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obp12j_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obp4ln_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obpc3s_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obpgvs_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obpljj_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obpp72_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obpwto_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obq0kz_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:58 o1_mf_94obq44n_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 18:59 o1_mf_94obqbp5_.flb
-rw-r-----   1 oracle1    dba1       99188736 Oct  1 19:14 o1_mf_94oco7k7_.flb
-rw-r-----   1 oracle1    dba1       49594368 Oct  1 19:15 o1_mf_94ocoh4r_.flb
-rw-r-----   1 oracle1    dba1       49594368 Oct  2 10:19 o1_mf_94owqsw7_.flb