I'd like to mention a small peace of software. It's called MrTrace and available in Version 2.0.0.43 right now. For me it's a tool to save time. So what is it doing at all?MrTrace is a plugin for Oracles SQL Developer to access ...
The Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS) produced and marketed by Oracle Corporation.
-
-
Regsiter for BIG Data online Forum
There will be an online forum with interesting sessions on BIG Data at February 16th. If you’re interested on Big Data, don’t miss it. Here’s the registration link: https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=388878&sessionid=1&key=4FEDBC21F62A9834AAE0B109EBBFC918&partnerref=exadata_email1_Jan_Bigdata&sourcepage=register
-
Concurrent Managers Health Tip #1 – Rebuild your indexes!
This is really a simple one and you would be surprised how manycompanies large and small overlook this.I have seen examples of sites with over 50 million rows inthe fnd_concurrent_requests_u1 indexes; a hugewaste of space! More importantly however is the problem of poor performance insuch a core OEBS activity ...
-
Login operation failed in Grid Control
Today, when I was trying to connect to the OEM Grid Control, I got “Login operation failed” error The first file to be checked are the log and trace files at Grid side. So I checked emoms.trc and emoms.log files under $OMS_HOME/sysman/log and didn’t find ...
-
Setting Up Oracle Connection Manager (without SOURCE_ROUTE)
This post must be seen as a direct follow up to Arup Nandas Setting Up Oracle Connection Manager.As there are many references to this post, please read it first. Problem and Solution are quite similar, only the architecture is a little bit different:The Architecture The network diagram of ...
-
Turning off Code Completion in SQLDeveloper – a Grumpy Old Man Fights Back
“You’re problem is you’re BBC”, a colleague remarked recently. On further investigation, I found this not to be some reference to the British Broadcasting Corporation but rather that I had been “Born Before Computers”. Yes, I grew up – in computing terms at least – on the Command Line. A ...
-
The Future of Financials Applications: Excel
I just completed another great training session held by the Oracle User Experience (UX) team. I am privileged to be part of the Oracle Fusion User Experience Advocates team, so Oracle is putting a lot of effort into teaching us about Fusion UX. One of the topics was the new ...
-
Exadata database server Drive Configuration Verification
To verify the database server physical drive configuration, use the following command: /opt/MegaRAID/MegaCli/MegaCli64 PDList -aALL | grep "Firmware state" The output should be similar to for the disks: Firmware state: Online, Spun Up To verify the database server virtual drive configuration, use the following command: /opt/MegaRAID/MegaCli ...
-
Desaster Recovery in the cloud, Part 2
In Part 1 we talked about some general requirements for setting up a simple-to-use disaster recovery solution for Oracle databases. Today, I built up the same inside the Amazon cloud, using different data centers in order to build up a robust DR solution. I used Amazon’s EC2 (Elastic Compute ...
-
OBIEE 11g: Where's the Compare Repositories Dialog?
Recently I decided to try out the new patching capabilities for the metadata in OBIEE 11g. The big reason for me was to avoid having to reset my connection pools. Each time I did a 3 way merge, the connection pools would get over-written with their development credentials. When I ...