ORA-01093 troubleshooting The environment is the 10.2.0.5 environment of the DG of RAC + RAC. At that time, I opened the master and slave databases and wanted to start the MRP process (Real-time application). However, the 1093 error occurred when
Reproduce the library cache lock wait event at 11 GB in Oracle From the example below, we can see that re-Compilation of objects in the production database will lead to library cache lock, so we should try to avoid compiling objects during business
Binlog Processing Method for MySQL DATA Recently, the disk has grown very fast and it is found that binlog logs occupy a large amount of disk resources. We use manual cleanup, and set Automatic cleanup later. View the specified deletion log Mysql>
How to enable and enable autotrace for Oracle tools Platform: Oracle 10g RHEL-5.8 The procedure is as follows: 1) sys @ ORCL> @ $ ORACLE_HOME/sqlplus/admin/plustrce. SQL 2) sys @ ORCL> grant plustrace to public; Description of several common
Oracle permission management: After Revoking DBA Role Oracle revoking DBA permissions: ORA-01536 After Revoking DBA Role [ID 465737.1] Applies:Oracle Server-Enterprise Edition-Version: 184.108.40.206 to 10.2.0.3This problem can occur on any
Use SPFILE to reset the configured initialization parameters to the default values of the system.Start with SPFILE. If you want to restore the initialization parameter to the default value, use a statement like this:Alter system reset db_create_file_
Oracle cross-database query replication table data distributed query, oracle Method 1: Currently, most databases require distributed queries. The following describes how to configure cross-database access in oracle. For example, there are two
Hibernate uses hql for Chinese sorting, Why does MySQL not support Chinese sorting? No way. You only need to wait for utf8_unicode_cn to come out. If you want to implement cross-database with hibernate and do not want to change the code, I will tell
Atitit. Concurrency test solution (2), atitit Solution Atitit. Concurrent Test Solution (2) ----- obtain random database records and randomly extract data for random sorting 1. Application Scenario 1 2. Principles of random data extraction 1 3.
[Oracle] deletes a node from RAC, which is a oraclerac node. Environment: OS: OEL5.6 RAC: 10.2.0.1.0 There are currently three rac1, rac2, and rac3 nodes. The following describes how to delete a rac3 node. 1. Delete the database instance on the rac3
Type conversion causes the execution plan to not go through the index test case, and the Execution Plan Index Test Environment Simulation:SQL> drop table t_col_type purge;Create table t_col_type (id varchar2 (20), col2 varchar2 (20), col3 varchar2 (2
How to "play" and "play"Today, I tried to share my story with you how to "play", the topic of today. Do you have any experience like this? Open your circle of friends and you will no longer hear from your friends, some personal pictures of friends
[Rman, 1] Typical Incremental Backup case and rman Incremental Backup caseI. Backup policy:1. sunday evening-level 0 backup completed MED (full backup) 2. monday evening-level 2 backup interval med3. Tuesday evening-level 2 backup interval med4.
ORA-01552: non-system tablespace 'xxxx 'cannot use system rollback segments, ora-01552xxxx ORA-01552: non-system tablespace 'xxxx 'cannot use system rollback segmentsFault analysis:The UNDO tablespace data file is damaged, causing the update
ON, WHERE, HAVING, wherehaving ON, WHERE, and HAVING can filter data by limiting conditions, but their usage is different. Next we will analyze the differences among the three.1. ON and WHERE All queries generate an intermediate temporary report.
Oracle Data Pump remote import file to local database, oracle import database-- Log On As A dbaC: \ Users \ Administrator> sqlplus/as sysdba-- Create a userSQL> create user bfzg0828 identified by bfzg0828 default tablespace users quotaUnlimited on
Oracle Development Series (1): Crazy errors: null value and no value (no result), too lenull Recently, I encountered some problems when I was doing development and writing operations. I found the cause for a long time and did not know it before. In
Redis and MongDB data sharing, redismongdb Refer: Http://blog.nosqlfan.com/html/3537.html redis Data Summary Http://blog.nosqlfan.com/html/3548.html mongDB Data Summary Problems with session sharing in redis How did you create a
Hbase integrates hive and sqoop to export data to mysql and hbasesqoop.Two advantages of hive integration of hbase tables: 1. import data to MYSQL.2. convert an hbase table to another hbase table. Three steps:1. Associate hive with hbase as an
PL/SQL Developer double-click table name query, pldeveloper Double-click a table. The default value is Expand/Collapse. To Expand/Collapse a table, you need to view the table data quickly. If you write select * from tab, it will be troublesome,