logs archiveIRC Archive / Freenode / #oracle / 2015 / July / 20 / 1
dbfuse_
hi
anyone on
petteja
yeah
dbfuse_
One of the cluster nodes is not coming up due to GPNP any pointers.
vinnix
hi
dbfuse_
hi
yottabyte
hey guys when you select from a table that there is some other transaction happening on, what happens?
is that table locked and the other transaction waiting until the select is finished?
MatheusOl
yottabyte: no, select doesn't block, unless you are doing some DDL
yottabyte
MatheusOl: so it's dirty reads?!
MatheusOl
:|
         

YottaByte
in some procedures I see like procedure my_proc(a IN number) IS my_var number; BEGIN -- logic here
is that missing like a declare
« prev next »