Oracle

Oracle Archive Log configuration query Archive Log is a non-active redo Log backup. archive logs can be used to keep all redo history records. When the database is in ARCHIVELOG mode and the log is switched, the background process ARCH will save the

1. Connection host string, said no listener SVRMGR> connect; ORA-12541: TNS: no listener SVRMGR> 2. Run the listener to indicate that the protocol-specific component of the address is incorrectly specified. C:> lsnrctl LSNRCTL for 32-bit Windows:

DBAs often encounter such a headache: they do not know who created a user in Oracle and did not specify the default tablespace for this user, therefore, this user will use the default tablespace-system tablespace. As a result, the system tablespace

This article will discuss and share with you some common classic queries of oracle SQL. You are welcome to add them. You can also share some classic queries. In this article, if you think there is any better solution to every problem, you are

Here we will introduce several steps to manually create a database in Oracle, including preparation and implementation.AD:Manual database creation in Oracle is the focus of this Article. We hope this article will help you better use Oracle. In

1. oracle internal process during select executionAnalysis: Includes syntax analysis, semantic analysis, view conversion, expression conversion, optimizer selection, connection method selection, connection sequence selection, and data search path,

  During Normal project development, I believe that a large batch of people are using this database's auto-incremental ID, which has both advantages and disadvantages. Advantage: it saves time, and you don't have to worry about how to identify

There is a new feature in 11G. When the table has no data, no segment is allocated to save space. Solution: 1. insert a row and then roll back to generate a segment. This method inserts data into an empty table and then deletes it, resulting in a

Today, due to business needs, we ran EXP conditional export and found some differences between WINDOWS and LINUX. The main difference lies in sensitive characters. The example is as follows:LINUX:Exp us/pass TABLES = \ (t_ec_event \) file =/tmp/test.

Oracle 10g installation does not find a prerequisite error solution when installing oracle 10g (Version: 10.2.0.1, haha, 10201) error: In oraparam. the prerequisite check is not found in ini, and the system prerequisite check is not executed. Start

Oracle audit table AUD $ processing method Oracle version: 11.2.0, other versions should test whether DBMS_AUDIT_MGMT is successful 1. query the table, and then truncate select count(*) from aud$; truncate table aud$; select count(*)

Setting the sga_target non-normal value causes the ORA-00093 to solve the problem of setting the sga_target non-normal value causes the ORA-00093 to install a new oracle server and then modify the parameters. SQL> alter system set sga_target = 1320

Oracle basic mathematical functions 1. trigonometric Functions Sin asin sinhcos acos coshtan atan tanh [SQL] SELECT SIN (3.14159265/6), ASIN (1), SINH (1) FROM DUAL; -- all others are similar to ATAN2 (x, y) returns the arc tangent of the coordinate

Compared with the general views, the general views and materialized views of Oracle differ from the general views in that the materialized views manage stored data and occupy the physical space of the database. The results of the materialized view

Oracle execution plan -- all_rows and first_rows (n) optimizer Mode 0. environment Creation [sql] SQL> create usertest identified by test 2 default tablespace users 3 temporary tablespace temp 4 quota unlimited on users; User

Rman catalog configuration brief note Server Configuration: [sql] SQL> create tablespace tbs_rman datafile 'H:\oradata\test\tbs_rman.dbf' size 20m autoextend on; Tablespace created SQL> create user rman identified by oracle default

Oracle SQL advanced programming learning notes (I) Core SQL statement 1, select statement execution sequence 5 SELECT 1 FROM 1.1 FROM JOIN ON 2 WHERE 3 GROUP BY 4 HAVING 5 ORDER BY  (1) first

USING Auotomatic Shared Memory Management has learned about amm some time ago. Today I want to learn about ASMM. When asmm is started, it is very simple to set the sga_target parameter. If asmm is set, the sga, such as buffer cache, large pool, java

Temporary tablespace groups in oracle are in a temporary tablespace group. You can define many temporary table spaces. A temporary tablespace group contains at least one temporary tablespace, but does not contain the maximum number of temporary

ORA-01555 Principle Analysis SQL> create undo tablespace undotbs1 datafile '/opt/app/oracle/RHYS/undotbs1.dbf' size 30 M; Tablespace created. SQL> alter system set undo_tablespace = undotbs1; System altered. SQL> select. usn,. status, B. name from v