catio.sql questions
Date: Thu, 28 Oct 1999 10:37:51 GMT
Message-ID: <381b276f.258078549_at_cnews.newsguy.com>
After I posted my initial question about finding hot tables, I saw a thread about this script. I have been messing around with it for most of the day and am having two issues.
First is when you run the sample_io procedure, I am getting errors on the 21 line where is uses a hextoraw conversion to initialize tail_of_lru.
tail_of_lru := hextoraw('4000000000'); -- init to very large value
If I take out two zeros, making the init value 40000000, sample_io will run. Should I have to do that inorder for that proc to run? Is there an init.ora setting I am missing?
The other issue is on another database, 8.0.5. After the creation of the table, extent_to_object_tab, the script tries to create a unique composite index on file#, lowb, for this particular database it fails because there is two records where file# and lowb are the same. Should this be occuring? One of the records is a temp object. Should I delete this row from the table then create the unique index, or just create a non-unique index?
My last question, has anyone had good data come back out of using catio.sql? What were the parms you used for sample_io? did you cron it to run a different intervals throughout the day, with the same parms? Is there any significant overhead in running this?
anyone's experience with this would be of great help. ~Jim Received on Thu Oct 28 1999 - 12:37:51 CEST