Oracle DBA入门级练习

aiklee10

一些很好的practice....大家有空可以try try
http://oranil.blogspot.com/2007/ ... or-entry-level.html

1.        Describe Oracle Architecture in detail.
2.        What is instance recovery, crash recovery, session recovery, complete recovery and incomplete recovery?
3.        what is roll forward and roll backward.
4.        Simulate a disaster and recover database to remote location with different file structure.
5.        create another user with same object privileges and roles.
6.        practice export,: schema, tables, FULL and import.
7.        how to make an import work faster.
8.        how to tune sql.
9.        trace out an user session, all sessions, and use of TKPROF and EXPLAN PLAN.
10.        Generate PLAN TABLE and extract usefull contents from PLAN TABLE.
11.        Drop Schema and Recreate the same.
12.        Table Reorg.
13.        Index Rebuild.
14.        Alter table with n records.
15.        Use of HINTS
16.        analyzing tables
17.        Get statistics about REDO logs and Redo Log Switching.
18.        Get info about UNDO Segments.
19.        Shrinking TEMP and UNDO
20.        Move Table from one tablespace to another.
21.        Create Index defination scripts
22.        Adding a data file to tablespace, Resizing a datafile to tablespace, Moving a datafile
23.        how to schedule a job via DBMS_JOBS. How to kill a session from Oracle.
24.        How to get Top 15 wait events. How to list TOP 5 Sql. Query to see the tablespace usage.
25.        How to configure STATSPACK and generate STATSPACK snap shots regularly and produce STATSPACK report daily at 8:00 pm
26.        Are triggers exported alone. What are limitations of EXP/IMP?
27.        Check DB for invalid objects and recompile all of them.
28.        Check DB for Fragmentation : Indexes, Tables
29.        Reorg Tabelspace, DB
30.        Install Oracle DB. Install different versions of Oracle DB into same server
31.        How do u check the status of backups from Oracle. How to shceck the status of Archive Logs and whats the use of V$LOG.
32.        How to get more info about different incarnations of control file.
33.        How to trace Control file to trace and how to recreate the control file.
34.        How to clone database. How to duplicate a DB.
35.        How to implement stand by database.
36.        How to identify the run-away queries.
37.        How to Audit the database for the last 90 days of user access.
38.        How to switch the listener logs and archive Alert logs. How to understand the Listener logs.
39.        How to use UNTIL CANCEL, UNTIL CHANGE, UNTIL TIME in recovery. Practice them.
40.        How to list any corrupt blocks on the database using oracle.
41.        What is Replication. How do u implement it?
42.        How many types of replication are there? Implement an MASTER-MASTER replication.
43.        Design and implement a backup strategy using WSH scripts[physical file backups] and RMAN backups and Windows Scheduler with following requirements : Monthly Cold Back Up, Daily Hot Backup, Daily Archive Log Backup, Daily Exports with 7 year retention period for Cold Backps and 6 month retention period for Daily Hot Backups and Export Dumps have 7 day retention period with Archive Logs having 1 month Retention period.
44.        List all the indexes of a table. Force a query to use a particular Index and another query to do a FULL table scan.
45.        Get the last DDL on a table. Count all the objects in the db. List all invalid objects. Get the total size of database including Archive Logs and Oracle Kernel.
46.        Move a table from one tablespace to another.
47.        Change the Authentication from OS to database. Change the PASSWORD of sys and system.
48.        Create scott schema and other sample schemas.
49.        What are materializsed Views. How to create them and how to purge Mlogs. How to move Mviews to other tablespaces.
50.        How do u use BETWEEN operator with DATE colummns. Can u perform a time-stamp based comparisions.
51.        How do u change SGA size. How do u change db block size from 2 to 8. How do u Pin a SQL procedure in shared pool.
52.        How do u rename a datafile without taking the tablespace offline or anyother down time.
53.        What is Datguard n how do u implement it.
54.        What are bind variables and how u make use of them to increase performance of SQL.
55.        Work on RMAN backups, more channeling, fine tuning, integrating with net backup, backup sets, deleting obselete backups and recovery to remote server with different file structure, validating backups, configuration settings and all with both catalog and control file managed RMAN backups
56.        How do u rename a database.
57.        How do u make a db into archivelog mode.
58.        How to switch from spfile manged to pfile managed database.
59.        How do u reduce the 90 day expiry of all db accounts to 45 day expiry. How do u unlock an user.
60.        What is DB tracing and how ways u can enable tracing in Oracle. How do u do that practically.
61.        Rebuild an index and Analyze the table if it is intact with the new index.

数据库专区

Basically those practice either not organized or not for entry level DBA, for instance, No. 8 how to tune SQL, this is considered OCM-level knowledge, because Oracle SQL can be very complicated.

No. 15 Use of Hints almost no more recommended in 10g and 11g, why still in the practice proposal.

aiklee10

高手.....

lonely2

这不错。。。。
谢谢分享。


但有写问题不是ENTRY LEVEL， 还有一些FUNCTION以不SUPOORT 在１１G 了。。。
LIKE analyze, 现在都用DBMS＿STAT。GATHER＿STATISTICS 了。ER。其实还可以用，但他们以不鼓励用analyze了。