Database Administrator

Listparts of Oracle Functions Recently, I found an interesting Oracle function that can splice column values. Next, let's take a look at its specific usage. Usage: The official document explains its role as follows: For a specified

Automatic Discovery and monitoring of apsaradb for Redis Based on Zabbix monitoring System Version: CentOS5.10Python version 2.4.3 1. python supportYum-y install python-simplejson 2. discovery script[Root @ localhost etc] # cat redis_port.py #! /Usr/

AWR export/import/Generate Report The customer's production system is always so important that you will not perform operations on their production machines for a long time. However, analyzing and generating AWR reports is a relatively

Oracle DBCA does not see started instances and Handling Methods I. Problem description: I tested the Oracle database in a unit. I wanted to use DBCA to check the database configuration information. Of course, I am also in a panic. Who would have

Proficient in Hibernate-relationships between domain objects and hibernate In the domain model, there are four relationships between classes.1. Association)Class can have one-to-one, one-to-many, and many-to-many relationships. For example, the

Hibernate establishes one-to-multiple bidirectional associations and hibernate associations The following content is organized from the second edition of Hibernate Note: Since it is a bidirectional Association, "One-to-multiple bidirectional

SQL Injection principles and how to avoid injection and SQL Injection principles SQL Injection: When will SQL be used? The answer is that when accessing the database, that is, SQL injection --> directly threatens the data source. Oh, the database

Mysql forgets the root password (the same as windows in linux), and mysqlroot How to solve the problem when mysql forgets the root password, 1: cd/etc/mysql/(enter the mysql configuration directory) 2: vim my. cnf \ skip-grant-tables (enter the

Common PLSQL subprograms and plsql 01. Clear the recycle binBeginExecute immediate 'purge recyclebin ';End;/02. truncation tableDeclareBeginExecute immediate 'truncate table person_bak2 ';End;/03. Modify the table column to be empty.-- Modification

Python3 connects to the Mairadb database and python3mairadb # This Code demonstrates connecting to the Mairadb database under python3.3.5. import mysql. connectorconfig = {'host': '2017. 168.14.101 ', # default 127.0.0.1 'user': 'person',

Notes are automatically generated when powerdesign exports SQL, and powerdesign exports SQL 1. Script Run Option ExplicitValidationMode = TrueInteractiveMode = im_Batch Dim mdl 'the current model 'Get the current active modelSet mdl =

One-click deployment of MongoDB cluster for Windows, mongodb ClusterBecause there are no virtual machines at home on weekends, you must complete the deployment requirements on a single machine in windows and write a bat running script.1. Create a

Two Methods of writing Quick Sort:Quick Sort Method 1: Appendix: full code implementation # Include # include using namespace std; int OnceSort (int * a, int left, int right) {int I = 0; int middle = right; right-= 1; while (left * (a + middle)

401st questions, 053401 401. Which of the following are correct about block media recovery? (Choose all that apply .)A. Physical and logical block upload uption is recorded automatically in V $ DATABASE_BLOCK _Upload uption.B. Logical uptions are

(Windows Maven project) install and operate Jedis database, mavenjedisRedis is a memory database that caches the data you write into the memory and periodically writes data to the disk, this article describes how to use Maven to compile and run a

Mysql query on the sixth day 1, mysql query on the sixth day The general query process is from the client to the server, and there is a network between them. Parse on the server, generate the execution plan, and execute. And return it to the client.

Create a configuration file for Hibernate and a special DTD symbol in the format of a Java property file. Sample

Queries users who use a tablespace and queries the table space. Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46912403   Yesterday, I gave some suggestions on how to find out which

Structured, semi-structured, and unstructured dataIn practical applications, we will encounter a variety of databases, such as nosql non-relational databases (memcached, redis, mangodb) and RDBMS Relational databases (oracle, mysql, etc ), there are

Was system error logs contain a large number of missing identifiers and was Original works, from "Deep Blue blog" blog, deep blue blog: http://blog.csdn.net/huangyanlong/article/details/46909941   Recently, when I checked was logs for a resident