Home » SQL & PL/SQL » SQL & PL/SQL » To Increase the Column Size !!
To Increase the Column Size !! [message #6868] Fri, 09 May 2003 01:14 Go to next message
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 Go to previous message
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
Previous Topic: DECODE Assistance
Next Topic: Dealing Multiple records and no records after Cursor
Goto Forum:
  


Current Time: Fri Apr 26 02:03:24 CDT 2024