NAV: SLTechnology News&Howtos > Database >

• 

  MongoDB server JavaScript script

  MongoDB server-side JavaScript scripts often use JavaScript statements db.getSiblingDB () db.getCollectionNames () db.getCollection (

  2022-06-01 15:50:16 Views: 290
• 

  Use oradebug in sqlplus to locate the trace file generated by the alter session 10046 event

  [root@HXZG ~] # su-oracle [oracle@HXZG ~] $sqlplus / as sysdbaSQL > select * from viciversionBannery-

  2022-06-01 15:50:16 Views: 244
• 

  Redhat6 + 11G RAC dual-node deployment

  1. Configure the network environment node1 [root@node1 ~] # vi/etc/sysconfig/networkNETWORKING=yesNETWORKING_IPV6=noHOSTNAME= Node1 [r

  2022-06-01 15:50:16 Views: 297
• 

  MyBatis series: (5) dynamic SQL

  1. The query condition of dynamic SQL operation is uncertain, and SQL syntax needs to be generated according to the situation. This situation is called dynamic SQL select emp_id,emp_name,emp_sal from emp.

  2022-06-01 15:50:03 Views: 208
• 

  Using python to generate oracle data report

  #! / usr/bin/env python#coding:utf-8# cx_Oracle is used to access oracle and export data import cx_Oracle# xlsxwriter to generate xlsx files

  2022-06-01 15:50:03 Views: 296
• 

  Talking about ORACLE AWR single instance I

  AWR in Oracle, full name is Automatic Workload Repository, automatic load information base. AWR is one of the important tools for DBA to understand its running status. According to the AWR report, you can have an overall understanding of the performance of oracle database.

  2022-06-01 15:50:03 Views: 274
• 

  MongoDB (1): installation, configuration and introduction

  one。 MongoDB, a non-relational database (NoSql), is a powerful, flexible and scalable way of data storage, because MongoDB is a document model with high freedom and flexibility, which can make you smooth in the development process. For large data volume, high concurrency and weak transactions

  2022-06-01 15:50:02 Views: 240
• 

  Solution to the problem of exporting empty tables with exp in oracle 11g

  A new feature in ORACLE 11G is that when the table has no data, segment is not allocated to save space. Alter system set deferred_segment_creation=false; this parameter defaults to TR

  2022-06-01 15:50:02 Views: 226
• 

  OCP-1Z0-05162 personal understanding

  1. Original title View the Exhibit and examine the structure of the CUSTOMERS table.You want to generate a report

  2022-06-01 15:50:02 Views: 286
• 

  MySQL data type

  Defining the type of data field in the MySQL data type MySQL is very important for optimizing your database. MySQL supports many types, which can be roughly divided into three types: numeric, date / time, and string (character) types. The numeric type MySQL supports all standard SQL values

  2022-06-01 15:50:01 Views: 281
• 

  Ubuntu16.04 installs the specified version of Mysql (5.5 to 5.6)

  Ubuntu upgraded to 16.04. directly executing apt-get install mysql will install 5.7. unfortunately, the APP developed under 5.7 cannot be started, but it needs to be downgraded. The methods you have tried are as follows: 1. Refer to the official website downgradi

  2022-06-01 15:49:51 Views: 204
• 

  It takes only 3 simple steps to reformat the entire database in a single operation!

  SQL Compare is a tool for comparing and synchronizing SQL Server database structures. More than 150000 database administrators, developers, and testers now use it. When testing the local database, temporarily storing or activating the database of the remote server, SQL

  2022-06-01 15:49:51 Views: 237
• 

  On Ubuntu-16.04 deployment OpenStack Ocata< & gt

  Note: this article is deployed according to the official document of openstack, address https://docs.openstack.org/. Obviously only 100000 characters, insist that more than 200000, no way, divided into parts. Suggestion: check carefully when configuring. After many experiments, many mistakes are matching.

  2022-06-01 15:49:50 Views: 247
• 

  Remember the solution to the problem that MongoDB CPU soared to 99%

  The company adjusted its business and transferred part of the data from Redis to MongoDB. The business was normal in the test environment. After the production environment was launched, it was found that as soon as the pressure came up, MongoDB's service directly filled CPU. I analyzed it with the development students and referred to similar problems on Baidu.

  2022-06-01 15:49:50 Views: 222
• 

  Using URLOS to install SQL Server 201 in CentOS

  How does CentOS install SQL Server 2017? You can find a large number of installation tutorials on the Internet, and after some trouble, you can also successfully install sqlserver in CentOS, but it may step on a lot of inexplicable holes and waste your treasure.

  2022-06-01 15:49:34 Views: 271
• 

  Zabbix topic: chapter 2 detailed explanation of zabbix3.0 installation

  Zabbix3.0 installation details this program outline installation configuration mariadb installation server-side zabbix web configuration web page initialization change to Chinese garbled problem zabbix topic: chapter 2 zabbix3.2 installation details zabbix specialized

  2022-06-01 15:49:04 Views: 204
• 

  Oracle 11g database migration

  Due to problems such as server replacement or hard disk damage, in some scenarios, we need to migrate the database. Oracle database can be backed up in a variety of ways. If downtime is possible, it is recommended to use cold backup to migrate data files directly, which will be more efficient. Since both hosts

  2022-06-01 15:49:02 Views: 242
• 

  What is the path to redis's log?

  What is the path to redis's log? Perhaps many people do not understand, in order to let you understand better, the editor summed up the following content, I hope you can gain something according to this article. Redis does not generate log files by default, so you need to configure the configuration method: 1

  2022-06-01 15:49:02 Views: 254
• 

  Mongostat detailed explanation

  Reference: http://docs.mongodb.org/manual/reference/program/mongostat/Fieldsmongostat outputs the following

  2022-06-01 15:48:59 Views: 223
• 

  Configure mysql database master-slave replication

  1. The principle explains that replication has the following three steps: (a) the master server records data changes in the binary log. (this is called a binary log event (binary log events). ) (b) copy the binary log events of the master server from the server to its own relay day

  2022-06-01 15:48:29 Views: 256