Tag Archives: database

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

12c Upgrade Exam – 1z0-060

Today we will describe some impressions aboutĀ 1z0-060 exam. So, for get success in exam, you need: Study hard on 12c architecture (CDB / PDB): how to start/ stop, create, drop, secure, etc. Do notĀ believe on dumps answers. We recommend to … Continue reading

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

First impression on 12cR2 database install

Today I’ll describe my first impressions on install the new 12cR2 (available for premises on march 2017) for linux and Solaris. Inicially I felt a little bit strange because there are only one file for database and only one for … Continue reading

Posted in database, New Features 12c, oracle | Tagged , , | 1 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

Why and Why not use table recover – Oracle 12c

Today will gonna discuss about RMAN table recovery, one of new features of Oracle 12c and my personal view of this feature. Official documentation you could foundĀ here. Basically RMAN use the mecanism of Point in Time recovery and automates the … Continue reading

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