Datafile Size

What is your datafile size? How long it can go? What is the max limit to which you can extend?

Showing Answers 1 - 1 of 1 Answers

hemant.agarwal03
Profile

Mar 18th, 2008

v$datafile data dictionary view will tell us the size of a datafile.
to check the number of datafile you can check db_files init parameter. you can also alter this parameter but it will reflect after restartthe database.

you can also resize the datafile size.