Feed aggregator

Connect to DV Datasets and explore many more new features in OAC / OAAC 18.3.3.0

Tim Dexter - 1 hour 54 min ago

Greetings !

Oracle Analytics Cloud (OAC) and Oracle Autonomous Analytics Cloud (OAAC) version 18.3.3.0 (also known as V5) got released last month. A rich set of new features have been introduced in this release across different products (with product version 12.2.5.0.0) in the suite. You can check all the new features of OAC / OAAC in the video here.

The focus for BI Publisher on OAC / OAAC in this release has been to compliment Data Visualization for pixel perfect reporting, performance optimizations and adding self service abilities. Here is a list of new features added this release:

BI Publisher New Features in OAC V5.0

New Feature Description 1. DV Datasets

Now you can leverage a variety of data sources covered by Data Visualization data sets, including Cloud based data sources such as Amazon Redshift, Autonomous Data Warehouse Cloud; Big Data sources such as Spark, Impala, Hive; and Application data sources such as Salesforce, Oracle Applications etc. BI Publisher is here to compliment DV to create pixel perfect reports using DV datasets.

Check the documentation for additional details. Also, check this video to see how this feature works.

2. Upload Center

Now upload all files for custom configuration such as fonts, ICC Profile, Private Keys, Digital Signature etc.from the Upload Center as a self service feature available in the Administration page.

Additional details can be found in the documentation here.

3. Validate Data Model

Report Authors can now validate a data model before deploying the report in a production environment. This will help during a custom data model creation where data sets, LOVs and Bursting Queries can be validated against standard guidelines to avoid any undesired performance impact to the report server. 

Details available here.

4. Skip unused data sets

When a data model contains multiple data sets for different layouts, each layout might not use all the data sets defined in the data model. Now Report Authors can select data model property to skip the execution of the unused data sets in a layout. Setting this property reduces the data extraction time, memory usage and improves overall report performance.

Additional details can be found here.

5. Apply Digital Signature to PDF Documents

Digital Signature is widely used feature in on-prem deployments and now this has been added in OAC too, where in Digital Signature can be applied to a PDF output. Digital Signatures can be uploaded from the Upload Center, required signature can be selected under security center, and then applied to PDF outputs by configuring attributes under report properties or run-time properties. 

You can find the documentation here. Also check this video for a quick demonstration.

6. Password protect MS Office Outputs - DocX, PPTX, XLSX

Now protect your MS Office output files with a password defined at report or server level.

Check the PPTX output properties, DocX output properties, Excel 2007 output properties

7. Deliver reports in compressed format

You can select this option to compress the output by including the file in a zip file before delivery via email, FTP, etc.

Additional details can be found here.

8. Request read-receipt and delivery confirmation notification 

You can opt to get delivery and read-receipt notification for scheduled job delivery via email.

Check documentation for additional details. 

9. Add scalability mode for Excel Template to handle large data size

Now you can set up scalability mode for an excel template. This can be done at system level, report level or at template level. By setting this attribute to true, the engine will flush memory after a threshold value and when the data exceeds 65K rows it will rollover data into multiple sheets.

You can find the documentation here.

 

Stay tuned to hear more updates on features and functionalities ! Happy BIP'ing ...

 

Categories: BI & Warehousing

Error while opening Database

Tom Kyte - 3 hours 54 min ago
HI,THERE I HAVE A SITUATION HERE,DUE TO POWER OUTAGE, DATABASE KEEP GIVING ERROR <code> <code> select name,open_mode from v$database; NAME OPEN_MODE --------- -----------------...
Categories: DBA Blogs

Automatic Memory Management or manual SGA & PGA setup?

Tom Kyte - 3 hours 54 min ago
Hi Tom, I need some clarification regarding the pros & cons of Oracle's AMM compare to us manually configuring SGA_TARGET & PGA_Aggregate. I read from quite a number of blogs & posts that doesn't recommend Oracle AMM on mission critical product...
Categories: DBA Blogs

Meaning of object_id and data_object_id in dba_objects.

Tom Kyte - 3 hours 54 min ago
Hi Tom, For some objects in dba_objects, I see object_id is not matching with data_object_id even when that object is not part of the cluster. 21:35:49 SQL> select count(*) from dba_objects where data_object_id is not null and object_name not...
Categories: DBA Blogs

Latest News, Updates, and Roadmaps--Oracle Premier Support at Oracle OpenWorld

Chris Warticki - Tue, 2018-10-16 15:57

Our conference sessions give you security, and how-to information that you can apply when you are back on the job. Hear directly from Oracle Support experts and Oracle Support customers and learn how you can maximize the value Oracle Premier Support provides your company.

Bookmark the Focus on Oracle Premier Support document for quick reference on your cell phone and you will have all the Premier Support sessions and activities available at your fingertips. Click on the + button for a session to pre-register and add the session to your Oracle OpenWorld schedule.

Oracle Premier Support—Hear from Customers

Oracle Support customers tell the story best—why they rely on Oracle Premier Support and how to get more from your Oracle products—from best practices for security, compliance, and governance to moving Oracle Applications Unlimited products to Oracle Cloud Infrastructure. Whether your Oracle Applications Unlimited run on premises or in the cloud, Oracle Premier Support is there with you.

 

See all the Oracle Premier Support customer sessions.

 

Oracle Premier Support Security—Hear from Security Experts

Oracle Premier Support provides customers with an enhanced security posture. Presented by security experts with operational security experience, these sessions will give you with insight into current security trends, common causes of security breaches, and with specific recommendations to help you secure your environment.

 

See all Oracle Premier Support Security Sessions

 

Oracle Applications Unlimited—Through at Least 2030

Get the latest details on Oracle Applications Unlimited products and their availability—whether you run Applications Unlimited products on premises or in Oracle Cloud Infrastructure. See all the Applications Unlimited sessions.

See all Oracle Applications Unlimited sessions

 

Oracle Platinum Services

See how Oracle Platinum Services helps maximize availability and reduce support complexity through remote fault monitoring, decreased response times, and patching performed by Oracle experts—at no additional cost.

See all the Oracle Platinum Services sessions

 

Find all the Oracle Support sessions, activities, and events on the Support and Services Oracle OpenWorld page.

October 2018 Critical Patch Update Released

Oracle Security Team - Tue, 2018-10-16 14:59

Oracle today released the October 2018 Critical Patch Update

This Critical Patch Update provides security updates for a wide range of product families, including: Oracle Database Server, Oracle Golden Gate, Oracle Big Data Graph, Oracle Fusion Middleware, Oracle Enterprise Manager, Oracle E-Business Suite, Oracle PeopleSoft, Oracle Siebel CRM, Oracle Industry Applications (Construction, Communications, Financial Services, Hospitality, Insurance, Retail), Oracle Java SE, Oracle Virtualization, Oracle MySQL, and Oracle Sun Systems Products Suite.

As with previous Critical Patch Update releases, a significant proportion of the patches is for third-party components (non-Oracle CVEs, including open source components). 

For more information about this Critical Patch Update, customers should refer to the Critical Patch Update Advisory located at https://www.oracle.com/technetwork/security-advisory/cpuoct2018-4428296.html and the executive summary published on My Oracle Support (Doc ID 2456979.1).  

New OA Framework 12.2.6 Update 15 Now Available

Steven Chan - Tue, 2018-10-16 12:41

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure.

We periodically release updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 15 (Patch 28739010:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.6 users should apply this patch. Future OAF patches for EBS Release 12.2.6 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • When Rich Table Interaction is set to off, data binding for user-customizable properties does not take effect for classic tables.

  • A script error occurs on clicking the Go button in the Web ADI LOV window when selecting the Web ADI template.

  • An enhancement that allows developers to set an accessibility role attribute to a table HTML element.

  • Claim line level descriptive flexfields are not saved on page update.

Related Articles

Categories: APPS Blogs

Oracle Code One Expands Support for Developers

Oracle Press Releases - Tue, 2018-10-16 11:00
Press Release
Oracle Code One Expands Support for Developers Oracle Code One now covers more technologies and reaches new communities

Redwood Shores, Calif.—Oct 16, 2018

Code One

Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card.

To support and empower the developer community, Oracle Code One will take place alongside Oracle OpenWorld on October 22 to 25 at Moscone West in San Francisco. Oracle’s premier event for developers has expanded to include more languages, technologies and developer communities. Oracle Code One will cover a wide range of topics from AI, blockchain, digital assistants and containers to Java and more languages such as Go, Rust and Python. Registration is still open to all developers and available at oracle.com/code-one.

Oracle Code One features daily keynotes at 5:00 PM in Moscone North’s Hall D. In the Java technical keynote on Monday, October 22, Georges Saab, Vice President of Development at Oracle, will share Java SE updates from the last twelve months including recent enhancements made in the latest Java 11 release. They will also share a glimpse into future projects aimed at accelerating user productivity such as Java in container environments and exploration of new code review options for the JDK. This year’s Duke’s Choice Award winners will also be announced during the keynote.

The Oracle Code One keynote on Tuesday, October 23, will explore topics ranging from managed Kubernetes and serverless functions to blockchain and intelligent digital assistants powered by chatbot technology. The keynote will be presented by Matt Thompson, Vice President of Developer Engagement and Evangelism at Oracle; Amit Zavery, Executive, Vice President of Fusion Middleware and PaaS Development at Oracle; and Siddhartha Agarwal, Group Vice President of Product Management and Strategy for Oracle Cloud Platform. The Code One Meetup at 5:00 PM lets developers not registered for Oracle Code attend the keynote, join a fireside chat with iconic leaders who have made groundbreaking developer innovations and explore evening sessions.

The Java Community Keynote will take place October 24 and feature special guest, James Gosling, creator of Java, together with Stephen Chin, Director of Developer Marketing and Heather VanCura, Director at Oracle and Chair of the Java Community Process, the keynote will also include developer groundbreakers from Canoo Engineering AG, Gluon, IT-Beratung, Snyk.

“As developers look to build increasingly complex cloud native applications, Oracle continues to provide new, innovative capabilities like AI and Machine Learning, blockchain and Kubernetes support for developers to leverage,” said Siddhartha Agarwal, Group Vice President of Product Management and Strategy at Oracle. “Oracle Code One is where developers can engage with Oracle’s technical experts and the larger developer ecosystem to learn how to build the next generation of these applications and services. The event features an unrivalled variety of technical sessions and a community of peers with expertise in the tools, tricks and technologies relevant to building for the cloud. Oracle is engaging with developers wherever they are located around the world to enable innovation via learning resources, developer-focused events, hands on hackfests and free Oracle Cloud Trials to help them get started.”

Throughout Oracle Code One, developers will find more of the Java content they expect with extended workshops, talks, sessions and Hands-on-Labs to explore technologies from Oracle and the broader developer ecosystem, including GraalVM, Oracle JET, the Fn Project, OpenJFX and GraphPipe. Developers at Oracle Code One can also expect unexpected demos based on the latest emerging technologies, from AI to blockchain.

Among this year’s exciting demos, sessions and keynotes, attendees will get to experience:

  • The Code Card – With Wi-Fi, buttons and an e-link screen, developers can design their own Code Card IoT device. Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card and join a workshop to learn how to program it using Oracle Cloud Functions, serverless technology powered by the Fn Project.

  • Demo: Alpha Zero AI Algorithm Connect Four – The Meet the Experts Lounge on Monday, October 22 at 4:00 PM will feature an interactive demonstration of a neural network trained to play Connect Four using the AlphaZero algorithm and deployed using Oracle’s open source GraphPipe.

  • Demo: Blockchain Beer – An exclusive demo of how a micro-brewery outcompetes big brands with the blockchain.

  • Panel: Groundbreaker Icons – A discussion by thought leaders in software development and open source, including Doug Cutting, (Hadoop), Neha Narkhede (Kafka), Graeme Rocher (Grails), Guido Van Rossum (Python) and Charles Nutter (JRuby).

  • AR Scavenger Hunt Game – Guests in the Developer Lounge can win money for charity by searching for chess pieces with their phone cameras, by downloading a special app. Find the scavenger hunt image and a 3D Java Duke appears on the screen with a quiz on the JavaFX 11 platform. For each correct answer on the scavenger hunt, Oracle will donate money to Iridescent, a science, engineering and technology education nonprofit organization that empowers underrepresented young people to become self-motivated learners, inventors and leaders. A leaderboard in the Oracle Code One Developer Lounge will show the number of players, the number of correct answers and how much money has been raised for Iridescent.

Oracle Code One is also an opportunity for developers to learn about the wide range of open source and open standards which Oracle champions. Since joining the Cloud Native Computing Foundation last year, Oracle has continued to advance key serverless and container projects, including announcing new open serverless standard support on its open source Fn Project and critical new features for Oracle Container Engine for Kubernetes to address key Kubernetes issues. Oracle  also contributed many of its Kubernetes projects to the open source community, including JenkinsX Supported Cloud Provider for OKE, Flexvolume DriverVolume ProvisionerCloud Controller Manager and Terraform Kubernetes Installer. These announcements follow last year’s announcement that Oracle open sourced several container utilities. For developers working on machine learning, Oracle recently announced that it open sourced GraphPipe, to simplify how enterprises deploy and query machine learning models from any framework. Earlier this year, Oracle also released GraalVM, a polyglot virtual machine to run Java and JVM languages with full support for JavaScript and Node.JS, plus early support for Ruby, Python, R and LLVM bitcode.

In 2019, Oracle will host over 300 events around the world to connect with and educate developers with workshops, sessions and keynotes featuring prominent experts. To learn more about Oracle Developer Events, please visit: https://developer.oracle.com/events

Oracle Cloud Platform Momentum

At last year’s OpenWorld, Oracle announced new integrated cloud offerings that made it easier for developers to leverage transformative technologies and create modern applications. These included the launch of the Oracle Container Native Application Development Platform and the Oracle Blockchain Cloud Service, as well as the expansion of the Oracle Mobile Cloud portfolio to include artificial intelligence-powered chatbots.

To accelerate mobile and web application development and deployment, Oracle announced the availability of Oracle Visual Builder Cloud, which enables both business users and developers to build applications with little to no coding. Oracle API Platform Cloud provides full lifecycle API management services. Finally, Oracle Integration Cloud now brings pre-built application integration and process automation to the Oracle Cloud Platform, making the deployment and integration of these applications more seamless than ever.

Contact Info
Alex Shapiro
Oracle
+1 405.608.5044
alex.shapiro@oracle.com
Quentin Nolibois
Burson Cohn & Wolfe
+1.415.591.4097
quentin.nolibois@bm.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 Code One

Oracle Code One is the industry’s most inclusive developer conference, featuring a collection of international and local experts and speakers to explore the latest in developer technologies, languages, practices and leading-edge topics. Expanded from Oracle’s JavaOne, Oracle Code One brings together extensive technical Java content and numerous keynotes, sessions and workshops across 11 tracks covering a wide range of topics from chatbots, microservices, AI, and blockchain to languages such as Go, Rust, Python, JavaScript, SQL, and R. For more information, to register or to watch Oracle Code One keynotes, sessions and more, visit www.oracle.com/code-one. Join the Oracle Code One discussion on Twitter.

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. 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. 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.

Future Product Disclaimer

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, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

Forward-Looking Statements Disclaimer

Statements in this article relating to Oracle’s future plans, expectations, beliefs, and intentions are “forward-looking statements” and are subject to material risks and uncertainties. Such statements are based on Oracle’s current expectations and assumptions, some of which are beyond Oracle’s control. All information in this article is current as of October 16, 2018 and Oracle undertakes no duty to update any statement in light of new information or future events.

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

Alex Shapiro

  • +1 405.608.5044

Quentin Nolibois

  • +1.415.591.4097

[BLOG] Oracle Integration Cloud Service(ICS): Using ICS to connect to Social Media [Part 1]

Online Apps DBA - Tue, 2018-10-16 10:38

This blog is the first part of 3 part blog series on How we can connect to Social Media using ICS Integration. Visit: http://bit.ly/2AdKw4F to move ahead to: 1) Learn With a Use Case for the practical implementations 2) To know about the Implementation and Testing Phases. 3) Learn, How to create a connector from […]

The post [BLOG] Oracle Integration Cloud Service(ICS): Using ICS to connect to Social Media [Part 1] appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Inheriting super user privileges over a role automatically in PostgreSQL

Yann Neuhaus - Tue, 2018-10-16 09:18

In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in PostgreSQL, you made that role a superuser and then granted that role to another role. What happens when you login using the other role? Will you have the super user privileges by default? Sounds confusing, I know, so lets do a test.

To start with we create a simple role and make that role a super user:

postgres=# create role my_admin;
CREATE ROLE
postgres=# alter role my_admin superuser;
ALTER ROLE

Of course you could also do that in one step:

postgres=# create role my_admin superuser;
CREATE ROLE

As a second step lets create a new user that is a member of the admin group and inherits the permissions of that role automatically:

postgres=# create user my_dba login password 'admin' in role my_admin inherit;
CREATE ROLE
postgres=# \du
                                    List of roles
 Role name |                         Attributes                         | Member of  
-----------+------------------------------------------------------------+------------
 my_admin  | Superuser, Cannot login                                    | {}
 my_dba    |                                                            | {my_admin}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

The questions now is: When we login using the my_dba user are we superuser automatically?

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -U my_dba postgres
psql (12devel)
Type "help" for help.

postgres=> \du
                                    List of roles
 Role name |                         Attributes                         | Member of  
-----------+------------------------------------------------------------+------------
 my_admin  | Superuser, Cannot login                                    | {}
 my_dba    |                                                            | {my_admin}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=> create database db1;
ERROR:  permission denied to create database
postgres=> 

… and we are not. What we can do is:

postgres=> set role my_admin;
SET
postgres=# create database db1;
CREATE DATABASE

The reason for that is that some privileges are not inherited automatically and these are: LOGIN, SUPERUSER, CREATEDB, and CREATEROLE.

What you can do is put something like that into “.psqlrc”:

set role my_admin

… or do it like that:

postgres=# alter user my_dba set role my_admin;
ALTER ROLE

This will explicitly set the role with each login and the super user privileges will be there. When you have a bit more complicated scenario where roles are assigned based on patterns in the username you could do something like this and add it to .psqlrc as well (or put that into a file and then execute that file in .psqlrc):

DO $$
DECLARE
  lv_username pg_roles.rolname%TYPE := current_user;
BEGIN
  if ( substr(lv_username,1,2) = 'xx'
       and
       position ('yy' in lv_username) > 0
     )
  then
    execute 'set role my_admin';
  end if;
  perform 1;
END $$;

… or whatever checks you need to identify the correct user names. Hope that helps …

 

Cet article Inheriting super user privileges over a role automatically in PostgreSQL est apparu en premier sur Blog dbi services.

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

Tom Kyte - Tue, 2018-10-16 09:06
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 - Tue, 2018-10-16 09:06
<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 - Tue, 2018-10-16 09:06
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 - Tue, 2018-10-16 07:00
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 - Tue, 2018-10-16 07:00
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

[BLOG] Oracle EBS (R12) Financial Functional: How to merge two suppliers or supplier sites – Supplier Merge Program

Online Apps DBA - Tue, 2018-10-16 06:47

Do you want to know How to merge two suppliers or suppliers sites? Visit: https://k21academy.com/financial14 where we have covered: ✔What is Supplier Merge Program ✔How to merge two suppliers or suppliers sites & much more… Do you want to know How to merge two suppliers or suppliers sites? Visit: https://k21academy.com/financial14 where we have covered: ✔What […]

The post [BLOG] Oracle EBS (R12) Financial Functional: How to merge two suppliers or supplier sites – Supplier Merge Program appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

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

Where come from Oracle CMP$ tables and how to delete them ?

Yann Neuhaus - Tue, 2018-10-16 05:27

Regarding the following “MOS Note Is Table SCHEMA.CMP4$222224 Or Similar Related To Compression Advisor? (Doc ID 1606356.1)”,
we know that since Oracle 11.2.0.4 BP1 or Higher, due to the failure of Compression Advisor some tables with names
that include “CMP”, created “temporary – the time the process is running” by Compression Advisor process (ie CMP4$23590) are not removed from the database as that should be the case.
How theses tables are created ? How to “cleanly” remove them ?

1.Check None CMP tables exist.

SQL> select count(*) from dba_tables where table_name like 'CMP%';

  COUNT(*)
----------
         0

2. Check there is no compression enabled for the table we will use to test the Compression Advisor.

SQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'FOO';

COMPRESS COMPRESS_FOR
-------- ------------------------------
NO       NO

3.Execute the Compression Advisor procedure

The procedure DBMS_COMPRESSION.get_compression_ratio analyzes the compression ratio of a table, and gives information about compressibility of a table.
For information, Oracle Database 12c include a number of enhancements to the DBMS_COMPRESSION package such as In-Memory Compression or Advanced Compression.

Let’s executing the DBMS_COMPRESSION.get_compression_ratio procedure:

SQL> 
alter session set tracefile_identifier = 'CompTest1110201815h51';
alter session set events '10046 trace name context forever, level 12';
set serveroutput on

DECLARE
  l_blkcnt_cmp    PLS_INTEGER;
  l_blkcnt_uncmp  PLS_INTEGER;
  l_row_cmp       PLS_INTEGER;
  l_row_uncmp     PLS_INTEGER;
  l_cmp_ratio     NUMBER;
  l_comptype_str  VARCHAR2(32767);
BEGIN
  DBMS_COMPRESSION.get_compression_ratio (
    scratchtbsname  => 'USERS',
    ownname         => 'TEST_LAF',
    objname         => 'FOO',
    subobjname      => NULL,
    comptype        => DBMS_COMPRESSION.comp_advanced,
    blkcnt_cmp      => l_blkcnt_cmp,
    blkcnt_uncmp    => l_blkcnt_uncmp,
    row_cmp         => l_row_cmp,
    row_uncmp       => l_row_uncmp,
    cmp_ratio       => l_cmp_ratio,
    comptype_str    => l_comptype_str,
    subset_numrows  => DBMS_COMPRESSION.comp_ratio_allrows,
    objtype         => DBMS_COMPRESSION.objtype_table
  );

  DBMS_OUTPUT.put_line('Number of blocks used (compressed)       : ' ||  l_blkcnt_cmp);
  DBMS_OUTPUT.put_line('Number of blocks used (uncompressed)     : ' ||  l_blkcnt_uncmp);
  DBMS_OUTPUT.put_line('Number of rows in a block (compressed)   : ' ||  l_row_cmp);
  DBMS_OUTPUT.put_line('Number of rows in a block (uncompressed) : ' ||  l_row_uncmp);
  DBMS_OUTPUT.put_line('Compression ratio                        : ' ||  l_cmp_ratio);
  DBMS_OUTPUT.put_line('Compression type                         : ' ||  l_comptype_str);
END;
/

Number of blocks used (compressed)       : 1325
Number of blocks used (uncompressed)     : 1753
Number of rows in a block (compressed)   : 74
Number of rows in a block (uncompressed) : 55
Compression ratio                        : 1.3
Compression type                         : "Compress Advanced"

PL/SQL procedure successfully completed.

4.Which “CMP internal” tables are created by DBMS_COMPRESSION.get_compression_ratio ?

To handle the compression advisor process, Oracle creates 4 CMP* tables : CMP1$23590, CMP2$23590, CMP3$23590, CMP4$23590.

Strangely, Oracle Trace 10046 files contains only DDL for the creation of the last 2 ones (we can also use LogMinner to find the DDL) : CMP3$23590, CMP4$23590.
The table CMP3$23590 is a copy of the source table.
The table CMP4$23590 is a copy “compressed” of CMP3$23590 table.

grep  "CMP*" DBI_ora_20529_CompTest1110201823h19.trc

drop table "TEST_LAF".CMP1$23590 purge
drop table "TEST_LAF".CMP2$23590 purge
drop table "TEST_LAF".CMP3$23590 purge
drop table "TEST_LAF".CMP4$23590 purge
create table "TEST_LAF".CMP3$23590 tablespace "USERS" nologging  as select /*+ DYNAMIC_SAMPLING(0) FULL("TEST_LAF"."FOO") */ *  from "TEST_LAF"."FOO"  sample block( 99) mytab
create table "TEST_LAF".CMP4$23590 organization heap  tablespace "USERS"  compress for all operations nologging as select /*+ DYNAMIC_SAMPLING(0) */ * from "TEST_LAF".CMP3$23590 mytab
drop table "TEST_LAF".CMP1$23590 purge
drop table "TEST_LAF".CMP2$23590 purge
drop table "TEST_LAF".CMP3$23590 purge
drop table "TEST_LAF".CMP4$23590 purge

As we can see above, the “internal” tables (even the one compressed CMP4$23590) are removed at the end of the process.

To be sure, we check in the database :

SQL> select count(*) from dba_tables where table_name like 'CMP%';

  COUNT(*)
----------
         0

So, everything is fine, no ‘CMP’ tables exist and the source table is not compressed :

SQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'FOO';

COMPRESS COMPRESS_FOR
-------- ------------------------------
NO       NO

5.But what happens if DBMS_COMPRESSION.get_compression_ratio fails ?

Let’s forcing the failure of the DBMS_COMPRESSION.get_compression_ratio procedure…

SQL> 
alter session set tracefile_identifier = 'CompTest1410201822h03';
alter session set events '10046 trace name context forever, level 12';
set serveroutput on

DECLARE
  l_blkcnt_cmp    PLS_INTEGER;
  l_blkcnt_uncmp  PLS_INTEGER;
  l_row_cmp       PLS_INTEGER;
  l_row_uncmp     PLS_INTEGER;
  l_cmp_ratio     NUMBER;
  l_comptype_str  VARCHAR2(32767);
BEGIN
  DBMS_COMPRESSION.get_compression_ratio (
    scratchtbsname  => 'USERS',
    ownname         => 'TEST_LAF',
    objname         => 'FOO',
    subobjname      => NULL,
    comptype        => DBMS_COMPRESSION.comp_advanced,
    blkcnt_cmp      => l_blkcnt_cmp,
    blkcnt_uncmp    => l_blkcnt_uncmp,
    row_cmp         => l_row_cmp,
    row_uncmp       => l_row_uncmp,
    cmp_ratio       => l_cmp_ratio,
    comptype_str    => l_comptype_str,
    subset_numrows  => DBMS_COMPRESSION.comp_ratio_allrows,
    objtype         => DBMS_COMPRESSION.objtype_table
  );
 24
  DBMS_OUTPUT.put_line('Number of blocks used (compressed)       : ' ||  l_blkcnt_cmp);
  DBMS_OUTPUT.put_line('Number of blocks used (uncompressed)     : ' ||  l_blkcnt_uncmp);
  DBMS_OUTPUT.put_line('Number of rows in a block (compressed)   : ' ||  l_row_cmp);
  DBMS_OUTPUT.put_line('Number of rows in a block (uncompressed) : ' ||  l_row_uncmp);
  DBMS_OUTPUT.put_line('Compression ratio                        : ' ||  l_cmp_ratio);
  DBMS_OUTPUT.put_line('Compression type                         : ' ||  l_comptype_str);
END;
 32  /
DECLARE
*
ERROR at line 1:
ORA-01013: user requested cancel of current operation

What “CMP*” tables persist after ?

Two “CMP*” tables is always present :

SQL> select count(*) from dba_tables where table_name like 'CMP%';

  COUNT(*)
----------
         2

SQL> select owner,table_name from dba_tables where table_name like 'CMP%';

OWNER     TABLE_NAME
------- ----------
TEST_LAF  CMP3$23687
TEST_LAF  CMP4$23687


Since “CMP3*” and “CMP4*” are copy (compressed for the second one) of source table, space disk can increase dramatically if Compressoin Advisor fails frequently and mainly with huge tables, so it’s important to remove these tables.

The source table called FOO, CMP3$23687 and CMP4$23687 internal tables contains same set of data (less for the last 2 ones since we use the sample block option)…

SQL> select count(*) from test_laf.CMP3$23687;

  COUNT(*)
----------
     22147

SQL> select count(*) from test_laf.CMP4$23687;

  COUNT(*)
----------
     22147

SQL> select count(*) from test_laf.foo;

  COUNT(*)
----------
     22387

The worst is that now we are in presence of compressed table while we don’t have the compression license option :

SQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'CMP4$23687';

COMPRESS COMPRESS_FOR
-------- ------------------------------
ENABLED  ADVANCED

To remove the oracle “CMP*” internal tables tables, let’s analyzing the 10046 trace file to check how oracle remove these tables when the DBMS_COMPRESSION.get_compression_ratio procedure run successfully:

Find below all the steps that oracle does to drop these tables:

drop table "TEST_LAF".CMP1$23687 purge

BEGIN
  BEGIN
    IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    END IF;
  EXCEPTION
    WHEN OTHERS THEN
     null;
  END;
END;

drop table "TEST_LAF".CMP2$23687 purge

PARSING IN CURSOR #140606951937256 len=515 dep=2 uid=0 oct=47 lid=0 tim=3421988631 hv=2219505151 ad='69fd11c8' sqlid='ct6c4h224pxgz'
BEGIN
  BEGIN
    IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    END IF;
  EXCEPTION
    WHEN OTHERS THEN
     null;
  END;
END;


drop table "TEST_LAF".CMP3$23687 purge

BEGIN
  BEGIN
    IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    END IF;
  EXCEPTION
    WHEN OTHERS THEN
     null;
  END;
END;


drop table "TEST_LAF".CMP4$23687 purge
BEGIN
  BEGIN
    IF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_CONTENTS)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    ELSIF (sys.is_vpd_enabled(sys.dictionary_obj_owner, sys.dictionary_obj_name, xdb.DBMS_XDBZ.IS_ENABLED_RESMETADATA)) THEN
      xdb.XDB_PITRIG_PKG.pitrig_dropmetadata(sys.dictionary_obj_owner, sys.dictionary_obj_name);
    END IF;
  EXCEPTION
    WHEN OTHERS THEN
     null;
  END;
END;

To remove “CMP*” tables, Oracle does :
– drop table *** purge
– call internal procedure : xdb.XDB_PITRIG_PKG.pitrig_truncate or xdb.XDB_PITRIG_PKG.pitrig_dropmetadata regarding if Oracle Virtual Private Database is used.

7. Last Test : Check the source table is not compressed, we don’t want to have the compression enabled since we are not licensing…

SQL> select nvl(COMPRESSION,'NO') as COMPRESSION,nvl(COMPRESS_FOR,'NO') as COMPRESS_FOR from dba_tables where table_name = 'FOO';

COMPRESS COMPRESS_FOR
-------- ------------------------------
NO       NO

6.Conclusion

To drop “CMP*” tables used by the DBMS_COMPRESSION.get_compression_ratio procedure, just execute : drop table CMP* purge.

I have not tested more in details the case where compression is used into Oracle VPD, so I don’t know the impact of executing the system procedure : xdb.XDB_PITRIG_PKG.pitrig_truncate or xdb.XDB_PITRIG_PKG.pitrig_dropmetadata in case we use VPD.

 

Cet article Where come from Oracle CMP$ tables and how to delete them ? est apparu en premier sur Blog dbi services.

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

Pages

Subscribe to Oracle FAQ aggregator