NAV: SLTechnology News&Howtos > Database >

• 

  Oracle AWR reports automatically generate and send mailbox Python scripts every day

  Reproduced from: http://blog.csdn.net/tianlesoftware/article/details/6319198Oracle 's AWR report provides good information about DB performance. So DBA

  2022-06-01 11:57:45 Views: 222
• 

  Oracle 10g add and delete log groups

  During the daily inspection, it was found that there was this error in the alert log Thread 1 cannot allocate new log, sequence 319708Checkpoint not complete actually

  2022-06-01 11:57:45 Views: 211
• 

  Install vCSA

  Learn about vCSA before installation. To put it simply, vCSA is a host that centrally manages esxi hosts in the enterprise. This is too unprofessional. Here are some materials I found on the Internet, describing the characteristics, advantages and disadvantages of vCenter Server and vCSA. Let's take a look.

  2022-06-01 11:57:45 Views: 228
• 

  Oracle delete operations hide secrets that you may not know.

  One phenomenon describes that Delete is a common operation in oracle database, especially in automated testing, initialization environment and pre-preparation are inevitable to add and delete operations, but after a period of time, you may encounter errors such as insufficient table space, which can not help but wonder.

  2022-06-01 11:57:27 Views: 259
• 

  Bad block processing occurs in Oracle index

  SQL > create table test as select * from dba_objects where rownum < 1001bot Table created.SQL > create inde

  2022-06-01 11:57:27 Views: 232
• 

  Realization of automatic backup and manual backup of database

  Front-end code: function createBackUp () {var path=$ ("# path") .val (); $.post ("dataBack", {'path': path}, function (d)

  2022-06-01 11:57:26 Views: 238
• 

  Goldengate missing archive log abend processing

  Ogg extraction process abend. Check and find that the log of the repository has been deleted: 2018-10-11 11:14:52 ERROR OGG-00446 Could not find archived log for sequ

  2022-06-01 11:57:26 Views: 289
• 

  Oracle turns on flashback

  Check whether the database is in archive mode: SQL > show parameter db_flashback;NAME TYPE VALUE

  2022-06-01 11:57:26 Views: 267
• 

  Centos 7.4 deployment of couchbase clusters

  Couchbase is a relatively new and rapidly developing nosql database technology. In 2014, viber announced that it would replace mongodb with couchbase to adapt to 1 billion users. At present, couchbase has been widely used in production environment.

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

  How to create a database in sqlyog?

  Today I will talk to you about how to create a database in sqlyog. Maybe many people don't know much about it. In order to make you understand better, the editor summarizes the following contents for you. I hope you can get something from this article. Start apache and MySQL of xampp first

  2022-06-01 11:57:00 Views: 232
• 

  A preliminary understanding of CAP Theory

  + C (Consistency), consistency: all nodes see the same data at the same time (all nodes see the same data at the same time); also known as atomicity or transaction consistency

  2022-06-01 11:56:59 Views: 291
• 

  How many hash slots are there in redis

  How many hash slots are there in redis? Many novices are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can gain something. 16384 hashes are built into the Redis cluster

  2022-06-01 11:56:55 Views: 225
• 

  What are the implementation ways to prevent SQL injection

  Today, I will talk to you about the ways to prevent SQL injection, which may not be well understood by many people. In order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article. Introduction to SQL injection SQL injection is a common network attack

  2022-06-01 11:56:55 Views: 248
• 

  What is the publish and subscribe function of redis

  What is the publish and subscribe function of redis? In view of this problem, this article introduces the corresponding analysis and answers in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible way. Preface redis provides a simple publish and subscribe function for some appropriate scenarios

  2022-06-01 11:56:55 Views: 201
• 

  What is a deadlock in DBMS

  This article will explain in detail what is the deadlock in DBMS, the content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article. In a database, a deadlock is when two or more threads are permanently blocked (suspended), none

  2022-06-01 11:56:55 Views: 272
• 

  Oracle asm disk mirroring configuration

  Sqlplus / as sysasmSQL > CREATE DISKGROUP DATA NORMAL REDUNDANCY2 FAILGROUP A1 DISK3'/ dev/data1_1' n

  2022-06-01 11:56:54 Views: 304
• 

  Cassandra user Management

  Cassandra replaces users and user groups with role. The role created by default does not have login and super permissions, but the user created by default has the permission of login (1) role # create role cassandra@cqlsh:keysp

  2022-06-01 11:56:54 Views: 202
• 

  Oracle forbids operating system authentication login

  The method of logging in the database by operating system authentication 1. The most basic method is to use "sqlplus / as sysdba" to log in to the database sqlplus / as sysdba slash "/" user name on the left and password on the right.

  2022-06-01 11:56:54 Views: 272
• 

  Modify AWR sampling interval and historical snapshot retention time

  The default sampling interval and historical snapshot retention time of 1.AWR is 7 days in 10g version and 8 days by default in 11g version. The collection interval is 1 hour. This information can be obtained from the DBA_HIST_WR_CONTROL view. Zx@ORCL > col

  2022-06-01 11:56:54 Views: 257
• 

  MySQL 5.7forgot your password.

  Modify the configuration file: [root@MySQL-S mysql] # vim / etc/my.cnf2. Add the following to the [mysqld] module. Skip-grant-tables3. Restart MySQL. [roo

  2022-06-01 11:56:54 Views: 299