Results 1 to 2 of 2

Thread: how we can see the sql in shared pool or buffercache

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 11-23-2007 #1
    pande.dhiraj
    pande.dhiraj is offline
    Junior Member
    Join Date
    Nov 2007
    Answers
    22
    Send a message via Yahoo to pande.dhiraj how we can see the sql in shared pool or buffercache

    Smile how we can see the sql in shared pool or buffercache

    hi all


    how we can see the queries which is currently in the sga ie shared pool, buffercahe etc.

    Reply With Quote Reply With Quote
  2. 11-23-2007 #2
    susarlasireesha
    susarlasireesha is offline
    Expert Member
    Join Date
    Apr 2007
    Answers
    500

    Re: how we can see the sql in shared pool or buffercache

    select
    username users, sql_text, Executions, loads, users_executing,
    sharable_mem, persistent_mem
    from
    sys.v_$sqlarea a, dba_users b

    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

About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
GeekInterview
Interact