Author Archives: Hanganalyze

Why you should, and should not, worry about the new era of inteligent databases

These days I fell like an terminator movie, with Ciberdyne working really hard to make Skynet a cient being – to become inteligent. We all know that some activities are a best fit to automation, reason why we spend hours … Continue reading

Posted in database, mindset | Tagged | Leave a comment

The infamous jdbc closed connection

Sometimes you, as an DBA, is blamed for everything. The database is slow, unavailable, unpatched, and the list goes on and on. Sometimes, in rare situations, you can prove then wrong 😀 Last week we have been called to analyze … Continue reading

Posted in database, Troubleshooting | Tagged , | Leave a comment

12cR1 + Suse 12 SP2 = take a look on this post

Today I face a weird issue during a HAS 12.1.0.2 in Suse 12 SP2 for a customer. Everything went smooth during the runInstaller, but roothas.pl failed with the follow error: SERVER_BLA:/u01/grid/12.1.0.2 # /u01/grid/12.1.0.2/perl/bin/perl -I/u01/grid/12.1.0.2/perl/lib -I/u01/grid/12.1.0.2/crs/install /u01/grid/12.1.0.2/crs/install/roothas.pl Using configuration parameter file: … Continue reading

Posted in database, Installation, Sem categoria | Tagged , , , | Leave a comment

db_multiblock_read_count – to be or not to be?

Sometimes you wanna to use things with default options…and sometimes the default is not good enough. We all know that db_file_multiblock_read_count is bumped by default on startup, usually you get 128 blocks per read. Why? From Oracle documentation, this value … Continue reading

Posted in Performance, Troubleshooting | Tagged , , | Leave a comment

A good starting point on DevOps culture

Hello there! Hope this article find you well. Sometimes the new stuff seems to be full of dark places and complexities. When you find a book, a link, a song, a magazine article that lights the path, is always a … Continue reading

Posted in DevOps | Tagged , | Leave a comment

To be or not to be (lazy)

Sometimes you are an Oracle DBA just tired of perform setup ( I like to install everything from scratch…since oracle 7.3 it was always an adventure for me 🙂 ) If you only want to download and have fun on … Continue reading

Posted in database, New Features 12c | Tagged , , , | Leave a comment

12.2 on-prem available for download

Finally 🙂 We will post shortly about some cool new features – like online move for non partitioned tables, sharding, v$index_usage_info and more! See you around!  

Posted in Installation, New Features 12c | Tagged , , | 1 Comment

Using oradebug – 10053 and 10046 events

Hello There! Hope this article finds you well. Today we will talk about oradebug, this little wonder in oracle, and how to set the 10046 and 10053 events to troubleshoot performance. First of all, what is oradebug? Oradebug is a … Continue reading

Posted in Performance, Troubleshooting | Tagged , , , , | Leave a comment