Oracle queries the corresponding SQLID according to the system resource consumption of the process

Description: ps aux 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

TTS of oracle database data migration

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

Installing oracle 11.2.0.4 under Docker

Note: https://github.com/sunrainwater/oracle-11g.git There is a complete installation code on Clone git code and generate image Direct execution: 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

Oracle scheduled task case

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. programme Write a stored procedure to update fields (change state); Write a job to execute the stored procedure regularly; Scheme logic stored p ...

Posted on Wed, 01 Apr 2020 04:38:31 -0400 by Chris12345

oracle Expdp and Impdp import and export database

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

Use sql to merge records with time period fields (start time, end time)

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 --Question ...

Posted on Sun, 29 Mar 2020 10:15:54 -0400 by le007

Oracle remote access configuration

Server configuration 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

Extend group by statement

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

Unable to run Eclipse; JVM terminated. Exit code = 13

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 -startup plugins/org.eclipse.equinox.launcher_1.1.0.v20100507.jar --launcher.library plugins/org.eclipse ...

Posted on Fri, 13 Mar 2020 09:04:55 -0400 by Mohit_Prog

Oracle single instance migration to Oracle single instance

Catalog 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