Hi,

1.1 Recurcive calls are the calls done by ORACLE on its dictionary. For example to parse a SQL statement it needs to query the dictionary for checking tablename, columns, access rights etc. Before acessing the table it requires datafile, extent info. To minimise recurcive calls you can increase shared pool so that some of it gets buffered.

1.2 You look at the total of recursive calls in relation to user calls. As long as you have a healthy ratio its OK.

2.1 Parse count should be related to number of executions to find out the effectiveness of SQL area in the shared pool.

2.2 ORACLE reuses information if it is already present. That may be reason you find that there is no change in the cumulative cursor information.

Baliga