dba

Create | Template December 23, 2002 Using and building Query Analyzer Templates by Gregory A. Larsen Building Custom Templates By now you should is somewhat familiar with the using pre-existing templates to build your SQL code. It is now the look

Is it difficult to accurately allocate the amount of memory required for different pools? The automatic shared memory management feature makes it possible to automatically allocate memory to where it is most needed. Whether you're an entry-level

The steps described in this article may not be necessary, but the author does not verify it further, so all the steps in the installation process are listed here. 1. Install Redflag Linux 5.0 Desktop Edition 2. Prepare before installation, make a

oracle| Objects | data | database procedures and functions Procedures and functions are stored in the database in a compiled form, and functions can have more than one parameter and have a return value without parameters. The procedure has 0 or

A Work as Root user 1. Configuring Kernel Parameters Log in with root user #sam access to System Administrator Manager In which select kernel configuration, enter later in the selection configurable parameters Modify the following parameters

To start Sybase and connect to the sample database (Windows): 1. Select "Start" → "program" → "Sybase SQL Anywhere 8" → "sybasecentral". 2. Connect to the sample database. Select tools → connections. Select Adaptive Server Anywhere 8 from the

oracle| Data | database Original Author: Sameer Wadhwa Pause (quiescing) A database is a powerful new feature that allows DBAs to complete some of the operations that a database is in restricted mode (restricted modes). With this feature, the DBA

Recently, because of the need, to learn the development of Oracle applications on the Solaris system. The Solaris one for x86 was downloaded from Sun's web site, and the Oracle 10g Realse 2 (10.2.0.2) x86 was downloaded from the Oracle Web site for

Test 1. Create a user leonarding and grant DBA authority Sys@leo> create user leonarding identified by leonarding default tablespace users; Sys@leo> Grant DBA to leonarding; 2. Create a T-table, as long as the structure of information Sys@leo>

MySQL 5.5 has 3 different formats for binary log (Binlog): Mixed,statement,row, the default format is Statement. Summarize the pros and cons of these three format logs. MySQL Replication replication can be based on a single statement (Statement

Description The password you enter when you create the database is the default password to modify the system, and the password to enter when you log on as system and Sysman default is the modified password (the password you entered when you created

Data | The current situation and prospect of database industry In recent years, I've been dealing with database administrators and interviewing a lot of DBA posts directly. This article would like to summarize the requirements of the IT industry

The main features of distributed database (1), data independence and location transparency. Data independence is one of the main goals of database method, distributed transparency means that users do not need to care about the logical partitioning

Several common SQL functions for querying meta information in Sybase ASA: sp_column_privileges Unsupported sp_columns table-name [, table-owner ] [, table-qualifier] [, column-name] 返回指定列的数据类型 sp_databases Unsupported sp_datatype_info Unsupported

1, sys and system user differences The system user can only log on em with normal status. SYS user has "SYSDBA" or "sysoper" permission, landing em can only use these two identities, can not use normal. "Sysoper" permissions, which are database

Backup | data | database Oracle9i begins Rman to provide the plus archivelog option, greatly simplifying the operation of the Rman backup. When you define the plus Archivelog statement, Rman performs the following steps: 1. Run an alter SYSTEM

Under Linux, kernel may also be installed without changing the same procedure as SolarisBut the kernel parameters must be changed under Solaris, and my next lesson is for Solaris Sparc/intel 'In/etc/system finally joined these:Set

Recently in an enterprise to do an internal system, the database is SQL2000, in order to ensure the security of data, need to do daily after work to do data backup, and mail to notify the administrator of the backup situation. Backup database is

Oracle There are several places to note before installation: Your swap partition is best to have a G or so big, the second your hard disk partition best also have large enough space. The following my translation of the Chinese version: 1. Create

SQL Server database upgrades require a significant amount of planning and testing by DBAs. Most of the time, there may not be any problems with the upgrade process, but some potential threats must not be overlooked. In this article, SQL Server