Database Reference
In-Depth Information
Think time
Think time is a term from the fields of load testing and benchmarking. Humans working
with an electronic information service require a certain time to assimilate information
returned by the service. The interval between the end of the previous request on the server
and the beginning of the next request from the user is called think time, since the human
user spends that interval of time thinking about what to do next.
User level SQL
SQL statements executed directly by a database user (non-recursive SQL).
Wait event
Wait events are used for response time accounting of database sessions. Through the wait
interface or SQL trace files, wait events externalize what a database session has been waiting
on and how much wait time it has accumulated.
Wait interface
The term wait interface is used to refer to a set of V$ fixed views that expose wait events that
database clients are waiting for. These V$ views cover database sessions that are currently
waiting as well as aggregated data on past waits. The wait interface may be used to diagnose
performance problems.
X$ fixed tables
Undocumented internal structures of the ORACLE DBMS. V$ fixed views are based on X$
fixed tables. X$ fixed tables are often called just X$ tables, but they are not tables in the usual
sense of the word, since they do not map to segments in a tablespace.
Search WWH ::




Custom Search