OraFAQ Forum: Performance Tuning » How we can check count for each partition

Home » RDBMS Server » Performance Tuning » How we can check count for each partition (Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit )

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

How we can check count for each partition [message #553224]

Wed, 02 May 2012 10:23

msol25
Messages: 211
Registered: June 2011
Location: Mumbai

Senior Member

Hi Experts,

We have 525 partitions and we want find out partition wise total count.Please help me for finding partitionwise count in a particular table.

Report message to a moderator

Re: How we can check count for each partition [message #553226 is a reply to message #553224]

Wed, 02 May 2012 10:29

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>We have 525 partitions and we want find out partition wise total count.Please help me for finding partitionwise count in a particular table.

count for which metric; rows, blocks, other?

query DBA_TAB_PARTITIONS

Report message to a moderator

Re: How we can check count for each partition [message #553227 is a reply to message #553226]

Wed, 02 May 2012 10:35

msol25
Messages: 211
Registered: June 2011
Location: Mumbai

Senior Member

yes but my table is not analyzed.So i think i cannot find exact count...

I want to find out total number of rows in eact partition using single sql select statement.

Report message to a moderator

Re: How we can check count for each partition [message #553228 is a reply to message #553227]

Wed, 02 May 2012 10:41

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>I want to find out total number of rows in eact partition using single sql select statement.
I want to win the lottery.
Sometime you don't get what you want.

Consider running DBMS_STATS against the table.

Report message to a moderator

Re: How we can check count for each partition [message #553229 is a reply to message #553228]

Wed, 02 May 2012 10:48

msol25
Messages: 211
Registered: June 2011
Location: Mumbai

Senior Member

My table is having 1995 million data and my Deployment is after 2 hrs then how i can win that lottery.

Report message to a moderator

Re: How we can check count for each partition [message #553230 is a reply to message #553229]

Wed, 02 May 2012 10:50

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>My table is having 1995 million data and my Deployment is after 2 hrs then how i can win that lottery.
The lack of planning on your part, does NOT constitute an emergency for me.

Report message to a moderator

Re: How we can check count for each partition [message #553231 is a reply to message #553230]

Wed, 02 May 2012 10:53

msol25
Messages: 211
Registered: June 2011
Location: Mumbai

Senior Member

Please anybody can resolve my issue........

I have a urgency.....

Report message to a moderator

Re: How we can check count for each partition [message #553235 is a reply to message #553231]

Wed, 02 May 2012 11:03

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

>Please anybody can resolve my issue........
>I have a urgency.....

How do you get rows counts without actually counting the rows?
Either you count then rows or DBMS_STATS count the rows.
pick your poison.

Report message to a moderator

Re: How we can check count for each partition [message #553236 is a reply to message #553235]

Wed, 02 May 2012 11:06

msol25
Messages: 211
Registered: June 2011
Location: Mumbai

Senior Member

i want to count the rows partitionwise....Please tell how i can do...?????????

Report message to a moderator

Re: How we can check count for each partition [message #553241 is a reply to message #553236]

Wed, 02 May 2012 11:22

BlackSwan
Messages: 20109
Registered: January 2009

Senior Member

  1* SELECT COUNT(*) FROM SALES partition (SALES_Q4_2003)
09:22:03 SQL> /

  COUNT(*)
----------
	 0

09:22:04 SQL> SELECT COUNT(*) FROM SALES partition (SALES_Q3_2003);

  COUNT(*)
----------
	 0

09:22:30 SQL>

Report message to a moderator