Feed aggregator

BEFORE Triggers Fired Multiple Times

Tom Kyte - Sat, 2017-11-18 17:06
Dear Tom, I have a question about triggers execution: according to documentation at http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#sthref1169 "BEFORE Triggers Fired Multiple Times If an UPDATE or DELETE ...
Categories: DBA Blogs

Behavior of dba_hist_sgastat metrics 'free memory' and 'SQL' for pool 'shared pool' have changed with 12.1.0.2

Tom Kyte - Sat, 2017-11-18 17:06
We are upgrading from 11.2.0.4 to 12.1.0.2 and we are seeing a new behavior for the "free memory" in the shared pool. We are looking at AWR in dba_hist_sgastat. While in 11g it goes up and down, in 12c it is non-decreasing, over several days at least...
Categories: DBA Blogs

Docker-CE: initial configuration

Dietrich Schroff - Sat, 2017-11-18 15:43
After installing docker to a ubuntu server i was keen what kind of processes and files are there.
# ps x|grep docker
 5852 ?        Ssl    0:05 /usr/bin/dockerd -H fd://
 5867 ?        Ssl    0:04 docker-containerd --config /var/run/docker/containerd/containerd.tomlSo the inital configuration is not stored in /etc.

The configuration file looks like this:
# cat /var/run/docker/containerd/containerd.toml
root = "/var/lib/docker/containerd/daemon"
state = "/var/run/docker/containerd/daemon"
subreaper = false
oom_score = -500

[grpc]
  address = "/var/run/docker/containerd/docker-containerd.sock"
  uid = 0
  gid = 0

[debug]
  address = "/var/run/docker/containerd/docker-containerd-debug.sock"
  uid = 0
  gid = 0
  level = "info"

[metrics]
  address = ""

[cgroup]
  path = ""

[plugins]
  [plugins.linux]
    shim = "docker-containerd-shim"
    runtime = "docker-runc"
    runtime_root = "/var/lib/docker/runc"
    no_shim = false
    shim_debug = false
    shim_no_newns = falseThe directory /var/run/docker/containerd/daemon seems to be important, so let's take a look:
# find /var/run/docker/containerd/daemon
/var/run/docker/containerd/daemon
/var/run/docker/containerd/daemon/io.containerd.runtime.v1.linux
/var/run/docker/containerd/daemon/io.containerd.runtime.v1.linux/moby
But theese entries are only directories...

So what about /var/lib? Here we go:
# find /var/lib/docker/ -maxdepth 1
/var/lib/docker/
/var/lib/docker/overlay2
/var/lib/docker/swarm
/var/lib/docker/image
/var/lib/docker/tmp
/var/lib/docker/runtimes
/var/lib/docker/trust
/var/lib/docker/plugins
/var/lib/docker/containerd
/var/lib/docker/containers
/var/lib/docker/builder
/var/lib/docker/volumes
/var/lib/docker/networkWithin the directory containers you can find information about the containers which run / ran on your docker system:

# ls -l
insgesamt 12
drwx------ 4 root root 4096 Nov 16 22:12 0c7567bb965449f5f2f3dfadfc38f0226bdb42cc6d46daa4641042090e0405c7
drwx------ 4 root root 4096 Nov 16 22:57 28b7f70147aabc94bd174ce7ad7f5d48ed5610ffaa21733d3549ee6e998ee7c3
drwx------ 4 root root 4096 Nov 16 21:59 2db1c3ed1dafc85369536c382e02b6a23e5d134d2ba3d56a738f3441fb624b04
 The first characters of the directories match the container-id:
# docker ps -a
CONTAINER ID        IMAGE               COMMAND             CREATED             STATUS                  PORTS               NAMES
28b7f70147aa        hello-world         "/hello"            2 days ago          Exited (0) 2 days ago                       trusting_bartik
0c7567bb9654        hello-world         "/hello"            2 days ago          Exited (0) 2 days ago                       festive_wozniak
2db1c3ed1daf        hello-world         "/hello"            2 days ago          Exited (0) 2 days ago                       epic_tesla


Online Videos with Lucas Jellema–Live recording of Talks, Interviews and Stuff

Amis Blog - Sat, 2017-11-18 11:58

An overview of some of my recent recordings:

expected soon:

November 2017 – Oracle Developer Community Podcast  What’s Hot? Tech Trends That Made a Real Difference in 2017 (with Chris Richardson, Frank Munz, Pratik Patel, Lonneke Dikmans, Bob Rhubart and Lucas Jellema)  – https://blogs.oracle.com/developers/podcast-tech-trends-that-made-a-real-difference-in-2017

November 2nd – Oracle Developer Community Two Minute Tech Tip – No Excuses: Get Hands-On Experience With New Technologies – https://www.youtube.com/watch?v=NrfrWMq0m9Y

image

October 3rd – Oracle OpenWorld DevLive – Interview with Bob Rubart (Oracle Developer Community) on Kafka Streams, Java Cloud, PaaS Integration – https://www.youtube.com/watch?v=L_mhNCT2nao

image

October, Oracle Code/JavaOne San Francisco – Real Time UI with Apache Kafka Streaming Analytics of Fast Data and Server Push – https://www.youtube.com/watch?v=izTuO3IUBBY 

image

August 23rd – APACOUC (Asia Pacific Oracle User Council) Webinar Tour 2017 –  Modern DevOps across Technologies, On Premises and Clouds – https://www.youtube.com/watch?v=q8-wvvod85U

August 14th – APACOUC (Asia Pacific Oracle User Council) Webinar Tour 2017 – The Oracle Application Container Cloud as the Microservices Platform – https://youtu.be/LkMomfG6rv4

July 7th – APACOUC (Asia Pacific Oracle User Council) Webinar Tour 2017 – The Art of Intelligence – A Practical Introduction Machine Learning – https://youtu.be/XmqQhDsJnhY

June – Oracle Code Brussels – DevLive: Get on the (Event) Bus! with Lucas Jellema – https://www.youtube.com/watch?v=4raJRNFRJFk 

imageApril 20th – Oracle Code London – Event Bus as Backbone for Decoupled Microservice Choreography – https://www.youtube.com/watch?v=dRd-QggXqiA

image

April 20th – Oracle Code London – DevLive: Lucas Jellema on Decoupled Microservices with Event Bus – https://www.youtube.com/watch?v=T0gZhzzu5lg image

Older Resources

October 2015 – 2 Minute Tech Tip The Evolution of Flashback in Oracle Database – https://www.youtube.com/watch?v=WOcsYtX69N8

January 2015 – Interviewing Simone Geib (Oracle SOA Suite Product Manager) – https://www.youtube.com/watch?v=MrtpAW9aOHQ 

September 2014 – 2 Minute Tech Tip – Vagrant, Puppet, Docker, and Packer – https://www.youtube.com/watch?v=36ZmfLMFPJI

October 2013 – Interview with Boh Rhubart on SOA, Agile, DevOps, and Transformation – https://www.youtube.com/watch?v=rtiwGqmzmWo

image 

March 2013 – On User Experience – with Bob Rhubart & Jeremy Ashley – https://www.youtube.com/watch?v=8Jm_cVCoQ3o


The post Online Videos with Lucas Jellema–Live recording of Talks, Interviews and Stuff appeared first on AMIS Oracle and Java Blog.

Run Oracle Database in Docker using prebaked image from Oracle Container Registry–a two minute guide

Amis Blog - Sat, 2017-11-18 05:38

imageThis article will show how to run an Oracle Database on a Docker host using the prebaked images on Oracle Continer Registry. It is my expectation that it takes me very little manual effort to run the full 12.2.0.1 Oracle Enterprise Database – just pull and run the Docker image. Once it is running, I get the usual Docker benefits such as clean environment management, linking from other containers, quick stop and start, running scripts inside the container etc.

The minimum requirements for the container is 8GB of disk space and 2GB of memory. There is a slim alternative that requires less resources: The slim (12.2.0.1-slim) version of EE does not have support for Analytics, Oracle R, Oracle Label Security, Oracle Text, Oracle Application Express and Oracle DataVault. I am not sure yet how much that shaves of the resource requirements.

My recent article Quick introduction to Oracle Container Registry–running one of Oracle’s prebaked images explained the first steps for getting started with Oracle Container Registry, including how to sign up and accept terms and conditions for individual images.

Once that is out of the way, we can get going with running the database.

The steps are:

  1. start docker
  2. login to Oracle Container Registry
  3. pull image for Oracle Database – I will use the enterprise edition database image in this article
  4. run a docker container based on that image
  5. start interacting with the database, for example from SQLcl or SQL Developer.

In terms of work, it will take less than two minutes of your time. The time before the database is running is mainly determined by the time it takes to download the image. After that, running the container takes just a few dozens of seconds.

The Oracle Database images are published on the website for the Container Registry:

image

image

image

Copy the docker pull command in the upper right hand corner to the clipboard. It is also worth remembering the docker run command for running the database image.

Note that this webpage contains more useful information:

  • how to run SQL scripts from within the container
  • how to expose the database [port]outside the container
  • how to specify SID (default ORCLCDB), PDB (default is ORCLPDB1), DOMAIN (default is localdomain) and allocated MEMORY (default is 2 GB)
  • how to change SYS password (default is Oradoc_db1)
  • how to make use of a volume external to the database container for storing data files, redo logs, audit logs, alert logs and trace files
  • how to run a database server image against an existing set of database files
Let’s run a database

After starting Docker (on my laptop I am using the Docker Quick Start Terminal in the Docker Toolbox), login to the container registry using your Oracle account.

image

SNAGHTMLea0ec12

Then pull the database image, using the command

docker pull container-registry.oracle.com/database/enterprise

image

07:09 Start Pull

10:28 Start Extracting

image

10.30 Image is available, ready run containers off

image

The download took over three and a half hours. I was doing stuff over that time – so no time lost.

Once the pull was finished, the image was added to the local cache of Docker images. I can now run the database.

docker run -d -it –-name ORA12201_1 –P container-registry.oracle.com/database/enterprise:12.2.0.1

The value ORA12201_1 is the self-picked name for the container.

image

Here -P indicates that the ports can be chosen by docker. The mapped port can be discovered by executing

docker port ORA12201_1

image

In a few minutes – I am not sure exactly how long it took – the container status is healthy:

image

The Database server can be connected to – when the container status is Healthy – by executing sqlplus from within the container as

docker exec -it ORA12201_1 bash -c “source /home/oracle/.bashrc; sqlplus /nolog”

image

imageIn addition to connecting to the database from within the container – we can also just consider the container running the database as a back  box that exposes the database’s internal port 1521 at port 32769. And using any tool capable of communicating to a database can be used in a regular way – provided we also have the IP address for the Docker Host if the connect is not made from that machine itself:

image 

Creating a database connection in SQL Developer is done like this:

SNAGHTMLf64a329

Using SYS/Oradoc_db1 as the credentials, the Docker Host IP address for the hostname and the port mapped by Docker to port 1521 in the container, 32769 in this case. The Service Name is composed of the PDB name and the domain name:  ORCLPDB1.localdomain.

A sample query:imageConnecting with SQLcl is similar:

sql sys/Oradoc_db1@192.168.99.100:32769/ORCLPDB1.localdomain as sysdba

image

To stop the container – and the database:

docker stop 62eb

It takes a few seconds to stop cleanly.

image

Restarting takes about 1 minute before the database is up and running:

image

image

Note: with this basic approach, all database files are created in the container’s file system. And are not available elsewhere nor will they survive the removal of the container. A better way of handling these files is through the mounting of a host folder for storing files or through a Docker Volume.

Note: when running on Windows using Docker Toolbox, this may be convenient for increasing the size of memory and disk of the default VM: https://github.com/crops/docker-win-mac-docs/wiki/Windows-Instructions-(Docker-Toolbox)

The post Run Oracle Database in Docker using prebaked image from Oracle Container Registry–a two minute guide appeared first on AMIS Oracle and Java Blog.

Garbled display while running FMW installer on Linux

Amardeep Sidhu - Sat, 2017-11-18 04:56

A colleague faced this while running FMW installer on a Linux machine. The display appeared like this

 

 

 

 

 

 

 

This thread gave a clue that it could have something to do with fonts. So I checked what all fonts related stuff was installed.

[root@someserver ~]# rpm -aq |grep -i font
stix-fonts-1.1.0-5.el7.noarch
xorg-x11-font-utils-7.5-20.el7.x86_64
xorg-x11-fonts-cyrillic-7.5-9.el7.noarch
xorg-x11-fonts-ISO8859-1-75dpi-7.5-9.el7.noarch
xorg-x11-fonts-ISO8859-9-100dpi-7.5-9.el7.noarch
xorg-x11-fonts-ISO8859-9-75dpi-7.5-9.el7.noarch
libXfont-1.5.2-1.el7.x86_64
xorg-x11-fonts-ISO8859-14-100dpi-7.5-9.el7.noarch
xorg-x11-fonts-ISO8859-1-100dpi-7.5-9.el7.noarch
xorg-x11-fonts-75dpi-7.5-9.el7.noarch
xorg-x11-fonts-ISO8859-2-100dpi-7.5-9.el7.noarch
libfontenc-1.1.3-3.el7.x86_64
xorg-x11-fonts-ethiopic-7.5-9.el7.noarch
xorg-x11-fonts-100dpi-7.5-9.el7.noarch
xorg-x11-fonts-misc-7.5-9.el7.noarch
fontpackages-filesystem-1.44-8.el7.noarch
fontconfig-2.10.95-11.el7.x86_64
xorg-x11-fonts-ISO8859-2-75dpi-7.5-9.el7.noarch
xorg-x11-fonts-ISO8859-14-75dpi-7.5-9.el7.noarch
xorg-x11-fonts-Type1-7.5-9.el7.noarch
xorg-x11-fonts-ISO8859-15-75dpi-7.5-9.el7.noarch
[root@someserver ~]#

stix-fonts looked suspicious to me. So I removed that with rpm -e stix-fonts.

That actually fixed the issue. After this the Installer window was displaying fine.

 

Categories: BI & Warehousing

root.sh fails with CRS-2101:The OLR was formatted using version 3

Amardeep Sidhu - Sat, 2017-11-18 04:33

Got this while trying to install 11.2.0.4 RAC on Redhat Linux 7.2. root.sh fails with a message like

ohasd failed to start
Failed to start the Clusterware. Last 20 lines of the alert log follow:
2017-11-09 15:43:37.883:
[client(37246)]CRS-2101:The OLR was formatted using version 3.

This is bug 18370031. Need to apply the patch before running root.sh.

Categories: BI & Warehousing

Unstructed vs. structured

Yann Neuhaus - Sat, 2017-11-18 01:13

The title of this blog post was: “Tracing DBMS_RCVMAN for reclaimable archivelogs” until I started to write the conclusion…

In a previous post I mentioned that there’s a bug with archivelog deletion policy when you want to mention both the ‘BACKED UP … TIMES TO …’ and ‘APPLIED’ or ‘SHIPPED’ as conditions for archived logs to be reclaimable. I opened a SR, they didn’t even try to reproduce it (and I can guarantee you can reproduce it in 2 minutes on any currently supported version) so I traced it myself to understand the bug and suggest the fix.

I traced the DBMS_RCVMAN with Kernel Recovery Area function SQL Tracing:

SQL> alter session set events 'trace[kra_sql] disk high, memory disable';
SQL> dbms_backup_restore.refreshAgedFiles;
SQL> alter session set events 'trace[kra_sql] off';

I know refreshAgedFiles checks for reclaimable file in FRA since it was an old bug where we had to run it manually on databases in mount.

I compared the traces when changing the order of ‘APPLIED’ and ‘BACKED UP’ and found the following:

< *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: setRedoLogDeletionPolicy with policy = TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY
---
> *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: setRedoLogDeletionPolicy with policy = TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK
5340c5340
< *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: policy = TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY
---
> *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: policy = TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK
5343c5343
< *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: EXITING setRedoLogDeletionPolicy with policy = TO BACKED UP 1 TIMES TO DISK APPLIED ON ALL STANDBY with alldest = 1
---
> *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: EXITING setRedoLogDeletionPolicy with policy = TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO DISK with alldest = 1
5350,5351c5350,5351
< *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: parseBackedUpOption devtype=DISK
< *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: parseBackedUpOption backed up conf - devtype=DISK , backups=1
---
> *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: parseBackedUpOption devtype=DISK
> *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: parseBackedUpOption backed up conf - devtype=DISK, backups=1
5363c5363
< *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: EXITING getBackedUpAl with TRUE
---
> *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: EXITING getBackedUpAl with key = 128 stamp = 958068130
5367c5367
< *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: EXITING getBackedUpFiles with: no_data_found
---
> *:KRA_SQL:kraq.c@1035:kraqgdbg(): DBGRCVMAN: EXITING getBackedUpFiles

You see at the top the difference in the way I mentioned the deletion policy. You see at the bottom that the first one (starting with ‘BACKED UP’) didn’t find archivelogs being backed up (no_data_found). But the second one (starting with ‘APPLIED’) mentioned the sequence# 128.

But if you look carefully, you see another difference in the middle: the “devtype=DISK” has an additional space before the comma in the first case.

So I traced a bit further, including SQL_TRACE and I found that the deletion policy is just using some INSTR and SUBSTR parsing on the deletion policy text to find the policy, the backup times, and the device type. For sure, looking for backups with DEVICE_TYPE=’DISK ‘ instead of ‘DISK’ will not find anything and this is the reason for the bug: no archived logs backed up means no archived log reclaimable.

If you look closer at DBMS_RCVMAN you will find that the device type is extracted with SUBSTR(:1, 1, INSTR(:1, ‘ ‘)) when the device type is followed by a space, which is the reason of this additional space. The correct extraction should be SUBSTR(:1, 1, INSTR(:1, ‘ ‘)-1) and this is what I suggested on the SR.

So what?

Writing the conclusion made me change the title. Currently, a lot of people are advocating for unstructured data. Because it is easy (which rhymes with ‘lazy’). Store information as it comes and postpone the parsing to a more structured data type until you need to process it. This seems to be how the RMAN configuration is stored: as the text we entered. And it is parsed later with simple text function as INSTR(), SUBSTR(), and LIKE. But you can see how a little bug, such as reading an additional character, has big consequences. If you look at the archivelog deletion policy syntax, you have 50% chances to run into this bug on a Data Guard configuration. The Recovery Area will fill up and your database will be blocked. The controlfile grows. Or you noticed it before and you run a ‘delete archivelog’ statement without knowing the reason. You waste space, removing some recovery files from local storage, which could have been kept for longer. If the deletion policy was parsed immediately when entered, like SQL DDL or PL/SQL APIs, the issue would have been detected a long time ago. Structure and strong typing is the way to build robust applications.

 

Cet article Unstructed vs. structured est apparu en premier sur Blog dbi services.

how SPM works with cursor_sharing=force?

Tom Kyte - Fri, 2017-11-17 22:46
<code>Hello Tom The post https://blogs.oracle.com/optimizer/how-do-adaptive-cursor-sharing-and-sql-plan-management-interact explains the interaction between cursor sharing and SPM quite clear. But I met some unexpected results if I set the cursor_...
Categories: DBA Blogs

Whitespaces bug

Tom Kyte - Fri, 2017-11-17 22:46
I have noticed a weird bug in our Oracle database as we are moving from one database (Oracle 11.2.0.3.0) to another database (Oracle 11.2.4.0). Database servers are in different data center with different operating systems and support teams. So the v...
Categories: DBA Blogs

Oracle SOA Suite 12c: database configuration

Dietrich Schroff - Fri, 2017-11-17 13:29
After the running the rcu i was keen what was created inside the database. The installation showed some additional tablespaces:
select tablespace_name from dba_tablespaces; TABLESPACE_NAME              
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
DEV_SOAINFRA
DEV_IAS_TEMP
DEV_STB
DEV_IAS_UMS
DEV_WLS
DEV_MDS
DEV_IAS_OPSS
DEV_IAU

13 Zeilen gewählt. Ok. Not really exciting.
But the list of the created tables was quite impressing:
select OWNER,TABLE_NAME from all_tables where owner like 'DEV%';

OWNER                TABLE_NAME                             
-------------------- ----------------------------------------
DEV_MDS              MDS_PURGE_PATHS                        
DEV_SOAINFRA         AQ$_IP_QTAB_G                          
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_G            
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_G          
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_G            
DEV_SOAINFRA         AQ$_IP_QTAB_T                          
DEV_SOAINFRA         AQ$_IP_QTAB_H                          
DEV_SOAINFRA         AQ$_IP_QTAB_I                          
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_T            
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_H            
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_I            
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_T          
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_H          
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_I          
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_T            
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_H            
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_I            
DEV_SOAINFRA         RUPD$_MFT_SOURCE_MESSAGE               
DEV_SOAINFRA         RUPD$_MFT_TRANSFER_INSTANCE            
DEV_SOAINFRA         RUPD$_MFT_TARGET_INSTANCE              
DEV_SOAINFRA         RUPD$_MFT_TARGET_MESSAGE               
DEV_SOAINFRA         RUPD$_MFT_DATA_STORAGE                 
DEV_SOAINFRA         TEMP_BRDECISION_INSTANCE_GLB           
DEV_SOAINFRA         TEMP_FLOWID_PURGE_GLB                  
DEV_SOAINFRA         TEMP_CUBE_INSTANCE_GLB                 
DEV_SOAINFRA         TEMP_DOCUMENT_CI_REF_GLB               
DEV_SOAINFRA         TEMP_DOCUMENT_DLV_MSG_REF_GLB          
DEV_SOAINFRA         TEMP_WFTASK_PURGE_GLB                  
DEV_SOAINFRA         TEMP_MEDIATOR_DEFERRED_GLB             
DEV_SOAINFRA         TEMP_MEDIATOR_RESEQUENCER_GLB          
DEV_SOAINFRA         UPGRADE_CURRENT_SEQUENCE_TEMP          
DEV_SOAINFRA         TEMP_UPGRADE_ECID                      
DEV_SOAINFRA         TEMP_UPGRADE_CI                        
DEV_SOAINFRA         TEMP_UPGRADE_DLV_MSG                   
DEV_SOAINFRA         TEMP_UPGRADE_DLV_ECID_MAP              
DEV_SOAINFRA         TEMP_UPGRADE_WKITM_CI                  
DEV_SOAINFRA         TEMP_UPGRADE_WFTASK                    
DEV_SOAINFRA         TEMP_UPGRADE_BRDECISION                
DEV_SOAINFRA         TEMP_UPGRADE_MI                        
DEV_SOAINFRA         TEMP_UPGRADE_MCI                       
DEV_SOAINFRA         TEMP_UPGRADE_MCDV                      
DEV_SOAINFRA         TEMP_UPGRADE_CPST_INST                 
DEV_SOAINFRA         LDAPADAPTER_IN                         
DEV_SOAINFRA         FILEADAPTER_IN                         
DEV_SOAINFRA         FILEADAPTER_MUTEX                      
DEV_SOAINFRA         JCA_NATIVE_CORRELATION                 
DEV_SOAINFRA         FILEADAPTER_TRANSACTION_LOG            
DEV_SOAINFRA         MESSAGE_STATISTICS                     
DEV_SOAINFRA         EIS_CONNECTION_DOWN_TIME               
DEV_SOAINFRA         AIA_ERROR_NOTIFICATIONS                
DEV_SOAINFRA         AIA_SYSTEMS                            
DEV_SOAINFRA         CAVS_DEFINITION_AUDITS                 
DEV_SOAINFRA         CAVS_DEFINITION_NSXPATHS               
DEV_SOAINFRA         CAVS_DEFINITION_XPATHS                 
DEV_SOAINFRA         CAVS_DEFINITION_XREFS                  
DEV_SOAINFRA         CAVS_DEFINITIONS                       
DEV_SOAINFRA         CAVS_GRPDEFINITION_DEFINITIONS         
DEV_SOAINFRA         CAVS_GRPDEFINITIONS                    
DEV_SOAINFRA         CAVS_GRPINSTANCE_INSTANCES             
DEV_SOAINFRA         CAVS_GRPINSTANCES                      
DEV_SOAINFRA         CAVS_INSTANCE_NSXPATHS                 
DEV_SOAINFRA         CAVS_INSTANCE_XPATHS                   
DEV_SOAINFRA         CAVS_INSTANCE_XREFS                    
DEV_SOAINFRA         CAVS_INSTANCES                         
DEV_SOAINFRA         CAVS_ROUTING_SETUP                     
DEV_SOAINFRA         CAVS_ROUTING_SETUP_DETAILS             
DEV_SOAINFRA         CAVS_SCHEDULER                         
DEV_SOAINFRA         AIA_ERROR_FLEX_FIELD                   
DEV_SOAINFRA         AIA_ERROR_MONITOR                      
DEV_SOAINFRA         AM_APPLICATION                         
DEV_SOAINFRA         AM_SUBSCRIPTION                        
DEV_SOAINFRA         AM_APIVISIBILITY                       
DEV_SOAINFRA         AM_ID_GENERATOR                        
DEV_SOAINFRA         B2B_STREAMSTORE                        
DEV_SOAINFRA         B2B_DATA_STORAGE                       
DEV_SOAINFRA         B2B_APP_MESSAGE                        
DEV_SOAINFRA         B2B_AUDIT_TEMP                         
DEV_SOAINFRA         B2B_BATCH_EVENT                        
DEV_SOAINFRA         B2B_BUSINESS_MESSAGE                   
DEV_SOAINFRA         B2B_BUSINESS_MESSAGE_RETRY             
DEV_SOAINFRA         B2B_CONTROL_NUMBER                     
DEV_SOAINFRA         B2B_CONTROL_NUMBER_SET                 
DEV_SOAINFRA         B2B_CTL_NUMBER                         
DEV_SOAINFRA         B2B_EXT_BUSINESS_MESSAGE               
DEV_SOAINFRA         B2B_HA_REGISTRY                        
DEV_SOAINFRA         B2B_LIFECYCLE                          
DEV_SOAINFRA         B2B_LOCK_REGISTRY                      
DEV_SOAINFRA         B2B_PARAMETER                          
DEV_SOAINFRA         B2B_PENDING_MESSAGE                    
DEV_SOAINFRA         B2B_PURGE_TEMP_AM                      
DEV_SOAINFRA         B2B_PURGE_TEMP_BM                      
DEV_SOAINFRA         B2B_PURGE_TEMP_WM                      
DEV_SOAINFRA         B2B_SEQUENCE_MANAGER                   
DEV_SOAINFRA         B2B_TRANSPORT_MANAGER                  
DEV_SOAINFRA         B2B_WIRE_MESSAGE                       
DEV_SOAINFRA         BEAM_SEQUENCE                          
DEV_SOAINFRA         BEAM_PROPERTY                          
DEV_SOAINFRA         BEAM_TRANSACTION_CONTEXT               
DEV_SOAINFRA         BEAM_FLEXTABLE                         
DEV_SOAINFRA         BEAM_DATAOBJECT                        
DEV_SOAINFRA         BEAM_NAMEMAPPING                       
DEV_SOAINFRA         BEAM_COLUMN                            
DEV_SOAINFRA         BEAM_ALERT_RULE                        
DEV_SOAINFRA         BEAM_ALERT_ESCALATION                  
DEV_SOAINFRA         AUDIT_COUNTER                          
DEV_SOAINFRA         AUDIT_DETAILS                          
DEV_SOAINFRA         AUDIT_TRAIL                            
DEV_SOAINFRA         CI_INDEXES                             
DEV_SOAINFRA         CLUSTER_MASTER                         
DEV_SOAINFRA         CLUSTER_NODE                           
DEV_SOAINFRA         CUBE_INSTANCE                          
DEV_SOAINFRA         CUBE_SCOPE                             
DEV_SOAINFRA         DLV_MESSAGE                            
DEV_SOAINFRA         DLV_SUBSCRIPTION                       
DEV_SOAINFRA         DOCUMENT_CI_REF                        
DEV_SOAINFRA         DOCUMENT_DLV_MSG_REF                   
DEV_SOAINFRA         HEADERS_PROPERTIES                     
DEV_SOAINFRA         DLV_AGGREGATION                        
DEV_SOAINFRA         ID_RANGE                               
DEV_SOAINFRA         LOAN_CUSTOMER                          
DEV_SOAINFRA         NATIVE_CORRELATION                     
DEV_SOAINFRA         TEST_DEFINITIONS                       
DEV_SOAINFRA         TEST_DETAILS                           
DEV_SOAINFRA         UPGRADE_INFO                           
DEV_SOAINFRA         VERSION                                
DEV_SOAINFRA         WI_FAULT                               
DEV_SOAINFRA         WORK_ITEM                              
DEV_SOAINFRA         CUBE_PROCESS_BREAKPOINT                
DEV_SOAINFRA         BPEL_CONVERSATION_SUBSCRIPTION         
DEV_SOAINFRA         SOAQTZ_BLOB_TRIGGERS                   
DEV_SOAINFRA         SOAQTZ_CALENDARS                       
DEV_SOAINFRA         SOAQTZ_CRON_TRIGGERS                   
DEV_SOAINFRA         SOAQTZ_FIRED_TRIGGERS                  
DEV_SOAINFRA         SOAQTZ_JOB_DETAILS                     
DEV_SOAINFRA         SOAQTZ_JOB_LISTENERS                   
DEV_SOAINFRA         SOAQTZ_LOCKS                           
DEV_SOAINFRA         SOAQTZ_PAUSED_TRIGGER_GRPS             
DEV_SOAINFRA         SOAQTZ_SCHEDULER_STATE                 
DEV_SOAINFRA         SOAQTZ_SIMPLE_TRIGGERS                 
DEV_SOAINFRA         SOAQTZ_TRIGGER_LISTENERS               
DEV_SOAINFRA         SOAQTZ_TRIGGERS                        
DEV_SOAINFRA         CM_CASE_OBJECT                         
DEV_SOAINFRA         CM_CASE_DOCUMENT                       
DEV_SOAINFRA         CM_CASE_EVENT                          
DEV_SOAINFRA         CM_PROPERTY_BAG                        
DEV_SOAINFRA         CM_CASE_DEFINITION                     
DEV_SOAINFRA         CM_CASE_MILESTONE_DEFINITION           
DEV_SOAINFRA         CM_ACTIVITY_DEFINITION                 
DEV_SOAINFRA         CM_ACTIVITY_CASE_DEFINITION            
DEV_SOAINFRA         CM_ACTIVITY_CATEGORY_DEFN              
DEV_SOAINFRA         CM_TRANSLATION                         
DEV_SOAINFRA         CM_ACTIVITY_INSTANCE                   
DEV_SOAINFRA         CM_CASE                                
DEV_SOAINFRA         CM_FABRIC_HEADER_PROPERTY              
DEV_SOAINFRA         CM_LINKED_CASE                         
DEV_SOAINFRA         CM_CASE_DATA                           
DEV_SOAINFRA         CM_CASE_FLEX_FIELD                     
DEV_SOAINFRA         CM_CASE_HEADER                         
DEV_SOAINFRA         CM_CASE_MILESTONE                      
DEV_SOAINFRA         CM_CASE_PHASE                          
DEV_SOAINFRA         CM_CASE_STAKE_HOLDER                   
DEV_SOAINFRA         CM_CASE_STAKE_HOLDER_MEMBER            
DEV_SOAINFRA         CM_COMMENT                             
DEV_SOAINFRA         CM_RULE                                
DEV_SOAINFRA         CM_RULE_EDIT                           
DEV_SOAINFRA         CM_ACTIVITY_ATTRIBUTE                  
DEV_SOAINFRA         CM_ACTIVITY_CORRELATION                
DEV_SOAINFRA         CM_SEQUENCE_TABLE                      
DEV_SOAINFRA         CM_CASE_DISPLAY                        
DEV_SOAINFRA         CM_ACTIVITY_STAKEHOLDER                
DEV_SOAINFRA         BPM_ACTIVITY                           
DEV_SOAINFRA         BPM_ACTIVITY_INSTANCE                  
DEV_SOAINFRA         BPM_ACTIVITY_PROPERTY                  
DEV_SOAINFRA         BPM_AUDIT_QUERY                        
DEV_SOAINFRA         BPM_AUDIT_QUERY_METADATA               
DEV_SOAINFRA         BPM_AUDIT_QUERY_VAR_MD                 
DEV_SOAINFRA         BPM_AUDIT_QUERY_VAR_RANGES             
DEV_SOAINFRA         BPM_AUDIT_QUERY_VARMD_EXT1             
DEV_SOAINFRA         BPM_AUDIT_QUERY_VARVALS_EXT1           
DEV_SOAINFRA         BPM_AUDIT_SEQUENCE                     
DEV_SOAINFRA         BPM_CASE                               
DEV_SOAINFRA         BPM_CASE_ACTIVITIES                    
DEV_SOAINFRA         BPM_CASE_ATTRIBUTES                    
DEV_SOAINFRA         BPM_CASE_DATA                          
DEV_SOAINFRA         BPM_CUBE_ACTIVITY                      
DEV_SOAINFRA         BPM_CUBE_ACTIVITY_INSTANCE             
DEV_SOAINFRA         BPM_CUBE_ACTIVITY_PROPERTY             
DEV_SOAINFRA         BPM_CUBE_ACTIVITY_SEQFLOW              
DEV_SOAINFRA         BPM_CUBE_AUDITINST_FLEX01              
DEV_SOAINFRA         BPM_CUBE_AUDITINSTANCE                 
DEV_SOAINFRA         BPM_CUBE_GLOBALCREATETASK              
DEV_SOAINFRA         BPM_CUBE_LASTSNAPSHOT                  
DEV_SOAINFRA         BPM_CUBE_LOCK                          
DEV_SOAINFRA         BPM_CUBE_NAMETAB                       
DEV_SOAINFRA         BPM_CUBE_NAMETAB_RANGE                 
DEV_SOAINFRA         BPM_CUBE_ORGUNIT                       
DEV_SOAINFRA         BPM_CUBE_ORGUNIT_ASSOC                 
DEV_SOAINFRA         BPM_CUBE_PARTNER_SERVICE               
DEV_SOAINFRA         BPM_CUBE_PROCESS                       
DEV_SOAINFRA         BPM_CUBE_PROCESS_PARTNER               
DEV_SOAINFRA         BPM_CUBE_PROCESSPERFORMANCE            
DEV_SOAINFRA         BPM_CUBE_PROCPERF_FLEX01               
DEV_SOAINFRA         BPM_CUBE_ROLE                          
DEV_SOAINFRA         BPM_CUBE_SEQUENCE                      
DEV_SOAINFRA         BPM_CUBE_TASKPERF_FLEX01               
DEV_SOAINFRA         BPM_CUBE_TASKPERFORMANCE               
DEV_SOAINFRA         BPM_CUBE_WORKLOAD                      
DEV_SOAINFRA         BPM_CUBE_WORKLOAD_FLEX01               
DEV_SOAINFRA         BPM_CUSTOM_APPS                        
DEV_SOAINFRA         BPM_MEASUREMENT_ACTION_EXCEPS          
DEV_SOAINFRA         BPM_MEASUREMENT_ACTION_SEQ             
DEV_SOAINFRA         BPM_MEASUREMENT_ACTIONS                
DEV_SOAINFRA         BPM_PARTNER_SERVICE                    
DEV_SOAINFRA         BPM_PROCESS                            
DEV_SOAINFRA         BPM_PROCESS_PARTNER                    
DEV_SOAINFRA         BPM_PROJECTSHAREDATA                   
DEV_SOAINFRA         BPM_PROJECTSHAREDATA_SEQ               
DEV_SOAINFRA         BPM_SEQUENCE                           
DEV_SOAINFRA         BPM_RT_FLOW_ELEMENT                    
DEV_SOAINFRA         BPM_RT_INSTANCE_CREATION               
DEV_SOAINFRA         BPM_RT_SEQUENCE                        
DEV_SOAINFRA         BPM_RT_SEQUENCE_FLOW                   
DEV_SOAINFRA         BPM_RT_SNAPSHOT                        
DEV_SOAINFRA         AG_INSTANCE                            
DEV_SOAINFRA         BPM_PML_SEQUENCE                       
DEV_SOAINFRA         BPM_PML_HS                             
DEV_SOAINFRA         BPM_PML_HS_ITEM                        
DEV_SOAINFRA         BPM_PML_HS_BPM_PML_HS_ITEM             
DEV_SOAINFRA         BPM_BAC_SEQUENCE                       
DEV_SOAINFRA         BPM_BAC_SESSION                        
DEV_SOAINFRA         BPM_BAC_METADATA_STORE                 
DEV_SOAINFRA         BPM_BAC_REPOSITORY_BACKUP              
DEV_SOAINFRA         BPM_OPTIMIZATION_DATA                  
DEV_SOAINFRA         BPM_OPT_COMPLETION_DATE_DATA           
DEV_SOAINFRA         BPM_OPT_DATA_SEQUENCE                  
DEV_SOAINFRA         BPM_ARCHIVEREQUEST                     
DEV_SOAINFRA         BPM_ARCHIVESEQUENCE                    
DEV_SOAINFRA         BPM_USER_DRAFT                         
DEV_SOAINFRA         EDN_EVENT_ERROR_STORE                  
DEV_SOAINFRA         EDN_E2J_MAPPING                        
DEV_SOAINFRA         EDN_EVENT_AGENTS                       
DEV_SOAINFRA         EDN_EVENT_SUBSCRIPTIONS                
DEV_SOAINFRA         EDN_LOG_ENABLED                        
DEV_SOAINFRA         EDN_LOG_MESSAGES                       
DEV_SOAINFRA         EDN_RETRY_COUNT                        
DEV_SOAINFRA         ATTACHMENT                             
DEV_SOAINFRA         ATTACHMENT_REF                         
DEV_SOAINFRA         BRIDGE_INSTANCE                        
DEV_SOAINFRA         COMPONENT_INSTANCE                     
DEV_SOAINFRA         COMPOSITE_INSTANCE                     
DEV_SOAINFRA         COMPOSITE_INSTANCE_ASSOC               
DEV_SOAINFRA         COMPOSITE_INSTANCE_FAULT               
DEV_SOAINFRA         INSTANCE_PAYLOAD                       
DEV_SOAINFRA         REFERENCE_INSTANCE                     
DEV_SOAINFRA         REJECTED_MESSAGE                       
DEV_SOAINFRA         REJECTED_MSG_NATIVE_PAYLOAD            
DEV_SOAINFRA         SENSOR_SEQUENCE                        
DEV_SOAINFRA         SEQUENCE                               
DEV_SOAINFRA         TEST_INSTANCE                          
DEV_SOAINFRA         XML_DOCUMENT                           
DEV_SOAINFRA         XML_DOCUMENT_REF                       
DEV_SOAINFRA         SCA_SEQUENCE                           
DEV_SOAINFRA         SCA_PARTITION                          
DEV_SOAINFRA         SCA_ENTITY                             
DEV_SOAINFRA         SCA_FLOW_INSTANCE                      
DEV_SOAINFRA         SCA_FLOW_TO_CPST                       
DEV_SOAINFRA         SCA_ASYNC_CPNT_STATE                   
DEV_SOAINFRA         SCA_COMMON_FAULT                       
DEV_SOAINFRA         SCA_FLOW_ASSOC                         
DEV_SOAINFRA         SCA_META_DATA                          
DEV_SOAINFRA         FAULT_NOTIFICATION_RULE                
DEV_SOAINFRA         FAULT_ALERT                            
DEV_SOAINFRA         BULK_RECOVERY_JOB                      
DEV_SOAINFRA         SCA_REJECTED_MESSAGE                   
DEV_SOAINFRA         SCA_ATTACHMENT_REF                     
DEV_SOAINFRA         UPGRADE_CURRENT_SEQUENCE               
DEV_SOAINFRA         RESLNCY_FAILURE_EP                     
DEV_SOAINFRA         RESLNCY_SUSPEND_SVC                    
DEV_SOAINFRA         RESLNCY_SUSPEND_SVC_HSTRY              
DEV_SOAINFRA         RESLNCY_FAILURE_EP_HSTRY               
DEV_SOAINFRA         AWR_SERVER_NODE                        
DEV_SOAINFRA         AWR_CONFIGURATION                      
DEV_SOAINFRA         AWR_COMPOSITE                          
DEV_SOAINFRA         AWR_COMPONENT                          
DEV_SOAINFRA         AWR_ENDPOINT                           
DEV_SOAINFRA         AWR_ACTIVITY                           
DEV_SOAINFRA         AWR_SYSTEM_RESOURCES                   
DEV_SOAINFRA         AWR_SNAPSHOT                           
DEV_SOAINFRA         AWR_RESOURCE_UTIL_METRIC               
DEV_SOAINFRA         AWR_FLOW_METRIC                        
DEV_SOAINFRA         AWR_EXECUTION_METRIC                   
DEV_SOAINFRA         AWR_BACKUP_METRIC                      
DEV_SOAINFRA         REP_BUS_EVENT                          
DEV_SOAINFRA         REP_FLOW_CORL                          
DEV_SOAINFRA         REP_EVENT_PROP                         
DEV_SOAINFRA         REP_PAYLOAD                            
DEV_SOAINFRA         REP_BUS_RECOVERY                       
DEV_SOAINFRA         PMON_BIZ_MODEL                         
DEV_SOAINFRA         PMON_BIZ_PROP                          
DEV_SOAINFRA         PMON_AUDIT                             
DEV_SOAINFRA         PMON_AUDIT_INFO                        
DEV_SOAINFRA         PMON_REJECTED_MODEL                    
DEV_SOAINFRA         PMON_SEQUENCE                          
DEV_SOAINFRA         SOA_HEALTHCHECK_RESULT                 
DEV_SOAINFRA         PC_OWF                                 
DEV_SOAINFRA         PC_TASK                                
DEV_SOAINFRA         PC_TASKASSIGNEE                        
DEV_SOAINFRA         PC_TASKASSIGNEEHISTORY                 
DEV_SOAINFRA         PC_TASKATTACHMENT                      
DEV_SOAINFRA         PC_TASKHISTORY                         
DEV_SOAINFRA         PC_TASKPAYLOAD                         
DEV_SOAINFRA         BPELNOTIFICATION                       
DEV_SOAINFRA         BPELNOTIFICATION_FILTERMSGS            
DEV_SOAINFRA         BPELNOTIFICATION_INVALADDRS            
DEV_SOAINFRA         BPM_BUSINESS_CONSTANT_OU_ASSOC         
DEV_SOAINFRA         BPM_BUSINESS_CONSTANT                  
DEV_SOAINFRA         BPM_APP_ROLE_OU_CAL_ASSOC              
DEV_SOAINFRA         BPM_CALENDAR_RULE                      
DEV_SOAINFRA         BPM_CALENDAR_WORKDAY                   
DEV_SOAINFRA         BPM_FISCAL_YEAR                        
DEV_SOAINFRA         BPM_FISCAL_YEAR_DIVISION               
DEV_SOAINFRA         BPM_EXT_USER_PROP_AVLBL_COL            
DEV_SOAINFRA         BPM_EXT_USER_PROPERTY_GLOBAL           
DEV_SOAINFRA         BPM_EXT_USER_PROPERTY_VALUE            
DEV_SOAINFRA         BPM_HOLIDAY_RULE                       
DEV_SOAINFRA         BPM_HOLIDAYS                           
DEV_SOAINFRA         BPM_LOGICAL_PEOPLE_GROUP               
DEV_SOAINFRA         BPM_LPG_MEMBER                         
DEV_SOAINFRA         BPM_ORGANIZATIONAL_UNIT                
DEV_SOAINFRA         BPM_OU_MANAGER                         
DEV_SOAINFRA         BPM_OU_USER                            
DEV_SOAINFRA         BPM_PP_ENTITY_GS_MAP                   
DEV_SOAINFRA         BPM_PRESENTATION                       
DEV_SOAINFRA         BPM_PRESENTATION_GRANT                 
DEV_SOAINFRA         BPM_USERAPPLICATIONDATA                
DEV_SOAINFRA         BPM_USERAPPLICATIONDATA_GRANT          
DEV_SOAINFRA         DOCUMENTDEFINITION                     
DEV_SOAINFRA         DOCUMENTINSTANCE                       
DEV_SOAINFRA         DOCUMENTPACKAGEDEFINITION              
DEV_SOAINFRA         DOCUMENTPACKAGEINSTANCE                
DEV_SOAINFRA         DOCUMENTPACKAGEPROCESS                 
DEV_SOAINFRA         DOCUMENTPACKAGEPROPERTIES              
DEV_SOAINFRA         DOCUMENTPACKAGEPROPERTIESMAP           
DEV_SOAINFRA         NOTIFICATIONTRACKER                    
DEV_SOAINFRA         NOTIFTRACKERATTACHMENTS                
DEV_SOAINFRA         WFAPPROVALGROUPMEMBERS                 
DEV_SOAINFRA         WFAPPROVALGROUPS                       
DEV_SOAINFRA         WFASSIGNEE                             
DEV_SOAINFRA         WFATTACHMENT                           
DEV_SOAINFRA         WFATTRIBUTELABELMAP                    
DEV_SOAINFRA         WFATTRIBUTELABELUSAGE                  
DEV_SOAINFRA         WFCERTAUTHORITY                        
DEV_SOAINFRA         WFCERTIFICATE                          
DEV_SOAINFRA         WFCERTIFICATEREVOKED                   
DEV_SOAINFRA         WFCOLLECTIONTARGET                     
DEV_SOAINFRA         WFCOMMENTS                             
DEV_SOAINFRA         WFEVIDENCE                             
DEV_SOAINFRA         WFHEADERPROPS                          
DEV_SOAINFRA         WFMESSAGEATTRIBUTE                     
DEV_SOAINFRA         WFNOTIFICATION                         
DEV_SOAINFRA         WFNOTIFICATIONMESSAGES                 
DEV_SOAINFRA         WFNOTIFICATIONSTATUS                   
DEV_SOAINFRA         WFREVIEWER                             
DEV_SOAINFRA         WFROUTINGSLIP                          
DEV_SOAINFRA         WFRULEDICTIONARY                       
DEV_SOAINFRA         WFTASK                                 
DEV_SOAINFRA         WFTASK_TL                              
DEV_SOAINFRA         WFTASKAGGREGATION                      
DEV_SOAINFRA         WFTASKASSIGNMENTSTATISTIC              
DEV_SOAINFRA         WFTASKDISPLAY                          
DEV_SOAINFRA         WFTASKERROR                            
DEV_SOAINFRA         WFTASKHISTORY                          
DEV_SOAINFRA         WFTASKHISTORY_TL                       
DEV_SOAINFRA         WFTASKMETADATA                         
DEV_SOAINFRA         WFTASKSEQUENCECHANGES                  
DEV_SOAINFRA         WFTASKTIMER                            
DEV_SOAINFRA         WFUSERPREFERENCE                       
DEV_SOAINFRA         WFUSERTASKVIEW                         
DEV_SOAINFRA         WFUSERTASKVIEWGRANT                    
DEV_SOAINFRA         WLI_QS_REPORT_ATTRIBUTE                
DEV_SOAINFRA         WLI_QS_REPORT_DATA                     
DEV_SOAINFRA         OSB_MSG                                
DEV_SOAINFRA         RM_SEQUENCES                           
DEV_SOAINFRA         RM_UNACKED_MESSAGES                    
DEV_SOAINFRA         RM_LOCALIDS                            
DEV_SOAINFRA         BRDECISIONFAULT                        
DEV_SOAINFRA         BRDECISIONINSTANCE                     
DEV_SOAINFRA         BRDECISIONUNITOFWORK                   
DEV_SOAINFRA         BRSEQUENCE                             
DEV_SOAINFRA         ACTIVITY_SENSOR_VALUES                 
DEV_SOAINFRA         COMPOSITE_SENSOR_VALUE                 
DEV_SOAINFRA         FAULT_SENSOR_VALUES                    
DEV_SOAINFRA         VARIABLE_SENSOR_VALUES                 
DEV_SOAINFRA         SCA_SENSOR_VALUE                       
DEV_SOAINFRA         MEDIATOR_GROUP_STATUS                  
DEV_SOAINFRA         MEDIATOR_RESEQUENCER_MESSAGE           
DEV_SOAINFRA         OSB_GROUP_STATUS                       
DEV_SOAINFRA         OSB_RESEQUENCER_MESSAGE                
DEV_SOAINFRA         B2B_GROUP_STATUS                       
DEV_SOAINFRA         B2B_RESEQUENCER_MESSAGE                
DEV_SOAINFRA         MEDIATOR_SERVICE_DETAIL                
DEV_SOAINFRA         OSB_SERVICE_DETAIL                     
DEV_SOAINFRA         B2B_SERVICE_DETAIL                     
DEV_SOAINFRA         MEDIATOR_RES_CONTAINERID_LEASE         
DEV_SOAINFRA         B2B_RES_CONTAINERID_LEASE              
DEV_SOAINFRA         OSB_RES_CONTAINERID_LEASE              
DEV_SOAINFRA         LABEL_VERSION_PCBPEL                   
DEV_SOAINFRA         XREF_DATA                              
DEV_SOAINFRA         XREF_DELETED_DATA                      
DEV_SOAINFRA         AIA_CAVSCALLBACKJMSQTAB                
DEV_SOAINFRA         IP_QTAB                                
DEV_SOAINFRA         AQ$_IP_QTAB_S                          
DEV_SOAINFRA         WFUSERVACATION                         
DEV_SOAINFRA         WFWORKQUEUE                            
DEV_SOAINFRA         WFWORKQUEUE_MEMBER                     
DEV_SOAINFRA         WFWORKQUEUE_MANAGER                    
DEV_SOAINFRA         WFWORKQUEUE_SKIP                       
DEV_SOAINFRA         MEDIATOR_AUDIT_DOCUMENT                
DEV_SOAINFRA         MEDIATOR_CALLBACK                      
DEV_SOAINFRA         MEDIATOR_CASE_DETAIL                   
DEV_SOAINFRA         MEDIATOR_CASE_INSTANCE                 
DEV_SOAINFRA         MEDIATOR_CONTAINERID_LEASE             
DEV_SOAINFRA         MEDIATOR_CORRELATION                   
DEV_SOAINFRA         MEDIATOR_DEFERRED_MESSAGE              
DEV_SOAINFRA         MEDIATOR_INSTANCE                      
DEV_SOAINFRA         MEDIATOR_PAYLOAD                       
DEV_SOAINFRA         MFT_SOURCE_MESSAGE                     
DEV_SOAINFRA         MFT_SECURITY_INFO                      
DEV_SOAINFRA         MFT_RETRY_INFO                         
DEV_SOAINFRA         MFT_RESUBMIT_INFO                      
DEV_SOAINFRA         MFT_PAUSED_INSTANCE_INFO               
DEV_SOAINFRA         MFT_TARGET_INSTANCE                    
DEV_SOAINFRA         MFT_ES_AUTHORIZATION                   
DEV_SOAINFRA         MFT_ERROR_INFO                         
DEV_SOAINFRA         MFT_DATA_STORAGE                       
DEV_SOAINFRA         MFT_CALLOUT_INSTANCE                   
DEV_SOAINFRA         MFT_SOURCE_UNPROCESSED                 
DEV_SOAINFRA         MFT_TRANSFER_INSTANCE                  
DEV_SOAINFRA         MFT_SOURCE_LIFECYCLE                   
DEV_SOAINFRA         MFT_TRANSFER_LIFECYCLE                 
DEV_SOAINFRA         MFT_TARGET_LIFECYCLE                   
DEV_SOAINFRA         MFT_TRANSFER_TARGET_REL                
DEV_SOAINFRA         MFT_TRANSFER_SCHEDULE                  
DEV_SOAINFRA         MFT_TARGET_MESSAGE                     
DEV_SOAINFRA         MFT_ES_PORT_ASSIGNMENT                 
DEV_SOAINFRA         MFT_RCU_PURGE                          
DEV_SOAINFRA         MFT_TRIGGER_EVENT                      
DEV_SOAINFRA         AQ$_IP_QTAB_L                          
DEV_SOAINFRA         SYS_IOT_OVER_76460                     
DEV_SOAINFRA         B2B_SYSTEM_MV                          
DEV_SOAINFRA         EDN_EVENT_QUEUE_TABLE                  
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_S            
DEV_SOAINFRA         AQ$_EDN_EVENT_QUEUE_TABLE_L            
DEV_SOAINFRA         SYS_IOT_OVER_76563                     
DEV_SOAINFRA         EDN_OAOO_DELIVERY_TABLE                
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_S          
DEV_SOAINFRA         AQ$_EDN_OAOO_DELIVERY_TABLE_L          
DEV_SOAINFRA         SYS_IOT_OVER_76592                     
DEV_SOAINFRA         EDN_AQJMS_TOPIC_TABLE                  
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_S            
DEV_SOAINFRA         AQ$_EDN_AQJMS_TOPIC_TABLE_L            
DEV_SOAINFRA         SYS_IOT_OVER_76625                     
DEV_SOAINFRA         TASK_NOTIFICATION_Q_T                  
DEV_SOAINFRA         MLOG$_MFT_SOURCE_MESSAGE               
DEV_SOAINFRA         MLOG$_MFT_TRANSFER_INSTANCE            
DEV_SOAINFRA         MLOG$_MFT_TARGET_INSTANCE              
DEV_SOAINFRA         MLOG$_MFT_TARGET_MESSAGE               
DEV_SOAINFRA         MLOG$_MFT_DATA_STORAGE                 
DEV_SOAINFRA         MV_MFT_SOURCE_MESSAGE                  
DEV_SOAINFRA         MV_MFT_PAYLOAD_INFO                    
DEV_SOAINFRA         MV_MFT_TRANSFER                        
DEV_SOAINFRA         MV_MFT_TRANSFER_COUNT_INFO             
DEV_SOAINFRA         MV_MFT_TARGET_INFO                     
DEV_SOAINFRA         MV_MFT_SOURCE_INFO                     
DEV_SOAINFRA         OSB_FTP_TRANSPORT_TBL                  
DEV_SOAINFRA         OSB_SFTP_TRANSPORT_TBL                 
DEV_SOAINFRA         OSB_EMAIL_TRANSPORT_TBL                
DEV_SOAINFRA         OSB_FILE_TRANSPORT_TBL                 
DEV_SOAINFRA         OSB_REPORTING_TBL                      
DEV_SOAINFRA         OSB_REPORTING_ERROR_TBL                
DEV_SOAINFRA         OSB_PURGE_TBL                          
DEV_SOAINFRA         acl                                    
DEV_SOAINFRA         aclentry                               
DEV_SOAINFRA         aclpermission                          
DEV_SOAINFRA         activitysubmission                     
DEV_SOAINFRA         activitysubmissiontype                 
DEV_SOAINFRA         contentdata                            
DEV_SOAINFRA         controlsubmission                      
DEV_SOAINFRA         controlsubmissiontype                  
DEV_SOAINFRA         documentsubmission                     
DEV_SOAINFRA         formmetadatatype                       
DEV_SOAINFRA         formsubmission_roleidentifier          
DEV_SOAINFRA         formsubmission                         
DEV_SOAINFRA         formsubmissiontype                     
DEV_SOAINFRA         formtemplate_languages                 
DEV_SOAINFRA         signaturesubmission                    
DEV_SOAINFRA         template_categories                    
DEV_SOAINFRA         template_features                      
DEV_SOAINFRA         template_tags                          
DEV_SOAINFRA         template                               
DEV_SOAINFRA         USERS                                  
DEV_SOAINFRA         TENANTS                                
DEV_SOAINFRA         TENANTROLES                            
DEV_SOAINFRA         ROLES                                  
DEV_SOAINFRA         USERSROLES                             
DEV_SOAINFRA         TENANTCATEGORIES                       
DEV_SOAINFRA         SPACES                                 
DEV_SOAINFRA         RESOURCES                              
DEV_SOAINFRA         TEMP11G_CUBE_INSTANCE                  
DEV_SOAINFRA         TEMP11G_DOCUMENT_CI_REF                
DEV_SOAINFRA         TEMP11G_DOCUMENT_DLV_MSG_REF           
DEV_SOAINFRA         TEMP11G_XML_DOCUMENT                   
DEV_SOAINFRA         COMPOSITE_INSTANCE_PURGE               
DEV_SOAINFRA         REFERENCE_INSTANCE_PURGE               
DEV_SOAINFRA         COMPOSITE_FAULT_PURGE                  
DEV_SOAINFRA         REJECTED_MESSAGE_PURGE                 
DEV_SOAINFRA         COMPONENT_INSTANCE_PURGE               
DEV_SOAINFRA         TEMP11G_WFTASK_PURGE                   
DEV_SOAINFRA         TEMP_MEDIATOR_INSTANCE                 
DEV_SOAINFRA         PRUNE_RUNNING_INSTS                    
DEV_SOAINFRA         ECID_PURGE                             
DEV_SOAINFRA         TEMP_PROCESSED_CIKEY                   
DEV_SOAINFRA         TEMP_PROCESSED_MI                      
DEV_SOAINFRA         TEMP_FLOWID_PURGE                      
DEV_SOAINFRA         TEMP_PRUNE_RUNNING_INSTS               
DEV_SOAINFRA         TEMP_CUBE_INSTANCE                     
DEV_SOAINFRA         TEMP_DOCUMENT_CI_REF                   
DEV_SOAINFRA         TEMP_DOCUMENT_DLV_MSG_REF              
DEV_SOAINFRA         TEMP_XML_DOCUMENT                      
DEV_SOAINFRA         TEMP_BRDECISION_INSTANCE               
DEV_SOAINFRA         TEMP_WFTASK_PURGE                      
DEV_SOAINFRA         TEMP_MEDIATOR_DEFERRED                 
DEV_SOAINFRA         TEMP_MEDIATOR_RESEQUENCER              
DEV_SOAINFRA         TEMP_MEDIATOR_GROUP                    
DEV_SOAINFRA         JOB_FLOW_CONTROL                       
DEV_SOAINFRA         SOA_PURGE_HISTORY                      
DEV_SOAINFRA         SOA_PURGE_ALERT                        
DEV_SOAINFRA         TEMP_AWR_PURGE                         
DEV_SOAINFRA         TEMP_HC_PURGE                          
DEV_SOAINFRA         VERIFY_GROUP1                          
DEV_SOAINFRA         VERIFY_ECID_GROUP1                     
DEV_SOAINFRA         VERIFY_FABRIC_GROUP1                   
DEV_SOAINFRA         VERIFY_CP_GROUP1                       
DEV_SOAINFRA         VERIFY_BPEL_GROUP1                     
DEV_SOAINFRA         VERIFY_MD_GROUP1                       
DEV_SOAINFRA         VERIFY_MEDIATOR_GROUP1                 
DEV_SOAINFRA         VERIFY_WORKFLOW_GROUP1                 
DEV_SOAINFRA         VERIFY_DC_GROUP2                       
DEV_SOAINFRA         VERIFY_MP_GROUP2                       
DEV_SOAINFRA         VERIFY_DL_GROUP1A                      
DEV_SOAINFRA         TRS_PARAMETER                          
DEV_SOAINFRA         TRS_CUBE_INSTANCE                      
DEV_SOAINFRA         TRS_DOCUMENT_DLV_MSG_REF               
DEV_SOAINFRA         TRS_COMPOSITE_INSTANCE                 
DEV_SOAINFRA         TRS_REFERENCE_INSTANCE                 
DEV_SOAINFRA         TRS_COMPOSITE_INSTANCE_FAULT           
DEV_SOAINFRA         TRS_INSTANCE_PAYLOAD                   
DEV_SOAINFRA         TRS_REJECTED_MESSAGE                   
DEV_SOAINFRA         TRS_COMPONENT_INSTANCE                 
DEV_SOAINFRA         TRS_BRDECISION_INSTANCE                
DEV_SOAINFRA         TRS_WFTASK                             
DEV_SOAINFRA         TRS_MEDIATOR_INSTANCE                  
DEV_SOAINFRA         TRS_MEDIATOR_PAYLOAD                   
DEV_SOAINFRA         TRS_MEDIATOR_PAYLOAD_TEMP              
DEV_SOAINFRA         TRS_MEDIATOR_GROUP_STATUS              
DEV_SOAINFRA         TRS_MEDIATOR_RESEQ_MESSAGE             
DEV_SOAINFRA         TRS_SOA_ECID                           
DEV_SOAINFRA         TRS_XML_DOCUMENT                       
DEV_SOAINFRA         UPGRADE_PARAMETER_TABLE                
DEV_SOAINFRA         UPGRADE_INJECTION                      
DEV_SOAINFRA         UPGRADE_PROGRESS_LOG                   
DEV_SOAINFRA         UPGRADE_OPEN_ECIDS_STATUS              
DEV_SOAINFRA         TEMP_COMPOSITEDN_UPGRADE               
DEV_SOAINFRA         TEMP_COMPOSITEDN_UPGRADE_ALL           
DEV_SOAINFRA         UPGRADE_ERROR_LOG                      
DEV_SOAINFRA         B2B_BAM_QTAB                           
DEV_STB              SERVICETABLE                           
DEV_STB              COMPONENT_SCHEMA_INFO                  
DEV_UMS              ACCESS_POINT                           
DEV_UMS              ADDRESS                                
DEV_UMS              CLIENT                                 
DEV_UMS              CLIENT_ACCESS_POINT                    
DEV_UMS              CLIENT_INSTANCE                        
DEV_UMS              CLIENT_PARAMETER                       
DEV_UMS              CLIENT_QUEUE                           
DEV_UMS              CLIENT_SESSION                         
DEV_UMS              DELIVERY_ATTEMPT                       
DEV_UMS              DELIVERY_CONTEXT                       
DEV_UMS              DRIVER                                 
DEV_UMS              DRIVER_QUEUE                           
DEV_UMS              DRIVER_SESSION                         
DEV_UMS              FILTER                                 
DEV_UMS              MESSAGE                                
DEV_UMS              MESSAGE_TRANSFORM                      
DEV_UMS              PARAMETER                              
DEV_UMS              QUEUE                                  
DEV_UMS              STATUS                                 
DEV_UMS              STATUS_ORPHAN                          
DEV_UMS              DEVICE_ADDRESS                         
DEV_UMS              RULE_SET                               
DEV_UMS              UCP_MEDIA_TYPE                         
DEV_UMS              UCP_USER_ATTRIBUTE                     
DEV_UMS              USER_DEVICE                            
DEV_UMS              ORASDPMAPPDEFRCVT1                     
DEV_UMS              ORASDPMENGINECMDT                      
DEV_UMS              ORASDPMENGINESNDT1                     
DEV_UMS              ORASDPMENGINERCVT1                     
DEV_UMS              ORASDPMWSRCVT1                         
DEV_UMS              ORASDPMDRIVERDEFSNDT1                  
DEV_UMS              ORASDPMENGINEPENDRCVQT                 
DEV_WLS              BEAWPCI                                
DEV_WLS              BEAWRCI                                
DEV_WLS              BEAXACMLAP                             
DEV_WLS              BEAXACMLAP_RS                          
DEV_WLS              BEAXACMLRAP                            
DEV_WLS              BEAXACMLRAP_R                          
DEV_WLS              BEAXACMLRAP_RS                         
DEV_WLS              WEBLOGIC_TIMERS                        
DEV_WLS              WLS_EVENTS                             
DEV_WLS              WLS_HVST                               
DEV_WLS              JOBINSTANCEDATA                        
DEV_WLS              EXECUTIONINSTANCEDATA                  
DEV_WLS              STEPEXECUTIONINSTANCEDATA              
DEV_WLS              JOBSTATUS                              
DEV_WLS              STEPSTATUS                             
DEV_WLS              CHECKPOINTDATA                         
DEV_WLS              BEACSS_SCHEMA_VERSION                  
DEV_WLS              BEAPC                                  
DEV_WLS              BEAPCM                                 
DEV_WLS              BEAPRMP                                
DEV_WLS              BEARM                                  
DEV_WLS              BEASAML2_CACHE                         
DEV_WLS              BEASAML2_ENDPOINT                      
DEV_WLS              BEASAML2_IDPPARTNER                    
DEV_WLS              BEASAML2_IDP_AUDIENCEURI               
DEV_WLS              BEASAML2_IDP_PT_EP                     
DEV_WLS              BEASAML2_IDP_REDIRECTURI               
DEV_WLS              BEASAML2_SPPARTNER                     
DEV_WLS              BEASAML2_SP_AUDIENCEURI                
DEV_WLS              BEASAML2_SP_PT_EP                      
DEV_WLS              BEASAMLAP                              
DEV_WLS              BEASAMLAP_AURI                         
DEV_WLS              BEASAMLAP_ITP                          
DEV_WLS              BEASAMLAP_RURI                         
DEV_WLS              BEASAMLRP                              
DEV_WLS              BEASAMLRP_ACP                          
DEV_WLS              BEASAMLRP_AU                           
DEV_WLS              BEAUPC                                 
DEV_WLS              BEAWCMCI                               
DEV_WLS              BEAWCRE                                
DEV_WLS_RUNTIME      ACTIVE                                 
DEV_MDS              MDS_PARTITIONS                         
DEV_MDS              MDS_PATHS                              
DEV_MDS              MDS_TRANSACTIONS                       
DEV_MDS              MDS_DEPL_LINEAGES                      
DEV_MDS              MDS_LABELS                             
DEV_MDS              MDS_TXN_LOCKS                          
DEV_MDS              MDS_STREAMED_DOCS                      
DEV_MDS              MDS_METADATA_DOCS                      
DEV_MDS              MDS_DEPENDENCIES                       
DEV_MDS              MDS_SANDBOXES                          
DEV_MDS              MDS_NAMESPACES                         
DEV_MDS              MDS_COMPONENTS                         
DEV_MDS              MDS_ATTRIBUTES                         
DEV_MDS              MDS_LARGE_ATTRIBUTES                   
DEV_OPSS             JPS_DN                                 
DEV_OPSS             JPS_ATTRS                              
DEV_OPSS             JPS_ATTRS_BINARY                       
DEV_OPSS             SEQUENCE                               
DEV_OPSS             JPS_CHANGELOG                          
DEV_OPSS             JPS_ENTITY_LOCK                        
DEV_OPSS             JPS_ENTRYID_DELETED                    
DEV_OPSS             CT_0                                   
DEV_OPSS             CT_1                                   
DEV_OPSS             CT_2                                   
DEV_OPSS             CT_3                                   
DEV_OPSS             CT_4                                   
DEV_OPSS             CT_5                                   
DEV_OPSS             CT_6                                   
DEV_OPSS             CT_6_1                                 
DEV_OPSS             CT_6_2                                 
DEV_OPSS             CT_6_3                                 
DEV_OPSS             CT_6_4                                 
DEV_OPSS             CT_7                                   
DEV_OPSS             CT_8                                   
DEV_OPSS             CT_9                                   
DEV_OPSS             CT_9_1                                 
DEV_OPSS             CT_9_2                                 
DEV_OPSS             CT_9_3                                 
DEV_OPSS             CT_10                                  
DEV_OPSS             CT_11                                  
DEV_OPSS             CT_12                                  
DEV_OPSS             CT_13                                  
DEV_OPSS             CT_14                                  
DEV_OPSS             CT_15                                  
DEV_OPSS             CT_16                                  
DEV_OPSS             CT_17                                  
DEV_OPSS             CT_18                                  
DEV_OPSS             CT_19                                  
DEV_OPSS             CT_20                                  
DEV_OPSS             CT_21                                  
DEV_OPSS             CT_22                                  
DEV_OPSS             CT_23                                  
DEV_OPSS             CT_24                                  
DEV_OPSS             CT_25                                  
DEV_OPSS             CT_26                                  
DEV_OPSS             CT_27                                  
DEV_OPSS             CT_28                                  
DEV_OPSS             CT_29                                  
DEV_OPSS             CT_30                                  
DEV_OPSS             CT_31                                  
DEV_OPSS             CT_32                                  
DEV_OPSS             CT_33                                  
DEV_OPSS             CT_34                                  
DEV_OPSS             CT_35                                  
DEV_OPSS             CT_36                                  
DEV_OPSS             CT_37                                  
DEV_OPSS             CT_38                                  
DEV_OPSS             CT_39                                  
DEV_OPSS             CT_40                                  
DEV_OPSS             CT_41                                  
DEV_OPSS             CT_42                                  
DEV_OPSS             CT_43                                  
DEV_OPSS             CT_44                                  
DEV_OPSS             CT_45                                  
DEV_OPSS             CT_46                                  
DEV_OPSS             CT_47                                  
DEV_OPSS             CT_48                                  
DEV_OPSS             CT_49                                  
DEV_OPSS             CT_50                                  
DEV_OPSS             CT_51                                  
DEV_OPSS             CT_52                                  
DEV_OPSS             CT_53                                  
DEV_OPSS             CT_54                                  
DEV_OPSS             CT_55                                  
DEV_OPSS             CT_56                                  
DEV_OPSS             CT_57                                  
DEV_OPSS             CT_58                                  
DEV_OPSS             CT_59                                  
DEV_OPSS             CT_60                                  
DEV_OPSS             CT_61                                  
DEV_OPSS             CT_62                                  
DEV_OPSS             CT_63                                  
DEV_OPSS             CT_64                                  
DEV_OPSS             CT_65                                  
DEV_OPSS             CT_66                                  
DEV_OPSS             CT_67                                  
DEV_OPSS             CT_68                                  
DEV_OPSS             CT_69                                  
DEV_OPSS             CT_70                                  
DEV_OPSS             CT_71                                  
DEV_OPSS             CT_72                                  
DEV_OPSS             CT_73                                  
DEV_OPSS             CT_74                                  
DEV_OPSS             CT_75                                  
DEV_OPSS             CT_76                                  
DEV_OPSS             CT_77                                  
DEV_OPSS             CT_78                                  
DEV_OPSS             CT_79                                  
DEV_OPSS             CT_80                                  
DEV_OPSS             CT_81                                  
DEV_OPSS             CT_82                                  
DEV_OPSS             CT_83                                  
DEV_OPSS             CT_84                                  
DEV_OPSS             CT_85                                  
DEV_OPSS             CT_86                                  
DEV_OPSS             CT_87                                  
DEV_OPSS             CT_88                                  
DEV_OPSS             CT_89                                  
DEV_OPSS             CT_90                                  
DEV_OPSS             CT_91                                  
DEV_OPSS             CT_92                                  
DEV_OPSS             CT_93                                  
DEV_OPSS             CT_94                                  
DEV_OPSS             CT_95                                  
DEV_OPSS             CT_96                                  
DEV_OPSS             CT_97                                  
DEV_OPSS             CT_98                                  
DEV_OPSS             CT_99                                  
DEV_OPSS             CT_100                                 
DEV_OPSS             CT_101                                 
DEV_OPSS             CT_102                                 
DEV_OPSS             CT_103                                 
DEV_OPSS             CT_104                                 
DEV_OPSS             CT_105                                 
DEV_OPSS             CT_106                                 
DEV_OPSS             CT_107                                 
DEV_OPSS             CT_108                                 
DEV_OPSS             CT_109                                 
DEV_OPSS             CT_110                                 
DEV_OPSS             CT_111                                 
DEV_OPSS             CT_112                                 
DEV_OPSS             CT_113                                 
DEV_OPSS             CT_114                                 
DEV_OPSS             CT_115                                 
DEV_OPSS             CT_116                                 
DEV_OPSS             CT_117                                 
DEV_OPSS             CT_118                                 
DEV_OPSS             CT_119                                 
DEV_OPSS             CT_120                                 
DEV_OPSS             CT_121                                 
DEV_OPSS             CT_122                                 
DEV_OPSS             CT_123                                 
DEV_OPSS             CT_124                                 
DEV_OPSS             CT_125                                 
DEV_OPSS             CT_126                                 
DEV_OPSS             CT_127                                 
DEV_OPSS             CT_128                                 
DEV_OPSS             CT_129                                 
DEV_OPSS             CT_130                                 
DEV_OPSS             CT_131                                 
DEV_OPSS             CT_132                                 
DEV_OPSS             CT_133                                 
DEV_OPSS             CT_134                                 
DEV_OPSS             CT_135                                 
DEV_OPSS             CT_136                                 
DEV_OPSS             CT_137                                 
DEV_OPSS             CT_138                                 
DEV_OPSS             CT_139                                 
DEV_OPSS             CT_140                                 
DEV_OPSS             CT_141                                 
DEV_OPSS             CT_142                                 
DEV_OPSS             CT_143                                 
DEV_OPSS             CT_144                                 
DEV_OPSS             CT_145                                 
DEV_OPSS             CT_146                                 
DEV_OPSS             CT_147                                 
DEV_OPSS             CT_148                                 
DEV_OPSS             CT_149                                 
DEV_OPSS             CT_150                                 
DEV_OPSS             CT_151                                 
DEV_OPSS             CT_152                                 
DEV_OPSS             CT_153                                 
DEV_OPSS             CT_154                                 
DEV_OPSS             CT_155                                 
DEV_OPSS             CT_156                                 
DEV_OPSS             CT_157                                 
DEV_OPSS             OES_SQL_STMTS                          
DEV_OPSS             OES_DIST_ID_REF                        
DEV_IAU              IAU_BASE                               
DEV_IAU              WEBCACHECOMPONENT                      
DEV_IAU              OVDCOMPONENT                           
DEV_IAU              OIDCOMPONENT                           
DEV_IAU              OWSM_PM_EJB                            
DEV_IAU              OWSM_AGENT                             
DEV_IAU              DIP                                    
DEV_IAU              OHSCOMPONENT                           
DEV_IAU              JPS                                    
DEV_IAU              ADMINSERVER                            
DEV_IAU              REPORTSSERVERCOMPONENT                 
DEV_IAU              WEBSERVICES                            
DEV_IAU              WS_POLICYATTACHMENT                    
DEV_IAU              OIF                                    
DEV_IAU              OAAM                                   
DEV_IAU              OAM                                    
DEV_IAU              STS                                    
DEV_IAU              SOA_B2B                                
DEV_IAU              SOA_HCFP                               
DEV_IAU              XMLPSERVER                             
DEV_IAU              IAU_DISP_NAMES_TL                      
DEV_IAU              IAU_LOCALE_MAP_TL                      
DEV_IAU              IAU_COMMON                             
DEV_IAU              IAU_CUSTOM                             
DEV_IAU              IAU_AUDITSERVICE                       
DEV_IAU              IAU_CUSTOM_01                          
DEV_IAU              IAU_USERSESSION                        
DEV_IAU              IAU_SCHEMA_VERSION                     
DEV_IAU              MLOG$_IAU_COMMON                       
DEV_IAU              MLOG$_IAU_CUSTOM                       
DEV_IAU              MLOG$_IAU_CUSTOM_01                    

870 Zeilen gewählt.
 I tried to get a relational database model of DEV_SOAINFRA:
Oracle SQL Developer Data Modeler 17.3.0.261.1529
Oracle SQL Developer Data Modeler Importlog
Datum und Uhrzeit: 2017-10-18 20:25:36 MESZ
Entwurfsname: Unbenannt_1
RDBMS : Oracle Database 12cR2

        Alle Anweisungen:         557
        Importierte Anweisungen:     557
        Fehlerhafte Anweisungen:         0
        Nicht erkannte Anweisungen:     0 But as you can (not) see: this model is not really helpful:

Date Calculations and Queries with Oracle Visual Builder Cloud Service

Shay Shmeltzer - Fri, 2017-11-17 12:10

It's very easy to define a field in a custom object in Oracle Visual Builder Cloud Service to store a date, but when it comes to doing calculations and queries based on this date you'll find that you need to resort to a little bit of JavaScript calculations.

Here are a couple of useful things to know if you are trying to do that.

Calculating Age (or time passed from a date in years)

Let's assume you are storing information about employees and one of the pieces of information you have is their date of birth - the Birthday field in the image below.

How do you show their actual age in years on a page?

You can define a calculated field in your business object - and have VBCS use the "calculate value with formula" as the source for this field.

Your formula would be something like:

(new Date() -new Date($birthdate) )/ (60*60*24*1000*365)

You are calculating the difference between today's date and the birthday field and since the answer is in milliseconds you convert it to years by dividing by the number of milliseconds in a year.

Note that as you type in your formula the dialog shows you the results of the formula below the formula field - quite useful to verify that you are doing it right.

Now your page can show the age of your employees:

Filtering Based on Date

What if you wanted to limit the records shown in the table above to only show employees of a specific age?

The tricky part is that you'll need to do the calculation against the birthday field and not against the age field. The age field is not actually stored anywhere - rather it is calculated on the fly.

Let's take the table shown above and assume we want to limit it to show employees who are younger than 9 years. To do that we'll add a query condition to our table to check that the birthday is larger than the date of (today - 9 years).

The calculation of the date 9 years ago will be with a formula like this:

new Date($current_date-9*365*24*60*60*1000)

Now your table only shows older employees.

Want to have a more dynamic way to define the query criteria - you can adopt the approach I showed in the blog about Creating Custom Search/Query Pages with Visual Builder along with the techniques shown here.

One last note - since not every year has 365 days - the calculation for milliseconds conversion is not completely accurate - but it is quite close.

Categories: Development

Generate Dates Between Two Given Dates Through Cursor

Tom Kyte - Fri, 2017-11-17 04:26
I have a table as below Create Session_Detail(ID,Date,Day,Status) I need a button where i write the cursor which is reading start_date and end_date and generate the dates in session_detail as per given start_date and end_date??
Categories: DBA Blogs

ADF Performance on Docker - Lighting Fast

Andrejus Baranovski - Fri, 2017-11-17 02:32
ADF performance depends on server processing power. Sometimes ADF is blamed for poor performance, but in most of the cases real issue is related to poor server hardware, bad programming style or slow response from DB. Goal of this post is to show how fast ADF request could execute and give away couple of suggestions how to minimize ADF request time. This would apply to ADF application running on any environment, not only Docker. I'm using ADF Alta UI based list application with edit fragment.

Rule number one - enable response compression. This will allow to transfer less data and obviously response will execute faster - shorter content download time. See in the screenshot below - JS file is compressed to 87 KB from original 411 KB. Initial page load in ADF generates around 3 MB of content (if this is very first access and static content is not cached yet on client side). With compression initial load of 3 MB will be around 300 - 400 KB. Thats a big difference. In this example ADF page opens in 1.2 seconds (this is equal to client side JS applications, if static content is downloaded on first access):


You can enable content response compression in WebLogic console (will be applied for all deployed Web apps). Go to domain configuration, Web Applications section:


Select checkbox to enable GZIP compression and provide a list of content types to be compressed:


Thats it - content compression is set.

When I navigate to edit fragment - request is executed in 305 ms. Thanks to fast Docker engine (running on Digital Ocean - Oracle ADF on Docker Container) and content response compression: 3.44 KB transferred for 14.49 KB original content:


Let's try Save operation. I changed Hire Date attribute and then pressed Save button. This will trigger Commit operation in ADF, push data to ADF BC and then execute DML statement with commit in DB. All these steps are completed in 113 ms.


Don't believe anyone who says ADF is slow. As you can see, ADF request is very fast fundamentally - but of course it can become slow, if you add a lot of data fetch and processing logic on top (blame yourself). Client side JS application would not run faster, if it would call backend REST service to save data. The only advantage of JS client side application in this case would be that it executes backend REST call asynchronously, while ADF calls requests in synchronous manner. However, it all depends - sometimes asynchronous calls are not suitable for business logic either.

How come ADF BC call to DB completes so fast? For that we need to check Data Source Connection Delay Time on WLS. In Docker (Digital Ocean) environment it is ridiculously short (thats very good): 66 ms. Check same on your server (go to Data Source monitoring in WLS console), longer delay time means slower response from DB and slower ADF performance:


Navigation back to the list runs in 356 ms, with 197.96 KB of content compressed to 10.47 KB. This is very fast, 350 ms response time is something that user would not notice (almost equal to processing on client side):


To optimize ADF performance, make sure you are using ChangeEventPolicy = NONE for iterators in Page Definitions:

Migrate EBS (R12) to Cloud , SSL & GoldenGate Install

Online Apps DBA - Fri, 2017-11-17 02:17

[K21Academy Weekly Newsletter] 171116 Subject: Migrate EBS(R12) To Cloud, SSL & GoldenGate Install In this weeks issue, you will find:- 1. Migrating Oracle EBS (R12) to Cloud ? 10 Things You must consider before Migration (Lift & Shift) 2. SSL in Oracle Fusion Middleware (WebLogic, OHS, SOA, OAM, OID, OVD etc 3. Oracle GoldenGate: Installation […]

The post Migrate EBS (R12) to Cloud , SSL & GoldenGate Install appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Partner Webcast – Lifting & Shifting Oracle Applications to Oracle Cloud

Oracle Applications Unlimited is Oracle’s commitment to continuously innovate in current applications while also delivering the next generation of cloud applications. Many enterprises have...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Great Britain and Northern Ireland February 2018 Dates: “Oracle Indexing Internals and Best Practices” Seminar (Battle For Britain)

Richard Foote - Fri, 2017-11-17 00:25
Attention Oracle Professionals in the United Kingdom !! I have now finalised all the dates and venues for a series of my popular and critically acclaimed “Oracle Indexing Internals and Best Practices” seminar I’ll be running in the UK in February 2018. I’m extremely excited as this will be the first time I’ve delivered this […]
Categories: DBA Blogs

CBO, FIRST_ROWS and VIEW misestimate

Yann Neuhaus - Thu, 2017-11-16 23:36

There are several bugs with the optimizer in FIRST_ROWS mode. Here is one I encountered during a 10.2.0.4 to 12.2.0.1 migration when a view had an ‘order by’ in its definition.

Here is the test case that reproduces the problem.

A big table:

SQL> create table DEMO1 (n constraint DEMO1_N primary key,x,y) as select 1/rownum,'x','y' from xmltable('1 to 1000000');
Table DEMO1 created.

with a view on it, and that view has an order by:

SQL> create view DEMOV as select * from DEMO1 order by n desc;
View DEMOV created.

and another table to join to:

SQL> create table DEMO2 (x constraint DEMO2_X primary key) as select dummy from dual;
Table DEMO2 created.

My query reads the view in a subquery, adds a call to a PL/SQL function, and joins the result with the other table:


SQL> explain plan for
select /*+ first_rows(10) */ *
from
( select v.*,dbms_random.value from DEMOV v)
where x in (select x from DEMO2)
order by n desc;
 
Explained.

You can see that I run it with FIRST_ROWS(10) because I actually want to fetch the top-10 rows when ordered by N. As N is a number and I have an index on it and there are no nulls (it is the primary key) I expect to read the first 10 entries from the index, call the function for each of them, then nested loop to the other tables.

In the situation I encountered it, this is what was done in 10g but when migrated to 12c the query was very long because it called the PL/SQL function for million of rows. Here is the plan in my example:


SQL> select * from dbms_xplan.display(format=>'+projection');
 
PLAN_TABLE_OUTPUT
-----------------
Plan hash value: 2046425878
 
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time |
--------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 21 | | 7 (0)| 00:00:01 |
| 1 | NESTED LOOPS SEMI | | 1 | 21 | | 7 (0)| 00:00:01 |
| 2 | VIEW | DEMOV | 902 | 17138 | | 7 (0)| 00:00:01 |
| 3 | SORT ORDER BY | | 968K| 17M| 29M| 6863 (1)| 00:00:01 |
| 4 | TABLE ACCESS FULL | DEMO1 | 968K| 17M| | 1170 (1)| 00:00:01 |
| 5 | VIEW PUSHED PREDICATE | VW_NSO_1 | 1 | 2 | | 0 (0)| 00:00:01 |
|* 6 | INDEX UNIQUE SCAN | DEMO2_X | 1 | 2 | | 0 (0)| 00:00:01 |
--------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
6 - access("X"="V"."X")
 
Column Projection Information (identified by operation id):
-----------------------------------------------------------
 
1 - (#keys=0) "V"."N"[NUMBER,22], "V"."X"[CHARACTER,1], "V"."Y"[CHARACTER,1] 2 - "V"."N"[NUMBER,22], "V"."X"[CHARACTER,1], "V"."Y"[CHARACTER,1] 3 - (#keys=1) INTERNAL_FUNCTION("N")[22], "X"[CHARACTER,1], "Y"[CHARACTER,1] 4 - "N"[NUMBER,22], "X"[CHARACTER,1], "Y"[CHARACTER,1]

A full table scan of the big table, with a call to the PL/SQL function for each row and the sort operation on all rows. Then the Top-10 rows are filtered and the nested loop operates on that. But you see the problem here. The cost of the ‘full table scan’ and the ‘order by’ has been evaluated correctly, but the cost after the VIEW operation is minimized.

My interpretation (but it is just a quick guess) is that the the rowset is marked as ‘sorted’ and then the optimizer considers that the cost to get first rows is minimal (as if it were coming from an index). However, this just ignores the initial cost of getting this rowset.

I can force with a hint the plan that I want – index full scan to avoid a sort and get the top-10 rows quickly:

SQL> explain plan for
select /*+ first_rows(10) INDEX_DESC(@"SEL$3" "DEMO1"@"SEL$3" ("DEMO1"."N")) */ *
from
( select v.*,dbms_random.value from DEMOV v)
where x in (select x from DEMO2)
order by n desc;
 
Explained.

This plan is estimated with an higher cost than the previous one and this is why it was not chosen:

SQL> select * from dbms_xplan.display(format=>'+projection');
PLAN_TABLE_OUTPUT
Plan hash value: 2921908728
 
------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 21 | 9 (0)| 00:00:01 |
| 1 | NESTED LOOPS SEMI | | 1 | 21 | 9 (0)| 00:00:01 |
| 2 | VIEW | DEMOV | 902 | 17138 | 9 (0)| 00:00:01 |
| 3 | TABLE ACCESS BY INDEX ROWID| DEMO1 | 968K| 17M| 8779 (1)| 00:00:01 |
| 4 | INDEX FULL SCAN DESCENDING| DEMO1_N | 968K| | 4481 (1)| 00:00:01 |
| 5 | VIEW PUSHED PREDICATE | VW_NSO_1 | 1 | 2 | 0 (0)| 00:00:01 |
|* 6 | INDEX UNIQUE SCAN | DEMO2_X | 1 | 2 | 0 (0)| 00:00:01 |
------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
6 - access("X"="V"."X")
 
Column Projection Information (identified by operation id):
-----------------------------------------------------------
 
1 - (#keys=0) "V"."N"[NUMBER,22], "V"."X"[CHARACTER,1], "V"."Y"[CHARACTER,1] 2 - "V"."N"[NUMBER,22], "V"."X"[CHARACTER,1], "V"."Y"[CHARACTER,1] 3 - "N"[NUMBER,22], "X"[CHARACTER,1], "Y"[CHARACTER,1] 4 - "DEMO1".ROWID[ROWID,10], "N"[NUMBER,22]

This cost estimation is fine. The cost of getting all rows by index access is higher than with a full table scan, but the optimizer knows that the actual cost is proportional to the number of rows fetched and then it adjusts the cost accordingly. This is fine here because the VIEW has only non-blocking operations. The problem in the first plan without the hint, was because the same arithmetic was done, without realizing that the SORT ORDER BY is a blocking operation and not a permanent sorted structure, and must be completed before being able to return the first row.

In this example, as in the real case I’ve encountered, the difference in cost is very small (7 versus 9 here) which means that the plan can be ok and switch to the bad one (full scan, call function for all rows, sort them) with a small change in statistics. Note that I mentioned that the plan was ok in 10g but that may simply be related to the PGA settings and different estimation for the cost of sorting.

 

Cet article CBO, FIRST_ROWS and VIEW misestimate est apparu en premier sur Blog dbi services.

Quick introduction to Oracle Container Registry–running one of Oracle’s prebaked images

Amis Blog - Thu, 2017-11-16 22:47

Oracle has been active with Docker for quite some time now. From the first hesitant steps from some enthusiastic employees with Docker build files that helped people to get going with Oracle software in their experimental containers to a GitHub repo with a broad set of extensive Docker build files to create Docker containers with various Oracle product that are supported (https://github.com/oracle/docker-images). And of course the Oracle Container Cloud – launched in the Spring of 2017 that will run custom Docker images. And now recently the next step: the availability of the Oracle Container Registry – Oracle’s own Docker container registry that offers a range of ready built container images with Oracle software. Using these images – all you need to run Oracle platform component on your local Docker Host or Kubernetes cluster is docker pull from this registry followed by a docker run.

In this article I will give a quick example of how to work this the Oracle Container Registry. It can be found at:  https://container-registry.oracle.com .

The steps to go through:

1. Register as a user for the Oracle Container Registry (one time only, an Oracle account is required)

2. Explore the registry, locate the desired image(s) and Agree to and accept the Oracle Standard Terms and Restrictions for the image(s) that you want to make use of

3. Do a docker login to connect to the Oracle Container Registry

4. Pull the image(s) that you need

5. Run the image(s)

Open the link for the Container Registry:

image

Click on Register. Sign On with an existing Oracle Account or start the flow for creating such an accountimage

Provide the account’s credentials. The click on Create New User.

SNAGHTML9181a91

A confirmation email is sent:

image

And now the opening page lists the areas in which currently images are provided:

image

You can explore what images are available, for example for the database:

image

And for Java:

image

Before you can download any image, you need to accept the terms for that specific image – a manual step in the user interface of the container registry:

image

image

image

After pressing Accept, this image is now available to be pulled from docker.

image

Run Docker container based on Oracle’s Java Runtime Image

I will focus now on the Java Run Time image – one of the smaller images on the registry – to demonstrate the steps for running it in my local Docker host.

Accept the terms:

image

Click on the name of image to get the details and the docker pull command required for this image:

image

Check out the tags:

image

We wil go for the latest.

From the Docker host, first do a login, using your Oracle account credentials:

docker login –u username –p password container-registry.oracle.com

SNAGHTML92082caThen use docker pull, using the command provided on the image page:

docker pull container-registry.oracle.com/java/serverjre

The image is downloaded and stored locally in the image cache.

image

image

When the download is complete the image (not small mind you, at 377 MB) is available to be used for running container instances, in the regular Docker way. For example:

docker run -it container-registry.oracle.com/java/serverjre

image

Et voila: the container is running locally based on a pre built image. No local build steps are required, no downloading of required software packages and special configurations to be applied. The Java runtime is fairly straightforward. With running the Oracle Docker image for the enterprise database or the Fusion Middleware infrastructure, the gain is even bigger from using the prebuilt image from the Oracle Container Registry.

If you want to free up local space, you can of course remove the Oracle Docker image. After all, it is easy to pull it again from the registry.

image

The post Quick introduction to Oracle Container Registry–running one of Oracle’s prebaked images appeared first on AMIS Oracle and Java Blog.

Docker-CE on Ubuntu 17.10 (Artful Aardvark)

Dietrich Schroff - Thu, 2017-11-16 15:07
Today docker is only added to the repositories up to ubuntu version 17.04:

If you want to run docker on 17.10 you have to perform the following steps:
After that 
# docker run hello-world
Unable to find image 'hello-world:latest' locally
latest: Pulling from library/hello-world
9a0669468bf7: Pull complete
Digest: sha256:cf2f6d004a59f7c18ec89df311cf0f6a1c714ec924eebcbfdd759a669b90e711
Status: Downloaded newer image for hello-world:latest

Hello from Docker!
This message shows that your installation appears to be working correctly.

To generate this message, Docker took the following steps:
 1. The Docker client contacted the Docker daemon.
 2. The Docker daemon pulled the "hello-world" image from the Docker Hub.
 3. The Docker daemon created a new container from that image which runs the
    executable that produces the output you are currently reading.
 4. The Docker daemon streamed that output to the Docker client, which sent it
    to your terminal.

To try something more ambitious, you can run an Ubuntu container with:
 $ docker run -it ubuntu bash

Share images, automate workflows, and more with a free Docker ID:
 https://cloud.docker.com/

For more examples and ideas, visit:
 https://docs.docker.com/engine/userguide/

Pages

Subscribe to Oracle FAQ aggregator