NAV: SLTechnology News&Howtos > Database >

• 

  Imp-00017 ora-06550

  Fault description Database version: 11.2.0.4 tel-> 12.2.0.1 description: imp encountered exception alarm during import: fault analysis this is a very common import warning, usually related to the database / client version. For example, here, the source database is 11.2.0.4, and the target data

  2022-06-01 06:51:06 Views: 253
• 

  Check undo info

  Alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';col status format a15col description form

  2022-06-01 06:50:57 Views: 262
• 

  PPT production skills: how to make three-dimensional water droplets in PPT

  Making a three-dimensional effect in a slide can be said to raise the horizontal line of the entire slide and make the slide as a whole look brand new. How to do this operation? today, we will reveal how to make three-dimensional water droplets in the slide. Https://www.pptbest.co

  2022-06-01 06:50:57 Views: 212
• 

  How many groups of standby redo log is reasonable?

  In the case of a single machine, the number of all redo_log groups + the number of all redo log groups + instances in 1RAC environment is normal. Generally, the number of redo log groups of each instance is the same. For example, for you, the number of standbby redo log groups is (nail1).

  2022-06-01 06:50:57 Views: 291
• 

  The first experience of TiDB

  Deploying TiDB is the first lesson in front of us, in fact, there are many ways to deploy, limited to the environment, I first began to think about how to deploy the stand-alone version. In the version of Centos 6, this is still quite difficult to deploy, and there will be a lot of unknown holes. According to official advice, yes.

  2022-06-01 06:50:56 Views: 228
• 

  Oracle alarm log ora-04030

  An error occurred in out of process memory when trying to allocate of ORACLE ORA-04030 in oracle 11g. Check the official MOS of ORACLE to confirm that it is BUG.

  2022-06-01 06:50:56 Views: 262
• 

  Oracle RAC enables archiving mode

  Generally speaking, when installing a database, archiving is enabled by default, but because most of the newly created databases need to do a lot of data operations and avoid disk capacity alarm problems caused by unnecessary archiving in the early stage, archiving will be turned off when building a database. When building a database in an oracle RAC cluster, archiving will be turned off.

  2022-06-01 06:50:56 Views: 288
• 

  [TABLESPACE] how to lower the high water level of data files (BLOCK_ID)

  The http://blog.itpub.net/29487349/viewspace-2143418/ article here talks about how to shrink the tablespace, so sometimes there will be the following situation, that is, we query the tablespace has a lot of free, but execute this article

  2022-06-01 06:50:56 Views: 266
• 

  The question bank of 2018OCP has changed. 052 the latest question analysis (with answers)-34

  34, Which is true about invalid PL/SQL objects?A) They are automatically recompiled against the new d

  2022-06-01 06:50:55 Views: 271
• 

  Materialized view ingenious use _ table synchronous use of materialized view method

  After the materialized view is created, a table with the same name as the materialized view is automatically created, and two objects appear in the dba_objects, the OBJECT_TYPE is TABLE and MATERIALIZED VIEW. User_mviews 、 user

  2022-06-01 06:50:55 Views: 256
• 

  Microsoft releases public preview version of SQL Server under Linux

  Microsoft releases public preview version of SQL Server under Linux Microsoft has released a public preview version of its next version of SQL Server database, which supports both Linux and Windows. In March of this year, Microsoft released

  2022-06-01 06:50:55 Views: 335
• 

  LATCH:ROW CACHE OBJECTS fault handling

  i. Symptoms: the application of feedback from the business side is slow, we find that the database is slow, accompanied by LATCH:ROW CACHE OBJECTS waiting events, and the database CPU is too high. ii. Solution: through the following analysis is due to a large number of hard parsing during the fault period, hard parsing needs to go

  2022-06-01 06:50:50 Views: 294
• 

  Garden Planner for Mac (landscaping design software) v3.7.48 active version

  The Garden Planner mac version is a landscaping design software applied on the MacOS platform. The garden planner mac version contains more than 1200 different elements and symbols. In addition, Garden Planner supports adjustments

  2022-06-01 06:50:47 Views: 305
• 

  Configuration and use of DG broker

  Configuration method 1. The main library of DG broker added in static monitoring is (SID_DESC= (GLOBAL_DBNAME=PROD_DGMGRL) (ORACLE_HOME=/db/oracle/product).

  2022-06-01 06:50:47 Views: 245
• 

  Expdp migration test

  The following actions require operations on the database server. For remote operations, please refer to http://blog.itpub.net/24486203/viewspace-2132814/1. The source library creates a directory directory sqlplus

  2022-06-01 06:50:46 Views: 252
• 

  One of the new features of 11gR2: Adaptive Cursor Sharing (ACS)

  One of the new features of 11gR2: Adaptive Cursor Sharing (ACS) http://www.killdb.com/2011/06/19/11gr2-%e6%96%b0%e7%89%b9%e

  2022-06-01 06:50:46 Views: 256
• 

  View merging for Oracle 12CR2 query transformation

  The test database version here is 12.2.0.1, and in the view merge, the optimizer represents the query block of the view into the query block that contains the view. View merging improves performance by letting the optimizer consider additional join order, access methods, and other transformations. For example, after a view is merged and in a

  2022-06-01 06:50:46 Views: 311
• 

  Return data to a mysql server of saltstack

  This article is based on the official website and some materials on the Internet. Most of them are on the official website. First of all, you need to install the mysql database. I have installed a branch of the mysql database called the MariaDB database, so I will use the ready-made one. I heard that the operation is the same as that of mysql. actually

  2022-06-01 06:50:46 Views: 216
• 

  HPC China 2018 came to a successful conclusion, China's supercomputing TOP100 came out!

  [IT168 Information] October 18-20, 2018 National High performance Computing academic Conference (HPC China 2018) was solemnly held in Shandong Qingdao International Convention and Exhibition Center. The theme of this conference is "everything can be calculated in HPC+" by the Chinese computer Society (CC).

  2022-06-01 06:50:34 Views: 259
• 

  MySQL locates the SQL executed by the unsubmitted transaction through performance_schema

  We often encounter such a scenario: the business side thinks that the database is "very slow". Through show processlist inspection, we find that a large number of State are waiting for lock, such as Waiting for table metadata/level.

  2022-06-01 06:50:32 Views: 269