Un punto unico de encuentro para compartir el conocimiento sobre bases de datos.
[Web Seminar] Adding Nodes to 10gR2 RAC
This week:
==========
*** Thursday, 8-Jan-2009, 9am Pacific (5pm GMT)
Adding Nodes to 10gR2 RAC
*** Presented by Mengmeng Tang (Dell Inc)
Will discuss detail steps for Oracle DBA and Linux Engineer to add new nodes to existing 10gR2 database RAC. Which including four major Parts :-
· Pre-install checking
· Adding an Oracle clusterware home to new nodes using OUI in interactive node · Adding an Oracle home to new nodes using OUI in interactive mode
· Adding ASM instance to new nodes
find Session who Locking Object
simple to Check someone who locking some objects on database
Session 1:
SQL> connect scott
SQL> select * from EMP where empno=7900 for update ;
Session 2:
SQL> connect / as sysdba
Find sid and other information on lock view with object_name.
select OBJECT_ID, OWNER,OBJECT_NAME ,l.sid , l.block from dba_objects o, V$LOCK l where l.ID1=o.OBJECT_ID and object_name = '&object_name' ;
SQL> select OBJECT_ID, OWNER,OBJECT_NAME ,l.sid , l.block from dba_objects o, V$LOCK l where l.ID1=o.OBJECT_ID and object_name = 'EMP' ;
Como redefinir una tabla en Oracle
Necesito redefinir "en-vivo" la tabla SCOTT.EMP01 de acuerdo a la siguiente formula: columna deptno=deptno+10 y además utilizar particiones.
No es posible CREATE/ALTER TABLE NVARCHAR2(4000)
Quizas alguien se pregunte: ¿Como puedo crear/alterar una tabla con NVARCHAR(4000)
Al consultar la documentación de Oracle, podrán darse cuenta que el tipo de datos NVARCHAR2 depende de la configuración del conjunto de caracteres (National Character Set)
Can't create/alter table NVARCHAR2(4000)
Perhaps Someone ask why I can create/alter table with NVARCHAR2(4000)
If they read on Oracle Docs, they'll know NVARCHAR2 data type depend on National Character.
The maximum column size allowed is 4000 characters when the national character set is UTF8 and 2000 when it is AL16UTF16. The maximum length of an NVARCHAR2 column in bytes is 4000. Both the byte limit and the character limit must be met, so the maximum number of characters that is actually allowed in an NVARCHAR2 column is the number of characters that can be written in 4000 bytes.
