Feed aggregator

Query the table in Oracle 12c In-Memory still have physical reads

Tom Kyte - 8 hours 53 min ago
1. I cached a table in Oracle12C inmemory as following. <code>SQL> SELECT A.SEGMENT_NAME, 2 SUM(A.INMEMORY_SIZE) / 1024 / 1024 / 1024, 3 SUM(BYTES) / 1024 / 0124 / 1024, 4 SUM(A.BYTES_NOT_POPULATED) 5 FROM V$...
Categories: DBA Blogs

Salary increment by using cursor

Tom Kyte - 8 hours 53 min ago
<code>declare i number; j varchar2(30); cursor raise is select name, salary from emp; begin open raise; loop fetch raise into j,i; i :=i+15; dbms_output.put_line(i||' '||j); exit when raise%notfound; end loop; end; /</code> I am try...
Categories: DBA Blogs

Filter in Interactive Report with morethen 1000 values against one field

Tom Kyte - 8 hours 53 min ago
Hello, Is there any way I can apply a filter with more than 1000 values i.e. 5000 in single filed while working on the interactive report. I just want to copy paste my values separated by ','
Categories: DBA Blogs

Oracle Answers the Call to Help Cities Improve Citizen Services

Oracle Press Releases - 10 hours 59 min ago
Press Release
Oracle Answers the Call to Help Cities Improve Citizen Services San Jose and other cities turn to Oracle to transform non-emergency services

Redwood Shores, Calif.—Oct 16, 2018

embedBrightcove('responsive', false, 'single', '5848145879001');

The City of San Jose selected Oracle Service Cloud to launch a new 311 service that could help make it safer, more inclusive, sustainable and user-friendly.

Cities across the country have selected Oracle Service Cloud to rethink traditional 311 services and provide the best possible citizen experience. With Oracle Service Cloud, cities including The City of San Jose, The City of Albuquerque, Sacramento County and The City of Fort Wayne have been able to transform the way they engage with citizens for all non-emergency inquiries and services.   

The City of San Jose is the nation’s 10th largest city, with approximately one million residents. To support its goal of becoming America’s most innovative city by 2020, The City of San Jose selected Oracle Service Cloud to launch a new 311 service that could help make it safer, more inclusive, sustainable and user-friendly.

“The Oracle Service Cloud platform has enabled the City to more effectively respond to resident’s service requests,” says Desiree Jafferies, San Jose’s customer contact center manager. “It has transformed our customer experience, shifting away from a reactive response to a more proactive, real-time, data-driven service environment.”

The City of Albuquerque supports more than 900,000 citizens. To improve efficiency and provide its citizens with the best possible service, The City of Albuquerque selected Oracle Service Cloud to support its 311 service. With Oracle Service Cloud, The City of Albuquerque has been able implement a new conversational interface that allows residents to ask the Alexa voice-activated system to help with a range of requests from finding a lost pet to scheduling a large package pickup, removing graffiti, getting rid of litter or reporting an abandoned car.

“This service allows us to offer residents innovative channels to engage with their city government,” stated Mayor Tim Keller. “Alexa’s conversational user interface is convenient for the community and will help us make the most effective and efficient use of 311 resources. We’re integrating emerging technologies with government to ensure that people from all walks of life in Albuquerque have easy ways to participate with their City and utilize City services.”

Sacramento County supports more than 1.5 million citizens. To provide the best possible service and support to internal agencies and other public constituents, Sacramento County selected Oracle Service Cloud to integrate data from different sources and optimize how residents interact with its 311 service across channels. With Oracle Service Cloud, Sacramento County has been able to automate previously manual processes to free up its communications center staff to focus more on customer service, collaboration and public engagement.  

The City of Fort Wayne, Indiana is home to more than 250,000 citizens. To capture the voice of its citizens and publicly hold city departments and officials accountable, The City of Fort Wayne selected Oracle Service Cloud to modernize its 311 service. With Oracle Service Cloud, The City of Fort Wayne has been able to reduce costs by increasing self-service channels and enabling citizens to engage on their preferred channels, while also reducing average wait times by approximately 60 percent.

“With Oracle, we have been able to connect seven Divisions with 16 different departments and change the game by unifying the entire city’s metrics into one performance scorecard. This not only holds departments accountable for their service performance, but it has also enabled us to move from a reactive to a proactive organization,” said Eric Harris 311 Call Center Manager, The City of Fort Wayne. “Now through our unified system, citizens are able to take a picture of a pothole with their smartphone and we are able to fill it within four hours. The city has also been able to reduce agent training time from three months to three weeks.”

Oracle Service Cloud is part of Oracle Customer Experience (CX) Cloud Suite, which empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. 

Contact Info
Danielle Cormier-Smith
Oracle
+1.914.441.4896
danielle@positive-comms.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates.

Talk to a Press Contact

Danielle Cormier-Smith

  • +1.914.441.4896

Oracle Honors Customer Innovation with Oracle Aconex Connect Awards

Oracle Press Releases - 10 hours 59 min ago
Press Release
Oracle Honors Customer Innovation with Oracle Aconex Connect Awards Honorees in the Americas include Austin Industries, Burns & McDonnell, Colorado High Performance Transportation Enterprise and Valley Metro

Redwood Shores, Calif.—Oct 16, 2018

Oracle has announced the winners of the Oracle Aconex Connect Awards in the Americas. Now in its third year, the global awards honor customers worldwide for innovation in delivering significant construction and engineering projects efficiently and effectively. Winners for the Europe, Middle-East and Africa (EMEA) and Asia-Pacific (APAC) regions were announced separately today.

As the industry matures, so does customer technology adoption and optimization. These customers, who have demonstrated exceptional results using Oracle Aconex products, are at the forefront of embracing digital transformation to improve outcomes for all project participants. They typically see this positive change through greater process efficiency, project-wide visibility, and new insights helping to drive more informed business decisions and continuous improvement.

“The winners of the Oracle Aconex Connect Awards continue to demonstrate the powerful combination of forward-looking technology and strategic vision,” said Leigh Jasper, Vice President, Aconex Strategy and Operations, Oracle Construction and Engineering. “Through strong leadership coupled with enterprise planning, organizations can significantly improve processes in key areas such as field performance and project controls, safety and quality. Ultimately, this translates to what everyone in the industry wants to do—improve operability and meet growth objectives.”

“Aconex is a critical resource for our growing agency where organizational transparency is key,” said Wulf Grote, Capital and Service Development Director, Valley Metro. “Their support means knowing information is always available so we can get it to the right people at the right time.”

Select results from the 2018 Americas Connect Awards winners:

  • Austin Industries cut time spent tracking and reporting RFIs and submittals by 75 percent and reduced the time spent on managing communication flow across their JV by 66 percent.
  • Burns & McDonnell previously reduced RFI cycles using Aconex from 3.64 days to 2.35 days and now through cross project standardization that has continued to decrease to an average of just 1.6 days.
 

Aconex customers were nominated for the Oracle Aconex Connect Awards in three categories: 

  • Hero Award – championing change in projects to minimize risk and save costs.
  • Project Award – collaborating effectively across project teams for successful delivery.
  • Enterprise Award – standardizing best project practices across enterprise portfolios.
 

This year a special award was introduced to acknowledge the significant contribution of women to the advancement of technology in engineering and construction.

Below is a full list of 2018 Oracle Aconex Connect Awards winners in the Americas:

  • Aguas Pacífico – Hero Award to Lilian Barrios for Excellence in Process Implementation on a Public Project.
  • Austin Industries – Project Award for Excellence in Project-Wide Collaboration on a Joint Venture (SFO Terminal 1 Boarding Area B Reconstruction).
  • Burns & McDonnell – Leadership Award to Patty Sullivan - 2018 Woman in Construction Technology.
  • Colorado High Performance Transportation Enterprise – Project Award for Excellence in Process Improvement on a P3 (Central 70).
  • Valley Metro – Enterprise Award for Excellence in Process Improvement to Support Company Growth and Hero Award to April Trevett for Excellence in Company-Wide Implementation and Adoption.
 

Global honorees for the 2018 Oracle Aconex Connect Award include: China Railway Major Bridge Engineering Group Co. LTD, Faithful + Gould (member of the SNC-Lavalin Group), Lendlease, Turner & Townsend Company and VINCI Construction Grands Projets, among others. Read more about selected 2018 Oracle Aconex Connect Awards winners here.

Contact Info
Judi Palmer
Oracle
+1.650.784.7901
judi.palmer@oracle.com
Brent Curry
H+K Strategies
+1 312.255.3086
brent.curry@hkstrategies.com
About Oracle Construction and Engineering

Asset owners and project leaders rely on Oracle Construction and Engineering solutions for the visibility and control, connected supply chain, and data security needed to drive performance and mitigate risk across their processes, projects, and organization. Our scalable cloud solutions enable digital transformation for teams that plan, build, and operate critical assets, improving efficiency, collaboration, and change control across the project lifecycle. www.oracle.com/construction-and-engineering.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Judi Palmer

  • +1.650.784.7901

Brent Curry

  • +1 312.255.3086

Partner Webcast – Oracle Database running on Docker in Oracle Container Cloud service

Docker has been an incredible success over the last few years. From a rather technical open source technology in 2014, it has evolved into a standardized runtime environment, that Developers & SW...

We share our skills to maximize your revenue!
Categories: DBA Blogs

How to read a value from the user at run time?

Tom Kyte - Mon, 2018-10-15 14:46
<b></b>Hey! I am a beginner. I was watching YouTube tutorials on Oracle PL/SQL and I came across this feature that uses the placeholder to assign a value to a variable by reading it from the user at the run time. I tried my best to use the given...
Categories: DBA Blogs

Is there way to convert user defined type to JSON?

Tom Kyte - Mon, 2018-10-15 14:46
Is there way to convert user defined types/collections to JSON (the same way as it's possible to convert them to XML via XMLTYPE)?
Categories: DBA Blogs

How does a global index behave on partitioned table

Tom Kyte - Mon, 2018-10-15 14:46
Suppose i have below table which has 1 billion record and partitioned based on Budget_Flag <code> CREATE TABLE xx_tab1 (budget_flag varchar(1), period_name VARCHAR2(10), begin_dr number, begin_cr number, creation_date DATE) PARTITI...
Categories: DBA Blogs

regarding exchange table partition

Tom Kyte - Mon, 2018-10-15 14:46
hi Team, currently, we are doing partition activity , in brief about the activity is we are using exchange partition with other table. While performing exchange we are facing issue of ORA-14097 : column type or size mismatch in ALTER TABLE EXC...
Categories: DBA Blogs

Query or report all runs of a scheduled job

Tom Kyte - Mon, 2018-10-15 14:46
It's possible someone has already written such a query, but how could I write a select statement that would report on all the expected times a scheduled job is going to run? So, for example, if I have 2 DBMS_SCHEDULED jobs: job_a runs at specifi...
Categories: DBA Blogs

Standby Database for Reporting Purpose

Tom Kyte - Mon, 2018-10-15 14:46
Hi We are using 10.2.0.1.0 database and we intend to configure a standby database for reporting purpose. Could you guide us as to how can we achieve the above. Regards Abdul Wahid
Categories: DBA Blogs

Enabling TKPROF/TRACE on certain queries

Tom Kyte - Mon, 2018-10-15 14:46
Hey, Is there a way to enable TKPROF / TRACE on certain queries only. I have application with hundreds of queries. When we do load test using appdynamics(profiling tool) it shows certain simple queries like insert/update too slow (43 seconds,53 seco...
Categories: DBA Blogs

How can I get characters before and after '-OO' character in a sentence?

Tom Kyte - Mon, 2018-10-15 14:46
Hi Tom, I have a string like '000-O 1000 DENIS GRATTON TRANSPORT LTD-OO Profile Class-PHONE-25183', can I use oracle regular expression to get all characters before '-OO'? I am using Oracle 12c release 1 Kind Regards, Derek
Categories: DBA Blogs

Tutorial: Configuring Integrated SOA Gateway in Oracle E-Business Suite R12.1.3

Steven Chan - Mon, 2018-10-15 11:19

I have being receiving queries about configuring Oracle E-Business Suite Integrated SOA Gateway (ISG). ISG provides REST and SOAP based web service interfaces for public integration APIs registered in Oracle Integration Repository. Here's a quick video that walks through the configuration process:

What is in this tutorial?

In this tutorial, I follow the steps documented in Installing Oracle E-Business Suite Integrated SOA Gateway, Release 12.1.3 (MOS ID 556540.1). This is the main document which lists the required patches and steps to configure EBS R12.1.3 instance for Integrated SOA Gateway.

This tutorial has following major sections:

  • Applying Patches
  • Executing TXK script
  • Enabling ASADMIN user
  • Verifying ISG Setup

This tutorial talks about configuring ISG in single node of EBS R12.1.3. If your EBS R12.1.3 instance is configured with a load balancer, you will be required to perform additional steps mentioned in My Oracle Support Document 1081100.1.

References

Related Articles

 

Categories: APPS Blogs

3 Ways to Meet Oracle Advanced Customer Services at OpenWorld 2018

Chris Warticki - Mon, 2018-10-15 10:35

If you are attending Oracle OpenWorld 2018 in San Francisco this month, we invite you to connect with us and learn more about how Oracle Advanced Customer Services can help you and your business.

Here is where you can find us:

1. Learning Sessions

We will lead over a dozen sessions, discussing some of the top challenges businesses like yours face every day. Topics include:

  • Oracle Cloud Infrastructure: A Proven End-to-End Approach to IaaS
  • Break Down Barriers with DevOps to Accelerate Innovation
  • Protect Your Business and Your Data with Oracle Managed Security Services

2. Support Stars Bar

Come meet our experts and learn how we can help you both maximize and modernize your existing infrastructure. Share your business challenges with us and learn how we are helping customers solve these same issues every day.

3. Customer Welcome Center Demos

Join the experts demonstrating key services and capabilities of Oracle Advanced Customer Services. Learn firsthand how our flexible solutions support your innovation and business growth.

Join Us

Oracle OpenWorld 2018 is today's premier business and technology event that you won't want to miss. Oracle Advanced Customer Services will be there, ready to help you and your business achieve tomorrow’s business goals, today!

To learn more about Oracle Support and Services at Oracle OpenWorld visit: oracle.com/goto/openworldservices

To learn more about Oracle Advanced Customer Services, visit: oracle.com/acs

We look forward to seeing you there!

Faking Histograms

Jonathan Lewis - Mon, 2018-10-15 07:37

This is a short index of articles I’ve written on how to create the different types of histogram that the optimizer uses:

  • Faking a frequency histogram    How to create frequency histograms (using a numeric column for the example)
  • Histogram Tip  An example of creating a simple character-based frequency histogram (published in the IOUG Tips booklet 2014).
  • Faking a height-balanced histogram  How to create a height-balanced histogram (using a numeric column for the example).
  • Hybrid Fake: How to create a hybrid histogram (using a character column for the example).
  • Extended Histogram:  faking values into a histogram for a column group – only special because we need to derive the value stored.
  • Top frequency:  I haven’t yet worked out how to fake a Top Frequency histogram. Since it’s little more than a frequency histogram where the optimizer knows there’s a further small percentage (less than one bucketful) of other data, this doesn’t worry me; if necessary I’ll just create a “good enough” frequency histogram and set a suitable density for the remainder.

And a couple of miscellaneous things about histograms

  • Big number problem – older versions of Oracle (pre 12c) can go wrong with data values more than 15 digits long
  • Long strings problem – until 12c Oracle stored at most 32 bytes of a string in the endpoint_actual_value column.
  • Hybrid/Top-N problem – a bug, fixed in 12.2 with a patch for 12.1.
  • Upgrade threat – a step you need to take to upgrade from 11.2.0.3 if you have histograms on char() columns
  • Upgrade threat 2 (Oracle-L) – if you’ve got a big history of histograms then the upgrade from 11.2.0.3 (or earlier) could take a long time

 

[Q/A BLOG] Oracle GoldenGate 12c Q/A: Part III

Online Apps DBA - Mon, 2018-10-15 07:04

Are you learning GoldenGate and have some questions unanswered? Visit: https://k21academy.com/goldengate28 to go through some of the most commonly asked questions in our training and their answers. In this Blog we cover: ✔ The difference between CSN, SCN ✔How to get log from source & target ✔What are the areas monitoring required in Goldengate and […]

The post [Q/A BLOG] Oracle GoldenGate 12c Q/A: Part III appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Alshaya Partners with Oracle Cloud to Accelerate Growth and Expansion

Oracle Press Releases - Mon, 2018-10-15 07:00
Press Release
Alshaya Partners with Oracle Cloud to Accelerate Growth and Expansion Multinational Franchise Operator Selects Cloud Suite to Arm Associates with New Tools to Personalize Customer Experience

Redwood Shores, Calif.—Oct 15, 2018

A leading Middle East retail franchise operator, M.H. Alshaya Co., has teamed up with Oracle as part of an enterprise transformation to improve operational efficiency and build a foundation for future growth and innovation. Alshaya’s digital transformation will empower its associates by introducing retail best practices to create a more responsive and personalized customer service experience across its portfolio of recognized global brands.

For over 30 years Alshaya has been a pioneering force in retail as franchise operator of nearly 90 of the world’s best-known brands including H&M, Mothercare, Debenhams, American Eagle Outfitters, Victoria’s Secret, Starbucks, The Cheesecake Factory, Boots and Pottery Barn. This diverse brand portfolio has provided Alshaya with a footprint including more than 4,000 physical stores and 53,000 associates across the Middle East, North Africa and Europe.

To streamline omnichannel operations and support brand loyalty objectives, Alshaya will implement a suite of Oracle Retail, Oracle Customer Experience, and Oracle Cloud Applications. These solutions will be provisioned on Oracle Cloud Infrastructure solutions.

“Oracle is a proven, world-class retail solution provider with unmatched expertise and they will be a key partner in our transformation,” said Steve Marston, Chief Information Officer at M.H. Alshaya Co. “Alshaya has worked with Oracle for many years and we are delighted to extend our collaboration with them to modernize our operations, invest in our teams and foster future growth as we expand our omnichannel reach.”

Alshaya will work with Oracle Consulting Services to implement applications and cloud services across the portfolio. Alshaya associates will be empowered to segment and personalize the consumer experience and encourage loyalty with new customer relationship management capabilities. Updated operational and financial systems will accelerate growth as Alshaya continues to expand.

“Alshaya operates a complex global business model with an impressive brand portfolio. Our collaboration creates a unique opportunity to deliver long-term value for their customers,” said Mike Webster, Senior Vice President and General Manager, Oracle Retail. “Oracle is focused on innovation while uniquely helping our customers maintain a single view of customer, inventory, order and channel.”

Alshaya has selected a powerful, end-to-end modern retail solution from Oracle including:

  • Enabling a Modern Customer Experience with a Single View of Customer: Oracle Retail Xstore Point of Service, Oracle Retail Customer Engagement Cloud Service, Oracle Marketing Cloud and Oracle Service Cloud

  • Driving Operational Excellence with a Single View of Inventory: Oracle Retail Merchandise Operations Management suite with Oracle Retail Store Inventory Management

  • Modernizing Legacy Systems: Oracle Fusion Procurement Cloud, Oracle Talent Management Cloud and Oracle EPM Cloud

  • Delivering Innovation and Scale: Oracle Infrastructure as a Service, Oracle Platform as a Service, Oracle Integration Cloud Service, Oracle Mobile Cloud Service, Oracle API Platform Cloud Service

Contact Info
Matt Torres
Oracle
4155951584
matt.torres@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

Trademarks

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

Talk to a Press Contact

Matt Torres

  • 4155951584

Chegg Creates New Monetization Opportunities with Oracle Cloud

Oracle Press Releases - Mon, 2018-10-15 07:00
Press Release
Chegg Creates New Monetization Opportunities with Oracle Cloud Provider of digital services for students deploys Oracle Monetization Cloud to support flexible billing and revenue management, improve customer retention, and accelerate time to market

Redwood Shores Calif—Oct 15, 2018

Chegg, Inc., the Smarter Way to Student™, has deployed Oracle Monetization Cloud to enable innovative digital subscription services.

Chegg’s student-first, interconnected learning platform is transforming the way millions of students learn by reconnecting the link between learning and earning through tools and services that support students throughout their educational journey. Their mission is to help students save time, save money, and get smarter in order to improve the overall return on educational investment.

With Oracle Monetization Cloud, Chegg is able to offer students cross-product discounts, bundled services, free trials, and other pricing incentives to increase value to their student subscribers. The solution allows Chegg to reduce time to market for the introduction of new subscription products such as Chegg Math Solver, which went through configuration, testing and launch in just two weeks.

Chegg is also using Oracle Monetization Cloud to consolidate multiple products into a single bundle. Formerly, Chegg customers needed to buy separate subscriptions for each service –each with a separate bill. By supporting the new Chegg “Study Pack” Oracle Monetization Cloud empowers Chegg to simplify their operations, take advantage of cross-selling opportunities, and improve their subscribers’ experience of initiating and paying for their services.

“We were able to replace our homegrown billing system with Oracle Monetization Cloud in a matter of months, working closely with the Oracle Communications Consulting team to meet our projected launch date, to quickly offer students more value and a better experience” said Pritie Sharda, director of e-Commerce, at Chegg.

Oracle Monetization Cloud is integrated with Oracle NetSuite ERP to provide Chegg with a streamlined financial management solution.

“As businesses innovate to offer greater digital services, they require increasingly flexible monetization capabilities,” said Doug Suriano, senior vice president and general manager of Oracle Communications. “Chegg is leveraging Oracle Monetization Cloud to bring these services to market faster and provide a more appealing customer experience.”

Contact Info
Katie Barron
Oracle
+1.202.904.1138
katie.barron@oracle.com
Jamie Dowling
Burson Marsteller
+1.212.614.4214
jamie.dowling@bm.com
About Oracle Communications

Oracle Communications provides integrated communications and cloud solutions for Service Providers and Enterprises to accelerate their digital transformation journey in a communications-driven world from network evolution to digital business to customer experience. www.oracle.com/communications

To learn more about Oracle Communications industry solutions, visit: Oracle Communications LinkedIn, or join the conversation at Twitter @OracleComms.

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

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

Talk to a Press Contact

Katie Barron

  • +1.202.904.1138

Jamie Dowling

  • +1.212.614.4214

Pages

Subscribe to Oracle FAQ aggregator