view counter

Database Feed

Oracle Database, Oracle 10g, Oracle 11g, Oracle XE, Oracle RAC, Oracle Instant Client, Oracle Data Guard and Oracle Exadata resources, news, and support articles.

My Perl Worklist for 2011

The Holiday Season was a very Perlish one for me. With two weeks’ worth of vacation time, and my mother-in-law visiting, I had plenty of time to sit down, leasurely sip some hot cocoa and hack my merry little heart away. Net result: four new/updated modules (Catalyst::Plugin::VersionedURI, Dist::Zilla::PluginBundle::YANICK, Dancer::Template::Mason and XML::XSS) and six seven blog [...]

What was wrong?

This is a tiny quiz like post, to see how people diagnose to sort the problem/problems here

This is when I check around 11:30Am on 27th (please open it from “view source button” to see better- button appears right hand side when you go over the code)

Retrieving Database SID,Port information from Grid Control repository

This is short posting on sql which can be used to get Hotsname,SID,Port information for databases registered in Grid Control repository. This information can be  used to create a tns entries and we can further use it to run a sql on all these databases. set pages 999 lines 200 col host for a50 col [...]

Theorems Regarding Business Logic

In yesterday's Rigorous Definition of Business Logic, we saw that
business logic can be defined in four orders:

IO Read Wait Occurrence Mismatch - Part 2

In Part 1 of this series, it was clearly demonstrated the number of IO read requests is not likely to equal the number of wait event IO read occurrences. This concerned me.

Prepared Quizzes, How Would You Answer that Question? 1

January 4, 2011 (Forward to the Next Post in the Series) While performing a Google search I encountered a couple of Oracle multiple choice quizzes that also supplied justifications for the answer that is described on the page as being correct.  The web pages I found reminded me a bit of some of the quizzes that I [...]

oradebug Man ^ ^

This topic is not mean special like movie topic or something else. I'm just curious on my DBA style, maybe it is wrong style, or the situation made me to do like that. When the Oracle Database has the issue and need to investigate... we will check from waited events and etc. If we have Enterprise Manager, that's easy way to help.
If not, we may find session id, that we interest... and then use dbms_support or dbms_monitor to trace.

Database smart flash cache wait events

When you enable the database smart flash cache and start using it you will see new wait events related to that. These events help to find out if the problem is about the flash cache or not.

The ones I faced till now are "db flash cache single block physical read", "db flash cache multiblock physical read" and "write complete waits: flash cache". These are from a 11.2.0.1 database using the F5100 flash array as the database smart flash cache.

2010 in review

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers A helper monkey made this abstract painting, inspired by your stats. The Louvre Museum has 8.5 million visitors per year. This blog was viewed [...]

view counter