Database Administrator

On CentOS 6.2 X64, 64-bit Oracle11gR2 is installed silently, and listening settings are silent. 1. Environment before installation:Operating System: CetnOS6.2x64 minimal installation. configured network IP address: 172.16.2.182, physical memory 8 GB,

Environment Description: OS/aix5.3-64bit DB/10.2.0.3-64bit Today, a new database is created on a quasi-standby bare device in an aix production system. Therefore, dbca is called to create a database using a data warehouse template. The

Java. SQL. SQLException: Access denied for user 'root, password = www.bkjia.com '@ 'localhost' (using password: NO) Today, when I tried to write the code for connecting to the database, I encountered a problem. It took only half a day to find the

When running a 32-bit Oracle database on a 32-bit or 64-bit platform, SGA is always limited, so that large memory machines cannot fully play a role, recently, I have found some documents on adjusting the largest SGA region. I have read the documents

Configuration of Outline in OCM: 1) Create outline for CATEGORY default (sys user ):Create outline scott2On select empno, ename FROM scott. emp3 where empno = 7788; 2) query the current outline status:SQL> select name, category, owner, SQL _TEXT

When you use sqlite3 to insert data, it takes about ms to insert each data entry. For batch import, You can import things to increase the speed. But assuming that your business inserts several data records every several seconds, Ms is obviously not

Compile the following function in the user to prompt that no dba_objects object exists; Create or replace function my_get_name (v_objid number)Return varchar2 isV_objname varchar2 (100 );BeginSelect t. OBJECT_NAME into v_objname from dba_objects t

RangePartition: RangeA partition is a table partition with a wide range of applications. It uses the range of column values as a partition condition to store records to column values.RangePartition. For example, by time,2010Year1Monthly

I. Reserved Area Loading and aging of large objects without PIN will cause fragments in the sharing pool. Oracle wants to solve this problem. It opens up a region in the sharing pool, all objects larger than 4400 bytes will be allocated space in

1.1. Installation Procedure 1.1.1. Go to the system and decompress the package file of our database. Go to the database directory and run./runInstaller. # Unzip linux.x64_11gR2_database_1of2.zip # Unzip linux.x64_11gr2_database204 f2.zip Note:

I have encountered some database problems during performance tests recently. I usually use slow query logs to find SQL statements with poor execution performance. However, I cannot find these SQL statements only, we need to help developers analyze

In Oracle databases, consistent gets is very useful in determining the performance of a SQL segment. Generally, comparing the performance of two SQL segments is not a short execution time, it depends on whose consistent gets is small. However, this

Oracle 11g grid infrastructure installation failure, or need to uninstall, not as troublesome as 10g CRS component Uninstall. Take linux as an example. The procedure for manually deleting CRS at 10 Gb is as follows:Rm-f/etc/init. d/init.css

Latin1 is an alias for the ISO-8859-1, and Latin-1 is written in some environments. ISO-8859-1 encoding is single-byte encoding, downward compatible with ASCII, its encoding range is 0x00-0xFF, 0x00-0x7F completely consistent with ASCII, 0x80-0x9F

Overview of Oracle flash deletion and recycle bin In earlier versions of the Oracle database, if a table is mistakenly deleted, the database must be restored to the previous time to restore the deleted table. This process is usually time-consuming

1. When the mysql client initiates a connection request, the MySql Server takes the initiative to check the client host name. 2. First, find the/etc/hosts file in the Windows System directory and search for the ing between domain names and IP

Oracle startup and ShutdownI. startup and shutdown processesStartup: shutdown → nomount (routine startup) → mount → openShutdown: open → mount → nomount → shutdownIi. startup routine (nomount)The startup routine puts the database in the nomount

When installing Oracle 10g RAC on Linux systems such as Red Hat as 5, we often encounter one or another errors. Some new environments lack such configurations, some old environments have such unsuitable settings, and sometimes some bugs. I have

Oracle implicit parameter: Use of allow_resetlogs_uption Tip: Implicit parameters of Oracle should be used only in the test environment or with the Support of Oracle Support. When the redo file in oracle is corrupted:1: If the damaged non-current

For RAC, when an Oracle Instance fails, the application has several high-availability technologies to ensure availability. These technologies are transparent to the client, and the client may not be able to perceive the instance failure. 1.