Release schedules dates document was updated!!

Continue Hanganalyze’s post: 12.2 on-prem available for download, we see that realease date document was update on MOS (742060.1).

Basically Oracle 12.2 was released for cloud (in March 2017 for premises) and 12.2 have been supported until 2021.

roadmap

So, now it’s time to think about and plan to upgrade databases 11.2.0.4 and 12.1.0.2, of course if  application was compatible too! 🙂

Remember, now Oracle Recertification program follow the schedules date (more information you could see in this video).

Advertisements
Posted in cloud, database, Exadata, Installation, My Oracle Support, New Features 12c, ODA, oracle, Supercluster | 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 happy moment.

Today I gonna share a very good reading, The Phoenix Project, a kick start on DevOps culture. Reading this book, you will follow the journey of Bill, responsible in DevOps addoption on Parts Unlimited – a fictional company.

You will understand the key concepts, like a day by day diary. Totally worth reading – check the amazon link here.

So take you coffee mug, sit on the couch and read on!

See you around.

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 some cool new features, a pre-installed ova is the gold medal for you..

Check out last this Jeff Smith (SQL Developer and lots of fun on his blog)  here.

Its a OVA with 12.2, APEX, SQL Developer and other cool stuff 🙂

See you around!

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!

12-2_its_time

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 sqlplus tool, intended to oracle support personel only – however, it can be very handy in a bunch of situations. You can use it to set specific troubleshooting events, use to diagnose on which interface your RAC is using for the interconnect messages, use to execute a hanganalyze ( the command, not me, okay? =] ), system state dumps, errorstack dumps and the list goes on.

How do I use it?

First of all, you need to attach oradebug to a specific session/process.

Using the ospid:

Get the os pid for the process, usually with and ps command, or getting the thread in windows environment. With the ospid (in this example 1177)

oradebug setospid 1177;

If you try to attach oradebug to an inactive process, you will receive:

SQL> oradebug setospid 13050;
ORA-00072: process “13050” is not active

If everything went smoothly, you will receive:

SQL> oradebug setospid 16792;
Oracle pid: 150, Unix process pid: 16792, image: oracle@BLASERVER12

Using the SID to attach oradebug:

First of all you need to find out the orapid for the session, running the sql below:

select
p.pid orapid
from v$process p, v$session s
where s.sid = &SID
and p.addr = s.paddr
/

 

Example:

SQL> select
p.pid orapid
from v$process p, v$session s
where s.sid = &SID
and p.addr = s.paddr
/ 2 3 4 5 6
Enter value for sid: 651
old 4: where s.sid = &SID
new 4: where s.sid = 651

ORAPID
———-
152

SQL> oradebug setorapid 152;
Oracle pid: 152, Unix process pid: 5392, image: oracle@BLASERVER12 (TNS V1-V3)

You are ready to go!

Setting the 10046 event

oradebug event 10046 trace name context forever, level 12;

Setting the 10053 event

oradebug event 10053 trace name context forever, level 1;

Why this is important?

You can use the 10046 to get sql specific informations, such as object, parsing, elapsed time, wait events, bind variables. It is an alternativa for dbms_monitor and dbms_system, another way to generate a sessions trace, and it could be “tkprofed” as well.

If you wanna to understand the optimizer’s decicions, there is no better way that using a 10053 trace. You will understand the cost estimates, access paths, query block names, peeked binds, optimizer parameters used during the parse.

In another post I’ll give detail about the levels, and why we type “name context forever”. This is a how to post only =]

See you around!

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 way that we can do a recover for a single table. Before Oracle 12c we can do it manually.

Inside of this mecanism, RMAN create auxiliary instance to perform recovery, get only necessary information: RMAN restore and recover the SYSTEM, SYSAUX, UNDO tablespaces + tablespace where table resides and use a datapump (expdp and impdp – if you configurate to import this on database) to get point-in-time information.

Why use this mecanism?

  • Because it permitted to get the old information dropped (accidentally or not for some user, of course if you have the previous backup) without restore all database.
  • It very easy to use: its permitted to recover the information of tape or disk backup based. You only have the information available.
  • You can set the recover to import table with another name or just generate a dump.

Why not use this mecanism? (until 12cR1)

  • If you have index associate with required table and this index was on different  tablespace, you can have some trouble.
  • You can’t configure options like parallelism or exclude index on datapump.
Posted in New Features 12c | Tagged , , | Leave a comment