REHL8 detailed steps for installing Oracle19C database
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
PostgreSQL DBA most commonly used SQL
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 creation user, specifying default (create) tablespace, user permission assignment (empowerment) script (dba, ETL required)
Oracle database create user, specify default (create) tablespace, and grant permissions (dba, ETL are required)
preface
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