how to list up all processes in oracle
Results 1 to 6 of 6

Thread: how to list up all processes in oracle

  1. #1
    Join Date
    Apr 2003
    Posts
    4

    how to list up all processes in oracle

    Hi,

    does anyone know, or have a script für oracle that lists up all processes that are currently working on that Database?

    Or is there a function in Oracle DBA Studio or another homebuild Programme of Oracle to list up all processes???

    Hope for an answer!

    Greetz
    Eldrik

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,861
    If it is on unix platform then

    ps -ef | grep oracle

    assuming oracle user owns all the processes.

  3. #3
    Join Date
    Apr 2003
    Posts
    4
    hi,

    no its under Windows.

    I think of something like an sql script like on that gives out how big database is in GB.....

    Greetz
    Eldrik

  4. #4
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,861
    Are you trying to list oracle's operating system processes or currenlty active session in the database?.

    For listing OS processes Windows does not provide any command line utility, you can check www.sysinternals.com to see if they have any freeware.

  5. #5
    Join Date
    Apr 2003
    Posts
    4
    currently the active processes which are working on the database.

    The processes that are used within windows, are mostly fix or not??

    Greetz
    Eldrik

  6. #6
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,861
    Query V$SESSION view for STATUS of ACTIVE in SQL PLUS.

Posting Permissions

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