dba

　　This example, run in MySQL5.0 and above version. The simple format that MySQL gives user permission commands can be summarized as: Grant permission on database object to user 　　One, grant ordinary data user, query, insert, UPDATE, delete all

The use of Muliple block sizes provides DBAs with additional control over the UNIX disk i/0 subsystem. ORACLE's DBA should understand the fundamentals of some UNIX disk I/O. Disk I/O is an important part of Oracle response time. reducing disk I/O

Object Design Usage Specification 1. Commonly used data types Description: The following is a commonly used data type introduction, table design according to the actual application selection. (1) Number (P,S): The exact numeric type of the fixed

Working with utilities If you have more than one version of SQL Anywhere installed on your computer, you must be aware of your system path when you use the utility. Because the installation will append the latest installed version of the executable

First introduce the next Jane Chaoyang. is now working in Alibaba (China) Network Technology Co., Ltd. DBA Team Operation Department, Jenzhiang is the MySQL Technology essay contest third winner (winning article: the implementation of MySQL

Oracle When I took the oracle9i OCP, one day on the internet, suddenly found in the oracle of this Gold certification project on the launch of a new higher level of certification, it is OCM, the full name is Oracle Certified Master, I translated it

After Oracle installs, there is a default database, and in addition to this default database, we can create our own database. For starters, to avoid trouble, you can use the ' Database Configuration Assistant ' Wizard to create a database. After

Yesterday, successfully helped the customer recover a failed database. The reason for the failure is that the technician truncate several data dictionary tables in the database, which directly results in the database being unavailable. The

There are many ways to start MySQL, we will discuss it in one by one One, mysqld Mysqld is a MySQL service Mysqld the [mysqld] and [Server] group groups in the My.cnf file when it is started this way (Each group has [] to split) In general, we

oracle| Data | database Finishing: Fenng Date: 25-oct-2004 Source: Http://www.dbanotes.net Version: 0.91 Sometimes, as a DBA, you may need to collect the deployed Oracle database information. Hardware configuration, operating system conditions,

Log in with the SYS user, authorize the DBA to the OE user so that the execution plan can be viewed with the OE user: Oe@ocm> Conn/as SYSDBA Connected. Sys@ocm> Grant DBA to OE; Grant succeeded. Sys@ocm> Conn Oe/oe Connected. Oe@ocm> set

Some of the commercial data in the network database were posted online after the theft, and the price data of the company's commercial website were maliciously modified ... Similar cases, the Internet search for a bit, really a lot. The only reason

Oracle oracle9.2 installed in redhad2.1 1. Create Oracle Users Su-root Groupadd dba Groupadd Oinstall USERADD-G oinstall-g dba Oracle passwd Oracle 2. Create installation directory Su-root Mkdir/opt/oracle Mkdir/opt/oracle/

I. Oracle built-in role connect and resource permissions Grant Connect,resource to user; Connect role:--is the typical right to give end users, the most basic Alter session--modifying sessions Create CLUSTER--Create a cluster Create DATABASE

Oracle Oracle Expert Tuning Secrets Objective 　　 Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve

# cd/home/oracle/crs/log/p570b/crsd # ls-lt Total 2150168-rw-r--r--1 root system 23958 19:14 crsd.log-rw-r--r--1 root system 10555307 Oct crsd.l01-rw-r--r--1 root System 10491275 SEP crsd.l02-rw-r--r--1 root system 10558627 Aug crsd.l03- rw-r--r-

Do MySQL 5.1 stored programs and functions work for replication? Yes, the standard behavior performed in stored programs and functions is copied from the primary MySQL server to the from server. Can the stored programs and functions created on the

Oracle 1. Modifying the kernel Vi/etc/system Set shmsys:shminfo_shmmax=268435456 (native memory is 512M) Set Shmsys:shminfo_shmmin=1 Set shmsys:shminfo_shmmni=100 Set shmsys:shminfo_shmseg=10 Set semsys:seminfo_semmni=110 Set semsys:seminfo_semmns=3

Application Purpose ======= The purpose of this article are to provide a understanding of freelists and freelist. SCOPE & Application =================== This article was intended to being used by DBAs to help understand the how freelists and

Must understand the SQL knowledge One, two table outer join query The existing two table A,b contents are as follows Mysql> select * from A; +------+------+ | ID | Col1 | +------+------+ | 1 | AA | | 2 | BB | | 3 | CC | +------+-