database size

[sridevi]

hi

1.how do i know what should be by database size.

2 does database over flow occur?
who takes care of the problem---- DBMS or the programmer

3. how to determine when to truncate a table

4. what is the default size of a table. Can it be set?

5. what is relation between database size and its table's sizes.

[skhanal]

1. depends on how much data you are storing, table and index structure

2. dba must plan for database growth based on estimate provided by programmers

3. depends on application, in some cases you can never truncate

4. in Oracle you can specify the number of extents for a table, in sql server it is limited by the size of data file

5. database size = tables size + index size + storage required for database system catalog + LOBs + ...

[rmiao]

Which rdbms do you use? Different rdbms has different means to check db or table size.

[sridevi]

I am using mysql and sybase

[rmiao]

Did you check maunals of them?