Infrastructure at your Service

Category

Oracle

Oracle Team

Oracle 12c In-Memory option: waiting for 12.1.0.2

By | Database management, Oracle | 2 Comments

By Franck Pachot . Oracle has announced a big feature that should come in the next 12c patch set: the In-Memory option. It will soon be in beta version, so nothing will be published about it until it comes to production. Before that phase, I’m going to explain what we can expect from that feature, besides the ‘In-Memory’,’columnar storage’, and ‘hybrid’ buzzwords. First, it is a redundant storage that is aimed to improve the query…

Read More
Oracle Team

Oracle Partitioned Sequences – a future new feature in 12c?

By | Database management, Oracle | 6 Comments

By Franck Pachot . Disclaimer: I’ll talk about an undocumented feature that appeared in Oracle 12c – undocumented except if you consider that being exposed in DBA_SEQUENCES as the PARTITION_COUNT is a kind of documentation. So, as the syntax is not documented (I got it only by guessing), you should not use it in production: there are probably some reasons why Oracle did not expose an interresting feature like that.

Read More
Oracle Team

Oracle et Dbvisit Replicate pour migrer sans arrêt de service… et sans stress

By | Hardware & Storage, Oracle | No Comments

By Franck Pachot . Je viens d’assister au Webinar Zero Downtime Migration pour Oracle, présenté par Chris Lawless qui est récemment passé de Product Manager Golden Gate à Product Manager Dbvisit.  Je vais détailler ici un point très important évoqué par Chris Lawless. La migration par réplication n’est pas seulement envisagée pour éviter un arrêt de service. Arrêt nécéssaire lors de la migration proprement dite (qui peut aller de quelques minutes à plusieurs heures en…

Read More
Oracle Team

Oracle is hanging? Don’t forget hanganalyze and systemstate!

By | Database management, Oracle | 12 Comments

By Franck Pachot . sqlplus / as sysdba oradebug setmypid oradebug unlimit oradebug hanganalyze 3 oradebug dump ashdumpseconds 30 oradebug dump systemstate 266 oradebug tracefile_name Your Oracle database – production DB, of course – is hanging. All users are blocked. You quickly check the obvious suspects (archivelog destination full, system swapping, etc.) but it’s something else. Even you, the Oracle DBA, cannot do anything: any select is hanging. And maybe you’re even not able to…

Read More
Oracle Team

Archivelog deletion policy for Standby Database in Oracle Data Guard

By | Database Administration & Monitoring, Oracle | 43 Comments

By Franck Pachot . Do you use ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY for your Oracle databases in Data Guard? Maybe you also use the Fast Recovery Area as archive log destination. That’s good practice! But did you ever check that it works as expected? What I mean is this: The archived logs that you don’t need are reclaimable by the FRA when space is needed And the archived logs that are required…

Read More
Oracle Team

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?

By | Application integration & Middleware, Oracle | 8 Comments

By Franck Pachot . Because people know that I really like Oracle AWR reports, they send them to me from time to time. Here is one I have received for Christmas with the following question: ‘Since our AIX server is virtualized, the response times are 4x longer. I feel that we are CPU bound, but cpu usage is mostly idle. Is there something hidden?’ It is a question that is frequently raised with virtualized environments….

Read More