Oracle

How to deal with the large types of CLOB and blobs CLOB can be used to store large text data, storing up to 4GB of data, and is more common in application development. Java provides a corresponding Sql.clob class. It provides two methods to read

The row and column conversions include the following six scenarios: 1. Column career Change 2. Row-Turn column 3. Multiple columns converted to strings 4. Convert multiple lines into strings 5. Convert strings to multiple columns 6. Convert

First, dynamic monitoring 1. Listening for files [Oracle@node1 admin]$ More/u01/oracle/network/admin/listener.ora Sid_list_listener = (Sid_list = (Sid_desc = (Sid_name = Plsextproc) (Oracle_home =/u01/oracle) (program = Extproc) ) )

1. Table structure Sql> desc v$process is the name empty? Type ----------------------------------------- -------- ---------------------------- ADDR RAW (8) PID number SPID VARCHAR2 (12) USERNAME VARCHAR2 (15) serial# number TERMINAL VARCHAR2

Yesterday a friend asked me how to monitor the operation of a pl/sql, here is a brief introduction to several methods. Introduce a professional Dbms_application_info package. The previous article introduced a solution through inserts and

Description of the phenomenon: Oracle Clusterware, Oracle cluster software introduced in Oracle 10G/11G version, if you need to reinstall Oracle Clusterware (CRS) on a server, you must first send Oracle Clusterware (CRS) Remove clean. Alarm

The Oracle 11g default installation database starts the audit feature, resulting in increased Oracle cumulative sys.aud$ table and associated index data volumes; If the table space is full, the ora-1654:unable to extend index SYS will be reported

We typically install the Oracle database on Linux or configure the core parameters of the Linux system when replacing or upgrading the hardware, and then adjust the Oracle system parameters. The actual meaning of these parameters is what, why to

Oracle database and SQL Server database are two commonly used databases, in the industry, Oracle database security is generally considered to be higher than SQL Server database, but the actual Oracle database and SQL The server database has how the

Preface The growing demand for distributed applications requires a better distributed software environment, which drives the development of distributed technology. Oracle data replication is a technology for implementing distributed data

Oracle advanced replication, also known as symmetric replication. Unlike Oracle's other features, Oracle's advanced replication is not Plug and play, and users must have a deep understanding of how they work and the advantages and disadvantages of

An Oracle physical structure failure is a variety of database failures that result from corruption of each physical file that constitutes a database. These failures may be caused by a hardware failure or by a human error. So we first need to

Oracle's BLOB field type can be used to hold long 2 of data. But the code that reads and writes the BLOB field data is usually verbose, and it's easy to make mistakes when it's not carefully coded. I integrate this feature into my OCI packaging

Oracle Logminer is an actual, useful analysis tool that Oracle has provided from the product 8i, which makes it easy to get the details of Oracle Redo log files (archived log files), especially The tool can analyze all the DML (INSERT, UPDATE,

In Oracle database systems, There are two ways to authenticate users if they want to log on to an Oracle database as a privileged user (Internal/sysdba/sysoper): Authenticate with an operating system-integrated authentication or a password file that

Prior to the Oracle 8i release, the internal user was used to perform the database startup and shutdown, as well as create database operations; Oracle has been phasing out internal users since the 8i version, Users who are granted the SYSDBA or

Reprint: http://www.cnblogs.com/djcsch2001/articles/1823459.htmlIndex, index creation, modification, deletionIndexAn index is an object in a relational database that is used to hold each record, and the main purpose is to speed up the reading speed

Function 1, numeric function (1) ceil (n)Returns the smallest integer greater than or equal to n(2) Power (m,n)Returns the n-th side of M(3) Trunc (M[,n])For the M intercept operation, when n is greater than 0 o'clock, the nth bit is intercepted to

Oracle's reverse engineering refers to importing databases in Oracle, or, of course, databases in SQL Server into PD, which requires a link to a database and then reverse-engineered operations.First step: Establish a link to the

One, configure the Oracle port on the serverEnter the NETCA command on the command line to open the related configuration default port number is 1521Second, after configuring the port, use the Telnet tool to debug the port.Enter the Telnet server IP