Feed aggregator

Oracle PLSQL Writing Excel File

Tom Kyte - Wed, 2018-01-31 06:26
Hi Tom, Thanks for being with us! I have a excel file with a template, what my requirement is to copy that template from that excel file to new excel file and also append some data into the same excel file with template. when I tried to write ...
Categories: DBA Blogs

Any scenairo where Optimizer will not use an active SQL profile

Tom Kyte - Wed, 2018-01-31 06:26
Hi team, If a SQL query has an active(ENABLED) profile, will there be any scenario when Optimizer will not use it? E.g. As I know the profile is auxiliary statistics on all objects being referenced by underlying SQL query. So if we gather stat...
Categories: DBA Blogs

Cannot enable table locks - ORA-00054: resource busy

Tom Kyte - Wed, 2018-01-31 06:26
Hello, I have one user who has disabled table locks on a table, and now we can't enable lock on this table : SQL> alter table USER.SOME_TABLE enable table lock; alter table USER.SOME_TABLE enable table lock * ORA-00054: resource busy and a...
Categories: DBA Blogs

TDE Column Enablement

Tom Kyte - Wed, 2018-01-31 06:26
Hi Oracle Masters, Two questions: 1) I read the below line in "Advanced Security Guide" for TDE: "If you enable TDE column encryption on a very large table, then you may need to increase the redo log size to accommodate the operation". Ho...
Categories: DBA Blogs

Column Creation Time

Tom Kyte - Wed, 2018-01-31 06:26
Hi Tom, I want to view the time at which a particular column is created/added in the table. USER_TAB_COLUMNS does not contain the column creation/modification timestamp. USER_OBJECTS has LAST_DDL_TIME which is at the Table level. I need Colum...
Categories: DBA Blogs

how to specify block size when installing database silently with dbca

Tom Kyte - Wed, 2018-01-31 06:26
Hi Tom, I use the script below to create database, but I want to know how to specify db block size.I didnot find a parameter in dbca.rsp corresonding to this. And block size is hard to be changed once the database is created. So can you please tell ...
Categories: DBA Blogs

ORA-24263: Certificate of the remote server does not match the target address

Tom Kyte - Wed, 2018-01-31 06:26
Dear Ask TOM Team, We have upgrade our DEV Environment to the Oracle 12.2 Release and we are about to finish our upgrade tests. Now one test that we thought should be a simple one is the SEND Mail over the UTL_SMTP package. In the release 12.1 we...
Categories: DBA Blogs

GDPR - backups and database design

Tom Kyte - Wed, 2018-01-31 06:26
Really surprised to see that nobody had any queries posted on the impacts on backup strategies related to GDPR. There is a clause which says right to erase personal data with respect to the GDPR and we are thinking on the possible ways the backup ...
Categories: DBA Blogs

Goldengate Tracing Network Ports

Michael Dinh - Tue, 2018-01-30 22:30
--- Find mgr process
$ ps -ef|grep ./mgr
ggs  11823     1  0  2017 ?        00:29:13 ./mgr PARAMFILE /u01/app/ggs/dirprm/mgr.prm REPORTFILE /u01/app/ggs/dirrpt/MGR.rpt PROCESSID MGR
ggs  45054 30127  0 14:15 pts/0    00:00:00 grep --color=auto ./mgr

--- Find extract process
$ ps -ef|grep ./extract
ggs  17604 30127  0 14:15 pts/0    00:00:00 grep --color=auto ./extract
ggs  44306 11823  0 03:33 ?        00:01:28 /u01/app/ggs/extract PARAMFILE /u01/app/ggs/dirprm/e_hawk.prm REPORTFILE /u01/app/ggs/dirrpt/e_hawk.rpt PROCESSID e_hawk
ggs  44354 11823  0 03:33 ?        00:00:48 /u01/app/ggs/extract PARAMFILE /u01/app/ggs/dirprm/p_hawk.prm REPORTFILE /u01/app/ggs/dirrpt/p_hawk.rpt PROCESSID p_hawk

--- Find mgr port
$ lsof -i -P |grep 11823
mgr     11823 ggs    6u  IPv4 3492119103      0t0  TCP *:7809 (LISTEN)

--- Find extract port
$ lsof -i -P |grep 44306
extract 44306 ggs    6u  IPv4 2827659844      0t0  TCP *:7840 (LISTEN)

$ lsof -i -P |grep 44354
extract 44354 ggs    6u  IPv4 2827649786      0t0  TCP *:7841 (LISTEN)
extract 44354 ggs   10u  IPv4 2827610899      0t0  TCP hawk.local:21252->eagle.local:7822 (ESTABLISHED)

--- Use Goldengate to find the same info. However, it does only provides local port.
$ ./ggsci 

Oracle GoldenGate Command Interpreter for Oracle
Version OGGCORE_12.
Linux, x64, 64bit (optimized), Oracle 12c on Jul 21 2017 23:31:13
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2017, Oracle and/or its affiliates. All rights reserved.

GGSCI> send manager childstatus debug

Sending CHILDSTATUS request to MANAGER ...

Child Process Status - 2 Entries

ID      Group   Process Retry Retry Time          Start Time          Port
---- -------- --------- ----- ------------------- ------------------- ----
   0   e_hawk     44306     0 None                2017/11/20 19:49:14 7840
   1   p_hawk     44354     0 None                2017/11/20 19:55:43 7841


Oracle Solaris 11.4 Beta publicly available on Oracle Technology Network (OTN)

Wim Coekaerts - Tue, 2018-01-30 13:49

Oracle Solaris 11.4 Beta is downloadable from OTN as of right now.  This is a very exciting milestone. Go and download it and play with it!


For more information see:




Open database read only

Tom Kyte - Tue, 2018-01-30 12:06
What is a command to change DB open mode from read write to read only without restarting the instance
Categories: DBA Blogs

How to find last inserted records from table

Tom Kyte - Tue, 2018-01-30 12:06
HI TOM, PLEASE EXPLAIN How to find last inserted records from table? IN ORACLE? THANKS BALA
Categories: DBA Blogs

Obtain all JSON keys from JSON columns

Tom Kyte - Tue, 2018-01-30 12:06
Hello, Is there a way to get all the keys that exist in a JSON column? JSON_VALUE function provides an easy way to access a value for a given key, but is there a way to obtain all the key names? Thanks, Gabi
Categories: DBA Blogs

Multiple SQL Profiles for one SQL

Tom Kyte - Tue, 2018-01-30 12:06
Is it possible to have multiple SQL Profiles for same query?
Categories: DBA Blogs

Database Performance Different Plans after Database Migration

Tom Kyte - Tue, 2018-01-30 12:06
I am facing the issue with database performance. Earlier, my database was running on XSeries Platform, Solaris OS. Then I migrated whole data and object to SPARC Platform. Both Servers have a bit different specs. For XSeries, data stores on S...
Categories: DBA Blogs

Re-enable of foreign key constraint takes a long time

Tom Kyte - Tue, 2018-01-30 12:06
I have two databases on Solaris 11 64bit. They both have the same schemas. One is approx. 1GB and the other is approx. 10GB. On both databases, there is a parent and child table with similar number of records (~300k records each). Fr...
Categories: DBA Blogs

conceptual question regarding ODBC driver

Tom Kyte - Tue, 2018-01-30 12:06
Hi Tom: I used to work as a analyst who developed SQL queries mainly using SQL developer and SSIS, and recently I have moved to a new team which I have slightly different role , leading me to some questions I never consider before. I am not so sur...
Categories: DBA Blogs

New Report Manager Update Available for EBS 12.1.3

Steven Chan - Tue, 2018-01-30 11:24

Oracle Report Manager is an online report distribution system that allows you to produce and manage point-in-time reports. Oracle Report Manager users can be either report producers or report consumers. Report producers submit, publish, and set security for reports. Report consumers view and approve reports.

We have just released a Report Manager update for EBS 12.1.3 with new functionality:

  • Repository Management Security

    Additional security capabilities have been added to the Oracle Report Manager Repository to restrict individual user actions on folders and reports.  A new user interface lets you define the users who have viewer and owner privileges for a folder or report. Users must have either viewer or owner privilege to view a secured report. Only users with owner privileges can perform actions such as moving, archiving, deleting, or updating the security privilege assignments for a secured folder or report, publishing reports or adding subfolders within a secured folder, or updating or creating a menu item for a secured report.

You can download the latest Report Manager for EBS 12.1.3 update here:

This is a cumulative bundle patch update that includes all previously-released Report Manager updates for EBS 12.1.3.


Related Articles

Categories: APPS Blogs

Oracle Backup and Recovery in the Cloud

Gerger Consulting - Tue, 2018-01-30 10:17
Attend our free webinar on February 13th and learn how you can implement a robust backup and recovery solution for your Oracle database running in the cloud.

About the Webinar:
A common misconception is that once you move your database to the cloud, you are done and data protection stops being your problem; it automatically backs itself up, recovers magically and of course it all happens securely. Sadly, nothing can be further from the truth.
In reality, the cloud opens up new opportunities but it also comes with its own challenges, especially when it comes to implementing a secure, reliable and fast database backup and recovery solution.
In this webinar you'll learn about how the cloud changes your database backup&recovery strategy and what solutions are available to you to use with your Oracle Database in the cloud.
Specifically, we'll cover the following topics:
  • Backup and recovery strategies for databases running in the cloud
  • Pros and cons of various backup and recovery strategies
  • How to do native, multi-cloud data protection
  • How to streamline and automate backups in the cloud to reduce costs and improve efficiency
We will also do a live demo with Oracle database running in the Amazon Cloud.

Categories: Development


Subscribe to Oracle FAQ aggregator