FIELD NOTESTHE ORA-600 BLOGSearch /BROWSE THE FIELD NOTES
117 field notes / page 9 of 10
In Oracle 12c there is a possibility to define a PL/SQL function inside the "WITH" clause, which can reduce the context switching overhead. Short example: SQL> create or replace function F_DUMMY(x number) retur
Install Oracle RAC 11gR2 on VirtualBox: http://www.youtube.com/playlist?list=PLqQNL6H71xCygSF_VqwM8j-Hhft4XoEEx VM templates can be found here: https://mega.co.nz/#!esp1kQQA!CUr8SlErdPppk-GkxedTUAdMpVQPrrrSI3c1
Instead of bonding you can use Oracle cluster interconnect HAIP for using multiple ethernets. And here is how its done 🙂 At the begining I have one interconnect – eth1: SQL> select * from GV$CLUSTER_INTERCONNE
Moja prezentacji z konferencji COIG http://prezi.com/ov5xbjytuzgw/?utm_campaign=share&utm_medium=copy&rc=ex0share
We had to change the hostnames on Exadata with one of the customers. It is a well known fact that RAC doesn’t like such changes – we had to reconfigure the cluster and after the whole process I found the funny
Oracle 12c offers a lot of fascinating new features – among them (at last) "FETCH FIRST n ROWS ONLY" syntax. http://www.oracle-base.com/articles/12c/row-limiting-clause-for-top-n-queries-12cr1.php Out of curios
My experience shows that you don’t have to know the DBID now for restoring contorlfile from backup. If I know the name of backup piece, that contains controlfile I can do the following scenario:
Oracle Cost Based Optimizer consists of three main components: Query Transformer, Esitmator, Plan Generator. In this article I will try to show you some interesting features of the first component – Query Trans
Tak dobrych referencji jeszcze chyba nigdy nie dostałem 🙂 I gdybym cechował się jakąkolwiek skromnością, to bym tego nie publikował. http://rafalosinski.com/lifetech/najlepsza-znana-mi-prelekcja-czyli-warsztat
Do you realy know SQL? I mean Oracle SQL…. Maybe you should take a closer look: http://ora-600.pl/art/sql-for-modeling.pdf
A few simple techniques of escalating privileges in database Oracle 11.2.0.3. http://ora-600.pl/art/oracle_privilege_escalation.pdf