Oracle Blues

2008-02-13

Oracle Coherence Data Grid Presentation Video

2008-02-12

Database Cluster information

Script to get the database cluster information:

SET SERVEROUTPUT ON



BEGIN

IF DBMS_UTILITY.is_cluster_database

THEN

DBMS_OUTPUT.put_line ('Clustered');

DBMS_OUTPUT.put_line (   'Connect to instance:'

|| DBMS_UTILITY.current_instance

);



<<instances>>

DECLARE

ltab_instance_table   DBMS_UTILITY.instance_table;

li_instance_count     PLS_INTEGER;

BEGIN

DBMS_UTILITY.active_instances

(instance_table      => ltab_instance_table

,instance_count      => li_instance_count

);



FOR i IN 1 .. li_instance_count

LOOP

DBMS_OUTPUT.put_line (   ltab_instance_table (i).inst_number

|| ' = '

|| ltab_instance_table (i).inst_name

);

END LOOP;

END INSTANCES;

ELSE

DBMS_OUTPUT.put_line ('Not Clustered');

END IF;

END;

Output example:

Clustered

Connect to instance:1

1 = orainst1:ORA1

2 = orainst2:ORA2

3 = orainst3:ORA3

General Elevator 5 e 6

Episódio 5

Episódio 6

Actualização: foram actualizados os videos pois o local original já não funciona.

Três pequenos musicais humoristicos:

"A short musical about workers who become agitated when they discover their food missing from the office refrigerator."
Lunch Misérables

"(...) demonstrates the importance of protecting our children from dangerous online predators"
Web Site Story

Senator Craig's New Music Video

versão digital do Oracle Magazine March/April 2008

Encontra-se disponivel a versão digital do Oracle Magazine de March/April 2008

Links for Oracle

In sequence of a previous post with links to Steven Feuerstein related resources I leave here some of my list of Oracle links.

History of Oracle

Metalink Official support (extra cost)

Oracle Technology Network(OTN) articles, sample code, downloads, forums

AskTom forum by Thomas Kyte

Oracle Magazine

Oracle database official documentation

Oracle Server Technologies Curriculum online tutorials

Oracle Express Edition Free Version of the DB

Free Development Environments
APEX
SQL Developer
JDeveloper

2008-02-11

Count Rows in each table

Sometimes we what to know which is the table that has more rows.
That could be archived easily by the following query

select table_name, num_rows FROM user_tables ORDER BY num_rows desc nulls last

Ler mais / Read more...

Cuidado com pagamentos MB na ZARA ou via UNICRE

Já é noticia de Novembro passado mas eu não sabia

Fica aqui o aviso!

PL/Vision: new version needed?

I have a new goal. To try to put PL/Vision at a new stage: an 10g and 11g version.

I try to install it in my 10.2 version and I got a compilation error.
For now here are the changes I made in the code

Compilation error:
comment line 50 and 51 of PLVEXEC package specification

  -- no_such_table EXCEPTION;

--    PRAGMA EXCEPTION_INIT (no_such_table, -942);

Unnecessary code:
comment line 162 of PLVEXEC package body
-- ELSIF code_in = -942 THEN RAISE PLVexc.no_such_table;
comment line 350, 351 of PLVEXEC package body

    --  logit BOOLEAN := FALSE;

--  showit BOOLEAN;