Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 184 of 211


V$SQLTEXT

This view contains the text of SQL statements belonging to shared SQL cursors in the SGA.

Column  Datatype  Description 

ADDRESS 

RAW 

Used with HASH_VALUE to identify uniquely a cached cursor 

HASH_VALUE 

NUMBER 

Used with ADDRESS to identify uniquely a cached cursor 

PIECE 

NUMBER 

Number used to order the pieces of SQL text 

SQL_TEXT 

VARCHAR2 

A column containing one piece of the SQL text 

COMMAND_TYPE 

NUMBER 

Code for the type of SQL statement (SELECT, INSERT, and so on) 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback