sql server cache Plan query

SELECT top 100 text.text as sql, cp.usecounts, cp.cacheobjtype,cp.objtype, plan1.dbid, plan1.query_plan,cp.plan_handle
FROM sys.dm_exec_cached_plans as cp
CROSS APPLY sys.dm_exec_sql_text(plan_handle)  as text
CROSS APPLY sys.dm_exec_query_plan(plan_handle) as plan1
WHERE usecounts > 1
ORDER BY usecounts DESC;