As of today, you can download this free tool out of our Enkitec‘s web page. Just select “eAdam” under the Products Tab.
The next version of eAdam will incorporate the GV$views, equivalent to the currently extracted DBA_HIST set. The reason of this enhancement is to handle read-only databases (DataGuard – DG). So views like GV$ACTIVE_SESSION_HISTORY will be available for data mining within the eAdam staging repository.
Any ways, I hope you enjoy this new (more...)
OTN have published over 100 photos of the tour on Facebook and one comment about seeing Tim Hall with all his fans. I was simply jealous, all these people would queue up to speak to him and many wanted their photo taken with him. I tease Tim about this but the reality is people look up to those they follow, be it business, TV, film or any other celebrity.
I am not knocking this, Tim has (more...)
We had a 8 node RAC cluster that was showing evidence of connections timing out. The following AWR report segments indicates a high level of login activity and blocking on the AUD$ table and segments.
None of it conclusive but what was the kicker was the fact that the aud$ table was still in the system tablespace which is manually managed and therefore automatic segment space management is not coming into play.
Over a 24 (more...)
In big projects hopefully testing the components of the system is a key point. When multiple teams are working on a project and each create services in there functional domain, you want the place the responsibility of these services with that software development team (SDT). Let’s talk in terms of a assembly line. If one team needs to integrate with a service of another team it should not have to wait for (more...)
photo by Jesus Solana
DBAs were cutting edge once upon a time. DBAs protected the company jewels and made sure the company’s data was secure, fast and dependable. DBAs discovered new ways to tune databases, exposed how internals worked, architected and proved optimal database designs. Now that so much information and knowledge has been created , documented, and automated, it seems that DBA work is becoming more and more commoditized. The DBA use to be (more...)
Editor’s note: Another cross-post from VoX, this one from Julian Orr. User experience works best when you understand your users. So, help us understand you and your mobile strategy by completing this painless and fun questionnaire.
What is your perspective on enterprise mobility? Tell us!
By Julian Orr, Oracle Applications User Experience
Is there a certain device capability, such as the ability to capture mobile signatures or remotely wipe a device, that is so (more...)
Big Data Oracle NoSQL in No Time - Getting Started Part 1
The below procedure will startup and shutdown the 4 node Oracle NoSQL Cluster.
nohup java -jar $KVHOME/lib/kvstore.jar start -root $KVBASE/server1/storage &
nohup java -jar $KVHOME/lib/kvstore.jar start -root $KVBASE/server2/storage &
nohup java -jar (more...)
Of course RMAN is primarily used for backup and recovery operations, but sometimes I need to run SQL commands: so in 11g or lower I have to open another terminal/tab or quit the current RMAN session and start a new one with sqlplus.
In Oracle Database 12c instead most of the sql (more...)
Here are the slides of some of my previous presentations (that I haven’t made public yet, other than delivering these at conferences and training sessions):
Scripts and Tools That Make Your Life Easier and Help to Troubleshoot Better:
- I delivered this presentation at the Hotsos Symposium Training Day in year 2010:
Troubleshooting Complex Performance Issues – Part1:
Troubleshooting Complex Performance Issues – Part2
Again and again, I’ve seen significant decisions made based on defective reasoning. One of the most common errors is the fallacy of the converse – the belief that if A leads to B, and B happened, then A must have happened.
I’ll talk more about (more...)
This time I will note procedure in form of the blog post.
Test is performed on Oracle version 184.108.40.206.
These were my unsuccessful attempts:
3> allocate channel c1 device type 'sbt_tape';
4> send 'NSR_ENV=(NSR_SERVER=backup_server,NSR_CLIENT=oracle_client,NSR_DATA_VOLUME=OrclPool)';
5> catalog backuppiece 'ARCH_ORCL_rep2dod5_s128878_p1';
"Is there a sizing/capacity/scalability guide available for APEX?"
After the success of the APEX Mobile Webinar I was really excited to conduct the second part of the ODTUG series: Strategies for Running Oracle Forms on Mobile Devices and Tablets. This webinar, presented with Oracle’s Product Manager Denis Tyrell, was also a big success; we were so glad to see many participants who are running legacy applications that are ready to modernize!
In the webinar, we be explored strategies for mobilizing legacy applications with (more...)
After a Tanel Poder pointed out to me that someone had blogged my article verbatim, which I don’t really care about, but they had copied the article verbatim without crediting me, which I do care about, I decided I’d just re-blog this. The article is best formatted at link:http://tinyurl.com/ybyjazq
Waits on the cache buffer chains latch, ie the wait event “latch: cache buffers chains” happen when there is extremely high and concurrent access to the (more...)
To quickly re-set the table, my organization purchased the Oracle ZFS Storage Appliance (ZFSSA) 7420. Oracle sold us on the Infiniband connectivity as a way to make a possible future transition to Exadata easier. However the pre-sales (more...)
Bobby Durrett just put together a great little post on “outer joins : where do I put the (+)“.
I also have hard time remembering, and below is my cheat sheet using graphics.
If English and French both have a unique key on the “ordinal_id” then it’s basically one-to-one relationship
We add an arrow in the middle of the line to denote “outer join”. The arrow points from the table that drives (more...)