Feed aggregator

Oralce Smart Flash Cache

Tom Kyte - Fri, 2017-04-21 03:06
Hello Team, Could you please explain why Smart Flash Cache is limited to Solaris and Oracle Linux platforms? https://oracle-base.com/articles/12c/database-smart-flash-cache-12cr1 Thanks.
Categories: DBA Blogs

Expected Date format coming as 00:00:00 using DD/MM/YYYY HH24:MI:SS

Tom Kyte - Fri, 2017-04-21 03:06
Hi Team, I am using the below query to get the records; which is working successfully. However when I am trying to get the time stamp in the column CREATED DATE then the 19/04/2017 00:00:00 & 3/4/2017 0:00. select distinct b.transaction_id as ...
Categories: DBA Blogs

Someone Delete data

Tom Kyte - Fri, 2017-04-21 03:06
In my office, someone deleted the Procedure. I want to know who did it? What time did it? Please tell the query to find the person information's like IP Address or Name.
Categories: DBA Blogs

Table Backup

Tom Kyte - Fri, 2017-04-21 03:06
Hi Team, I have had gone through one question in interview,I could not find answer to that. If you can help me with that. Let say,there is one table employee with millions of record and we want to increase the column size address_col(10) to add...
Categories: DBA Blogs

External table preprocessor

Tom Kyte - Fri, 2017-04-21 03:06
Hello, I have to read a file via external table but this file it's located into another directory inside the ASM. As first step I have to move the file So, I decided to use the preprocessor feature running a script Here's my table (premise: ...
Categories: DBA Blogs

How to get rid of double quotes from get_ddl

Tom Kyte - Fri, 2017-04-21 03:06
Hi Team, Is there any way to get rid of the double quotes from the output of dbms_metadata.get_ddl. Following is the sample output of dbms_metadata.get_ddl('TABLE','TEST') : e.g., CREATE TABLE "TEST" ( "F1" NUMBER(4,0) NOT NULL ENAB...
Categories: DBA Blogs

ROWID not incrementing. Need an alternative for deduping

Tom Kyte - Fri, 2017-04-21 03:06
Hi Tom, I have a SQL script which (runs daily) inserts data into a table and then de-duping is done based on the rowid. But recently I have observed that rowid is not incrementing with inserts and instead Oracle is re-using space to generate rowid...
Categories: DBA Blogs

How to create a stored procedure only when a particular table exists

Tom Kyte - Fri, 2017-04-21 03:06
Hi Tom, I'm trying to create a stored procedure only when a particular table already exists, using the following code: SET SERVEROUTPUT ON DECLARE v_row_count INTEGER := 0; e_wrong_db EXCEPTION; BEGIN S...
Categories: DBA Blogs

Is there a self-reference to my PL/SQL program's name?

Tom Kyte - Fri, 2017-04-21 03:06
Hi Tom, Is there a PL/SQL variable equivalent of the $0 variable in Unix. Within a procedure/function if I want to know the name of the program that I am running, can I get it from a system variable. I plan to write into a log table and I want to pa...
Categories: DBA Blogs

Breaking News! Dodeca Spreadsheet Management System Certified on Oracle Analytics Cloud!

Tim Tow - Thu, 2017-04-20 23:37
Now that the Oracle Analytics Cloud, or "OAC", has been released, we had to get serious about our work with one of the Oracle Analytics Cloud components, the Essbase Cloud Service, or "EssCS" for short.  You would think that we should have been working hard on EssCS for quite some time, but we had been assured by Oracle product management that the Essbase Java API would be available in EssCS.  Of course, Dodeca was built using the Essbase Java API and thus we expected that support for EssCS would be very easy.

We got access to a production version of the EssCS last week and started our work.  As promised by product management, the Essbase Java API is available in EssCS and, believe it or not, we did not need to change a single line of source code in order to support the Essbase Cloud.  We did, however, have to update our build processes to use Java 8 instead of the decrepit Java 6 used in Essbase 11.x.

As far as configuration inside Dodeca itself, the only change we made was that we configured the APSUrl in the Essbase Connection object to point to the Essbase Cloud APS instance.  Note that the URL format has changed in the cloud.  The Java API was accessible in Essbase 9.3.1 through Essbase using the format:


In the cloud, this has changed to:


The Essbase Connection configuration looks pretty much the same as the configuration for an on premise connection configuration:

Of course, the Dodeca views look identical when run against an on premise or a cloud server:

In summary, it was trivial to test Dodeca using EssCS.  Every single Essbase functionality that we use in the product, from data grid operations to metadata operations and even report scripts, worked exactly the same as it does against an on premise Essbase cube.  Based on our testing, we are certifying the Dodeca Spreadsheet Management System to work on the Oracle Analytics Cloud.

We have a number of innovations we plan to introduce in the near future aimed to improve the Essbase Cloud experience, so stay tuned.  If you are planning to come to Kscope17 in San Antonio, plan to attend the Dodeca Symposium and you may just be the first to see of these cool new things!

Categories: BI & Warehousing

Developing a training course or university curriculum for Oracle Application Express (APEX)? Start here!

Joel Kallman - Thu, 2017-04-20 13:37
While education in Oracle Application Express (APEX) is offered as a part of many university and secondary school courses around the globe, in most cases, the educators took it upon themselves to develop their own custom curriculum.  To lessen the burden on educators, we have developed and made available for public download a full course curriculum for Oracle Application Express.

This courseware, developed by our product manager Chaitanya Koratamaddi over the past year, includes 16 distinct lessons, complete with PowerPoint presentations, hands-on-labs, and all necessary SQL scripts and application export files.  You can use all or a portion of these materials in your own curriculum.

This same courseware was provided to the Oracle Academy team, who now also offer an Oracle Application Express course.  The Oracle Academy course is offered in a hosted interactive form, complete with quizzes, and it also includes both educator and student curriculum.  There are many other benefits to joining Oracle Academy.  For more information about Oracle Academy, go here.

To access the publicly available Oracle Application Express curriculum, go to:


How to make dashboard for Mimer database

Nilesh Jethwa - Thu, 2017-04-20 12:25

Mimer is a SQL based relational database management system (RDBMS.It provides small footprint, scalable and robust relational database solutions.

Are you using Mimer for your data marts or data-warehouse? If so, build your Free Mimer business intelligence dashboard software.

 A Mimer dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Mimer SQL reporting reporting, it's a live view of exactly how your marketing campaign is performing.

  • Better Decision Making
  • Gain Competitive Advantage
  • Enhance Collaboration
  • Spotting potential problems
  • Merge with data from Excel Dashboards
  • Live SQL against database
  • No need for Data-warehouse or ETL
  • Leverage the speed and stability of your powerful database.

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-mimer-sql 


Tom Kyte - Thu, 2017-04-20 08:46
Hi team, I have imported the database schema from one db to another db with same schemas details and it is completed successfully but when i comparing the objects it is showing difference So, can you pls let me know in impdp some specific object...
Categories: DBA Blogs

SYS indexes

Tom Kyte - Thu, 2017-04-20 08:46
I have some indexes that starts with SYS I am not able to see them in user_indexes but SQL developer explorer shows them. Any idea?
Categories: DBA Blogs

plsql developer - delete memory record

Tom Kyte - Thu, 2017-04-20 08:46
can we delete a record from cursor memory with out effecting main table in plsql
Categories: DBA Blogs

Automatic Memory Management

Tom Kyte - Thu, 2017-04-20 08:46
Hi Tom, I am trying to understand For Automatic Memory Management in 11g.We have MEMORY_TARGET parameter. 1)Can you please explain how MEMORY_TARGET considers SGA_MAZ_SIZE if auto shared memory management is enabled. If i keep sga_targ...
Categories: DBA Blogs

Is it possible for a single session to fully utilize IO?

Tom Kyte - Thu, 2017-04-20 08:46
Dear Tom, We have an Oracle 12c database used mainly as a data warehouse for scientific data. The database has a few very large tables (>1TB) and they are usually accessed via a full table scan. The database is mostly idle having no more than one ...
Categories: DBA Blogs

Guide to PeopleSoft Logging and Auditing - Revised Whitepaper

After discussions at Collaborate2017 with several PeopleSoft architects we have revised our Guide to PeopleSoft Auditing. The key change is the recommendation NOT to use PeopleSoft’s native database auditing and to instead use Oracle Fine Grained Auditing (FGA). FGA comes free with the Enterprise Edition of the Oracle RDBMS and, not only is it easier to implement, FGA does not have the performance impact of PeopleSoft’s native auditing.

If you have questions, please contact us at info@integrigy.com

-Michael Miller, CISSP-ISSMP

Auditing, Oracle PeopleSoft
Categories: APPS Blogs, Security Blogs

Predicate evaluation order

Tom Kyte - Wed, 2017-04-19 14:26
I've known for a while that the order of predicate evaluation in a query is non deterministic, as posted by Tom here (https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:696647495510). I even wrote my own blog about it a while back (...
Categories: DBA Blogs

"accessible by" clause in 12.2

Tom Kyte - Wed, 2017-04-19 14:26
Team, Reading through the "accessible by" clause enhancements in 12.2 <u>http://docs.oracle.com/database/122/LNPLS/release-changes.htm#GUID-85A17D6B-4E7A-49D9-B5AC-B0D69390B449</u> <quote> Starting with Oracle Database 12c release 2 (12.2),...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator