Oracle

As an Oracle DBA, you must know what Metalink is.Metalink is the official technical support site for Oracle, its url: http://metalink.oracle.com. Oracle uses this website to support customers around the world. According to statistics from Oracle,

In our projects, we may encounter this situation. The database server and the client are in different time zones. Therefore, we need to consider the synchronization of time when designing our system, that is, different clients in different time

Oracle wait events are an important basis and indicator for measuring the operating status of oracle. The concept of wait events is introduced in oracle7.0.1.2, with approximately 100 wait events. In Oracle 8.0, this number was increased to

For Oracle DBAs, table space monitoring is an important task of daily and regular monitoring. Table space monitoring includes table space status, data files, table space usage, and remaining conditions. 1. Table space list: SQL> select * from V $

Just installed Oracle Application Server, login to find the password is wrong, fainted! Let's take a look at how to reset the password. It's easy to find it. Stop the ap first. You can use the command (opmnctl stopall) or menu (stop SOA suite

The procedure is as follows: 1. master database operations 1. Modify the attributes of the master database: Alter system force logging; # View status Select force_logging from V $ database; 2. Change the database to archive mode: Archive log

Technorati label: Be, Backup Exec, Veritas, backup 1.1 create job-Oracle full backup according to policy, difference to tape, restore (OK) This test is performed in the actual generation environment, and the tape library is used for backup. Then,

Here is an example of comparing two dictionaries: A dictionary has an index directory (dict A), and a dictionary does not (dict B) Now we need to find out the similarities and differences between all the words starting with. So how do you compare

This case takes China Construction Bank as an example.Download the created transaction table and name it ccb.txt.At this time, you have two options: sqlldr or external table   (I) sqlldrBecause online banking can only be used on win, if your OS is

 MTS (multi-threaded server) is an optional configuration option for Oracle server. Compared with the dedicate method, MTS has the biggest advantage of not increasing physical resources (memory) supports more concurrent connections. In other words,

Reprinted from: http://space.itpub.net/519536/viewspace-626464 Oralce pairNullThere is a special "care" in the position after sorting the values, which is "nullsWith the "first" and "nulls last" options, you can use this option to forcibly specify

System Environment: 1. Operating System: Windows 2003 Server 2. Database: Oracle9i Release 9.0.1.1.1 3. installation path: D:/Oracle database creation steps: 1. manually create related directories D:/Oracle/admin/orarman D:/Oracle/admin/orarman/Arch

Oracle Database Configuration modification:C:/Oracle/product/10.2.0/db_1/Network/admin/listener. ora C:/Oracle/product/10.2.0/db_1/Network/admin/tnsnames. ora   Oracle Database listening program cannot start the solution: C: /Documents and

After successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad conditions, by disabling non-essential Oracle services, you can speed up your

  I usually install english when installing the server operating system. This prevents garbled characters. The server system was installed by a colleague in Chinese. Garbled characters occur during database installation.   Google has a method to

1. Set the listener password [mandatory] Setting the listener password can prevent most attacks. This is usually a simple process. You can use LSNRCTL to set a password. The password will be encrypted and stored in the listener. ora file. You can

TAF is short for transparent application failover. Generally, the application TAF is in the OPS/RAC environment. The purpose and idea of this function from 8i are both good, but the current application is still very limited. This article will give a

1. Random Number packageSELECT DBMS_RANDOM.VALUE From dual; 2. Random Number in the range of [0 .. 100]Select trunc (DBMS_RANDOM.VALUE (0,100 )) From dual; 3. A 10-character random string larger than 'A'SELECT DBMS_RANDOM.STRING ('A', 10) From dual;

1. Latch description 1.1 Latch Latch is a serial lock mechanism used to protect the shared data structure in the SGA zone. The implementation of latch is related to the operating system, especially whether a process needs to wait for a latch and how

I. Conditions for triggering DBWR Disk Data Writing 1. when a process scans the secondary LRU and primary LRU linked lists to find the buffer header that can be overwritten [idle buffer, if the number of buffer headers that have been scanned reaches