NAV: SLTechnology News&Howtos > Database >

• 

  Oracle Data Guard Feature 12cR2 Series (2)

  The previous article introduced three features in Data Guard 12cR2, and this article will continue to introduce some of the new features. | | Using DBCA to Create a Data Guard Standby creates a physical repository before 12c |

  2022-06-01 06:37:54 Views: 301
• 

  Redis-- most people don't know the shit about cache breakdown and cache setting order.

  First, about the cache setting order: cache is often used in web design, and we all know that setting cache can improve the response speed of the system. When doing this cache, I do not know why, many people's process is: when reading data, read the number from the cache first.

  2022-06-01 06:37:54 Views: 233
• 

  Detailed explanation of redis configuration file

  Bind 0.0.0.0 # binds the redis server network card IP. The default is 127.0.0.1, that is, the local loopback address. In this way, access to the redis service can only be through a local client connection, not through a remote connection. If the bind option is empty

  2022-06-01 06:37:53 Views: 211
• 

  Installation and configuration of PowerDesigner connecting to Oracle database

  PowerDesigner installation and configuration connection Oracle database through unremitting efforts finally powerdesigner successfully connected to the database, in the middle also encountered some problems, I hope to discuss with you, no more nonsense, here comes the main topic. one

  2022-06-01 06:37:49 Views: 213
• 

  2011-11-29 11G New function: PL/SCOPE

  Http://www.itpub.net/thread-1499223-20-1.html197 Building I opened PL/Scope in the current session: ALTER SESSION SET plscope_setting

  2022-06-01 06:37:49 Views: 202
• 

  The relation and difference of v$sql, v$sqlarea, v$sqltext and v$sql_plan in Oracle9i

  For the same SQL statement, if different optimizer goals are used in different environments, there will be different execution plans, which requires a separate cursor (that is, subcursors) to distinguish the different running behavior in each case. [@ more@] Oracle uses

  2022-06-01 06:37:48 Views: 258
• 

  Several simple examples of conditional statement and Loop statement in DM7

  Recently, I had an initial contact with the Dameng database (DM7), and the syntax of SQL is very similar to that of oracle. -- if statement: if elsif else and ifDeclarep_int int;Beginp_int: = 1bot if p

  2022-06-01 06:37:48 Views: 256
• 

  Db how to roll back and recover quickly, the god skill of DBA!

  [author: 58 Shen Jian, this article comes from the official Wechat account of architect's Road, please contact the original author for reprint and authorization] if technicians often operate DB online and walk along the river for a long time, there will inevitably be mistakes: what should I do if I have the wrong data in update, wrong data in delete and wrong data in drop? Looking for DB

  2022-06-01 06:37:44 Views: 269
• 

  ORACLE ORA-03137 error handling

  Background: when the company's OA system is running today, user feedback sometimes shows that it can not be logged on to the OA platform. The OA administrator checked and found that there was no problem with the application, but he sometimes reported an error when connecting to the database; sure enough, he logged in to the OEM cloudcontrol

  2022-06-01 06:37:42 Views: 242
• 

  Redo log management

  The larger the file operated by the computer, the lower the efficiency of the system, so the log file should be as small as possible, but too small will cause the log file to switch frequently, trigger a complete checkpoint, and cause the system to suspend the so-called redo log maintenance or repair, which is to delete the problematic redo log group or log member.

  2022-06-01 06:37:39 Views: 209
• 

  A large number of mongodb slow queries caused by a cp command

  Problem encountered: an alarm was received in the early morning, and the cpu load of a mongodb server exceeded 8. As it did not affect the business, we began to investigate the cause the next morning. Find out the reason: 1. First learn about the applications on the server. The main application of the db server is only mongodb. So open it.

  2022-06-01 06:37:32 Views: 216
• 

  Implementation of paging query in hbase

  Hbase itself is not paged query, I found a lot of information on the Internet to achieve a paging function, here to make a record, share with you, if there are any deficiencies, please feel free to point out. Don't talk much nonsense, look at the code. Import java.io.IOExcepti

  2022-06-01 06:37:31 Views: 217
• 

  Steps to install MySQL5.6.39 on CentOS6.5

  1. Extract the installation file 1.1 extract tar-zxvf mysql-5.6.39-linux-glibc2.12-x86_64.tar.gz1.2 rename mysql-5.6.39-linux-glibc2.1

  2022-06-01 06:37:31 Views: 278
• 

  Mongodb slow query analysis

  1. Use the slow query log (system.profile) to find the statement that exceeds 500ms mongos > db.setProfilingLevel (1500) 2. Then use .explain () to analyze the number of lines affected and why it exceeded

  2022-06-01 06:37:31 Views: 242
• 

  Oracle11g- port links, multiple log files, backup archives

  Oracle net protocol remote connection oracle net configuration network port method netca graphical listening file is used to modify the port using dbca graphical interface. Or select a port when creating a new one. When using graphics, root should give xhost +

  2022-06-01 06:37:27 Views: 227
• 

  Are you ready for the selection of domestic database?

  Are you really ready for database selection? Eygle once mentioned in the sharing, one master, one standby, a mainstream commercial database, an open source or domestic database, which he thinks is a more reasonable configuration. But when we choose the type, have we really done enough research preparation? For the mainstream of tradition

  2022-06-01 06:37:25 Views: 289
• 

  Redhat 6.5 mysql upgrade 5.5.48 implementation outline from mysql 5.6.32 to mysql 5.7.16

  1mysql os versionredhat 6.52, old version mysql 5.5.48 create test database and test table mysql > create database zxy;Query OK, 1 row affecte

  2022-06-01 06:37:24 Views: 249
• 

  [MongoDB Learning Notes 8] in-depth MongoDB update (update) operation: modifier $set

  The document in MongoDB is updated by the update method after it is stored in the database. The update method has two parameters. For example, update (args1,args2) args1 refers to the condition for querying the document, and args2 refers to what to do with the queried document.

  2022-06-01 06:37:18 Views: 204
• 

  RDS MySQL 5.73Node Enterprise Edition blockbuster release

  More than 15:00 on October 23, more than experts jointly explained that with the gradual popularization of cloud computing technology, the boundaries of customer industries and scenarios that use cloud services are constantly being broadened and new requirements are constantly put forward. Under the leadership of the Internet industry, which was the first to try cloud computing, finance, insurance and other industries began to embrace the cloud.

  2022-06-01 06:37:18 Views: 202
• 

  How to use dictation to type speech to text on Mac

  Typing is not for everyone. If your fingers are clumsy or difficult to spell, typing may be the least favorite part of your computer. Fortunately, you can use the built-in dictation software on Mac to say what you want to type. Https://www.macz.com/news

  2022-06-01 06:37:13 Views: 205