Oracle has many pitfalls.
Oracle has many pitfalls
Existing pitfalls include:
1. Cold backup. The steps from Win32 to Win64 are required.
2. Open the database gradually.
Open: startup nomount alter database mount; alter database open;
The Oracle startup speed also accounts for memory usage, so you can close the database at ordinary times and enable it when necessary. A simple method is to disable the Oracle service and enable it when necessary.
The advantage of gradually opening is that Oracle is prone to problems.
3. You can use V $ SQLAREA to view the SQL statement, resulting in low execution efficiency. This "pitfall" is a good pitfall.