| sizing a database [message #102572] |
Tue, 23 July 2002 11:23  |
Magno
Messages: 1
Registered: July 2002
|
Junior Member |
|
|
Hi everybody!,
I have three big tables with a increasing of 4Gb each month, the most of fields are numeric(15,2). The data doesn't change in time. It's only for reports.
How to minimize the database size?
1. changing numeric -> varchar2(maybe)
2. setting PCTFREE = 3, PCTUSED = 90
3. INITRANS = 1 MAXTRANS = 255
do you have any idea?
Magno
|
|
|
|
| Re: sizing a database [message #102597 is a reply to message #102572] |
Tue, 30 July 2002 11:52  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
Decreasing PCTFREE will help. If your rowlengths won't increase during updates, then you can reduce that to 0. Increasing PCTUSED could add processing overhead depending on how data is deleted from your table. e.g. if your data is timestamped with the current date when you load it and you delete it based on date ranges then it's likely that you'll be deleting the contents of whole blocks, so they will become free anyway.
If you are on 9i, see COMPRESSION for tables and indexes.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
