Great videos on Oracle Real World Performance.
Building a hybrid application with Mobile Application Framework and WebCenter Portal by Yannick Ongena
With the release of the Mobile Application Framework it makes sense to look into building a hybrid application that integrates assets from WebCenter into a native application. This will reduce the development cost (build once, reuse multiple times) and simplifies management. WebCenter Portal provides functionality to target specific pages to specific mobile devices. By doing so, we can build pages that are designed to be consumed in a native application.
By doing so, you (more...)
We continue to release updates to EBS 12.2 technology stack (TXK) and Applications Database (AD) components based on customer feedback. We released the first set of updates in March 2014, the second set in May 2014, the third set in July 2014, and have now made available a fourth set of critical updates.
If you are on Oracle E-Business Suite Release 12.2, we strongly recommend that you apply these two (more...)
Oracle is pleased to announce that the Oracle StorageTek T10000D Tape Drive (Firmware version: 4.07.107 and Hardware Part Number: 7042136) has achieved a FIPS 140-2 validation with overall compliance at Level 1 of the FIPS standard. Conformance with the FIPS 140-2 standard provides assurance to government and industry purchasers that products are correctly implementing cryptographic functions as the FIPS 140-2 standard specifies.
FIPS 140-2 is a public sector procurement requirement in both the (more...)
Top Three Reasons to Use an In-Memory Data Grid
Date: Wednesday, October 29, 2014
Time: 10:00 AM PDT
As data volumes and customer expectations increase—driven by social, mobile, and cloud devices—so does the need to manage more data, often in real time. Companies facing this challenge benefit from the in-memory data grid technology of Oracle Coherence due to its ability to offload overburdened databases and shared data services and provide real-time data updates to applications. (more...)
However we ran into one problem the other week. I noticed that the test3 database was still in physical standby (more...)
A recent question on the OTN forum asked about narrowing down the cause of deadlocks, and this prompted me to set up a little example. Here’s a deadlock graph of a not-quite-standard type:
Deadlock graph: ---------Blocker(s)-------- ---------Waiter(s)--------- Resource Name process session holds waits process session holds waits TX-00040001-000008EC-00000000-00000000 50 249 X 48 9 X TX-000A001F-000008BC-00000000-00000000 48 9 X 50 249 S
My session (the one that dumped the trace file) is 249, and I was blocked (more...)
A couple of very, very basic observations on getting going with 12c Inmemory in a multitenant database.
1. When trying to set inmemory_size within a PDB when inmemory_size is 0 in the CDB
ORA-02096: specified initialization parameter is not modifiable with this option
SQL> alter session set container = cdb$root; Session altered. SQL> select value from v$parameter where name = 'inmemory_size'; VALUE -------------------------------------------------------------------------------- 0 SQL> alter session set container = orcl; Session altered. SQL> alter (more...)
A recent posting on OTN reminded me that I haven’t been poking Oracle 12c very hard to see which defects in reporting execution plans have been fixed. The last time I wrote something about the problem was about 20 minhts ago referencing 188.8.131.52; but there are still oddities and irritations that make the nice easy “first child first” algorithm fail because the “depth” calculated by Oracle doesn’t match the “level” that you would get from (more...)
I spoke at a one day DOUG meeting yesterday. It was pretty cool. Very small intimate group of about 50. The speakers were Nitin Vengurlekar, Charles Kim, Cary Millsap and myself. All are Ace Directors and either work at Viscosity or Enkitec. As a bonus, Tanel Poder showed up to weigh in on some open discussion. Anyway, I thoroughly enjoyed it. I promised the group I would post my slides and a zip file with (more...)
Here’s a question that appeared in my email a few days ago:
Based on the formula: “sreadtim = ioseektim + db_block_size/iotrfrspeed” sreadtim should always bigger than ioseektim.
But I just did a query on my system, find it otherwise, get confused,
SQL> SELECT * FROM SYS.AUX_STATS$;< SNAME PNAME PVAL1 PVAL2 ------------------------------ ------------------------------ ---------- -------------------- SYSSTATS_INFO STATUS COMPLETED SYSSTATS_INFO DSTART 10-08-2014 10:45 SYSSTATS_INFO DSTOP 10-10-2014 10:42 SYSSTATS_INFO FLAGS 1 SYSSTATS_MAIN CPUSPEEDNW 680.062427 SYSSTATS_MAIN (more...)
Some time back, I posted a blog entry about Metering and Chargeback in Enterprise Manager, where I covered the basic capabilities of the Chargeback Application. It’s taken me some time to get back to the promised followup blog post on setting up Chargeback, what with Oracle Open World getting in the way of things, but that’s what I’m finally doing now.
Chargeback can be setup in EM12c by any user with the EM_CBA_ADMIN role, or (more...)
I previously wrote that I peeped the idea about showing the session information in terminal title from Timur Akhmadeev’s screenshots, and Timur wrote:
I’m using (a bit modified) Tanel Poder’s login.sql available in his TPT scripts library: http://tech.e2sn.com/oracle-scripts-and-tools
Colored prompt is the one of many features of rlwrap.
Disclaimer: I’m not posting to make me look better, we’ve all written code that we’re later ashamed of, and I’m no different!
This is some code from a system I was maintaining some time ago. I’ve kept it since then because it illustrates a number of things NOT to do:
FUNCTION password_is_valid (in_password IN VARCHAR2) -- do NOT copy this code!!! ... RETURN VARCHAR2 IS l_valid VARCHAR2(1); l_sql VARCHAR2(32000); CURSOR cur_rules IS SELECT REPLACE(sql_expression ,'#PASSWORD#' ,'''' (more...)
Just a quick note to point out that the October PSU was just released. The database has a few more vulnerabilities than usual (31), but they are mostly related to Java and the high CVSS score of 9 only applies to people running Oracle on windows. (On other operating systems, the highest score is 6.5.)
Only two things are really certain: network latency over long distances, and the fact that humanity will soon rapidly degenerate into undead brain-eaters.
When that day comes, when the dead are crowding at your door and the windows are busted out and ripped up rotted arms are clawing at the inside of your home, I know what you’ll be thinking: is my database protected?
Don’t worry, my friends. The Oracle Alchemist has you covered. We (more...)
You all know that when you grant SELECT on a table to a user, they can do a SELECT FOR UPDATE, locking records in the table and preventing other updates or deletes. [Some client tools may do that in the background. ]
Well finally Oracle (more...)
Last week I attended Oracle OpenWorld 2014, and it was an outstanding event filled with great people, awesome sessions, and a few outstanding notable experiences.
Personally I thought the messaging behind the conference itself wasn’t as amazing and upbeat as OpenWorld 2013, but that’s almost to be expected. Last year there was a ton of buzz around the introduction of Oracle 12c, Big Data was a buzzword that people were totally excited (more...)
One of my blog readers asked me to write a sample EMCLI codes to create named credentials for Database. To be able to create a named credential, you need to know the target name (unless you create a global credential), target type and credential type associated with the target type. Let’s say I want to create a named credential for my database named “TESTDB”. First I need to login to our EM12c server, and list (more...)