Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

Dynamic Performance (V$) Views, 157 of 179


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, etc.) 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index