Database Administrator

Java detailed process of connecting to the SQLite database using JDBC for various data operations Preface:SQLite is a ACID-compliant relational database management system, which is contained in a relatively small C library. It is a public project

Signalled during ORA-1031 Error message: ORA-1031 signalled during: create tablespace name datafile '+ data' size 10 M autoextend on next 5 M maxsize unlimited... Problem description In the newly deployed Oracle environment, a designer user needs

Invalid and unavailable objects for Oracle Database Reconstruction Invalid and unavailable objects Invalid PL/SQL objects and unavailable indexes may affect performance. Invalid PL/SQL objects must be recompiled before they can be used. This

Overview of Oracle Architecture From the Oracle Server Architecture Overview, I found an introduction to the Oracle architecture, which is used to describe the overall Oracle architecture. Overview of Oracle Server Architecture 1 Oracle databases

Disable and uninstall Oracle AWR features Need to disable AWR? Such a good stuff. By default, AWR is usable and requires a certain amount of sysaux tablespace. However, when debugging packages related to AWR (license is required) access the AWR view

Shell script for synchronous update of Hive dataIntroduction: in the previous article Sqoop1.4.4, import incremental data from Oracle10g to Hive0.13.1 and update the master table in Hive describes the principle of incremental update of Hive tables

Oracle startup error sqlplus/nolog Error [Oracle @ www.bkjia.com bin] $ sqlplus/nolog Sqlplus: error while loading shared libraries:/u01/oracle/lib/libnnz11.so: cannot restore segment prot after reloc: Permission denied An error occurred while

Small oracle-imp import error filesize settings, oracle-impfilesize **************************************** ******************************** *************************************** Original Works are from the blog of "Deep Blue blog". You are

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode, restorearchivelogSymptom: I reported an error ORA-00265 after executing the open archive command SQL> alter database archivelog; alter database archivelog * ERROR at

T-SQL templates defined by common SQL jobs, sqlt-SQL templates -- Define the creation job DECLARE @ jobid uniqueidentifierEXEC msdb. dbo. sp_add_job @ job_name = n' job name', @ job_id = @ jobid OUTPUT -- Define job steps DECLARE @ SQL nvarchar (400)

Left to right: InnoDB or MyISAM, innodbmyisam Welcome to my original Website: http://www.phpthinking.com/archives/456 MyISAM is the default storage engine in MySQL. Generally, not many people care about this. It is a tricky thing to decide what

Common Methods for viewing Oracle execution plans-Series 2: oracle execution plans Continued article: http://blog.csdn.net/bisal/article/details/38919181 3. AUTOTRACE Switch Turn on AUTOTRACE in SQLPLUS to get the SQL Execution Plan. The prompt

Troubleshooting "Global Enqueue Services Deadlock detected" (Doc ID 1443482.1), enqueuedeadlock In this Document   Purpose   Troubleshooting Steps   1. TX deadlock in Exclusive (X) mode  

The use of views in SQL (simple views) is suitable for entry-level SQL views. Creating a view can better call data from one database to another (for example, transferring data from database 209 to database 205) Example: Database 209 has different

Cannot set user id: Resource temporarily unavailable, cannotsetuserid A while ago, Infra reported that the database server could not be connected through putty and SecureCRT. The error message is Resource temporarily unavailable. Since there are

Install mysql5.5.17 source code and mysql5.5.17 source code1. Download the source code packageSOURCE code package is often compressed tar.gz, the name only contains version information, the size is much smaller than the RPM package, Binary Package,

Cainiao database (6)-enabling and disabling Oracle services conveniently and quickly Background: As a programmer, in daily work, our computer often needs to run many programs at the same time, such as Eclipse, browsers, and instant messaging

Some instances understand the mysql database stored procedures and mysql database Stored ProceduresMysql stored procedure: encapsulate SQL: Create procedure p1 () beginselect * from t_news; end $ // simple mysql Stored procedure instanceDisplay

To build a RAC-DG for the customer encountered some problems, set up rac-dgYesterday I went to a customer to build a physical standby database of the RAC-DG, here I will list the general process again, for does not involve leakage of privacy, the

SQL Server in the eyes of programmers-what does non-clustered index bring to us ?,Zookeeper I will not talk about some database concepts, so I can only use some practices to understand the meaning of these concepts. The use cases in the following