Showing posts with label Oracle. Show all posts
Showing posts with label Oracle. Show all posts

Tuesday, March 13, 2012

To re-create "enq: RO – fast object reuse" problem

create 3 sessions.

Session 1:

SQL> select count(*) from mchbas;

  COUNT(*)
----------
   5943314

Friday, March 9, 2012

Move index or table to another tablespace

A) Tip :- How to move index  from one tablespace to another ?
B) Tip :- How to move Table from one tablespace to another ?