Prob. in connecting as sqlplus "/as sysdba" in 9.2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Prob. in connecting as sqlplus "/as sysdba" in 9.2

  1. #1
    Join Date
    Jan 2003
    Location
    India
    Posts
    7

    Prob. in connecting as sqlplus "/as sysdba" in 9.2

    Hi,

    I am having a problem in oracle9.2 installed on Linux 7.2, starting up the database.
    when I give [ sqlplus "/as sysdba ] at $ prompt its taking a lot of time and my server is becomming slower, and then when I use top command I surprised to see that the Server process which is starting up the database is using nearly 1GB in SIZE & RSS columns.......
    why its like that??????

    Please help me soon......


    Regards,
    Singh.

  2. #2
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Top is not the right utilty to tell you which processes is consuming what amount of memory..its buggy..what is the value of show sga command..

    regards
    Hrishy

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