Hi all!
Today is a quick tip. Actually, just because more than once I was about to kill a session in a RDS session and it was simply not possible with my usual ALTER SYSTEM KILL SESSION scripts… 🙂
Know how to do it? Here it goes:
begin rdsadmin.rdsadmin_util.kill( sid => &sid, serial => &serial); end; /
Putted it in a script: @killrds.sql
Cheers!
Did you know the SIMPLE_INTEGER datatype is a subtype of the PLS_INTEGER datatype and can increase the speed of integer arithmetic in natively compiled code as well as in interpreted code?
Nice, right?
This is an 11g feature, so not that new… Have a look and use it!
Check below for datatype declaration example:
PLS_INTEGER:
var_old_fashioned PLS_INTEGER := 0;
SIMPLE_INTEGER:
var_new_way SIMPLE_INTEGER := 0;
Cheers!
