Dump file size oracle

Post as a guest Name. Email Required, but never shown. The Overflow Blog. Stack Gives Back Safety in numbers: crowdsourcing data on nefarious IP addresses. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.

Related 0. Hot Network Questions. Question feed. Stack Overflow works best with JavaScript enabled. When the trace file is limited in size, it may be automatically split into multiple files, called segments, if needed. This process is call trace file segmentation. The segments will have the same file name as the active trace file, but with an extra segment number appended.

When the combined size of all the trace file segments exceeds the specified limit, the oldest segment is deleted, and a new, empty segment is created. Thus, the trace file always contains the most recent trace information. Asked 4 years, 11 months ago. Active 4 years, 11 months ago. Viewed 9k times. Please advice if any body have idea on this? Improve this question. Add a comment. Active Oldest Votes. If the tables are fragmented then actual size may vary.

The newly created table has blocks. Which is 13MB. All rights reserved. Next, lets delete all the records from the table and try estimate the dump size of table.

Again, lets try to estimate the dump size. Improve this answer. Nice and thorough.