Database Administrator

Currently, an MV in the library is used to calculate the hourly traffic volume. The data is as follows:SQL> select * from mv_time_stat;TIME CNT--------------------0 1871 512 343 194 195 206 507 1078 6829 134210 185411 129212 141613 118014 121715 1573

OriginBecause the customer requested to deploy mssql server 2008 on the application, and we were used to developing server programs in Linux, we had the need to connect mssql server 2008 with python in linux. This demand is very difficult. We have

For beginners, there are always the following questions about the connection between client tools and database servers: Do I have to install the Oracle database on a local machine?If I have installed an Oracle database locally, why is it so stupid

Requirements for Oracle 11.31 database installation on HP-UX IA64 11.2 systems: I. Swap memory requirements Between 4 GB and 8 GB then 2 times RAM.Between 8 GB and 32 Gbit/s then 1.5 times RAM.More than 32 GB then 32 gb ram. Ii. JDK

1. recover database using backup controlfile 2. recover database until cancel 3. recover database using backup controlfile until cancel; 4. recover database until cancel using backup controlfile; Differences: 1. If the current control file is

How to change SYSADMIN Password in Oracle EBS R12 Test environment:SQL> select * from v $ version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.1.0.7.0-64bit

Authorized users can access database objects and their contents. Prompt that after a user has the permission to Process Tables of other users, the user must have public or private synonyms of these tables before he can reference tables of other

The following are the two problems I encountered when working on the system: . SQL server has duplicate rows of data and cannot be updated or deleted. It is usually a table without a primary key. Error: Check whether the table has a primary key.

Configure password-free SSH on the cluster nodeTo configure SSH without a password, you must first generate an RSA or DSA key on each cluster node, and then copy all the keys generated by all cluster node members to the authorization key file, the

Author: Qing Dujun Address: http://blog.csdn.net/qingdujun/article/details/36425825 When SQL Server 2008 + VS2010 uses code written in C # To restore the database, an error occurs: Error message: A transmission error occurs when sending a request

Environment Settings...First, check your physical memory size. We recommend that you increase the memory size by 1 GB.# Grep MemTotal/proc/meminfo Check whether your swap partition size meets the requirements. Generally, it is twice the physical

Stored Procedure Overview The commonly used operating database language SQL statements must be compiled and then executed before execution. The Stored Procedure (Stored Procedure) is a set of SQL statements for specific functions, after compilation,

WebLobic Server is an industry-leading application Server developed by BEA. Is a pure java implementation of SUN J2EE. WebLogic has long been regarded as one of the best J2EE tools on the market. Like a database or email Server, WebLogic Server is

We are all familiar with the recycle bin in windows. After a file is deleted and put into the recycle bin, it can be restored. The Oracle recycle bin works exactly the same, but there are some differences in implementation details.. In addition, the

I. Overview I have written two articles about Oracle Data Pump before: Oracle 10 gData Pump Expdp/Impdp Oracleexpdp/impdp example These two articles describe the use of data pumps. In actual use, we will also encounter a problem where some ORA-xx

GridFS is a distributed file system on MongoDB. It uses the distributed storage mechanism of MongoDB and uses MongoDB to store file data and file metadata. It has the advantages of both a document-based database and a file system. GridFS is the

Bad blocks of Oracle data files can be divided into physical and logical Bad blocks. Physical Bad blocks (or media Bad blocks) mean that the block format itself is bad, and the data in the block has no meaning. The logical bad block refers to the

I always thought that a NULL string is NULL. When I inserted a NULL String, I could use NULL. However, some time ago, I found that the NULL Character Set was not included after I used the not in value, at that time, I also thought that it should be

In some cases, some businesses cannot tolerate data loss. In other cases, Database Availability may be more important than data loss. Some applications require the database to maximize performance and tolerate the loss of a little data. The

Recently, many employees who have installed Oracle 10g RAC on the RHEL 5.X platform do not have much difficulty, but repetitive manual work is still relatively high. Therefore, a semi-automatic installation script is compiled by the way. Install