Database Administrator

An error occurred while using create pfile form spfile In the RAC environment. I. Problem Solving 1. Check the parameter records in the normal RAC. Node spfile location SQL> show parameter pfile NAME TYPE VALUE ---------------------------------------

Common Oracle commands in Linux Common Oracle commands in Linux 1. Start the oracle database: // Switch to an Oracle user: [Root @ server36 ~] # Su-oracle // Enter the sqlplus environment. The nolog parameter indicates no Logon: [Oracle @ server36 ~]

Oracle filling tables with random data A script from AskTom can also fill in random data for a table. Create or replaceProcedure gen_data (p_tname in varchar2, p_records in number)-- This routine is designed to be installed ONCE pre database, hence--

The corresponding index cannot be deleted when the primary key is deleted. drop constraint -- The index is not deleted when a table primary key is deleted. If the primary key index is created with the primary key constraint,The index is

Oracle Outline usage I. Overview Oracle Outline, also known as the storage Outline in Chinese, is the earliest mechanism to control SQL Execution plans based on prompts. It is also the only tool in 9i and earlier versions that can be used to

Specific SQL processing procedures in Oracle Shows the general phases of SQL processing in Oracle: parsing, optimization, generation of row sources and execution. The database may ignore some steps, depending on the specific statements. 1. SQL

MySQL modifies the copied user and password In the production environment, you sometimes need to modify the password for copying a MySQL user account, for example, if the password is lost, or because multiple different copy users want to be a single

MySQL Study Notes _ 5_ SQL language design and writing (on), study notes _ 5_ SQL SQL language design and writing (I) I. SQL statement Classification Data Definition Language (DDL ): Defines and manages data objects, including databases, data

MySQL learning notes _ 6_ SQL language design and writing (below), learning notes _ 6_ SQL SQL language design and writing (II) -- SELECT query Summary: SELECT [ALL | DISTINCT] # distinct is DISTINCT, clear, and different. {* | Table. * | [table.]

Mysql partition, mysql table Partition I. Functions of mysql partitions Ii. Mysql partitioning Methods Iii. Mysql partition implementation Master-slave Problems1. Database Backup (Master/Slave database) 2. database load balancing

SQL Server column-to-row refer, sqlbench Today, we are doing a data presentation. We use column-to-row conversion. There are multiple methods for column-to-row conversion. The feature is one of them, and Povit is a function that is available only

Error code: 1054 Unknown column 'Course' in 'field list', 1054 column 1. Error description 1 queries executed, 0 success, 1 errors, 0 warnings query: SELECT stu_name, course, score FROM t_student_info s LIMIT 0, 1000 error code: 1054 Unknown

Database and database LearningDomain integrity restrictions SQL supports the concept of DOMAIN, and can use the CREATE DOMAIN statement to CREATE a DOMAIN and the integrity constraints that the DOMAIN should meet. [Example 14] CREATE a Gender DOMAIN

Consistency Test and open consistency test in the open stageIn the open stage, oracle requires consistency check before it can open the database. What tests have been done?Check whether the Checkpoint CNT in the data file header is consistent with

Database and database LearningDatabase integrity Data correctness and compatibility Data integrity and security are two different conceptsData IntegrityPrevent the database from having non-semantic data, that is, prevent the database from having

Database and database LearningComputer System Security Various Security Measures Established and taken for computer systems to protect hardware, software, and data in computer systems and prevent accidental or malicious damage to the system, data

MySQL SQL optimization and mysqlsql OptimizationPreface Some people have reported that the previous articles are too theoretical and lack practical operation details. This article is more practical. Note: This article is based on MySQL. A lot of

Aerospike-Architecture Distributed, aerospikeDistribution) The Aerospike database is a component provided for 24/7 running applications that can reliably process big data. When developing an application, you don't have to worry about where the

Customized tablespace retention policies and customized retention policies In large databases, the recycle bin is large, and there is a lot of garbage. It is very slow to query tablespaces. To prevent accidental operations, it is impossible to add

PostgreSQL tutorial (12): Role and permission management, postgresql permission management PostgreSQL manages database access permissions through roles. we can regard a role as a database user or a group of database users. Roles can have database