Q
Problem solve Get help with specific problems with your technologies, process and projects.

Where session-specific SQL is executed

Can you tell me where the session-specific SQL statements and other SQL statements are executed? For example:
set autotrace on; echo on;

select * from emp;
Which process is responsible for executing both of the statements?

SET AUTOTRACE ON and SET ECHO ON are SQL*Plus commands. They are not executed in the database. They only tell the SQL*Plus application how to do certain things. This is entirely handled within SQL*Plus. So your SQL*Plus executable is responsible for these statements.

A command like "SELECT * FROM EMP;" is also handled by SQL*Plus. But SQL*Plus recognizes this as a SQL statement. So SQL*Plus passes the SQL statement to the database. In return, SQL*Plus gets data back and shows the data on the screen.

For More Information

Dig Deeper on Oracle and SQL

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close