NAV: SLTechnology News&Howtos > Database >

• 

  Risk warning 11g easy to ignore import performance issues

  In the preface, a set of key system of a large state-owned bank is upgraded from 10g to 11g, and Lao K is responsible for the operation guarantee on the first morning after the upgrade; Party A customers have done various tests before the upgrade to ensure that there will not be any performance problems after the upgrade. However, things went against one's wishes. Lao K just arrived at the scene, and the customer application group

  2022-06-01 10:11:51 Views: 265
• 

  Log corruption encountered while backing up transaction log

  Fault description: the following error Backup detected log corruption in database FakeDBName was encountered while backing up the transaction log. Context is FirstSector. Log

  2022-06-01 10:11:51 Views: 291
• 

  Construction of RAC by Oracle 11gR2 (2)-- configuring shared Storage

  Oracle 11gR2 to build RAC (2)-- configure shared storage system environment: operating system: RedHat EL5Cluster: Oracle GI (Grid Infrastructure) Oracle: Orac

  2022-06-01 10:11:47 Views: 249
• 

  Analysis function of oracle rookie learning-ranking

  Analysis function of oracle rookie learning-sort sort function 1.row_number: returns a continuous sort, regardless of whether the values are equal or not 2.rank: have equality worth sorting the same, order values then jump 3.dense_rank: sort with equality worth sorting phase

  2022-06-01 10:11:47 Views: 281
• 

  Processing in the case of too much SYSAUX table space (too much AWR information)

  What is the difference between the contents stored in SYSTEM and SYSAUX tablespaces? What should I do if the SYSAUX table space is too large? Answer: in general, business data generated by an enterprise should be stored in a separate data table space, rather than using tables that already exist in the system

  2022-06-01 10:11:47 Views: 283
• 

  Lie architect's NOSQL and caching

  NOSQL mainstream are Redis, mongodb, memcached content is being edited and added, please wait patiently, recently is replenishing all aspects of architect skills

  2022-06-01 10:11:47 Views: 270
• 

  Use spool output csv format to view system tablespace usage

  SET SPOOL ON pre off entmap offSET ECHO OFFSET TRIMOUT OFFset feedback offset heading onset colsep

  2022-06-01 10:11:40 Views: 228
• 

  A few small commands that 12C DG DGMGRL must remember

  [root@roidb01] # su-oracleLast login: Thu Nov 23 20:32:31 CST 2017 on pts/1$ dgmgrl / DGMGRL for Li

  2022-06-01 10:11:40 Views: 298
• 

  Postgresql varchar field regexp_replace regular replacement

  1. Replace target 1) .contact field type varchar. 2)。 Remove two consecutive fields with different numbers after each equal sign, effective_caller_id_name=051066824513,effectiv

  2022-06-01 10:11:10 Views: 207
• 

  Oracle system

  Today, when you understand the architecture of Oracle, the whole system can be explained by a picture, or you can compare it to a football team. Users who want to access the database have to access the database through a service process. At the front are shared pools, database buffers, caches and redo log buffers, as well as j

  2022-06-01 10:11:10 Views: 273
• 

  Update the HANA component version through hdblcm

  1. First download the latest update package IMDB_SERVER100_122_4-10009569.SAR2 on support.sap.com. SAPCAR-xvf IMDB_SERVER100_122_4-10

  2022-06-01 10:11:10 Views: 220
• 

  Problems with installing oracle10g in Linux 6 and above

  Welcome to my < >: http://edu.51cto.com/lecturer/index/user_id-1850277.htmlLinux 6 and above are not oracle 10g certified versions, compared to

  2022-06-01 10:11:09 Views: 262
• 

  Package Management in Go language

  What is a package in the Go language? we are using other languages, such as Java, which have the concept of package. It is a concept in the Java language to organize our Java files, such as the java.lang package, which contains many commonly used classes, such as

  2022-06-01 10:11:09 Views: 213
• 

  Remote link to database with tools Times-1045 access denied error

  Today I tried to use the Navicat tool to remotely link to MySQL Times 1045 error! The error message is as follows: 1045 access denied for user 'root'@192.168.0.101' because the database forbids remote

  2022-06-01 10:11:09 Views: 221
• 

  Order of single table query

  Select sex, count (Sex) as count from tch_teacher where id > 15 group by Sex having count > 5 order b

  2022-06-01 10:11:09 Views: 259
• 

  The design of SQLServer table (building table)

  Knowledge part 1, SQLServer data type data type is an attribute of data, used to define that the data is time, numbers, strings (text, letters), etc. SQLServer provides a set of system data types that define the set that can be used with SQLServer

  2022-06-01 10:10:38 Views: 235
• 

  Mongodb authentication login

  Mongodb authentication login Start MongoDB without access control.mongod-- port 27017-- dbpath / data/db1Connect to th

  2022-06-01 10:10:38 Views: 267
• 

  Backup and restore messages (01)

  This lab requires an AD server and a mail server. How long will the mail server join the domain to retain deleted items? The exchange mailbox database provides a retention period for messages that have been soft deleted, during which users can recover deleted items without requesting an administrator.

  2022-06-01 10:10:08 Views: 286
• 

  Connection 12cR2 PDB error ORA-28040/ORA-01017

  The test environment installed a set of 12cR2 database, tried to connect to the database through PL/SQL developer, but reported an error ORA-28040: No matching authentication protocol checked on the Internet

  2022-06-01 10:10:02 Views: 234
• 

  12c ADG cannot delete standby archive RMAN-08137

  First, the environment description 12c has changed a lot. At present, more and more systems are online, and we need to constantly update our knowledge base. On: 12.1.0.2 version, RAC can't delete archivelog ERROR-

  2022-06-01 10:09:59 Views: 275