parsing,”Each time you execute a SQL statement, a lot happens in the background. This background activity is called parsing. Parsing can be quite expensive.During parsing, some of these things happen:The statement syntax is checked to make sure you typed everything correctly.The objects you’re referring to are checked. For example, if you’re trying access a table called emp

parsing,”Each time you execute a SQL statement, a lot happens in the background. This background activity is called parsing. Parsing can be quite expensive.During parsing, some of these things happen:The statement syntax is checked to make sure you typed everything correctly.The objects you’re referring to are checked. For example, if you’re trying access a table called emp

Oracle makes sure it exists in the database.Oracle makes sure that you have permission to do what you’re trying to do.The code is converted into a database-ready format. The format is called byte-code or p-code.Oracle determines the optimum path or plan. This is by far the most expensive part.”