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

Thread: Problemas with a snp0

  1. 01-31-2002, 03:57 PM #1
    rramosb
    rramosb is offline Junior Member
    Join Date
    Jan 2002
    Posts
    8

    Unhappy

    Hi,
    Every day
    the Oracle Instance (7.3.4)
    display this messages
    in the alert log

    Restarting dead backgroun process SNP0


    How can i know what is the problem


    thanks


    Ricardo Ramos
    rramosb@hotmail.com
    Guatemala, Central América


    P.S.
    Sorry for bad english
    Reply With Quote Reply With Quote
  2. 02-01-2002, 01:42 AM #2
    grjohnson's Avatar
    grjohnson
    grjohnson is offline Senior Advisor
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    The SNP0 process is a job_queue_process. It could have stopped for a number or reasons.

    It could've been caused also by issuing the 'alter system kill...' command.

    Cheers,
    OCP 8i, 9i DBA
    Brisbane Australia
    Reply With Quote Reply With Quote
  3. 02-01-2002, 10:47 AM #3
    rramosb
    rramosb is offline Junior Member
    Join Date
    Jan 2002
    Posts
    8

    Red face snp0

    I need to know
    what tables / views use
    to know what is the real
    problem and resolve it
    Reply With Quote Reply With Quote
  4. 02-01-2002, 10:59 AM #4
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    take a look into dba_jobs


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    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