NAV: SLTechnology News&Howtos > Database >

• 

  Eliminate the alarm of password login

  Welcome to the MySQL 8.0 must-know course series. MySQL8.0 must know must-automatic deployment of https://edu.51cto.com/course/16368.html MySQL8.0 must know must know parameters standardized configuration

  2022-06-01 10:28:10 Views: 239
• 

  How to view the current session information of oracle

  How to view the current session information of oracle? how to check the current number of connections in Oracle? You just need to query it with the following SQL statement. # View the connection select * from v$session where that is not currently empty

  2022-06-01 10:28:10 Views: 233
• 

  / the process caused by limits.conf Oracle bug is not enough

  Today, when I checked SMIDB, I found a lot of errors in the alarm log of CRS, specifically: 2015-08-19 17-14-12-21-745: [/ oracle/app/11.2.0/grid_1/bin/oraagent.

  2022-06-01 10:27:58 Views: 241
• 

  Nine basic sql statements you need to know for testing

  1. To test, you need to learn simple and basic sql statement selection: select from table1 where range insertion: insert into table1 (field1,field2) values (value1)

  2022-06-01 10:27:43 Views: 202
• 

  Multi-instance practice of zabbix Monitoring MySQL

  1. Practical background: multiple MySQL instances are deployed on a machine, each using a different port, which needs to be monitored through zabbix. Second, the practice method and the principle explanation: 1. Create a template to monitor the use of the MySQL database on Zabbix and import a case

  2022-06-01 10:27:43 Views: 220
• 

  What is Docker Volume?

  Summary: Docker Volume, usually translated into data volumes, is used to hold persistent data. When we run a database such as MySQL in a Docker container, we generally save the data on the host through Docker Volume, so that even if MyS is deleted

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

  Modify the password of the mysql database in XAMPP

  Modify the password of MySQL database in XAMPP XAMPP is only for developers and cannot be used in production environment. First of all, the MySQL administrator (root) has not set a password, and users can directly access the mysql server through phpmyadmin and modify the database

  2022-06-01 10:27:27 Views: 291
• 

  The basis of Oracle_sql Optimization-- Optimizer Summary

  The basis of the optimizer: 1. The optimizer in Oracle: the optimizer is a core subsystem built into the Oracle database. The purpose of the optimizer is to get the most efficient execution path of the target sql in the current situation according to certain judgment principles, that is to say, to get the goal.

  2022-06-01 10:27:20 Views: 212
• 

  SQL_ID 1 of oracle

  In Oralce, a sql statement generates a lot of information when it is executed: SQL uniquely identifies SQL text information, binding variable information, execution plan and cursor information, statistics, performance information and other information. For example, sql source, status, etc. SQL_ID in Oracle, SQL optimization

  2022-06-01 10:27:20 Views: 243
• 

  The Win10 system environment cannot start MongoDB on the local computer, error generation

  An error occurred when starting MongoBD, prompting: "window can no longer start MongoDB on the local computer. For more information, check the system event log. If not a Microsoft service, contact the service vendor and refer to the specific service error code 100." Solve

  2022-06-01 10:27:20 Views: 233
• 

  Centos6.5 install oracle 11G

  1. Installation environment: linux server: centos6.5 oracle version: 11g R22. System requirements: the system requires that the physical memory swap space in which the memory must be higher than 1G is generally twice the amount of memory. For example, 1G of memory can be set to swap partition.

  2022-06-01 10:27:16 Views: 228
• 

  Simple configuration of samba service and vsftp service and nfs service

  1. Establish a samba share with a shared directory of / data, which requires: (describe the complete process) 1) the shared name is shared, and the workgroup is magedu;2) add group develop, add users gentoo,centos and ubuntu, where g

  2022-06-01 10:27:10 Views: 261
• 

  SQL Server 2017 AlwaysOn AG automatic initialization (XII)

  When not to use automatic seed settings in some cases, automatic seed settings may not be the best choice to initialize a secondary copy. During automatic seed setup, SQL Server performs backups over the network for initialization. If the database is very large or the secondary copy is a remote copy, this

  2022-06-01 10:27:10 Views: 298
• 

  ORACLE database recursively queries the parent and child nodes of the current node (tree)

  ORACLE database recursively queries all children's data of the current data (excluding their own) SELECT id AS id, parent_id AS parentId, parent_id AS parent, na

  2022-06-01 10:27:09 Views: 274
• 

  Oracle 11g for redhat 64

  Environment: (1) Linux localhost.localdomain 2.6.32-358.el6.x86_64 # 1 SMP Tue Jan 29 11:47:41 EST 2013 x86x64

  2022-06-01 10:26:59 Views: 213
• 

  About Citrix Vmware Symantec Oracle and other software door-to-door implementation service instructions

  We provide nationwide implementation of Citrxi Vmware Symantec Oracle and other software projects, the specific contents are as follows: Citrix XenDeskTop XenApp PVS NetScaler CloudBri

  2022-06-01 10:26:58 Views: 296
• 

  Msyql master-slave replication Last_IO_Errno: 1042

  Error when executing show slave status\ G on slave server: Seconds_Behind_Master: NULLMaster_SSL_Verify_Server_Cert: NoLa

  2022-06-01 10:26:58 Views: 219
• 

  Several modes of oracle start-up and shutdown

  During the process of starting nomount in nomount phase oracle, he will load the parameter file (spfiledid.ora spfile.ora initsid.ora and then allocate memory according to the parameters will open the alert file to write the log) > s

  2022-06-01 10:26:58 Views: 215
• 

  Several points that should be paid attention to in the development of oracle summarized by myself.

  1. Table association problems are best not associated with more than three table examples: salary table a provident fund form b medical insurance form c if there is employee number 12365 in salary table a, but there is no 12365 data in table b if the association condition is a. Work number = b. The work number (+) will make an error and turn off

  2022-06-01 10:26:58 Views: 280
• 

  Introduction to platform integer type and progress bar editing type

  Fields with integer data type and edit type as progress bar: automatically generate the corresponding progress bar database settings by entering numbers: field properties: property settings: display percentage, display numerical value sample effect: property setting: maximum value, minimum value example effect: original address: http://bbs

  2022-06-01 10:26:56 Views: 246