Subscriber Count

    448

Subscribe2

Pages

Contact for Online learnings
* indicates required field
Thanks for the inquiry. You will be receiving a mail shortly with course details. If not please check the spam folder once and mark our mail as not a spam.

BigData Posts – Update

Hello,

You might be wondering about no posts in my blog. But the fact is am busy learning BigData and praticising and preparing a tutorial content in my new subdomain blog. http://bigdata.db.geeksinsight.com

So far three lessons have been posted on Bigdata Hadoop Fundamentals, if you have missed to see them here are they,

Hadoop Overview […]

Happy New YEAR – Thanks to All.

Howdy,

First of all, ****Many Many THANKS**** to all of my blog readers for the support and continuous encouragement through out the year 2013.

A wonderful year now on the history books as like my posts moves to Archives. I have tried to write as many as I can and that’s again a great learning […]

Difference between object_id and data_object_id from dba_objects

Hello,

I have got two questions from my friend.

1) What is the difference between object_id and data_object_id?

2) Will be there any performance impact if data_object_id changes?

For the question #1,

a) Object_id represents the primary_key or the unique identifier for the object b) data_object_id is the pointer […]

RAC: Timezone differences in CRS and Database logs

Hello All,

We have got an issue about time zone differences in alert logs , crs logs with system timestamp and with system timestamp.

System date time [oracle@TESTRAC1]/ # date Tue Apr 24 04:10:11 CEST 2013

But database Alert log shows,

Thread 1 advanced to log sequence 235 (LGWR switch) Current log# 11 […]

Time to read few good posts from other blogs

Dear Readers,

We have few good posts in Oracle community this week and here are they, and very interesting though

Jonathan Lewis on Systimestamp puzzles:-

systimestamp

Oracle optimizer blog comes up with method_opt parameter significance in dbms_stats

How does the METHOD_OPT parameter work-

Randolf Geist on

ASM AU Size And LMT AUTOALLOCATE

Arup Nanda […]

First & Test post on new site

Hello All,

This is the first post and test post for this new site, if you are encountering any issues with site please drop me an email with issue, will fix it.

For those who enrolled post to email subscription, they should receive this post via email, if not can you please spare sometime […]

Another good blog: Iordon Iotzov’s

Thanks Iordon Iotzov for showing up here and following this blog.

To my blog readers,

Iordon has many good works and posts under his blog and he has recently presented at HOTSOS about confidence on cardinalities/statistics. You can read it here.

http://iiotzov.wordpress.com/2013/03/14/hotsos-symposium-2013/

-Thanks Geek DBA

RAC: Restrict Parallel Query processing to local node only

When a query is issued against an Oracle Real Application Clusters (Oracle RAC) database with multiple nodes, the parallel processes may be spawned on different nodes. This approach is used to ensure that no one node becomes overloaded and that the processing power of all nodes is utilized as efficiently as possible.

However, under certain […]

Quick Question: Check for performance issues

Updated answers

Thank you! Merry Christmas & Happy New Year

Hello All,

My best wishes for Christmas and upcoming new year to you all!

This year has been very promising to me via this blog which earned me a lot of good friends and fellow DBA’s, indeed I have a learnt a lot too via this channel.

I recognized that the journey of this blog […]