Database Administrator

PL/SQL enhancements in Oracle 12c Oracle 12c enhances a series of methods for defining and executing PL/SQL program units. This article covers several new features of Oracle 12c: 1. optimized the caller permission function for the result cache

Use LVM to back up and restore the MariaDB Database Comparison with mysqldump to introduce LVM snapshot volumesMysqldump: Hot Backup cannot be performed, and the backup time is long when the database is large. The advantage is that the Backup

Oracle 11g Database shutdown causes the crsd process of 10g Database to restart The customer has an Oracle 10 Gb RAC environment. Due to an occasional demand, a database of 11 GB needs to be temporarily started. When we mount the software and

Oracle 18C database creation prompt ORA-12754 error Solution In order to experience Oracle 18C, early in the morning on the https://edelivery.oracle.com/osdc/faces/SoftwareDelivery to install the media down. First test the database software

Oracle logic import error: the error message "cannot create logs" is displayed. The error message "oracle logic import" is displayed. **************************************** ********************************

In order to learn the SQL statements of the database, after a long wait and learning, I finally learned how to use Oracle 10 Gb to learn the SQL statements of the database over the past few days. Required Software: Oracle 10g, TOAD for Oracle The

SQL Server data migration to PostgreSQL error explanation and solution, serverpostgresql Problem reproduction: 1. PG client: postgres=# create table text_test (id int,info text);CREATE TABLEpostgres=# insert into text_test values (1,E'\0x00');ERROR:

Oracle backup tools, file naming formats, rman operations, and mongolerman I. Common tools: Recovery Manager: rman can only perform Hot Standby (mount or open state)Oracle Secure BackupUser-managed backup: cp/dd [if =/of =/blocksize =]   Ii. rman

Some basic knowledge about databases (1) ------ database engine, ------ Database Engine MySQL database provides 13 different storage engines to handle different data processing. Most people who have used MySQL should know the two storage engines

[Redis 1] Redis database learning and practices-installation and deployment, redis learning and practicesRedis database learning and practice-installation and deployment 1: Redis database introduction: Redis-Remote DictionaryServer can be directly

Cost Calculation Method in execution plan, execution plan cost Concept: Blevel: Binary Height = index height-1 Clustering_factor: Cluster factor, number of blocks in the table to be scanned after index scan, clustering_factor Index scan calculation

MyBatis framework Learning (III)-Mapper proxy development, mybatis-mapperIn the previous section, we learned the simple implementation of CRUD in MyBatis. In this process, we used the original Dao method for development. In this process, we found

Oracle client + PLSQL Developer remote login to Oracle database, oracle client plsql Oracle databases have powerful functions and excellent performance. These advantages also result in a large amount of memory occupied by Oracle. To address this

The TNS-01201: Listener cannot find executable... error message was recently received when the Listener was started. This error has never been encountered. I really don't know what it is. The following is a detailed description of the error and the

Run the DBCA command on a set of DB servers and report the following error: [Oracle @ game_db ~] $ Dbca Exception in thread "main" [Oracle @ game_db ~] $ [Oracle @ game_db ~] $ ExportDISPLAY = 1921.68.3.189: 0.0 [Oracle @ game_db ~] $ Dbca Exception

To be continued ...... To be continued ...... To be continued ...... To be continued ...... Col tablespace_name for a15Col segment_name for a15Col segment_type for a15 Select segment_name, segment_type, tablespace_name, extents, bytes/1024 KB from

Platform: RHEL4.8, Oracle10.2.0.1Plan: db_name = dndn, db_unique_name/ORACLE_SID = dndnThe above two parameters can also be set to different. $ Export ORACLE_HOME = $ ORACLE_BASE/product/10.2.0/db_1 $ Export ORACLE_SID = dndn 2. Create an

DB2 joint database is a special form of distributed database management. In the federated database system, you can use an SQL command to send command requests to multiple data sources. Before remote replication between DB2 and non-DB2 databases,

Configure MongoDB configuration items in the configuration file and back up and restore the database, mongodb backup and recoveryI. mongoDB command line startup option Configuration When mongodb is started using the command line, we can select some

Oracle 11g RMAN: Interpretation of the command for creating dg in Active Database Duplication for standby database, rmanduplicationIf the production-based duplicate replication is not manually configured with pfile (set memory, process, dg-related