Subscribe to Posts by Email

Subscriber Count

    696

Disclaimer

All information is offered in good faith and in the hope that it may be of use for educational purpose and for Database community purpose, but is not guaranteed to be correct, up to date or suitable for any particular purpose. db.geeksinsight.com accepts no liability in respect of this information or its use. This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content and if notify any such I am happy to remove. Product and company names mentioned in this website may be the trademarks of their respective owners and published here for informational purpose only. This is my personal blog. The views expressed on these pages are mine and learnt from other blogs and bloggers and to enhance and support the DBA community and this web blog does not represent the thoughts, intentions, plans or strategies of my current employer nor the Oracle and its affiliates or any other companies. And this website does not offer or take profit for providing these content and this is purely non-profit and for educational purpose only. If you see any issues with Content and copy write issues, I am happy to remove if you notify me. Contact Geek DBA Team, via geeksinsights@gmail.com

Pages

Future of DBA – A constant question

In constant pursuit of human race behind technology with all due respect of it this post dedicated to all those of like mine.

Often I (in fact everyone of reading this) am been asked a question , what is future of DBA with cloud, autonomous etc.

Well that’s not for only DBA’s its every where, […]

AIOUG – Hyderabad – Performance Tuning Tech day – 23rd June

Hello All

AIOUG – Hyderabad Chapter announced Performance Tuning Tech Day on 23-June in Hyderabad and I am speaking on SQL Plan Stability & Flexibility Features.

Here is registration Link :- https://www.meraevents.com/event/aioug-hyderabad-oracle-db-performance-tuning-tech-day

And Agenda is as follows, Don’t miss it as the topics covered by speakers will be helpful.

 

 

[…]

SQL Server on Linux

Hello,

Back in Nov 2016, Microsoft has announced SQL Server on Linux and being a Database enthusiast I would like to hands on and see how it works, but I am been busy with some other projects and could not look into it. Last week I had a conversation with one of my peer in […]

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