Introduction to the Author
Author: Lucifer Liu, member of the Chinese DBA Consortium (ACDU).Currently mainly engaged in Oracle DBA work, has been engaged in Oracle database development work, mainly serving the production and manufacturing, Automotive Finance and other industries.Now has Oracle OCP, OceanBase OBCA certification, good at Orac ...
Posted by DGaleDavid on Mon, 17 Jan 2022 21:31:59 +0100
1, What is a Session
Session is an interface (HttpSession).A Session is a Session. It is a technology used to maintain an association between a client and a server.Each client has its own Session.In the Session session, we often use it to save the information after the user logs in.
2, How to create a Session and get (id number, new or not)
Posted by buildakicker on Fri, 14 Jan 2022 21:32:03 +0100
In work, we delete data or database by mistake. Do we have to run away? I don't think so. Programmers must learn to save themselves and retrieve the data unconsciously.
In MySQL database, we know that binlog logs record all our operations on the database, so binlog logs are a sharp tool for us to save ourselves.
Today, taking MySQL databa ...
Posted by tunari on Tue, 11 Jan 2022 03:48:29 +0100
Tip: after the article is written, the directory can be generated automatically. Please refer to the help document on the right for how to generate it
I saw it on the bus in the morning**_ The article on MySQL binlog written by yidianyu * * in Jiangnan is very detailed about the use of binlog to recover the database. I can under ...
Posted by cbolson on Fri, 31 Dec 2021 17:04:25 +0100
Please read carefully and refer to the README document for the latest steps, processes and related requirements for the overall upgrade of Oracle 19c rac cluster from 19.3 opatch to 19.10.
1, View the current database patch version
col ACTION for a8
col status for a15
set line 999
col ACTION_TIME for a30
col DESCRIPTION for a50
SQL> selec ...
Posted by dianaqt on Thu, 30 Dec 2021 18:40:19 +0100
The DBLINK built this time is to access the SQL SERVER database on the Win side of the Damon database on the Linux side. By configuring ODBC to connect to the SQL SERVER database, DM creates an ODBC DBLINK connection to realize the DBLINK between DM and SQL SERVER. The following are the specific operation steps.
DBLINK (Datab ...
Posted by Dustin013 on Thu, 23 Dec 2021 18:52:15 +0100
1, Preparation before installation
1.1 create RAID5 disk array
To view the number of hard disk devices, use the ll / dev/sd * command
[root@TradeProbe ~]# ll /dev/sd*
brw-rw----. 1 root disk 8, 0 8 May 15:36 /dev/sda
brw-rw----. 1 root disk 8, 1 8 May 15:36 /dev/sda1
brw-rw----. 1 root disk 8, 2 8 May 15:36 /dev/sda2
brw-rw----. 1 root di ...
Posted by teo99 on Wed, 22 Dec 2021 18:12:25 +0100
Create relevant views according to the data dictionary to facilitate query
create schema dba;
create view dba.ro_conflicts as select datname,pg_stat_get_db_conflict_all(oid) conflict_all,pg_stat_get_db_conflict_bufferpin(oid) conflict_bufferpin,pg_stat_get_db_conflict_lock(oid) conflict_lock,pg_stat_get_db_conflict_snapshot(oid) conflict_ ...
Posted by phpnoobie on Wed, 15 Dec 2021 17:25:57 +0100
Oracle database create user, specify default (create) tablespace, and grant permissions (dba, ETL are required)
In the actual development process, creating users in the database, specifying tablespaces and assigning permissions to users are the basic operations. The script commands are introduced below.
Tip: the following ...
Posted by zarp on Wed, 15 Dec 2021 16:18:13 +0100