Database Administrator

Summary of the new features of Oracle 12c on business impact (1) 1. invisible fields In Oracle 11g R1, Oracle introduces some good enhancement features in the form of invisible indexes and virtual fields. Inherit and develop the former, and

Oracle Enterprise Manager Cloud Control 12c R4 installation ConfigurationPrepare Software Em12.1.0.4_linux64_V45344-01.zip Em12.1.0.4_linux64_V45345-01.zip Em12.1.0.4_linux64_V45346-01.zip  Install the Operating System (OEL6.5) After loading OS and

Oracle Database permission management and oracle permission managementPermission management: the default three usernames and passwords in oracle 9: sys change_on_install // the Administrator with the highest permissions: system manager // normal

SQL Server database bcp export backup file application, serverbcp/*** Authorization*/EXEC sp_configure 'show advanced options', 1;GoReconfigure;GoExec sp_configure 'xp _ Your shell', 1;GoReconfigure;Go/** Import the text file of the specified table *

Access to Create a Table SQL statement Create Table to set AUTOINCREMENT for Automatically increasing columns, SQL statement createtable Access Table creation SQL statement Create Table setting AUTOINCREMENT for Automatically increasing Columns SQL

1. Create groups and users In linux, open the terminal and log on as the root user. Enter the following command: Groupadd dba // Add the dba group useradd-g dba-m oracle // Add the username as oracle and add the user to the dba group passwd oracle /

Redis document translation _ LRU cache, redis document _ lruUsing Redis as an LRU cache uses Redis as the LRU cacheSource: http://blog.csdn.net/column/details/redisbanli.htmlWhen Redis is used as a cache, sometimes it is handy to let it

TNS-12532: TNS: invalid argument, Oracle error messages too speechlessSymptom:Tnsping error:[Oracle @ unicomGZ01 admin] $.../../bin/tnsping orclTNS Ping Utility for Linux: Version 11.1.0.6.0-Production on 16-MAY-2013 15:27:00Copyright (c) 1997,200 7,

I. Back up the database1. Open SQL Enterprise Manager and click Microsoft SQL Server in the root directory of the console.2. SQL Server group --> double-click to open your Server --> double-click to open the database directory3. Select Your Database

Alibaba Cloud SQL Intelligent Query analyzer, a database query and analysis management tool developed by delphi. To facilitate your work, you can use a database query and analysis management tool developed by delphi to share with you the following

Basic concepts: 1. Multi-dimensional dataset: a multi-dimensional dataset is the main object in Online Analytical Processing (OLAP) and a technology that allows quick access to data in a data warehouse. A multi-dimensional dataset is a collection

What is a MySql database? Generally, a database is a collection of data. Specifically, a database on a computer can be a collection of files in the memory or a collection of memory data. MySql Databases and SQL server databases are actually database

Redis Research (14th)-management tools, redis research toolsTo do well, you must first sharpen your tools. When using Redis, if you can effectively use various Redis management tools, it will greatly facilitate development and management. I.

SQL statement Optimization-query different rows of the two tables NOT IN, NOT EXISTS, Join query Left Join, existsleft In actual development, we often need to compare the differences between two or more tables and compare the data that is the same

MongoDB (2)-learn about the installation configuration and mongodb installation Configuration I introduced the general theoretical knowledge of MongoDB. This article will install and use MongoDB on windows and linux. Of course, we will install

[Soft engineer Video] software, software engineering, and engineering video Software Engineering I am now learning about the soft engineer video and summarize what is the origin of software and software engineering. Seeing this figure, the blur

SQL Server trigger and SQL Server triggerSQL Server triggers A trigger is a special type of stored procedure, which is different from the stored procedure we introduced earlier. A trigger is triggered by an event and automatically called for

Reduce disk I/O IO of distributed Disks Tablespace use local management 1. Distribute files to different devices A.Separate data files from log files B.Reduce disk IO irrelevant to the server C.Evaluate the usage of bare Devices D.Split table data 2.

The simplest and most effective Bufferpool A buffer pool is a storage area in the memory. It is used to temporarily read and modify database pages (including table rows or index items ). The buffer pool is used to improve the performance of the

When the system fails, data logs can be used to restore data to solve database faults. As an SQL Server database administrator, it is important to understand the role of data log files and how to use them to solve common database faults. Since the