Oracle Principles Practice Topics

Oracle Practice Exercises 1.0

February 10, 2017 Friday 9:07:22

1, list the IT industry database types and user distribution
2. List some products commonly used by Oracle Company
3. Brief description of Oracle database software, databases, instances, and their presence
4, through the data dictionary and parameter query database each component
5. Enumerate some common directory structure of Oracle software
6. Enumerate the log directory structure of Oracle
7, detailed description of the database startup process
8. Connection Establishment Process Analysis
9. Connection Error Judgment process
10. Describe several names of the database
11. Describe the composition of the SGA
12. Describe the memory parameters and some rules that are in effect
13. Memory parameter type and modification syntax
14, describe the SPFile and pfile, how to do the conversion and the matter of attention
15, Parameter modification error database cannot start resolve
16, how to find the client and the corresponding process and port number through the server process
17. Describe Pga_aggregate_target parameters and PGA usage status
18, query the memory usage of each process
19. The overall principle of OLTP database parameter assignment

Job 1.1

February 12, 2017 Sunday 3:47:59

20. Configuring Listener.ora Files with NETCA
21, generate two monitors, respectively listener, listener1, ports 1521, 1522, respectively
22, static registration listener and Listener1
23, view official documents, static registration configuration Listener.ora file
24, reference Official document change parameter Local_listener
25, monitoring connection error troubleshooting process
26. Using Netmgr to generate static registration
27. Generate Tnsnames.ora files using NETCA
28, confirm the role of tnsping and the wrong range
29. Use official documents to turn trace monitoring on and off
30. Install Oracle Client (two versions of installation)
31, Sqlplus/as sysdba inside/The meaning and the effective condition
32. Sqlnet.ora open and Close OS authentication
33, describe the password file and the occasion of the effective
34. Use the blacklist in Sqlnet.ora to reject connections from some clients
35, how to directly kill the corresponding port process, forcibly shut down the service
36, describe the dedicated server mode work process, advantages and disadvantages, connection method
37, describe the shared server mode work process, advantages and disadvantages, connection method
38, the configuration system can connect both private and shared two connections, and set the session parameters
39, WebLogic Maintenance of the connection pool working mode
40, describe the database-side connection pool establishment, the solution of the business scenario

Job 1.2

Friday, February 17, 2017 1:42:10
41. Describe the role of 5 large background process
42. Describe the server process
43, description redo log record format, recording process
44. Describe DML and commit execution processes
45. Describe ROWID composition structure
46. Describe the function of table space and add data files
47. Describe the function of each system table space
48. Description Data dictionary and common Data dictionary
49. Describe the execution process of a DDL statement (segment, non-segment)
50. Describe the concept of section block
51. Describe the core advantages of local and ASSM two kinds of technology
52, describe the dictionary, MSSM two kinds of technology disadvantage
53. Related technologies for querying related objects

Job 1.3

February 18, 2017 Saturday 11:31:30
53. Inquire about the related technology used by the relevant object.
54. Data Block Structure description
55, the line link, the line migration description and the judgment way.
56. High water mark description and the way of lowering the high water mark Line.
57, sparse table description and Sparse table collation method.
58. Set up, start and close the EM stand-alone version.
59, using EM to establish table space.
60, the role and characteristics of SCN number
61. Describe the function and significance of system, file, file header, termination, redo log, Commit, Redolog file series SCN number.
62, the system SCN changes in two scenarios.
63, check the various SCN number.

Exercise 1.4

64. Describe the whole process of starting and ending a transaction, including redo, undo, data Block
65, analysis reasons: experienced large DML table, non-normal commit or rollback, performance will be slower
66, Analysis Reason: Rollback speed is very slow
67, Analysis Principle: Write does not block read
68, Analysis Reason: ORA-01555 error
69. Analysis of several cases of the explosion of undo space
70. Undo parameters and adjust best practices
71. Undo monitor, including large transaction, long transaction, undo segment usage, activity transaction
72, VSession-v$process convert each other
73. Alter system kill session ' 140,574 ' and kill-9 the difference between the foreground process and the principle analysis
74, explanation buffer cache four kinds of CHAIN,CBC, LRU, Lruw, ckpt
75. Explain checkpoints, incremental checkpoints, full checkpoints.
76. Complete analysis of database crash recovery
77, after the database crashes, undo damage exception recovery, and the corresponding risk analysis
78, after the database crashes, all redo lost abnormal recovery, and the corresponding risk
79, redo log can be covered by the conditions

Oracle Principles Practice Topics