Oracle DBA Pen Questions

Unix/linux topic:

1. How to view host CPU, memory, IP and disk space?

cat /proc/cpuinfocat /proc/meminfoifconfig  –afdisk–l

2. What are your common process management and host Performance view commands?

Ps–ef

Iostat

3. Set up DBA and reorganize user Oracle, default shell is bash.

4. How to view the user Oracle's login history and command operation history?

5, write crontab, let script/opt/test.sh at 8:00 every Sunday night to execute

6. How to find all files with the log suffix in the current directory and all of its subdirectories that contain "ora-" or "warning" character content

7, write a shell, complete the automatic login database (user name password is test/testpwd, network connection string is db_wending) and get the database current SCN function

Oracle Database Topics

1. How to quickly understand a database system that has been running for a long time?

2, how to get the execution plan and statistics of SQL statement?

3. List your favorite data dictionary views and dynamic performance views.

4, state the use of database backup and recovery technology, and its advantages and disadvantages.

5, describe the relationship between Table/segment/tablespace/datafile/extent/block.

6, the front desk system reflects very slow, you need to analyze the diagnosis. Please state the diagnostic process in detail, including writing down the possible operating system commands, database views, and so on.

7, the company is ready to upgrade Oracle 9i to Oracle 10.2.0.4, but the approval of the shutdown time of only 10 minutes, how do you plan to respond?

8. The principles and technical features of the Oracle HA technology such as RAC, Dataguard, Streams replication, advanced replication, etc. are stated in detail.

9, write the stored procedure, the current user under the database object number information grouped by object type output.

10. Please write down the Oracle initialization parameters that you often follow