Un punto unico de encuentro para compartir el conocimiento sobre bases de datos.


Visor de traces 10053 Cost Based Optimizer

Jonathan Lewis nos comparte este practico visor de traces, cuya autoria original corresponde a Hans-Peter Sloot de Atos Origin y Robert van der Ende, quienes
escribieron esta herramienta para facilitar la revisión de los archivos trace generados con el evento 10053, que pueden llegar a ser enormes. Recorrer el contenido
de arriba a abajo para referenciar las zonas de interes puede ser extremadamente tedioso. Su interface de navegacion tipo "arbol" permite visualizar los encabezados
importantes y expandir al detalle el(los) que te interese(n).

Hola Oracle Exadata/Database Machine

Durante las ultimas cuatro o cinco semanas he tenido el raro privilegio de trabajar con esta sorprendente pieza de ingenieria, la Oracle Database Machine.

Example: ROW CACHE LOCK ...

Investigate ROW CACHE LOCK when we found High "row cache lock' wait
http://it.toolbox.com/blogs/surachart/row-cache-lock-35256

Etc:
Oracle DUPLICATE Without Connection to Target Database (11gR2)
http://surachartopun.com/2009/11/duplicate-without-connection-to-target....

If you have further doubts or want to ask the gurus, visit the Forum

Surachart Opun
http://surachartopun.com

Example; Moving database file in ASM diskgroup

I wrote about moving datafile in ASM

Moving database file from one ASM diskgroup to another
http://it.toolbox.com/blogs/surachart/moving-database-file-from-one-asm-...

MOVING DATAFILE IN ASM BY ASMCMD(cp)
http://it.toolbox.com/blogs/surachart/moving-datafile-in-asm-by-asmcmdcp...

By Surachart
http://surachartopun.com

10gRAC with Solaris (IPMP)

On Solaris, IP network multipathing (IPMP) provides physical interface failure detection and transparent network access failover for a system with multiple interfaces on the same IP link.

On 10gRAC, It's a good question, How to Setup 10gRAC with Solaris (IPMP) ?

ASM Dynamic Volume Manager (ADVM) and ASM Clustered File System (ACFS)

11gR2 feature... ASM Dynamic Volume Manager (ADVM) and ASM Clustered File System (ACFS)

We can create ACFS by using asmca (link). and we can use command-lines(sql*plus, asmcmd) as well.

- Create a volume from an ASM diskgroup



Syndicate

Syndicate content

Follow DatabasesLA on Twitter

Who's online

There are currently 0 users and 0 guests online.

Estadisticas

Locations of visitors to this page

hidden hit counter