Database Administration (MOSC)

MOSC Banner

oracle mechanism

edited Jun 28, 2012 3:55AM in Database Administration (MOSC) 3 commentsAnswered

I have a table called emp(emp_no number(3),emp_name varchar2(50)),

I made select query : select * from emp, I want to know the mechanism that oracle 
server used to fetch data from table (data files)

I mean : 
** what are the background processes that oracle server run to fetch data?

** what are the memory (sga or pga) types that oracle server allocated to fetch data?

** what are the applications that client workstation runs ?

** what are the connections that client workstation established ? 


Thanks everybody in advance.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center