Tuesday, July 22, 2014

Here are few links/ pages for new/beginner DBAs

System Administration/ Unix Scripts

Monitoring CPU output on Solaris and report in excel
tail and grep tools for DBA
Good Linux / Unix System Admin Commands for DBA
Check Hardware configuration of Linux Box
grep next / previous few lines of key word
Collect and report Linux System Activity Information with sar
cpu vs core vs sockets - calculation 
Useful Shell commands and Scripts


Oracle Golden Gate

 

Oracle DBA 

RAC , ASM

Check the distribution of session on all the nodes 

 

SQL, PL/SQL , Automation

To put all the datafiles of the database or a tablespace in autoextend mode
Move table and dependant LOB to other tablespace
Converting Numbers to millions and more ...
Historical growth of tablespace
for the 1st time database users - How to start the database
Adding name of the table in the output from multiple tables

Performance Tuning

Explain plan for SQLs
Export and import of data

Weblogic

FAILED_NOT_RESTARTABLE in WebLogic Server 11g

Peformance Testing