The third column of the command result is the CPU utilization of the process
The fourth column of the command result is the memory usage of the process
These two columns can be used as the basis for high system resource consumption of processes
The spid of Oracle dynamic performance view v$proce ...
Posted on Thu, 02 Apr 2020 21:13:42 -0400 by versatilewt
Data migration is one of the daily work of DBA, and the experimental details of the following articles are complete. Please leave a message if the original author feels that his rights and interests are violated.
The essence of transferring tablespace is to extract tablespace metadata transfer + data file transfer under ...
Posted on Thu, 02 Apr 2020 13:54:44 -0400 by CAM
Note: https://github.com/sunrainwater/oracle-11g.git There is a complete installation code on
Clone git code and generate image
docker run -it –privileged –name oracle11g -p 1521:1521 -v /data:/install oracle-11g-scripts
(no bash will be added to the last side, otherwise it will not be executed au ...
Posted on Wed, 01 Apr 2020 10:00:31 -0400 by ramonekalsaw
Brief description of needs
A data table contains the entry time of the data. The initial status of the data is valid. After five days, the system automatically sets the status of the data as invalid.
Write a stored procedure to update fields (change state);
Write a job to execute the stored procedure regularly;
stored p ...
Posted on Wed, 01 Apr 2020 04:38:31 -0400 by Chris12345
The basic import and export statements are
//Import / export database under specified user and instance orcl
impdp/expdp user/pwd@orcl directory=DATA_PUMP_DIR
Data ﹣ pump ﹣ dir is the default export path of oracle database files. It is generally the / admin / orcl (instance name) / dpdump directory under the orac ...
Posted on Tue, 31 Mar 2020 19:00:36 -0400 by vince251
A question from a basic friend:
His blog is linked to sql time period merging and merging https://blog.csdn.net/Seandba/article/details/105152412
Problem: the total open time of the computing channel is as long as any terminal is open. The difficulty lies in the overlapping of the open time of various terminals
Problem test data
Posted on Sun, 29 Mar 2020 10:15:54 -0400 by le007
If you don't want to write by yourself, you can configure it through Net Manager
The localhost in the following configuration file is changed to ip address, otherwise, it cannot be accessed remotely
1. Network monitoring configuration
# listener.ora Network Configuration File: C:\app\Administrator\product\11.2.0\dbhome_1\ne ...
Posted on Thu, 26 Mar 2020 12:03:38 -0400 by Tory
Learn from Chapter 5 of Oracle development art of breaking through the iceberg GROUP BY
For simple group by statements, it is difficult to analyze the complex dimensions, and it is difficult to meet the requirements of the actual production of complex reports. The extension feature of group by is needed. The union statement can also meet the r ...
Posted on Mon, 23 Mar 2020 05:00:57 -0400 by shrimp
I just append - vm C: \ \ Program Files \ Java \ jre6 \ bin \ javaw.exe
In eclipse.ini, then I try to start eclipse again and receive this error. Give me how to solve or link to the actual solution to it.
This is my eclipse.ini
Posted on Fri, 13 Mar 2020 09:04:55 -0400 by Mohit_Prog
1. Environment deployment 2
1. 1. Modify the database to archive mode. 2
1. 2 create test table 2
2. Backup preparation 2
2. 1 full database backup 2
2. 2 copy parameter file 2
2. 2. 1 view parameter file path 2
2. 2.2 copy parameter file 3
2. 2.4 creating dynamic files 3
2. 5 copying archives 3 ...
Posted on Fri, 13 Mar 2020 05:50:20 -0400 by lin