Database Administrator

Some performance Alarms can be found through the dba_outstanding_alerts table. If the locked table cannot be released for a long time, the sid and serial # Of the relevant session can be found here #. select * from dba_outstanding_alerts

The new server gave me a try. I simply recorded the installation and upgrade process and learned from the experts. When installing Linux AS 4.7, you can choose LVM to easily manage the space, increase or reduce the size of the file system, and

I use binary for installation, file nameMysql-standard-5.0.18-linux-i686-glibc23.tar.gz[1] decompress the above file to a certain place and change the directory name of MySQL to mysql. The result should be as follows:/Home/jiang/mysql[2] INSTALL

Install mysql5.1 using rpm in CentOS/Linux First, we need to download the 64-bit Linux, so the 64-bit version is downloaded, and the following three files are required: 64bit

1. Create a tablespace for the experiment. Create tablespace block datafile size 1 M extent management local;-because it is 11 GB, AMS is used. Alter user ff default tablespace block; Alter user ff quota unlimited on block; 2. corrupt data

MySQL compilation and Installation notesThe premise is that your Linux system should build the GCC compiling environment.If CentOS is used, you can:Yum-y install gccYum-y install gcc-c ++Add MySQL user groups and usersGrounadd mysqlUseradd-g

MySQL service basics: MySQL is an open-source relational database server software. It is currently developed and maintained by Oracle. MySQL features multiple threads and users. It is based on the C/S (Client/Server) architecture. It is easy to

After receiving the phone number from the O & M personnel, the number of connections to the mysql server is full. log on to the server and check that it is full. Well, first increase the number of connections to 2500 to provide external services

Oracle does not distinguish whether tables or indexes are stored in tablespaces. When the data volume is small, you can place tables and indexes in the same tablespace. However, as the data volume increases, it is best to separate the table and

Grant select any dictionary to scott;Create table t1 as select * from emp;Insert into t1 select * from t1;-- Check the storage partition records whose segments are T1 under scott.Select segment_name, extent_id, file_id, block_id, blocksFrom

Error Reporting ProcessSrv-bioradb: ~> Sqlplus/as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Thu Jul 25 18:27:45 2013 Copyright (c) 1982,201 1, Oracle. All rights reserved. Connected to an idle instance. SQL> startupORA-00845: MEMORY_TARGET

(I) HugePages Introduction HugePages is introduced by kernel 2.6 to adapt to the increasing physical memory size. In Linux, the default page size is 4 K. If HugePages is used, the default page size is 2 M. Let's look at two more terms: Page table

Question: Oracle 11g Rac is more difficult to maintain than 10g, and more commands are provided, this section summarizes the Votedisk, OCR, and some commands used for resource maintenance of 11g rac for future reference. Recommended reading: Oracle 1

Step 1: query the table id from the data dictionary View Select object_id from all_objects where owner = 'sunard' and object_name = 'tbl _ WDC_INF '; Step 2: Identify the order of all fields in the table by id Select obj #, col #, name from sys.

Oracle 10g connection error: ORA-12514: TNS: The Listener currently cannot recognize requests in the connection Descriptor Solution:1. Open the /network/admin/listener. ora file and find:SID_LIST_LISTENER =(SID_LIST =(SID_DESC =(SID_NAME =

In actual application development, we have a lot of energy devoted to debugging programs and troubleshooting exceptions. The code developed using the design logic and scenario is often broken by the production data ". Quick locating of Error Data

What is the process of SQL statements in the database? What is the execution order? Before answering this question, let's review: in the Oracle database system architecture, SQL statements are generated by user processes and then transmitted to the

Question 1: Dbstart error: Failed to auto-start Oracle Net Listene using/ade/vikrkuma_new/oracle/bin/tnslsnr After successfully installing Oracle10G in Linux, switch to the Oracle user and directly use "dbstart" ($ ORACLE_HOME/bin) when the oracle

The tkprof program is further described as follows:After the tracking function is enabled, Oracle collects the performance status data of the SQL statements being executed in the tracking session to a trace file. This trace file provides many useful

1. Installation --------------------------------------------------------------------------------# Add an installation Source [Mongodb]Name = MongoDB RepositoryBase url = http://downloads-distro.mongodb.org/repo/RedHat/ OS /x86_64/Gpgcheck = 0Enabled