Feed aggregator

ORA-00980 translation is no longer valid

Tom Kyte - Thu, 2016-07-28 17:06
Dear Sir, I am exporting a database from one system and importing it in another system. after importing its shows the error ORA-00980 tranlation is no longer valid everywhere i can see the solution but my question is 1)its working well with wit...
Categories: DBA Blogs

Invalid rowid in deadlock trace file...I must be missing something

Tom Kyte - Thu, 2016-07-28 17:06
Hi! We recently had an event where a trigger was changed by only a few lines resulting in hundreds of deadlocks a minute. We changed it back and all is well. I'm trying to figure out what happened though. The change in the trigger was if inserting s...
Categories: DBA Blogs


Tom Kyte - Thu, 2016-07-28 17:06
Hi Sir i am new for oracle. ____Q1) 2. Disabled validate - 3. Enabled novalidate 4. Enabled validate Please explain briefly with primary key constraints only with example (either 3Q or 4Q take any one ) Q2)while doing outer join(left/reght) ...
Categories: DBA Blogs

Code enchancement

Tom Kyte - Thu, 2016-07-28 17:06
Hell Chris, i have tables called t1 and t2. Table T1 Script as follows: <code> DROP TABLE T1 CASCADE CONSTRAINTS; CREATE TABLE T1 ( ID NUMBER ) Insert into T1(ID) Values(2001); Insert into T1(ID) Values(3001); Insert into...
Categories: DBA Blogs


Tom Kyte - Thu, 2016-07-28 17:06
Categories: DBA Blogs

Banishing some PeopleSoft Myths

Duncan Davies - Thu, 2016-07-28 11:05

There seems to be quite a bit of uncertainty and misinformation in the PeopleSoft marketplace currently, so I thought it might be time to banish a few myths:

1. PeopleSoft isn’t being improved/getting investment

There are those with vested interests or other biases that will always deny this regardless of the evidence put in front of them, but PeopleSoft is improving in leaps and bounds. In the last couple of years PeopleSoft has been moving at an increasing speed, and one of the biggest questions on many client’s minds right now is “how do I keep up”. My Cedar colleague Graham Smith has a long list of recent new features in his PeopleSoft Predictions 2016 post, but if you just counted Fluid, Selective Adoption and Cloud Delivery Architecture I don’t think there’s ever been a time in which PeopleSoft has improved so much in a short space of time, pre or post-acquisition. Paco has repeatedly committed to keeping PeopleSoft around until at least 2027, and using the last few years as evidence I’m inclined to believe him.

2. PeopleSoft is Legacy/Old Fashioned

PeopleSoft is certainly very well established, with a long history and a wide customer base, that much is true. This can be a good thing, in that much of the system is tried and tested with the wrinkles ironed out. It is also true that some aspects of PeopleSoft do things the ‘old way’. The majority of deployments are on-premises, without the flexibility and efficiency that cloud deployment and automation can bring. You also pay for PeopleSoft up-front, rather than monthly. It doesn’t have to be this way, however. PeopleSoft can be deployed in an agile and efficient manner, taking advantage of some of the new technology available to us now, and the new enhancements within the product.

3. To be a future-proof system it needs to be SaaS

This is tricky as different people hold varying ideas about what constitutes SaaS, however PeopleSoft does get regular updates containing new functionality from the vendor (every ~10 weeks), can be deployed in the Cloud (to gain auto-scaling/elasticity of resources, a predictable monthly subscription and theoretically even multi-tenancy – at least above the database-level, if it was something that clients wanted). Furthermore, the application of the updates and the management of the cloud architecture can be handed over to a friendly partner in order to get even closer to purists’ definitions of what SaaS entails – if that is important to you.

4. PeopleSoft’s UI is out-dated

Up until a few years ago there wasn’t the focus on ‘consumer grade UI’ that there is now. In that era, PeopleSoft’s UI measured up pretty well. It was certainly more attractive than SAP and/or E-Business Suite. Recently this greater focus on the User Interface has introduced new competitors but PeopleSoft still keeps up well. Of course you can compare an old version of PeopleSoft with the latest from a competitor and it will appear dated in comparison, however if you use the latest PeopleSoft UI in the comparison it’ll fare rather better. The Fluid UI is (at least) the equal of anything out there, regardless of which device you view it on.

5. The PeopleSoft Market is Quiet

From what I can see there are fewer green-field implementations than 5 years ago, but there is a lot more upgrade activity. Clients are moving to 9.2 at a far greater rate than for 9.0 or 9.1, and then starting initiatives to really get value from the software once they get there. As a company I’m not sure Cedar has ever been busier.

So, now I’ve got that off my chest, I might do some predictions like Graham next …

Fishbowl’s Agile (like) Approach to Oracle WebCenter Portal Projects

In this video blog, Fishbowl Solutions’ Technical Project Manager, Justin Ames, and Marketing Team Lead, Jason Lamon, discuss Fishbowl’s Agile (like) approach to managing Oracle WebCenter portal projects. Justin shares an overview of what Agile and Scrum mean, how it is applied to portal development, and the customer benefits of applying Agile to an overall portal project.

Customer Testimonial:

“This is my first large project being managed with an Agile-like approach, and it has made a believer out of me. The Sprints and Scrum meetings led by the Fishbowl Solutions team enable us to focus on producing working portal features that can be quickly validated. And because it is an iterative build process, we can quickly make changes. This has lead to the desired functionality we are looking for within our new employee portal based on Oracle WebCenter.”

Michael Berry

Staff VP, Compensation and HRIS

Large Health Insurance Provider

The post Fishbowl’s Agile (like) Approach to Oracle WebCenter Portal Projects appeared first on Fishbowl Solutions' C4 Blog.

Categories: Fusion Middleware, Other

How to manage your containers in Oracle Storage Cloud Service ?

Yann Neuhaus - Thu, 2016-07-28 07:57

Oracle Cloud Storage Service provides secure, scalable and consistent data from any environment.
To get a higher flexibility for your backups, I suggest to use a CloudBerry application in Oracle Public Cloud.

This application can be used on Cloud Backup and Recovery in PaaS and IaaS infrastructures.
We are going to use it for our DbaaS in PaaS infrastructure.
However, a user-friendly third party tool can also be used as CloudBerry Explorer for OpenStack as managing Storage Containers.

Before starting with CloudBerry it is necessary to subscribe to a trial access or to buy a billing frequency hourly or monthly. In both cases, we have the same functionalities.

Let’s go !

Follow all steps to subscribe your free trial access in the PaaS / DbaaS category on https://cloud.oracle.com/home.
Once your account is registered, you will receive an e-mail from Oracle with subscription details.

This e-mail contains a lot of services, but we will only use the Oracle Backup Service. We can notice that our Backup Service has a data region (UK) and a link to associated documentation (same for other services).

Oracle Database Backup Service
Data Region: UK001
Get Started: http://docs.oracle.com/cloud/latest/dbbackup_gs/index.html

In the next steps, we will have a look on different types of Backup Services. The access to the Backup Services is linked to your account.

You need :
Your email address
Your password
Your Identity Domain

Start with CloudBerry by downloading and installing the following link : http://www.cloudberrylab.com and install it.

Step 1 – Creating an Oracle connection

File > New Oracle Account


The account location depends on where you have subscribed your Datacenter. This account is notified when you receive your confirmation e-mail. Note that your storage space is linked with your identity domain and that all services, which depend on your subscription, will be stored in this area.

Once the connection is established we are going to create a container for the backup storage area (process below).


This page shows other containers as well as our “SandBox” container we just created. The “_apaas” belongs to an Application Container Cloud I created as a service on my Oracle Public Cloud.

We will use our SandBox container to create our Oracle Backup Service. There are 2 kinds of containers, “Standard & Archive”.

Standard : Containers are similar to a directory structure but with a key distinction: unlike directories, containers cannot be nested.
By default, all containers are of the standard storage class (as opposed to the archive storage class).

Archive : You can use Archive containers to store data that won’t be accessed for a while or that will be accessed infrequently.

For example :


In Cloud, we can monitor storage capacity of your Oracle Database Backup Service.


Step 2 – Connection in your Oracle Public Cloud


Once the connection to your Oracle Public Cloud is established, we shall create a new database with a Backup storage area. I am not going to describe all steps to create a database in a Cloud, but rather some steps to backup the storage and a summary before we create it.

Step 3 – Creating Cloud Database with Backup and Recovery configuration Here is the summary of out DBaaS creation :


As you will notice in the backup destination section, we have chosen a backup location option for the database in your service and, depending on your choice, provided information regarding the Oracle Storage Cloud service container where cloud backups have to be stored.

Backup Destination: we are going to store our backup in a Cloud or/in a local storage.


For configuration, remember your :

Cloud Storage Container : <store service name>-<identity domain name>/<container name>

Step 4 – Backup Tests

First, we shall execute a backup of the database with RMAN command, then we will be able to check the results.


The backup has been correctly performed with RMAN command. So we will see if we have our backup pieces in your container.


 As shown in the picture above, we find the backups in our “SandBox” container.

Step 5 – How to check my backup parameters ?

When you perform a “Show All” command in RMAN you can check how your channel is configured for backups. There you should have a library parameter set up in RMAN as follow :


We can notice that there are “SBT_TAPE” channels for the device with its library (libopc.so) and the configuration which is limited to maxsize of 2 Go.

We see a parameter file called opcSDBX.or which contains the settings to access the backup cloud service Container. Then you can check it and open it with a text editor.


Here we find our parameters entered previously when we created our access in the Oracle Cloud backup. We can observe one important thing: we use a wallet to secure backups and recovery in Cloud.


Easy to use, simple to set up, just try it !


Cet article How to manage your containers in Oracle Storage Cloud Service ? est apparu en premier sur Blog dbi services.

Oracle Buys NetSuite

Oracle Press Releases - Thu, 2016-07-28 06:52
Press Release
Oracle Buys NetSuite

Redwood Shores, Calif.—Jul 28, 2016

Oracle (NYSE: ORCL) today announced that it has entered into a definitive agreement to acquire NetSuite (NYSE: N), the very first cloud company. The transaction is valued at $109.00 per share in cash, or approximately $9.3 billion.

“Oracle and NetSuite cloud applications are complementary, and will coexist in the marketplace forever,” said Mark Hurd, Chief Executive Officer, Oracle. “We intend to invest heavily in both products—engineering and distribution.”

“We expect this acquisition to be immediately accretive to Oracle’s earnings on a non-GAAP basis in the first full fiscal year after closing,” said Safra Catz, Chief Executive Officer, Oracle.

“NetSuite has been working for 18 years to develop a single system for running a business in the cloud,” said Evan Goldberg, Founder, Chief Technology Officer and Chairman, NetSuite. “This combination is a winner for NetSuite’s customers, employees and partners.”

“NetSuite will benefit from Oracle’s global scale and reach to accelerate the availability of our cloud solutions in more industries and more countries,” said Zach Nelson, Chief Executive Officer, NetSuite. “We are excited to join Oracle and accelerate our pace of innovation.”

The evaluation and negotiation of the transaction was led by a Special Committee of Oracle’s Board of Directors consisting solely of independent directors. The Special Committee unanimously approved the transaction on behalf of Oracle and its Board of Directors.

The transaction is expected to close in 2016. The closing of the transaction is subject to receiving certain regulatory approvals and satisfying other closing conditions including NetSuite stockholders tendering a majority of NetSuite’s outstanding shares in the tender offer. In addition, the closing is subject to a condition that a majority of NetSuite’s outstanding shares not owned by executive officers or directors of NetSuite, or persons affiliated with Larry Ellison, his family members and any affiliated entities, be tendered in the tender offer.

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

Contact Info
Deborah Hellinger
Oracle Corporate Communications
Ken Bond
Oracle Investor Relations
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.


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

Safe Harbor

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

Cautionary Statement Regarding Forward-Looking Statements

This document contains certain forward-looking statements about Oracle and NetSuite, including statements that involve risks and uncertainties concerning Oracle's proposed acquisition of NetSuite, 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 NetSuite, 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, and the possibility that Oracle or NetSuite 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 NetSuite.

In addition, please refer to the documents that Oracle and NetSuite, respectively, file with the U.S. Securities and Exchange Commission (the "SEC") on Forms 10-K, 10-Q and 8-K. These filings identify and address other important factors that could cause Oracle's and NetSuite's respective operational and other results to differ materially from those contained in the forward-looking statements set forth in this document. 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 NetSuite is under any duty to update any of the information in this document.

Oracle is currently reviewing the existing NetSuite 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 NetSuite's product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by NetSuite or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. It is intended for information purposes only, and may not be incorporated into any contract.

Additional Information about the Acquisition and Where to Find It
In connection with the proposed acquisition, Oracle will commence a tender offer for the outstanding shares of NetSuite. The tender offer has not yet commenced. This document is for informational purposes only and is neither an offer to purchase nor a solicitation of an offer to sell shares of NetSuite, nor is it a substitute for the tender offer materials that Oracle and its acquisition subsidiary will file with the SEC upon commencement of the tender offer. At the time the tender is commenced, Oracle and its acquisition subsidiary will file tender offer materials on Schedule TO, and NetSuite will file a Solicitation/Recommendation Statement on Schedule 14D-9 with the SEC with respect to the tender offer. The tender offer materials (including an Offer to Purchase, a related Letter of Transmittal and certain other tender offer documents) and the Solicitation/Recommendation Statement will contain important information. Holders of shares of NetSuite are urged to read these documents when they become available because they will contain important information that holders of NetSuite securities should consider before making any decision regarding tendering their securities. The Offer to Purchase, the related Letter of Transmittal and certain other tender offer documents, as well as the Solicitation/Recommendation Statement, will be made available to all holders of shares of NetSuite at no expense to them. The tender offer materials and the Solicitation/Recommendation Statement will be made available for free at the SEC's web site at www.sec.gov.

In addition to the Offer to Purchase, the related Letter of Transmittal and certain other tender offer documents, as well as the Solicitation/Recommendation Statement, Oracle and NetSuite file annual, quarterly and special reports and other information with the SEC. You may read and copy any reports or other information filed by Oracle or NetSuite at the SEC public reference room at 100 F Street, N.E., Washington, D.C. 20549. Please call the Commission at 1-800-SEC-0330 for further information on the public reference room. Oracle's and NetSuite's filings with the SEC are also available to the public from commercial document-retrieval services and at the website maintained by the SEC at http://www.sec.gov. 

Learn More
Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

Oracle FROM_TZ Function with Examples

Complete IT Professional - Thu, 2016-07-28 06:00
In this article, I’ll explain what the Oracle FROM_TZ function is and show you some examples. Purpose of the Oracle FROM_TZ Function The purpose of the FROM_TZ function is to convert a TIMESTAMP value and a specified TIME ZONE to a TIMESTAMP WITH TIME ZONE value. It seems like a simple data conversion function, but […]
Categories: Development

OBIEE - New Feature Guide

Rittman Mead Consulting - Thu, 2016-07-28 04:00
OBIEE - New Feature Guide

Oracle has recently released version for OBIEE 12c, which has a variety of exciting new features for Data Visualization, BI Publisher, Dashboards in OBIEE, and ODBC connections. It can be performed as an in-place upgrade (performed by the Upgrade Assistant) or as a fresh install. The upgrade process is explained at length here. There is also an example Linux in-place upgrade from to which can be found here. Let's take an in-depth look at some of the new features.

Data Visualization (aka Visual Analyzer)

A variety of features have been added to Data Visualization, which brings it closer to its standalone counterpart, Data Visualization Desktop.

Visualize Data from Oracle Applications

One of the most powerful exploratory features of Data Visualization Desktop is the ability to use your OBIEE analyses as direct datasources. This allows user to "revisualize" and explore the data contained within one or more analyses in different ways. Oracle has added this same feature in data visualization. To access this feature from the DV Home Page, click on Data Sources > Create New Data Source.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

You are then presented with three choices: From a File, From Oracle Applications or From Database (more on this later).

OBIEE - New Feature Guide

Selecting From Oracle Applications opens a new window where you enter your connection information.

OBIEE - New Feature Guide

Once you enter the connection information, you are able to view all of the folders you have access to within the OBIEE catalog. Selecting an analysis and clicking ok brings you to another screen where you can specify between measures and attributes for your columns and change the specified aggregation for your measure columns.

OBIEE - New Feature Guide

Clicking Add Data Source adds the analyses to the Data Source page

.OBIEE - New Feature Guide

Visualize Data from Databases

Another feature added to DV is the ability to connect directly to a database. It allows you to add tables directly from a database schema or write a SQL statement to select the data you want.

To connect to a database as a data source, select Data Sources from the Home Page then Create New Data Source > From Database. This brings up a connection window to enter your connection details.

OBIEE - New Feature Guide

From here, you can also select from a large selection of database types other than the default Oracle Type. Clicking on Oracle brings up the list which matches the selections available in the latest release of Data Visualization Desktop.

OBIEE - New Feature Guide

Choosing to add tables from a database schema allows you to add data sources, one table at a time.

OBIEE - New Feature Guide

In some situations, you might want to create one datasource selection from a database from multiple tables. You can achieve this by clicking on the SQL tab after making your database connection and writing a custom sql statement.

OBIEE - New Feature Guide

Clicking OK brings you to a results screen with all of the columns previously defined in your sql statement and also give you the ability to rename your datasource and to change the aggregation type for your measure columns.

OBIEE - New Feature Guide

Modifying Uploaded Data Sources

Also known as "Data Wrangling", Oracle has added the ability to manipulate a dataset depending on the column data type. By invoking a logical SQL function, Data Visualization does the work for you and can create a new column or edit an existing one. To show an example of this, I created a new VA Project and uploaded a sample Excel file.

OBIEE - New Feature Guide

In the top left menu bar, there is an option called Stage. Clicking on it opens the datasource and shows all of the columns present and the first 100 records.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

Note: If you have more than one file, clicking on the name of the file in the top left will reveal a dropdown menu where you can choose between them.

To edit or add a column, navigate to the right of the column you wish to edit and click on the options icon OBIEE - New Feature Guide.

This brings up the options menu where you can select from a variety of different options for editing or adding column depending on the datatype.

OBIEE - New Feature Guide

Using the Concatenate function, I was able to create a new column that showed the full name of each customer combined with data in the Age Group column separated by a colon.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

If you chose to create a new column, a Create New Data Element window opens allowing you to input logical SQL functions similar to the edit column formula feature in OBIEE Analytics.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

New and Enhanced Visualization Types

DV now includes new visualizations including donut charts, text boxes, sunburst, combo, scatter (cat.) and stacked scatter (cat.), which brings it in line with the offerings from Data Visualization Desktop.

OBIEE - New Feature Guide

Also included (assuming you have installed and configured Oracle's R distribution) is the ability to add clusters, outliers, reference lines, trend lines and forecast. There are two ways to add these to your visualizations. The first is by selecting the Analytics option in the horizontal menu bar on the far right side and then choose the desired function. Double clicking on a function automatically adds it to your visualization.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

Another option is to add them directly from Menu > Properties > Analytics within your visualization.  You can add analytic functions and, depending on the function, there are a variety of different options to change how the function is displayed.

OBIEE - New Feature Guide

You can also add URLs or links to insights within Tiles, Text Boxes and Image visualizations and, if you use Chrome for Windows or Android, there is a dictation option within properties that you can use to add descriptions.

OBIEE - New Feature Guide

Customize Color Schemes

One of the more frustrating absences from DV up to this point was the ability to customize colors in your visualizations. Oracle has not only added this feature but given you the ability to customize and save these customizations, making color conformance for a group of users or across an entire organization a breeze.

Let's start by looking at an example of applying color to an entire project. To access the project color properties, click on Canvas Settings > Project Properties. By clicking on the color selection in the Color Series section, you can choose from one of four default selections or create your own custom palette.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

Notice how each measure is assigned a color and that color is continuous across the entire project.

You can also manage colors from inside of an individual visualization. To do this, click on Menu > Color > Manage Color Assignments. From here you can assign colors to each measure individually and it is then displayed across the entire project.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

Another option is to change a color by right clicking on an individual data point.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

In this example, I right clicked on Technology and changed its color which then changed it for every visualization in the project.

OBIEE - New Feature Guide

Data Blending

Oracle added the ability to specify which data source takes precedence over the other when blending two data sources together. This can be very useful when you have a project that includes data from two data sources and there are match values in one data source that are not in the second. Let's look at an example.

I have two data sources. One contains population information and one contains country name and they are matched on the country codes.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

Notice in the example that there are countries that have no population facts and and population facts that have no countries.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

So that we can see only the countries which have population information, click on one of the columns in the report, right click and select Properties > Data Sets. Here you are presented with an option for each source: All Rows or Matching Rows.

OBIEE - New Feature Guide

Changing the source that contains country information to Matching Rows will keep only the countries that have corresponding population information.

OBIEE - New Feature Guide

Share Reports as Read-Only

It is now possible to share a report with other users as read-only. They will still be able to interact and edit filters, but won't be able to see the authoring content controls. They are also able to go back an forth between presentation mode.

Other Features 

Two other features for DV introduced in is the ability to upload data files up to 50mb in size. Also you can hide the filter panel from view to increase canvas space for your projects.

BI Publisher

Oracle has also updated BI Publisher 12c to version You can see the official document here.

Deliver documents to Oracle Document Cloud Service

You are now able to deliver BI Publisher reports to the Oracle Documents Cloud service via a delivery channel in BI Publisher. You can deliver reports to cloud storage from both on-premise or a cloud deployment of BI Publisher.

You can set up this feature under Administration > Delivery > Document Cloud Services within BI Publisher

OBIEE - New Feature Guide

Here, under the Document Cloud Services tab, you can add the connection details to your cloud server.

OBIEE - New Feature Guide

OBIEE - New Feature Guide

Use WebCenter Content as a Data Source

You can now read text data files from WebCenter Content. You can create a Content Server data source under Administration > Delivery > Content Server

OBIEE - New Feature Guide

After you create your Content Server as a data source, you can create Content Server as a dataset in a BI Publisher data model and retrieve text data files stored in Web Center Content by Document ID.

OBIEE - New Feature Guide

Attach PDF to Your Invoices

You can now send PDF attachments along with invoices with BI Publisher You can attach PDFs along with the invoice while bursting. The process is explained in more detail in the BI Publisher documents here.

Integrate Using RESTful APIs

BI Publisher introduces a set of REST APIs that allow you to view reports in an application. It connects to the BI Publisher Server through a URL and uses JSON objects to contain data. You can read more about RESTful APIs in BI Publisher in the BI Publisher new features guide here.

Deliver Email Body in HTML Format along with Report as Attachment

You can use standard HTML4 formatting tags to create the email body, include a logo or images, add hyperlinks and more. Reports will be generated as attachments to the email.

Manage Custom Fonts

In BI Publisher, you can manage custom fonts from the Administration page, and once uploaded, these custom fonts can be displayed in reports.

OBIEE - New Feature Guide

Manage PGP Keys for FTP Delivery Encryption

In BI Publisher, Administrators can upload and manage PGP Keys from the Administration page. FTP delivery encryption is now a self-service feature. More details can be found in the BI Publisher documents.

Dynamic Memory Guard

You can now separately configure limits for online and offline reports. The limits can be made dynamic by using variables, system defined functions and operators and, when the data changes, the dynamic memory guard will adjust.

You can access the Memory Guard in the Administration page under Runtime Configuration > Properties.

OBIEE - New Feature Guide

More information can be found in the BI Publisher documents.

Enabling Encryption for File Data Security on Cloud

You can now enable File Data Encryption in the Administration page and your data files with be encrypted at the time of uploading them on the server.

OBIEE Dashboard Subpages

A new feature for OBIEE is the ability to add subpages within dashboards. This feature will allow dashboard designers to create multiple subpages for each dashboard page. To add a subpage, click on the desired dashboard page and click the "Add Dashboard Page" icon and select "Add Subpage."

OBIEE - New Feature Guide

The Add Subpage window will then be displayed where you can name your subpage and add a description.

OBIEE - New Feature Guide

Once you click OK, the subpage will be added to the dashboard page and adding content to the subpage is the exact same process as adding content to a dashboard page.

OBIEE - New Feature Guide

RPD - Enable Data Driven Fragment Selection

A new feature for RPD developers is the ability to improve the performance of fragmented logical table sources by using the Enable Data Driven Fragment Selection feature. More information on how to enable this feature can be found in the documents here.

Additional Data Sources Supported

New data sources are supported for using DataDirect 7.1.5. These include Amazon RedShift, Oracle Service Cloud, Greenplum, Salesforce, and Teradata. Connections to Apache Spark and MongoDB are also available using 8.0.


All in all, the update for OBIEE 12c adds some very powerful features. Data Visualization is now a very complete product and it's new features and native connectors make it a powerful addition to the new era of data visualization. For Oracle Cloud users, the integration for BI Publisher and Data Visualization makes the "report and share" process easier than ever.

Categories: BI & Warehousing

Exact count of alphabet

Tom Kyte - Wed, 2016-07-27 22:46
Sir, I want the query so that I have the names of person who are having exactly have 2 'a' in his or her name.. M trying query but m getting more then 2 'a'. But i want exactly two. Thanks.
Categories: DBA Blogs

data pump api - keep master

Tom Kyte - Wed, 2016-07-27 22:46
Is there a way to keep the master table on the successful completion of a data pump import/export using the API? There looks to be a way to keep the master table when using interactive data pump (keep_master=Y).
Categories: DBA Blogs

database migration from sun sparc to solaris x86_64

Tom Kyte - Wed, 2016-07-27 22:46
We are planning to migrate our databases from sun sparc machine to solaris x86_64. Both are different endian format. Could you please let me know the best approach to migrate these databases
Categories: DBA Blogs

How to Read and Load Swift Message into Database

Tom Kyte - Wed, 2016-07-27 22:46
Hi Tom, This is regarding SWIFT MESSAGE (MT900 format). On Daily basis ,We will be receiving Bank to Bank transactions details in the form of SWIFT Message (MT900 format) i.e in .txt file. Here , Ask is to Read and LOAD swift message tags ...
Categories: DBA Blogs

deletion of controlfiles

Tom Kyte - Wed, 2016-07-27 22:46
hi Team, even after deleting all the controlfiles the checkpoint doesn't gives me error, where the checkpoint writes the information where no controlfile is available? Kindly clarify.
Categories: DBA Blogs

table join evaluation (ORA-01722: invalid number)

Tom Kyte - Wed, 2016-07-27 22:46
Hello AskTom Team, Could you please explain how optimizer evaluates the join with wrong data types? <code> CREATE TABLE TEST1(COL1 NUMBER,COL2 VARCHAR2(100)); CREATE TABLE TEST2(COL1 NUMBER,COL2 VARCHAR2(100)); CREATE TABLE TEST3(COL1 NUMBER...
Categories: DBA Blogs


Tom Kyte - Wed, 2016-07-27 22:46
Hi ,I installed Oracle 12c on my laptop , and when i try to connect from form builder gets this error ORA-12154 :tns : couldn't resolve the connect identifier specified I tried all ways but not solved I hope anyone can help me cause I only know ab...
Categories: DBA Blogs

Char vs Varchar (data location)

Tom Kyte - Wed, 2016-07-27 22:46
Hello Tom, I read your article https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1542606219593 (and would have replied there, but couldn't figure out how to do that) and was wondering if this MS SQL "feature" I read about in "Bu...
Categories: DBA Blogs

Large Pages and MEMORY_TARGET on Windows

Yann Neuhaus - Wed, 2016-07-27 16:57

In a previous post about enabling large page on Windows Server, I explained that it’s possible to use large pages with Automatic Memory Management (AMM, where sizing if SGA and PGA is automatic with MEMORY_TARGET setting) but possible does not mean that it is recommended. We feel that it’s not a good idea, but are there reasons for it or it’s just our linux backgroud that brings this opinion?


What is the size of allocated large pages? If it is set, SGA_MAX_SIZE is the size allocated as large pages when ORA_LPENABLE=1, even if you’ve set some MEMORY_MAX_SIZE:
VirtualBox_Windows 2012 Server_27_07_2016_17_12_02

I take screenshots with all information: the init.ora settings and the regedit entry on top-left. Latest sqlplus commands on top right (here screenshot is just after the startup). And memory given by Sysinternals RamMap.

So, when SGA_MAX_SIZE is set, it’s the maximum size of SGA that can be allocated, and this is what is allocated at startup from physical memory until the end of the instance. You can reduce the SGA_TARGET dynamically, but I don’t see any reason for that as the memory allocated in large page will not be released, nor swapped, nor usable for PGA.


If we don’t set SGA_MAX_SIZE, then the SGA can grow up to MEMORY_MAX_SIZE and this is what is allocated at startup when ORA_LPENABLE=1:

VirtualBox_Windows 2012 Server_27_07_2016_17_16_44

Physical memory must be free

When ORA_LPENABLE=1 and not enough memory is available if physical memory, you get an error (ORA-27102 OS 1450) at startup:
VirtualBox_Windows 2012 Server_27_07_2016_17_23_17

What I did here was running 10 instances of SQLDeveloper to use 2GB on my 8GB VM.


Not only we need the SGA to be allocated from physical memory, but it needs to be contiguous. Here is a screenshot I took some times later with those sqldev closed but after I had lot of activity on the VM:
VirtualBox_Windows 2012 Server_27_07_2016_21_32_16
As you see here, there is enough RAM (7GB) but not contiguous.

The recommandation when using large pages on Windows is to start all instances immediately after server restart, and if you have to restart an instance you may have to reboot the server. Note that the major advantage of large pages is on virtualized environments, and then you should not have more that one instance in a server. If you are convinced that with Windows it’s always good to restart the server, here you have a reason: fragmentation breaks large pages.


Let’s go back to the state where I had 10 SQLDeveloper opened. I change ORA_LPENABLE to 2 instead of 1 to be able to start the instance even is there is not enough contiguous RAM for the SGA (here for the MEMORY_TARGET as no SGA_MAX_SIZE is defined).

Now, I’m able to start the instance (but it took several minutes here as physical memory is exhausted):
VirtualBox_Windows 2012 Server_27_07_2016_20_56_25
Instance is started, but not all 6GB have been allocated as large pages. In this case where SGA_TARGET is 3GB, I presume that all SGA uses large pages unless we increase SGA_TARGET higher than the 5GB allocated, but this is only my guess.


So, now that we know how it works, let’s see the danger to run AMM with large pages.

Here is a database in AMM where MEMORY_TARGET=5GB after running some query that needs several GB of buffer cache (thanks to CACHE hint and “_serial_direct_read”=never) and several GB of PGA (thanks to manual workarea size policy). First, without large pages:

VirtualBox_Windows 2012 Server_27_07_2016_21_56_24

The RAM allocation is all private process memory (on Windows, Oracle processes are actually threads from one process only). And AMM achieves its goal: target is MEMORY_TARGET=5GB and this is what we have allocated for the instance.


Now doing the same with large page:
VirtualBox_Windows 2012 Server_27_07_2016_22_09_10

MEMORY_MAX_SIZE is supposed to be used for PGA+SGA and a large use of PGA should reduce SGA. But it cannot be done here because SGA is large page and PGA cannot be allocated from large pages. This means that AMM with large page do not achieve its goal. MEMORY_MAX_SIZE acts like having set SGA_MAX_SIZE to that value and very small PGA_AGGREGATE_TARGET. In this example (artificial example as I used manual workarea size policy, but same happens with auto and several sessions) physical memory is exhausted.

From that, I think we have a reason to recommend ASSM (Automatic Shared Memory Management) with large pages, as with Linux. In Oracle, because of the threaded architecture, it’s not a requirement but in my opinion it’s still a good idea to differentiate those memory areas that are so different:

  • SGA: one area allocated at startup, preferentially from large pages
  • PGA: variable size areas allocated and de-allocated by sessions

If you have more than few GB on your server, you should size SGA and PGA independently and benefit from large pages for SGA. Do not set MEMORY_MAX_SIZE then. Don’t set MEMORY_TARGET either as it acts as MEMORY_MAX_SIZE if this one is not set.


Cet article Large Pages and MEMORY_TARGET on Windows est apparu en premier sur Blog dbi services.


Subscribe to Oracle FAQ aggregator