Home » SQL & PL/SQL » SQL & PL/SQL » Partition taking more space (Oracle 11g)
Partition taking more space [message #651110] Wed, 11 May 2016 08:44 Go to next message
s4.ora
Messages: 71
Registered: March 2010
Member
Hi All,

I have create 2 tables, one with Partition and another with Non-Partition, both the tables are having same number of records (Count - 1,500,000), both the tables are having same records. but the Partitioned table is consuming more amount of space.

Please find the screenshot attached..

STG_ENTRANCE_DS - Partitioned
STG_ENTRANCE_BOSE - Non-Partitioned


Can anybody help me understand, why Partitioned Table is consuming more space ?

Report message to a moderator

Re: Partition taking more space [message #651111 is a reply to message #651110] Wed, 11 May 2016 08:52 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Can anybody help me understand, why Partitioned Table is consuming more space ?
something was done differently.
We can't explain why because we don't know the history behind each of the tables.

Report message to a moderator

Re: Partition taking more space [message #651112 is a reply to message #651111] Wed, 11 May 2016 08:56 Go to previous messageGo to next message
s4.ora
Messages: 71
Registered: March 2010
Member
what can be the possible reason..??

Report message to a moderator

Re: Partition taking more space [message #651113 is a reply to message #651112] Wed, 11 May 2016 08:59 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
at some time in the past partitioned table held more data.
Oracle never voluntarily returns disk space back to the OS.

Report message to a moderator

Re: Partition taking more space [message #651114 is a reply to message #651110] Wed, 11 May 2016 09:03 Go to previous message
John Watson
Messages: 8929
Registered: January 2010
Location: Global Village
Senior Member
What is that query meant to be showing?

(btw, I wish you would not say "record" when you mean "row").

Report message to a moderator

Previous Topic: External table not fully loaded
Next Topic: Hierarchy query help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:02:34 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.