NAV: SLTechnology News&Howtos > Database >

• 

  SQL Server audit scheme for grade protection project

  According to the SQL Server audit requirements of the grade protection project, keep the SQL Server Default Trace file for more than half a year. Solution for users, Default Trace can only turn off or enable the trace, and cannot modify any parameters.

  2022-06-01 10:39:31 Views: 207
• 

  12C what is the impact of modifying the operating system time on the database?

  Sometimes the system time may be set incorrectly because the installation database is not standardized enough, and we need to adjust the system time. But what is the impact of adjusting the system time on the database? Let's do some small experiments. 1. Test the table insert operation with a date field. -- sessi

  2022-06-01 10:39:31 Views: 212
• 

  MYSQL-- custom function

  Custom function user-defined function is a way to extend MYSQL, its usage is the same as built-in function 1 function can return any type of value, also can receive these types of parameters 2 function body is composed of legal SQL statement 3 function body can be simple SELECT or I

  2022-06-01 10:39:30 Views: 262
• 

  Oracle 11g change log group size

  1. Create a new log group 1.alter database add logfile group 4 ('/ u01Accord size size 04.log')

  2022-06-01 10:39:30 Views: 211
• 

  Design of data processing associated with database based on python+mysql+redis cache

  1. Add table CREATE TABLE tb_signin (id INT,user_name VARCHAR (10), signin_num INT, signin_time DATETIME, gold_)

  2022-06-01 10:39:21 Views: 282
• 

  Several ways of configuring Web Program by Tomcat

  The original text comes from the bricklayer, if you need to reprint, please indicate that the source is java's JDBC, so here we will take JDBC as an example to summarize some common contents of java database operation. 1. database driver loading first of all, we know that JDBC is based on java database driver.

  2022-06-01 10:39:21 Views: 276
• 

  First acquaintance of Mysql (1)

  1 build database server 2 MYSQL data type 3 modify table structure 1 build database server 1.1 when mariadb exists: # systemctl status mariadb#systemctl stop mariad

  2022-06-01 10:39:20 Views: 294
• 

  Ubuntu Server 18.04 configure Redis stand-alone master-slave

  [target] configure redis stand-alone master-slave, port 6378 connect master,6379 port connect slave,master read-write, slave read-only. [installation and testing] install sudo apt updatesudo

  2022-06-01 10:39:20 Views: 273
• 

  Linux installation oracle database failed to start the installation interface

  Could not execute auto check for display colors using command / usr/bin/xdpyinfo. Check if the DISPL [

  2022-06-01 10:39:20 Views: 247
• 

  The archive logs in the slave library of Oracle Dataguard are out of sync.

  Environment: RAC+ standalone Dataguard problem: when starting slave database to ADG mode, the backend archive log is found to be out of sync. 1. The archive log of log in slave database is found to be out of sync, as follows: MRP0: Background Media Recover

  2022-06-01 10:39:20 Views: 244
• 

  2PL two-stage locking Protocol and Paradigm of Database

  1.2PL2PL definition: 1. All read and write operations must be locked before; 2. Locking operation is not allowed after unlocking operation; S lock: after adding S lock, other transactions can be read and cannot be written until the end of locked transaction; X lock: no other transaction can be read or written until the end of transaction after adding X lock.

  2022-06-01 10:39:20 Views: 284
• 

  Oracle insertion

  DECLARETYPE num_tt IS TABLE OF INT;num_t num_tt:=num_tt (); mid_val INT;mid_j INT;BEGINnum_t.extend (20

  2022-06-01 10:39:19 Views: 258
• 

  Comparison of execution time between Timesten and Oracle SQL

  Just took a simple test. Timesten 11g and Oracle 11.2.0.4 are installed on two physical machines with the same hardware environment to create a table create table test (a number,b va) in both databases.

  2022-06-01 10:39:19 Views: 214
• 

  The case of Oracle Study-data recovery artifact Flashback (2)

  The case of Oracle Study-data recovery artifact Flashback (2) 1. Flashback Table: for misoperation of DML, you can roll back the table through Undo block (two modes: time-based and SCN-based)

  2022-06-01 10:39:16 Views: 275
• 

  2017 is almost over. 2018 would be better.

  How time flies. More than half a year has passed in 51cot College. I joined 51cot College in May 2017 and gained a lot from this platform. I am studying the oracle micro position of Brother Feng, carrying on the systematic study of oracle, according to the regulations of the college.

  2022-06-01 10:39:05 Views: 223
• 

  Linux basic part 5 basic commands-3

  In linux, we often need to find certain files, the directory where the files are located, and so on. Then we need to use some basic file lookup class commands. There are mainly the following file search commands: which view command or the full path of the executable file whereis display two

  2022-06-01 10:39:05 Views: 241
• 

  Data Migration of Mysql Billing system based on radius

  Summary of data transfer technology from radius billing system to blue ocean billing system this paper is for reference only and has been successfully tested in the actual environment. You are welcome to ask questions. 1. First of all, we must have a clear train of thought and a clear goal. This billing transfer will mainly be the veteran billing radius manageme.

  2022-06-01 10:39:04 Views: 275
• 

  Redis-- rdb persistence

  Persistence: generally speaking, there is still data on the next boot, and the data will not be lost after the power outage and will be stored on disk. Redis:rdb snapshot persistence every N minutes or N writes, dump data from memory to form an RDB file. Compress and put it in the backup directory. Detailed description of parameters: sav from bottom to top

  2022-06-01 10:39:04 Views: 210
• 

  Detailed explanation of MySQL show processlist; command

  SHOW PROCESSLIST shows which threads are running, and if you have SUPER permission, you can see all threads, otherwise, you can only see your own threads (that is, threads related to the MySQL account you are using), if you do not use the FULL pass

  2022-06-01 10:39:04 Views: 255
• 

  Create a simplecmdb project

  Create simplecmdb project 1. Create project simplecmdb, create an application, startapp hostinfo, and add application [root@133] # cd / opt/python/dja to setting

  2022-06-01 10:38:50 Views: 213