在這裡編輯新頁面「首頁/PlanningTheDatabase」
As a DBA, you must plan:
The logical storage structure of the database and its physical implementation:
- How many disk drives do you have? What type of storage is being used?
- How many data files will you need? (Plan for growth.)
- How many tablespaces will you use?
- What types of information will be stored?
- Are there any special storage requirements due to type or size?
Overall database design
Database backup strategy
Dynamicc Performance Views: Usage Examples A frequent user of these views is Enterprise Manager, but users can also query these views as needed. The three examples shown in the slide answer the following questions:
1. For which SQL statements (and their associated numbers of executions) is the CPU time consumed greater than 200,000 microseconds?
SQL> SELECT sql_text,executions FROM v$sql WHERE cpu_time > 2000000;
2. Which current sessions are logged in from the EDRSR9P1 computer on the last day?
SQL> SELECT * FROM v$session WHERE machine = 'CLIENTHOSTNAME' and login_time > SYSDATE -1;
3. What are the session IDs of those sessions that are currently holding a lock that is blocking another user, and how long have those locks been held?
SQL> SELECT sid, ctime FROM v$lock WHERE block > 0;
SQL> SELECT inst_id,current_scn FROM GV$DATABASE;
INST_ID CURRENT_SCN
---------- -----------
1 1142923
2 1142923