To find the number of nodes? TDWORLD | May 24, 2014 | Important Queries | No Comments Query 14) To find the number of nodes? Answers > Select count(distinct nodeid) from dbc.resusagescpu; sel count(distinct VprId ) from DBC.ResUsageSvpr where VprType=’NODE’; Related Posts Query to find the number of vprocs No Comments | May 24, 2014 Important Query for Download ~~ DBA Must Have queries !! No Comments | Nov 23, 2013 How can you find the Table Space Size of your table across all AMP No Comments | May 24, 2014 How to check the status of backup/Recovery when Net vault/Netbackup is not installed ? No Comments | May 24, 2014 About The Author tdworld2013 Add a Comment Cancel reply Your email address will not be published. Required fields are marked *Comment:*Name:* Email Address:* Website: Save my name, email, and website in this browser for the next time I comment.