Soft Parse Vs Hard Parse

 

If the Same Sql is found in a shared pool and it avoids optimization and Row source genertion and directly goes to the execution stage and then that sequence statement to through soft parse.

 

if the Sql statement was not found in the shared resources and it had to do the optimization and Row source generation then that means it did the hard parse.