How to delete historical data generated by statspack

How to delete historical data generated by statspack When $ Oracle_HOME/rdbms/admin/spauto is used. after SQL creates a default job, snapshots are collected every hour in the database, so that you can use $ ORACLE_HOME/rdbms/admin/spreport at any

Oracle EM 12C monitoring MySQL

Oracle EM 12C monitoring MySQL [Preface] Oracle EM 12C itself does not provide MySQL monitoring. The plug-in can be used to monitor the database on EM 12C. Pythian Group developed the corresponding plug-ins, by installing this plug-in, you can

About the entries parameter of the orapwd command

About the entries parameter of the orapwd command When I read the Oracle official document Administrator's Guide this morning, in the password file section, the entries PARAMETERS OF THE orapwd command are described as follows: This argument

The database reports an ORA-01839 Error

The database reports an ORA-01839 Error The ZCGL database reports that the date of the month specified by the ORA-01839 is invalid when running the SQL statement The detailed SQL statement is simplified as follows: Select * From table_name

Oracle deletes records in a table in batches

Oracle deletes records in a table in batches When Oracle deletes a large number of records in a table in batches, batch deletion is often used and is submitted one by one for three reasons:1. Avoid the impact on select of other transactionsIf other

RMAN-06061 WARNING skipping archivelog compromises

RMAN-06061 WARNING skipping archivelog compromises -- RMAN-06061 Processing-- During routine database backup check, the backup status of a database is completed with errors.-- So I went to the operating system to check and found the following alarms

Obtain SQL statement execution plans from the most authoritative Oracle Database

Obtain SQL statement execution plans from the most authoritative Oracle Database This document is compiled and summarized based on relevant information. It mainly describes the most authoritative and correct methods and steps for obtaining SQL

ORA-00031-mark the session to terminate and kill the process at the OS level

ORA-00031-mark the session to terminate and kill the process at the OS level Reporting when killing a processORA-00031-mark the session to terminateHowever, viewing the v $ session view still exists, but the status is changed to killed and is not

Common RMAN parameter settings

Common RMAN parameter settings View All RMAN configurationsRMAN> show all; RMAN configuration parameters for database with db_unique_name Oracle007 are:Configure retention policy to recovery window of 7 DAYS; ------ backup files are saved for 7 DAYS

Expdp encountered a ORA-39126 Error

Expdp encountered a ORA-39126 Error Problem description:The Oracle database is RAC of 11.2.0.4 and expdp is performed on one of the nodes. the following error is returned: Estimate in progress using BLOCKS method...ORA-39126: Worker unexpected fatal

Functions of standby redo log

Functions of standby redo log We all know that dataguard has three data protection modes: maximum protection mode, maximum available mode, and maximum performance mode.In the maximum protection mode, standby redo log must be used in the highest

Oracle filling tables with random data

Oracle filling tables with random data A script from AskTom can also fill in random data for a table. Create or replaceProcedure gen_data (p_tname in varchar2, p_records in number)-- This routine is designed to be installed ONCE pre database, hence--

Oracle Data Dictionary

Oracle Data Dictionary Oracle uses data dictionaries to manage and display database information. data dictionaries usually store database metadata, which is the "Database" of databases ". Generally, a data dictionary consists of four parts: an

ORA-03137: TTC protocol internal error: [12333]

ORA-03137: TTC protocol internal error: [12333] [1] problem Background: The Oracle database version is 11.2.0.1, and the operating system is CentOS release 5.9. The detailed error message is as follows: Dump

Reset the startup time after the GoldenGate process is disconnected.

Reset the startup time after the GoldenGate process is disconnected. After the system is restarted, the operator does not restart the goldengate process, resulting in the disconnection of the replication link.In addition, some archiving logs have

OS block size and Oracle block size to find the OS Blocksize

OS block size and Oracle block size to find the OS Blocksize I have read similar articles, most of which are about the blocksize of the file system. I don't know if it is related to the Oracle block size. I tried to find that, even if it is a file

Use Oracle PROFILE to control session idle time

Use Oracle PROFILE to control session idle time The following is an example of how the customer wants to control the idle time of a session.Microsoft Windows [version 6.1.7601]Copyright (c) 2009 Microsoft Corporation. All rights reserved. C: \ Users

Specific SQL processing procedures in Oracle

Specific SQL processing procedures in Oracle Shows the general phases of SQL processing in Oracle: parsing, optimization, generation of row sources and execution. The database may ignore some steps, depending on the specific statements. 1. SQL

Flash back archive (11G new feature) Stay away from ORA-01555 errors

Flash back archive (11G new feature) Stay away from ORA-01555 errors 1.1.1.1 flash back Archiving The previous flash back is implemented based on undo flash back, because our flash back is not sure of time, so it will lead to ORA-01555 (snapshot is

ORA-02050 transaction processing xxx has been rolled back, some remote databases may have problems

ORA-02050 transaction processing xxx has been rolled back, some remote databases may have problems -- Database check found a database today reported a ORA-02050 error:ORA-02050: transactions 35.28.256948 have been rolled back and some remote

Total Pages: 1013 1 .... 182 183 184 185 186 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

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.