Database Administrator

One of the top 10g features of Oracle is the Advisory Framework, which is a collection of optimization consultants that can help you make full use of your database. One of them, the SQL Access Advisor, recommends that you change the indexes and

Oracle announced at its headquarters in the United States that the latest version of Oracle Database 11g is now fully available, the product is completely based on the Linux platform. Oracle Database 11 GB provides customers with a new generation of

In linux, only one Oracle database can be created. However, you can create different tablespaces for different users. The format is as follows:Create tablespace vewertemp datafile '\ oracle \ oradata \ viewer \ dbvewertemp. dbf' size 50 M autoextend

The database part in the deployment system is mysql, which is used in linux.In mysql, there is no password for Local root Login by default.Execute a grant statement as follows:Grant all on *. * to 'livesky 'IDENTIFIED by '20140901 ';Explanation:

After the Linux system is installed by default, there is no built-in database software, which does not meet our needs for Java EE development. Therefore, we need to install the database software by ourselves. Of course, the first choice is MySQL.

Oracle Database logs are called redo logs. All data changes are recorded in redo logs, which can be used to repair damaged databases. Large Databases use logs. The benefits of this design are the same.Redo logs are grouped. A database must have at

Software environment: 1. Windows 2000 Oracle 8.1.7 2. ORACLE installation path: C: \ ORACLE Implementation Method: 1. Choose "start"> "Settings"> "Control Panel"> "Administrative Tools"> "services" to stop all Oracle services. 2. Start-> Program->

Recently I wrote an Oracle job, which runs at an interval of 1 minute. However, I found that this job was not running. I initially suspected that the time interval was incorrect, but I found that the time interval was not an error. I also suspected

Copy the following code and save it as ***. php. $ User = "database username ";//$ Password = "Database password ";//$ Db_name = "Database Name ";// $ Link = mysql_connect ("localhost: 3306", $ user, $ password );Mysql_select_db ("$ db_name", $

After installing Mysql in Linux, You need to perform some configuration.Modify/etc/my. cnf as needed. Refer to the Configuration:[Mysqld]# Set the default value to the INNODB table, which supports transactions and row locks:Default-storage-engine =

Mysql may have different codes installed on windows and linux. If garbled characters occur during data import and export from these two databases, therefore, we can add a forced encoding to import and export databases: 1. mysql-uuser-p --

The Oracle display cursor is a SELECT clause clearly defined in the Declaration unit, and a name is specified at the same time.Use this name to reference the cursor attribute canonicalizedly, and use the name to reference and display the cursor in

The following is a summary of installing MySQL in Ubuntu 12.04 over the past few days: There are three ways to install MySQL in Linux: the first is to install the rpmbinary file separately, the second is to install the source code after compilation,

Reference: Doc ID 109095.1 First, create a Java class that calls Unix shellon the database, and use runtime.getruntime(cmd.exe c () to implement 1. Create or replace java source named "CaptureStream"Import java. util .*;Import java. io .*; Class

1. In the system environment, CentOS 6.3, master a ip: 192.168.1.28, and master B ip: 192.168.1.29. 2. Install cmake and mysql 1. Install cmake # Tar xf cmake-2.8.8.tar.gz # Cd cmake-2.8.8 #./Bootstrap # Gmake & gmake install 2. Install mysql #

Initialization parameters related to the Primary role Db_name Db_name must be the same in the same DG Environment Db_unique_name The db_unique_name parameter is an added parameter for the coexistence of multiple instances

1. parameterized cursorPurpose: Open the same cursor multiple times and return different result sets. The parameters in the declaration part of the cursor must correspond to the real parameters provided in the OPEN statement (quantity and data type )

1. functions and features of Control Files 1) define the current physical status of the database2) maintain data consistency: If the checkpoints in the control file are consistent with those in the data file, the data is consistent and can be

In the Oracle system, if the remarks field requires 200 Chinese characters, this field is either set to varchar2 (600) or nvarchar2 (200 ). The following provides a reference for saving the length of Chinese characters in the remarks field of

Thread pool operation process: The thread pool contains a certain number of thread groups. Each groups manages a certain amount of client connections. when mysql establishes a connection, the thread pool will be cyclically (round-robin fashion)