I am new to Oracle DBA (a learner) Need your help in architrcture concepts.
So please share your knowledge on below two questions
1. What is the architectural flow when a user executes a pl/sql program (say a procedure with cursor based record type).
2. Commit command has been fired followed by delete command. In this scenario please explain the architectural flow (which components of instance invloves and also what happens at SGA & PGA).
Kindly share your valuable views here.
Thanks in advance.