Feed aggregator

How to Increase Partner Opportunities using Oracle Applications User Experience Enablers

Usable Apps - Wed, 2016-09-21 16:44

By Plinio Arbizu of Oracle Gold Partner Services & Processes Solutions, Mexico

There are lots of advantages for partners by employing user experience (UX) practices to develop their business solutions. Major benefits such as productivity gains, user satisfaction, and training savings are realized during project implementation right through to the final delivery.

However, what happens when a partner is in the pre-sale project stage or when the customer is not yet convinced to invest resources to implement UX improvements?

In such situations, at S&P solutions we have found that applying design and prototyping techniques to legacy systems allows us to quickly show customers the benefits that can be achieved with an enhanced applications user experience.

This article provides details of a prototyping experience using the tools provided by the Oracle Applications User Experience (OAUX) Cloud User Experience Rapid Development Kit (RDK).

Use Case

Oracle iProcurement is part of Oracle E-Business Suite and enables organizations to perform the procurement activity electronically over the internet.  The user interfaces are a classic desktop design as shown in the following image:

Oracle iProcurement Desktop UI

In this case, we are going to enhance the Oracle iProcurement user experience, taking into account real customer requirements and suggestions about the design.

Customer Requirements

The requirements for the new design are:

1. To expedite the Receiving Goods process. Usually, users perform the following steps to complete the receiving process:

a. Visually inspect received goods.

b. Registration of the received goods on paper.

c. Registration of this paper information in Oracle iProcurement.

The proposed digital UX solution should simplify this process in order to reduce operations time.

2. The new user experience must facilitate the user to be more productive in completing tasks.

Proposed Solution

The proposed solution was composed of these important features.

  • Use of mobile devices. This would allow the receiving process to be performed flexibly from the factory receiving zone and avoid the need for of paper.
  • Use of mobile device features. To reduce processing time for received goods we can use the mobile device camera to read the barcode of the goods and avoid typing in the codes manually.

Suggested User Interfaces

In order to implement the requirements, we suggested the following interface design:

List of Requisitions

Proposed Requisitions Mobile UI Design

Proposed Requisitions List Mobile UI Design

On this mobile interface we can see the same requisition information shown in the previous desktop interface. But, in the redesign we've proposed the following recommendations to improve the user experience:

  • A flatter visual design.
  • Page content that is constrained horizontally and centered.
  • The most important content is easily glanced at.
  • More content is available with a wider display, in landscape mode.
  • A salient color is used to highlight – not decorate, but we ensure that we meet accessibility requirements for use of color too.
  • Gradual disclosure of key information as needed to complete the task.     

Receive Requisitions

Proposed Receive Requisitions Mobile UI Design

Proposed Receive Requisitions Mobile UI Design 

This interface is designed to register the receipt of goods:

  • We use colors to highlight the information. For example, we use the red color to identify modified information, but again are aware of accessibility requirements.
  • Another important aspect considered in this design is that only information that is really useful for the business process (for example, requisition quantities) is displayed.
  • This design follows a gradual disclosure recommendation.  For example, the Change Receipt Quantity and Delete Item options are not displayed by default, but only when the user needs to update info by selecting the yellow button on the right. 

Resources

We used the prototyping tools provided by the OAUX Cloud UX RDK. The RDK includes an easy-to-use wireframing template and tools that enable the creation of high-fidelity wireframes that were used for creating the mobile user interfaces included in this article.

In addition to the RDK, the Oracle Applications User Experience team offers partners and developers resources and methods to improve applications user experience productively and to win business. More details can be found on the Usable Apps website.

Conclusions

Using the OAUX resources to show customers designs of user interfaces that apply key UX principles and comparing the new designs with existing solutions  is an excellent way to demonstrate the advantages of an improved user experience and to win customer business.

Enablement for the design and building of partner user experience solutions is available for free. Use the resources and guidance offered by the OAUX team on the Usable Apps website and the information on the Usable Apps blog.

These resources and knowledge enables Oracle partners and developers to improve their skills and to offer customers more than technical skills: a complete user experience that is easy and fast to design, build, and implement.

About the Author

Plinio Arbizu is an Oracle Applications User Experience Designated Speaker and Oracle Technology Network ACE Director. He has more of 15 years of professional experience in projects using Oracle products such as Oracle Forms, Oracle ADF, Oracle WebCenter, and Oracle Mobile Application Framework (MAF) and is one of the authors of Web 2.0 Solutions with Oracle WebCenter 11g.

Plinio is a frequent speaker at Latin America events and is one of the coordinators of ORAMEX (Grupo de Usuarios Oracle de México/Oracle User Group Mexico), as featured on the Usable Apps blog. Plinio also holds UX certification from the Nielsen Norman Group.

Lessons in Marketing from Macy's

WebCenter Team - Wed, 2016-09-21 16:04
Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4

I am from New York and Macy’s is a staple brand for me. We can all recognize that red star anywhere we see it, we can picture their showrooms, the store’s brand displays, the floor upon floor of fashion clothing, accessories, home and beauty products. All of use, especially us New Yorkers enjoy and are well versed with Macy’s Fireworks and their world-famous Thanksgiving Parade.

For a brand to evoke such strong associations and positive recognition, clearly they must be doing something right in marketing (and customer service too)!

Well, here’s our big chance to learn a thing or two from Macy’s. If you are at Oracle OpenWorld 2016 this week, then don’t miss Thursday session:

Digital Asset Management for Modern Enterprises [CON7267]
Thursday, September 21 | 10:45 a.m. – 11:30 a.m.
| Moscone W 2014
Marc Andre-Houle, Senior Product Manager, Oracle
Christopher Kung, Vice President, Macy's China Limited
Rebecca Li, Senior Manager, Macy's China Ltd.

As a marketer, you recognize the big challenge in managing digital assets for multiple channels for customer facing platform. From content creation, collaboration to review and approvals to multi-channel content publication and delivery. Learn how Oracle Digital Asset Management is looking to solve these and such marketer’s challenges.

And hear from Macy’s China leadership on how Macy’s leverages technology to stay ahead of the competition and drive brand leadership and marketing results. Macy’s focuses its efforts on customer satisfaction and it starts even before you become their customer. Learn how Macy’s marketing strategy starts with content creation using digital technologies and goes all the way to publication and delivery.


Don’t miss:

Digital Asset Management for Modern Enterprises [CON7267]
Thursday, September 21 | 10:45 a.m. – 11:30 a.m. | Moscone W 2014


Tweet along with #OracleDX and #OOW16 and share your thoughts, lessons and experiences too.

/* 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:0in; mso-para-margin-bottom:.0001pt; 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;}

#OOW16: Highlights from Days 1-3

WebCenter Team - Wed, 2016-09-21 10:49

Well here we are at day 3 already of Oracle OpenWorld, and we’ve heard some pretty exciting announcements this week!

Larry Ellison kicked off Sunday's keynote by showcasing industry-first cloud innovations and announcing our release of Oracle's second generation Infrastructure as a Service (IaaS) data centers. Ellison introduced Oracle Database 12c Release 2, as well as more than 20 new Oracle Cloud Platform and Application services that extend choice and access for customers and partners globally. Industry-first innovations highlighted include a new Database as a Service (DBaaS) that is orders of magnitudes faster and more scalable than other Cloud database services and new Adaptive Intelligence Applications that use machine learning to power the next generation of Cloud applications.

"You will see as we develop features for the cloud, we'll also start delivering our software in the cloud first. Clearly it's going to go on-premises, but the first deployment of our database and a lot of our software now is going to go to the cloud first." - Larry Ellison, Executive Chairman & CTO, Oracle

Image result for larry ellison openworld keynote 2016 image

Larry also showed off a new platform for building and running ChatBots! Our Oracle ChatBot Platform is a simple interface for enterprise applications and the ChatBots made with it can work in modern messaging apps like Facebook Messenger, Slack, and Kik. The tool doesn’t require you to write in Java, PHP, or even JavaScript, instead, it involves dragging and dropping in a graphical user interface. 

Monday brought a full day of sessions covering our strategy & vision for our Content and Experience Management solutions, as well as a general session where Inderjeet Singh, EVP, Fusion Middleware Development, Oracle, showed the capabilities of Oracle’s middleware platform-as-a-service solutions for cloud-native application development, API management, data and enterprise integration, the Internet of Things, big data, machine learning, data visualization, and mobile ChatBots. He showcased how to easily move existing Oracle and non-Oracle workloads to the cloud; how to extend and integrate on-premises and software-as-a-service applications; and how to build API-first, mobile-fronted applications with portability across public and on-premises clouds.

The Oracle OpenWorld Content and Experience Management Website has been such a seamless and easy way for attendees to have all the important information right at their fingertips this week! Live Twitter feeds and pictures allow attendees to experience the conference in real time. Have you tweeted using hashtags #OracleDX or #OOW16? Your tweets will appear on the site! How cool is that? We hope you'll give it a try if you haven't already. https://sites.oracle.com/oowdx

The Oracle Mobile Challenge has been a huge hit this week! While attendees have been going to sessions, visiting vendors in the exhibit hall (Moscone South) and networking with experts, they've been able to add in some fun and some have won some great prizes! Throughout the week, Samsung has given away Galaxy smartphones, 360 Gear VR Cameras, and Gear VR Goggles! There is still time for you to play, as today will be the last day to participate (although we still hope you attend sessions and visit with us tomorrow). Here you can see who Monday's winners were!

As we approach the last 2 days of OpenWorld, we hope you have had a great start to your week and look forward to meeting with you and talking further! Be sure to join in on the conversations!


Wednesday at OpenWorld and JavaOne

OTN TechBlog - Wed, 2016-09-21 10:24

Wednesday at the OTN Lounge and Java Hub have activities still in full swing.

Have you visited the IoT Workshop in the OTN Lounge? Interact with your fellow attendees by getting your own wi-fi micro microcontroller and connect it to Oracle IoT Cloud Service. OTN is partnering with the AppsLab, the OAUX emerging technologies team, to make this happen. Don’t forget to download the app to participate in the workshop.

The Java Hub Gaming Station is in its last day! Play your favorite Nintendo games on a retro handheld console, powered by Java, running on a Raspberry Pi, and printed on a 3D printer. It is optimized using Flight Recorder and is connected to the Oracle Cloud.

Normal 0 false false false EN-US X-NONE X-NONE /* 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-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; 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-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Normal 0 false false false EN-US X-NONE X-NONE /* 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-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; 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-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

This past Sunday the OTN Lounge hosted the Women in Technology (WIT) Panel. They will be at the Java Hub today at 1:30. Visit the Oracle WIT community space to learn more and join the conversation. It's a place to share your knowledge, technical resources and engage with other women throughout the Oracle technical community. Make sure to include #OTNWIT with posts you'd like to share!

Normal 0 false false false EN-US X-NONE X-NONE /* 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-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; 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-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} This past Sunday the OTN Lounge hosted the Women in Technology (WIT) Panel. They will be at the Java Hub today at 1:30. ">Visit the Oracle WIT community space to learn more and join the conversation. It's a place to share your knowledge, technical resources and engage with other women throughout the Oracle technical community. Make sure to include #OTNWIT with posts you'd like to share!

Normal 0 false false false EN-US X-NONE X-NONE /* 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-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; 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-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} Stop by the OTN Lounge to watch a CommunityCast taping. Today we have the winners of OFM PaaS Oracle Innovation Awards, the SQL authors and book signing, and build SPARC Cloud Infrastructure with OpenStack.

The OTN Systems Hub has times for the Systems’ sessions at OpenWorld and interviews at the OTN Lounge, with Jamie Iles discussing security and downtime at 10 am.

Visit the OTN Archbeat Blog to learn more about specific ACE sessions and stop by the OTN Lounge to watch the taping of the infamous Two Minute Tech Tips.

Normal 0 false false false EN-US X-NONE X-NONE /* 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-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:8.0pt; mso-para-margin-left:0in; line-height:107%; 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-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;}

Tonight the OTN and Pythian are sponsoring the Oracle Bloggers Meetup. It will be held at Jillian’s @ Metreon 5:30 – 7:00 pm. Following the meetup is the Oracle Appreciation Event featuring Multi-GRAMMY Award-Winning Artists Sting and Gwen Stefani.

Oracle Open World 2016 from a PeopleSofter point of view: Tuesday 20th

Javier Delgado - Wed, 2016-09-21 10:10
We are now at full steam in what regards PeopleSoft at Oracle Open World. As my jet lag gets better (today I woke up at 4.30am, quite an achievement), so does the announcements at the PeopleSoft specific sessions.

The day started with a general keynote facilitated by Safra Catz and Thomas Kurian. I have found the second part most interesting as it went deeper into the announcements made last Sunday by Larry Ellison. Compared to my last presence at OOW two years ago, it is quite noticeable to see how some technologies such as Big Data have now made their way to the headlines while others like Docker have appeared apparently from nowhere. This is what I like about the IT industry, the pace of change eliminates any possibility of boredom.


But of course this blog is about PeopleSoft, so let's focus on that. Yesterday I have the opportunity to attend the following sessions:
  • General Session: Today’s PeopleSoft is Intuitive, Powerful, and in the Cloud [GEN5077] delivered by Paco Abrejuan.
  • PeopleSoft Technology Roadmap [CON7061] by Jeff Robbins.
  • Hands-On with PeopleSoft: Value of PeopleSoft in Oracle Cloud [CON7072] also by Jeff Robbins.
The first session outlined the most significant functional and technical enhancements that we should expect in the near future, while Jeff focused in more detail in some of the technical ones.

All in all, some serious announcements were made. All of them were in line with Oracle's recommendation to customers in order to maximise their investment:
  • Implement PeopleSoft Fluid UI
  • Fully execute on Selective Adoption
  • Deploy PeopleSoft to Oracle Cloud


Fluid UI
This is probably the area that concentrated most of the announcements. Every enhancement is now using Fluid UI, so its adoption seems to be the best way for customer to protect their PeopleSoft investment.

This is of enhancements that seemed more interesting to me:
  • The Expenses module is now present in Fluid UI. This was one of the first mobile-enabled modules, although it was originally built using iScripts, which made its maintenance rather difficult. The new pages in Fluid look much better and I'm sure it will be easier to maintain.
  • A new Classic Plus style will be delivered in PeopleTools 8.56, giving traditional UI pages a closer look and feel to the Fluid UI ones. This stylesheet will not make these pages responsive, but it should significantly improve the user experience when navigating back and forth Fluid and traditional UI pages. 


  • ElasticSearch will be replacing Oracle SES as of PeopleTools 8.56, meaning that both SES and Verity will be deprecated. I cannot say I'm sad about these news.

  • Mobile Approvals will now be implemented in Fluid and not MAP. This does not necessarily mean a different look, but it should make the maintenance simpler, as from my point of view MAP is more complex to debug when comparing to Fluid.

  • Related to Mobile Approvals but extensible to other pages is the new Page Composer, a fancy tool allowing to create and modify pages from the web browser. Amazing, isn't it?


One important note to be made is that Oracle idea is to gradually remove support for those traditional UI pages that have Fluid UI counterparties. So, if you are not yet in Fluid UI, you should start seriously considering it.

Selective AdoptionOracle would like to see more and more customers taking advantage of the Selective Adoption delivery model. Jeff Robbins gave an interesting presentation on how this actually means to build a DevOps organisation in synch with the PeopleSoft Support and Development team.

Looking backwards, Oracle has introduced in the last few years a lot of improvements in order to make Selective Adoption easier, like the use of Oracle Cloud for Update Images or the capability to identify those enhancements not affected by customisations.

From my point of view, the key barrier to implement Selective Adoption remains the maintenance procedures at PeopleSoft customers. Selective Adoption has not only changed the way we apply patches and enhancements to PeopleSoft applications, but also the way we should budget and plan our maintenance efforts.



A key announcement made during these sessions was that PeopleTools will not be delivered for the moment using the Continuous Delivery model, so we should expect to see a PeopleTools 8.57, 8.58 and so on. This contradicts the announcement made during last Oracle Open World, but I do not think it is necessarily bad news.

PeopleSoft in the CloudLast Oracle Open World we heard a lot of announcements related to making PeopleSoft easier to deploy in the cloud. As Graham Smith said during his session on Monday, PeopleSoft has been always able to run in the cloud, but now it is just easier to make the transition.

In this edition of Oracle Open World, one of the main announcements for PeopleSoft is the new Cloud Manager. This will be particularly useful when using Oracle Compute Cloud as the IaaS/PaaS platform.


Oracle Cloud Manager can be used for several purposes, including:

  • Subscribing to updates and applying them automatically in Demo enviroments.
  • Quickly provision new environments for specific purposes such as development, testing or training.
  • Lifting and shifting PeopleSoft Dev/Test instance to the Oracle Cloud.

All in all, and although I have always been a happy user of Amazon Web Services, Oracle's Cloud value proposition for PeopleSoft applications seems to be getting better and better.

Postcards from Oracle Open World
This time I did have some time to visit around the exhibition halls and different booths. Wednesday looks exciting with sessions and the Appreciation Event (I hope this time I do not lose my wristband like in 2014). 

In the meanwhile, I leave you some pictures. Keep tuned for more updates!

Shouldn't it be in the clouds?
I don't see Hillary as an option :-(
Nice one!


Oracle Announces Platform Innovation Award Winners

Oracle Press Releases - Wed, 2016-09-21 07:06
Press Release
Oracle Announces Platform Innovation Award Winners Celebrates customers using Oracle PaaS and IaaS to drive business value

Oracle OpenWorld, San Francisco, Calif.—Sep 21, 2016

This week at Oracle OpenWorld, Oracle honored the winners of the 2016 Oracle Cloud Platform Innovation Awards. This prestigious group of recipients is using Oracle’s PaaS and IaaS services in new and innovative ways to transform their businesses, drive innovation and gain a competitive advantage.

Thirty-one customers were chosen from around the world, spanning small and medium businesses to the largest enterprise, across a wide range of industries. This year’s winners include: Ambev, Avaya, BAMF, Calix, Cima Global, Cisco Capital, City of Hope, ClubCorp, Cummins, Inc., DX Marketing, Dubai Airports, Elbooq, ENEL, HCPA, Helsana Gruppe, IDEA Cellular, IDEXX Laboratories, La Caixa, Manchester Airport Group, Nacional Monte de Piedad, National Pharmacies, The Procter and Gamble Company, Rakuten, Renault, Safexpress, State Bank of India, SuiteBox, Tippett Studio and YellowDog.

“These awards recognize customers that are using Oracle’s PaaS and IaaS together in unique and innovative ways to transform their businesses. Over the past couple of years, we’ve seen our customers make a wholesale move in using the Cloud for just simple dev/test scenarios to running serious, enterprise workloads in the Cloud,” said Amit Zavery, senior vice president of Cloud Platform and Integration products, Oracle. “We’d like to congratulate all customers on their well-deserved awards.”

Part of the Oracle Excellence Awards, the Cloud Platform Innovation Awards is an annual awards program recognizing customers for their cutting-edge solutions using Oracle’s PaaS and IaaS services. Recipients of Oracle’s Platform Innovation Awards were selected based on the uniqueness of their business case, business benefits, level of impact relative to the size of the organization, complexity and magnitude of implementation and the originality of architecture.

Oracle Cloud Platform and Infrastructure enables organizations to move their enterprise workloads to the Cloud while providing their customers with a portfolio of highly innovative and accessible cloud-based services to capitalize on key transformative technologies such as big data analytics, machine learning and IoT.

A few of the 2016 winners are:

HCPA Chose Oracle Cloud at Customer for Running Business-Critical Healthcare Workload

Hospital de Clínicas de Porto Alegre (HCPA) is a leading hospital in Brazil with 850 beds. It is well known for transplants and genetic research in Latin America and conducts over 600,000 consultations a year. Oracle Cloud at Customer allowed HCPA to run applications that handle healthcare data on their premises and enabling low latency connections to other on-premises applications.

“By moving to Oracle’s Cloud at Customer infrastructure with subscription based pricing, HCPA was able to immediately cut back $2.5MM in CapEx expense, and foresee additional savings as more workloads are moved to Cloud at Customer,” said Valter Silva, CIO, HCPA. “Oracle Cloud at Customer is fully managed by Oracle. As a result, HCPA has also significantly reduced our IT operating and staffing costs.”

IDEA Cellular Chose Oracle PaaS to Help Prevent Outages in its Most Mission-Critical Applications

IDEA Cellular, one of India’s leading wireless telecommunication providers, is using Oracle Management Cloud to help prevent potential outages and also to increase performance and efficiency of its mission-critical applications. Using Oracle Management Cloud, IDEA Cellular is able to monitor its Oracle and third-party applications to rapidly identify the root cause of problems before they become potential problems.

“IDEA Cellular has over 175 million wireless subscribers, and our mission-critical systems cannot afford downtime,” said Prakash Paranjape, CIO, IDEA Cellular. “Oracle Management Cloud’s machine learning techniques enable us to proactively identify potential operational trouble-spots even in our most complex applications, helping to prevent failures.”

Tippett Studio Chose Oracle IaaS to Store Special Effects Used in Biggest Blockbuster Movies

Tippett Studio, the animation and visual effects company behind incredible special effects in films like Jurassic Park, RoboCop, Starship Troopers, Twilight, Jurassic World and Star Wars: The Force Awakens plans to move petabytes of archived digital content to the Oracle Storage Cloud Services to provide a global content repository for easy accessibility and sharing and to streamline its operations at cloud-scale economics.

“With Oracle Storage Cloud Services, we can access content from anywhere in the world much faster than with legacy IT gear and benefit from unrivaled economic value,” said Sanjay Das, COO, Tippett Studio. “We selected Oracle because it provided the most compelling business value for our growing animation and visual effects business while other public cloud services were priced up to 10 times more.”

For additional information, visit Oracle Cloud and connect with Oracle Cloud on Facebook and Twitter.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
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.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

Trademarks

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

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Oracle Cloud Helps Grant Thornton Tap Workforce Insights

Oracle Press Releases - Wed, 2016-09-21 07:04
Press Release
Oracle Cloud Helps Grant Thornton Tap Workforce Insights Using Oracle’s Public Cloud Infrastructure, Grant Thornton unlocks insights from U.S. Workforce

Oracle OpenWorld, San Francisco, Calif.—Sep 21, 2016

Oracle Corporation today announced that its Cloud infrastructure solutions are helping Grant Thornton LLP—a leading accounting and consulting firm—match its professionals to its client’s needs by providing a platform to tap large volumes of in-house workforce data.

To accomplish this, Grant Thornton and Oracle have deployed an analytics solution on Oracle Public Cloud—an effort that has unified Grant Thornton’s data sources, increased its data confidence and reduced data bottlenecks.

“We turned to Oracle because we wanted to tap big data to more effectively get the right client-service professionals in the right roles,” said Grant Thornton Chief People and Culture Officer Pamela Harless. “The ability to pair the correct people with carefully aligned projects is critical in the highly competitive world of professional services—and it’s why we chose an integrated Oracle Cloud infrastructure and analytics environment.”

According to Harless, Oracle Cloud maximized value and accelerated adoption through the Oracle Accelerated Buying Experience, which enabled Grant Thornton to procure the Cloud services quickly and easily – keeping the firm on track to meet its aggressive deployment timeline.

“We are excited about this partnership with Grant Thornton. The solution they built underlines the power, flexibility and agility of the Oracle Cloud Platform,” said Don Johnson, vice president of product development at Oracle. “This partnership is an example of the modern investments we are making in building the next generation storage platform.”

Grant Thornton and Oracle hope to continue their collaborative relationship by jointly bringing similar workforce-analytics and big-data offerings to the marketplace.

To learn more about what Oracle Cloud can do for you, please visit us at cloud.oracle.com.

Contact Info
Scott Thornburg
Oracle
+1.415.816.8844
scott.thornburg@oracle.com
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.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

Trademarks

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

Disclaimer

“Grant Thornton” refers to Grant Thornton LLP, the U.S. member firm of Grant Thornton International Ltd (GTIL). GTIL and the member firms are not a worldwide partnership. Services are delivered by the member firms. GTIL and its member firms are not agents of, and do not obligate, one another and are not liable for one another’s acts or omissions. Please see grantthornton.com for further details.

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Scott Thornburg

  • +1.415.816.8844

Adventist Health Cures Aging Legacy IT Systems with Oracle Cloud

Oracle Press Releases - Wed, 2016-09-21 07:02
Press Release
Adventist Health Cures Aging Legacy IT Systems with Oracle Cloud Rapidly expanding integrated health delivery network chooses Oracle Applications Cloud to modernize systems and help drive growth

Oracle OpenWorld, San Francisco, Calif.—Sep 21, 2016

Adventist Health, a faith-based, nonprofit integrated health system, has selected Oracle Applications Cloud as part of an end-to-end Cloud deployment to modernize its IT systems and transform the performance of key business functions including HR and Finance. The move to Oracle Applications Cloud will enable Adventist Health to support its strategic growth initiatives, simplify its technology infrastructure and lower costs.

An innovator for more than 150 years, with 20 hospitals, over 260 clinics and a workforce of 32,700, Adventist Health was struggling with aging legacy technology, built for a different era and was unable to meet the dynamic healthcare challenges of today. Following a competitive review that included Workday, Infor, and SAP, the organization selected Oracle Applications Cloud, including Oracle Enterprise Resource Planning (ERP) Cloud, Oracle Human Capital Management (HCM) Cloud, Oracle Analytics Cloud, and Oracle Enterprise Performance Management Cloud on the strength of its integrated breadth and depth of offerings, embedded analytics and the modern, easy-to-use interface of its applications.

“We wanted to modernize our systems by moving to the Cloud, but we also wanted a single, unified solution that comprehensively addressed a wide range of our business areas, with room to grow. Oracle met all these needs,” said Chip Dickinson, vice president for business solutions, Adventist Health. “With the Oracle Applications Cloud, we will have the modern tools that will enable us to best serve our workforce, our business operations, and most importantly, our patients and communities.”

Adventist Health will take advantage of Oracle ERP Cloud’s complete suite of capabilities across financials, procurement, and project portfolio management to help optimize its hospital and clinic network, and drive operational efficiencies while reducing costs. The solution’s available physical, data, and functional security, along with proven scalability, help ensure privacy and performance. Critically, Oracle ERP Cloud’s seamless integration with Oracle HCM Cloud will allow Adventist Health to tightly align talent requirements and investments to strategic growth plans.

With Oracle HCM Cloud, Adventist Health will be able to build a global common model for HR processes, deliver streamlined processes that reduce manual and duplicative efforts, and ensure tight HR process integration to drive complete and impactful reporting, analytics and payroll on a centralized system. Oracle HCM Cloud provides this through an enhanced user experience via a simple, scalable and intuitive design with mobile and self-service capabilities.

“We are proud to partner with Adventist Health to help them best manage and connect with staff, whether it’s through performance management, strategically aligning competencies to positions, or by providing deeper insight into organizational structuring,” said Gretchen Alarcon, group vice president of HCM Product Strategy for Oracle. “Oracle’s single unified Cloud shares data across business processes, allowing organizational leaders to keep employees engaged to best serve patient needs.”

With the Oracle Cloud, Oracle delivers the industry’s broadest suite of enterprise-grade Cloud services, including Software as a Service (SaaS), Platform as a Service (PaaS), Infrastructure as a Service (IaaS), and Data as a Service (DaaS).

For additional information, visit Adventist Health, Oracle Cloud and connect with Oracle Cloud on Facebook and Twitter.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
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.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

Trademarks

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

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

MoneyGram Increases Business Efficiencies, Cuts Time for New Product Introductions with Oracle Cloud

Oracle Press Releases - Wed, 2016-09-21 07:00
Press Release
MoneyGram Increases Business Efficiencies, Cuts Time for New Product Introductions with Oracle Cloud Oracle Cloud solutions streamline payroll, core human resources and recruitment processes for the global money transfer business

Oracle OpenWorld, San Francisco, Calif.—Sep 21, 2016

Oracle announced today that MoneyGram International Inc., the second-largest money transfer company in the world with $1.45 billion in annual revenue, has implemented Oracle HCM Cloud to overhaul its human resources (HR) operations and reduce administrative processes to be more efficient. Reports that previously took 40-hours to produce can now be completed in 80 percent less time.

Serving more than 350,000 agent locations in more than 200 counties, MoneyGram was in need of a global tool that could accommodate the needs of its nearly 3,000 employees. The existing system required too many spreadsheets, and manual processes that were complex and did not scale. MoneyGram managers struggled to keep up with changing market demands and additions to new products and services for the sales team. The lack of a central global data storehouse for employee records and business information made it difficult to generate reports or analyze market opportunities.

Previously using a manual, on-premise service, MoneyGram opted for Oracle’s Cloud technology for its scalability and worldwide presence to help accommodate various country-specific HR issues and help streamline its global operations. MoneyGram selected Oracle HCM Cloud with specific functionalities including, Global HR, Payroll (U.S.), Workforce Compensation, Goal and Performance Management, Talent Review and Succession, and Recruiting and Onboarding. The Oracle implementation changed 25 percent of MoneyGram’s transactional infrastructure, executives said.

“MoneyGram needed a holistic approach to HR where scalability was one of the top considerations, and this is the main reason we looked at Cloud,” said Paula Peacher, senior director of Global Payroll and HRIS at MoneyGram. “Oracle HCM Cloud consolidated our payroll processes and helped us accommodate country-specific issues from a core HR standpoint. It assisted with security requirements from information to data privacy. It also increased efficiency and control and helped improve our process cycle times so we could be more responsive to market demands and maintain a competitive edge. Ultimately, our staff was able to cut time needed for new product introductions by 40 percent.”

The Oracle platform is delivering important time-saving benefits in the first year of implementation. Other benefits include savings in cost and the consolidation of multiple outdated and non-integrated legacy systems. MoneyGram executives estimate that the company has the potential to save millions of dollars by retiring outdated systems and transitioning to Oracle HCM Cloud. 

“Oracle is delivering bottom-line benefits for companies such as MoneyGram through innovative, flexible and unified cloud solutions,” said Gretchen Alarcon, group vice president of HCM Product Strategy for Oracle. “A tightly integrated system leads to more data integrity for the company and is ultimately more beneficial for their customers in the long-run.”

To learn more about Oracle HCM Cloud, follow @OracleHCM on Twitter or Facebook, or read the Modern HR in the Cloud blog

Contact Info
Jennifer Yamamoto
Oracle
+1.916.761.9555
jennifer.yamamoto@oracle.com
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.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. Designed for attendees who want to connect, learn, explore and be inspired, Oracle OpenWorld offers more than 2,200 educational sessions led by more than 2,000 customers and partners sharing their experiences, first hand. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. Oracle OpenWorld 2016 is being held September 18 – September 22 at Moscone Center in San Francisco. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

About JavaOne

The JavaOne conference brings together Java experts and enthusiasts for an extraordinary week of learning and networking focused entirely on all things Java. With more than 440 sessions covering topics that span the breadth of the Java universe, keynotes from foremost Java visionaries, tutorials, and expert-led hands-on learning opportunities, JavaOne is the world's most important event for the Java community. Join the JavaOne discussion on Twitter.

About MoneyGram International, Inc.

MoneyGram is a global provider of innovative money transfer and payment services and is recognized worldwide as a financial connection to friends and family. Whether online, or through a mobile device, at a kiosk or in a local store, we connect consumers any way that is convenient for them. We also provide bill payment services, issue money orders and process official checks in select markets. More information about MoneyGram International, Inc. is available at moneygram.com.

Trademarks

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

Safe Harbor

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Jennifer Yamamoto

  • +1.916.761.9555

Oracle NANVL Function with Examples

Complete IT Professional - Wed, 2016-09-21 06:00
The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article. Purpose of the Oracle NANVL Function The NANVL function is used to return a different value if the specified value is NaN (not a number). It’s useful for floating-point numbers such as […]
Categories: Development

Oracle Open World 2016 – Day 3

Yann Neuhaus - Wed, 2016-09-21 02:39

On day 3 I visited various sessions about In-Memory and its many new features in 12gR2. Yesterday I already listed some new features of In-Memory. In this post I want to explain the new features more in detail:

 

In-Memory Join Groups:

Columns are specified, which are used to join tables:

CREATE INMEMORY JOIN GROUP V_name_jg (VEHICLES(NAME), SALES(NAME));

Those columns share the compression dictionary. My understanding on how this works is as follows: The joins occur on dictionary values rather than data. E.g. a dictionary with distinct values of car brands (column NAME in VEHICLES and SALES) may look as follows:

BMW 1
VW 2
Mercedes 3
Ford 4
Fiat 5
Dodge 6

The dictionary values are stored in the compression units instead of the real data:

1
1
2
3
3
3
4
5
5
6

Doing that for the 2 columns allows the joins to happen on the dictionary values rather than real values. Oracle talks about a speedup of a factor 2-3 when using Join Groups.

 

In-Memory expressions:

SQL expression results (NET in the example below) can now be stored as additional in-memory columns:

CREATE TABLE SALES (
PRICE NUMBER, TAX NUMBER, ...
NET AS (PRICE + PRICE * TAX )
)
INMEMORY;

All in-memory optimizations (e.g. vector processing or storage indexes) apply to the expression columns as well. When a SQL contains the expression then it can be taken from the column store without computing it:

SELCT SUM(NET) FROM SALES WHERE NET > 50;

Different types of expressions are possible:

  • Arithmetic expression
  • Logical expression (e.g. DECODE)
  • Type conversion (e.g. UPPER, TO_CHAR)
  • PL/SQL expressions

Two modes to define the expressions to populate (Manual and Auto) can be used:

Manual: Declare virtual columns for the desired expression (see example above). The parameter INMEMORY_VIRTUAL_COLUMNS defines if virtual columns are considered for inmemory:
INMEMORY_VIRTUAL_COLUMNS
= ENABLE: All user-defined virtual columns on the table or partition enabled for in-memory will be populated
= MANUAL: User-defined virtual columns must explicitly marked for INMEMORY (default)
= DISABLE: No user-defined column will ever be populated

Auto: Oracle detects frequent expressions automatically. I.e. the optimizer stores “hot” expressions (based on frequency and cost) in the expression statistics store (ESS). With the procedures IME_CAPTURE and IME_POPULATE in the package DBMS_INMEMORY the expressions are captured and declared as hidden in-memory virtual columns on the appropriate table. Expressions in the ESS can be checked by querying ALL|DBA|USER_EXPRESSION_STATISTICS.

 

In-Memory JSON

JSON columns and expressions on JSON columns can now be populated in-memory.

 

In-Memory on Active Data Guard

According Oracle, In-Memory on Active Data Guard was the most wanted feature from customers for In-Memory for 12gR2. I.e. the In-Memory column store can now be used on the Active Data Guard instance as well. The standby database can have different data (columns) stored in-memory than the primary. The decision on what columns to populate in-memory on the different instances is based on a service. I.e. on primary the following DDL may be used:

ALTER TABLE SALES INMEMORY DISTRIBUTE FOR SERVICE A;
ALTER TABLE SHIPMENTS INMEMORY DISTRIBUTE FOR SERVICE B;

Table SALES will be populated In-Memory on that instance, which has service A enabled and SHIPMENTS will be populated on the instance, which has service B enabled.

 

In-Memory Columnar Flash

On Exadata the In-Memory format can be used on the Flash Cache. I.e. an In-Flash Column store can be created. The advantage is that there is usually much more Flash than RAM and hence more data can be cached for In-Memory on Flash scans. To do that the CELLMEMORY segment attribute is available:

ALTER TABLE sales CELLMEMORY;
CREATE TABLE trades (...) CELLMEMORY MEMCOMPRESS FOR QUERY;

Restrictions in comparison to normal In-Memory:

  • The MEMCOMPRESS sub-clause only supports “FOR QUERY LOW” and “FOR CAPACITY LOW”.
  • There is no PRIORITY sub-clause.

 

Automatic Data Optimization (ADO) extended to In-Memory

The heatmap can now be used to define how long data should remain In-Memory or when In-Memory compression should be changed. I.e. in the maintenance window or on manual request (using the procedure DBMS_ILM.EXECUTE_ILM) Oracle checks if a policy has been met to e.g. flush data from the In-Memory column store.

ALTER TABLE sales ILM ADD POLICY ... NO INMEMORY AFTER 10 DAYS OF NO ACCESS;

That allows sliding windows of column store content based on access-time or time of creation. A customized policy function can also be created in PLSQL.

 

In-Memory Fast-Start

The In-Memory column store content can now be checkpointed to Securefile Lobs. When the DB restarts the population is faster (between 2-5x) as the data can immediately be loaded in memory without CPU-intensive compression activity. To activate In-Memory Fast-Start the procedure DBMS_INMEMORY_ADMIN.FASTSTART_ENABLE with a tablespace-name as parameter has to be executed. The tablespace should be 2 times the size of the in-memory column store.

 

Cet article Oracle Open World 2016 – Day 3 est apparu en premier sur Blog dbi services.

DB Time

Tom Kyte - Tue, 2016-09-20 21:46
Hi Tom, I have been reading your questions/answers thread and like it. Want to ask you one simple question. Database Time= CPU Time +Non-Idle Wait; I see in my database, CPU Time is more all the time and Non-Idle Wait is less. say for exampl...
Categories: DBA Blogs

Materialized View

Tom Kyte - Tue, 2016-09-20 21:46
Hello Tom, What are the best practices with MV - <1> a) generate MV on the DB that owns base tables - and refresh MV and populate over the DB links to other DB's or b) Pull data from the source DB over the DB link and populate the MV from...
Categories: DBA Blogs

dynamic pl/sql - ora-00922

Tom Kyte - Tue, 2016-09-20 21:46
Hi Tom, I need to use dynammic sql in a stored procedure. I created an anonymous block to test it. The code fails at execute immediate with ORA-00922. But, when I run the code generated by the block, it works. Why doesn't it work in an anonymous bl...
Categories: DBA Blogs

Importing data from file to oracle databse via command prompt

Tom Kyte - Tue, 2016-09-20 21:46
Hi Experts, I am trying to load data from file into oracle database via command prompt throwing error like IMP-00038: Could not convert to environment character set's handle IMP-00000: Import terminated unsuccessfully I installed oracle 11g...
Categories: DBA Blogs

Listener Error Related on Web Server

Tom Kyte - Tue, 2016-09-20 21:46
Hello Chris, Conner and Tom, I am building two Apache/jBoss servers. These servers are connected to an Oracle database server version 12.1.0.1.0 on Windows 2012. 1. Web server one: The website is up and connected to the database. However, the ...
Categories: DBA Blogs

Is ROWNUM=1 on queries makes them faster all the time ?

Tom Kyte - Tue, 2016-09-20 21:46
Hi Chris/Connar, I have been checking on lot of contents in the Internet to find a "Simple Answer" for this and my final resort is AskTom. For tuning of the our PLSQL programs for our various application we have been using "ROWNUM=1" co...
Categories: DBA Blogs

Oracle EXISTS clause

Tom Kyte - Tue, 2016-09-20 21:46
Hi Tom, I have recently joined a new organization. Here I am facing performance issue for one of my stored procedure. The problematic sql in my procedure is, <i>SELECT iCustomerGroupSeqNo FROM Col_Cur_AgreementAlloc CCAA,V_Tmp_Allocationsumm...
Categories: DBA Blogs

how to install SQLCL on windows machine 86bit

Tom Kyte - Tue, 2016-09-20 21:46
hello Connor, I wanted to know if can guide me in right direction where by i may be able to download and install(Step By Step) Sqlcl. i heard about it thats its awesome tool and i really wanted to dig into it. I am using windows machine 86bit ...
Categories: DBA Blogs

Direct path reads of a FTS on a table slow - what could be the reason

Tom Kyte - Tue, 2016-09-20 21:46
We have two Oracle database instances X & Y with the same parameter / configuration. There is a table "bigtable" which has around 2 Million rows in both the databases. In a query, if the "bigtable" table is full scanned, we observe the below: 1) ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator