Database Administrator

Reproduce the library cache lock wait event at 11 GB in Oracle From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during business

View All Tables and fields and Table comments. Field comments in Oracle View All Tables and fields and Table comments. Field comments in Oracle Get table: Select table_name from user_tables; // The table owned by the current user Select table_name

Oracle 11g uses DML Error Logging to avoid bulk insert failure Use DML Error Logging to avoid bulk insert failureIf an error occurs when an insert statement with a subquery is used to load data. the system terminates the statement and rolls back the

Take a closer look at other functions of the Oracle nested table and make a simple arrangement. Oracle provides two methods to use nested tables:1. PL/SQL code is used as the extended PL/SQL language. (This section describes the oracle memory table

[MongoDB] Serveral common command of MongoDb, mongodbserveral In the recent days, since the overwork made me exhaused, on arrival to home I will go to bed, which leads to loss of blogs that shoshould have been written in the past days. Now I make a

Thoughts on MongoDB application practices and practicesI recently studied MongoDB and used it to quickly build a flexible no schema storage system. Through demonstration and analysis, this article uses MongoDB to quickly build a storage system with

After MySQL 5.6 is installed on Windows 7, there is no service and it cannot be started. mysql5.6 Due to business needs, today in Mac OS X Windows 7 virtual machine installed the latest MySQL version: mysql-5.6.20-winx64.msi, The results found that

Whether the path change of the bare device in ASM affects the operation of the database. Use asm to store database files. In linux, you can use asmlib to manage Block devices, or use bare devices to create an asm disk. In asmlib mode, changing the

ORA-01552: non-system tablespace 'xxxx 'cannot use system rollback segments, ora-01552xxxx ORA-01552: non-system tablespace 'xxxx 'cannot use system rollback segmentsFault analysis:The UNDO tablespace data file is damaged, causing the update

One-time oracle em configuration experience and oracleem configuration experience Configuring em for oracle10grac was originally a very simple task, but it took a long time to record it and forget it. First, the following error is reported: [oracle@

Hadoop2.X/YARN environment setup-CentOS7.0 system configuration, centos7.0 I. Why should I choose CentOS7.0? The official CentOS 7.0.1406 version was released at 17:39:42 on January 26, July 7. I used many Linux versions. For the environment

Create views and primary foreign keys in SQLserver, and create views in sqlserverI. background I have learned the relevant content of the database, but I have never practiced it in the form of a database. Now, when I am working on a data center, I

Database index PrincipleWhen you encounter a new knowledge, you can learn it through the what-why-how method. Below we will learn the database index through this method.What is database index?Definition 1: an index is a structure used to sort the

Mongodb installation in win7 is absolutely correct. mongodb installation in win7Install MongoDB in Windows 7 1. DownloadAddress: http://www.mongodb.org/downloads (32-bit or 64-bit ).I downloaded: mongodb-win32-x86_64-2.4.5.zip 2. DecompressPut

Object-Oriented Programming (Chapter Summary), object-oriented programming chapter1. Object-oriented has three main features: encapsulation, inheritance, and polymorphism.2. If a class drug settings inherit, you must specify NOTFINAL; otherwise,

V. Index Optimization Design 1. Manage organization Indexes The index can greatly accelerate the database query speed. The index maps the logical value in the table to a safe RowID, so the index can quickly locate the physical address of the data.

Transformers (SqlHelper) and transformers sqlhelper 1. Basic Introduction SqlHelper is a database operation component based on · NET Framework. The component contains the database operation method. SqlHelper is used to simplify the repeated

Part 1 Database SQL language Data manipulation language (DML)   Data Manipulation Language,DMLIncluding insert, delete, and update statements for adding, deleting, and modifying data. The following table tb_employeeinfo is used as an example: Create

This blog is translated from: Http://blog.mongodb.org/post/87200945828/6-rules-of-thumb-for-mongodb-schema-design-part-1? Mkt_tok = 3RkMMJWWfF9wsRonsq7Ldu % 2FhmjTEU5z14uUsUKGxhokz2EFye % 3D % 3D Note: This translation is not strictly translated. It

I wrote a blog about Oracle Database remote connection: Oracle database -- server-side remote connection configuration. In that article, I recommended someone else's blog, which is the topic of this blog. However, I recently used it, so I went