Posts

Oracle Architectural Components

-
                                            Oracle  Architectural Components The oracle architectural component includes a number of primary component like 1) Oracle server 2) Oracle instance 3) Oracle database 4)some mandatory file 5) some optional file 6) user and server process 7) other process 1) Oracle server: oracle server is combination of oracle instance and oracle database once we install oracle server software and then we create oracle database we called mission 2) Oracle instance : Oracle instance in nothing but collection of  SGA and background process, if instance is down we cannot access  data in existing database, instance down means memory have been release from operating system level, some time getting issues for instance level failure ,means CPU utilisation its becomes 100% & memory utilisation it's become 100% 3) Or...
Post a Comment
Read more

DBA Checklist (Activities of Oracle DBA)

-
DBA Checklist (Activities of Oracle DBA) Contents of this Post 1.              Daily DBA Checklist 2.              Daily Night DBA Checklist 3.              Weekly DBA Checklist 4.              Weekly Tuning DBA Checklist 5.              Monthly DBA Checklist 6.              Quarterly DBA Checklist 7.              One Time Activity DBA Checklist Daily DBA Checklist ·                      Health check of the Database Instance and Listener. ·  ...
Post a Comment
Read more

Oracle dba quiz

-
1.In which of the scenarios will the DBA perform recovery? (Choose all that apply.) ·          A) The alert log file is corrupted. ·          B) A tablespace is accidentally dropped. ·          C) One of the redo log members is corrupted. ·          D) A database user terminates the session abnormally. ·          E) The hard disk on which the data file is stored is corrupted Ans: B, E 2.You are not sure if Flashback Database is enabled. What database column and view can you query to see if the flashback logs are being created in the flash recovery area? ·          A) Query the initialization parameter FLASHBACK_DATABASE in VJINSTANCE. ·          B) Query the FLASHBACK_ENABLED column in ...
1 comment
Read more