Skip navigation.

Feed aggregator

Expert Oracle Application Express (second edition) available

Dimitri Gielis - Thu, 2015-08-20 05:03
During my holiday Apress released the second edition of Expert Oracle Application Express.In the second edition we not only updated the content to APEX 5.0, but there're some new chapters in too from new authors. In total you get 14 chapters from 14 different authors.I believe it's a very nice book with great content and it's for a good cause. Roel describes it very nicely in his blog post "the goal is to raise as much money as we can for the funds that support the relatives of two of the greatest Oracle APEX Development Team members who passed away a few years ago: Carl Backstrom and Scott Spadafore."

You can get it from the Apress website or from Amazon. Happy reading :)

Categories: Development

MRP process on standby stops with ORA-00600

Amardeep Sidhu - Thu, 2015-08-20 03:03

A rather not so great post about an ORA-00600 error i faced on a standby database. Environement was 11.2.0.3 on Sun Super Cluster machine. MRP process was hitting ORA-00600 while trying to apply a specific archive log.

The error message was something like this

MRP0: Background Media Recovery terminated with error 600
Errors in file /u01/app/oracle/product/11.2.0.3/diag/diag/rdbms/xxxprd/xxxprd1/trace/xxxprd1_pr00_6342.trc:
ORA-00600: internal error code, arguments: [2619], [539], [], [], [], [], [], [], [], [], [], []
Recovery interrupted!

Some googling and MOS searches revealed that the error was due to corrupted archive log file. Recopying the archive file from primary and restarting the recovery resolved the issue. The fist argument of the ORA-600 is actually the sequence no of the archive it is trying to apply.

Categories: BI & Warehousing

Memory added based on buffer pool advisory did not give desired result

Bobby Durrett's DBA Blog - Wed, 2015-08-19 14:37

Development asked me to look at ways to cut the run time of a series of PeopleSoft payroll batch jobs so I took an AWR report of the entire 4 hour period.  Based on the waits, the percentage of the elapsed time spent using I/O and the buffer pool advisory I chose to double the size of the buffer cache. But, this added memory did not improve the run time of the batch jobs. Maybe the affected blocks are only read into memory once so they would not get cached no matter how big the buffer pool was.

Here is the original run on June 22 with the original memory settings:

Cache Sizes

Begin End Buffer Cache: 3,328M 3,424M Std Block Size: 8K Shared Pool Size: 1,600M 1,520M Log Buffer: 7,208K

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class db file sequential read 1,910,393 10,251 5 72.03 User I/O DB CPU 2,812 19.76 log file sync 35,308 398 11 2.80 Commit resmgr:cpu quantum 31,551 62 2 0.43 Scheduler db file scattered read 7,499 60 8 0.42 User I/O Buffer Pool Advisory
  • Only rows with estimated physical reads >0 are displayed
  • ordered by Block Size, Buffers For Estimate
P Size for Est (M) Size Factor Buffers (thousands) Est Phys Read Factor Estimated Phys Reads (thousands) Est Phys Read Time Est %DBtime for Rds D 336 0.10 41 2.71 6,513,502 1 9842530.00 D 672 0.20 83 2.42 5,831,130 1 8737799.00 D 1,008 0.29 124 2.18 5,241,763 1 7783636.00 D 1,344 0.39 166 1.96 4,720,053 1 6939010.00 D 1,680 0.49 207 1.77 4,250,981 1 6179603.00 D 2,016 0.59 248 1.59 3,825,904 1 5491420.00 D 2,352 0.69 290 1.43 3,438,372 1 4864023.00 D 2,688 0.79 331 1.28 3,083,734 1 4289879.00 D 3,024 0.88 373 1.15 2,758,459 1 3763273.00 D 3,360 0.98 414 1.02 2,459,644 1 3279504.00 D 3,424 1.00 422 1.00 2,405,118 1 3191229.00 D 3,696 1.08 455 0.91 2,184,668 1 2834329.00 D 4,032 1.18 497 0.80 1,931,082 1 2423784.00 D 4,368 1.28 538 0.71 1,696,756 1 2044421.00 D 4,704 1.37 579 0.62 1,479,805 1 1693185.00 D 5,040 1.47 621 0.53 1,278,370 1 1367070.00 D 5,376 1.57 662 0.45 1,090,505 1 1062925.00 D 5,712 1.67 704 0.38 914,112 1 777352.00 D 6,048 1.77 745 0.31 746,434 1 505888.00 D 6,384 1.86 786 0.24 580,310 1 236941.00 D 6,720 1.96 828 0.17 414,233 1 149325.00

In the SQL ordered by Elapsed Time report the top batch job SQL was 99.14% I/O

Based on this report it seems that the number of physical reads could be reduced to about 20% what they were on June 22 by doubling the size of the buffer cache. But, adding the memory did not cut the number of physical reads in any major way.

Here is yesterday’s run:

Cache Sizes

Begin End Buffer Cache: 6,848M 6,816M Std Block Size: 8K Shared Pool Size: 3,136M 3,136M Log Buffer: 16,572K

Top 5 Timed Foreground Events

Event Waits Time(s) Avg wait (ms) % DB time Wait Class db file sequential read 1,789,852 10,173 6 72.15 User I/O DB CPU 2,970 21.06 log file sync 37,562 200 5 1.42 Commit resmgr:cpu quantum 24,996 59 2 0.42 Scheduler db file scattered read 5,409 54 10 0.38 User I/O Buffer Pool Advisory
  • Only rows with estimated physical reads >0 are displayed
  • ordered by Block Size, Buffers For Estimate
P Size for Est (M) Size Factor Buffers (thousands) Est Phys Read Factor Estimated Phys Reads (thousands) Est Phys Read Time Est %DBtime for Rds D 672 0.10 83 11.25 516,440 1 1309098.00 D 1,344 0.20 166 5.98 274,660 1 683610.00 D 2,016 0.29 248 4.02 184,712 1 450915.00 D 2,688 0.39 331 2.90 133,104 1 317404.00 D 3,360 0.49 414 2.20 100,860 1 233990.00 D 4,032 0.59 497 1.80 82,768 1 187185.00 D 4,704 0.69 580 1.53 70,445 1 155305.00 D 5,376 0.79 663 1.31 60,345 1 129176.00 D 6,048 0.88 745 1.14 52,208 1 108127.00 D 6,720 0.98 828 1.01 46,477 1 93301.00 D 6,848 1.00 844 1.00 45,921 1 91862.00 D 7,392 1.08 911 0.95 43,572 1 85785.00 D 8,064 1.18 994 0.89 40,789 1 78585.00 D 8,736 1.28 1,077 0.85 38,889 1 73671.00 D 9,408 1.37 1,160 0.81 37,112 1 69073.00 D 10,080 1.47 1,242 0.77 35,490 1 64876.00 D 10,752 1.57 1,325 0.75 34,439 1 62158.00 D 11,424 1.67 1,408 0.73 33,353 1 59347.00 D 12,096 1.77 1,491 0.71 32,524 1 57204.00 D 12,768 1.86 1,574 0.69 31,909 1 55613.00 D 13,440 1.96 1,656 0.68 31,361 1 54194.00

After the memory add the same top batch job SQL was 98.80% I/O.  Some improvement but not nearly as much as I expected based on the buffer pool advisory.

I guess the moral of the story is that the buffer pool advisory does not apply to specific workloads and is only a general guideline.  Maybe this is the same kind of fallacy that you have with buffer cache hit ratios where certain workloads make the ratio irrelevant.  Here were the hit ratios:  Before 98.59% After 98.82%.  Basically these are the same.

I just thought I would share this to document a real case of using the buffer pool advisory and having it not produce the expected results.

Bobby

Categories: DBA Blogs

Virtual Technology Summit – Spotlight on Java

OTN TechBlog - Wed, 2015-08-19 13:00

Register now for OTN's new Virtual Technology Summit - September 16, 2015. Hear from Oracle ACEs, Java Champions and Oracle Product Experts, as they share their insights and expertise through Hands-on-Labs, highly technical presentations and demos that enable you to master the skills you need to meet today's IT challenges. Chat live with folks and ask your questions as you attend sessions.

Java Spotlight: Cloud, IoT and Java 8 - Java is an integral part of any cutting edge IT project. In this VTS, you will get a deep understanding of Cloud-enabled JavaScript stored procedures with Java 8 Nashorn, Java 8 Date and Time API and applications connecting devices with the cloud. There are three sessions in the Java track:

  • Connecting Devices to the Cloud - Taking healthcare as an example, this session will demonstrate using a mobile phone and a smart watch in combination with a Java based gateway, iBeacons and other sensors to monitor the activity of elderly people. With the help of an IoT cloud service this data can be analyzed to detect situations that might be critical (illness, bone fracture etc.). If such a case was detected, the cloud service can trigger enterprise applications. With this approach it might be possible to connect such a system to existing healthcare applications. This session will give you an idea how you can combine existing technologies to do something useful and help elderly people in case of an emergency.
  • Java SE 8 - Date and Time - The Date and Time API introduced in Java 8 provides a comprehensive and standardized package for date and time implementation. In this session you will learn the best ways to apply this new functionality in your projects.
  • Cloud enabled JavaScript Stored Procedures with Java 8 Nashorn - JavaScript is one of the most popular programming language and the natural choice for processing JSON documents. To process millions of JSON documents would you rather perform the processing in-place in RDBMS, returning only the result sets to the invoker, or ship the data to a middle-tier engine? Stored procedures allowing database processing thereby avoiding data shipping. However, to be portable across tiers and databases, JavaScript stored procedures need a standard database access API; Java 8 furnishes the Nashorn JavaScript engine which allows JDBC calls in JavaScript. For Cloud deployment, JavaScript stored procedures may be invoked through RESTful Web Services, turning these into Cloud data services.
Register today!

Become a member of the OTN Community: Register here to start participating in our online community. Share your expertise with other community members!

NEW REWARDS! If you attend this virtual technology summit and are already a member of the Oracle Technology Network Community, you will earn 150 points towards our new Rewards and Recognition program (use the same email for both). Read all about it in our FAQ: Oracle Community - Rewards & Recognition FAQ.

Oracle Positioned as a Leader in the Gartner Magic Quadrant for Web Content Management, 2015

WebCenter Team - Wed, 2015-08-19 11:53
Executive Summary

Web content management remains a vibrant and growing market, fueled by the aspirations of digital strategists on the demand side and continuous innovation on the supply side. IT application leaders, marketers, digital experience specialists and merchandizers all now view WCM as mission-critical.

Market Definition/Description

Gartner defines Web content management (WCM) as the process of controlling the content to be consumed over multiple digital channels through the use of specific management tools based on a core repository. These may be procured as commercial products, open-source tools or hosted service offerings. Product functions go beyond simply publishing Web content, to include:

  • Content creation functions such as templating, workflow and change management
  • WCM repositories that organize and provide metadata about the content
  • Library services such as check-in/check-out, version control and security
  • Content deployment functions that deliver prepackaged or on-demand content to Web servers
  • A high degree of interoperability with adjacent technologies, such as CRM, marketing resource management, digital asset management (DAM) and Web analytics
  • Real-time adaptation to visitor interaction
  • Good integration with delivery tiers, such as e-commerce, social media and portal software

Figure 1. Magic Quadrant for Web Content Management

Source: Gartner (July 2015)

Oracle was positioned as a Leader in the Gartner Magic Quadrant for Web Content Management for its Oracle WebCenter Sites offering. 

Oracle WebCenter Sites enables organizations to deliver a compelling digital experience to customers by deploying and managing sophisticated and engaging Websites across digital channels. This Web experience management solution automates the entire process of managing the Web—including business-user content authoring, delivery of high-scale dynamic sites, content targeting and optimization, user-generated content, social networking integration, end-user personalization, and mobile Web delivery. As a key component of Oracle’s customer experience ecosystem – including business intelligence, customer relationship management, commerce, enterprise content management, marketing automation, portal, search and social relationship management –Oracle WebCenter Sites uniquely offers organizations the ability to connect the customer experience across all touch points - to build loyalty, drive customer acquisition, and reduce operational costs.

In today’s socially enabled, multichannel online world, individuals increasingly expect their online experiences to be targeted specifically to their interests, and to provide a point of seamless extension and expression of who they are. For Web marketers, this new imperative presents a unique set of challenges when it comes to engaging with their customers online. No longer is it acceptable to simply present flashy product Web pages, or interact with customers via newsletters and mailing lists, nor is it acceptable to publish a stripped-down mobile version of a corporate site. Instead, you have to show the ability to “know” your customer as an individual. Would they rather interact with your company and other customers via Facebook than your corporate site? Do they do most of their browsing and interaction via their iPhone? Do they want to have a personalized view of their relationship with your company, from transaction history to loyalty offers?

Oracle WebCenter Sites meets the new Web experience management (WEM) imperative by connecting the digital experience across channels, to meet the demands of today’s customers. With the WEM solution from Oracle WebCenter Sites, organizations can rapidly create, deploy, and manage multiple Web properties, while empowering business users to manage Websites themselves. Its easy-to-use tools allow organizations to get Web content and campaigns to market faster, and create targeted, interactive, and optimized experiences across Web, mobile, and social channels. Oracle WebCenter Sites offers centralized management of multilingual, multilocale, multisite Web deployments. The solution also integrates seamlessly with customer relationship management (CRM), enterprise content management, commerce, marketing automation and more, to deliver a digital customer experience that will help organizations meet their business goals.

Oracle was pleased to be named a Leader in the 2015 Gartner Magic Quadrant for Web Content Management. You can read the full report here.

Source: "Gartner Magic Quadrant for Web Content Management", Mick MacComascaigh, Jim Murphy, July 29 2015.

This graphic was published by Gartner, Inc. as part of a larger research document and should be evaluated in the context of the entire document. The Gartner document is available upon request from Oracle.

Gartner does not endorse any vendor, product or service depicted in its research publications, and does not advise technology users to select only those vendors with the highest ratings or other designation. Gartner research publications consist of the opinions of Gartner's research organization and should not be construed as statements of fact. Gartner disclaims all warranties, expressed or implied, with respect to this research, including any warranties of merchantability or fitness for a particular purpose.

More Information

The full report can be found here: https://www.oracle.com/corporate/analystrelations/reports/index.html#technology

Are open source projects run like a democracy or an oligarchy?

Sean Hull - Wed, 2015-08-19 09:32
I was reading Fred Wilson’s comments recently on The Bitcoin XT Fork. In it he discussed how open source developers manage their projects. “A group of open source core developers are a democratic system.” I was surprised by this comment because I had never thought if it as democratic. Here are my thoughts… Join 28,000 … Continue reading Are open source projects run like a democracy or an oligarchy? →

Oops

Jonathan Lewis - Wed, 2015-08-19 03:02

I made a mistake a few days ago following up a question on the OTN database forum. The question was about a problem creating a hash/list composite partitioned table, and one of the respondants suggested that perhaps the problem appeared because hash/list wasn’t a legal combination.

Spot on: so I confirmed that observation and supplied a link to the official Oracle white paper that listed the combinations that were legal in 11.2 for composite partitioning.  In fact, although I was fairly sure that hash/list wasn’t legal, I had even run up a quick test to check that the attempt would fail before I’d searched online for the document.

Fortunately other people had different ideas about the original failure, and one of them supplied a link to a thread on AskTom which actually included some SQL to create a hash/list composite partitioned table. Naturally I tested it (even though it was from Tom Kyte) and obviously it worked (after all it was from Tom Kyte) – and then I spotted the syntax error in the example I had created for myself.

Trust but verify … and then …

I had fallen into two traps – and one of them was documented in my own “Trust” posting from 2006.

The white paper was dated September 2009 (Tom’s example was dated June 2013) and as it says in my Trust note:

  • If its date is more than about 18 months old – don’t assume it’s (still) true
  • If it’s not your exact version number – don’t assume it’s (still) true

The second trap was an example of confirmation bias, I was fairly sure that my test was supposed to fail with Oracle error “ORA-00922: missing or invalid option”, so when it failed with exactly that error I didn’t check why it had failed and didn’t notice that I had swapped the order of a couple of clauses in the create table statement. It’s very easy to think you’ve done enough when testing – especially when your test results match your expectation.

Update – later that day

So I’ve had an email asking me how I got the ORA-00922.  Here’s the SQL as I wrote it – don’t give the answer in the comments, but how quickly can you spot what I did wrong ?

create table t1
(
        object_name,
        object_type,
        created
)
partition by hash(object_name) partitions 4
subpartition by list(object_type)
subpartition template (
        subpartition sp1 values ('TABLE'),
        subpartition sp2 values ('INDEX'),
        subpartition sp3 values (default)
)
as
select  object_name, object_type, created
from    all_objects
;

It’s a deceptive error (to me, at least) because even though I know it’s wrong it still looks right.


Shrink/Grow Exadata diskgroups

Syed Jaffar - Wed, 2015-08-19 01:42
One of the important tasks that I foresee after an initial Exadata deployment is, mostly prior to DB in production, is to balance/resize the Exadata diskgroups (DATA & RECO).  Generally, the space is distributed as 80(DATA), 20(RECO) or 40(DATA), 60(RECO), depending on the database backup option you choose while deploying. In one of our Exadata setups, we don't need such a huge RECO size, hence, we shrunk the RECO size and increased the DATA diskgroup size. I am pretty sure, many of you might have done and want to do the same. However, shrinking/rebalancing the space is not like a normal ASM resize operation on Exadata, it needs some special consideration and tasks. The following Oracle Support Notes has the better explanation and examples to achieve the task.

Example of dropping RECO diskgroup and adding the space to DATA diskgroup (Doc ID 1905972.1)
NOTE:1465230.1 - Resizing Grid Disks in Exadata: Example of Recreating RECO Grid Disks in a Rolling Manner
How to increase ASM disks size in Exadata with free space in cell disks (Doc ID 1684112.1)
Resizing Grid Disks in Exadata: Examples (Doc ID 1467056.1)



August 26: Oracle EPM Cloud Customer Reference Forum with Communications Test Design, Inc. (CTDI)

Linda Fishman Hoyle - Tue, 2015-08-18 15:27
Join us for another Oracle Customer Reference Forum on August 26, 2015, at 9:00 a.m. PT to hear Paul Cardell, Vice President Corporate Operations at Communications Test Design, Inc. (CTDI). He will explain how Oracle EPM Cloud (Planning and Budgeting Cloud) provides easy integration with current financial systems and improves speed and accuracy of data processing at CTDI.

Cardell also will share CTDI’s lessons learned during the company's implementation and the benefits it is receiving by using Oracle EPM Cloud.

Register now to attend the live Forum on Wednesday, August 26, 9:00 a.m. PT / 6:00 p.m. CEST and learn more about CTDI’s experience with Oracle EPM Cloud.

For more information:

Customer Story: Communications Test Design Supports Accurate Daily Forecasting Across 70 Global Facilities by Using the Cloud

Customer Video: CTDI Enhances Daily Forecasting with Oracle Solutions

Fishbowl Solutions is now a Google for Work Premier Partner

As of August 1, 2015, Google promoted Fishbowl Solutions to Premier Partner status! This elevation is a testament to our commitment to selling and servicing Google Search Solutions, and we are very excited to be counted among the select companies to attain this level of partnership. Kim Negaard, the Google Product Manager at Fishbowl, took some time to talk about our history with Google and what being a Premier Partner means.

 

The post Fishbowl Solutions is now a Google for Work Premier Partner appeared first on Fishbowl Solutions' C4 Blog.

Categories: Fusion Middleware, Other

WordPress 4.3 “Billie”

Tim Hall - Tue, 2015-08-18 14:02

WordPress 4.3 “Billie” has arrived.

I was on my blog admin pages doing something else and I noticed the update was available before the auto-updater kicked in and updated the site automatically, so I gave it a nudge and now I’m upgraded.

Like most of the recent WordPress updates, there is little new that interests me, but it’s always a good idea to be up to date, so whatever… :)

Cheers

Tim…

WordPress 4.3 “Billie” was first posted on August 18, 2015 at 9:02 pm.
©2012 "The ORACLE-BASE Blog". Use of this feed is for personal non-commercial use only. If you are not reading this article in your feed reader, then the site is guilty of copyright infringement.

New Adventures with Raspberry Pi

Oracle AppsLab - Tue, 2015-08-18 13:02

If you read here, you’ll recall that Noel (@noelportugal) and I have been supporters of the Raspberry Pi for a long time, Noel on the build side, many, many times, me on the talking-about-how-cool-and-useful-it-is side.

And we’ve been spreading the love through internal hackdays and lots of projects.

So, yeah, we love us some Raspi.

The little guy has become our go-to choice to power all our Internet of Things (IoT) projects.

Since its launch in early 2012, the little board that could has come a long way. The latest model, the Raspberry Pi 2 B, can even run a stripped down Windows 10 build to do IoT stuff.

Given all that we do with Raspis, I’ve always meant to get one for my own tinkering. However, Noel scared me off long ago with stories about how long it took to get one functional and the risks.

For example, I remember reading a long post early on the Pi’s history about how choosing a Micro USB was critical, amperage too high burned out the board, too low and it wouldn’t run.

The information was out there, contributed by a huge and generous community. I just never had the time to invest.

Recently, I’ve been talking the good people at the Oracle Education Foundation (@ORCLcitizenship) about ways our team can continue to help them with their workshops, and one of their focus areas is the Raspberry Pi.

After all, the mission of the Raspi creators was to teach kids about computers, so yeah.

I figured it was finally time to overcome my fears and get dirty, and thanks to Noel, I found a kit that included everything I would need, this Starter Kit from Vilros.

IMG_20150812_094443

Vilros Raspberry Pi 2 Complete Starter Kit

Armed with this kit, I took a day and hoped that would be enough to get the little guy running. About an hour after starting, I was done.

IMG_20150812_095354 IMG_20150812_103311 IMG_20150812_103512 IMG_20150812_111034

Going from zero to functional is now ridiculously easy, thanks to these kits that include all the necessities.

So, now I have a functioning Pi running Raspbian. All I need is a project, any ideas?

Coda: Happy coincidence, as I wrote this post, I got a DM from Kellyn Pot’Vin-Gorman (@dbakevlar) asking if knew any ways for her to use her Raspberry Pi skills in an educational capacity. Yay kismet.
Possibly Related Posts:

Virtual Technology Summit - Spotlight on Database

OTN TechBlog - Tue, 2015-08-18 13:00

Register now for OTN's new Virtual Technology Summit - September 16, 2015. Hear from Oracle ACEs, Java Champions and Oracle Product Experts, as they share their insights and expertise through Hands-on-Labs, highly technical presentations and demos that enable you to master the skills you need to meet today's IT challenges. Chat live with folks and ask your questions as you attend sessions.

Database Spotlight: Develop, Deploy and Manage Database Applications in the Oracle Cloud - Oracle has delivered the most comprehensive and powerful platform for deploying Cloud-based applications and services. Starting from the Infrastructure as a Service to the Platform as a Service, Oracle delivers a fully integrated cloud --platform and applications. This track provides an in-depth look at Oracle Database Cloud Services and the enabling technologies for developing, deploying and managing applications in the Oracle Cloud. There are three sessions in the database track:

  • Using Oracle SQL Developer and Oracle REST Data Services to enable the Oracle Cloud - This session presents the latest capabilities in Oracle's popular SQL Developer and ORDS tools for database application development and deployment in the cloud. See how to clone and migrate data between Oracle cloud and on-premise implementations and other powerful techniques for developing applications for the cloud, in the cloud.
  • Developing APEX 5.0 Mobile Applications in the Oracle Cloud - This session will walk through the capabilities for rapidly building and deploying responsive web applications using APEX 5.0 showing Oracle Developer Cloud Services in action.
  • How to Deploy and Monitor Cloud Database Applications Using Oracle Enterprise Manager 12c Cloud Control - This session provides an overview of Oracle Database Cloud Services and the management capabilities of Oracle Enterprise Manager 12c Cloud Control. See how to manage Oracle cloud deployment, provisioning, security and application access and monitoring.
Register today!

Become a member of the OTN Community: Register here to start participating in our online community. Share your expertise with other community members!

NEW REWARDS! If you attend this virtual technology summit and are already a member of the Oracle Technology Network Community, you will earn 150 points towards our new Rewards and Recognition program (use the same email for both). Read all about it: Oracle Community - Rewards & Recognition FAQ.

Get a Look at the Future Oracle Cloud User Experience at Oracle OpenWorld 2015

Oracle AppsLab - Tue, 2015-08-18 12:19

Here’s the first of many OpenWorld-related posts, this one cross-posted from our colleagues and friends at VoX, the Voice of Experience for Oracle Cloud Applications. Enjoy.

Are you all set for Oracle OpenWorld 2015 (@oracleopenworld)? Even if you think you’re already booked for the event, you’ll want to squeeze in a chance to experience the future of the Oracle Applications User Experience (OAUX) — and maybe even make a few UX buddies along the way — with these sessions, demos, and speakers. We loved OOW 2014, and couldn’t wait to get ready for this year.

lucasjakeoow2015

Lucas Jellema, AMIS & Oracle ACE Director (left), Anthony Lai, Oracle (center), Jake Kuramoto, Oracle (right) at OOW 2015 during our strategy day. Photo by Rob Hernandez.

Save the Date: Oracle Applications Cloud User Experience Strategy & Roadmap Day

The OAUX team is hosting a one-day interactive seminar ahead of Oracle OpenWorld 2015 to get select partners and customers ready for the main event. This session will focus on Oracle’s forward-looking investment in the Oracle Applications Cloud user experience.

You’ll get the opportunity to share feedback about the Oracle Applications Cloud UX in the real world. How is our vision lining up with what needs to happen in your market?

Speaking of our vision, we’ll start the session with the big-picture perspective on trends and emerging technologies we are watching and describe their anticipated effect on your end-user experiences. Attendees will take a deeper dive into specific focus areas of the Oracle Applications Cloud and learn about our impending investments in the user experience including HCM Cloud, CX Cloud, and ERP Cloud.

The team will also share with you the plans for Cloud user experience tools, including extensibility and user experience in the Platform-as-a-Service (PaaS4SaaS) world (get the latest here). We’ll close out the day with a “this-town-ain’t-big-enough” event that was extremely popular last year: the ACE Director Speaker Showdown.

Want to go?

When: 9 a.m. to 5 p.m. Wednesday, Oct. 21, 2015
Where: Oracle Conference Center, Room 202, 350 Oracle Pkwy, Redwood City, CA 94065
Who: Applications Cloud partners and customers (especially HCM, CX, or ERP Cloud), Oracle ACE Directors, and Oracle-internal Cloud thought leaders in product development, sales, or Worldwide Alliances and Channels

Register Now!

To get on our waitlist.

Active confidential disclosure agreement required.

Chloe Arnold and Mindi Cummins, Oracle, during OOW 2014 at the OAUX Cloud Exchange

Chloe Arnold and Mindi Cummins, Oracle, during OOW 2014 at the OAUX Cloud Exchange.

Save the Date: Oracle Applications User Experience Cloud Exchange

Speakers and discussions are all well and good, but what is the future of the Oracle Applications UX really like? The OAUX team is providing a daylong, demo-intensive networking event at Oracle OpenWorld 2015 to show you what the results of Oracle’s UX strategy will look like.

User experience is a key differentiator for the Oracle Applications Cloud, and Oracle is investing heavily in its future. Come see what our recently released and near-release user experiences look like, and check out our research and development user experience concepts, then let us know what you think.

These experience experiments for the modern user will delve even deeper into the OAUX team’s guiding principles of simplicity, mobility, and extensibility and come from many different product areas. This is cutting-edge stuff, folks. And, since we know you’re worn out from these long, interactive days, this event will also feature refreshments.

Want to go?

When: Monday, October 26, 2015
Where: InterContinental Hotel, San Francisco
Who: Oracle Applications Cloud Partners, Customers, Oracle ACEs and ACE Directors, Analysts, Oracle-internal Cloud thought leaders in product development, sales, or Worldwide Alliances and Channels.

Register Now!

To get on our waitlist.

Active confidential disclosure agreement required.Possibly Related Posts:

Script to get previous month’s AWR report

Bobby Durrett's DBA Blog - Tue, 2015-08-18 11:58

We keep 6 weeks of history in the AWR on our databases, but I want to capture some information for long-term trending. What I really want to do is capture some metrics and put them in some database tables to use to generate reports, but I have not had time to build the scripts to do that.  So, instead I built a simple set of scripts to capture an AWR for the previous month. Since we have 6 weeks of history if I run my report in the first week of a month all the days of the previous month should still be in the AWR. I have just finished building this script so I can not promise that there is value in keeping monthly AWR reports but I thought it was worth sharing it.  Maybe something in the code will be useful to someone.  Here is the script:

-- Has to be run in the first week of the month so the entire
-- previous month is available. We keep 6 weeks of awr history.

-- setup columns for snapshots

column bsnap1 new_value bsnap1s noprint;
column esnap1 new_value esnap1s noprint;
column filenm new_value filenms noprint;

-- get snap id for first day of previous month

select min(snap_id) bsnap1
from dba_hist_snapshot
where 
extract(month from END_INTERVAL_TIME)=
extract(month from (sysdate-to_number(to_char(sysdate,'DD'))))
and
STARTUP_TIME=
(select max(STARTUP_TIME)
from dba_hist_snapshot
where 
extract(month from END_INTERVAL_TIME)=
extract(month from (sysdate-to_number(to_char(sysdate,'DD')))));

-- get snap id for last day of previous month

select max(snap_id) esnap1
from dba_hist_snapshot
where 
extract(month from END_INTERVAL_TIME)=
extract(month from (sysdate-to_number(to_char(sysdate,'DD'))));

-- get html file name

select 
name||
'_'|| 
to_char(extract(month from 
(sysdate-to_number(to_char(sysdate,'DD')))))||
'_'|| 
to_char(extract(year from 
(sysdate-to_number(to_char(sysdate,'DD')))))||
'.html' filenm
from v$database;

-- get awr report

define report_type='html';
define begin_snap = &bsnap1s;
define end_snap = &esnap1s;
define report_name = '&filenms';

define num_days = 0;

@@$ORACLE_HOME/rdbms/admin/awrrpt.sql

undefine report_type
undefine report_name
undefine begin_snap
undefine end_snap
undefine num_days

If the database bounced during the previous month we get the last set of snapshots after the last bounce.

I am not sure whether this approach will give us any benefits but I think it may help to show how to use queries to pick begin and end snapshots and then run an AWR report.

The tricky part of the code is this:

extract(month from (sysdate-to_number(to_char(sysdate,'DD'))))

It just returns the previous month as a number.  It is August now so here is what it returns today:

SQL> select
 2 extract(month from (sysdate-to_number(to_char(sysdate,'DD'))))
 3 prev_month
 4 from dual;

PREV_MONTH
----------
 7

sysdate-to_number(to_char(sysdate,’DD’)) is the last day of the previous month:

SQL> select sysdate-to_number(to_char(sysdate,'DD')) last_day
 2 from dual;

LAST_DAY
---------
31-JUL-15

– Bobby

Categories: DBA Blogs

Oracle Social Cloud Expands Twitter Partnership to Enable Better Social Service and Customer Experiences

Linda Fishman Hoyle - Tue, 2015-08-18 11:42

A Guest Post by Group Vice President Meg Bear (pictured left), Oracle Social Cloud

We all know the importance of "customer service” in delivering excellent customer experiences, and Oracle Social Cloud is taking social service capabilities to a new level for its customers. During the past two weeks alone, Oracle Social has announced its new Twitter partnership for advanced customer service insights, as well as the latest Social Cloud + Service Cloud enhancements and integrations. You can read more about these social service enhancements in this latest Forbes blog.

On August 6, 2015, Twitter and Oracle Social Cloud announced an extended partnership that gives Oracle customers enriched Twitter data and functionality to create improved and transformative customer service solutions for brands. As Twitter is the primary and growing social platform for customer service, this allows Oracle to deliver next-generation social service solutions for its customers and build out stronger, more engaging customer experiences. You can read more detail about the new Twitter functionally in this Wired article and on the Oracle Social Spotlight blog.

The importance of social service is echoed by our customers: “General Motors continues to strive for excellence with our customer care capabilities, providing new ways to understand and engage with our customers like never before—and it’s a winning strategy for both our customers and our business,” said Rebecca Harris, Global Head of Social Center of Expertise at General Motors. “We interact daily with our customers on Twitter, allowing for a quicker, more personal engagement, enabling General Motors to put its customers at the center of everything we do.”

Additionally, Oracle Social and Service Cloud jointly announced the latest social service integrations and enhancements this week during the CRM Evolution industry event in NYC, where Oracle has a strong presence through a sponsorship and speaking presence with Oracle executives Meg Bear (Social Cloud), Erika Brookes (Social Cloud) and Stephen Fioretti (Service Cloud). Read more about these social service enhancements in this VentureBeat article.  

Bottomline: Oracle CX is leading the market as the only platform that takes a comprehensive view of customer engagements and insights across the entire lifecycle and across every channel to drive stronger, more satisfying customer experiences.


Convert CSV file to Apache Parquet... with Drill

Tugdual Grall - Tue, 2015-08-18 08:44
Read this article on my new blog A very common use case when working with Hadoop is to store and query simple files (CSV, TSV, ...); then to get better performance and efficient storage convert these files into more efficient format, for example Apache Parquet. Apache Parquet is a columnar storage format available to any project in the Hadoop ecosystem. Apache Parquet has the following Tugdual Grallhttps://plus.google.com/103667961621022786141noreply@blogger.com0

(X)Query OPatch Information From The Database

Marco Gralike - Tue, 2015-08-18 07:55
There are cool posts out there regarding querying the OPatch info in Oracle 12 which…

If You Were the CIO...

WebCenter Team - Tue, 2015-08-18 07:47
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

If you were a Chief Information Officer (CIO) of a large company, say like Oracle, what would you want from a collaboration solution? What would be your 3 biggest priorities? Would security trump convenience? How about heterogeneity? And plugability – the ability for the solution to connect with existing systems and infrastructure? What about control? Would you trust the public Cloud?

Find out what Mark Sunday, Senior Vice President and Chief Information Officer has to say about cloud based Enterprise File Sync and Share solution.

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;}

Oracle 12.1.0.2.x – JSON Database Patch Bundle(s)

Marco Gralike - Tue, 2015-08-18 03:58
It has been a while I patched a local development database, but nowadays stuff gets…