Recent content by NewDBA

The reason for increasing size is that db startup parameter has -bistall. DB stalled at 750 MB. I increased it to 1.5 G and then to 1.9 G. The transaction will be started in am hour and the bi size may grow beyond 1.9 G. So i wanted to be sure if i can increase its size limit to 2.5 or 3G so...

Thanks for your replies. This is indeed a monster transaction as approx 15,000,000 records are being moved from old DB to this new one. I checked the DB creation log properly and i saw message 9453: Large database file access is already enabled for database. So this means that if needed i can...

They are using some old scripts/programs to do it. I haven't seen those. More over i haven't enabled large files on this DB at time of creation. Without enableLargeFile, will it allow to extent it beyond 2 GB file size?

Thanks for the reply Tom. Application team is moving data from this Db to the new one and have made sure no data is added to this DB anymore. This is being done online so no business impact. When this is over i am going to go full force for upgrade as that is the best solution to many problems...

Thanks for reply. yes its an area limit issue. there is only 1 table and no index in this area. therefore moving data is the only option we have i guess. But the question I have, will block usage go down if i only move/delete data from this table or do i have to also do the dump-load? And will...

yes i am on version 9 as of now but right now need a quick fix to be able to take decision on upgrade. suddenly i realized that my records per block is 128 and block size 8K, so my reserved space is not 5 GB but 1 GB. As of now nothing is being written to the DB but soon will. Now the question...

Hi, An urgent help needed. In addition to the above issue, the block usage reached 90% sometime back. We did create a new DB but die to some application design issue, it will take some 15 days to completely stop writing into current DB. Just now this DB went down with the following error...

Thanks for reply RHD. The mean record size is 83 in the dbanalys. With that the value i get is 98. In last one month the number of records written is: 124522631 and size increase is 10 GB. For the largest possible size of my DB area, i used values from following link...

Thanks for the reply RHD. I read the KB article you suggested andd it was really helpful. Today i ran dbanalys on the DB and compared it with one month old analysis. There is only one table in that area and approx 10 GB was written in last 30 days. If it continues to write at same speed i...

Hi, Today I was adding extents in one of the DB's when I found the error: Prod01:PROGRESS:/live/db/billingDB:> prostrct add billingDB add_06102014.st Formatting extents: size area name path name 524288 AlphaData /live/db/billingDB/data01/billingDB_7.d3...