DB size

[arameshdba]

HI this is ramesh please tell me the sum minimum size's for db, table space, redologs, how manay redologs for 1 db in real time, how much time takes to clone the db, db contains how many tables, how many table spaces, in the interviews about which errors they will ask,etc.

Thanks
ramesh

[madhugp]

hi,

for the interview point of view you study the concepts well.
minimum no of tablespaces,datafiles for a small realtime database can be 1
other than system tablespace.
the minimum size of db can be 1 GB or more depending on the database.
the database size is sum of space occupied by all datafiles used
for that database.
you can query dba_data_files, dba_tablepsaces etc.. views