A collection of articles on Oracle themes for UNIX (Solaris).

In this page we offer a collection of articles for Oracle 10g and 9.2.X and UNIX. See also our free Oracle DBA scripts.

• Better than the database console. What is using the CPU? 27-DEC-2007
• The Oracle 10g wait interface in an Oracle Application Express (ApEX) application. Rich in charts and graphs. 1-DEC-2007
• Export into a compressed file
• An RMAN tutorial for beginners: first backup.
• The Oracle Flashback: recover rows deleted or updated by mistake.
• What is the SCN? How does the Oracle recovery work?
• How to determine which UNIX process is accessing a TCP/IP port.
• A sample JSP servlet performing a useful query in an Oracle database (active transactions).
• Installing Oracle using a tar file
• Script for listing the top CPU oracle processes(which oracle UNIX processes are using the most CPU on the server).
• Objects locked and sessions holding the locks.
• Introduction to the Oracle audit.
• Are all Oracle users audited?
• How to reset an Oracle password (without even knowing it).
• Become Oracle Certified DBA the wise way.
• A beginner’s guide to the Oracle Real Application Cluster RAC
• ORA-00257 archiver error: dont’t panic.
• RMAN-05001 error: what does it mean?
• An example of truss with Oracle
• When did an Oracle user logon last time? When was the password changed?