Database Administrator

Recently, the system was changed from SUSE10.3 to. It looks pretty much better. However, my display is 19-inch wide screen. It takes a lot of effort to set the resolution of 1440x900 in 11.2. After the driver is installed, set the screen width

1. Delete ConstraintsAlter table table_name drop constraint constraint_name;2. Create a primary keyAlter table table_name add constraint constraint_name primary key (column_name1, column_name2 );3. Create a unique constraintAlter table table_name

First, create a physical standby database. Reference:   After creating a physical standby database, it is best to create your own spfile Stop the redo application on the physical standby Database:Alter database recover managed STANDBY database

Oracle is divided into archive and non-archive modes. The difference between the two is the redo log processing. In archive mode, when a redo log is fully written, the content in the redo log is written to the archive file. After the redo log is

Two different database servers read data from one user on one database server from another database server. In this case, you can use dblink. In fact, dblink is similar to the view in the database. When creating dblink, you need to know the IP

1. Oracle startup stepsLog On As an Oracle user and enter the following commandSqlplus/nologConn/as sysdbaStartupQuitLsnrctl start2. An error occurs when the Oracle database is started at startup.ORA-01102: cannot mount database in Exclusive

When analyzing SQL Performance, you often need to determine the SQL statements with high resource consumption, which are summarized as follows: 1. View suspicious SQL statementsSelect substr (to_char (s. pct, '99. 00'), 2) | '%' load, S.exe cutions

I made a small modification to the eclipse project today and found that the previously running project is always stuck today. I started to think that the database has not closed the connection, leading to connection congestion, later, I took a

Improving Oracle performance-how to index I. Question proposalAt the early stage of application system development, due to the relatively small amount of data in the development database, the performance of SQL statement writing is not good for

0. database parameter attributesCol PROPERTY_NAME format a25Col PROPERTY_VALUE format a30Col DESCRIPTION format a100Select * from database_properties; Select * from v $ version; 1. Find the SID of the current session, SERIAL #SELECT Sid, Serial #

Mysql HA achieves high availability of MYSQL I. background Most websites currently use the classic configuration like MYSQL + Linux + APACHE. It is important for website administrators to consider how to prevent the unavailability of the entire

Oracle 10g RAC cannot add node Unable to access cluster service while creating node, cocould not add node rac1 1. Check whether the node you added is the IP address of the host involved in the cluster defined in the hosts file. If not, it is likely

It's a bit empty. Let's summarize it with the new occi packages. This article is actually very useful, and it is a difficult topic for newcomers, for example, Oracle, unix, c ++, occi, shell, and makefile. Just pick out a noun and you will be able

// Connect to the database$ Conn = mysql_connect ("localhost", "root", "123456 ");// Select a databaseMysql_select_db ("test", $ conn );// Start ErrorMysql_query ("start transaction ");// Add a master table$ InsertStudent = "insert into student

Recently, the company bought a video conferencing software, but only the operating system provided by the company (CentOS 5.2 x86), and there is no graphical interface, which makes me very depressed. Since there is no graphic interface environment,

Recently, we used hibernate to dynamically generate tables in the project. When we set hbm2ddl. auto to update, we found that hibernate did not generate the corresponding data table information according to the default generation rules. However, it

### Run the following content in the System shell--- Run the following content in Sqlplus with this Annotation### 1. Environment for obtaining Oracle usersSu-oracleCd/oracleSource. cshrc### Display the running status of Oracle10gRAC/crsCrs_stat-t###

Database Version Oracle11gR2SQL> select * from v $ version where rownum = 1; BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production Create a manually

When using lomboz_eclipse 3.3 to connect to Oracle, you may encounter some troubles. Write down this process for your reference. 1. window --> show View --> other --> Connectivity --> Data Source Explorer 2. In the new Data Source Explorer window,

The shared pool is mainly composed of data_dictionary that saves the data dictionary and the library cache that saves the SQL and PL/SQL code and execution plan. It also includes several other buffers for different system features and technologies,