odbv
03.11.2016

Oracle Database Block Visualizer

Recently I wanted to demonstrate to some people on my training, how Oracle database maintains blocks in a datafile – what happens after truncate, truncate with drop storage clause, delete, regular insert, direct path insert and so on… I didn’t find any tool for that so I’ve written my own. It’s core code is based […]


Czytaj
#ThanksOTN
11.10.2016

OTN Appreciation Day : pragma UDF

Joining the OTN Appreciation Day I really like the new pragma UDF feature for PL/SQL – it makes me believe that context switches will be less painful in the future I wrote a little bit more about it here: http://blog.ora-600.pl/2015/10/29/oracle-12c-pragma-udf-the-truth/ And Martin Widlake wrote a lot about it here: https://mwidlake.wordpress.com/2015/11/11/pragma-udf-some-current-limitations/


Czytaj
PL/SQL
19.09.2016

Using DTrace to understand why PL/SQL packages can be faster than stored procedures (kgiPinObject)

I know – everyone knows, that PL/SQL packages are faster than stored procedures. If you’ll ask anyone at the training or in your dev team "what is better" – you’ll (almost) always hear: PL/SQL packages. But why exactly? The documentation says: The first time you invoke a package subprogram, Oracle Database loads the whole package […]


Czytaj
kksParseCursor
14.09.2016

session cached cursors and the significance of PL/SQL (kksParseCursor)

Years pass by and I think that the more I’m trying to understand the Oracle RDBMS – the less I know. Recently I started to examine the behavior of session cursor cache and I noticed an interesting thing. But let’s start from the beginning like we should The documentation says: About the Session Cursor Cache […]


Czytaj
POUG 2016
01.09.2016

Voucher for POUG conference

Since the promotion tickets for the first international Oracle conference in Poland (poug.org/en) are sold out, I’ve decided to create a little contest allowing you to win a voucher code for -20% of the current ticket price. The task is easy, but you have to use DBA and DEV skills to resolve it. So the […]


Czytaj
RICO
31.07.2016

how to recover dropped package

Sometimes you drop something by accident – you know, the syndrome called "An Enter Too Far". If you drop a table, the case is easy – you can use recyclebin to restore it. But when you drop a package or procedure… well, you have a problem Of course, you could use a flashback query on […]


Czytaj
AWK
27.07.2016

AWK TO THE RESCUE 3 – match ASMLib with multipath

This will be just short article with very simple trick, showing how to match the ASMLib devices with actual multipath devices. I’m sure there is a simpler way… but I just love using AWK If you know a simpler or more elegant solution – please post it in the comments section. My solution looks like […]


Czytaj
RAC 12c
14.06.2016

ORACLE RAC 12c: restore OCR and VOTEDISK

Let’s fuckup the cluster! Of course after this operation, the final state of the processes can look like this: The cssd service will not be able to start, because there are no voting disks: OK, so let’s try to stop the cluster services: Now we will have to start CRS in exclusive mode and start […]


Czytaj
opifch2
27.05.2016

Context switch – PL/SQL cursor loops and fetchsize vs opifch2

Well it has been a month since my last blog post, so I think it’s time to write something Those context switches can be a real pain in the ass – there is a great article by Frits Hoogland about context switching from SQL to PL/SQL – you can read it here: https://fritshoogland.wordpress.com/2016/01/23/plsql-context-switch/ You should […]


Czytaj
Exadata & SR-IOV
26.04.2016

Infiniband SR-IOV on Exadata OVM

Virtual hosts on Exadata with OVM are HVM and not PV. This is one of the limitations of Infiniband SR-IOV – can’t be used with PV. So there is a qemu used to emulate the hardware While accessing a physical device from within a DOMU we can see that actual work is being done on […]


Czytaj
EXADATA+OVM
03.04.2016

Exadata & OVM: Unable to get map of the virtual network interfaces

This week I had a "pleasure" of reimaging Exadata server to use OVM. During this process we hit interesting problem – after the reimaging process there was no bridge at DOM0, corresponding to the client network – because of this, the OEDA sofware returned an error like this: The error was produced by this script: […]


Czytaj
AWK
16.03.2016

AWK to the rescue 2 – 10046+10053 = ?

I’ve created recently a script in AWK to create wait event histogram from 10046 trace file. The script can be found here. I thought that a good idea would be creating a little script to analyze the contents of 10053 and 10046 events together. So I wrote one You can download it here: http://ora-600.pl/oinstall/format_10046_10053.awk How […]


Czytaj
1 2 3 6

Kontakt

Database Whisperers sp. z o. o. sp. k.
ul. Płocka 5A
01-231 Warszawa
NIP: 5272744987
REGON:362524978
+48 508 943 051
+48 508 348 987
info@ora-600.pl

Newsletter zapisz się żeby być na bieżąco