Database Administrator

When installing 64-bit Oracle 10 Gb in Oracle Linux, The ins_ctx.mk problem occurs. When 64-bit Oracle 10g is installed on Oracle Linux Server Release 5.7, the following problems are encountered: Error in invoking target 'install' of makefile'/u01/

MySQL read_log_event (): 'found invalid event in binary Log' MySQL is known for its ease of use. It can install N different versions on the same server to facilitate testing and migration. In addition, mysql is integrated in most Linux systems and

Data Center reconstruction-Database Design-Data Center reconstruction Database I. Draw an ERTU A E-R Diagram, also known as an Entity Relationship divisor, provides a way to represent Entity types, attributes, and associations to describe the

Linux Oracle service starts and stops scripts and starts automatically. After installing Oracle 10g R2 in CentOS 6.3 and restarting it, you will find that Oracle is not started on your own. This is normal because Oracle Installation in Linux does

Database optimization tutorial (I) preface & definition of slow query, and introduction of database optimization tutorial Preface   Recently, I helped the company optimize the database. Based on what I learned, I used the learning knowledge step by

If you do not use the judgment operation to ensure that if any number is greater than 30, it is 30; otherwise, it is the original value (maximum limit on Field Values in SQL sorting), and 30 SQL statements Scenario: in a database, you need to sort a

Create a log file in oracle and an oracle Log File The syntax for creating a log file is as follows: Alter database database_name add logfile [group group_number](File_name [, file_name [,...]) [SIZE number] [reuse]; The syntax is described as

Database B tree B + tree, database B tree In database indexes, B or B + trees are generally used for retrieval and query. The following describes how to query data in two data structures: 1) B tree B treeEach nodeData Object Storage address pointer

Install Oracle12cR1 on Oracle Linux in VirtualBox, oraclevmvirtualbox Summarized today, using simple several words to describe how to install Oracle Database on Oracle Linux as following. *** Login as root user1. Update host name in/etc/hosts 2.

Uninstall MySQL Enterprise Monitor and mysqlenterprise in LinuxMySQL Enterprise Monitor is an Enterprise-level monitoring designed specifically for MySQL databases. It can be well integrated with various MySQL features, including: mySQL's key

RULE-based optimizer (learning notes) and rule learning notesCui Hua's Oracle-based SQL optimization learning notes1.1 RULE-based Optimizer (1) CBO (2) RBO Compared with CBO, RBO has obvious permissions. When RBO is used, once a problem occurs in

Use of dbms_ SQL in oracle, oracledbms_ SQL 1. Run the query using dbms_ SQL Use dbms_ SQL to execute the select statement in the order of open cursor --> parse --> define column --> execute --> fetch rows --> close cursor; 1. Create a team table

PostgreSQL registration Start and Stop unmount batch processing script, postgresql Batch Processing Register to start pg_install.bat: echo offset PGSQL_DIR=%~dp0if not "%PGSQL_HOME%"=="" ( if not "%PGSQL_HOME%"=="%PGSQL_DIR%" ( echo

Oracle Partition Table Technology (Partitioned Tables), partitionedtables Since Oracle 8 (around 1997), the concept of Partition Table & partition index (Partitioned Tables & Indexes) has been introduced to adjust large Tables and large Indexes to

EMCA fails with error "ORA-01017: invalid username/password; logon denied", emcaora-01017 Creation of dbcontrol repository fails when execute  $ Emca-config dbcontrol-repos create With error:Database connection through listener failed. Fix the error

SQL two simple paging query methods, SQL paging Query Method In the past, we may have used the skip and take method of linq for paging queries, but few of them write SQL paging queries by themselves, because most of the time, we are calling others'

[Oracle] oracledba6 SQL Tuning sets, oracledba6tuning You want to use the SQL Tuning Advisor to generate recommendation S for badly written SQL statements in your development environment. W Hich three sources can you select for the advisor to

Controllable cache for improving the performance of computing reports with clear sets, and controllable reports It is an indisputable fact that using cache can improve report performance. Generally, high-end report tools provide the report cache

Common methods for processing cross-row group computing reports and solutions for computing reports and computing reportsReport description The order amount is calculated by month based on the order table and specified year (parameter), and compared

Apache OFbiz member module table structure design, apacheofbiz In addition to the technical framework, the structure design of database tables can be described as another direction worth learning. In this article, we will talk about the design of