Oracle

In the process of running Oracle, for various reasons, some objects, such as stored procedures and functions, are as follows: SQL> select distinct object_type from all_objects; Object_type------------------ClusterConsumer groupContextEvaluation

The log buffer log_buffer is the memory area used by Oracle to store redo logs. When the database is started, you can see: SQL> startupThe Oracle routine has been started. Total system global area 85006980 bytesFixed size 453252 bytesVariable

To_char is a function that converts a numeric or date type to a numeric type. For example, the simplest application: /* 1.0123 ---> '1. 0123 '*/ Select To_char (1.0123) From Dual /* 123 ---> '123 '*/ Select To_char (123) From

Exp export data, reported EXP-00003: Not found segment (12, 11) Storage definition, looked up from the Internet, there are two main reasons: 1. Version problems, that is, the client and server versions are the same, while I only have minor version

1. query the list of log files used:Select * from V $ log; 2. query the log files of the Group in use:Select * from V $ logfile; 3. Force log switching:Alter system switch logfile; 4. query historical logs:Select * from V $ log_history; 5.

Ant has no problem in executing system commands. In this actual system command, two problems are encountered: one is that the command for starting the service contains spaces, and the other is how to back up the database and add the date

I. Inner join) The connection condition of the where statement first concatenates all tables to be connected into a "big table". If there are other conditions in the middle, you can use the restrictions, after reducing the number of columns and

The Oracle control file is the core file for running the Oracle database. If the control file is lost and cannot be recovered, the consequence is very serious and the database cannot be started. Oracle provides two methods to back up control files: 1

Common Oracle management SQL commands Database Version SQL> select * from V $ version;Banner----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.1.0-ProductionPL/SQL release

During development, we often encounter the cursor Writing of dynamic table names, which happens in the work, as shown below:   DeclareStralltable varchar2 (100 );Type cur_typ is ref cursor;C cur_typ; C_id number (18 );C_code varchar2 (100 );BeginFor

Why check points must occur when the database switches logs? What is the significance of this checkpoint? Which of the following table space management methods are available. Differences between local indexes and global indexes and their

Oracle provides two administrator verification methods: operating system verification and password file verification, connecting to the database, and performing management tasks. When an Oracle database is created, two users sys and system are

During work, I found that a data computing result was abnormal. I checked the original data and did not find any problems. I then compared it with the system computing result. I was shocked: It was a lot bigger, so, check the program and find the

The client can connect to the server only after creating a connection with the server. At this time, the server needs to allocate certain resources to the user for connection, that is, PGA. So how does Oracle manage PGA? How many resources does a

Oracle monitoring lock table (Lock table and unlock table) 1. query locked tables Select S. username, decode (L. type, 'Tm ', 'table lock', 'tx', 'row lock', null) lock_level, O. owner, O. object_name, O. object_type, S. sid, S. serial #, S.

How to Implement comma-separated column-to-row Conversion     1. The conversion method is as follows: Create or replace view v_con_project as select CP. "con_num", CP. "project_code", CP. "req_money", CP. "is_has_build_dept", CP.

Performance Analysis of paging writing and supplementary description of rownum I. Data preparation before testing SQL> SELECT COUNT(*) FROM BPM_PROCVAR; COUNT(*)---------- 2121400 Ii. Paging writing 1. Paging method 1 SELECT * FROM (SELECT

Share a little bit of experience: Seq_bos_t_priv_function is a sequence, and colnum1 is the primary key.Insert into Table1 (colnum1, colnum2) values ('select seq_bos_t_priv_function.nextval from dual', '1 ');Insert into Table1 (colnum1, colnum2)

This article describes two sample codes for configuring the connection between Oracle and MySQL using "c3p0 ".You can make corresponding modifications based on your actual situation. 1. Connect to the Oracle database  

ISQLPLUS cannot access em in Web mode. 1. Check whether the host name, IP address, and port are correct.The host name, IP address, and port are recorded in the $ ORACLE_HOME/install/portlist. ini file.The default value is: Average userHttp: // ip: 55