Home » RDBMS Server » Performance Tuning » LONG RAW performance problem
LONG RAW performance problem [message #65469] Tue, 28 September 2004 16:58
typhoon
Messages: 1
Registered: September 2004
Junior Member
hi, I need help to solve a strange problem related to LONG RAW.

My Oracle9i table is created as
  CREATE TABLE test (id LONG, content LONG RAW, PRIMARY KEY (id))

Then I did something like this:
  1> INSERT INTO test VALUES (1, new byte[[1024 * 1024]])
  2> for (int i = 0; i < 1000; i++)
         UPDATE test SET content=new byte[[1024 * 1024]]
  3> DELETE FROM test
 
Now querying the EMPTY table shows a surpring performance result:
  SELECT id FROM test     0.03s
  SELECT *  FROM test     76.21s

Other information:
  1> The meta data shows that the table has used 330472 pages
  2> UPDATEs more, performs worse
  3> Rebuilding the primary key index doesn't solve the problem
  4>
does solve the problem but we cann't
     do that in the real application

Does anyone have a solvent to this problem? Thanks a lot!
Previous Topic: What is Bucket/Chunk and how to check the fragment on shared pool
Next Topic: Using of NO_INDEX hint with INSERT statement
Goto Forum:
  


Current Time: Thu Feb 29 09:51:15 CST 2024