Simple ORACLE operations and precautions

I often read some articles to solve many of my own problems, but I am always embarrassed to read the articles that others read. After all, I learned others' experience and improved myself, but I didn't share it with others. I also want to write some of my own experiences. Let's start with oracle.
For developers, you only need to follow the steps to install oracle, and then install the Data Connection Tool (Popular pl/SQL) for development and use.
Oracle contains user content. After the installation is complete, we can create our own users. To facilitate management, we can also create our own tablespace and temporary tablespace.
For the use of oracle stored procedures, we can put them in packages, which puts all stored procedure functions and defined variables into one for use, using Stored Procedures can reduce the number of times we access the database and improve program performance. However, this also has some disadvantages, resulting in a high coupling of some of the packages, which affects the maintenance efficiency, if the program is separated, it will lead to program confusion, and it is difficult to find the content to be written to or debugged. We recommend that you use the Stored Procedure properly.
Oracle's backup module is divided into cold backup, hot backup, and logical backup. Logical backup is the exp and imp we use. rman is commonly used for hot backup, then, you can set a backup policy to allow full backup of the database or perform Incremental backup. Before hot backup at www.2cto.com, you need to set oracle to the archive mode. Note that many problems may occur here, frequent operations will generate a large number of logs, causing database downtime. If archiving logs are enabled, You need to regularly clear the archived logs, when performing a large volume of operations, you need to monitor archived logs from time to time. If it is too large, you need to clear some logs. Oracle also needs to pay attention to the number of connections, which is 150 by default. This can be adjusted to a larger value. Generally,-is no problem, 3. The four G memory is sufficient, which is also prone to problems. Compared with oracle, mysql is much simpler in terms of operation. If mysql enables logs, it can be retrieved if it deletes the database and does not have a backup, but oracle won't, in general, oracle is excellent in all aspects. The username and password must be entered to delete the database at oracle11g. I have been developing for more than a year, but I am not a professional dba. I have little knowledge about this and I am writing blogs for the first time. I can only write at this level, I hope you can correct them more. This is just some experience, so there is no specific operation procedure. Author: sieniu porridge