Feed aggregator

impdp parallel

Tom Kyte - Sun, 2016-07-03 13:46
Dear TOM when i impdp a db user with parallel parameter,does it really create the indexes with the parallel degree which i specified? thank you.
Categories: DBA Blogs

Questions about performance tuning.

Tom Kyte - Sun, 2016-07-03 13:46
I am working as plsql developer with 2 years of experience and I have some doubts which listed below. 1- What are the basic concepts I should know as a junior engineer about performance tuning. 2- What is the performance of " select * from Emp...
Categories: DBA Blogs

Dataguard in SE edition

Tom Kyte - Sun, 2016-07-03 13:46
I know that oracle 11g SE edition does not support any data guard. so Is it possible to create a physical standby database with RMAN on SE edition? help
Categories: DBA Blogs

why ref cursor is inefficient that regular cursor

Tom Kyte - Sun, 2016-07-03 13:46
I have seen many posts and observed that Ref Cursors are inefficient when compared to Regular cursors. it would be great if you explain me what happens internally and why ref cursors are inefficient than regular cursors.
Categories: DBA Blogs


Tom Kyte - Sun, 2016-07-03 13:46
Hello Sir, Can we have your presentation from OOW 2010? Thanks & Regards
Categories: DBA Blogs

SQL Saturday 510 – Locks, latches et spinlocks – Les slides

Yann Neuhaus - Sun, 2016-07-03 13:40

Cette année les gens ont encore répondu présent au SQLSaturday à Paris qui devenu incontournable pour ceux qui aiment échanger autour de la donnée avec les produits Microsoft. Par ailleurs, le temps a plutôt été au rendez-vous cette année et la vue depuis le 40ème étage de la tour Montparnasse est toujours aussi impressionnante.

Pour ma part, j’ai eu le plaisir d’animer une session en fin de journée sur la concurrence d’accès mais vu depuis SQL Server avec 3 principaux mécanismes utilisés comme les locks, latches et spinlocks.

blog 98 - lock latches spinlocks


Les slides sont téléchargement directement depuis le site du Pass.

Encore un grand merci aux organisateurs de cet événement (GUSS), aux volontaires de Supinfo, aux sponsors et aux participants!

A bientôt


Cet article SQL Saturday 510 – Locks, latches et spinlocks – Les slides est apparu en premier sur Blog dbi services.

Startups: Your Oracle PaaS4SaaS Cloud Pivot Enabler is Here

Usable Apps - Sat, 2016-07-02 19:52

Oracle Applications User Experience Senior Director Ultan O’Broin (@ultan) keeps his finger on the pulse of the startup scene in EMEA with an eye to enabling that community with the OUAX outreach machine. Here he talks about what's on offer to startups to accelerate SaaS and PaaS opportunities.

 When Life Gives You Lemons, Pivot

Jared of Pied Piper Pivots

After over two decades of experience in the tech industry, half of it in the Valley, I still find it hard to predict what’s going to go down on any given day. Even if things go slightly pear-shaped, I rarely don’t have a #lovemyjob day. Having a sense of humor always helps... 

Dogpatch Labs Dublin, Ireland

Dogpatch Labs tech co-working space, Dublin. As good a community of happening startups as anywhere in Silicon Valley (Image: Ultan O'Broin). 

It’s probably why HBO's Silicon Valley is favorite viewing of mine. I can relate to it not only it resonates with my experience and goes past the tech jargon and cuts close to the bone with those #ouch moments.

In the first series of Silicon Valley there's the famous TechCrunch Disrupt scene where Pied Piper's business development head Jared responds to a life giving you lemons moment by advising the crew that their startup needs to “pivot” and pitch their middle-out compression solution in a different direction. Pivoting is about being adaptable and finding a good fit with the market.

Twilio IPO Congrats at Dogpatch Labs

Twilio IPO celebrated in Dogpatch Labs (Twilio Ireland is located there.) (Image: Ultan O'Broin)

If This Then That Conundrum

Our partners too need to be adaptable in the fast-moving “as a service”  space. Building new stuff to pitch is as critical to meeting the demands of a customer and expectations about the shortened innovation cycles of a cloud.

Take virtual reality,  augmented reality or wearable tech, for example. Partners cannot sell an innovative solution with new technology unless they build it to show it, yet unless a customer expresses a serious interest in it they won't risk cost and time cost in building something to show to the market. Two factors for success remains constant though: the solution must add value by solving a problem and the user experience involved must be superb or no-one will either want to sign up for it.

Startup Enablement Accelerators

Our Cloud UX Rapid Development Kit (RDK) solves this kind of "chicken and egg" problem. Using our kit and enablement helps startups to not only identify suitable SaaS integrations or custom PaaS apps business use cases and design them using the startup-friendly Jobs To Be Done approach but to then rapidly build and deploy them as awesome user experiences.

The OAUX team of course has worked with the best of the startup ecosystem for years: Our AppsLab emerging tech team are huge fans of Twilio (now past IPO stage). We have a great story to tell about enabling others worldwide to design and build PaaS4SaaS solutions with a killer UX to seek out and win business with. In the applications space, startup operations such as FXLoader have solutions on the Oracle Cloud MarketPlace and others such as Certus Solutions are already UX and PaaS4SaaS champs.

Next Steps to Greatness

Are you a startup who wants to build a killer SaaS or PaaS UX for the cloud? Do you need design guidance for your idea? If so, check out our RDK: it's free. Furthermore, we offer free design guidance and enablement workshops for selected use cases too. For hands-on enablement (which takes the form of a couple of online sessions and a hands-on workshop), there are criteria though, before you can head to market:

  • You must have a cutting edge simplified UI use case for SaaS extensions or PaaS custom app with a responsive web UI across devices? Same for any IoT, wearable tech, or mobile solutions that integrate with the API riches of the web.
  • You must be an active OPN member (Silver level+).
  • Your application or service must extend or integrate with one or more of the Oracle SaaS applications using supported APIs or PaaS or cloud integration services and/or application extensibility tools.
  • You must be willing to share your success story with Oracle and the partner/startup community.
There are other gotchas we will also check into before we commit, but it's nothing too serious. Stuff like are you past series A funding? Are you out of your parent's garage yet? Is there a a Russ Hanneman on board (we'll let you know)? And yes, we will parse your social media history. The final stage would be you'd need to complete a review and live demonstration to the OAUX and/or the Oracle Cloud MarketPlace team.

Our PaaS4SaaS enablement is already proven in Silicon Valley and in EMEA. Our relationship with the startup community and partner network is a global one and growing all the time.

So, if you’re interested to starting a conversion with us about enablement, then contact us through the usual channels or in the comments below.

Getting values dynamically

Tom Kyte - Sat, 2016-07-02 19:26
Hi, I will pass table_name tabl1 and its primary key value pk=(some value). My requirement is suppose there is table1, its has primary key pk1 and also it has unique keys ak1,ak2 , And its one of unique keys is foreign key to table2, now i require...
Categories: DBA Blogs

Links for 2016-07-01 [del.icio.us]

Categories: DBA Blogs

Count months 15 days record.

Tom Kyte - Sat, 2016-07-02 01:06
Hi, I want to count records from my database table on every month's 15 days count in respect any group by Id. Like : GroupBy_Id Count statDate EndDate 5 15 01-Mar-2016 15-Mar-2016 5 2 16-M...
Categories: DBA Blogs

How to schedule a script in sql developer

Tom Kyte - Sat, 2016-07-02 01:06
Hi; I have tried many ways to schdule an a script using sql developer;But for these scripts those are failed.But those can nicely run using built in oracle sql-plus.i can use the script by using @ sign and with the file name (eg : @filename) Here...
Categories: DBA Blogs

August 3: American Tower International—Oracle HCM Cloud Customer Forum

Linda Fishman Hoyle - Fri, 2016-07-01 18:46

At this Oracle HCM Cloud Customer Forum, Tom Coleman, VP, Compensation, Benefits and HR Technology and Lorri Davy, Director, HR Technology from American Tower will discuss why American Tower decided to move its HR system from Oracle E-Business Suite on-premises to the Oracle HCM Cloud. They will talk about how this move is transforming the business for American Tower's 3,400 employees in 13 countries around the world.

Register now to attend the live Forum on Wednesday, August 3, 2016, at 9:00 a.m. PDT and learn more about American Tower International’s experience with Oracle HCM Cloud.

New OA Framework 12.2 Update 4 Now Available

Steven Chan - Fri, 2016-07-01 18:26

Web-based content in Oracle E-Business Suite 12 runs on the Oracle Application Framework (OAF or "OA Framework") user interface libraries and infrastructure.   Since the release of Oracle E-Business Suite 12.2 in 2013, we have released several cumulative updates to Oracle Application Framework to fix performance, security, and stability issues. 

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

The latest OAF update is now available:

EBS 12.2.5 Bundle Patch 4

Where is the documentation for this update?

Instructions for installing this OAF Release Update Pack are here:

Who should apply this patch?

All EBS 12.2 users should apply this patch.  Future OAF patches for EBS 12.2 will require this patch as a prerequisite. 

What's new in this update?

Fixes are included for following critical issues:

  • Users intermittently getting FND_SESSION_MGR_INST_ERROR. On session timeout, clicking on any responsibility on the homepage throws error "Error while invoking main menu: Application: FND, Message Name:FND_SESSION_MGR_INST_ERROR.
  • Spacing and alignment issues for read only message Choice and text areas.
  • JAWS is not reading the confirmation message which appears after adding an attachment inline, successfully.
  • When the query string of a view object is modified in the controller to remove unused where clause parameter conditions, using 'export' results in an exception.
  • Reverted fix which enabled caching of errors for beans on which server validation was disabled.

This Bundle Patch requires the R12.ATG_PF.C.Delta.5 Release Update Pack as a mandatory prerequisite.

Related Articles

Categories: APPS Blogs

Oracle SOA: Using Sensors on Optional Elements

Jan Kettenis - Fri, 2016-07-01 10:36
In this posting I describe an issue you may run into when configuring composite sensors on optional elements, and why it is good practice to always add a filter that checks if the element is actually present.

If you define a sensor on a composite to record elements that are optional, you may find an error in the logs similar to the below:

If that is the case you probably have a composite that takes a request with one or more optional elements, of which one or more are not provided, which then is transformed by an XSLT. I have only seen it in combination with a Mediator, but don't know if it would happen in case of BPEL or BPM as well.

For some reason (a product limitation, if not a bug) it will try to store the sensor with a null value, which will result in the above error. You will not see the error when the input is being mapped using XPath, as then it will not try to store the sensor.

To make it always work, the solution is to add a filter on the value to make it only store the value if the element is actually there. I will now explain how to do that.

Let's assume you have a payload like this:

If you want a sensor on the secondElement, you can add a sensor by right-mouse clicking the service and choose Configure Sensors:

For this optional element you should configure it as follows:

It may look a bit like overkill to always do it, but then again if you do it right away, you no longer have to worry about it later, as it will always work, XSLT or not. 

Rename your Weblogic 12c AdminServer

Darwin IT - Fri, 2016-07-01 08:55
At one of my customers we create Service Bus Weblogic Domains using a script, driven by a property file. But in one of the environments we encountered that the AdminServer was accidently called 'Adminserver', with a lower-case 's'. Now this is a very minor issue, but the administrator would like to have it fixed, since it is an anomaly regarding with other environments.

This week I got to implement my start-stop scripts (which I will publish later) and so bumbed into this naming fault again.

Renaming it turns out to be walk in the park. So let me show you how I did it. Most of the steps could easily be done in a WLST script, but I trust this is not something you would do on a regular basis, so we do it just in off-line commandline mode.

Before doing anything from the steps below, first shutdown the complete domain, all the weblogic servers, including the AdminServer. And I should advice: backup your domain. This can easily be done by zipping the domain folder.

Then set the fmw environment, that is most conveniently done using a script. The one I always create on a new environment is fmw12c_env.sh:

echo set Fusion MiddleWare 12cR2 environment
export FMW_HOME=/u01/app/oracle/fmw12c2

export SOA_HOME=$FMW_HOME/soa
export OSB_HOME=$FMW_HOME/osb
export MFT_HOME=$FMW_HOME/mft
echo call setWLSEnv.sh
. $FMW_HOME/wlserver/server/bin/setWLSEnv.sh
export PATH=$FMW_HOME/oracle_common/common/bin:$WL_HOME/common/bin/:$WL_HOME/server/bin:$PATH

Under Linux you should run this as:
$ . ./fm12c_env.sh

It is important to add the dot in front of the command, to have the settings exported to the calling session. I trust that if you're on windows, you'd be able to create a .bat/.cmd file out of this.

The script put's wlst.sh/.cmd in the path. Start it, which brings you to a prompt like:

In the offline mode, read the domain first with:
wls:/offline> readDomain('/u01/app/work/domains/osb_domain')
Where '/u01/app/work/domains/osb_domain' is the path to the domain.
Navigate to the Servers node:
wls:/offline/osbo3_domain>cd ('/Servers')
drw- Adminserver
drw- osb_server1
Then navigate to the Adminserver (you could have done that immediately, but you might want to check on your servers first):
wls:/offline/osbo3_domain/Server>cd ('Adminserver')

For the wlst novice: you might have discovered by now that we navigate through (cd()) and introspect (ls())the MBean-hierarchy using filesystem-related commands. The current folder is actually the current MBean at hand, also called the 'Current Managed Object', in short 'cmo'.
So now we're at it, change its name, for instance:
To have this change effect you need to write/save/update the domain:

After that you can quit wlst using the 'exit()' command.

There is still one little issue to solve, before being able to start the AdminServer and the rest of the domain.

In most cases the nodemanager uses the startWebLogic.sh command to start the domain. This one calls the setDomainEnv.sh/.cmd script.

When no Servername is provided as the start parameter, the AdminServer is assumed to be started.
This is evaluated in the setDomainEnv.sh/.cmd in the following lines:
if [ "${SERVER_NAME}" = "" ] ; then

So edit the file, locate the lines and change the line 'SERVER_NAME="Adminserver"' to 'SERVER_NAME="AdminServer"' (or the name you used in change the server to).

In this same file, setDomainEnv.sh/.cmd, you might want to disable the start of the Derby Java Database server.
Locate the lines
# Set DERBY_FLAG, if derby is available.

if [ "${DERBY_FLAG}" = "" ] ; then
if [ -f ${WL_HOME}/common/derby/lib/derby.jar ] ; then
And add the following lines just before the 'if':

To be able to start the renamed AdminServer you also might want to move the folder named 'security' from the ${DomainHome}/servers/Adminserver folder (the server folder with the previous name) to the corresponding folder with a new name. This allows the renamed server to reuse the boot.properties file. And remove the old folder, or rename the server folder to the new name.

This concludes the renaming-steps. Now you're good to go to startup the domain again.

SQL Server 2016 TCO

Tom Kyte - Fri, 2016-07-01 07:06
Team, i was going through this link. https://blogs.technet.microsoft.com/dataplatforminsider/2016/06/01/sql-server-2016-is-generally-available-today/ Comparing the cost of SQL Server 2016 with Oracle 12c, Oracle cost 12x more. We know Ora...
Categories: DBA Blogs

Block user account to PRIMARY production server and move them to the REPORTING STANDBY Db.

Tom Kyte - Fri, 2016-07-01 07:06
We are planning to all our Business users to use our read only Active data guard standby database and restrict them using the Primary production database using logon trigger. But as part of security, users have to change their passwords every 60 ...
Categories: DBA Blogs

How to validate the XML data exists in the XML table

Tom Kyte - Fri, 2016-07-01 07:06
Hi Tom, Can you please help me on how to validate the XML data available in the XML table. I have one XML table as: CREATE TABLE TEST_XML OF XMLTYPE XMLTYPE STORE AS SECUREFILE BINARY XML; And the data as: INSERT INTO TEST_XM...
Categories: DBA Blogs

Would there be a better way of improving the performance?

Tom Kyte - Fri, 2016-07-01 07:06
I have a code as shown. Objective of this piece of code is to give a report on counts for student enrollments, student absences and percentage present in the district starting from the first day of school up until the last day (i.e. a total of 18...
Categories: DBA Blogs

Number filtering from Oracle with Decimal

Tom Kyte - Fri, 2016-07-01 07:06
Hi Team, We had a situation where the customer is pulling a report from a table. This table has a number format as number (5,2) . They have a value 9 and also its updating another value as 9.00 while selecting it from the table if we use to_char(n,9...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator