The Reset log option is used for the first time when the database is opened after the following situations:
Not fully restored
Recovery based on backup control files
CREATE Controlfile ... Resetlogs
The primary role of the reset log is to
The case of PL/SQL programming specification
As in SQL, Pl/sql is case-insensitive. Its general guidelines are as follows:
Keywords (BEGIN, EXCEPTION, end, IF THEN else,loop, End LOOP), data type (VARCHAR2, number), internal functions (least,
Oracleenterprisemanager (Oracle Enterprise Manager, abbreviation OEM) provides management services for managing distributed environments through a set of Oracle programs. OEMs include a set of DBA tools, a repository, and a graphical display of the
An index is a list of keywords for several data rows that, when queried for data, can be quickly positioned through the keywords in the index to the block of data to which the record is to be accessed, greatly reducing the number of I/O to the data
Summary: In a large number of business data processing projects, you can consider the use of partitioned tables to improve the performance of the application system and facilitate data management, this article describes the use of partitioned tables
oracle| Performance | execution
The cost of using the Oracle execution planning mechanism to improve query performance the time of the new SQL statement is the most important part of the Oracle SQL statement execution time. But by understanding the
oracle| Data | database | performance
Oracle database is favored by more and more enterprises because of its high reliability, security and compatibility. How to keep Oracle databases in good performance is a concern for many database administrators
Oracle
Discussion on Oracle Job (Job) Update next_date
The author of this article: Kamus (Kamus@itpub.net)
Summary: This article analyzes the mechanism for modifying the next execution time during Oracle job execution through experiments and
oracle| Download
[Oracle] Several important e-book downloads
Initial Link:
Http://www.dbanotes.net/Oracle/DB_Books_Download.htm
For Oracle technology enthusiasts for reference.
For the purpose of communication, please do not use it as a commercial
oracle| problem
Oracle Common fool question 1000 Q (ix)
Author: ccbzzp
9I-managed v$ view.
401. V$pq_tqstat
Contains statistics on parallel execution operations. Helps to measure imbalances in a query.
402. v$process
Contains information
Oracle| Experience | performance
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
oracle| Stored Procedures
Oracle Side1. Creating Oracle Process StorageCreate or Replace procedure Proce_test (paramin in Varchar2,paramout out varchar2,paraminout into out varchar2)AsVarparam VARCHAR2 (28);BeginVarparam:=paramin;paramout:=varparam|
Sql*loader is an Oracle data-loading tool that is typically used to migrate operating system files to an Oracle database. Sql*loader is a large data
The Load method that the warehouse chooses to use.
Under NT, the Sql*loader command is Sqlldr,
Look at a simple example:
Sql> CREATE TABLE T as
2 SELECT * from Dba_objects;
Table has been created.
Sql> SET Autot on
Sql> SELECT COUNT (*) from T;
COUNT (*)
----------
49611
Execution plan
------------------------------------------------
Yesterday afternoon, the implementation reported an Oracle error ora-03137said that the database in 11g no problem, upgrade to 12c, the error.Local debugging, see after executing SQL, reported exception, as follows:Execute SQL in a 12c database, no
1, first check whether DG Space is sufficientSql> select Name,total_mb,free_mb,usable_file_mb from V$asm_diskgroup;NAME TOTAL_MB FREE_MB USABLE_FILE_MB--------------------------------- ---------- ---------- --------------DATADG 4198790 230531
First, CDB backup1.1 Backup CDB onlyTo back up the CDB database only requires a user with SYSDBA or sysbackup permissions to connect to the CDB root environment, perform the backupdatabase root command to complete a backup of CDB, as follows:[[email
Oracle provides a number of powerful analytic functions that can be used to accomplish requirements that may require a stored procedure to be implemented.The analytic function calculates the aggregated values based on a set of data rows, which are
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service