Database Administrator

◆ Oracle user environment settings: $ Cat. profile # Created for oracle RAC by ljg, 20091230 --- begin # Umask 022 ORACLE_BASE =/u01/app/oracle; export ORACLE_BASE CRS_HOME =/u01/crs/oracle/product/10/app; export CRS_HOME ORACLE_HOME = $ ORACLE_BASE/

SQL: With partdata as (select rownum rowno, t. * from tablename t where column = '000000' order by column) select * from partdata where rowno between 0 and 50 It is said that this speed is fast. This can also be: Oracle paging has a common

During project development today, we found that there are too many database connections and many timeout connections exist in Oracle. As a result, the new client cannot connect to the database. Therefore, the oracle connection attribute is forcibly

It took a long time to connect the Oracle 10g database to the Tomcat server after one night and one morning, but it was actually quite simple.I am using Java. There are two methods. Related reading: Notes for using spfile and pfile in Oracle (1) //

Before 9i, Oracle used pfile to store the initialization parameter settings. These parameters were read when the instance was started. Any modification requires restarting the instance to take effect, with spfile, you can use alter system or alter

How to display all current user tables in OracleShow all tables of a user (for example, SCOTT, uppercase is required) Select TABLE_NAME from all_tables where owner = 'Scott '; Show all current user tables Select * from user_tables Display All

Oracle Data Import Imp user/passwd file = abc. dmp tables = abc indexes = n Oracle Data Import (dmp file) The data volume is large and the compressed dmp file is 15 GB. You need to export the data to the company's test database. I thought it was

Oracle dump may have Character Differences in different oracle databases. Today, I am going to get a new method from my friends, as shown below. 1. Common method-find a machine with the same Registry language and oracle language characters and

LVS Server: 192.85.1.5Virtual IP: 192.85.1.10Real Server1: 192.85.1.4Real Server2: 192.85.1.9Install ipvsadm and keepalived on The LVS Server.$ Sudo apt-get install ipvsadm keepalivedYou can directly modify keepalived. conf without configuring

The process of cross-compiling the SQLite-3.3.8 (or SQLite3.3.12) and porting to ARMS3C2410: To port SQLite3.3.8 (or SQLite-3.3.12) to the ARM2410 Development Board, in addition to the support of the underlying operating system, you must also have

Early in the morning, I found that all mysql files in the Data Directory had disappeared, and a cold sweat occurred. What happened !!??? Was hacked, or was mysql Data loss caused by restarting the server two days ago ??? What is the problem? go

Today, my colleague reported that the installation of the Oracle 11g client on RedHat 5.5 has been unsuccessful. For the error, see: View the specific error information as follows: Information: Build a client shared libraryInformation: Build a

The TRUCK_GPS_TRANS table uses the interval patition function of Oracle11 to automatically create partitions by day. Now, you need to delete the partition data from the past 30 days on a regular basis to keep the business data in the table for only 3

A few days ago, when archiving cannot be closed due to batch data import, the archive path and the flash burst! (I am still curious about archiving. I have never met this before. I don't know why) Ora-19815: Warning db_recovery_file_dest_size 100%

The Oracle execution plan storage outline corresponds to the SQL statement one by one. Therefore, if we change the predicate condition in the SQL statement, the storage outline will be ineffective or we need to create a new storage outline to

The Oracle Database modifies the corresponding values for the same field based on different conditions: For example, adjust the employee's salary based on the position. If the employee's position is "SALESMAN" or "ANALYST", the employee's salary is

1. Define the time range Determine the number of logs to be mined based on the time, and add the logs to the script respectively.  2. Write a logminer script Execute dbms_logmnr.add_logfile (logfilename => '/home/Oracle/admin/ORCL/archive/ORCL_1_6701

Open the log-bin parameter in the master database to ensure that the server-id parameters of the master and slave are different. Create a rep user on the master to allow slave access [Plain] view plaincopyprint?MASTER @ root @ (none) 12:34:34> grant

This is a relatively biased knowledge, but it has a lot of practical significance and can help DBAs complete some daily management work, for example, you can disable some user functions (prohibit users from modifying or deleting a table, and

Today is, and the learning progress is also in full swing. Today, I will record a small part of the experiment. We know that the RAC network has a private network and a public network. The public network provides customer access requests and the