Tuesday, February 1, 2011

INTER-v$view

Topics to have a touch for Oracle Apps DBA interview ( 3+ yrs ):
Linux : Basic Commands
1.      ls
2.      ln
3.      ps ( ucx, -eaf, -fx )
4.      grep
5.      awk,sed
6.      lsof
7.      netstat
8.      find
9.      top, sar, vmstat
10.  uptime
11.  free
12.  cpuinfo, meminfo
13.  uname ( -a, -ms) ( 32 bit/64 bit )
14.  sysctl.conf
15.  hosts
16.  hostame ( -i, -f )
17.  mount/umount

Oracle DBA ( 10g/11g) :
1.      10g Architechture
2.      Installation of Oracle 10g/11g ( Kernal Parameters significance )
3.      Upgradation from 9i – 10g
4.      Tablespace management
5.      Backups ( Physical [Hot/Cold] , Logical [Exp/Imp/RMAN])
6.      Recovery Scenarios
1.      System datafile loss
2.      Non-System Datafile Loss
3.      Redo logfile loss
4.      Table loss
7.      Cloning ( Hot/RMAN )
8.      Exp/Imp Options also expdp/impdp advancements
9.      tkprof, explain plan, statspack, awr
10.  RMAN configuration and bkps
11.  Datagaurd modes/parameters/configuration
12.  ASM ( concept/RAID/how to add disk group dynamically )
13.  RAC basics ( Architechture/ Cmnds )
14.  11g New feautures

Oracle Apps DBA ( 11i/R12 ) :
         1.      Installation 11i/R12
         2.      11i/R12 Architectural differences
         3.      Apps Patching ( Types of Patches, Reduce downtime, Issues )
         4.      DB Patching ( Types, Apply/Rollback, Issues )
         5.      Inventory ( Local/Global )
         6.      Concurrent Mgr ( Types, Custom Conc Mgr, PCP, Issues )
         7.      Forms ( Servlet/Socket, In R12 how to shift bw them, Config files in 11i/R12)
         8.      Apache ( Main Config files 11i/R12, Locations, Issues like 500 Internal server Error, Blank Pg, Slow etc )
         9.      Point Release and Major Upgrades to R12
        10.  Application Cloning ( Issues, Post Steps )
        11.  Add node
        12.  Custom Top Creation
        13.  Register Conc Prog/Form
        14.  Logfiles and Config files locations
        15.  Autoconfig ( Concept/ Templates/XML files )

-          In the above listed topics some may be missing ( some are intentionally missed as they are supposed to be known to you and interviewer may not stress )
-          Please suggest any more to be added.


Thanks,
Kiran 

No comments:

Post a Comment