Home » RDBMS Server » Performance Tuning » slow in scanning documents
slow in scanning documents [message #262985] Tue, 28 August 2007 13:08 Go to next message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member

Hello sir,

In our database the scanning documents seems very slow
scanning documents in one table (table name scandoc).If we select ant record from that tables it seems very slow this table contain 2 blob columns.

Before 1 year this same problem occur in 8i ,so we increased the pctversion from 10 to 100 the problem solved ,but now the databse in 9i,same problem would occur again.

Please help me sir,what can i do..?


_Thanx in advance







Re: slow in scanning documents [message #263234 is a reply to message #262985] Wed, 29 August 2007 08:22 Go to previous message
vasudevan
Messages: 119
Registered: February 2006
Location: TRICHY
Senior Member



Hello guys


Now my problem was solved ,After i have droped the slow table recreate the table and import the same table from export
now it lloks very fine.


-Thanx.
Previous Topic: CBO vs RBO
Next Topic: rebuilding index
Goto Forum:
  


Current Time: Fri Jun 28 09:59:42 CDT 2024