Feed aggregator

Index creation slow - lots of direct path write/temp waits

Tom Kyte - Thu, 2019-02-07 00:46
I have a table on which I'm trying to index a column. This happens as part of an ETL process, however I have run this process directly to reproduce. The table in question has about 15M rows and I am trying to index a single column. create index x...
Categories: DBA Blogs

Created file using UTL_FILE. How to prevent file from being picked up before it has been fully created

Tom Kyte - Thu, 2019-02-07 00:46
We have an integration where the file is being created in oracle ebs using utl_file utility. The file is placed on the server where biztalk pings every 60 sec and picks it up. In one scenario the file was picked up before it was written out resulting...
Categories: DBA Blogs

When are partition statistics beneficial?

Tom Kyte - Thu, 2019-02-07 00:46
Tom, When are partition-level statistics used by the optimizer in 9iR2 and 10g? The only thing I've found in the docs so far (trying to avoid RTFM) is that they're used when a query fit the form SELECT ... FROM MYTABLE PARTITION (PTN_NAME). Specif...
Categories: DBA Blogs

oracle database parameters

Tom Kyte - Thu, 2019-02-07 00:46
Dear Tom, I'm trying to test the oracle 12C reporting system, in which i will dump the oracle database transaction database backup to report system. For better performance of completed reporting system, what are the parameters i need to set perfe...
Categories: DBA Blogs

GROUP BY returns incorrect number of rows

Tom Kyte - Thu, 2019-02-07 00:46
Hi A bit of an odd one - possibly a bug. <code>DROP TABLE xxibpc_test; CREATE TABLE xxibpc_test AS WITH data AS (SELECT LEVEL l_no FROM dual CONNECT BY LEVEL <= 10000) SELECT 1 instance_number ,1 + l_no session_id ,10...
Categories: DBA Blogs

Special Tables in OUAF based products

Anthony Shorten - Wed, 2019-02-06 22:47

Long time users of the Oracle Utilities Application Framework might recognize two common table types, recognized by their name suffixes, that are attached to most Maintenance Objects within the product:

  • Language Tables (Suffix _L).  The Oracle Utilities Application Framework is multi-lingual and can support multiple languages at a particular site (for example customers who have multi-lingual call centers or operate across jurisdictions where multiple languages are required). The Language table holds the tags for each language for any fields that need to display text on a screen. The Oracle Utilities Application Framework matches the right language records based upon the users language profile (and active language code).
  • Key Tables (Suffix _K). These tables hold the key values (and the now less used environment code) that are used in the main object tables. The original use for these tables was for key tracking in the original Archiving solution (which has now been replaced by ILM). Now that the original Archiving is not available, the role of these tables changed to be used in a number of areas:
    • Conversion. The conversion toolkit in Oracle Utilities Customer Care and Billing and now in the Cloud Service Foundation, uses the key table for efficient key generation and black listing of identifiers.
    • Key Generation. The Key generation utilities now use the key tables to quickly ascertain the uniqueness of a key. This is far more efficient than using the main table for this, especially with caching support in the database.
    • Information Life-cycle Management. The ILM capability uses the key tables to drive some of its processes including recognizing when something is archived and when it has been restored.

These tables are important for the operation of the Oracle Utilities Application Framework for all types of parts of the product. When you see them now you understand why they are there.

Spring Cloud GCP and authentication from your Spring Boot Application

Pas Apicella - Wed, 2019-02-06 17:18
When using Spring Cloud GCP you will need to authenticate at some point in order to use the GCP services. In this example below using a GCP Cloud SQL instance you really only need to do 3 things to access it externally from your Spring Boot application as follows.

1. Enable the Google Cloud SQL API which is detailed here

  https://cloud.google.com/sql/docs/mysql/admin-api/

2. Ensure that your GCP SDK can login to your Google Cloud SQL. This command will take you to a web page asking which google account you want to use

  $ gcloud auth application-default login

3. Finally some application properties in your Spring Boot application detailing the Google Cloud SQL instance name and database name as shown below.

spring.cloud.gcp.sql.instance-connection-name=fe-papicella:australia-southeast1:apples-db
spring.cloud.gcp.sql.database-name=employees

Now when you do that and your application starts up you will see a log message as follows below clearly warning you this this method of authentication can have implications at some point.

2019-02-07 09:10:26.700  WARN 2477 --- [           main] c.g.a.oauth2.DefaultCredentialsProvider  : Your application has authenticated using end user credentials from Google Cloud SDK. We recommend that most server applications use service accounts instead. If your application continues to use end user credentials from Cloud SDK, you might receive a "quota exceeded" or "API not enabled" error. For more information about service accounts, see https://cloud.google.com/docs/authentication/.

Clearly that's something we have to resolve. To do that we simply can add another Spring Boot application property pointing to a service account JSON file for us to authenticate against to remove the warning.

spring.cloud.gcp.credentials.location=file:/Users/papicella/piv-projects/GCP/fe-papicella-8077fe1126b2.json

Note: You can also use an ENV variable as follows

export GOOGLE_APPLICATION_CREDENTIALS="[PATH]"

You can get a JSON key generated from the GCP console "IAM and Admin -> Service Accounts" page


For more information on authentication visit this link https://cloud.google.com/docs/authentication/getting-started



Categories: Fusion Middleware

Oracle E-Business Suite and Applications Unlimited Continued Oracle Investment—No Upgrades

Chris Warticki - Wed, 2019-02-06 13:13
Continued Oracle Investment for Years to Come

In June 2018, Oracle published the “Applications and Support—an Unbeatable Combination” announcement. This message re-affirmed Oracle’s commitment to the Applications Unlimited products with continuing development and support through at least 2030. The products covered by  Applications Unlimited are Oracle E-Business Suite, PeopleSoft, JD Edwards EnterpriseOne, and Siebel.

The June announcement committed Oracle E-Business Suite Development to move to the continuous innovation release model for the next major release (identified as 12.X), as explained in the Oracle E-Business Suite publication.

  Continuous Innovation Release Announced

In the subsequent October 2018 announcement, Oracle E-Business Suite announced that we will implement continuous innovation on the current 12.2 release. 

 

Significance to Oracle E-Business Suite Customers

This is important to Oracle E-Business Suite customers because the announcement:

  • Restates Oracle’s commitment to Oracle E-Business Suite.
  • Clarifies that the inter-dependency of the applications and technology stack has been uncoupled, and it will be possible to perform “tools only” updates (affecting the application layer), without being forced to update the technology stack at the same time, or conversely, tech stack updates without updating the applications.
  • Means it will be easier for customers to remain current—on the continuous innovation release—and benefit from the latest developments.
  • Removes the justification for 12.1.3 users to delay upgrading, as once they have migrated to 12.2, they can remain on that release for at least through 2030.
  • Sets the record straight—responding to/countering some of the misinformation and rumors, which have been circulated, stating that Oracle E-Business Suite will not be developed or supported.

 

Oracle Applications Unlimited

With continuous innovation now available for Oracle E-Business Suite 12.2, Oracle E-Business Suite joins the other Applications Unlimited products that also have pledged to provide continuous innovation and Oracle Premier Support through at least 2030 for their current continuous innovation releases.

 

 

Committed to Customers | Committed to Innovation | Committed to Products

 

Learn More

 

 

Replacements for OrdDoc

Tom Kyte - Wed, 2019-02-06 06:26
I have been using OrdDoc to store files and attachments for my applications. It looks like Oracle has deprecated this and will no longer support it in its next release (https://mikedietrichde.com/2018/08/10/oracle-multimedia-is-deprecated-in-oracle-1...
Categories: DBA Blogs

CDC on Views

Tom Kyte - Wed, 2019-02-06 06:26
Hi Tom, I have a view created daily on a detailed table set ( n number of tables based on the load) as below CDR_Detail_20190204_view CDR_Detail_20190205_view CDR_Detail_20190206_view To generate a report , i need to pick all the daily views(...
Categories: DBA Blogs

Can I force query to use the varchar index if the condition uses a number value

Tom Kyte - Wed, 2019-02-06 06:26
Hi, I've got the following sql statement: <code>SELECT C.APPLICATION_NUMBER, D.AGREEMENT_TYPE, C.SUPPLIER_REFERENCE FROM APPLICATION_DATA D, APPLICATION C WHERE C.APPLICATION_NUMBER =:b1 AND D.APPLICATION_ID = C.APPLICATION_ID;</code> ...
Categories: DBA Blogs

Windows Oracle11g to Linux Oracle 12c

Tom Kyte - Wed, 2019-02-06 06:26
Hi, hope you're doing great? I wonder if you can help me by giving me some advices or pointing me to some useful docs. In fact, we are planning to migrate a financial application with most of its business logic is written in Pl/SQL, from Windows Orac...
Categories: DBA Blogs

Performance degradation after database restoration

Tom Kyte - Wed, 2019-02-06 06:26
HI ALL, I HAVE A PROBLEM HERE WE are running an application(FOR REPORTING ONLY) with Oracle database 11.2, Data for this oracle database is getting from SQL server ( users are inserting data into SQL server first and finally with the help o...
Categories: DBA Blogs

Max number of processes

Tom Kyte - Wed, 2019-02-06 06:26
hi - we recently had a code change in our production database. Since then we see that every 2 days we have hundereds of inactive sessions in the database and maximum number of processes is reached. We increased this number a couple of times and every...
Categories: DBA Blogs

Storing JSON file in the database

Tom Kyte - Wed, 2019-02-06 06:26
I created a table with two JSON columns. CREATE TABLE USER.JSON_DOCS ( id RAW(16) NOT NULL, file CLOB, CONSTRAINT json_docs_pk PRIMARY KEY (id), CONSTRAINT json_docs_chk CHECK (file IS JSON) ); Then I tried to storage a JSON in...
Categories: DBA Blogs

View that can be used to get last SQL elapsed time

Tom Kyte - Wed, 2019-02-06 06:26
Hello Gentlemen, We currently don't have OEM tool. Is there a data dictionary view that can be queried that will provide the last elapsed time for a particular query that has an elapsed time of less than 5 seconds? v$sql view has a column called...
Categories: DBA Blogs

Create Databases from Automatic Daily Backups - New Feature - Jan 2019 - Oracle Cloud Infrastructure

Senthil Rajendran - Wed, 2019-02-06 03:03
New Feature - Create Databases from Automatic Daily Backups
Services : Block Volume
Release Month : Jan 2019

Automatic Daily Backup feature lets you to create automated backups of OCI DB System Databases on a daily basis. With this feature you can now create a new system out of the automated daily backups.

Here is a DB System in OCI that is created and you can see there is a Automated Backup Running













Once the backup is completed you will see that it is ready for the refresh





From the backup section select Create Backup and fill in the required details





Once you start the database creation process you will see the restore process beginning immediately.



The DB System will have your database in provisioning stage



Once restore is done you will be having your new Database up and running.



This is indeed a cool feature. I bet your DBA will love to see this , he can now start looking into other useful stuffs.



New OA Framework 12.2.7 Update 2 Now Available

Steven Chan - Tue, 2019-02-05 18:00

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure.

We periodically release updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.7 is now available:

Oracle Application Framework (FWK) Release 12.2.7 Bundle 2 (Patch 28963259:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.7 users should apply this patch. Future OAF patches for EBS Release 12.2.7 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch includes fixes for the following issues:

  • When the LOV search icon is clicked, the link ‘Skip navigation elements to page contents’ takes focus.
  • When adding attachments, an attachment title longer than 256 multibyte characters raises an error.

Related Articles

Categories: APPS Blogs

HP Color LaserJet MFP on Ubuntu: Scan Error during device I/O (code=9)

Dietrich Schroff - Tue, 2019-02-05 13:57
I decided to use a multi function printer including scanner and fax with my ubuntu systems.
First step was to download the hplip package from HP:
https://developers.hp.com/hp-linux-imaging-and-printing/gethplip

The installation process worked like a charme
bash ./hplip-3.19.1.run But running the scan utility ends up with the following error:


$ hp-scan

HP Linux Imaging and Printing System (ver. 3.19.1)
Scan Utility ver. 2.2

Copyright (c) 2001-15 HP Development Company, LP
This software comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to distribute it
under certain conditions. See COPYING file for more details.

warning: No destinations specified. Adding 'file' destination by default.
Using device hpaio:/net/HP_ColorLaserJet_MFP_M278-M281?ip=192.168.178.200
Opening connection to device...
error: SANE: Error during device I/O (code=9)After searching around the solution was the following:
"Install the plugin"?
!

$ hp-plugin





HP Linux Imaging and Printing System (ver. 3.19.1)
Plugin Download and Install Utility ver. 2.1

Copyright (c) 2001-15 HP Development Company, LP
This software comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to distribute it
under certain conditions. See COPYING file for more details.


HP Linux Imaging and Printing System (ver. 3.19.1)
Plugin Download and Install Utility ver. 2.1

Copyright (c) 2001-15 HP Development Company, LP
This software comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to distribute it
under certain conditions. See COPYING file for more details.

Checking for network connection...
Downloading plug-in from:
Plugin is not accessible. Trying to download it from fallback location: [https://developers.hp.com/sites/default/files/hplip-3.19.1-plugin.run]
Receiving digital keys: /usr/bin/gpg --homedir /home/esther/.hplip/.gnupg --no-permission-warning --keyserver pgp.mit.edu --recv-keys 0x4ABA2F66DBD5A95894910E0673D770CDA59047B9
Creating directory plugin_tmp
Verifying archive integrity... All good.
Uncompressing HPLIP 3.19.1 Plugin Self Extracting Archive..............................................................

HP Linux Imaging and Printing System (ver. 3.19.1)
Plugin Installer ver. 3.0

Copyright (c) 2001-15 HP Development Company, LP
This software comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to distribute it
under certain conditions. See COPYING file for more details.

Plug-in version: 3.19.1
Installed HPLIP version: 3.19.1
Number of files to install: 64


Done.
 Plug-in installation successful

Done.After that running hp-scan immediately creates a PNG file with the scan:
 hp-scan

HP Linux Imaging and Printing System (ver. 3.19.1)
Scan Utility ver. 2.2

Copyright (c) 2001-15 HP Development Company, LP
This software comes with ABSOLUTELY NO WARRANTY.
This is free software, and you are welcome to distribute it
under certain conditions. See COPYING file for more details.

warning: No destinations specified. Adding 'file' destination by default.
Using device hpaio:/net/HP_ColorLaserJet_MFP_M278-M281?ip=192.168.178.200
Opening connection to device...

Resolution: 300dpi
Mode: gray
Compression: JPEG
Scan area (mm):
  Top left (x,y): (0.000000mm, 0.000000mm)
  Bottom right (x,y): (215.899994mm, 296.925995mm)
  Width: 215.899994mm
  Height: 296.925995mm
Destination(s): file
Output file:
warning: File destination enabled with no output file specified.
Setting output format to PNG for greyscale mode.
warning: Defaulting to '/home/esther/Downloads/hpscan001.png'.

Warming up...


Scanning...
Reading data: [*************************************************************************************************************************] 100%  8.5 MB    
Read 8.5 MB from scanner.
Closing device.

Outputting to destination 'file':

Done.This is really fast. But if you want a GUI just use xsane...

Keeping a column constant

Tom Kyte - Tue, 2019-02-05 12:26
Hi, <code>Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit</code> We have a need to keep certain values in a table constant in a cloned database. We store email addresses in a table, and use these for generating email commu...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator