Feed aggregator

Goldengate Integrated Replicat Parallel Execution

Tom Kyte - Thu, 2017-09-14 16:46
We're creating a bi-directional Goldengate replication environment between two Oracle databases... Goldengate 12.2 Oracle EE RDBMS 12.1 Both databases on a 2-node Exadata RAC We're using Integrated Extract and Replicat on both nodes. For p...
Categories: DBA Blogs

On addition of a single column, performance of query drastically impacted

Tom Kyte - Thu, 2017-09-14 16:46
Hi, On addition of a single column, performance of a query has drastically impacted (40 secs from 0.0002 secs). Oracle has changed earlier plan and picked plan that takes more time. Change : new column added to a query in select clause : dsi...
Categories: DBA Blogs

Oracle SQL background process

Tom Kyte - Thu, 2017-09-14 16:46
Hi Tom, I have bit knowledge (aware of defination) on PGA and SGA. But I would like to know, when the sql is triggered from client tool(toad). -> background process uses Shared pool memory OR pga memory for performing SYNTAX and SYMANTIC check...
Categories: DBA Blogs

Clustered Index and primary keys

Tom Kyte - Thu, 2017-09-14 16:46
I have question on clustered index I read from documents that whenever primary key is created, it creates clustered index along with it, and it sorts the rows in the table in the same order as the clustered index(on the actual disk), I didn?t unde...
Categories: DBA Blogs

Unjustified memory consumption of windows server equal to SGA_MAX_SIZE in (with manual MM)

Tom Kyte - Thu, 2017-09-14 16:46
Hi, I just installed the latest Oracle Enterprise Edition and I noticed something different with regarding the memory consumption of the Windows Oracle RDBMS Kernel Executable. The database is installed on a Windows server 201...
Categories: DBA Blogs

Demo App for REST enabled SQL

Kris Rice - Thu, 2017-09-14 15:34
Getting Started  The new Oracle REST Data Services SQL over REST.  How to enable that is on my last blog post here: http://krisrice.blogspot.com/2017/09/ords-173-beta-introducing-rest-enabled.html cURL Examples The simplest way to test this new feature out is with a curl command sending over the SQL. $ curl -X "POST" "http://localhost:9090/ords/hr/_/sql" \ -H "Content-Type:

Q1 FY18 GAAP EPS UP 19% TO $0.52 and NON-GAAP EPS UP 12% TO $0.62

Oracle Press Releases - Thu, 2017-09-14 14:04
Press Release
Q1 FY18 GAAP EPS UP 19% TO $0.52 and NON-GAAP EPS UP 12% TO $0.62 Q1 FY18 Cloud Revenues Up 51% to $1.5 Billion and Total Revenues Up 7% to $9.2 Billion

Redwood Shores, Calif.—Sep 14, 2017

Oracle Corporation (NYSE: ORCL) today announced fiscal 2018 Q1 results. Total Revenues were up 7% from the prior year to $9.2 billion. Cloud plus On-Premise Software Revenues were up 9% to $7.4 billion. Cloud Software as a Service (SaaS) revenues were up 62% to $1.1 billion. Cloud Platform as a Service (PaaS) plus Infrastructure as a Service (IaaS) revenues were up 28% to $400 million. Total Cloud Revenues were up 51% to $1.5 billion.

GAAP Operating Income was up 7% to $2.8 billion and Operating Margin was 31%. Non-GAAP Operating Income was up 11% to $3.8 billion and non-GAAP Operating Margin was 41%. GAAP Net Income was up 21% to $2.2 billion, while non-GAAP Net Income was up 14% to $2.7 billion. GAAP Earnings Per Share was up 19% to $0.52, while non-GAAP Earnings Per Share was up 12% to $0.62.

Short-term deferred revenues were up 9% compared with a year ago to $10.3 billion. Operating cash flow on a trailing twelve-month basis was up 8% to $14.8 billion.

“The sustained hyper-growth in our multi-billion dollar cloud business continues to drive Oracle’s overall revenue and earnings higher and higher,” said Oracle CEO, Safra Catz. “In Q1, total revenues were up 7%, GAAP EPS was up 19%, and non-GAAP EPS was up 12%. Oracle is off to a very, very strong start in FY18.”

“With SaaS revenue up 62%, our cloud applications business continues to grow more than twice as fast as Salesforce.com,” said Oracle CEO, Mark Hurd. “ERP is our largest and most important cloud applications business. We now have about 5,000 Fusion ERP customers plus 12,000 NetSuite ERP customers in the Oracle Cloud. That’s 30 times more ERP customers than Workday.”

“In a couple of weeks, we will announce the world’s first fully autonomous database cloud service,” said Oracle Chairman and CTO, Larry Ellison. “Based on machine learning, the latest version of Oracle is a totally automated “self-driving” system that does not require human beings to manage or tune the database. Using AI to eliminate most sources of human error enables Oracle to offer database SLA’s that guarantee 99.995% reliability while charging much less than AWS.”

The Board of Directors also declared a quarterly cash dividend of $0.19 per share of outstanding common stock. This dividend will be paid to stockholders of record as of the close of business on October 11, 2017, with a payment date of October 25, 2017.

Q1 Fiscal 2018 Earnings Conference Call and Webcast

Oracle will hold a conference call and webcast today to discuss these results at 2:00 p.m. Pacific. You may listen to the call by dialing (816) 287-5563, Passcode: 425392. To access the live webcast, please visit the Oracle Investor Relations website at http://www.oracle.com/investor. In addition, Oracle’s Q1 results and Fiscal 2018 financial tables are available on the Oracle Investor Relations website.

A replay of the conference call will also be available by dialing (855) 859-2056 or (404) 537-3406, Passcode: 82330974.

Contact Info
Ken Bond
Oracle Investor Relations
Deborah Hellinger
Oracle Corporate Communciations
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE: ORCL), visit www.oracle.com/investor or contact Investor Relations at investor_us@oracle.com or (650) 506-4073.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

"Safe Harbor" Statement

Statements in this press release relating to Oracle's future plans, expectations, beliefs, intentions and prospects, including statements regarding the growth of our cloud applications business compared to competitors and the announcement regarding our new autonomous database cloud service, are all "forward-looking statements" and are subject to material risks and uncertainties. Many factors could affect our current expectations and our actual results, and could cause actual results to differ materially. We presently consider the following to be among the important factors that could cause actual results to differ materially from expectations: (1) Our cloud computing strategy, including our Oracle Cloud SaaS, PaaS, IaaS and data as a service offerings, may not be successful. (2) If we are unable to develop new or sufficiently differentiated products and services, or to enhance and improve our products and support services in a timely manner or to position and/or price our products and services to meet market demand, customers may not buy new software licenses, cloud software subscriptions or hardware systems products or purchase or renew support contracts. (3) If the security measures for our products and services are compromised or if our products and services contain significant coding, manufacturing or configuration errors, we may experience reputational harm, legal claims and reduced sales. (4) We may fail to achieve our financial forecasts due to such factors as delays or size reductions in transactions, fewer large transactions in a particular quarter, fluctuations in currency exchange rates, delays in delivery of new products or releases or a decline in our renewal rates for support contracts. (5) Our international sales and operations subject us to additional risks that can adversely affect our operating results, including risks relating to foreign currency gains and losses. (6) Economic, geopolitical and market conditions can adversely affect our business, results of operations and financial condition, including our revenue growth and profitability, which in turn could adversely affect our stock price. (7) We have an active acquisition program and our acquisitions may not be successful, may involve unanticipated costs or other integration issues or may disrupt our existing operations. A detailed discussion of these factors and other risks that affect our business is contained in our U.S. Securities and Exchange Commission (SEC) filings, including our most recent reports on Form 10-K and Form 10-Q, particularly under the heading "Risk Factors." Copies of these filings are available online from the SEC or by contacting Oracle Corporation's Investor Relations Department at (650) 506-4073 or by clicking on SEC Filings on Oracle’s Investor Relations website at http://www.oracle.com/investor. All information set forth in this press release is current as of September 14, 2017. Oracle undertakes no duty to update any statement in light of new information or future events. 

Talk to a Press Contact

Ken Bond

  • +1.650.607.0349

Deborah Hellinger

  • +1.212.508.7935

September 2017 Updates to AD and TXK for EBS 12.2 Now Available

Steven Chan - Thu, 2017-09-14 13:27

We have been fine-tuning the administration tools for E-Business Suite 12.2 via a series of regular updates to the Applications DBA (AD) and EBS Technology Stack (TXK) components:

We have now made available a twelfth set of critical updates to AD and TXK. We strongly recommend that you apply these new AD and TXK updates at your earliest convenience:

They must be individually downloaded from My Oracle Support, as shown by this example for AD:

Refer to the following My Oracle Support knowledge document for full installation instructions and associated tasks:

What's New in this Patchset?

This patchset includes a large number of critical fixes for stability issues that will affect all customers.  It also includes the following new features:

  • 25928667 Issue with LIBPATH in APPSORA.CMD
  • 26004435 FWDPORT ONE-OFF BUGFIX # 25720619 TO DELTA 9 AND DELTA 10
  • 26117566 Re-link fails with CYGWIN Version 2.8.0
  • 26371653 AD.RLNK: Relink makefile error for adadmin_wapper.exe - AutoBuild

Related Articles

Categories: APPS Blogs

A Guide to Attending Oracle OpenWorld and JavaOne for Free

Shay Shmeltzer - Thu, 2017-09-14 11:32

This title seems like a click bait, but I'll try and show you that this is actually possible. (Especially if you act fast).

A pass to both conferences is not a cheap item, and with training budgets shrinking you might be running into problems getting approval to expense this to your company. But here are a couple of tricks you can use to get free access to OOW/JavaOne. Some would get you a full pass and some will get you into specific areas and sessions.

Full Pass

Be a Speaker

Well we are a bit late to the call for papers at this point, but you might still be able to become a co-speaker if you have a good customer story to tell that shows how you are using the product/technology that a talk is about. Oracle is always looking to feature customer stories in our sessions - it is always better when a customer shares their real live success. Look up the content catalog and locate sessions on products that you are successfully implementing - ping the speaker and they might want to add you as a co-speaker.

Apply for the Oracle Excellence Awards

We are late for getting in this year, but keep an eye for this for next year. Winners get a free pass to OOW. Details here.

JavaOne Special Discount

Right now you can get 50% off your JavaOne ticket price if you use this code DJFS2017. Register here https://www.oracle.com/javaone/register.html

Other Passes

So full pass might be hard to get for free, but you can get in on a big chunk of the action for free using 

The Discoverer pass

A Discoverer pass lets you into the exhibit halls and various keynotes. Getting into the exhibit hall is great if you want to meet product managers and learn about the latest versions (and upcoming versions too). Most of the PMs are going to do shifts at the Oracle Demoground in their product pods - so hang out there and you'll be able to chat with us.

Usually a Discoverer pass is $75 - but since you are reading this blog, you can get one for free - use the code CDFR2017. Register here.

Oracle Code

Want to get into some technical sessions - this year we are bringing Oracle Code back to San Francisco during OOW - and you can get into this part of the conference for free. Reg here:


See you at the conference in a couple of weeks.




Categories: Development

Benefits of Exetuvie Dashboards for Call Centers

Nilesh Jethwa - Thu, 2017-09-14 08:54

Managing a call center is no easy feat, hence, business intelligence tools such as an executive dashboard can be tremendously helpful.

Call center management needs constant attention. Managers should focus on the latest performance metricsand important industry KPIs. Taking these into consideration, arming company executives with a reliable call center dashboard is worth its weight in gold.

Keeping a watchful eye on all the activities of the call center that you’re managing can help you increase overall productivity, and business intelligence tools should will play a major role. Not only will you be able to reduce handling times significantly but also be able to meet the obligations of your service level agreements hassle-free.

With the industry of call centers being one of the most competitive these days, providing clients with the highest level of service is the ultimate goal and you can assure service quality when you have an executive dashboard in your arsenal.

It works by increasing the visibility of real-time metrics that are crucial to your business. With a dashboard app, you can access vital information immediately and address any issues before they become potentially damaging to your company.

In any call center dashboard, there are several performance metrics that you have to pay close attention to and here are some of them:

Read more at http://www.infocaptor.com/dashboard/executive-dashboard-analytics-for-call-centers

The Insurance of Oracle APEX - Can Your Low Code Framework Do This?

Joel Kallman - Thu, 2017-09-14 08:27
Oracle Application Express (APEX) runs wherever the Oracle Database runs.  I've said these words to thousands of customers and partners for the last 15 years.  So why should you care?  Simple.  Peace of mind.

Last evening, Amazon Web Services tweeted the following announcement:

"Use Amazon RDS for Oracle with Oracle APEX versions 5.0.4 & 5.1.2 to build applications within your web browser."

Now, one might think I'm daft for even mentioning AWS on my blog, but I think this presents an opportunity to emphasize two very important points about Oracle APEX:

  1. While I believe that Oracle Cloud is superior for running your Oracle APEX applications, if for some reason you need to not run it on the Oracle Cloud at some later date, you have that choice.
  2. Oracle APEX is not exclusively a cloud-only solution.  You can run it in the Oracle Cloud (my preference), you can run it on AWS, you can use a number of other hosting providers, you can run it with other infrastructure providers, but you can also choose to run it on-premises.  And you can change your mind among these options whenever you wish.  This is very powerful.

Oracle Application Express is a part of every Oracle Database Cloud Service from Oracle, including:

There are other cloud services coming from Oracle later this year which will also include and feature Oracle APEX.

If you think that the Oracle Database is only good for storing data (i.e., a "bit bucket"), you'd be wrong.  If you're unfamiliar with Oracle APEX, please check out this Simple Guide to Oracle APEX.  From bespoke applications in the Oracle Cloud & on-premises to Oracle ERP Cloud PaaS Extensions using Oracle APEX, our customers and partners are really killing it with the Oracle Database and Oracle APEX.

P.S.  Kudos to Amazon for referencing it as Oracle APEX and not Oracle Apex!

Oracle 12c Service Broker for Pivotal Cloud Foundry

Pas Apicella - Thu, 2017-09-14 00:21
The following example is a PCF 2.0 Service Broker written as a Spring Boot application. This is just an example and should be evolved to match a production type setup in terms oracle requirements. This service broker simple creates USERS and assigns then 20M of quota against a known TABLESPACE

It's all documented as follows


Categories: Fusion Middleware

#GoldenGate and #Docker!

DBASolved - Wed, 2017-09-13 22:55

Check this out … Oracle GoldenGate is now avaliable on Docker! All the details you need to get up and running on an image is included in Oracle’s public github.



Filed under: Docker, Golden Gate
Categories: DBA Blogs

Deterministic functions and Virtual Columns

Tom Kyte - Wed, 2017-09-13 22:26
It seems that ?DETERMINISTIC? means exactly what I think (or some of the non-oracle sources on the internet) think it does. I expected this script to fail either on the create function, create table or when running the select statements. I would ha...
Categories: DBA Blogs

Join of two tables and want first row of matching records in second table

Tom Kyte - Wed, 2017-09-13 22:26
I have two tables <code>create table g ( a int, d date); with this data in it: insert into g values ( 1, to_date('01/15/2004','mm/dd/yyyy')); insert into g values ( 2, to_date('01/15/2004','mm/dd/yyyy')); insert into g values ( 3, to_dat...
Categories: DBA Blogs

Selecting column dynamically

Tom Kyte - Wed, 2017-09-13 22:26
Is there a way to write a SQL which selects the number of columns based on the data available .. Say i am trying to post the number of lines inserted on a table per hour on a day .. So when i run the select between 03:00-04:00 hr it should give...
Categories: DBA Blogs

User defined function in select statement

Tom Kyte - Wed, 2017-09-13 22:26
Hi, I want fetch total_resale value based on quote_id and group by item_class but its not fetching proper result. Please find DDL, DML and function as below, DDL: <code>CREATE TABLE QUOTE_TEST ( ITEM_CLASS VARCHAR2(20 BYTE) , QUOTE_ID...
Categories: DBA Blogs

Import is taking 4 days to get DB impprted

Tom Kyte - Wed, 2017-09-13 22:26
Dear sir Database 11g- exported to dmp file sizing 20 GB Then i imported it with imp command as Full=Y and commit=Y, and db got imported successfully with in 5 hours. Next i imported the same dmp file in oracle 12c Initialy import went as...
Categories: DBA Blogs

Create a view to convert rows to columns dynamically

Tom Kyte - Wed, 2017-09-13 22:26
I have a question regarding view creation. Here is my question: I need to generate a report using a view which takes data from two tables lets say Table_A and Table_B. Sample data in Table_A: <code>empno empname elem_name -------------...
Categories: DBA Blogs

Concurrency wait event

Tom Kyte - Wed, 2017-09-13 22:26
Greetings, As per my AWR report:: <code>Event Waits Time(s) Avg wait (ms) % DB time Wait Class ----------------------------- SQL*Net more data from client 35,972 9,805 273 65.90 ...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator