The following are few tips for cursor optimization:

- When the cursor is not needed, close the cursor

- Deallocate the cursor after closing it.

- Fetch less number of rows.

- Avoid triggers – because trigger executes whenever data gets updated, leads to overload of the system.

- When the rows are not need to update, use the option FORWARD ONLY

- Use where instead of having clause unless it is essential