Feed aggregator

Al Nahdi Drives Growth and Insight with Oracle Retail Cloud Services

Oracle Press Releases - Wed, 2017-04-19 06:00
Press Release
Al Nahdi Drives Growth and Insight with Oracle Retail Cloud Services From Spreadsheets to Packaged Applications, Saudi Arabian Retailer Drives Increased Productivity

Redwood Shores, Calif.—Apr 19, 2017

Today Oracle announced Saudi Arabian pharmacies’ retailer Nahdi Medical Company deployed Oracle Retail Advanced Science Engine Cloud Service, Oracle Retail Merchandising Solutions, and Oracle Retail Category Management. Nahdi is considered the largest pharmacies’ chain in Middle East and North Africa. Its mission is to exceed the expectations of 85 million guests across 125 cities by providing personalized high-quality health, wellness and beauty products and services through its expertise and extended reach.

Nahdi manages a huge and growing assortment of SKUs across 170 categories throughout its stores. The volume of data forced Nahdi to adopt a scalable and smart planning solution. With the deployment of Oracle Retail, Nahdi gains the ability to segment customers, cluster stores and understand the effects of demand transference without having to recruit a full team of scientists with transaction-level data experience. Powerful scientific insights are delivered in a digestible format for the business user through personal-based dashboards. Prior to selecting Oracle, Nahdi planners spent time navigating a manual process using Excel spreadsheets and in-house databases. Today Nahdi is able to optimize the planning team’s productivity with standardized and automated planning processes. 

“The implementation of Oracle Retail increased the accuracy of planning and forecasting the merchandising figures. We are able to plan and execute better assortment of products across our stores to improve our guests’ satisfaction,” said Dr. Khalid Tadlaoui, Vice President of Information Technology, Nahdi Medical Company.

“The proliferation of data can be overwhelming, and it becomes increasingly important for retailers like Nahdi Medical Company to leverage and invest in solutions that understand how to drive insight through embedded science, business intelligence and analytics into solutions and processes,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “Oracle Retail is incredibly proud to provide this competitive advantage as cloud services, accelerating speed to market and driving productivity.”

Oracle PartnerNetwork Gold Level Partner Logic Information Systems accelerated a smooth cloud implementation and guided the customer through business process change. Logic developed a Retail Data Extractor to extract data correctly and cleanly from the installation of Oracle Retail Merchandising Systems for the cloud implementation. Logic delivered training programs to empower the business and technical teams. 

"It is a privilege to work with a retailer like Nahdi who is using science to leverage the performance and availability of each individual product to satisfy their guests and who also places an importance that their employees have access to critical planning information without wasted time sifting through Excel and manual processes,” said Amber Naqvi, President, Logic Information Systems.

Contact Info
Judi Palmer
Oracle (US)
650-784-7901
judi.palmer@oracle.com
Gaurav Bhatnagar
Oracle (Middle East)
+97143909094
gaurav.b.bhatnagar@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.

About Logic Information Systems

Since 1997, Logic has been the trusted systems integration partner to leading retailers around the world. With an exclusive focus on Oracle Retail, and a team of more than 750 expert consultants who bring a unique balance of real-world retail and IT experience, Logic is equipped to understand and deliver on a retailer’s business and technology goals. Working with Logic, retailers benefit from people, process, and technology solutions that increase efficiency, profitability and deliver a world-class experience for shoppers.

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.

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

Judi Palmer

  • 650-784-7901

Gaurav Bhatnagar

  • +97143909094

Compress Basic Table

Tom Kyte - Tue, 2017-04-18 20:06
Tom, I need help. -If I create a table with COMPRESS BASIC on the partitions and then I insert data from another table does not decrease the size. -Now if I create a table from another with a: CREATE TABLE AS SELECT * FROM TABLE_2 And COMPRESS ...
Categories: DBA Blogs

Swap memory

Tom Kyte - Tue, 2017-04-18 20:06
Hi Team, In which case Oracle uses Swap memory. If we set Memory_target=10G parameter Oracle allocates SGA + PGA which that 10G only. Thanks & Regards Krishna.
Categories: DBA Blogs

Can I optimize the auto extend operation by changing the resizing value?

Tom Kyte - Tue, 2017-04-18 20:06
Hi, I'm using Oracle database 12.1.0.2.0 on Windows 64-bit The alert log is showing many "Resize operation completed for file#..." messages and the "Resource monitor" is showing I/O intensive usage. select * from DBA_DATA_FILES shows that the IN...
Categories: DBA Blogs

How to remove the duplicates records which are in two different columns of a single table.

Tom Kyte - Tue, 2017-04-18 20:06
I have table called "DUPLICTAE" which contains the below records. I need the below desired ouput... <code>COL1 | COL2 :----- | -----: banglore | chennai kolkata | pune chennai | mysore pune | banglore mysore | kolkata mumba...
Categories: DBA Blogs

Loading a file in External Table with a fields more than 4000 characters

Tom Kyte - Tue, 2017-04-18 20:06
Hi Tom, I have a file with the following structure: <code>+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+= 2017-03-01 16:17:08 : INFO : (65193 | WRIT...
Categories: DBA Blogs

Oracle Buys Moat

Oracle Press Releases - Tue, 2017-04-18 16:09
Press Release
Oracle Buys Moat Creates the World’s Most Comprehensive Cloud Platform for Marketing Data and Analytics

Redwood Shores, Calif.—Apr 18, 2017

Oracle today announced that it has signed an agreement to acquire Moat, the fastest-growing digital measurement cloud company. Moat will join Oracle Data Cloud, which uses data and analytics to enhance media for leading marketers and publishers. The combination of Oracle and Moat will connect data to consumer attention for better media experiences and business outcomes.

Moat will remain an independent platform within Oracle Data Cloud, providing trusted measurement, analytics, and intelligence to the world’s largest brands including Nestle, Procter & Gamble, and Unilever, and leading publishers such as ESPN, Facebook, NBCUniversal, Snapchat, and YouTube. Moat’s enterprise client base and industry-leading attention analytics and intelligence suite provide a strong complement to Oracle Data Cloud’s audience targeting and measurement solutions.

“I am thrilled to welcome CEO Jonah Goodhart and the entire Moat team to Oracle Data Cloud,” said Eric Roza, SVP and GM of Oracle Data Cloud. “Moat has grown its attention analytics business by over 100% in the past year, providing actionable insights around viewability, brand safety, non-human traffic, and ad creative to over 600 publisher, brand and agency clients. With the Moat acquisition, Oracle Data Cloud now offers brands and publishers a full suite of targeting and measurement solutions to improve the outcome of virtually every type of digital advertising campaign.”

“It is with great enthusiasm that we join forces with Oracle Data Cloud,” said Jonah Goodhart, CEO and Co-Founder of Moat. “When Oracle approached us about working together, we began to see the huge potential to jointly drive innovation. At our core, we believe there is an opportunity to fundamentally improve marketing and storytelling by brands and publishers through better data and analytics.”

More information about this announcement is available at www.oracle.com/moat.

Oracle is currently reviewing the existing Moat product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of Moat’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by Moat or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and Moat, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of Moat, anticipated customer benefits and general business outlook. When used in this document, the words “anticipates”, “can”, “will”, “look forward to”, “expected” and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or Moat, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or Moat may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or Moat. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor Moat is under any duty to update any of the information in this document.

Contact Info
Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com
Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@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.

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

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

April 2017 Critical Patch Update Released

Oracle Security Team - Tue, 2017-04-18 15:00

Oracle today released the April 2017 Critical Patch Update.

This Critical Patch Update provides fixes for a wide range of product families including: Oracle Database Server, Oracle Enterprise Manager Grid Control, Oracle E-Business Suite, Oracle Industry Applications, Oracle Fusion Middleware, Oracle Sun Products, Oracle Java SE, and Oracle MySQL.

Oracle recommends this Critical Patch Update be applied as soon as possible. A summary and analysis of this Critical Patch Update has been published on My Oracle Support (Doc ID 2252203.1)

For More Information:

The Critical Patch Update Advisory is located at http://www.oracle.com/technetwork/security-advisory/cpuapr2017-3236618.html

My Oracle Support Note 2220314.1 is located at https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=2252203.1 (MOS account required).

How to make dashboard for Informix database

Nilesh Jethwa - Tue, 2017-04-18 14:25

Informix is a secure database, optimized for or OLTP, IoT and is forging new frontiers with its unique ability to seamlessly integrate SQL, NoSQL/JSON, time series and spatial data. Reliability, flexibility, ease of use, and low total cost of ownership makes Informix the best in class enterprise database available in the market.

Instant Visibility. A Informix dashboard visually summarizes all the important metrics you have selected to track, to give you a quick-and- easy overview of where everything stands. With real-time Informix SQL reporting reporting, it's a live view of exactly how your marketing campaign is performing.

  • Better Decision Making
  • Gain Competitive Advantage
  • Enhance Collaboration
  • Spotting potential problems
  • Merge with data from Excel Dashboards
  • Live SQL against database
  • No need for Data-warehouse or ETL
  • Leverage the speed and stability of your powerful database.

Read more at http://www.infocaptor.com/ice-database-connect-dashboard-to-informix-sql

Getting Started with Oracle Developer Samples

Are you just joining Oracle's transformation journey to Cloud? Are you just getting used to working with the technology leader ? Having trouble getting started?  Oracle is developing,...

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

Oracle Warehouse Management Cloud Update Helps Businesses Scale Logistics to Meet Multi-Channel Demand

Oracle Press Releases - Tue, 2017-04-18 07:00
Press Release
Oracle Warehouse Management Cloud Update Helps Businesses Scale Logistics to Meet Multi-Channel Demand Momentum of Cloud WMS Solution Touted in Top Industry Analyst Reports

Redwood Shores, Calif.—Apr 18, 2017

Oracle today announced a new supply chain cloud functionality that helps businesses master challenging warehouse fulfillment issues in order to help outpace their competition. Version 8 of Oracle Warehouse Management Cloud (the former LogFire Warehouse Management System) has the latest functional user experience and integration enhancements that provide a comprehensive view of inventory from supplier to the distribution center (DC) to store shelves.

With Forrester research reporting that the total cloud market value is expected to top $236 billion dollars by 2020, and Transparency Market Research reporting the cloud WMS market is expected to expand from $1.2 billion in 2015 to $4.1 billion by 2024, Oracle is well-positioned to help companies on their journey to adopt SCM cloud solutions.

With Version 8, Oracle continues to lead the industry in modernizing application release cycles by leveraging 100 percent cloud architecture to offer access to frequent solution improvements similar to the easy updates with leading consumer applications.

“LogFire has conclusively proven the viability and compelling value proposition of their cloud-based WMS. The Oracle WMS Cloud is a no-compromise solution built from day one for the cloud. It enables companies to thrive in today’s dynamic, interconnected, omni-channel fulfillment economy,” said Jon Chorley, CSO & group vice president, SCM product strategy at Oracle. “Version 8 continues our dedication to providing customers with the very latest logistics execution capabilities, which now also gives them the ability to leverage other compelling cloud solutions from Oracle.”

Oracle Warehouse Management Cloud recently garnered attention for their offering in two different industry analyst reports. Both reports lauded Oracle’s position and commented on increased cloud WMS adoption across industries. The first is the IDC research on WMS in the Cloud and second is the 2017 Gartner Magic Quadrant for Warehouse Management Systems, which placed Oracle in the Leaders Quadrant.

Chorley continued, “We believe that 2017 is the year cloud computing in Warehouse Management Systems will go mainstream. Our positioning in the Gartner and IDC reports affirms that businesses are comfortable transitioning their fulfillment operations to the cloud. We’re taking every opportunity to introduce the value of the cloud to our customers to help them grow their businesses.”

At Oracle’s recent major supply chain conference—the Modern Supply Chain Experience in San Jose, California – Oracle users saw this technology first hand. Customers packed into sessions in order to learn more about the future of their industry and how the cloud will be transforming everything from sourcing and manufacturing to transportation, warehousing, and even store shelves.

For more information, please see the Gartner Magic Quadrant1 and IDC’s WMS in the Cloud report2.

For additional information on Oracle Supply Chain Management (SCM) Cloud, visit Facebook, Twitter or the Oracle SCM blog.

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

1. Gartner, “2017 Magic Quadrant for Warehouse Management Systems,” by C. Dwight Klappich, Simon Tunstall, February 13, 2017. Oracle has acquired distribution rights for this report, expiration March 2018.
2. IDC, “WMS in the Cloud,” by John Santagate, January 2017. Oracle has acquired distribution rights for this report, expiration March 2018.

Contact Info
Joann Wardrip
Oracle
+1.650.607.1343
joann.wardrip@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.

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

Joann Wardrip

  • +1.650.607.1343

Getting Started with Oracle Developer Samples

Are you just joining Oracle's transformation journey to Cloud? Are you just getting used to working with the technology leader ? Having trouble getting started?  Oracle is developing,...

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

3 Ways to Make Paperwork Less Difficult

WebCenter Team - Tue, 2017-04-18 06:54

Authored by: Sarah Gabot, Partner Marketing Manager, HelloSign

Let’s face it--paperwork, regardless of whether it’s on paper or in the cloud, is no fun. It still takes time and effort to prepare, and if you’re getting it signed, you’re often sitting waiting for the document to return. 

Believe it or not, you can make the paperwork even simpler with the help of an eSignature tool. 

We’ve listed out three ways you can make paperwork less painful. You can immediately begin applying these to the HelloSign for Oracle Content and Experience Cloud integration today. 

Avoid manually reviewing documents with data validation 
Human error happens. People accidentally input the wrong information or have typos when filling out forms. That’s why HelloSign created data validation

Data validation is a feature that prevents users from entering incorrect information. For example, if you require the user to type in his or her social security number, you know that only nine numbers are acceptable. No letters. Exactly nine numbers. 

Using this feature, when the documents return, there will be fewer errors to comb through and less back and forth between you and the signer. 

Increase signer completion rates with mobile-friendly signing
Nearly everybody has a smartphone these days. Being able to handle tasks on-the-go on a smartphone has become a requirement for most people. Signing documents is no exception. 

HelloSign’s signing experience is mobile-friendly. Instead of having to pinch on a small screen, the signer experience is intuitive with responsive pages. There’s also progress tracking that shows how many total (and remaining) required fields are left. 

A more mobile-friendly experience means that your signers are more inclined to complete the document faster. 

Save time by auto-filling documents. 
For certain documents, there are fields that you, the document preparer, can pre-fill. For example, if you have a templated document like an offer letter, you can pre-fill fields in the document (eg. job title, salary number) in HelloSign for Oracle CEC. 

It’s a quick way for you to prepare standardized documents without having to recreate it every time. 

Try it out yourself! 
See for yourself how you can simplify paperwork flows using Oracle Content and Experience Cloud and HelloSign. To learn how to get started, email our sales team at oracle-sales@hellosign.com or speak to your Oracle Account rep.

3 Ways to Make Paperwork Less Difficult

WebCenter Team - Tue, 2017-04-18 06:54

Authored by: Sarah Gabot, Partner Marketing Manager, HelloSign

Let’s face it--paperwork, regardless of whether it’s on paper or in the cloud, is no fun. It still takes time and effort to prepare, and if you’re getting it signed, you’re often sitting waiting for the document to return. 

Believe it or not, you can make the paperwork even simpler with the help of an eSignature tool. 

We’ve listed out three ways you can make paperwork less painful. You can immediately begin applying these to the HelloSign for Oracle Content and Experience Cloud integration today. 

Avoid manually reviewing documents with data validation 
Human error happens. People accidentally input the wrong information or have typos when filling out forms. That’s why HelloSign created data validation

Data validation is a feature that prevents users from entering incorrect information. For example, if you require the user to type in his or her social security number, you know that only nine numbers are acceptable. No letters. Exactly nine numbers. 

Using this feature, when the documents return, there will be fewer errors to comb through and less back and forth between you and the signer. 

Increase signer completion rates with mobile-friendly signing
Nearly everybody has a smartphone these days. Being able to handle tasks on-the-go on a smartphone has become a requirement for most people. Signing documents is no exception. 

HelloSign’s signing experience is mobile-friendly. Instead of having to pinch on a small screen, the signer experience is intuitive with responsive pages. There’s also progress tracking that shows how many total (and remaining) required fields are left. 

A more mobile-friendly experience means that your signers are more inclined to complete the document faster. 

Save time by auto-filling documents. 
For certain documents, there are fields that you, the document preparer, can pre-fill. For example, if you have a templated document like an offer letter, you can pre-fill fields in the document (eg. job title, salary number) in HelloSign for Oracle CEC. 

It’s a quick way for you to prepare standardized documents without having to recreate it every time. 

Try it out yourself! 
See for yourself how you can simplify paperwork flows using Oracle Content and Experience Cloud and HelloSign. To learn how to get started, email our sales team at oracle-sales@hellosign.com or speak to your Oracle Account rep.

OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2

Yann Neuhaus - Tue, 2017-04-18 06:20

Another GoldenGate 12.2 one: Some days ago I had this in the GoldenGate error log:

2017-04-12 14:56:08  WARNING OGG-02901  Oracle GoldenGate Capture for Oracle, extimch.prm:  Replication of UDT and ANYDATA from redo logs is not supported with the Oracle compatible parameter setting. Using fetch instead.
2017-04-12 14:56:08  ERROR   OGG-02912  Oracle GoldenGate Capture for Oracle, extimch.prm:  Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 or later.

Seemed pretty obvious that I was missing a patch.

Headed over to mos and searched for the patch mentioned:

ogg_17030189

Hm, only two hits and I was neither on Exadata nor on the 12.1.0.1 database release. After digging around a bit more in various mos notes there was one (Doc ID 2091679.1) which finally mentioned a workaround. When you install GoldenGate 12.2 you get a script by default in the GoldenGate Home which is called “prvtlmpg.plb”. Looking at the script:

oracle@xxxxx:/u01/app/ogg/ch_src/product/12.2.0.1.160823/ [xxxxx] ls prvtlmpg.plb
prvtlmpg.plb
oracle@xxxxx:/u01/app/ogg/ch_src/product/12.2.0.1.160823/ [xxxxx] strings prvtlmpg.plb
WHENEVER SQLERROR EXIT
set verify off 
set feedback off
set echo off
set serveroutput on
column quotedMiningUser new_value quotedMiningUser noprint
column quotedCurrentSchema new_value quotedCurrentSchema noprint
variable status number
prompt
prompt Oracle GoldenGate Workaround prvtlmpg
prompt
prompt This script provides a temporary workaround for bug 17030189.
prompt It is strongly recommended that you apply the official Oracle 
prompt Patch for bug 17030189 from My Oracle Support instead of using
prompt this workaround.
prompt
prompt This script must be executed in the mining database of Integrated
prompt Capture. You will be prompted for the username of the mining user.
prompt Use a double quoted identifier if the username is case sensitive
prompt or contains special characters. In a CDB environment, this script
prompt must be executed from the CDB$ROOT container and the mining user
prompt must be a common user.
prompt
prompt ===========================  WARNING  ==========================
prompt You MUST stop all Integrated Captures that belong to this mining
prompt user before proceeding!
prompt ================================================================

Really? You get a script to workaround a known issue by default? Lets try:

SQL> @prvtlmpg.plb

Oracle GoldenGate Workaround prvtlmpg

This script provides a temporary workaround for bug 17030189.
It is strongly recommended that you apply the official Oracle
Patch for bug 17030189 from My Oracle Support instead of using
this workaround.

This script must be executed in the mining database of Integrated
Capture. You will be prompted for the username of the mining user.
Use a double quoted identifier if the username is case sensitive
or contains special characters. In a CDB environment, this script
must be executed from the CDB$ROOT container and the mining user
must be a common user.

===========================  WARNING  ==========================
You MUST stop all Integrated Captures that belong to this mining
user before proceeding!
================================================================

Enter Integrated Capture mining user: GGADMIN

Installing workaround...                                                                                         
No errors.                                                                                                       
No errors.
No errors.                                                                                                       
Installation completed.                                                                                          
SQL>                                                                                                             

And finally the extract started fine. Interesting … There seems to be a patch for 11.2.0.4.7DBPSU in development but nothing else for the moment. Even the latest PSU for 11.2.0.4 seems not to include the patch.

 

Cet article OGG: Patch 17030189 is required on your Oracle mining database for trail format RELEASE 12.2 est apparu en premier sur Blog dbi services.

Oracle Audit Trail Add Program Name

The program name attribute (V$SESSION.PROGRAM) is not by default passed to Oracle’s audit logs. It can be optionally included. To do so, apply Patch 7023214 on the source database. After the patch is applied, the following event needs to be set:

ALTER SYSTEM SET
           EVENT='28058 trace name context forever'
           COMMENT='enable program logging in audit trail' SCOPE=SPFILE;

The table below summarizes key session attributres (V$SESSION) the are passed/not passed to Oracle auditing

Oracle Audit Trails

Session Attribute

(V$SESSION)

Description

Traditional Auditing (SYS.AUD$)

Fine Grained Auditing (SYS.FGA_LOG$)

CLIENT_IDENTIFIER

End user username

CLIENTID

CLIENTID

CLIENT_INFO

Concatenated application log string

Not passed

Not passed

MODULE

ABAP program, module, application component or service

Not passed

Not passed

ACTION

Business action being executed, page, code event, location within program

Not passed

Not passed

 

If you have questions, please contact us at info@integrigy.com

-Michael Miller, CISSP-ISSMP

Reference
 
 
 
Auditing, Oracle Database, Oracle Audit Vault
Categories: APPS Blogs, Security Blogs

Down the performance of single table using Various DML Operation.

Tom Kyte - Tue, 2017-04-18 01:46
Suppose I have a table that's called account_detail of customer account detail. And This table contain 100,000,000 Rows. suppose we fire select query on this table and at a same time may or may not be insert or update or delete record fire by staff...
Categories: DBA Blogs

PL SQL Bulk Insertion with a Mapping

Tom Kyte - Tue, 2017-04-18 01:46
I have a table Trans containing around 10 billion records an having index on a column "customer_id". Table Structure : FCT_Trans customer_id varchar2(20), trans_date date, trans_type varchar2(10), Cust_name varchar2(100), ect I have another ...
Categories: DBA Blogs

Trigger

Tom Kyte - Tue, 2017-04-18 01:46
Hi Team, I have to create a trigger which will record the old value as well as new value in case of insert. Situation is that I have one application and on frontend part whenever some changes happened then the xyz_id got changed. At the backend, ...
Categories: DBA Blogs

Migrating huge tables with blobs

Tom Kyte - Tue, 2017-04-18 01:46
Hello Tom, we migrate from informix to oracle and we have this problem : we have to unload tables with millions records, each record has blob, blobs are unloaded in some blob files with size near 2 GB. 170 thousand blobs are in one blob fil...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator