Feed aggregator

Who Will Win the Database Wars? Public Cloud DBMS Services- Amazon Vs Oracle and Microsoft

Chris Foot - Thu, 2016-12-15 07:33

This is the second installment in the Who Will Win the Database Wars series which analyzes the most significant areas of database vendor competition. In addition to this comparison, the series also includes the following competitive assessments:

Who Will Win the Database Wars? The Traditional “Big Three”: Oracle, Microsoft and IBM vs Everybody Else

Chris Foot - Thu, 2016-12-15 07:32

This is the third installment in the Who Will Win the Database Wars series which analyzes the most significant areas of database vendor competition. In addition to this comparison, the series also includes the following competitive assessments:

Who Will Win the Database Wars? Relational vs NoSQL Database Models

Chris Foot - Thu, 2016-12-15 07:31

This is the fourth installment in the Who Will Win the Database Wars series which analyzes the most significant areas of database vendor competition. In addition to this comparison, the series also includes the following competitive assessments:

Who Will Win the Database Wars? Open Source Vs Commercial Database Systems

Chris Foot - Thu, 2016-12-15 07:30

This is the final installment in the Who Will Win the Database Wars series which analyzes the most significant areas of database vendor competition. In addition to this comparison, the series also includes the following competitive assessments:

Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups

Yann Neuhaus - Thu, 2016-12-15 06:01

Temporary Tablespaces Groups exist for quite a while now (since 10gR2), but they are, for whatever reason not so often used. Personally, I think they are quite cool. Very easy to setup, and especially in big environments with a lot of parallel processing very useful. But this blog will not be about Temporary Tablespace Groups. They are already explained in the 12.2 Admin Guide.

https://docs.oracle.com/database/122/ADMIN/managing-tablespaces.htm#ADMIN-GUID-55A6AE10-6875-4B73-9A5C-CB4965AD5AFE

For my Active DataGuard environment, I would like to use Temporary Tablespace Groups in combination with Temporary Undo, which is enabled by default as soon as you activate the ADG feature. And of course, I would like to do it online, without shutting down neither the primary nor the ADG standby.

Is this possible? We will see. I start first with creating a Temporary Tablespace Group called DBITEMP
with 3 bigfile temp tablespaces DBITEMP1/DBITEMP2/DBITEMP3.

-- On Primary

SQL> CREATE BIGFILE TEMPORARY TABLESPACE DBITEMP1 TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T TABLESPACE GROUP DBITEMP;

Tablespace created.

SQL> CREATE BIGFILE TEMPORARY TABLESPACE DBITEMP2 TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T TABLESPACE GROUP DBITEMP;

Tablespace created.

SQL> CREATE BIGFILE TEMPORARY TABLESPACE DBITEMP3 TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T TABLESPACE GROUP DBITEMP;

Tablespace created.

SQL> ALTER DATABASE DEFAULT TEMPORARY TABLESPACE DBITEMP;

Database altered.

SQL> alter system archive log current;

System altered.

SQL> select TABLESPACE_NAME, CONTENTS, BIGFILE from dba_tablespaces where CONTENTS = 'TEMPORARY' and TABLESPACE_NAME like '%DBI%';

TABLESPACE_NAME                CONTENTS              BIG
------------------------------ --------------------- ---
DBITEMP1                       TEMPORARY             YES
DBITEMP2                       TEMPORARY             YES
DBITEMP3                       TEMPORARY             YES

SQL> select * from DBA_TABLESPACE_GROUPS;

GROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
DBITEMP                        DBITEMP1
DBITEMP                        DBITEMP2
DBITEMP                        DBITEMP3

SQL> select NAME, BYTES from v$tempfile where name like '%dbitemp%';

NAME                                                                         BYTES
-------------------------------------------------------------------- -------------
/u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp1_d52c66g5_.tmp          33554432
/u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp2_d52c6yqv_.tmp          33554432
/u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp3_d52c7954_.tmp          33554432

SQL> !ls -l /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp1_d52c66g5_.tmp
-rw-r----- 1 oracle oinstall 33562624 Dec 14 12:28 /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp1_d52c66g5_.tmp

SQL> !ls -l /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp2_d52c6yqv_.tmp
-rw-r----- 1 oracle oinstall 33562624 Dec 14 12:29 /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp2_d52c6yqv_.tmp

SQL> !ls -l /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp3_d52c7954_.tmp
-rw-r----- 1 oracle oinstall 33562624 Dec 14 12:28 /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp3_d52c7954_.tmp

SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE FROM database_properties
  2  WHERE property_name='DEFAULT_TEMP_TABLESPACE';

PROPERTY_NAME            PROPERTY_VALUE
------------------------ ----------------------
DEFAULT_TEMP_TABLESPACE  DBITEMP


DGMGRL> show database 'DBIT122_SITE1';

Database - DBIT122_SITE1

  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    DBIT122

Database Status:
SUCCESS

DGMGRL> show database 'DBIT122_SITE2';

Database - DBIT122_SITE2

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 0 Byte/s
  Real Time Query:    ON
  Instance(s):
    DBIT122

Database Status:
SUCCESS

On the primary database, it looks good. Everything was setup correctly, and the Temporary Tablespace Group is ready to be used. Now lets check what we have on the Standby … almost nothing.

My temporary tablespaces and the group are there, however, the tempfiles are missing. So … not really useful at that stage.

SQL> select TABLESPACE_NAME, CONTENTS, BIGFILE from dba_tablespaces where CONTENTS = 'TEMPORARY' and TABLESPACE_NAME like '%DBI%';

TABLESPACE_NAME                CONTENTS              BIG
------------------------------ --------------------- ---
DBITEMP1                       TEMPORARY             YES
DBITEMP2                       TEMPORARY             YES
DBITEMP3                       TEMPORARY             YES

SQL> select * from DBA_TABLESPACE_GROUPS;

GROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
DBITEMP                        DBITEMP1
DBITEMP                        DBITEMP2
DBITEMP                        DBITEMP3


SQL> SELECT PROPERTY_NAME, PROPERTY_VALUE FROM database_properties
  2  WHERE property_name='DEFAULT_TEMP_TABLESPACE';

PROPERTY_NAME            PROPERTY_VALUE
------------------------ ----------------------
DEFAULT_TEMP_TABLESPACE  DBITEMP

SQL> select NAME, BYTES from v$tempfile where name like '%dbitemp%';

no rows selected

Ok. Lets take a look at the alert.log, if Oracle is telling something. And yes, indeed, a big WARNING message is posted into the alert.log saying that the temporary tablespaces DBITEMP1/2/3 are empty.

*********************************************************************
WARNING: The following temporary tablespaces contain no files.
         This condition can occur when a backup controlfile has
         been restored.  It may be necessary to add files to these
         tablespaces.  That can be done using the SQL statement:

         ALTER TABLESPACE <tablespace_name> ADD TEMPFILE

         Alternatively, if these temporary tablespaces are no longer
         needed, then they can be dropped.
           Empty temporary tablespace: DBITEMP1
           Empty temporary tablespace: DBITEMP2
           Empty temporary tablespace: DBITEMP3
*********************************************************************

Ok. With 12.2 it is like it always was. You have to do it manually.

SQL> ALTER TABLESPACE DBITEMP1 ADD TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T;

Tablespace altered.

SQL> ALTER TABLESPACE DBITEMP2 ADD TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T;

Tablespace altered.

SQL> ALTER TABLESPACE DBITEMP3 ADD TEMPFILE SIZE 32M AUTOEXTEND ON MAXSIZE 12T;

Tablespace altered.

Now I have everthing in place. What about dropping a temporary tablespace out of the tablespace group First, I take it out of temporary tablespace group. This change is immediately reflected on the Standby.

-- Primary

SQL> alter tablespace DBITEMP3 TABLESPACE GROUP '';

Tablespace altered.

SQL> select * from DBA_TABLESPACE_GROUPS;

GROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
DBITEMP                        DBITEMP1
DBITEMP                        DBITEMP2

-- Standby 

SQL> select * from DBA_TABLESPACE_GROUPS;

GROUP_NAME                     TABLESPACE_NAME
------------------------------ ------------------------------
DBITEMP                        DBITEMP1
DBITEMP                        DBITEMP2

And now you can drop it.

-- Primary

SQL> drop tablespace DBITEMP3 including contents and datafiles;

Tablespace dropped.

alert.log
...
drop tablespace DBITEMP3 including contents and datafiles
2016-12-14T16:35:25.567597+01:00
Deleted Oracle managed file /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp3_d52c7954_.tmp
Completed: drop tablespace DBITEMP3 including contents and datafiles
...

-- Standby

alert.log
...
Deleted Oracle managed file /u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp3_d52dv3dv_.tmp
Recovery deleting tempfile #4:'/u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp3_d52dv3dv_.tmp'
Recovery dropped temporary tablespace 'DBITEMP3'
...

ok. Dropping works fine. This change is also immediately reflected. What about resizing a temporary file? Is this change also immediately reflected on the standby? Due to OMF, we do have different names for the tempfiles, so should we use a “alter database tempfile <NAME> resize” or a “alter database tempfile <NUMBER> resize” to make it work. In regards of regular datafiles, it doesn’t matter, you can use both ways and Oracle does it correctly.

- Primary

SQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';

     FILE# NAME                                                                      BYTES
---------- -------------------------------------------------------------------- ----------
         2 /u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp1_d52dthwg_.tmp       33554432
         3 /u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp2_d52dtx7f_.tmp       33554432

		 
SQL> alter database tempfile '/u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp1_d52c66g5_.tmp' resize 512M;

Database altered.

SQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';

     FILE# NAME                                                                      BYTES
---------- -------------------------------------------------------------------- ----------
         2 /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp1_d52c66g5_.tmp      536870912
         3 /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp2_d52c6yqv_.tmp       33554432


-- Standby

SQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';

     FILE# NAME                                                                      BYTES
---------- -------------------------------------------------------------------- ----------
         2 /u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp1_d52dthwg_.tmp       33554432
         3 /u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp2_d52dtx7f_.tmp       33554432

Ok. Resizing by name is not reflected on the standby. But what about resizing the tempfile by using the file number instead of the name?

-- Primary
 
SQL> alter database tempfile 3 resize 768M;

Database altered.

SQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';

     FILE# NAME                                                                      BYTES
---------- -------------------------------------------------------------------- ----------
         2 /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp1_d52c66g5_.tmp      536870912
         3 /u02/oradata/DBIT122_SITE1/datafile/o1_mf_dbitemp2_d52c6yqv_.tmp      805306368

		 
-- Standby

SQL> select file#, name, bytes from v$tempfile where name like '%dbitemp%';

     FILE# NAME                                                                      BYTES
---------- -------------------------------------------------------------------- ----------
         2 /u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp1_d52dthwg_.tmp       33554432
         3 /u02/oradata/DBIT122_SITE2/datafile/o1_mf_dbitemp2_d52dtx7f_.tmp       33554432

As you can see, I doesn’t matter. Resize operations on tempfiles are not replicated to the standby.

Conclusion

Temporary Tablespace Groups can be used with Active DataGuard, and of course, it can be done online. However, when you initially create them, or when you resized them, some manual work has to be done on the standby. And yes, the Temporary Tablespace Groups can be used in combination with the Temporary UNDO feature on the Active DataGuard Standby.

 

 

Cet article Oracle 12cR2 – Howto setup Active DataGuard with Temporary Tablespace Groups est apparu en premier sur Blog dbi services.

Oracle LNNVL Function with Examples

Complete IT Professional - Thu, 2016-12-15 05:00
In this article, I’ll explain what the Oracle LNNVL function does and show you some examples. Purpose of the Oracle LNNVL Function The purpose of the LNNVL is to perform a “logical not null” on the expression that has been provided. It allows you to evaluate data that contains a NULL value, which is something […]
Categories: Development

ETL Offload with Spark and Amazon EMR - Part 1

Rittman Mead Consulting - Thu, 2016-12-15 03:00

We recently undertook a two-week Proof of Concept exercise for a client, evaluating whether their existing ETL processing could be done faster and more cheaply using Spark. They were also interested in whether something like Redshift would provide a suitable data warehouse platform for them. In this series of blog articles I will look at how we did this, and what we found.

Background

The client has an existing analytics architecture based primarily around Oracle database, Oracle Data Integrator (ODI), Oracle GoldenGate, and Oracle Business Intelligence Enterprise Edition (OBIEE), all running on Amazon EC2. The larger architecture in the organisation is all AWS based too.

Existing ETL processing for the system in question is done using ODI, loading data daily into a partitioned Oracle table, with OBIEE providing the reporting interface.

There were two aspects to the investigation that we did:

  • Primarily, what would an alternative platform for the ETL look like? With lots of coverage recently of the concept of "ETL offloading" and "Apache-based ETL", the client was keen to understand how they might take advantage of this

    Within this, key considerations were:

    • Cost
    • Scalability
    • Maintenance
    • Fit with existing and future architectures
  • The second aspect was to investigate whether the performance of the existing reporting could be improved. Despite having data for multiple years in Oracle, queries were too slow to provide information other than within a period of a few days.

Oracle licenses were a sensitive point for the client, who were keen to reduce - or at least, avoid increased - costs. ODI for Big Data requires additional licence, and so was not in scope for the initial investigation.

Data and Processing

The client uses their data to report on the level of requests for different products, including questions such as:

  • How many requests were there per day?
  • How many requests per product type in a given period?
  • For a given product, how many requests were there, from which country?

Data volumes were approximately 50MB, arriving in batch files every hour. Reporting requirements were previous day and before only. Being able to see data intra-day would be a bonus but was not a requirement.

High Level Approach

Since the client already uses Amazon Web Services (AWS) for all its infrastructure, it made sense to remain in the AWS realm for the first round of investigation. We broke the overall requirement down into pieces, so as to understand (a) the most appropriate tool at each point and (b) the toolset with best overall fit. A very useful reference for an Amazon-based big data design is the presentation Big Data Architectural Patterns and Best Practices on AWS. Even if you're not running on AWS, the presentation has some useful pointers for things like where to be storing your data based on volumes, frequency of access, etc.

Data Ingest

The starting point for the data was Amazon's storage service - S3, in which the data files in CSV format are landed by an external process every hour.

Processing (Compute)

Currently the processing is done by loading the external data into a partitioned Oracle table, and resolving dimension joins and de-duplication at query time.

Taking away any assumptions, other than a focus on 'new' technologies (and a bias towards AWS where appropriate), we considered:

  • Switch out Oracle for Redshift, and resolve the joins and de-duplication there
    • Loading the data to Redshift would be easy, but would be switching one RDBMS-based solution for another. Part of the aim of the exercise was to review a broader solution landscape than this.
  • Use Hadoop-based processing, running on Elastic Map Reduce (EMR):

    • Hive QL to process the data on S3 (or HDFS on EMR)
      • Not investigated, because provides none of the error handling etc that Spark would, and Spark has SparkSQL for any work that needs doing in SQL.
    • Pig
      • Still used, but 'old' technology, somewhat esoteric language, and superseded by Spark
    • Spark
      • Support for several languages including commonly-used ones such as Python
      • Gaining increasing levels of adoption in the industry
      • Opens up rich eco-system of processing possibilities with related projects such as Machine Learning, and Graph.

We opted to use Spark to process the files, joining them to the reference data, and carrying out de-duplication. For a great background and discussion on Spark and its current place in data architectures, have a listen to this podcast.

Storage

The output from Spark was written back to S3.

Analytics

With the processed data in S3, we evaluated two options here:

  • Load it to Redshift for query
  • Query in-place with a SQL-on-Hadoop engine such as Presto or Impala
    • With the data at rest on S3, Amazon's Athena is also of interest here, but was released after we carried out this particular investigation.

The presumption was that OBIEE would continue to provide the front-end to the analytics. Oracle's Data Visualization Desktop tool was also of interest.

In the next post we'll see the development environment that we used for prototyping. Stay tuned!

Categories: BI & Warehousing

Oracle Technology Patch Versioning Changed

Steven Chan - Thu, 2016-12-15 02:06

Version numbering for Oracle Database, Enterprise Manager, and Fusion Middleware products began to change after November 2015. The new version format makes it easier to see which bundle patches are from which time-frame, and in particular which patches are from the same Critical Patch Update release. 

This change is documented here:

Some bundles may continue to use a numeric 5th digit in the short term, but will transition to the new format over time.

What changed?

The new format replaces the numeric fifth digit of the bundle version with a release date in the form  "YYMMDD" where:

  • YY is the last 2 digits of the year
  • MM is the numeric month (2 digits)
  • DD is the numeric day of the month (2 digits)

The "release date" is the release date of the main bundle / PSU / SPU. In some rare cases, for example where the same bundle is released on multiple platforms, the patch for a specific platform may not be available until some days after the "release date".

Related Articles

Categories: APPS Blogs

Whitepaper List as at December 2016

Anthony Shorten - Wed, 2016-12-14 17:25

The following Oracle Utilities Application Framework technicalwhitepapers are available from MyOracle Support at the Doc Id's mentioned below. Some have beenupdated in the last few months to reflect new advice and new features.

Refer to Whitepaper Strategy Now and In the Future for direction of the documentation.

Note: If a link on this page does not work, this means the whitepaper may have been retired. In that case refer to the online documentation provided with your product for more information.

Unless otherwise marked the technical whitepapers in the table beloware applicable for the following products (with versions):

Doc Id DocumentTitle Contents ConfigLabDesign Guidelines This whitepaper outlines how to design and implement a datamanagement solution using the ConfigLab facility.
This whitepaper currently only applies to the following products:
TechnicalBest Practices for Oracle Utilities Application Framework Based Products Whitepaper summarizing common technical best practices usedby partners, implementation teams and customers. PerformanceTroubleshooting Guideline Series A set of whitepapers on tracking performance at each tier inthe framework. The individual whitepapers are as follows:
  • Concepts - General Conceptsand Performance Troublehooting processes
  • Client Troubleshooting -General troubleshooting of the browser client with common issues andresolutions.
  • Network Troubleshooting -General troubleshooting of the network with common issues andresolutions.
  • Web Application Server Troubleshooting- General troubleshooting of the Web Application Server with commonissues and resolutions.
  • Server Troubleshooting -General troubleshooting of the Operating system with common issues andresolutions.
  • Database Troubleshooting -General troubleshooting of the database with common issues andresolutions.
  • Batch Troubleshooting -General troubleshooting of the background processing component of theproduct with common issues and resolutions.
SoftwareConfiguration Management Series
A set of whitepapers on how to manage customization (code anddata)using the tools provided with the framework. Topics include RevisionControl, SDK Migration/Utilities, Bundling and Configuration MigrationAssistant. The individual whitepapers are as follows:
  • Concepts - General conceptsand introduction.
  • Environment Management -Principles and techniques for creating and managing environments.
  • Version Management -Integration of Version control and version management of configurationitems.
  • Release Management -Packaging configuration items into a release.
  • Distribution - Distributionand installation of releases across environments
  • Change Management - Genericchange management processes for product implementations.
  • Status Accounting - Statusreporting techniques using product facilities.
  • Defect Management - Genericdefect management processes for product implementations.
  • Implementing Single Fixes -Discussion on the single fix architecture and how to use it in animplementation.
  • Implementing Service Packs -Discussion on the service packs and how to use them in animplementation.
  • Implementing Upgrades -Discussion on the the upgrade process and common techniques forminimizing the impact of upgrades.
OracleUtilities Application Framework Security Overview A whitepaper summarizing the security facilities in theframework. Now includes references to other Oracle security productssupported. LDAPIntegration for Oracle Utilities Application Framework based products A generic whitepaper summarizing how to integrate an externalLDAP based security repository with the framework. OracleUtilities Application Framework Integration Overview A whitepaper summarizing all the various common integrationtechniques used with the product (with case studies). SingleSign On Integration for Oracle Utilities Application Framework basedproducts A whitepaper outlining a generic process for integrating anSSO product with the framework. OracleUtilities Application Framework Architecture Guidelines This whitepaper outlines the different variations ofarchitecture that can be considered. Each variation will include adviceon configuration and other considerations. BatchBest Practices This whitepaper outlines the common and best practicesimplemented by sites all over the world. TechnicalBest Practices V1 Addendum Addendum to Technical Best Practices for OracleUtilities Customer Care And Billing V1.x only. XAIBest Practices This whitepaper outlines the common integration tasks andbest practices for the Web Services Integration provided by the OracleUtilities Application Framework. OracleIdentity Manager Integration Overview This whitepaper outlines the principals of the prebuiltintergration between Oracle Utilities Application Framework BasedProducts and OracleIdentity Manager used to provision user and user group securityinformation. For Fw4.x customers use whitepaper 1375600.1instead. ProductionEnvironment Configuration Guidelines A whitepaper outlining common production level settings forthe products based upon benchmarks and customer feedback. 1177265.1 What'sNew In Oracle Utilities Application Framework V4?  Whitepaper outlining the major changes to the framework sinceOracle Utilities Application Framework V2.2. 1290700.1 DatabaseVault Integration Whitepaper outlining the DatabaseVault Integration solution provided with Oracle UtilitiesApplication Framework V4.1.0 and above. 1299732.1 BIPublisher Guidelines for Oracle Utilities Application Framework Whitepaper outlining the interface between BIPublisher and the Oracle Utilities Application Framework 1308161.1 OracleSOA Suite Integration with Oracle Utilities Application Framework basedproducts This whitepaper outlines common design patterns andguidelines for using OracleSOA Suite with Oracle Utilities Application Framework basedproducts. 1308165.1 MPLBest Practices
This is a guidelines whitepaper for products shipping withthe Multi-Purpose Listener.
This whitepaper currently only applies to the following products:
1308181.1 OracleWebLogic JMS Integration with the Oracle Utilities Application Framework This whitepaper covers the native integration between OracleWebLogic JMS with Oracle Utilities Application Framework using thenew Message Driven Bean functionality and real time JMS adapters. 1334558.1 OracleWebLogic Clustering for Oracle Utilities Application Framework This whitepaper covers process for implementing clusteringusing OracleWebLogic for Oracle Utilities Application Framework based products. 1359369.1 IBMWebSphere Clustering for Oracle Utilities Application Framework This whitepaper covers process for implementing clusteringusing IBM WebSphere for Oracle Utilities Application Framework basedproducts 1375600.1 OracleIdentity Management Suite Integration with the Oracle UtilitiesApplication Framework This whitepaper covers the integration between OracleUtilities Application Framework and OracleIdentity Management Suite components such as OracleIdentity Manager, OracleAccess Manager, OracleAdaptive Access Manager, OracleInternet Directory and OracleVirtual Directory. 1375615.1 AdvancedSecurity for the Oracle Utilities Application Framework This whitepaper covers common security requirements and howto meet those requirements using Oracle Utilities Application Frameworknative security facilities, security provided with the J2EE WebApplication and/or facilities available in OracleIdentity Management Suite. 1486886.1 ImplementingOracle Exadata with Oracle Utilities Customer Care and Billing This whitepaper covers some advice when implementing OracleExaData for OracleUtilities Customer Care And Billing. 878212.1 OracleUtilities Application FW Available Service Packs This entry outlines ALL the service packs available for theOracle Utilities Application Framework. 1454143.1 CertificationMatrix for Oracle Utilities Products This entry outlines the software certifications for all theOracle Utilities products. 1474435.1 OracleApplication Management Pack for Oracle Utilities Overview This whitepaper covers the Oracle Application Management Packfor Oracle Utilities. This is a pack for OracleEnterprise Manager. 1506855.1 IntegrationReference Solutions
This whitepaper covers the various Oracle technologies youcan use with the Oracle Utilities Application Framework. 1544969.1 NativeInstallation Oracle Utilities Application Framework Thiswhitepaper describes the process of installing Oracle UtilitiesApplication Framework based products natively within OracleWebLogic. 1558279.1 OracleService Bus Integration  Thiswhitepaper describes direct integration with OracleService Busincluding the new OracleService Bus protocol adapters available.Customers using the MPL should read this whitepaper as the OracleService Bus replaces MPL in the future and this whitepaper outlineshowto manually migrate your MPL configuration into OracleService Bus.

Note: In Oracle Utilities Application Framework V4.2.0.1.0 and above,Oracle Service Bus Adapters for Outbound Messages andNotification/Workflow are available 1561930.1 UsingOracle Text for Fuzzy Searching This whitepaper describes how to use the Name Matchingand  fuzzy operator facilities in OracleText to implemement fuzzy searching using the @fuzzy helperfucntion available in Oracle Utilities Application FrameworkV4.2.0.0.0 1606764.1
AuditVault Integration This whitepaper describes theintegration with OracleAudit Vaultto centralize and separate Audit information from OUAF products. AuditVault integration is available in OUAF 4.2.0.1.0 and above only.
1644914.1
MigratingXAI to IWS
Migration from XML ApplicationIntegration to the new native Inbound Web Services in Oracle UtilitiesApplication Framework 4.2.0.2.0 and above.
1643845.1
PrivateCloud Planning Guide
Planning Guide for implementingOracle Utilities products on Private Clouds using Oracle's CloudFoundation set of products.
1682436.1
ILMPlanning Guide
Planning Guide for OracleUtilities new ILM based data management and archiving solution.
207303.1
Client / Server Interoperability Support Matrix
Certification Matrix.
1965395.1
Cache Nodes Configuration using BatchEdit utility
Using the new Batch Edit Wizard to configure batch quickly and easily
1628358.1
Overview and Guidelines for Managing Business Exceptions and Errors
Best Practices for To Do Management
2014163.1
Oracle Functional/Load Testing Advanced Pack for Oracle Utilities Overview
Overview of the new Oracle Utilities testing solution. Updated for 5.0.0.1.0.
1929040.1
ConfigTools Best Practices
Best Practices for using the configuration tools facility
2014161.1
Oracle Utilities Application Framework - Keystore Configuration
Managing the keystore
2014163.1
Oracle Functional/Load Testing Advanced Pack for Oracle Utilities Overview
Outlines the Oracle Application Testing Suite based testing solution for Functional and Load Testing available for Oracle Utilities Application Framework based products
2132081.1
Migrating From On Premise To Oracle Platform As A Service
Outlines the process of moving an Oracle Utilities product from on-premise to Oracle Cloud Platform As A Service (PaaS)
2196486.1
Batch Scheduler Integration
Outlines the Oracle Utilities Application Framework based integration with Oracle’s DBMS_SCHDEULER to build, manage and execute complex batch schedules
2211363.1
Enterprise Manager for Oracle Utilities: Service Pack Compliance
Outlines the process of converting service packs to allow the Application Management Pack for Oracle Utilities to install service packs using the patch management capabilities
2214375.1
Web Services Best Practices
Outlines the best practices of the web services capabilities available for integration

Whitepaper List as at December 2016

Anthony Shorten - Wed, 2016-12-14 17:25

The following Oracle Utilities Application Framework technical whitepapers are available from My Oracle Support at the Doc Id's mentioned below. Some have been updated in the last few months to reflect new advice and new features.

Refer to Whitepaper Strategy Now and In the Future for direction of the documentation.

Note: If a link on this page does not work, this means the whitepaper may have been retired. In that case refer to the online documentation provided with your product for more information.

Unless otherwise marked the technical whitepapers in the table below are applicable for the following products (with versions):

Doc Id Document Title Contents ConfigLab Design Guidelines This whitepaper outlines how to design and implement a data management solution using the ConfigLab facility.
This whitepaper currently only applies to the following products:
Technical Best Practices for Oracle Utilities Application Framework Based Products Whitepaper summarizing common technical best practices used by partners, implementation teams and customers. Performance Troubleshooting Guideline Series A set of whitepapers on tracking performance at each tier in the framework. The individual whitepapers are as follows:
  • Concepts - General Concepts and Performance Troublehooting processes
  • Client Troubleshooting - General troubleshooting of the browser client with common issues and resolutions.
  • Network Troubleshooting - General troubleshooting of the network with common issues and resolutions.
  • Web Application Server Troubleshooting - General troubleshooting of the Web Application Server with common issues and resolutions.
  • Server Troubleshooting - General troubleshooting of the Operating system with common issues and resolutions.
  • Database Troubleshooting - General troubleshooting of the database with common issues and resolutions.
  • Batch Troubleshooting - General troubleshooting of the background processing component of the product with common issues and resolutions.
Software Configuration Management Series
A set of whitepapers on how to manage customization (code and data) using the tools provided with the framework. Topics include Revision Control, SDK Migration/Utilities, Bundling and Configuration Migration Assistant. The individual whitepapers are as follows:
  • Concepts - General concepts and introduction.
  • Environment Management - Principles and techniques for creating and managing environments.
  • Version Management - Integration of Version control and version management of configuration items.
  • Release Management - Packaging configuration items into a release.
  • Distribution - Distribution and installation of releases across environments
  • Change Management - Generic change management processes for product implementations.
  • Status Accounting - Status reporting techniques using product facilities.
  • Defect Management - Generic defect management processes for product implementations.
  • Implementing Single Fixes - Discussion on the single fix architecture and how to use it in an implementation.
  • Implementing Service Packs - Discussion on the service packs and how to use them in an implementation.
  • Implementing Upgrades - Discussion on the the upgrade process and common techniques for minimizing the impact of upgrades.
Oracle Utilities Application Framework Security Overview A whitepaper summarizing the security facilities in the framework. Now includes references to other Oracle security products supported. LDAP Integration for Oracle Utilities Application Framework based products A generic whitepaper summarizing how to integrate an external LDAP based security repository with the framework. Oracle Utilities Application Framework Integration Overview A whitepaper summarizing all the various common integration techniques used with the product (with case studies). Single Sign On Integration for Oracle Utilities Application Framework based products A whitepaper outlining a generic process for integrating an SSO product with the framework. Oracle Utilities Application Framework Architecture Guidelines This whitepaper outlines the different variations of architecture that can be considered. Each variation will include advice on configuration and other considerations. Batch Best Practices This whitepaper outlines the common and best practices implemented by sites all over the world. Technical Best Practices V1 Addendum Addendum to Technical Best Practices for Oracle Utilities Customer Care And Billing V1.x only. XAI Best Practices This whitepaper outlines the common integration tasks and best practices for the Web Services Integration provided by the Oracle Utilities Application Framework. Oracle Identity Manager Integration Overview This whitepaper outlines the principals of the prebuilt intergration between Oracle Utilities Application Framework Based Products and Oracle Identity Manager used to provision user and user group security information. For Fw4.x customers use whitepaper 1375600.1 instead. Production Environment Configuration Guidelines A whitepaper outlining common production level settings for the products based upon benchmarks and customer feedback. 1177265.1 What's New In Oracle Utilities Application Framework V4?  Whitepaper outlining the major changes to the framework since Oracle Utilities Application Framework V2.2. 1290700.1 Database Vault Integration Whitepaper outlining the Database Vault Integration solution provided with Oracle Utilities Application Framework V4.1.0 and above. 1299732.1 BI Publisher Guidelines for Oracle Utilities Application Framework Whitepaper outlining the interface between BI Publisher and the Oracle Utilities Application Framework 1308161.1 Oracle SOA Suite Integration with Oracle Utilities Application Framework based products This whitepaper outlines common design patterns and guidelines for using Oracle SOA Suite with Oracle Utilities Application Framework based products. 1308165.1 MPL Best Practices
This is a guidelines whitepaper for products shipping with the Multi-Purpose Listener.
This whitepaper currently only applies to the following products:
1308181.1 Oracle WebLogic JMS Integration with the Oracle Utilities Application Framework This whitepaper covers the native integration between Oracle WebLogic JMS with Oracle Utilities Application Framework using the new Message Driven Bean functionality and real time JMS adapters. 1334558.1 Oracle WebLogic Clustering for Oracle Utilities Application Framework This whitepaper covers process for implementing clustering using Oracle WebLogic for Oracle Utilities Application Framework based products. 1359369.1 IBM WebSphere Clustering for Oracle Utilities Application Framework This whitepaper covers process for implementing clustering using IBM WebSphere for Oracle Utilities Application Framework based products 1375600.1 Oracle Identity Management Suite Integration with the Oracle Utilities Application Framework This whitepaper covers the integration between Oracle Utilities Application Framework and Oracle Identity Management Suite components such as Oracle Identity Manager, Oracle Access Manager, Oracle Adaptive Access Manager, Oracle Internet Directory and Oracle Virtual Directory. 1375615.1 Advanced Security for the Oracle Utilities Application Framework This whitepaper covers common security requirements and how to meet those requirements using Oracle Utilities Application Framework native security facilities, security provided with the J2EE Web Application and/or facilities available in Oracle Identity Management Suite. 1486886.1 Implementing Oracle Exadata with Oracle Utilities Customer Care and Billing This whitepaper covers some advice when implementing Oracle ExaData for Oracle Utilities Customer Care And Billing. 878212.1 Oracle Utilities Application FW Available Service Packs This entry outlines ALL the service packs available for the Oracle Utilities Application Framework. 1454143.1 Certification Matrix for Oracle Utilities Products This entry outlines the software certifications for all the Oracle Utilities products. 1474435.1 Oracle Application Management Pack for Oracle Utilities Overview This whitepaper covers the Oracle Application Management Pack for Oracle Utilities. This is a pack for Oracle Enterprise Manager. 1506855.1 Integration Reference Solutions
This whitepaper covers the various Oracle technologies you can use with the Oracle Utilities Application Framework. 1544969.1 Native Installation Oracle Utilities Application Framework This whitepaper describes the process of installing Oracle Utilities Application Framework based products natively within Oracle WebLogic. 1558279.1 Oracle Service Bus Integration  This whitepaper describes direct integration with Oracle Service Bus including the new Oracle Service Bus protocol adapters available. Customers using the MPL should read this whitepaper as the Oracle Service Bus replaces MPL in the future and this whitepaper outlines how to manually migrate your MPL configuration into Oracle Service Bus.

Note: In Oracle Utilities Application Framework V4.2.0.1.0 and above, Oracle Service Bus Adapters for Outbound Messages and Notification/Workflow are available 1561930.1 Using Oracle Text for Fuzzy Searching This whitepaper describes how to use the Name Matching and  fuzzy operator facilities in Oracle Text to implemement fuzzy searching using the @fuzzy helper fucntion available in Oracle Utilities Application Framework V4.2.0.0.0 1606764.1
Audit Vault Integration This whitepaper describes the integration with Oracle Audit Vault to centralize and separate Audit information from OUAF products. Audit Vault integration is available in OUAF 4.2.0.1.0 and above only.
1644914.1
Migrating XAI to IWS
Migration from XML Application Integration to the new native Inbound Web Services in Oracle Utilities Application Framework 4.2.0.2.0 and above.
1643845.1
Private Cloud Planning Guide
Planning Guide for implementing Oracle Utilities products on Private Clouds using Oracle's Cloud Foundation set of products.
1682436.1
ILM Planning Guide
Planning Guide for Oracle Utilities new ILM based data management and archiving solution.
1682442.1
ILM Implementation Guide for Oracle Utilities Customer Care and Billing
Implementation Guide for the ILM based solution for the Oracle Utilities Customer Care And Billing.
207303.1
Client / Server Interoperability Support Matrix
Certification Matrix.
1965395.1
Cache Nodes Configuration using BatchEdit utility
Using the new Batch Edit Wizard to configure batch quickly and easily
1628358.1
Overview and Guidelines for Managing Business Exceptions and Errors
Best Practices for To Do Management
2014163.1
Oracle Functional/Load Testing Advanced Pack for Oracle Utilities Overview
Overview of the new Oracle Utilities testing solution. Updated for 5.0.0.1.0.
1929040.1
ConfigTools Best Practices
Best Practices for using the configuration tools facility
2014161.1
Oracle Utilities Application Framework - Keystore Configuration
Managing the keystore
2014163.1
Oracle Functional/Load Testing Advanced Pack for Oracle Utilities Overview
Outlines the Oracle Application Testing Suite based testing solution for Functional and Load Testing available for Oracle Utilities Application Framework based products
2132081.1
Migrating From On Premise To Oracle Platform As A Service
Outlines the process of moving an Oracle Utilities product from on-premise to Oracle Cloud Platform As A Service (PaaS)
2196486.1
Batch Scheduler Integration
Outlines the Oracle Utilities Application Framework based integration with Oracle’s DBMS_SCHDEULER to build, manage and execute complex batch schedules
2211363.1
Enterprise Manager for Oracle Utilities: Service Pack Compliance
Outlines the process of converting service packs to allow the Application Management Pack for Oracle Utilities to install service packs using the patch management capabilities
2214375.1
Web Services Best Practices
Outlines the best practices of the web services capabilities available for integration

Dataguard Oracle 12.2 : Fast-Start Failover with Maximum Protection

Yann Neuhaus - Wed, 2016-12-14 17:04

With Oracle 12.1 the one requirement to configure Fast-start Failover is to ensure the broker configuration is operating in either Maximum Availability mode or Maximum Performance mode.
With 12.2 Fast-Start Failover can be now configured with the Maximum Protection
Below our broker configuration

DGMGRL> show configuration;
Configuration - ORCL_DR
Protection Mode: MaxPerformance
Members:
ORCL_SITE - Primary database
ORCL_SITE1 - Physical standby database
ORCL_SITE2 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS (status updated 48 seconds ago)

Let’s configure the maximum protection mode.
We first have to update some database properties.

DGMGRL> edit database 'ORCL_SITE1' set property LogXptMode='SYNC';
Property "logxptmode" updated
DGMGRL> edit database 'ORCL_SITE' set property LogXptMode='SYNC';
Property "logxptmode" updated
DGMGRL> edit database 'ORCL_SITE2' set property LogXptMode='SYNC';
Property "logxptmode" updated

After we have to enable the Maximum Availability before enabling the Maximum protection

DGMGRL> edit configuration set protection mode as maxavailability;
Succeeded.
DGMGRL> edit configuration set protection mode as maxprotection;
Succeeded.
DGMGRL>

And now let’s enable Fast-Start failover

DGMGRL> enable fast_start failover;
Error: ORA-16693: requirements not met for enabling fast-start failover
Failed.
DGMGRL>

Oh what happens?
Remember before enabling Fast-Start Failover we have to enable flashback for databases and also to set the database property FastStartFailoverTarget
Let’s enable flashback for databases
For the Primary

SQL> alter database flashback on;
Database altered.

For Standby databases

DGMGRL> edit database 'ORCL_SITE1' set state='APPLY-OFF';
Succeeded.
SQL> alter database flashback on;
Database altered.
SQL>
DGMGRL> edit database 'ORCL_SITE1' set state='APPLY-ON';
Succeeded.
DGMGRL>


DGMGRL> edit database 'ORCL_SITE2' set state='APPLY-OFF';
Succeeded.
DGMGRL>
SQL> alter database flashback on;
Database altered.
DGMGRL> edit database 'ORCL_SITE2' set state='APPLY-ON';
Succeeded.
DGMGRL>

Let’s set FastStartFailoverTarget property for the primary database

DGMGRL> edit database 'ORCL_SITE' set property FastStartFailoverTarget='ORCL_SITE2';
Property "faststartfailovertarget" updated

And then now we can enable the Fast-Start Failover with the maximum protection

DGMGRL> enable fast_start failover;
Enabled.
DGMGRL>

Checking after our configuration. The observer must be started, otherwise you will get warning about observer

DGMGRL> show configuration;
Configuration - ORCL_DR
Protection Mode: MaxProtection
Members:
ORCL_SITE - Primary database
ORCL_SITE2 - (*) Physical standby database
ORCL_SITE1 - Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS (status updated 1 second ago)
DGMGRL>

Just note that At least 2 standby databases must be available, otherwise the mode will be retrograded to MAXPERFORMANCE after Failover

 

Cet article Dataguard Oracle 12.2 : Fast-Start Failover with Maximum Protection est apparu en premier sur Blog dbi services.

Web Services Best Practices Whitepaper

Anthony Shorten - Wed, 2016-12-14 16:13

Over the last few release new web services capabilities have been added to the Oracle Utilities Application Framework. A wide range of new and updated facilities are now available for integration capabilities for inbound and outbound communications.

A new whitepaper has been released outlining the best practices for using the new and updated web services capabilities including:

 Capability Usage
 Inbound  Outbound  Inbound Web Services
 Container SOAP based web services

 Message Driven Bean (MDB)
 Container based JMS resource processing

 REST Support
 JSON/XML REST


 Real Time Adapters
 Real time integration for transports


 Outbound Messages
 Service based communications


 SOA/Oracle Service Bus Integration
 SOA middleware based interface
• •
 Web Service Integration
 Importing and execution of an external web service



The whitepaper is available from My Oracle Support at Web Services Best Practices for Oracle Utilities Application Framework (Doc Id: 2214375.1)

Customers using XAI can refer to the XAI Best Practices (Doc Id: 942074.1) available from My Oracle Support. The Web Services Best Practices whitepaper replaces the XAI whitepaper for newer releases.

Web Services Best Practices Whitepaper

Anthony Shorten - Wed, 2016-12-14 16:13

Over the last few release new web services capabilities have been added to the Oracle Utilities Application Framework. A wide range of new and updated facilities are now available for integration capabilities for inbound and outbound communications.

A new whitepaper has been released outlining the best practices for using the new and updated web services capabilities including:

 Capability Usage
 Inbound  Outbound  Inbound Web Services
 Container SOAP based web services

 Message Driven Bean (MDB)
 Container based JMS resource processing

 REST Support
 JSON/XML REST


 Real Time Adapters
 Real time integration for transports


 Outbound Messages
 Service based communications


 SOA/Oracle Service Bus Integration
 SOA middleware based interface
• •
 Web Service Integration
 Importing and execution of an external web service



The whitepaper is available from My Oracle Support at Web Services Best Practices for Oracle Utilities Application Framework (Doc Id: 2214375.1)

Customers using XAI can refer to the XAI Best Practices (Doc Id: 942074.1) available from My Oracle Support. The Web Services Best Practices whitepaper replaces the XAI whitepaper for newer releases.

Oracle Database 12c Release 2 Multitenant (Oracle Press)

Yann Neuhaus - Wed, 2016-12-14 16:00

Here it is. The multitenant book is out for sale…

CaptureBooks
One year ago, at DOAG2015, Vit Spinka came to me with this idea: with Anton Els they planned to write a book on multitenant and proposed me to be a co-author. I was already quite busy at that time and my short-term plan was to prepare and pass the OCM 12c exam. But this book idea was something great and that had to be started quickly. At that time, we expected the 12cR2 to be out on June 2016 and then the book should be at for Oracle Open World. So no time to waste: propose the idea to Oracle Press, find a reviewer and start as soon as possible.

For reviewers, I was very happy that Deiby Gomez accepted to do the technical review. And Mike Donovan was volunteer to do the English review. I think he didn’t imagine how hard it can be to take non-native English speakers writing, with very limited vocabulary, and put that to something that makes sense to read. It’s an amazing chance to have the language review done by someone with deep technical knowledge. This ensures that the improved style do not change the meaning. Having that language review is also a good way to uniformise the style for what is written by three different authors. I bet you cannot guess who has written what. In addition to that, Oracle Press asked to Arup Nanda to do an additional review which was great because Arup has experience about book writing.

So we worked on the 12.2 beta, tested everything (there are lot of code listings in the book), filled bugs, clarified everything. We had good interaction with support engineers and product managers. The result is a book on multitenant which covers all administration tasks you can do on a 12c database.

Cs11EMPWcAAdlSqIt was an amazing adventure from the get-go. You know people for their skills, blogs, presentations and discussions at events. And then you start to work with them on a common thing – the book – and remotely – we’re all on different timezones. How to be sure that you can work together? Actually, it was easy and went smooth. We listed the chapters and each of us has marked which chapter he prefers. And that was done: in one or two e-mail exchange the distribution of tasks was done with everybody happy. We had very short schedule: need to deliver one chapter every 2 or 3 weeks. I was happy with what I wrote and was equally happy with what I’ve read from Vit and Anton. Reviews from Deiby, Mike, Arup were all adding higher precision and clarity. Incredible team work without the need for long discussions. Besides the hard work and the delightful result, working with this team was an amazing human adventure.

Oracle Database 12c Release 2 Multitenant (Oracle Press)

Master the Powerful Multitenant Features of Oracle Database 12c
• Build high-performance multitenant Oracle databases
• Create single-tenant, multitenant, and application containers
• Establish network connections and manage services
• Handle security using authentication, authorization, and encryption
• Back up and restore your mission-critical data
• Work with point-in-time recovery and Oracle Flashback
• Move data and replicate and clone databases
• Work with Oracle’s Resource Manager and Data Guard

 

Cet article Oracle Database 12c Release 2 Multitenant (Oracle Press) est apparu en premier sur Blog dbi services.

Table lock adding foreign key

Tom Kyte - Wed, 2016-12-14 14:46
Add foreign constraint in child table at a time inserting statement fire in references table(parent table) so inserting query is going to hold, but we want to insert statement and add foreign key constraint parallel. it is possible or not ?
Categories: DBA Blogs

Count number of occurances by date and by code.

Tom Kyte - Wed, 2016-12-14 14:46
Hi All- I need to create a report that shows number of occurrences of a student being suspended (by 2 different suspension codes) for a range of dates (usually first day of month and last day of month) by school. Here is the starting query, th...
Categories: DBA Blogs

Grouping with DateRange

Tom Kyte - Wed, 2016-12-14 14:46
Hi Tom I have the following Case: CREATE TABLE TEST_DATERANGE ( TITLE VARCHAR2(10) ,DATEFROM DATE ,DATEUPTO DATE ); INSERT INTO TEST_DATERANGE VALUES ('Test A',TO_DATE( '01.12.2016' , 'DD.MM.YYYY' ),TO_DATE( '05.12.2016' , 'DD.MM.YYYY' ))...
Categories: DBA Blogs

The year zero

Tom Kyte - Wed, 2016-12-14 14:46
When I try to create a date in the year 0 I get an error: <code> SQL> select to_date('1-Jan-0000AD', 'dd-Mon-yyyyAD') 2 from dual 3 ; select to_date('1-Jan-0000AD', 'dd-Mon-yyyyAD') * ERROR at line 1: ORA-01841: (full...
Categories: DBA Blogs

Search for values in all tables

Tom Kyte - Wed, 2016-12-14 14:46
Hi Please I want your help In database 10g I want to search for a value (number or char) I don't know it's stored in any table of database Like search for 'king' the result be table_name=employees , column_name=emp_id Thanks for your efforts
Categories: DBA Blogs

FORCE result cache for queries that are not cacheable?

Tom Kyte - Wed, 2016-12-14 14:46
Is there a way to force the result cache for ANY query and let the application handle invalidation? In an extreme (not very wise) case, do this: select /*+ force_result_cache */ * from dba_tables where table = 'XXX'; Basically, we want to c...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator