Interview Questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Interview Questions

  1. #1
    Join Date
    Nov 2004
    Posts
    3

    Interview Questions

    Here are two questions that I was asked during one of my interview:

    1- Where does the ORA-XXXX error messages get stored in a Unix system?

    -My Answer: first look at the Alert.log
    -And I would look under the $Oracle_Home\bin directory ?????????


    2- what do you need to do to look at processing status, like process waiting for execution?

    -My Answer: to use statspack utility and to write a script that involves V$session and V$waitstats???

    How would you answer them?

    Thanks,

  2. #2
    Join Date
    Dec 1999
    Location
    Purgatory
    Posts
    346
    I wouldn't. If they don't know the answers to these simple questions, I wouldn't want to work for them.....

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    hmmm I think yu failed you interview

    oerr command, and this command reads from $ORACLE_HOME/rdbms/mesg/oraus.msg



    2 is to look v$session_wait

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