{"id":1496,"date":"2016-10-17T11:56:48","date_gmt":"2016-10-17T02:56:48","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=1496"},"modified":"2023-04-14T16:25:06","modified_gmt":"2023-04-14T07:25:06","slug":"oracle-mri-cycle-check-%ec%86%8c%ea%b0%9c-%ed%85%8c%ed%81%ac%eb%8d%b0%ec%9d%b4%ed%83%80-%ec%83%81%ec%84%b8-%ec%a0%95%ea%b8%b0-%ec%a0%90%ea%b2%80","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=1496","title":{"rendered":"ORACLE MRI CYCLE CHECK \uc18c\uac1c ( \uc624\ub77c\ud074 DBMS \uc0c1\uc138 \uc810\uac80 \ubc29\ubc95 )"},"content":{"rendered":"

 <\/p>\n

\uc624\ub77c\ud074 DBMS \uc0c1\uc138 \uc810\uac80 \ubc29\ubc95<\/p>\n

<\/div>\n

\n

\ubaa9 \ucc28
\n<\/strong><\/span><\/p>\n

1. Target Database Basic Information\u00a0\u00a0\u00a0\u00a09
\n<\/span><\/a><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a010<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a010<\/a>
\n<\/span><\/p>\n

2. Target Database Version Information\u00a0\u00a0\u00a0\u00a011<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a011<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a011<\/a>
\n<\/span><\/p>\n

3. Target Database Session Information\u00a0\u00a0\u00a0\u00a012<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a012<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a012<\/a>
\n<\/span><\/p>\n

4. Target Database use for system resources Information\u00a0\u00a0\u00a0\u00a012<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a012<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a013<\/a>
\n<\/span><\/p>\n

5. SGA Set Status\u00a0\u00a0\u00a0\u00a013<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a013<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a013<\/a>
\n<\/span><\/p>\n

6. The main parameter settings Status\u00a0\u00a0\u00a0\u00a014<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a014<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a014<\/a>
\n<\/span><\/p>\n

7. Database configuration status of the control file\u00a0\u00a0\u00a0\u00a015<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a015<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a015<\/a>
\n<\/span><\/p>\n

8. On-Line Portfolio Composition Redo Log Files\u00a0\u00a0\u00a0\u00a015<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a015<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a016<\/a>
\n<\/span><\/p>\n

9. Per Minute Log Switch Generation Count (Collect Last 7 Days)\u00a0\u00a0\u00a0\u00a016<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a016<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a016<\/a>
\n<\/span><\/p>\n

10. Hourly Occurrence Log Switch Status (Hour)\u00a0\u00a0\u00a0\u00a017<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a017<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a018<\/a>
\n<\/span><\/p>\n

11. Date Archived Log Generation Status (Collect Last 7 Days)\u00a0\u00a0\u00a0\u00a018<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a018<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a018<\/a>
\n<\/span><\/p>\n

12. Default tablespace of the User and the Default temp tablespace of the User\u00a0\u00a0\u00a0\u00a019<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a019<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a019<\/a>
\n<\/span><\/p>\n

13. Database User Password Expired Check\u00a0\u00a0\u00a0\u00a020<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a020<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a020<\/a>
\n<\/span><\/p>\n

14. Database user Object Summary List\u00a0\u00a0\u00a0\u00a020<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a021<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a021<\/a>
\n<\/span><\/p>\n

15. Invalid Object Check\u00a0\u00a0\u00a0\u00a021<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a021<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a022<\/a>
\n<\/span><\/p>\n

16. DataBase Total Size\u00a0\u00a0\u00a0\u00a022<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a022<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a022<\/a>
\n<\/span><\/p>\n

17. Table space Used 90% (Used >= 90%)\u00a0\u00a0\u00a0\u00a022<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a022<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a023<\/a>
\n<\/span><\/p>\n

18. Table Space Fragmentation\u00a0\u00a0\u00a0\u00a023<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a023<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a025<\/a>
\n<\/span><\/p>\n

19. Auto Extend Feature is Set Data file Information\u00a0\u00a0\u00a0\u00a025<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a025<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a026<\/a>
\n<\/span><\/p>\n

20. Parallel Degree 2 or more, set the Table \/ Index list (Top 10)\u00a0\u00a0\u00a0\u00a026<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a026<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a027<\/a>
\n<\/span><\/p>\n

21. One Tablespace Has mixed Table + Index list\u00a0\u00a0\u00a0\u00a027<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a027<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a027<\/a>
\n<\/span><\/p>\n

22. Sequence List (Used >= 95%)\u00a0\u00a0\u00a0\u00a028<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a028<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a028<\/a>
\n<\/span><\/p>\n

23. Database Link List\u00a0\u00a0\u00a0\u00a029<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a029<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a029<\/a>
\n<\/span><\/p>\n

24. Collect Statistical Information into the Database (Analyze)\u00a0\u00a0\u00a0\u00a029<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a029<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a030<\/a>
\n<\/span><\/p>\n

25. Constraint segment exists, but the list is used in the Disable state\u00a0\u00a0\u00a0\u00a030<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a030<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a031<\/a>
\n<\/span><\/p>\n

26. Index not Foreign Key Constraint\u00a0\u00a0\u00a0\u00a031<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a031<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a031<\/a>
\n<\/span><\/p>\n

27. Index, 10GB or larger without gateun Table List\u00a0\u00a0\u00a0\u00a031<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a032<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a032<\/a>
\n<\/span><\/p>\n

28. Index numbers are excessive Table Information\u00a0\u00a0\u00a0\u00a032<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a032<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a032<\/a>
\n<\/span><\/p>\n

29. Execessive Split Index List (block > 1000)\u00a0\u00a0\u00a0\u00a033<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a033<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a033<\/a>
\n<\/span><\/p>\n

30. LOB Detail Information\u00a0\u00a0\u00a0\u00a033<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a033<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a034<\/a>
\n<\/span><\/p>\n

31. All parameters set status Check\u00a0\u00a0\u00a0\u00a034<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a034<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a036<\/a>
\n<\/span><\/p>\n

32. Archive Log Information\u00a0\u00a0\u00a0\u00a036<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a036<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a037<\/a>
\n<\/span><\/p>\n

33. Recovery Area\u00a0\u00a0\u00a0\u00a037<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a037<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a038<\/a>
\n<\/span><\/p>\n

34. Fast Recovery Area Information\u00a0\u00a0\u00a0\u00a038<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a038<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a038<\/a>
\n<\/span><\/p>\n

35. Rman Backup Information\u00a0\u00a0\u00a0\u00a038<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a038<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a039<\/a>
\n<\/span><\/p>\n

36. Backup Information (30 Days)\u00a0\u00a0\u00a0\u00a039<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a039<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a040<\/a>
\n<\/span><\/p>\n

37. ASM Information\u00a0\u00a0\u00a0\u00a040<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a040<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a041<\/a>
\n<\/span><\/p>\n

38. ASM Partnering Disk\u00a0\u00a0\u00a0\u00a041<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a041<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a041<\/a>
\n<\/span><\/p>\n

39. Alert Log Online Backup Message detail (5 Day)\u00a0\u00a0\u00a0\u00a041<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a041<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a042<\/a>
\n<\/span><\/p>\n

40. Alert Log Error Message Total summary (30 Days)\u00a0\u00a0\u00a0\u00a042<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a042<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a042<\/a>
\n<\/span><\/p>\n

41. Alert Log Error Message Day Summary (30 Days)\u00a0\u00a0\u00a0\u00a042<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a042<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a043<\/a>
\n<\/span><\/p>\n

42. Alert Log Online Backup Message Day Summary (30 Days)\u00a0\u00a0\u00a0\u00a043<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a043<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a043<\/a>
\n<\/span><\/p>\n

43. Oracle Database Option Usage\u00a0\u00a0\u00a0\u00a043<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a043<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a044<\/a>
\n<\/span><\/p>\n

44. Oracle Database Usage Options Details\u00a0\u00a0\u00a0\u00a044<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a044<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a045<\/a>
\n<\/span><\/p>\n

45. Literal SQL Check\u00a0\u00a0\u00a0\u00a045<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a045<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a046<\/a>
\n<\/span><\/p>\n

46. H\/W Plat formation\u00a0\u00a0\u00a0\u00a046<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a046<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a046<\/a>
\n<\/span><\/p>\n

47. H\/W CPU Information\u00a0\u00a0\u00a0\u00a046<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a046<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

48. H\/W MEMORY Information\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

49. OS Version Check\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

50. OS Disk \/ Storage Information\u00a0\u00a0\u00a0\u00a047<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a048<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a048<\/a>
\n<\/span><\/p>\n

51. O\/S Packages Information\u00a0\u00a0\u00a0\u00a048<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a048<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a049<\/a>
\n<\/span><\/p>\n

52. O\/S Patch Information (Solaris 10 Only)\u00a0\u00a0\u00a0\u00a049<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a049<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a050<\/a>
\n<\/span><\/p>\n

53. Kernel Parameter Recommendations\u00a0\u00a0\u00a0\u00a050<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a050<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a052<\/a>
\n<\/span><\/p>\n

54. Ulimit\u00a0\u00a0\u00a0\u00a052<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a052<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a053<\/a>
\n<\/span><\/p>\n

55. Database Patch Information\u00a0\u00a0\u00a0\u00a053<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a053<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a058<\/a>
\n<\/span><\/p>\n

56. \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95#1\u00a0\u00a0\u00a0\u00a058<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a058<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc791\uc131 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a059<\/a>
\n<\/span><\/p>\n

57. \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95 #2\u00a0\u00a0\u00a0\u00a059<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a059<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc791\uc131 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a060<\/a>
\n<\/span><\/p>\n

58. \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95 #3\u00a0\u00a0\u00a0\u00a060<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a060<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc791\uc131 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a061<\/a>
\n<\/span><\/p>\n

59. \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95 #4\u00a0\u00a0\u00a0\u00a061<\/a>
\n<\/span><\/p>\n

A.\u00a0\u00a0\u00a0\u00a0<\/span>\uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a061<\/a>
\n<\/span><\/p>\n

B.\u00a0\u00a0\u00a0\u00a0<\/span>\uc791\uc131 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a062<\/a>
\n<\/span><\/p>\n

    \n
  1. Target Database Basic Information
    \n<\/strong><\/span><\/li>\n<\/ol>\n

    \n

      \n
    1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
      \n<\/strong><\/span><\/li>\n<\/ol>\n


      \n<\/strong><\/span><\/p>\n

        \n
      1. \uc810\uac80 \ub0b4\uc6a9
        \n<\/strong><\/span><\/li>\n<\/ol>\n

        1\ubc88 \ud56d\ubaa9\uc740 Database\uc758 \uac00\uc7a5 \uae30\ubcf8\uc801\uc778 \uc815\ubcf4\ub4e4\uc744 \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
        \nStartup_Time \uae30\uac04\uc774 \uae38\uc5b4 \uc9c8\uc218\ub85d \uc7a0\uc7ac\uc801 \ubb38\uc81c \ubc1c\uc0dd \uc694\uc18c\uac00 \ub418\uace0 Status\uac00 NOMOUNT & MOUNT & OPEN \uc0c1\ud0dc\uc778\uc9c0 \ud655\uc778 \ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.
        \n<\/span><\/p>\n

        \n

          \n
        1. Target Database Version Information
          \n<\/strong><\/span><\/li>\n<\/ol>\n

           <\/p>\n

            \n
          1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
            \n<\/strong><\/span><\/li>\n<\/ol>\n


            \n<\/span><\/p>\n

            \n

              \n
            1. \uc810\uac80 \ub0b4\uc6a9
              \n<\/strong><\/span><\/li>\n<\/ol>\n

              2\ubc88 \ud56d\ubaa9\uc740 Database\uc758 Version\uc815\ubcf4\ub97c \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
              \n\uac01 Version\uc744 \ud655\uc778\ud574\uc11c \ud604\uc7ac Version\uc758 \ud328\uce58\uac00 \uc7ac\ub300\ub85c \ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud558\uc5ec \ucd5c\uc2e0 \ud328\uce58\ub85c \uad8c\uace0 \ud560 \uc218 \uc788\uc73c\uba70 End of Service\ub97c \ud655\uc778\ud558\uc5ec \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
              \n<\/span><\/p>\n

              \n

                \n
              1. \n
                Target Database Session Information
                \n<\/strong><\/span><\/div>\n
                  \n
                1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                  \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                  \n<\/span><\/p>\n

                  \n

                    \n
                  1. \uc810\uac80 \ub0b4\uc6a9
                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                    3\ubc88 \ud56d\ubaa9\uc740 \ud574\ub2f9 Database Node\ubcc4\ub85c \uc138\uc158 \uc815\ubcf4\ub97c \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                    \nTotal\uc138\uc158\uacfc Active\uc138\uc158\uc744 \ube44\uad50\ud574\uc11c Inactive\uc138\uc158\uc758 \uc22b\uc790\ub97c \uc54c \uc218 \uc788\uace0 Active\uc138\uc158 \uc218 \ub300\ube44\ud558\uc5ec Inactive\uc138\uc158\uc758 \uc218\uac00 \ub9ce\ub2e4\uba74 \ubd88\ud544\uc694\ud55c \uc138\uc158\uc744 \uc815\ub9ac\ud558\uc5ec \ub9ac\uc18c\uc2a4\ub97c \ud655\ubcf4 \ud574\uc904 \uc218 \uc788\uc2b5\ub2c8\ub2e4. (WAS\uac19\uc740 Middleware \ud658\uacbd\uc774\uba74 \ucee4\ub125\uc158 polling \uad6c\uc870\ub85c Inactive\uc138\uc158\uc758 \uc22b\uc790\uac00 \uc801\uc740 \ud3b8\uc774\ub2e4)
                    \n<\/span><\/p>\n

                     <\/p>\n

                      \n
                    1. \n
                      Target Database use for system resources Information
                      \n<\/strong><\/span><\/div>\n
                        \n
                      1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                        \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                        \n<\/span><\/p>\n

                        \u2026
                        \n<\/span><\/p>\n


                        \n<\/span><\/p>\n

                        \n

                          \n
                        1. \uc810\uac80 \ub0b4\uc6a9
                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                          4\ubc88 \ud56d\ubaa9\uc740 \uac01 Node\ubcc4\ub85c \uc2dc\uc2a4\ud15c \ub9ac\uc18c\uc2a4 \uc810\uc720 \uc0c1\ud0dc \uc815\ubcf4\ub97c \ucd9c\ub825\ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                          \nSessions\uc640 Process\ub97c \ubcf4\uc544\uc57c \ud558\uba70 \uc138\uc158\uc774 Full\uc774 \ub41c \uc801\uc774 \uc788\ub294\uc9c0 \ud655\uc778 \ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.
                          \n<\/span><\/p>\n

                            \n
                          1. \n
                            SGA Set Status
                            \n<\/strong><\/span><\/div>\n
                              \n
                            1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                              \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                              \n<\/span><\/p>\n

                              \n

                                \n
                              1. \uc810\uac80 \ub0b4\uc6a9
                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                5\ubc88 \ud56d\ubaa9\uc740 \uacf5\uc6a9 \uba54\ubaa8\ub9ac \uacf5\uac04\uc778 SGA\uc758 \uc0c1\ud0dc\uc815\ubcf4\ub97c \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                \n\uba54\ubaa8\ub9ac \uad00\ub9ac \ubc29\uc2dd\uc774 ASMM \uc778\uc9c0 AMM\uc778\uc9c0 \uc54c \uc218 \uc788\uace0 \ubb3c\ub9ac\uba54\ubaa8\ub9ac\uc5d0 \ube44\ud574\uc11c PGA\uc640 SGA\uc758 \uba54\ubaa8\ub9ac\uac00 \uc801\ub2f9\ud55c\uc9c0 \ud655\uc778\ud558\uc5ec \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                \nASMM (Automatic Shared Memory Management) – \u00a0\u00a0\u00a0\u00a010G\ubd80\ud130 \ub3c4\uc785\ub41c \uba54\ubaa8\ub9ac \uad00\ub9ac \ubc29\uc2dd\uc73c\ub85c ORACLE\uc774 \uc5c5\ubb34 \ubd80\ud558\ub97c \ud310\ub2e8\ud558\uc5ec SGA\uc601\uc5ed (Shared Pool, Database Buffer Cache, Large Pool, Java Pool)\uc758 \ud06c\uae30\ub97c \uc870\uc815\ud558\ub294 \ubc29\uc2dd\uc774\ub2e4.
                                \n<\/span><\/p>\n

                                AMM (Automatic Memory Management)\u00a0\u00a0\u00a0\u00a0– \u00a0\u00a0\u00a0\u00a0 11G\ubd80\ud130 \ub3c4\uc785\ub41c \uba54\ubaa8\ub9ac \uad00\ub9ac \ubc29\uc2dd\uc73c\ub85c SGA \uc601\uc5ed\ubfd0\ub9cc \uc544\ub2c8\ub77c PGA \uc601\uc5ed\ub3c4 ORACLE\uc774 \uc790\ub3d9\uc73c\ub85c \uad00\ub9ac \ud574\uc8fc\ub294 \ubc29\uc2dd\uc774\ub2e4.
                                \n<\/span><\/p>\n

                                  \n
                                1. \n
                                  The main parameter settings Status
                                  \n<\/strong><\/span><\/div>\n
                                    \n
                                  1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                    \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                    \n<\/span><\/p>\n

                                     <\/p>\n

                                      \n
                                    1. \uc810\uac80 \ub0b4\uc6a9
                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                      6\ubc88 \ud56d\ubaa9\uc740 Main Parameter\ub4e4\uc744 \ud655\uc778 \ud560 \uc218 \uc788\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                      \nDB_BLOCK_SIZE\uac00 \uae30\ubcf8\uac12\uc778 8K\uc778 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uace0 DB_FILES\uac00 200\uc778\ub370 200\uc774\uc0c1 \ub118\uc5b4\uac00\uba74 \uc5d0\ub7ec\uac00 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc73c\ubbc0\ub85c 200\uc774\uc0c1\uc774\ub77c\uba74 Parameter\uac12\uc744 \uc99d\uac00 \uc2dc\ucf1c \uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                      \nDB_FILE_MULTIBLOCK_READ_COUNT \ub294 \ud55c\ubc88\uc5d0 read \ud560 \uc218 \uc788\ub294block\uc758 \uc22b\uc790\ub97c \ub098\ud0c0\ub0b4\uace0 \ub0ae\uc744\uc218\ub85d OLTP \ub192\uc744\uc218\ub85d DW \ud658\uacbd \uc785\ub2c8\ub2e4.
                                      \n<\/span><\/p>\n

                                       <\/p>\n

                                        \n
                                      1. \n
                                        Database configuration status of the control file
                                        \n<\/strong><\/span><\/div>\n
                                          \n
                                        1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                          \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                          \n<\/span><\/p>\n

                                          \n

                                            \n
                                          1. \uc810\uac80 \ub0b4\uc6a9
                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                            7\ubc88 \ud56d\ubaa9\uc740 Control File\uc758 \uc704\uce58\ub97c \ub098\ud0c0\ub0b4\uc5b4 \uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. \uc774\ubbf8\uc9c0\ub97c \ubcf4\uba74 \ucee8\ud2b8\ub864\ud30c\uc77c\uc774 \uc788\ub294 \uacbd\ub85c\uc640 Control File\uc758 \uac1c\uc218\uac00 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4. Control File\ub4e4\uc774 \uc804\ubd80 \uac19\uc740 Directory\uc5d0 \uc788\ub2e4\uba74 Directory\uc5d0 \ubb38\uc81c\uac00 \uc0dd\uae38 \uacbd\uc6b0 DB\uac00 \uc7ac\ub300\ub85c \uc791\ub3d9\ud558\uc9c0 \uc54a\uc744 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 Control File\uc758 \uc704\uce58\ub97c \uc774\uc911\ud654 \uc2dc\ud0a4\uae30\ub97c \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                            \n<\/span><\/p>\n

                                             <\/p>\n

                                              \n
                                            1. \n
                                              On-Line Portfolio Composition Redo Log Files
                                              \n<\/strong><\/span><\/div>\n
                                                \n
                                              1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                \n<\/span><\/p>\n

                                                 <\/p>\n

                                                  \n
                                                1. \uc810\uac80 \ub0b4\uc6a9
                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                  8\ubc88 \ud56d\ubaa9\uc740 Redo Log Files\uc758 \uc815\ubcf4\ub97c \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. \uac01 Node\ubcc4\ub85c 1Group\ub2f9 2Member\uc529 \uac00\uc9c0\uace0 \uc788\uace0 512MB\uc758 Size\ub97c \uac16\uace0 \uc788\ub294 \uac83\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                  \nRedo Log File 1Group\ub2f9 2Member \uc774\uc0c1\uc740 \uac16\uace0 \uc788\uc5b4\uc57c \ud558\uba70 \uacbd\ub85c\ub3c4 \uc774\uc911\ud654 \uc2dc\ud0a4\uae30\ub97c \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. Group\uc740 2\uac1c\uc529 \uac00\uc9c0\uace0 \uc788\uc5b4\uc57c \ud558\uba70 Group\uc218\uac00 \ub9ce\ub2e4\uba74 Member\uc218\ub97c \ub298\ub9ac\uace0 Group\uc218\ub97c \uc904\uc5ec\uc8fc\ub294 \uac83\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. ( Size \uc808\uac10\uc744 \uc704\ud574\uc11c )
                                                  \n<\/span><\/p>\n

                                                   <\/p>\n

                                                    \n
                                                  1. \n
                                                    Per Minute Log Switch Generation Count (Collect Last 7 Days)
                                                    \n<\/strong><\/span><\/div>\n
                                                      \n
                                                    1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                      \n<\/span><\/p>\n

                                                       <\/p>\n

                                                        \n
                                                      1. \uc810\uac80 \ub0b4\uc6a9
                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                        9\ubc88 \ud56d\ubaa9\uc740 \ucd5c\uadfc \uc77c\uc8fc\uc77c \ub0b4 Log Switch \ud69f\uc218\ub97c \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. Log switch \ud69f\uc218\ub97c \ubcf4\uace0 \ud69f\uc218\uac00 \ubcc4\ub85c \uc77c\uc5b4\ub098\uc9c0 \uc54a\ub294\ub2e4\uba74 \ub514\uc2a4\ud06c\uc808\uac10\uc744 \uc704\ud574\uc11c Group\uc218 & Size\ub97c \uc904\uc5ec\uc57c \ud569\ub2c8\ub2e4.
                                                        \n\ube44\uc728\ub85c \ubd24\uc744 \ub54c 30\ubd84 \uc774\uc0c1\uc774 80%\uc778 \uac83\uc774 \uc774\uc0c1\uc801\uc785\ub2c8\ub2e4.
                                                        \n\uc774 \ud56d\ubaa9\uc744 \ud1b5\ud574\uc11c \uc8fc\ub85c \uc5b4\ub290 \uc2dc\uac04\uc5d0 \ubcc0\uacbd\uc774 \ub9ce\uc774 \uc77c\uc5b4 \ub0ac\ub294\uc9c0\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                        \n<\/span><\/p>\n

                                                        \uc0ac\uc774\ud2b8\uc5d0\uc11c Redo log \ud06c\uae30\uc5d0 \ub300\ud574 \uc5b8\uae09\ud560 \ub54c\ub9c8\ub2e4 \ub108\ubb34 \ucee4\uc9c0\uba74 \uc131\ub2a5 \uc800\ud558\uac00 \uc77c\uc5b4\ub098\uc9c0 \uc54a\uc744\uae4c \uc6b0\ub824\ud558\ub294 \uacbd\uc6b0\ub97c \uc790\uc8fc \uc811\ud558\uac8c \ub418\ub294\ub370 \uc0ac\uc2e4 Redo \ub85c\uadf8\ub294 \ucee4\uc9c8\uc218\ub85d \uc131\ub2a5\uc5d0 \uc720\ub9ac\ud569\ub2c8\ub2e4. \ub108\ubb34 Log Switch\uac00 \uc790\uc8fc \uc77c\uc5b4\ub098\uba74 Archiving \ubc0f \uccb4\ud06c\ud3ec\uc778\ud2b8\uac00 \uc790\uc8fc \ubc1c\uc0dd\ud558\uac8c \ub418\ubbc0\ub85c Archiver \ud504\ub85c\uc138\uc2a4\uc640 DBWR \ud504\ub85c\uc138\uc2a4\uac00 \ubc14\ube60\uc9d1\ub2c8\ub2e4.
                                                        \n<\/span><\/p>\n

                                                        v$log_history \ubdf0\ub97c \uc870\ud68c\ud574\ubcf4\uba74 \ub85c\uadf8 \uc2a4\uc704\uce58\uac00 \uc5bc\ub9c8\ub098 \uc790\uc8fc \uc77c\uc5b4\ub098\ub294\uc9c0 \uc54c \uc218 \uc788\uace0 \uc624\ub77c\ud074\uc758 \uad8c\uace0\uc548\uc740 20\ubd84\uc5d0 \ud55c\ubc88\uc529 \uc77c\uc5b4\ub098\ub294 \uac83\uc785\ub2c8\ub2e4. \uc774 \uad8c\uace0\uc548\uc744 \ubc18\ub4dc\uc2dc \uc900\uc218\ud560 \ud544\uc694\ub294 \uc5c6\uc9c0\ub9cc \uc801\uc5b4\ub3c4 5~10\ubd84 \uc0ac\uc774\uc5d0 \ud55c\ubc88\uc529 \ub85c\uadf8 \uc2a4\uc704\uce58\uac00 \uc77c\uc5b4\ub098\ub3c4\ub85d \uc124\uc815\ud574\uc8fc\ub294 \uac83\uc744 \uad8c\uc7a5\ud569\ub2c8\ub2e4.
                                                        \n<\/span><\/p>\n

                                                        \ub610 Redo\uac00 \uc9c0\ub098\uce58\uac8c \uc791\uc73c\uba74 Log File Switch Completion \ub4f1 \ub300\uae30 \uc774\ubca4\ud2b8\uac00 \ubb38\uc81c\uac00 \ub420 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                        \n<\/span><\/p>\n

                                                         <\/p>\n

                                                          \n
                                                        1. \n
                                                          Hourly Occurrence Log Switch Status (Hour)
                                                          \n<\/strong><\/span><\/div>\n
                                                            \n
                                                          1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                            \n<\/span><\/p>\n

                                                            \n

                                                              \n
                                                            1. \uc810\uac80 \ub0b4\uc6a9
                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                              10\ubc88 \ud56d\ubaa9\uc740 Log Switch \ud69f\uc218\ub97c \ub0a0\uc9dc \ubcc4 \uc2dc\uac04\ub2e8\uc704\ub85c \ucd9c\ub825\ud574 \uc8fc\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                              \n\uc774 \ud56d\ubaa9\uc744 \ud1b5\ud574\uc11c\ub294 \uc5b4\ub290 \ub0a0\uc9dc \uc5b4\ub290 \uc2dc\uac04\uc5d0 \ubcc0\uacbd\uc774 \ub9ce\uc774 \uc77c\uc5b4 \ub0ac\ub294\uc9c0 \uc54c \uc218 \uc788\uc73c\uba70 \uc8fc\ub85c \ubcc0\uacbd\uc774 \ub9ce\uc774 \uc77c\uc5b4\ub098\ub294 \uc2dc\uac01\uc744 \ud655\uc778\ud558\uc5ec \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                              \n<\/span><\/p>\n

                                                               <\/p>\n

                                                                \n
                                                              1. \n
                                                                Date Archived Log Generation Status (Collect Last 7 Days)
                                                                \n<\/strong><\/span><\/div>\n
                                                                  \n
                                                                1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                  \n<\/span><\/p>\n

                                                                  \n

                                                                    \n
                                                                  1. \uc810\uac80 \ub0b4\uc6a9
                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                    11\ubc88 \ud56d\ubaa9\uc740 \ucd5c\uadfc \uc77c\uc8fc\uc77c\uac04 \uc77c\ubcc4\ub85c Archive Log File \uc0dd\uc131\ub41c \ud69f\uc218\uc640 \uadf8 \ud30c\uc77c\ub4e4\uc758 Size\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                    \n\uc774 \ud56d\ubaa9\uc744 \ud1b5\ud574\uc11c\ub294 \ubcc0\uacbd \ub7c9\uc774 \uc801\uc740 \uc694\uc77c\uc774\ub098 \ub9ce\uc740 \uc694\uc77c\uc744 \uc54c \uc218 \uc788\uace0 Redo Log\uac00 \ub2e4\ucc28\uae30\ub3c4\uc804\uc5d0 Archive\uac00 \uc790\uc8fc \uc77c\uc5b4\ub098\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub610\ud55c Begin Backup \/ End Backup \uc2dc SCN\uc774 \ubc14\ub00c\uace0Application\uc5d0 DDL\uc774 \ub4e4\uc5b4 \uc788\uc73c\uba74 \ub2e4 \uc4f0\uc9c0 \uc54a\uc544\ub3c4 Archive\uc5d0 \ub0b4\ub824 \uc4f0\ub294 \uacbd\uc6b0\uac00 \uc0dd\uae38 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                                    \n<\/span><\/p>\n

                                                                     <\/p>\n

                                                                      \n
                                                                    1. \n
                                                                      Default tablespace of the User and the Default temp tablespace of the User
                                                                      \n<\/strong><\/span><\/div>\n
                                                                        \n
                                                                      1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                        \n<\/span><\/p>\n

                                                                          \n
                                                                        1. \uc810\uac80 \ub0b4\uc6a9
                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                          12\ubc88 \ud56d\ubaa9\uc740 Default\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c System\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub85c \uc9c0\uc815\ud558\uace0 \uc788\ub294 \uc720\uc800\ub4e4\uc758 \uc815\ubcf4\ub97c \ucd9c\ub825\ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. System\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0\ub294 \uc2dc\uc2a4\ud15c \uc6b4\uc601\uc5d0 \ud544\uc694\ud55c Data Dictionary<\/span>\uc640 \uc800\uc7a5 \ud504\ub85c\uc2dc\uc800, DB\ud2b8\ub9ac\uac70 \ub4f1\uc774 \uc800\uc7a5 \ub418\uc5b4 \uc788\ub294 \ub9e4\uc6b0 \uc911\uc694\ud55c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc774\ubbc0\ub85c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\ub294 \uac83\uc744 \uad8c\uace0 \ud574\uc57c \ud569\ub2c8\ub2e4.
                                                                          \n\ud14c\uc774\ube14\uc744 \ub9cc\ub4e4 \ub54c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uc9c0\uc815\ud558\uc9c0 \uc54a\uc73c\uba74 \uc790\ub3d9\uc73c\ub85c System\ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub85c \uc9c0\uc815\uc774 \ub418\ubbc0\ub85c \uc720\uc800\uc758 Default \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uac00 \uc874\uc7ac\ud558\ub294\uc9c0 \uc548\ud558\ub294\uc9c0 \ud655\uc778\ud558\uace0 \uc9c0\uc815 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c \uc784\uc2dc \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub294 \ubd84\ub9ac\uac00 \ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                          \n<\/span><\/p>\n

                                                                           <\/p>\n

                                                                            \n
                                                                          1. \n
                                                                            Database User Password Expired Check
                                                                            \n<\/strong><\/span><\/div>\n
                                                                              \n
                                                                            1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                              \n<\/span><\/p>\n

                                                                              \n

                                                                                \n
                                                                              1. \uc810\uac80 \ub0b4\uc6a9
                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                13\ubc88 \ud56d\ubaa9\uc740 Database \uc720\uc800\ub4e4\uc758 \uc138\uc158 \uc811\uc18d \uad8c\ud55c\uacfc Password \uc0dd\uc131\uc77c \ub9cc\ub8cc\uc77c \ub4f1\uc744 \ucd9c\ub825\ud574\uc8fc\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4. Lock\uac78\ub9b0 \uc720\uc800\ub098 Password \ub9cc\ub8cc\uc77c\uc744 \ub4f1\uc744 \ud655\uc778\ud558\uc5ec \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                \n<\/span><\/p>\n

                                                                                .
                                                                                \n<\/span><\/p>\n

                                                                                  \n
                                                                                1. \n
                                                                                  Database user Object Summary List
                                                                                  \n<\/strong><\/span><\/div>\n
                                                                                    \n
                                                                                  1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                    \n<\/span><\/p>\n

                                                                                    \n

                                                                                      \n
                                                                                    1. \uc810\uac80 \ub0b4\uc6a9
                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                      14\ubc88 \ud56d\ubaa9\uc740 \uac01 Owner\ubcc4\ub85c Object\uc758 \ub9ac\uc2a4\ud2b8 \ubc0f \uc218\ub7c9\uc744 \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                      \n\ubcf4\uc548\uc5d0 \ucde8\uc57d\ud55c Public Synonym \uc740 \ub9ce\uc73c\uba74 \ub9ce\uc744\uc218\ub85d \uc88b\uc9c0 \uc54a\ub2e4.
                                                                                      \n\uc5b4\ub5a4 Owner\uac00 \uac00\uc7a5 \ub9ce\uc740 Table\uacfc Index\ub97c \uac00\uc9c0\uace0 \uc788\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4..
                                                                                      \n<\/span><\/p>\n

                                                                                       <\/p>\n

                                                                                        \n
                                                                                      1. \n
                                                                                        Invalid Object Check
                                                                                        \n<\/strong><\/span><\/div>\n
                                                                                          \n
                                                                                        1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                          \n<\/span><\/p>\n

                                                                                          \n

                                                                                            \n
                                                                                          1. \uc810\uac80 \ub0b4\uc6a9
                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                            15\ubc88 \ud56d\ubaa9\uc740 Invalid \uc0c1\ud0dc\uc778 Object\ub4e4\uc744 \ucd9c\ub825\ud558\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. \uc0ac\uc6a9\ud558\ub2e4\uac00 \uace0\uc7a5\uc774 \ub0ac\uac70\ub098 \uc758\ub3c4\uc801\uc73c\ub85c Invalid\uc0c1\ud0dc\ub85c \ub9cc\ub4e0 \uac83\uc744 \uccb4\ud06c\ud558\uc5ec \uc6b4\uc601\ud558\uae30 \uc804\uc5d0 valid \uc0c1\ud0dc\ub85c \ubc14\uafd4 \uc8fc\uac70\ub098 \uc548\uc4f0\ub294 Object\ub294 \uc81c\uac70\ud560 \uac83\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                            \n<\/span><\/p>\n

                                                                                             <\/p>\n

                                                                                             <\/p>\n

                                                                                              \n
                                                                                            1. \n
                                                                                              DataBase Total Size
                                                                                              \n<\/strong><\/span><\/div>\n
                                                                                                \n
                                                                                              1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                \n<\/span><\/p>\n

                                                                                                \n

                                                                                                  \n
                                                                                                1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                  16\ubc88 \ud56d\ubaa9\uc740 Database\uc758 \uc804\uccb4 \ud06c\uae30\uc640 Used Size, Free Size\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                  \nUsed\ub97c \uccb4\ud06c\ud574\uc11c Free\uc0ac\uc774\uc988\uac00 \uc5bc\ub9c8\ub098 \ub0a8\uc558\ub294\uc9c0 \uccb4\ud06c\ud560 \uc218 \uc788\uace0 \ud6a8\uc728\uc131 \uccb4\ud06c\ub97c \ud1b5\ud574 \ube44\ud6a8\uc728\uc801\uc778 \ub514\uc2a4\ud06c\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4. ( Table\uacfc Index\uc758 Size = Used )
                                                                                                  \n<\/span><\/p>\n

                                                                                                   <\/p>\n

                                                                                                    \n
                                                                                                  1. \n
                                                                                                    Table space Used 90% (Used >= 90%)
                                                                                                    \n<\/strong><\/span><\/div>\n
                                                                                                      \n
                                                                                                    1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                      \n<\/span><\/p>\n

                                                                                                      \n

                                                                                                        \n
                                                                                                      1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                        17\ubc88 \ud56d\ubaa9\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uc6a9\ub7c9\uc774 90%\uc774\uc0c1\uc778 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                        \n\uc790\ub3d9 \uc99d\uac00 \ubaa8\ub4dc\ub85c \ub418\uc5b4 \uc788\uc5b4\uc11c Size\uac00 \uc790\ub3d9\uc73c\ub85c \uc99d\uac00 \ub418\uaca0\uc9c0\ub9cc File\uc744 \uc4f8 \ub54c CPU\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uace0 \uc790\ub3d9 \uc99d\uac00 \ubaa8\ub4dc\ub85c Size\ub97c \ub298\ub9b4 \ub54c\ub3c4 CPU\ub97c \uc0ac\uc6a9\ud558\ubbc0\ub85c \uacbd\ud569\uc774 \ubc1c\uc0dd\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub807\uae30 \ub54c\ubb38\uc5d0 \uadf8\uc804\uc5d0 \ubbf8\ub9ac \uc99d\uac00\ud560 \uac83\uc744 \uad8c\uace0\ud574\uc57c \ud569\ub2c8\ub2e4.
                                                                                                        \n<\/span><\/p>\n

                                                                                                        \uc790\ub3d9 \uc99d\uac00 \ubaa8\ub4dc\ub294 db_block_size\uac00 \uae30\ubcf8\uac12\uc778 8k\uba74 \ucd5c\ub300 30 GB\uae4c\uc9c0 \ub298\uc5b4\ub098\uace0 16k\ub77c\uba74 60 GB\uae4c\uc9c0 \ub298\uc5b4 \ub0a0 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                                                                        \n<\/span><\/p>\n

                                                                                                         <\/p>\n

                                                                                                          \n
                                                                                                        1. \n
                                                                                                          Table Space Fragmentation
                                                                                                          \n<\/strong><\/span><\/div>\n
                                                                                                            \n
                                                                                                          1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                            \n<\/span><\/p>\n


                                                                                                            \n<\/span><\/p>\n

                                                                                                            \n

                                                                                                            \n

                                                                                                              \n
                                                                                                            1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                              18\ubc88 \ud56d\ubaa9\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ub2e8\ud3b8\ud654\uac00 \uc77c\uc5b4\ub09c \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \ubaa9\ub85d\ub4e4\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                              \n\uc774 \ud56d\ubaa9\uc744 \ud1b5\ud558\uc5ec \ud604\uc7ac \uac00\uc7a5 \ub9ce\uc774 \uc4f0\uace0 \uc788\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uace0 reorg & rebuild \ud588\uc744 \uc2dc Free space \ud655\ubcf4\uac00 \uac00\uc7a5 \ub192\uc740 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                                                                              \n\ub9c8\uc774\uadf8\ub808\uc774\uc158 \uc791\uc5c5\uc744 \ud560 \uacbd\uc6b0 undo \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4size\ub97c \ud655\uc778\ud558\uc5ec Size\ub97c \ub298\ub824 \uc8fc\uac70\ub098 Guarantee Mode\ub97c \ubcc0\uacbd\ud558\uc5ec undo \uacf5\uac04\uc774 \ubd80\uc871\ud558\uc5ec \uc2e4\ud328\ud558\ub294 \uc0c1\ud669\uc744 \ubc29\uc9c0 \ud574\uc57c \ud569\ub2c8\ub2e4.
                                                                                                              \nTEMP \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uacbd\uc6b0\ub294 Sort\uc2dc \uc774\uc6a9\uc744 \ud558\uac8c \ub418\ub294\ub370 PGA \uc601\uc5ed\uc744 \uba3c\uc800 \uc0ac\uc6a9\ud558\uace0 \ubd80\uc871\ud560 \uacbd\uc6b0 TEMP \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 \uacf5\uac04\uc744 \uc0ac\uc6a9\ud558\uac8c \ub429\ub2c8\ub2e4.
                                                                                                              \nTEMP \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4 size\ub294 DB\uc5d0\uc11c \uac00\uc7a5 \ud070 \ud14c\uc774\ube14\uc758 \uc0ac\uc774\uc988\ubcf4\ub2e4\ub294 \ucee4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                              \n<\/span><\/p>\n

                                                                                                               <\/p>\n

                                                                                                               <\/p>\n

                                                                                                                \n
                                                                                                              1. \n
                                                                                                                Auto Extend Feature is Set Data file Information
                                                                                                                \n<\/strong><\/span><\/div>\n
                                                                                                                  \n
                                                                                                                1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                  \n<\/span><\/p>\n

                                                                                                                  \n

                                                                                                                  \n

                                                                                                                    \n
                                                                                                                  1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                    19\ubc88 \ud56d\ubaa9\uc740 1. \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc758 \uc790\ub3d9\uc99d\uac00\ubaa8\ub4dc \uc0ac\uc6a9\uc5ec\ubd80 2. \ub354 \uc774\uc0c1 \ub298\uc5b4\ub098\uc9c0 \uc54a\ub294 Data file \ud655\uc778 3. File\ubcc4 \ud604\uc7ac \uc0ac\uc6a9\ub7c9 4. Data file\uc758 \uacbd\ub85c
                                                                                                                    \n5. Data file\uc758 \uc0dd\uc131 \uc21c\uc11c ( FILE_ID \ucc38\uace0 ) \ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                    \n<\/span><\/p>\n

                                                                                                                     <\/p>\n

                                                                                                                     <\/p>\n

                                                                                                                      \n
                                                                                                                    1. \n
                                                                                                                      Parallel Degree 2 or more, set the Table \/ Index list (Top 10)
                                                                                                                      \n<\/strong><\/span><\/div>\n
                                                                                                                        \n
                                                                                                                      1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                        \n<\/span><\/p>\n

                                                                                                                        \n

                                                                                                                          \n
                                                                                                                        1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                          20\ubc88 \ud56d\ubaa9\uc740 Degree\uac00 2\uc774\uc0c1 \uc124\uc815\ud55c Table \/ Index \uc815\ubcf4\ub97c \ucd9c\ub825\ud558\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                          \n\ub9ce\uc740 Index\uc5d0 Degree\uac00 \uc124\uc815\ub418\uc5b4 \uc788\uc73c\uba74 SGA\ub97c \uc0ac\uc6a9\ud558\uc9c0 \uc54a\uace0 PGA\ub97c \uc0ac\uc6a9\ud558\uac8c \ub418\uc5b4 \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9\uc774 \uc99d\uac00 \ud558\uac8c \ub429\ub2c8\ub2e4. \uba54\ubaa8\ub9ac \uc0ac\uc6a9\ub7c9\uc774 \uacc4\uc18d \uc99d\uac00\ud558\uac8c \ub418\uba74 \uc11c\ubc84\uc5d0 \ubd80\ub2f4\uc774 \ub418\ubbc0\ub85c 2\uc774\uc0c1 \uc124\uc815\ud55c Table \/ Index\ub4e4\uc740 \uad8c\uace0\ub97c \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                          \n<\/span><\/p>\n

                                                                                                                           <\/p>\n

                                                                                                                            \n
                                                                                                                          1. \n
                                                                                                                            One Tablespace Has mixed Table + Index list
                                                                                                                            \n<\/strong><\/span><\/div>\n
                                                                                                                              \n
                                                                                                                            1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                              \n<\/span><\/p>\n

                                                                                                                              \n

                                                                                                                                \n
                                                                                                                              1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                21\ubc88 \ud56d\ubaa9\uc740 \ud558\ub098\uc758 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\uc5d0 Table\uacfc Index\uac00 \ud63c\ud569 \ub418\uc5b4 \uc788\ub294 \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. \uc7a5\uc560 \ubc1c\uc0dd\uc2dc Table\uacfc Index\uac00 \ub2e4\uac19\uc774 \uc0ac\ub77c\uc9c8 \uc218 \uc788\uae30 \ub54c\ubb38\uc5d0 \ubd84\ub9ac \ud574\uc904 \uac83\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.<\/span>
                                                                                                                                \n<\/strong><\/span><\/p>\n

                                                                                                                                 <\/p>\n

                                                                                                                                 <\/p>\n

                                                                                                                                  \n
                                                                                                                                1. \n
                                                                                                                                  Sequence List (Used >= 95%)
                                                                                                                                  \n<\/strong><\/span><\/div>\n
                                                                                                                                    \n
                                                                                                                                  1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                    \n

                                                                                                                                      \n
                                                                                                                                    1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                      22\ubc88 \ud56d\ubaa9\uc740 Sequence\uac12\uc774 95%\uc774\uc0c1\uc778 \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                      RAC\uc758 \uacbd\uc6b0 Sequence\uc758 Cache\uac12\uc774 \ub0ae\uc73c\uba74 \uacbd\ud569\uc774 \ubc1c\uc0dd \ud558\ubbc0\ub85c 1000\uc774\ub098 10000\uae4c\uc9c0 \uc62c\ub824 \uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                       <\/p>\n

                                                                                                                                       <\/p>\n

                                                                                                                                        \n
                                                                                                                                      1. \n
                                                                                                                                        Database Link List
                                                                                                                                        \n<\/strong><\/span><\/div>\n
                                                                                                                                          \n
                                                                                                                                        1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                          \n

                                                                                                                                            \n
                                                                                                                                          1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                            23\ubc88 \ud56d\ubaa9\uc740 Database Link \ub9ac\uc2a4\ud2b8\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                            IP\uac00 \ub178\ucd9c\ub418\uba74 \ubcf4\uc548\uc5d0 \ucde8\uc57d\ud574 \uc9c0\uba70 Public\uc73c\ub85c \uc0dd\uc131\ub41c Database Link\ub294 \ubcf4\uc548\uc5d0 \uc8fc\uc758 \ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4. Database Link\uc5d0 IP\ub97c \ub123\ub294 \uacbd\uc6b0\ub3c4 \uc788\uae30 \ub54c\ubb38\uc5d0 \uccb4\ud06c\ud558\uc5ec \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                             <\/p>\n

                                                                                                                                             <\/p>\n

                                                                                                                                              \n
                                                                                                                                            1. \n
                                                                                                                                              Collect Statistical Information into the Database (Analyze)
                                                                                                                                              \n<\/strong><\/span><\/div>\n
                                                                                                                                                \n
                                                                                                                                              1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                \n

                                                                                                                                                  \n
                                                                                                                                                1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                  24\ubc88 \ud56d\ubaa9\uc740 \ud1b5\uacc4 \uc815\ubcf4\uc758 \uc218\uc9d1 \ub0b4\uc5ed\uc744 \ucd9c\ub825\ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                  \ud1b5\uacc4 \uc815\ubcf4\ub780 Optimizer\uac00 \uc2e4\ud589\uacc4\ud68d\uc744 \uc218\ub9bd\ud560 \ub54c \ucc38\uc870\ud558\ub294 \uc815\ubcf4\uc774\uae30 \ub54c\ubb38\uc5d0 \uc911\uc694\ud55c \uc815\ubcf4\uac00 \ub418\ubbc0\ub85c 6\uac1c\uc6d4 \uc774\uc0c1 \ud1b5\uacc4 \uc815\ubcf4\uc758 \uc218\uc9d1\uc774 \uc5c6\ub294 \uacbd\uc6b0 \uc218\uc9d1\ud560 \uac83\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                   <\/p>\n

                                                                                                                                                   <\/p>\n

                                                                                                                                                    \n
                                                                                                                                                  1. \n
                                                                                                                                                    Constraint segment exists, but the list is used in the Disable state
                                                                                                                                                    \n<\/strong><\/span><\/div>\n
                                                                                                                                                      \n
                                                                                                                                                    1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                      \n

                                                                                                                                                        \n
                                                                                                                                                      1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                        25\ubc88 \ud56d\ubaa9\uc740 \uc81c\uc57d\uc870\uac74\uc774 \uc788\uc73c\ub098 Disable \ub418\uc5b4\uc788\ub294 \ubaa9\ub85d\ub4e4\uc744 \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                        Migration \uc791\uc5c5, Column\uc758 \ubcc0\uacbd, \ub4f1 \ubcf5\ud569\uc801\uc778 \uc0c1\ud669\uc5d0 \uc758\ud574\uc11c Disable\ub41c \uc81c\uc57d\uc870\uac74\uc774 \uc0dd\uae38 \uc218 \uc788\uc73c\ubbc0\ub85c \uccb4\ud06c\ud558\uc5ec \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                         <\/p>\n

                                                                                                                                                         <\/p>\n

                                                                                                                                                          \n
                                                                                                                                                        1. \n
                                                                                                                                                          Index not Foreign Key Constraint
                                                                                                                                                          \n<\/strong><\/span><\/div>\n
                                                                                                                                                            \n
                                                                                                                                                          1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                            \n

                                                                                                                                                              \n
                                                                                                                                                            1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                              26\ubc88 \ud56d\ubaa9\uc740 Index\uac00 \uc5c6\ub294 \uc81c\uc57d\uc870\uac74 \ubaa9\ub85d\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                              \uc5f0\uacb0\ub418\uc5b4 \uc788\ub294 \ud14c\uc774\ube14 \uc911\uc5d0 \uc790\uc2dd Table\uc758 Key Column\uc774 \ubc14\ub00c\uba74 \ubd80\ubaa8 Table\uc758 Key Column\ub3c4 \ubc14\ub00c\uc5b4\uc57c \ud558\uc9c0\ub9cc Index\uac00 \uc5c6\ub2e4\uba74 Table Full Scan\uc744 \ubc1c\uc0dd \uc2dc\ud0a4\uac8c \ub429\ub2c8\ub2e4.
                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                               <\/p>\n

                                                                                                                                                               <\/p>\n

                                                                                                                                                                \n
                                                                                                                                                              1. \n
                                                                                                                                                                Index, 10GB or larger without gateun Table List
                                                                                                                                                                \n<\/strong><\/span><\/div>\n
                                                                                                                                                                  \n
                                                                                                                                                                1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                  \n

                                                                                                                                                                    \n
                                                                                                                                                                  1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                    27\ubc88 \ud56d\ubaa9\uc740 Index\uac00 \uc5c6\ub294 10GB\uc774\uc0c1 Table \ubaa9\ub85d\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                    Size\uac00 \ud070 Table\uc758 \uacbd\uc6b0\uc5d0 Table Full Scan\uc744 \ubc1c\uc0dd \uc2dc\ud0a4\uba74 \uc131\ub2a5\uc774 \ub290\ub824\uc9c8 \uc218 \uc788\uc73c\ubbc0\ub85c Index \uc0dd\uc131\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                    Table\uc774 \ud070 \uacbd\uc6b0 Wait Event\uc911 DB file\uc758 Table\uc5d0 \uc788\ub294 \ub370\uc774\ud130\uac00 \ubaa8\ub450 PGA\ub85c \uc62c\ub77c\uac00\uac8c \ub429\ub2c8\ub2e4.
                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                     <\/p>\n

                                                                                                                                                                     <\/p>\n

                                                                                                                                                                      \n
                                                                                                                                                                    1. \n
                                                                                                                                                                      Index numbers are excessive Table Information
                                                                                                                                                                      \n<\/strong><\/span><\/div>\n
                                                                                                                                                                        \n
                                                                                                                                                                      1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                        \n

                                                                                                                                                                          \n
                                                                                                                                                                        1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                          28\ubc88 \ud56d\ubaa9\uc740 Index\uac00 5\uac1c \uc774\uc0c1 \uc788\ub294 Table\uc758 \ubaa9\ub85d\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                          Index\uac00 \ub9ce\uc73c\uba74 DML\uc791\uc5c5\uc2dc \ubd80\ud558\uac00 \ub9ce\uc774 \uac78\ub9ac\ubbc0\ub85c \uacb0\ud569\uc744 \uc2dc\ud0a4\uac70\ub098 \uc0ad\uc81c\ub97c \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                           <\/p>\n

                                                                                                                                                                           <\/p>\n

                                                                                                                                                                            \n
                                                                                                                                                                          1. \n
                                                                                                                                                                            Execessive Split Index List (block > 1000)
                                                                                                                                                                            \n<\/strong><\/span><\/div>\n
                                                                                                                                                                              \n
                                                                                                                                                                            1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                                              \n

                                                                                                                                                                                \n
                                                                                                                                                                              1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                29\ubc88 \ud56d\ubaa9\uc740 \ube48\ubc88\ud558\uac8c Update\uc640 Delete \uc791\uc5c5\uc774 \uc77c\uc5b4\ub098\uc11c Rebuild\uac00 \ud544\uc694\ud55c Index\ubaa9\ub85d\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                Density = \ubc00\ub3c4\ub85c\uc368 1\uc5d0 \uac00\uae4c\uc6b8\uc218\ub85d \uc88b\uc740 \ubc00\ub3c4 \uc774\uace0 \ub0ae\uc73c\uba74 \ub0ae\uc744\uc218\ub85d Rebuild \ub300\uc0c1\uc774 \ub429\ub2c8\ub2e4. Full Table Scan\uc2dc Extra.Block\uc744 \uc870\ud569\ud574\uc11c \uac00\uc838 \uc624\uae30 \ub54c\ubb38\uc5d0 Block\uc218\uac00 \ub9ce\uc73c\uba74 \ub9ce\uc744\uc218\ub85d \uc88b\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.
                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                 <\/p>\n

                                                                                                                                                                                 <\/p>\n

                                                                                                                                                                                  \n
                                                                                                                                                                                1. \n
                                                                                                                                                                                  LOB Detail Information
                                                                                                                                                                                  \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                    \n
                                                                                                                                                                                  1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                                    \n

                                                                                                                                                                                      \n
                                                                                                                                                                                    1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                      30\ubc88 \ud56d\ubaa9\uc740 No Cache\ub85c \uc0ac\uc6a9\uc911\uc778 LOB\uc758 \ubaa9\ub85d\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                      LOB\ub294 No Cache\ub85c \uc0ac\uc6a9\uc2dc Direct Path Read\/Write\ub97c \uc218\ud589\ud558\uac8c \ub418\uae30 \ub54c\ubb38\uc5d0 \ud06c\uae30\uac00 \uc791\uace0 \uc790\uc8fc \uc0ac\uc6a9\ub418\ub294 LOB\uc758 \uacbd\uc6b0 Caching\ud558\uc5ec \uc131\ub2a5\uac1c\uc120\ud6a8\uacfc\ub97c \uc5bb\uc744 \uac83\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                        \n
                                                                                                                                                                                      1. \n
                                                                                                                                                                                        All parameters set status Check
                                                                                                                                                                                        \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                          \n
                                                                                                                                                                                        1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                          \u2026
                                                                                                                                                                                          \n<\/span><\/p>\n


                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                          \n

                                                                                                                                                                                            \n
                                                                                                                                                                                          1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                            31\ubc88 \ud56d\ubaa9\uc740 \uac01\uc885 Parameter\ub4e4\uc758 \uc0c1\ud0dc\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                            \uc774 \ud56d\ubaa9\uc5d0\uc11c \ud544\uc694\ud55c Parameter\ub97c \ucc3e\uc544\uc11c \uc0c1\ud0dc\ub97c \uccb4\ud06c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                             <\/p>\n

                                                                                                                                                                                              \n
                                                                                                                                                                                            1. \n
                                                                                                                                                                                              Archive Log Information
                                                                                                                                                                                              \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                \n
                                                                                                                                                                                              1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                                \n

                                                                                                                                                                                                  \n
                                                                                                                                                                                                1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                  32\ubc88 \ud56d\ubaa9\uc740 log_archive_format \uc124\uc815 \uac12\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  Archive File\uc774 Archive \uc601\uc5ed\uc5d0 \ub9de\uac8c \ub5a8\uc5b4\uc9c0\uace0 \uc788\ub294\uc9c0 \ud655\uc778 \ud558\uc5ec\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  log_archive_format\uc758 \uc124\uc815 \uac12\uc740
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  \u00a0%s : Log sequence<\/span>\ubc88\ud638
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  \u00a0%S : Log sequence<\/span>\ubc88\ud638\uc774\uba70 \uc55e\ubd80\ubd84\uc744 0\uc73c\ub85c \ucc44\uc6cc \ub3d9\uc77c\ud55c \uae38\uc774\ub85c \ud45c\ud604
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  \u00a0%t : Thread<\/span> \ubc88\ud638
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  \u00a0%T : Thread<\/span> \ubc88\ud638\uc774\uba70 \uc55e\ubd80\ubd84\uc744 0\uc73c\ub85c \ucc44\uc6cc \ub3d9\uc77c\ud55c \uae38\uc774\ub85c \ud45c\ud604
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  \u00a0%a : \ud65c\ub3d9 \uc544\uc774\ub514
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  %d : Database \uc544\uc774\ub514
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  %r : Reset Log \uc544\uc774\ub514
                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                  \n

                                                                                                                                                                                                  \n

                                                                                                                                                                                                    \n
                                                                                                                                                                                                  1. \n
                                                                                                                                                                                                    Recovery Area
                                                                                                                                                                                                    \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                      \n
                                                                                                                                                                                                    1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                        \n
                                                                                                                                                                                                      1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                        33\ubc88 \ud56d\ubaa9\uc740 Recovery Area\uc758 \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                                                        db_recovery_file\uc758 \uacbd\ub85c\uc640 \uacf5\uac04\uc758 \ud06c\uae30\ub97c \uc54c \uc218 \uc788\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                                                         <\/p>\n

                                                                                                                                                                                                          \n
                                                                                                                                                                                                        1. \n
                                                                                                                                                                                                          Fast Recovery Area Information
                                                                                                                                                                                                          \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                            \n
                                                                                                                                                                                                          1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                                            \n

                                                                                                                                                                                                              \n
                                                                                                                                                                                                            1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                              34\ubc88 \ud56d\ubaa9\uc740 FRA\ub85c \uc9c0\uc815\ud588\ub358 \ud30c\uc77c\uc758 Name\uacfc Size\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                                                                               <\/p>\n

                                                                                                                                                                                                               <\/p>\n

                                                                                                                                                                                                                \n
                                                                                                                                                                                                              1. \n
                                                                                                                                                                                                                Rman Backup Information
                                                                                                                                                                                                                \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                                  \n

                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                  1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                    35\ubc88 \ud56d\ubaa9\uc740 Rman\uc758 Backup \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                    \nNo Catalog DB\ub85c \uc6b4\uc601\ud560 \uacbd\uc6b0 Rman\uc758 Backup \uc815\ubcf4\ub294 Control File\uc5d0 \uc788\uae30 \ub54c\ubb38\uc5d0 Control File \uc720\uc2e4 \uc2dc Rman Backup\ubcf8\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubcf5\uad6c \ud560 \uc218 \uc5c6\uace0 Catalog DB\ub85c \uc6b4\uc601\ud560 \uacbd\uc6b0\ub294 Control File\uc774 \uc544\ub2cc Catalog DB\uc5d0 \uc800\uc7a5\uc774 \ub418\uae30 \ub54c\ubb38\uc5d0 Control File Auto backup\uc744 On \uc2dc\ud0ac \uac83\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.
                                                                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                                                                     <\/p>\n

                                                                                                                                                                                                                     <\/p>\n

                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                    1. \n
                                                                                                                                                                                                                      Backup Information (30 Days)
                                                                                                                                                                                                                      \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                      1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                                                                        \n

                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                        1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                          36\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80\uc744 \uc9c4\ud589\ud558\uae30 \uc804\uae4c\uc9c0 Backup \ubc1b\uc740 \ubaa9\ub85d\ub4e4\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                                                          \uc774 \ud56d\ubaa9\uc744 \ud1b5\ud574\uc11c Backup\uc744 \ubc1b\uc740 \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \uc54c \uc218 \uc788\uace0 Backup \ubc1b\uc740 \uc2dc\uac04\uacfc \uc18d\ub3c4\ub97c \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. Backup \uc2e4\ud328 \uc2dc Status\uc5d0 Fail\ub85c \ub098\uc624\uae30 \ub54c\ubb38\uc5d0 \uc2e4\ud328\ud55c Backup\uc5d0 \ub300\ud574\uc11c\ub294 \ud655\uc778\ud558\uc5ec \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                                                           <\/p>\n

                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                          1. \n
                                                                                                                                                                                                                            ASM Information
                                                                                                                                                                                                                            \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                            1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                                                                                              \n

                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                              1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                37\ubc88 \ud56d\ubaa9\uc740 ASM\uc73c\ub85c \uad6c\uc131\ud55c Disk\ub4e4\uc758 \uc774\ub984\uacfc Size \ub4f1\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4\/
                                                                                                                                                                                                                                \nDisk Group\uc774 \ubd80\uc871\ud55c \uacbd\uc6b0 \uc0ac\uc804\uc5d0 Disk Group\uc744 \ub298\ub824 \uc8fc\uae30\ub97c \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                                                                 <\/p>\n

                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                1. \n
                                                                                                                                                                                                                                  ASM Partnering Disk
                                                                                                                                                                                                                                  \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                  1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                    1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                      38\ubc88 \ud56d\ubaa9\uc740 ASM Partnering Disk \ubaa9\ub85d\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                      1. \n
                                                                                                                                                                                                                                        Alert Log Online Backup Message detail (5 Day)
                                                                                                                                                                                                                                        \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                        1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                                                                          \n

                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                          1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                            39\ubc88 \ud56d\ubaa9\uc740 Alert Log\uc5d0 \uae30\ub85d\ub41c Online Backup \uba54\uc2dc\uc9c0\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                                                                             <\/p>\n

                                                                                                                                                                                                                                             <\/p>\n

                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                            1. \n
                                                                                                                                                                                                                                              Alert Log Error Message Total summary (30 Days)
                                                                                                                                                                                                                                              \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                              1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                                                                                \n

                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                  40\ubc88 \ud56d\ubaa9\uc740 30\uc77c\uac04 Alert Log Error \uba54\uc2dc\uc9c0\ub97c \uc804\uccb4 \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                  \n\uc5b8\uc81c \uac00\uc7a5 \ub9ce\uc740 Error\uac00 \ubc1c\uc0dd \ud588\ub294\uc9c0 \ub0a0\uc9dc \ubcc4 \uc2dc\uac04 \ubcc4\ub85c \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. ORA-01555 \uac19\uc740 \uacbd\uc6b0\ub294 \ud2b9\uc815 \ubc30\uce58\uc5d0\uc11c \ub098\uc62c \uc218 \uc788\ub294\ub370 \uc774\ub54c Undo \ud14c\uc774\ube14\uc2a4\ud398\uc774\uc2a4\ub97c \uac1c\ub7f0\ud2f0 \ubaa8\ub4dc\ub85c \ubc14\uafb8\uace0 \uc790\ub3d9 \uc99d\uac00 \ubaa8\ub4dc\ub97c On\uc73c\ub85c \ubc14\uafd4\uc90d\ub2c8\ub2e4.
                                                                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                                                                   <\/p>\n

                                                                                                                                                                                                                                                   <\/p>\n

                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                  1. \n
                                                                                                                                                                                                                                                    Alert Log Error Message Day Summary (30 Days)
                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                                    1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                                      1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                        41\ubc88 \ud56d\ubaa9\uc740 30\uc77c\uac04 Alert Log Error \uba54\uc2dc\uc9c0\ub97c \ub0a0\uc9dc \ubcc4 \uc2dc\uac04 \ubcc4\ub85c \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                                                                                                         <\/p>\n

                                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                                        1. \n
                                                                                                                                                                                                                                                          Alert Log Online Backup Message Day Summary (30 Days)
                                                                                                                                                                                                                                                          \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                                          1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                                                                                             <\/p>\n

                                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                                            1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                              42\ubc88 \ud56d\ubaa9\uc740 30\uc77c\uac04 Alert Log\uc5d0 \uae30\ub85d\ub41c \ubc31\uc5c5 \uba54\uc2dc\uc9c0\ub97c \ub0a0\uc9dc \ubcc4 \uc2dc\uac04 \ubcc4\ub85c \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                                                                                                                              \n

                                                                                                                                                                                                                                                              \n

                                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                                              1. \n
                                                                                                                                                                                                                                                                Oracle Database Option Usage
                                                                                                                                                                                                                                                                \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                                1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                  \n

                                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                                  1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                    \n

                                                                                                                                                                                                                                                                    43\ubc88 \ud56d\ubaa9\uc740 \ud604\uc7ac Database\uc758 \uc801\uc6a9\ub41c \uc635\uc158\uc744 \ud655\uc778 \ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                    \n\uc810\uac80 \ub300\uc0c1 Database\uac00 \uc5b4\ub5a4 \uc635\uc158\uc744 \uc4f0\uace0 \uc788\ub294\uc9c0 \uc54c \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                    \n

                                                                                                                                                                                                                                                                     <\/p>\n

                                                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                                                    1. \n
                                                                                                                                                                                                                                                                      Oracle Database Usage Options Details
                                                                                                                                                                                                                                                                      \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                                                      1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                        \n

                                                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                                                        1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                          44\ubc88 \ud56d\ubaa9\uc740 43\ubc88 \ud56d\ubaa9\uc5d0\uc11c \ubcf8 \uc635\uc158 \uc911\uc5d0\uc11c Yes\ub85c \uc124\uc815\ub41c \ud56d\ubaa9\ub4e4\uc744 \uc790\uc138\ud788 \ubcf4\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                          \n\ud604\uc7ac \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \uc635\uc158\uc758 \ub9c8\uc9c0\ub9c9 \uc0ac\uc6a9\uc2dc\uac04 \ub4f1\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                           <\/p>\n

                                                                                                                                                                                                                                                                           <\/p>\n

                                                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                                                          1. \n
                                                                                                                                                                                                                                                                            Literal SQL Check
                                                                                                                                                                                                                                                                            \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                                                            1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                              \n

                                                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                                                              1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                45\ubc88 \ud56d\ubaa9\uc740 Literal SQL\uc744 \ucd9c\ub825 \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                \nLiteral SQL\uc774\ub780 SQL\ubb38\uc7a5 \uc791\uc131\uc2dc SQL\ubb38\uc758 \uc0c1\uc218 \uac12\uc744 Hard Coding<\/span>\ud574\uc11c \uc791\uc131\ud55c \uac83\uc744 \ub9d0\ud558\uba70 Literal SQL\ubb38\uc744 \ub9ce\uc774 \uc0ac\uc6a9\ud558\uba74 Hard Parsing<\/span><\/span>\uc758 \ube48\ub3c4\ub97c \ub192\uc774\uac8c \ub418\uc5b4 \uc131\ub2a5\uc774 \uc800\ud558 \ub420 \uc218 \uc788\uc73c\ubbc0\ub85c \ub9ce\uc774 \uc0ac\uc6a9\ud558\ub294 SQL\ubb38\uc740 Bind Variable\ub97c \uc774\uc6a9\ud55c \ubc29\ubc95\uc73c\ub85c \ubcc0\uacbd\ud560 \uac83\uc744 \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                \n

                                                                                                                                                                                                                                                                                 <\/p>\n

                                                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                                                1. \n
                                                                                                                                                                                                                                                                                  H\/W Plat formation
                                                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                                                  1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                    \n

                                                                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                                                                    1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                      46\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80 \ub300\uc0c1 \uc11c\ubc84\uc758 H\/W \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                                                                      1. \n
                                                                                                                                                                                                                                                                                        H\/W CPU Information
                                                                                                                                                                                                                                                                                        \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                                                                        1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                          \n

                                                                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                                                                          1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                            47\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80 \ub300\uc0c1 \uc11c\ubc84\uc758 CPU \uc22b\uc790\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                             <\/p>\n

                                                                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                                                                            1. \n
                                                                                                                                                                                                                                                                                              H\/W MEMORY Information
                                                                                                                                                                                                                                                                                              \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                                                                              1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                \n

                                                                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                                                                1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                  48\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80 \ub300\uc0c1 \uc11c\ubc84\uc758 Memory\uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                   <\/p>\n

                                                                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                                                                  1. \n
                                                                                                                                                                                                                                                                                                    OS Version Check
                                                                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                                                                                    1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                      \n

                                                                                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                                                                                      1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                        49\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80 \ub300\uc0c1 \uc11c\ubc84\uac00 \uc5b4\ub5a4 OS\ub97c \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uc9c0 \uc5b4\ub5a4 Version\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\uc9c0 \uc54c \uc218 \uc788\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                         <\/p>\n

                                                                                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                                                                                        1. OS Disk \/ Storage Information
                                                                                                                                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                           <\/p>\n

                                                                                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                                                                                          1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                                                                                            1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                              50\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80 \ub300\uc0c1 \uc11c\ubc84\uc758 Disk \/ Storage \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.<\/span>
                                                                                                                                                                                                                                                                                                              \n<\/span>\uc774 \ud56d\ubaa9 \uc5d0\uc11c\ub294 \uac01\uac01\uc758 Disk \uc0ac\uc6a9\ub7c9\uc744 \uc54c \uc218 \uc788\uace0 90%\uc774\uc0c1 \ucc28\uc788\ub294 Disk\ub4e4\uc744 \uccb4\ud06c\ud574\uc11c Disk\uacf5\uac04\uc774 \ubd80\uc871\ud558\uc9c0 \uc54a\ub3c4\ub85d \ubbf8\ub9ac \uad8c\uace0 \ud574\uc8fc\uc5b4\uc57c \ud569\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                              \n<\/span><\/span><\/p>\n

                                                                                                                                                                                                                                                                                                              \n

                                                                                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                                                                                              1. O\/S Packages Information
                                                                                                                                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                 <\/p>\n

                                                                                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                                                                                1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                  \n

                                                                                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                                                                                  1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                    51\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80 \ub300\uc0c1 \uc11c\ubc84\uc758 Packages \uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. \ud604\uc7ac OS\uac00 \uc5b4\ub5a4 Package\ub97c \uc124\uce58 \ud588\ub294\uc9c0\ub97c \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                     <\/p>\n

                                                                                                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                                                                                                    1. O\/S Patch Information (Solaris 10 Only)
                                                                                                                                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                                                                                                      1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                        \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                        \n

                                                                                                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                                                                                                        1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                          52\ubc88 \ud56d\ubaa9\uc740 Solaris 10\uc5d0\uc11c \ud655\uc778\ud558\ub294 \ud56d\ubaa9\uc73c\ub85c \ub300\uc0c1 \uc11c\ubc84\ub294 Solaris 11 \uc774\uae30 \ub54c\ubb38\uc5d0 \uc544\ubb34\ub7f0 \ub0b4\uc6a9\uc774 \ub098\uc624\uc9c0 \uc54a\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                           <\/p>\n

                                                                                                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                                                                                                          1. Kernel Parameter Recommendations
                                                                                                                                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                             <\/p>\n

                                                                                                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                                                                                                            1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                              \n<\/span><\/p>\n


                                                                                                                                                                                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                              \n

                                                                                                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                                                                                                              1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                                53\ubc88 \ud56d\ubaa9\uc740 OS Kernel Parameter\uac12\uc744 \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4. \uc810\uac80 \ub300\uc0c1 \uc11c\ubc84\uc758 OS Kernel Parameter\ub4e4\uc774 \uc5b4\ub5a4 \uac12\uc73c\ub85c \uc124\uc815\uc774 \ub418\uc5b4 \uc788\ub294\uc9c0 \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                 <\/p>\n

                                                                                                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                                                                                                1. \n
                                                                                                                                                                                                                                                                                                                                  Ulimit
                                                                                                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                                                                                                  1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                                    \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                                                                                                                    1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                                      54\ubc88 \ud56d\ubaa9\uc740 OS Ulimit\uac12\uc744 \ud655\uc778\ud560 \uc218 \uc788\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4. Ulimit\uc774\ub780 \ud558\ub098\uc758 \uc720\uc800 ( shell, process )\uc5d0 \ub300\ud574\uc11c \ud560\ub2f9\ud560 \uc790\uc6d0 \ub7c9\uc758 \ud55c\uacc4\ub97c \uc815\ud558\ub294 \uac83\uc774\uace0
                                                                                                                                                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                      \uc774 \ud56d\ubaa9\uc744 \ud1b5\ud574\uc11c \uc124\uc815\ud55c Ulimit\uac12\uc744 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                                                                                                                                                                       <\/p>\n

                                                                                                                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                                                                                                                      1. \n
                                                                                                                                                                                                                                                                                                                                        Database Patch Information
                                                                                                                                                                                                                                                                                                                                        \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                                                                                                                        1. \uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                                          \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n


                                                                                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n


                                                                                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n


                                                                                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n


                                                                                                                                                                                                                                                                                                                                          \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                          \n

                                                                                                                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                                                                                                                          1. \uc810\uac80 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                                            55\ubc88 \ud56d\ubaa9\uc740 \uc810\uac80 \ub300\uc0c1 Database\uc758 Patch\uc815\ubcf4\ub97c \ubcf4\uc5ec\uc8fc\ub294 \ud56d\ubaa9\uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                            \nDatabase\uc758 Version\ubfd0\ub9cc \uc544\ub2c8\ub77c Oracle EM Version\uc774\ub098 \uac01\uc885 Tool\ub4e4\uc758 \uc815\ubcf4\uae4c\uc9c0 \ubcf4\uc5ec\uc8fc\uace0 PSU \ud328\uce58\uac00 \uc5b4\ub514\uae4c\uc9c0 \ub418\uc5b4\uc788\ub294\uc9c0\ub3c4 \ud655\uc778\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                                                                                                                            1. \n
                                                                                                                                                                                                                                                                                                                                              \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95#1
                                                                                                                                                                                                                                                                                                                                              \n<\/strong><\/span><\/div>\n

                                                                                                                                                                                                                                                                                                                                               <\/p>\n

                                                                                                                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                                                                                                                              1. \uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                                                \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                                                \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                                \n

                                                                                                                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                                                                                                                1. \uc791\uc131 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                                                  56\ubc88 \ud56d\ubaa9\uc740 \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c Issue\uc2dc\ud2b8 \uc791\uc131 \ubc29\ubc95 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                  \nIssue \uc2dc\ud2b8\uc5d0\ub294 \uc810\uac80\ud588\ub358 \ubaa8\ub4e0 \ub0b4\uc6a9\ub4e4\uc758 \uc694\uc57d\uc774 \ub4e4\uc5b4\uac00\ub294 \ubd80\ubd84\uc73c\ub85c critical \/ warning \/ information\uc73c\ub85c \uad6c\ubd84\ud574\uc11c \uc694\uc57d \ub0b4\uc6a9\uc744 \uc785\ub825\ud574 \uc8fc\ub294 \uc2dc\ud2b8 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                  \n<\/span><\/span><\/span><\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                                  \n

                                                                                                                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                                                                                                                  1. \n
                                                                                                                                                                                                                                                                                                                                                    \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95 #2
                                                                                                                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                                                                                      \n
                                                                                                                                                                                                                                                                                                                                                    1. \uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                                                      \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                                                      \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                                      \n

                                                                                                                                                                                                                                                                                                                                                        \n
                                                                                                                                                                                                                                                                                                                                                      1. \uc791\uc131 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                                                        \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                                                        57\ubc88 \ud56d\ubaa9\uc740 \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c Guide\uc2dc\ud2b8 \uc791\uc131 \ubc29\ubc95 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                        \nGuide\uc2dc\ud2b8\uc5d0\ub294 17\ubc88 \ud56d\ubaa9\uc5d0\ub3c4 \uc788\ub294 \ub0b4\uc6a9 \uc774\uc9c0\ub9cc 90%\uc774\uc0c1 \uc0ac\uc6a9\uc911\uc778 Tablespace\ub294 \uc911\uc694\ud55c \uc815\ubcf4\uc774\uae30 \ub54c\ubb38\uc5d0 \ud55c\ubc88 \ub354 \ub530\ub85c \uc785\ub825\ud574\uc8fc\uc5b4 Guide \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                        \n<\/span><\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                                        \n

                                                                                                                                                                                                                                                                                                                                                          \n
                                                                                                                                                                                                                                                                                                                                                        1. \n
                                                                                                                                                                                                                                                                                                                                                          \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95 #3
                                                                                                                                                                                                                                                                                                                                                          \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                                                                                            \n
                                                                                                                                                                                                                                                                                                                                                          1. \uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                                                            \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                                                            \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                                            \n

                                                                                                                                                                                                                                                                                                                                                              \n
                                                                                                                                                                                                                                                                                                                                                            1. \uc791\uc131 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                                                              \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                                                              58\ubc88 \ud56d\ubaa9\uc740 \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c Literal SQL\uc2dc\ud2b8 \uc791\uc131 \ubc29\ubc95 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                              \nLiteral SQL\uc2dc\ud2b8\uc5d0\ub294 45\ubc88 \ud56d\ubaa9\uc5d0\ub3c4 \uc788\ub294 \ub0b4\uc6a9 \uc774\uc9c0\ub9cc Version Count\uac00 1000\uc774\uc0c1\uc778 \ud56d\ubaa9\ub4e4\ub9cc \uc694\uc57d\ud558\uc5ec Guide \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                              \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                                              \n

                                                                                                                                                                                                                                                                                                                                                                \n
                                                                                                                                                                                                                                                                                                                                                              1. \n
                                                                                                                                                                                                                                                                                                                                                                \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \uc791\uc131\ubc29\ubc95 #4
                                                                                                                                                                                                                                                                                                                                                                \n<\/strong><\/span><\/div>\n
                                                                                                                                                                                                                                                                                                                                                                  \n
                                                                                                                                                                                                                                                                                                                                                                1. \uc694\uc57d \ubb38\uc11c \uc791\uc131 \uacb0\uacfc
                                                                                                                                                                                                                                                                                                                                                                  \n<\/strong><\/span><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n


                                                                                                                                                                                                                                                                                                                                                                  \n<\/span><\/p>\n

                                                                                                                                                                                                                                                                                                                                                                  \n

                                                                                                                                                                                                                                                                                                                                                                    \n
                                                                                                                                                                                                                                                                                                                                                                  1. \uc791\uc131 \ub0b4\uc6a9
                                                                                                                                                                                                                                                                                                                                                                    \n<\/strong><\/span><\/li>\n<\/ol>\n

                                                                                                                                                                                                                                                                                                                                                                    59\ubc88 \ud56d\ubaa9\uc740 \uc815\uae30\uc810\uac80 \uc694\uc57d \ubb38\uc11c \ub514\uc2a4\ud06c\ucd94\uc774\uc2dc\ud2b8 \uc791\uc131 \ubc29\ubc95 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                                    \n\ub514\uc2a4\ud06c\ucd94\uc774\uc2dc\ud2b8\uc5d0\ub294 \uc6d4\ubcc4\ub85c ASM\uacfc DB SIZE\uc758 \uc0ac\uc6a9\ub7c9\uc744 \uae30\ub85d\ud574\uc11c \uc0ac\uc6a9\ub7c9\uc744 Guide \ud574\uc8fc\ub294 \ud56d\ubaa9 \uc785\ub2c8\ub2e4.
                                                                                                                                                                                                                                                                                                                                                                    \n<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

                                                                                                                                                                                                                                                                                                                                                                      \uc624\ub77c\ud074 DBMS \uc0c1\uc138 \uc810\uac80 \ubc29\ubc95 \ubaa9 \ucc28 1. Target Database Basic Information\u00a0\u00a0\u00a0\u00a09 A.\u00a0\u00a0\u00a0\u00a0\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a010 B.\u00a0\u00a0\u00a0\u00a0\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a010 2. Target Database Version Information\u00a0\u00a0\u00a0\u00a011 A.\u00a0\u00a0\u00a0\u00a0\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a011 B.\u00a0\u00a0\u00a0\u00a0\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a011 3. Target Database Session Information\u00a0\u00a0\u00a0\u00a012 A.\u00a0\u00a0\u00a0\u00a0\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a012 B.\u00a0\u00a0\u00a0\u00a0\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a012 4. Target Database use for system resources Information\u00a0\u00a0\u00a0\u00a012 A.\u00a0\u00a0\u00a0\u00a0\uc2a4\ud06c\ub9bd\ud2b8 \uc218\ud589 \uacb0\uacfc\u00a0\u00a0\u00a0\u00a012 B.\u00a0\u00a0\u00a0\u00a0\uc810\uac80 \ub0b4\uc6a9\u00a0\u00a0\u00a0\u00a013 5. SGA Set Status\u00a0\u00a0\u00a0\u00a013 […]<\/p>\n","protected":false},"author":1,"featured_media":2875,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[9],"tags":[774,775,776,777,778,779],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/02\/1-know-how.jpg?fit=937%2C450","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1496"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1496"}],"version-history":[{"count":3,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1496\/revisions"}],"predecessor-version":[{"id":4826,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1496\/revisions\/4826"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2875"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1496"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}