I am currently working in a team alongside a gentleman known as Roberto Rigliaco. You are unlikely to have heard of Roberto as he is not (yet) a blogger and not (yet) known on the conference circuit.
Nevertheless, Roberto has done some excellent work recently analyzing the use of object statistics in partitioned tables. I haven’t seen his findings published anywhere else and so I am glad to say that Roberto has accepted my offer (more...)
Ever deleted or changed something by accident in your application and wished you could get it back?
You can! The oracle database has a feature called flashback, and APEX can take advantage of this feature. (Flashback needs to be enabled on the database, if you are not sure if it is enabled on your database, you can always ask your DBA).
Today I will show you some of the different places, where you can (more...)
The EM agent’s scheduled activities can be listed using emctl status agent scheduler, like this:
You’ll see a regular cycle of Response calls (anybody home?), metric uploads, and heartbeats.
As of August 1, 2015, Google promoted Fishbowl Solutions to Premier Partner status! This elevation is a testament to our commitment to selling and servicing Google Search Solutions, and we are very excited to be counted among the select companies to attain this level of partnership. Kim Negaard, the Google Product Manager at Fishbowl, took some time to talk about our history with Google and what being a Premier Partner means.
The post Fishbowl (more...)
There is quite a debate going around based on Simon’s linkedin post regarding the future of Forms; but when you read it you’ll see, he doesn’t actually talk about the future of Forms – he talks about the demise of Forms and its replacement with Oracle APEX. As someone who does believe in the future of forms, there are several things I wanted to clarify.
Firstly, it mentions that despite the release of Oracle Forms 12c, Oracle (more...)
Just like everything else in Enterprise Manager, an Exadata is a target and all of its components are targets. All of these pieces can be removed through the 12c console.
Select Exadata from the bottom of the main Targets drop-down to display a list of Database Machines in your environment. Highlight the row containing the subject machine and press the Big Red X to take you into the detail page.
The left panel shows you the (more...)
Recently, a colleague of mine had some problems with pinning application procedures into the shared pool. His database was upgraded to RAC and he wanted to pin the application procedures and packages into shared pool upon the database startup.
The non-RAC version of the database was using a shell script, something like $ORACLE_HOME/local/scripts/pin_procs.sh in the script that was starting DB when the system was booted
However, RAC starts the database automatically and no user (more...)
Mainly: You do not want to pick the tool that’s hot this year.
(picture from blog above)
The reason is that choosing this year’s hot framework is an unnecessary leap of faith that places your project at risk. What happens if you choose wrong? You’ll watch your application (more...)
dbms_redefinition actually is a nifty, but powerful little toolkit that let’s you change table-definitions without actually locking the table in such a manner that it would prevent regular operations from being interrupted.
You can read loads about it in the Oracle documentation or in the wealthy library by Mr. Tim Hall.
One thing I noticed, and which I want to share here has lots to do with the house keeping that is automatically done by (more...)
If a full /tmp directory is blocking you from running an installer script, try this:
I’ve just been troubleshooting an ADF application that ran fine on one environment and not on another. After some searching, I discovered that a script had not been run on one of the environments so the database was different.
That reminded me of a simple database check that I often include in my applications: I simply calculate a hash value of all tables and views with an SQL statement like this:
Last week I had the pleasure of presenting at the New Jersey Government Oracle User Group (NJOUG).
It was incredible to see such a dedicated group of people; almost 50 people came out just from the government to hear all different types of topics with regards to database, middleware, etc.
I was actually asked to speak on a range of topics to basically map out what I see as the future for Oracle Forms from (more...)
I finished the installation of 12c cluster and noticed that I haven’t been asked for voting and registry devices as was previously the case. I had to create a single disk group. John Franklin, from LinkedIn RAC SIG suggested running ocrcheck command, so I did:
[grid@rac1 ~]$ ocrcheck -details
Status of Oracle Cluster Registry is as follows :
Version : 4
Total space (kbytes) : 409568
Used space (kbytes) : 1612
Available space (kbytes) : (more...)
I installed my first 12c ASM (database is still 184.108.40.206) and I made the 11G disk layout: 2GB for voting/quorum, 2 GB for OCR. However, the installation procedure did not ask me for the voting and OCR devices. ASM came right up without them. So, the devices are not needed for 12c? What about upgrading from 11g, which did need the devices? The “crsctl” utility confirms that voting and OCR devices are (more...)
In my previous post, I looked at non shared latches and how the latching is done by Oracle. This post is a description on how the latching works for shared latches.
The information is quite internal, if you landed on this page it might be a good idea to start with my first post on this topic: first post.
A famous example for shared latches is the ‘cache buffers chains’ latch.
For the sake (more...)
Oracle DBAs who are so old that they remember the days before Oracle 11.2 probably remember the tuning efforts for latches. I can still recall the latch number for cache buffers chains from the top of my head: number 98. In the older days this was another number, 157.
But it seems latches have become less of a problem in the modern days of Oracle 11.2 and higher. Still, when I generate heavy (more...)
Oracle Application Express 5.0.1 is now released and available for download. If you wish to download the full release of Oracle Application Express 5.0.1, you can get it from the Downloads page on OTN. If you have Oracle APEX 5.0.0 … Continue reading
Consolidating identity information in Oracle Identity Manager
In part 1 one this article we saw several options for managing identities in an environment where multiple sources for identity information are used. In this part, you’ll find more information on how to set up Oracle Identity Manager in a scenario like the one described in the Swift&Safe Inc. use case.
First of all, the identities based on the input from CUST1 will be placed in dedicated (more...)