| Total estimation using BLOCKS method - datapump [message #581365] |
Fri, 05 April 2013 01:33  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear All,
I have analyzed that, datapump estimation is 9.902GB. When i check size of .dmp file, it's shows 1.44Gb.
Export: Release 11.2.0.1.0 - Production on Fri Apr 5 02:00:05 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_FULL_01": system/******** dumpfile=expdp_LVGITRN_30_24_050413.dmp directory=DP_DIR logfile=expdp_LVGITRN_30_24_050413.log full=y exclude=statistics
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: [bold]9.902 GB [/bold]
Please let me know why it is happening? What's the reason behind it? Why Datapump estimate so much than actual size?
Eager to know the concept behind it.
Regards,
Ishika
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Total estimation using BLOCKS method - datapump [message #581383 is a reply to message #581376] |
Fri, 05 April 2013 02:58  |
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
|
Senior Member |
|
|
Dear Michel,
Even i saw this in site.
BLOCKS The estimate is calculated by multiplying the number of database blocks used by the source objects, times the appropriate block sizes.
But my confusion is-
I have not used compression parameter in expdp, then why there is so much differences between estimation and actual one? If, it is internal calculation by oracle and difficult to know about the calculation then my question is wrong.
Regards,
Ishika
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
