Valuable is the taste for art, ye, man of vision/span>

But vision that perceives not the Reality, is useless.

The goal of art is the flame of immortal life

 Not this fleeting breath transitory like the spark.


A platform where I share my Oracle experiences and learning’s. It’s also to rumble about my feelings on various oracle related stuff.

Intellect reigns over all beings of clay and light
Nothing is beyond the reach of God-given mind
The entire world bows to its eternal glory
The heart alone challenges its sway at every step.“(Dr. Sir Mohammad Iqbal)

Intellect gives power, but this power can be utilized constructively for the good of humanity only if it is guided and controlled by Love. This Love is not a mere vague humanitarian sentiment. It is an active force which gives a quality to Individuality when it is pressed into the service of worthy ends.

I dedicate this website to MY LUCKY CHARM,Oracle Experiments, Interviews & Practices.

The complexities of database administration are often an ongoing challenge for DBA’s. While leveraging on the live practical practices, the site supports to take care of database administration tasks ranging from mundane work to specialized solutions like DataGaurd & RAC.

My website is a sincere & humble effort cum initiative for providing self help to students, professionals who really want to enhance their skills in Oracle Database, with special emphasis to the Administration part. The ultimate aim & motive behind this initiative has been the impediments, difficulties which I had faced when I ventured out to try my hands at Oracle DB Administration.

Though I could find loads of information available out on the www, yet didn’t find much of them handy as they didn’t give importance to the fact that many professionals in particular newbie’s require in particular point of time. They always look for detailed step by step explanation of each activity. It was challenging cum tedious process, which made me think to come up with a simple and straight forward articles which will serve as a kind of “do it yourself” guide for all those who want to venture out to the galaxy of Oracle DB Administration. The topics, strategies, articles or issue I discuss here are much self explanatory because of SCREEN SHOT ARSENAL, I mostly keep intact with to offer the tailored and best solutions.

My knowledge of current technologies particularly RAC database administration, DR Implementation coupled with my managerial skills make me an effective professional. Working with new technology and the challenge of resolving a difficult problem is what keeps me going.

My practical expertise & dedicated work with combination of aesthetic and user-friendly approach shall help all the professional to benefit at large from this site.
With the world becoming more competitive day by day, I stand by your side offering complete Step by step solutions that can help you seamlessly scale up your competencies.
The site offers maximum practical information and mostly does a fair presentation using snapshots of practical work.  I at strive and endeavor to give my best. I look forward to servicing your requirements both now and in the coming years.

Your comments and suggestions are always welcome! Your feedback will help us serve you better.


www.ORACLE-CKPT.comDiscover whats possible.

You can Subscribe Here.

Website Comments

  1. firdous

    I am sure this website will give good technical information to those who want to build new techniques as Oracle Dba’s.. Good piece of work

  2. Vikranth

    Job well done. Keep up the good work. You are the guy who is not just learning Oracle but you are living with Oracle. Congratulations once again!!!!.
    And I will give contribution from my side as well.

  3. neeraj

    Hello CKPT
    Today ,while googling , i found this site. As i read the URL only the thing comes in my mind is that this is CKPT of OTN (99% guess). When , on explore this site then i found it’s you only . I am your one of the follower . I like the way you reply on OTN and your answer to the point . As far this site is concerned , It is very useful site in all the way . I wish you a very good time ahead ..
    God Bless You
    Neeraj Vishen

  4. S. Firdous

    I congratulate you for this efforts you put in to bring some comfort for oracle professional in their daily work.
    This is something really encouraging and appreciating… I wish you all the best of luck in your future endeavours

  5. meetdileep

    Congratulations Basha… Every one shall really appreciate your efforts for sharing the knowledge… Keep it up.

  6. Glen Schimmels

    I anticipate a tremendous amount of knowledge, dialogue and expertise will be shared here. Excellent choice for the name as well, I like it. I know you will enjoy every minute of it and am sure when people see the great information that will be found here you will have quite a following.

  7. Abdul

    Great effort, superb way of mentoring, delicious tips, supercalifragilisticexpialidocious art of knowledge sharing.
    Keep it up, God bless you!!

    😛 A CKPT is the act of flushing modified, cached database blocks to disk. Normally,
    when you make a change to a block — the modifications of that block are made to a memory
    copy of the block. When you commit — the block is not written (but the REDO LOG is —
    that makes it so we can “replay” your transaction in the event of a failure).
    Eventually, the system will checkpoint your modified blocks to disk.

    • Nassyam Basha

      Thanks, Its still a long road map. Any suggestions/comments are always welcome.
      Good explanation on “CKPT”, BTW i started using this name i guess from 1.5 or 2 years hardly. earlier it was casual name. Why CKPT? — I feel superior Background process which plays big role(not sure) :p

  8. ateeqrahman786

    basha bhai, gud work, luking forward for more interesting problems-solutions. could you please email me a script to find size of all tablespaces on daily basis, so that i can store them i excel and compare @ end of the month., win 2008 srv

    Best Regards,

  9. nazia

    Assalamualaikum wrwb,
    The info u provide for the one’s who are beginners like me is awesome.Please do post more on administration and Data Guard topics. your work is much appreciated.:). Thanks in advance.

    • Nassyam Basha

      Thanks and I will try add more and more contents and articles as much as possible. Don’t say beginners. Remember that each day is learning and something new. 🙂

  10. Madhu

    Hi Nassyam
    Can you please post the procedure to build datagaurd for the below setup?
    Primary: 2-Node RAC, ver (Traditional DB, non cdb), ASM, local listener: 1608
    Standby: Stand alone, w/ Oracle restart, ASM

    This is Madhu from Ravi’s class

  11. Madhu

    In addition to the above request, Our scenario uses DB_UNIQUE_NAME for 2-node RAC as HPROD1.
    Standby (standalone) database as HPROD2

  12. Rafiq

    Superb efforts bhai, hope it will be grate platform to share the knowledge.

  13. Anbumani Ganesan

    Hi Brother,

    Greetings. Anbumani from Chennai, hope you remember few time we met in Chennai chapter.
    Whenever i got challenge in my DBA career, your content is helping me a lot. Thanks a lot.


Leave a Reply to meetdileep Cancel reply