Oracle

1. Display user Information (1) Display the current session user 10:16:18 sql> Show user; USER is "SYS" (2) Show privileged users 10:17:07 sql> Conn sys/oracle as SYSDBA; Connected. 10:17:09 sql> SELECT * from V$pwfile_users; USERNAME Sysdb

Oracle 10g introduced the concept of the temporary tablespace Group (temporary tablespace Group), which allows users to take advantage of multiple temporary tablespace spaces simultaneously in different sessions. 1. Main features of the temporary

A lot of the time, do Oracle DBA us, when the application administrator to inform us that the application is now slow, the database is very slow, when we go to the database to do a few examples of select also found the same problem, sometimes we can

1. Definition Process: (1) Accept 0 or more parameters as input (input) or output (outputs), or both as input and output (INOUT). (2) Unlike functions, stored procedures do not return a value. (3) Stored procedures cannot be used directly by SQL

operating system authentication on a server 1. Configure Sqlnet.ora Files Parameter names.directory_path= (TNSNAMES, Onames, HOSTNAME) indicates how the host string used to resolve client connectionsTNSNames said the use of Tnsnames.ora file to

Oracle Area information for SGA The SGA (System global Area) global zone is combined with some of the necessary background processes called instances (Instance). said it is the global zone is comprised of global variables and data structures, and

oracle| Temporary Table | question In a program, a subquery is often required within a primary key range, which is dynamically generated in the foreground. So the only one that comes over is a string-formatted SQL statement that determines the range

oracle| Data | database Finishing: Fenng Date: 25-oct-2004 Source: Http://www.dbanotes.net Version: 0.91 Sometimes, as a DBA, you may need to collect the deployed Oracle database information. Hardware configuration, operating system conditions,

oracle| Control | data | Detailed transaction control transaction control includes coordinated access to multiple synchronizations of the same data.　　When a user changes the data that another user is using, Oracle uses transaction control who can

Enterprise|oracle 3rd: Oracle Enterprise Manager get started back to course list purpose This chapter introduces you to Oracle Enterprise Manager Database control. Oracle Universal Installer will install Oracle Enterprise Manager Database control

Oracle The new experience of ORACLE's virtual Private database =============================================== Welcome everyone to exchange with me: small white enhydra_boy@tom.com Welcome to reprint, please keep this statement, thank you! ======

One, the shared server mode work mechanism: Shared server mode (also known as the MTS Multi-threaded server): After the database is started, there are two more processes than the dedicated server mode, one is the dispatch process (dispatcher)

1. Basic Database Information Version information: Sql> select * from V$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-prod Pl/sql Release

This is a set of Windows RAC environments, as well as an environment that previously dealt with a performance failure caused by a row cache lock. Here is a record of the process: 1 for the one-hour AWR collection and analysis, first of all, from

I. The concept and architecture of Rman Recovery Manager (RMAN) is an Oracle tool for backup (Backup), restore (Restore), and recovery (recover) databases. Rman can only be used in ORACLE8 or higher versions. It can back up the entire database or

Previously, the LOB fields were processed using the Dbms_lob package, and a recent document found that many of the commonly used character functions support lob fields. Create a test table: Sql> CREATE TABLE T_lob (ID number, CONTENTS CLOB);

Oracle's documentation describes that when the sample statement is not included, you can use hint to specify the execution plan, which in fact takes effect even if the sample statement is included. Hint Sql> SELECT object_id from T SAMPLE (1) WHERE

Some time ago in a migration of data pump and exp, found that the difference in efficiency is quite large. Here is an example of a simple comparison. First, compare the difference between exp general mode, exp direct path mode, and EXPDP three ways

In 11GR2, Oracle analysis functions are further enhanced. This article introduces the new analysis function Listagg. 11GR2 also adds an analytic function Listagg, the function of which implements string concatenation. In 11GR2, Oracle has finally

http://www.ohsdba.cn/index.php?g=Home&m=Article&a=show&id=171 time: 2016-10-09-00:40:04 | Author: ohsdba | 中文版If not noted, this site is the original article. Welcome reprint, please indicate the source and author information when reproduced. DTrace