Oracle

/*Obtain the Oracle service name1. Query the registry and obtain the Oracle Installation root directoryFor example, HKEY_LOCAL_MACHINE \ SOFTWARE \ oracle \ ORACLE_HOME REG_SZ E: \ oracle \ ora92Find the location of the Oracle service name file:

After we installed Oracle10g on the machine, we found that it was still the default machine name. It was too long to remember and changed to a simple one. Restart the system, start the console, and prompt the Agent process exited abnormally during

Before learning a new thing, you need to understand its purpose. Article This section describes the advantages and disadvantages of Oracle RAC and other four components for future reference. The full text is as follows: To improve performance,

When I accidentally executed the left outer join query of Oracle 9i, I found some incredible problems. I will post them here to discuss with you.Create tables and records to simulate the current situation:Create Table temp_test1(A number

1. The database name is the internal identifier of the Oracle database. It should not be changed after installation. Many physical storage directories of the database use the database name. 2. instance_name, oracle_sid, and database instance name

Three parts in total Part 1 Oracle 10g Installation Part 2 ORACLE Express Installation Part 3 ora-12514 troubleshooting Part 1 Oracle 10g Installation Http://www.jb51.net/article/18038.htm People who have just been familiar with Oracle will feel

 1. Orion Overview 1.1 Orion description Orion (Oracle I/O calibration tool) is an independent tool used to calibrate the I/O performance of the Oracle database's storage system. The calibration result is of great help for understanding the

 1. Enterprise Manager Component Description   Before the description, we first use the following SQL statement to check the components in the database: SQL> Col comp_id for A15 SQL> Col version for A15 SQL> Col comp_name for A30 SQL> select comp_id,

I played Oracle 11g. It was a bit problematic. I wanted to check the log and found it for half a day. The original 11g Alert Log was changed, starting from Oracle 11g, oracle Database provides alert logs in two formats: XML and traditional

If reproduced, please indicate the source: http://blog.csdn.net/robinson_0612/archive/2010/03/30/5431428.aspxAlthough Oracle 10g Database Release 2 has been released for several years, this version is still a version that many beginners learn. The

When I first started to study C # development projects, I had to worry about writing a secure and efficient database connection for a long time. I found that many friends who have just started learning and some who have been friends for a year or

Oracle paging query SQL syntax classification: Oracle column 4850 people read comments (1) collect reports -- 1: no order by statement. (Most efficient)-- (After testing, this method has the lowest cost. Only one layer is nested, and the speed is

Http://hi.baidu.com/%D3%C5%D3%CE%D7%D4%B5%C3/blog/item/512586f7b4c1e521720eecf9.html2007-10-27 In recent times, many netizens raised questions about Listener Configuration, and the client cannot connect to the server ). This article briefly

Oracle character FunctionsDescription: The input value of a character function is of the character type and the return value is of the character or number type. It can be used directly in an SQL statement or in a PL/SQL block. 1. ASCII (n)

Making Oracle run faster 2-database design and optimization based on massive data Edit recommendations The first domestic project was created based on the author's 10 years of work experience. Books on Database Design and Optimization Based on

I. Check Process(1) We can check the Database Alert LogExample:/U0/admin/SM/bdump/alert_sm.logThe temp tablespace error is not reported in the database. Generally, no error is reported. You can ignore the error because no temp tablespace is required.

In a high-availability system, changing the definition of a table is a tough issue, especially for a 7 × 24 system. The basic syntax provided by Oracle can basically meet general modification requirements. However, if you change a common heap table

Installing oracle in Linux is a daunting task. Its complexity far exceeds that of installing the Linux operating system. If Oracle is successfully installedAt the same time, I also mastered some Linux technologies. This article describes how to

Part 1: SQL & PL/SQL[Q]How to query special characters, such as wildcards % and _[A] select * from table where name like 'a \ _ % 'escape '\' [Q]How to insert single quotes to database tables[A] ASCII codes can be used for processing. Other special

During database operations, we may encounter this situation, and the data in the table may be repeated, causing a lot of inconvenience during database operations, so how can we delete the useless data? The deduplication technology can provide a