Oracle Point, Oracle Life.

What are some good resource books for learning/using Oracle?…Read More…

Among this list, my suggestion are shown as following.

1. Oracle 101 Oracle performance tuning; Vaidyanatha, Deshpande, Kostelac

2. Effective Oracle by Design, Tom Kyte

3. High-Performance Oracle, Geoff Ingram

4. Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions, Tom Kyte

5. Unix for the Oracle DBA; Donald K. Burleson

6. Expert one-on-one; Thomas Kyte

7. Effective Oracle Database 10g Security by Design

Popularity: 3% [?]

As Oracle DBA, you should understand Unix well. Please refer to the attached file for a list of solaris command you need to know and likely use.

They are:

01. HD info(vendor, RPM, capacity)
02. Display the number of used and free i-nodes
03. Display processes with the highest CPU utilization
04. Display processes with the highest memory usage
05. Printing disk geometry and partition info
06. Checking whether it’s running in 32-bit mode or 64-bit mode
07. Verifying a route to a specified network
08. print the version of OBP
09. print the version of Open Windows
10. To determine which monitor resolution is available
11. system configuration
12. Display the device list (and drivers attached to devices)
13. processor type, speed
14. patch applied on the system
15. exported file system on NFS server
16, display current run level
17. Find out a package which a file belongs to
18. Examining gcc behavior
19. Display the version of CDE
20. Display the version of BIND
21. system configuration
22. display the current status for each metadevice
23. Swap Administration Interface
24. Check Solaris Semaphore
25. display the size or sizes of a page of memory

Go get complete list of command at Solaris Command Reference for Oracle DBA.pdf

Popularity: 2% [?]