Oracle

The following is a detailed analysis of the three methods for creating an Oracle database. For more information, see 1. Create, configure, or delete a Database by running Oracle Database Configuration Assistant (you can also enter dbca in the

After Oracle is installed, there is a default database. In addition to this default database, we can also create our own database. For beginners, you can use the 'database Configuration asmap' Wizard to create a Database to avoid troubles. After

1. The following statement is used to query which objects are locked: The Code is as follows:   Select object_name, machine, s. sid, s. serial #From v $ locked_object l, dba_objects o, v $ session sWhere l. object_id = o.

It took more than an hour to install the 11 GB package. It took a long time for SQL Developer to complete the task. Now, let's summarize the installation steps and hope to improve the installation efficiency for the children's shoes. Haha. 1. Oracle

The first thing to note is that a ORA-01555 error is a "secure" error that will not cause data loss or corruption, but will make the query that receives the error Unable to continue. The following is the cause of the ORA-01555 error is introduced,

(1) select the most efficient table name sequence (only valid in the rule-based Optimizer ): The ORACLE parser processes the table names in the FROM clause in the order FROM right to left. The table written in the FROM clause (basic table driving

1. the length of CHAR is fixed, while the length of VARCHAR2 can be changed. For example, the storage string "abc", for CHAR (20 ), it indicates that the character you store will occupy 20 bytes (including 17 null characters). In the database, it

ORA-12560 Solution Today, when oracle Data imp/exp is executed, the prompt is displayed after executing exp input scott/tiger in cmd: EXP-00056: ORACLE error 12560 ORA-12560: TNS: protocol adapter error. EXP-00000: Export termination failed I

The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. ORACLE supports the national language architecture, allowing you to store, process,

Oracle package utl_inaddr Purpose: Obtain the Host Name and IP address in the LAN or Internet environment. 1. IP address in utl_inaddr.get_host_address Environment If the query fails, a system error is prompted. Query the IP address of

Set oralce Automatic Memory ManagementShutdown and restart are required to enable oracle automatic memory management.1. Determine the sga pga memory size:SHOW PARAMETER TARGET2. determine the maximum pga usage since the database is started:Select

Oracle Linux 6 bridging NICs Recently, the company formatted an old HP to perform Linux virtualization and install some test servers. The operating system uses Oracle Linux 6.4 and the virtual machine uses KVM. The previous installation was

Stateless HTTP protocol 1. Advantages and Disadvantages of stateless HTTP protocol A) HTTP interaction is stateless. Stateless means that when a browser sends a request to the server, the server responds, but the same browser sends the request to

1. log on to the database using an oracle user [Oracle @ wuzj ~] $ Sqlplus/nolog SQL * Plus: Release 10.2.0.1.0-Production on Thu Feb 26 12:06:29 2009 Copyright (c) 1982,200 5, Oracle. All rights reserved. SQL> conn/as sysdba Connected. // View the

The former is easy to locate. All operating systems allow us to view CPU-intensive tasks. These tasks can be traced back to a specific user, a specific application module. CPU-intensive modules are generally caused by poor code and/or structure,

ISQL * PLUSThe configuration process is as follows:1. Configure HTTPD$ Cd $ ORACLE_HOME/Apache/conf$ Vi httpd. conf1.1 set the Server name or Server IP address and port and start the HTTPD process as a non-root user. The port must be greater than 102

Q: When I installed oracle9i on redhat8, I was prompted to change the second disk, but my optical drive could not be withdrawn. What should I do?The optical drive is loaded by the mount command. when changing the disk, I use the umount command under

During the installation of Oracle10g RAC, it is extremely important to exercise caution when setting the network.The following lists the network configurations of my Oracle10g RAC environment for your reference.1. settings of the hosts fileBecause

1. The tested statements must be exactly the same as those in the shared pool. 2. Variable names should be as consistent as possible 3. Rational use of external connections 4. Use less multi-layer nesting 5. Multi-purpose concurrency Statement

1. What is a cursor?A cursor is a PL/SQL control structure that allows you to control the display of SQL statements to facilitate the processing of table data one by one.2. cursor ClassificationDisplay cursor: Declared and named by the