Programmer Group

grails has been upgraded to version 3.0.9 due to work needs, and needs to configure multiple data sources. grails 2.1's multi-source configuration is relatively simple, but more than 3.0 version of the database configuration changes to application.yml for configuration, how to configure multi-source, Baidu and bing search no answer (forgive me ...

Understanding Oracle's execution plan is the first step in optimizing, so let's start with the example below. Additional information below 1. Create test tables [sql] view plaincopy   SQL> create table t as select 1 id,object_name from dba_objects;           Table created           SQL> update t set id=99 where rownum=1;           1 ...

Tool preparation ​JDK Since it is a Java protocol, JDK is essential, but the largest version of JDK supported by lr11 is only jdk1.6, and it must be 32 bits. ​ jdbc connects jar packages To connect to oracle database, you need to prepare the database-driven jar package and select the corresponding version of the jar package acc ...

function Grammar for Defining Functions Practice calculating the sum of two numbers Adding Data to Exercise Functions Call function of exercise function view Characteristics of Views Adding and deleting views Add view Delete view Synonym SYNONYM grammar Practice synonyms cursor Classification of cursors Cursor syntax Pr ...

Optir_mode parameter _optimizer_mode is an optimizer parameter of oracle 11g. It can affect the behavior of the optimizer in some cases, and it is a detail parameter that can not be ignored. SQL> show parameter optimizer; optimizer_capture_sql_plan_baselines boolean FALSE optimizer_dynamic_sampling integer 2optimizer_features_enable string ...

1. Download server and workbench 2. Install server 2018-04-22T09:29:10.385999Z 1 [Note] A temporary password is generated for root@localhost: 8Jj)>opkXLuN If you lose this password, please consult the section How to Reset the Root Password in the MySQL reference manual. The prompted root password must be noted ...

This paper contains the following two knowledge points. The environmental information is shown in the following figure: Deploy Data Guard service; Configuration and use of Data Guard Broker.I. Deployment of Physical Standby 1.1 Main Library Preparations 1.1.1 Enable force logging SQL> ALTER DATABASE FORCE LOGGING; 1.1.2 Create standby data ...

The Path class is one of the new features added to jdk7 to replace the java.io.File class.  The reason for adding this class is that the java.io.File class has many shortcomings:1. Many methods in the java.io.File class fail without exception handling or throwing an exception.The java.io.File.delete() method returns a Boolean value indicat ...

There are three processes to start oracle, nomount, mount, open I. nomount stage During the nomount phase, you can see that the instance has started.The oracle process creates a shared memory pool based on the parameter file. SQL> startup nomount; ORACLE instance started. Total System Global Area 1653518336 bytes Fixed Size 22138 ...

Installation of non-graphical interface and database migration for Linux system Database Installation Installation of dependency packages yum install binutils compat-libstdc++-33 elfutils elfutils-libelf-devel gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers libaio libaio-devel libgcc libstdc++ libstdc++-devel make sys ...