DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to view all queries?

  1. 11-14-2000, 12:26 AM #1
    maxxx
    maxxx is offline Junior Member
    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?
    Reply With Quote Reply With Quote
  2. 11-14-2000, 01:46 AM #2
    Felix
    Felix is offline Junior Member
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32

    Smile View all query

    Hi,


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

    bye
    Felix
    DBA
    Reply With Quote Reply With Quote
  3. 11-14-2000, 05:31 AM #3
    maxxx
    maxxx is offline Junior Member
    Join Date
    Nov 2000
    Posts
    29
    But i don't know sys and system passwords
    I know only password for administrator
    Reply With Quote Reply With Quote
  4. 11-14-2000, 06:05 AM #4
    pando
    pando is offline Pando & Company
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    why you need sys & system´s password when you have administrator´s privilege?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width