How to view all queries?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to view all queries?

  1. #1
    Join Date
    Nov 2000
    Posts
    29
    Does anyone know how i can see all select statements
    and other queries which users of Oracle run to server.
    There is some programs such Spotlight and DBArtisan,
    which show only latest queries, but i want to see all of them?

  2. #2
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32

    Smile View all query

    Hi,


    you can with V$sql,V$sqltext datadict.

    bye
    Felix
    DBA

  3. #3
    Join Date
    Nov 2000
    Posts
    29
    But i don't know sys and system passwords
    I know only password for administrator

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    why you need sys & system´s password when you have administrator´s privilege?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width