You are here10g

10g


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) ?

Any Idea About "INITRANS"

What is "INITRANS"?
Specify the initial number of concurrent transaction entries allocated within each data block allocated to the database object. This value can range from 1 to 255 and defaults to 1, with the following exceptions: (on10g MAX_TRANS 's ignored )

DB_FILES... think???

DB_FILES initialization parameter... why i should to think about it?

When starting Oracle database instance, DB_FILES initialization parameter indicates the amount of SGA space to reserve for datafile information and maximum number of datafiles that can be created for the instance.

SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time

Today, my colleague told me, Why I can't use "sqlplus" (Oracle client) on my application server connect your database, But I can use "tnsping"... And I'd ever connected!

I remoted on this server and found "sqlplus" hung ... and sqlplus used more CPU %

$ ps aux
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 12722 96.4 0.2 19560 4600 pts/5 R 15:36 0:06 sqlplus

So, found out on metalink... (338461.1)
SQL*Plus 10.2.0.1 Hangs, When System Uptime Is Long Period of Time (Linux x86)

Used "strace" :

$ strace sqlplus -V 2>&1 |less



Syndicate

Syndicate content

Follow DatabasesLA on Twitter

Who's online

There are currently 0 users and 3 guests online.

Estadisticas

Locations of visitors to this page

hidden hit counter