Find number of hard parses and soft parses of a sql

I am trying to find how to determine if a sql is having parsing issues....how to find the number of hard parses and soft parses of a sql from PARSE_CALLS in v$sql.

I am aware that we can find if the sql is traced...but trying to understand using queries.

Please advice.

As per metalink:

Top 10 by Parse Calls:

set linesize 100 set pagesize 100 SELECT * FROM (SELECT substr(sql_text,1,40) sql, parse_calls, executions, hash_value,address FROM V$SQLAREA WHERE parse_calls > 1000 ORDER BY parse_calls DESC) WHERE rownum  <=10 ;

As per AWR:

SQL ordered by Parse Calls