NAV: SLTechnology News&Howtos > Database >

• 

  Platform business data access control

  1. Concept introduction Business data permission control refers to the business table in platform project management, which controls data display in the form of variables such as personnel ID and department ID. As shown in the following figure: figure 1, you can only view your own registered data; figure 2, you can view the data of the entire department; figure 3, you can view

  2022-06-01 09:03:33 Views: 296
• 

  Zabbix server

  How to build zabbix:1. First of all, the environment needed by zabbi zabbix requires the lnmp environment, so the installation and configuration of the lnmp environment are not introduced in detail here. If you do not know how to build this quickly, you can refer to the following article: NGINX installation: http

  2022-06-01 09:03:32 Views: 216
• 

  12C uses global_name for targeted import and export

  Usually, when many people export a certain part of data under pdb, they use service_name custom tns to locate and connect to a certain pdb, while 12C connection pdb has the following methods, which can be much more convenient: alter session set conta

  2022-06-01 09:03:32 Views: 239
• 

  When Case:MySQL uses left join, rewriting or to union can improve efficiency.

  (1) before optimization: when or is used, the SQL execution time 1.47smysql > select e.emproomnoree.firstroomnametemparentiond.deptabilnored.fromdated date d.towritten date from

  2022-06-01 09:03:32 Views: 230
• 

  A case study of system memory exhaustion

  Recently encountered a problem that the RAC node hang caused the node to be restarted. Finally, after analysis, it is found that after a period of time, the system memory will be exhausted, the original 256g of memory, and finally only a few hundred megabytes. 1. As you can see from the TOP output during the problem period, there is only 7 GB of memory left, while

  2022-06-01 09:03:23 Views: 274
• 

  Oracle 11.2.0.3 set up the startup script to enable ORACLE to start automatically

  After installation under Linux, you have to start the corresponding service each time with the following command: startup service dbstart startup monitor lsnrctl start startup console emctl start dbconsole this article uses Red Hat En

  2022-06-01 09:03:22 Views: 241
• 

  My database OCP

  The function of monitoring is to establish a data connection between the client computer and the central database computer. Once the connection is established, it will not affect the two, and the user on the client on the connection can do any operation and query, even if the monitor has been turned off or broken, but the new remote connection can no longer be connected after it is stopped.

  2022-06-01 09:03:22 Views: 254
• 

  Detailed tutorial of installing Oracle 11g based on RHEL 6.5 (8) & mdash;—OVF template making

  8 OVF template making 8.1 system cleanup and initialization [root@oracle ~] # cd / temp [root@oracle temp] # lsdatabase lost+foundlinux.x64_11g

  2022-06-01 09:03:10 Views: 275
• 

  Oracle data file recover recovery process

  First of all, query the status of the data file select name,status,file# from vault datafileposition 2. Close the database and stop listening to shutdown immediate;3. Open the database startup4. Put r

  2022-06-01 09:03:10 Views: 229
• 

  Install oracle11g under centos6.5

  Installation environment: operating system: database system: # du-sh database/ View database folder size # sysctl-a | grep sem modifies kernel parameters # sysctl-p installation steps: 1. Configure local YUM

  2022-06-01 09:03:09 Views: 208
• 

  Develop your own framework-- (2) encapsulation of database tool classes

  In order to separate the content of the framework from the data, we encapsulate the commonly used classes into a utility class, and when these methods are used, the encapsulated class is called, which can greatly improve the reusability of the code. First of all, encapsulate the database-related operations, in order to standardize the encapsulation, we create an interface to let the number

  2022-06-01 09:03:09 Views: 294
• 

  View oracle database job and session information

  View all jobselect from dba_jobs; view running jobselect from dba_jobs_running;select job,log_user,priv_user,sch

  2022-06-01 09:03:09 Views: 265
• 

  Installation and configuration Guide for MySQL Multi-instance

  Operating system: CentOS 6.8 virtual machine: VMware database: MySQL 5.1.62 practical task: install and configure multi-instance MySQL database 1. Install the dependency package [root@www~] # yum instal required by MySQL

  2022-06-01 09:03:09 Views: 292
• 

  Mongodb CRUD Action-Select

  Vps2 "> https://docs.mongodb.com/manual/reference/method/db.collection.find/ query document db.collection.find (qu

  2022-06-01 09:03:09 Views: 273
• 

  Sqlserver update statement based on subquery

  Syntax structure: update primary table aliases set primary table aliases .name = (select child table aliases .name from child table aliases where primary table aliases .id = child table aliases .id) from main table aliases example:

  2022-06-01 09:03:08 Views: 287
• 

  Introduction and deployment of zabbix

  Introduction to zabbix zabbix is an enterprise-level monitoring solution that can monitor objects, collect information, and store the collected information in a database through SNMP, zabbix dedicated agent, simple system management and network tools.

  2022-06-01 09:03:02 Views: 244
• 

  Serialization-pickle

  Serialization-pickle,json1, serialization converts the state information of an object into a form that can be stored or transferred, and there is some structural data in memory that you want to save for use, or send it to others to use a lot of games that allow you to save progress when you exit, and then you start again.

  2022-06-01 09:03:02 Views: 216
• 

  MHA monitoring detection error report

  MHA has been running normally since it was installed, and there have been switches in the middle, but all of them have been done normally. Later, other dba have done some operations after mha automatic switching, but did not say what they have done. When I checked the status again, I found that the monitoring was not running, so I started it manually and reported the following results

  2022-06-01 09:03:02 Views: 225
• 

  Mysql Learning Notes (4)-aggregation function, control flow function

  [text] first, the introduction of navicat: (third-party visual client to facilitate the management and maintenance of MySQL database) NavicatTM is a set of fast, reliable and affordable database management tools, specially designed to simplify database management and reduce system management costs. it

  2022-06-01 09:03:01 Views: 260
• 

  RAW creation of ORACLE under linux

  1. Disk partition, establish 13 partitions, corresponding to ORACLE13 files fdisk / dev/sdc2. Edit the 60. Raw _ file # vi / etc/udev/rules.d/60-raw.rulesACT

  2022-06-01 09:03:01 Views: 253