Database Administrator

PL/SQL smart call stack Analysis PL/SQL smart call stack Analysis The three DBMS_UTILITY functions(DBMS_UTILITY.FORMAT_CALL_STACK, DBMS_UTILITY.FORMAT_ERROR_STACK, and DBMS_UTILITY.FORMAT_ERROR _ BACKTRACE) have been crucial aids in diagnosing and

Python in Ubuntu accesses the Oracle database through the SQLAlchemy Library SQLAlchemy is not a database driver. The Python driver for accessing Oracle data is cx_Oracle, but this driver depends on Oracle instant client. Therefore, if you want to

Installing Oracle 11g R2 silently in CentOS I,Http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.htmlOracle 11g online documentation:Http://www.oracle.com/pls/db112/homepage Ii. System RequirementsMemory: 1 GB (minimum

Run Oracle with Docker on Mac 1. You must use Boot2Docker to run Docker and install Boot2Docker on Mac. 1. Download the pkg installer https://github.com/boot2docker/osx-installer/releases/latest, and install it in double-click mode;2. initialize and

Oracle SQL Tuning Health-Check (SQLHC) The performance of an SQL statement mainly depends on good physical structure, accurate system statistics, accurate object statistics, reasonable query optimizer parameters, and reasonable system parameters.

How to use scripts to quickly deploy MySQL and deploy one machine and multiple instances MySQL has three versions: binary, source code package, and RPM. The following describes how to install a binary package. : Http://dev.mysql.com/downloads/mysql/

Manage the logon (start) account and password of the SQL Server service Today, I handled an alwaysOn problem-the secondary copy is always displayed [not synchronized-suspicious] due to insufficient disk space. In the log, we can see that the

Oracle sets a scheduled task JOB to schedule and execute stored procedures or PL/SQL code blocks Currently, there are two methods for configuring scheduled job Scheduling in Oracle Database: dbms_scheduler to create job scheduling and dbms_job to

Oracle RMAN backup-control file backup Go to the RMAN page Rman target/ RMAN> Change the backup mode of control files to automatic backup RMAN> configure controlfile autobackup on; Check whether the backup of the control file is automatic

PostgreSQL log classification and management PostgreSQL has three types of logs: pg_log (database operation log), pg_xlog (WAL log, that is, redo log), and pg_clog (transaction commit log, which records the transaction metadata) Pg_log is disabled

Data Processing-PostgreSQL process Language Learning Some time ago, when the company switched to the new PostgreSQL data mart system, it downloaded the postgresqlAPI PDF file to study the PostgreSQL data mart. I found that using PostgreSQL process

[Speech Recording] RWP team talked about SQL optimization and recorded rwp team SQL Speaking of SQL optimization, what is the first reaction in your mind as a reader? Index? Hint? Partition? Parameter? Execution Plan? Haha, let's talk about it.

SunlightDB 2017 new blockchain database, sunlightdb2017 What is blockchain? Since last year, the concept of blockchain has been gaining popularity, especially in developed countries. Blockchain has also become the name of a revolution, and has

Redis source code analysis (1) -- Redis Data Structure-string SDS, redissds 1. SDS Overview The strings used in Redis are Simple Dynamic strings (SDS. SDS is packaged Based on the C string to make it more suitable for Redis use scenarios. In

Mainstream database of deep learning | MySQL basics, mainstream mysql Beijing | deep learning and AI Training December 23-24 Review deep learning with the classic course > The body contains 4732 words and 21 images. The expected reading time is 12

HBase vs. MongoDB vs. MySQL vs. Oracle vs. Redis, the primary key of the three major open-source NoSQL databases, the two mainstream traditional SQL databases, nosqlredismongodb HBase vs. MongoDB vs. MySQL vs. Oracle vs. Redis, the primary key

Use Amazon Machine Learning and Amazon Redshift to establish a binary classification model, amazonredshift Most of the decisions in daily life are in binary format. Specifically, such questions can be answered by "yes" or "no. There are also many

ORACLE-018: ORACLE tip 001 string processing, oracle-018oracle 1. truncate a string Oracle uses a function substr to intercept a string. The parameter is substr (string, start position, and truncation length ), For example, if the string 123,112

Failed to attach database to server XXX, failed to attach database xxx I recently learned MVC + EF and watched the video for a small demo. EF needs to be connected to the database. The example in the video is quite similar to that in the previous

Modify the table name and field name in an SQL statement.   Today, we have a temporary task to modify the database table name and field name in the production environment. In the past, the field names of the table names to be modified were all in