Database Administrator

Oracle user status query Oracle user status query # Switch to an Oracle user Su-oracle # Log on to sqlplus Sqlplus/as sysdba # Set the display format Set pagesize 300; Set linesize 300; # Querying the user list and user status Select

Typical paging code in Oracle Since there is no top keyword in Oracle, the paging code in SQL Server does not apply to Oracle. How can paging be implemented in Oracle? -- Query all data STUNO STUNAME STUAGE STUID STUSEAAT-----------------------------

Oracle-ASM installation tutorial The steps for installing the ASM database are a lot different from those for installing RAC. Therefore, we have successfully installed the database based on the ASM management by modifying the installation document

MySQL 5.6.26 restores data through frm & ibd Create A database bkjia on serverRoot (yoon)> show create table bkjia \ G* *************************** 1. row ***************************Table: bkjiaCreate Table: create table 'bkjia '('Id' int (11)

Redis non-Relational Database Service (Nosql) Introduction: Redis is an open-source, high-performance key-value system that can be used to cache or store data.Redis data can be persistent and supports multiple data types: string, list, hash, set,

Oracle RAC system memory cannot be released Solution The environment is a real-time production database host on the current network. Hp-ux 11.31 + Oracle 10.2.0.4.0 RAC cluster.Two machines: RAC and essdb3 and essdb4.Physical memory 128 GB, SGA 64

Are Fields in MongoDB documents sorted in order? In this article, we will briefly discuss the sequence of fields in Mongodb. The document in Mongodb is a Json string consisting of Key: Value pairs. It is reasonable to say that the order of fields

Compile and install the PostgreSQL 6.5 database on CentOS 9.3 PrefacePostgreSQL is a free object-relational database server (Database Management System), which is issued under a flexible BSD-style license. It provides an alternative to other

Yii2-Redis using note-Cache I learned about Redis a few days ago, and now I am going to use it on the project. We are currently using the Yii2 framework, in the official website to search for Redis, we found the yii2-redis this extension. After

Use of MySQL Log and mysqlbinlog Tool View log-related global variables:Mysql> show global variables like '% log %' Modify related variables:1. For a function, use set global xxx = xxx.2. For file operations, you can only modify the configuration

Oracle Partition Table online redefinition field not null Oracle uses DBMS_REDEFINITION to redefine a table online. It synchronizes data to an intermediate table in the new structure based on the materialized view, and then implements it by renaming

Oracle Database object_view A view is a very important database object. It is similar to a common table. We can query data from a view. In fact, it is a virtual table built on a table. It does not store real data in the view, but only saves a SELECT

Master-slave Redis configuration in Linux 1. Download redis-2.8.24.tar.gz at http://redis.io/download. 2.decompress redis-2.8.24.tar.gz and install Tar xvf redis-2.8.24.tar.gzMv redis-2.8.24/usr/local/cd/usr/local/redis-2.8.24makeMake install #

MariaDB DML statements and user authorization DML (Data Manipulation Language): INSERT, DELETE, UPDATE, SELECT INSERT [INTO] tbl_name [(col1,...)] {VALUES | VALUE} (val1 ,...),(...),... Suppose there is a table above Insert a row of data: insert

Oracle _ transaction control statement A transaction is a logical unit for database operations. A transaction can contain one or more DML (data manipulation language), DDL (Data Definition Language), and DCL (Data Control Language) statement, which

Oracle Database object_synonym A synonym is a database object. It is an alias defined for a database object. The main purpose of synonyms is to simplify the writing of SQL statements. Concepts and types of synonyms Synonyms can be used to define an

Import Oracle Data Using Solr5.3.0 1. Modify solr-data-config. Xml file with the following content: (PS: This article creates an index based on the siteinfo table of the yqfx database in the Oracle database. The site table contains three fields: id,

How to remotely back up MySQL binlog Previously, binlogs were backed up and compressed locally, and then sent to a remote server. However, there are still some risks, because log backup is cyclical. If the server goes down and the hard disk is

MySQL Optimization-enable MySQL slow query log and analysis tool mysqldumpslow 1. It is very easy to enable MySQL slow query logs. You only need to add the following in the MySQL configuration file my. cnf:[Mysqld]Slow_query_log = 1-enable slow

Hadoop 2.x detailed steps for building a pseudo-distributed environment, hadoop2.x This article describes in detail the entire process of Hadoop 2.x pseudo-distributed environment construction by combining text and text for your reference. The