To Increase the Column Size !! [message #6868] |
Fri, 09 May 2003 01:14 |
wrbalaji
Messages: 11 Registered: February 2003
|
Junior Member |
|
|
Hi all,
I have planned to use the view V$SQL for my Database Audit. Can any one tell me how can i increase the size of SQL_TEXT column in V$SQL view from 80 to its maximum size 1000? Because my SQL Statements are larger than the size 80.
Thanks in advance,
balaji.
|
|
|
Re: To Increase the Column Size !! [message #6870 is a reply to message #6868] |
Fri, 09 May 2003 02:10 |
|
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
SQL> desc v$sql
Name Null? Type
------------------------------- -------- ----
<B><FONT COLOR=RED>SQL_TEXT VARCHAR2(1000)</FONT></B>
SHARABLE_MEM NUMBER
PERSISTENT_MEM NUMBER
RUNTIME_MEM NUMBER
SORTS NUMBER
LOADED_VERSIONS NUMBER
OPEN_VERSIONS NUMBER
USERS_OPENING NUMBER
EXECUTIONS NUMBER
USERS_EXECUTING NUMBER
LOADS NUMBER
FIRST_LOAD_TIME VARCHAR2(19)
INVALIDATIONS NUMBER
PARSE_CALLS NUMBER
DISK_READS NUMBER
BUFFER_GETS NUMBER
ROWS_PROCESSED NUMBER
COMMAND_TYPE NUMBER
OPTIMIZER_MODE VARCHAR2(10)
OPTIMIZER_COST NUMBER
PARSING_USER_ID NUMBER
PARSING_SCHEMA_ID NUMBER
KEPT_VERSIONS NUMBER
ADDRESS RAW(4)
TYPE_CHK_HEAP RAW(4)
HASH_VALUE NUMBER
CHILD_NUMBER NUMBER
MODULE VARCHAR2(64)
MODULE_HASH NUMBER
ACTION VARCHAR2(64)
ACTION_HASH NUMBER
SERIALIZABLE_ABORTS NUMBER
OUTLINE_CATEGORY VARCHAR2(64) MHE
|
|
|