NAV: SLTechnology News&Howtos > Database >

• 

  Talk about database flashback technology

  When it comes to flashback technology, I rarely use it after working for so long that I almost forget what flashback technology has. If you are free today, let's review the flashback technology in the database. Even if I don't read a book, there are several kinds of flashback technology in my impression: flashback database, flashback deletion, and flashback query. Flash

  2022-06-01 14:03:19 Views: 222
• 

  [Mo Jin original] difference between cross-database access and cross-user access in Sql

  Today, the programming of database partition function was amused. The background has created a Db Link, and you can't access it. Go through all kinds of troubles. I didn't come out to find someone. I just finished describing the problem. Suddenly remembered that the interview was changed to @, and it was a success! The difference between cross-library access and cross-user access is-

  2022-06-01 14:03:19 Views: 296
• 

  Oracle data export, import operation

  Principle: export data through the exp.exe tool in the Oracle BIN directory 2019.01.10 cmd window import export table .SQL file 2019.04.30 PL/SQL tool import export table .pde file-large amount of data

  2022-06-01 14:03:14 Views: 256
• 

  HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another Node

  In this DocumentAPPLIES TO:Oracle Database-Enterprise Edition-Version 9.2.0.1 and laterInformati

  2022-06-01 14:03:14 Views: 221
• 

  Commands for creating and deleting MySQL databases

  The MySQL database is a collection of data tables. It is important to create a database, and so is the naming of the database. Let's talk about the command line for creating and deleting the database. 1. The command line that creates the database, create database huthon;, creates a

  2022-06-01 14:03:14 Views: 263
• 

  Oracle wallet practice and common operation

  The role of Wallet starts from Oracle 10g R2, through the use of Oracle Wallet to achieve any user does not use a password to log in to the database (non-operating system authentication), which is a script to log in to the database with a user password in shell.

  2022-06-01 14:03:14 Views: 226
• 

  Django project directory structure

  Django project directory structure you have configured your Heroku account and created your first Heroku application. Let's discuss a very important topic (though often overlooked): Djang

  2022-06-01 14:03:13 Views: 243
• 

  Ibtmp1 file is too large

  A database found that the disk alarm has been 100%. What is it that there is an ibtmp1 in the data directory of the database? After looking at the official documents, I found that The temporary tablespace is a tablespac

  2022-06-01 14:03:10 Views: 213
• 

  Common structure of OGG12.2

  1. Single replication structure source data system-- (Capture)-- > queue file-- (Pump)-- > network (Internet,Intranet)-- > queue file-- (Delivery)-- > destination data system this structure is used to use the number of

  2022-06-01 14:03:03 Views: 272
• 

  Changes and improvements of MariaDB 10.4.11 (GA)

  1. Account locking allows administrators to lock / unlock user accounts. Sentence: 1 Lock ALTER USER 'hechunyang'@'%' ACCOUNT LOCK; when the user logs in again after locking, the following message is prompted: # mysql-H2

  2022-06-01 14:03:02 Views: 219
• 

  Solve the problem that the server cannot be accessed from the external network and the use of the PHPWAMP port scanning tool

  The server cannot be accessed from the public network, and Ali Cloud cannot access the solution from the public network. Tencent Cloud public network cannot access the PHPWAMP integrated environment, which supports nginx, iis, apache, asp, php and asp.net, and has many built-in utilities. None in the server's external network

  2022-06-01 14:02:56 Views: 244
• 

  Mongodb of NoSQL

  NoSQL (NoSQL = Not Only SQL), which means "not just SQL". Refers to the non-relational database, is the general name of the database management system which is different from the traditional relational database. NoSQL is used to store very large-scale data. These types

  2022-06-01 14:02:56 Views: 254
• 

  My MYSQL is resistant to manufacturing.

  1. Server hardware 1, cpu (frequency and quantity) (1) cpu frequency cpu intensive: mainly for sql execution efficiency, currently mysql does not support concurrent processing of multiple cpu to the same sql; (2) number of cpu (web application) mainly increases throughput and concurrent processing capacity; example

  2022-06-01 14:02:55 Views: 258
• 

  SQL Server calculates Jaccard coefficient-sim (iMagazine j)

  A few days ago, I saw someone in the Q group asking such a question: how to use SQL in SQL Server to achieve the following calculation from the figure, the problem is how to calculate the Jaccard coefficient. Jaccard coefficient, also known as Jaccard similarity coefficient (Jaccar)

  2022-06-01 14:02:37 Views: 263
• 

  Redis key value related commands

  1. Keys format: keys {pattern} returns all key that satisfy a given pattern. 2. Exists format: exists' key' determines whether key exists. 3. Del format: del 'key' deletes ke

  2022-06-01 14:02:36 Views: 285
• 

  Replication crash safe

  What is a master-slave copied replication crash safe? The parameter master_info_repository has two values: FILE & # 40; the corresponding file master.info), or TABL

  2022-06-01 14:02:36 Views: 278
• 

  Modify the Job Scheduler log level of Oracle and delete the running log

  Job running for a long time will generate a large number of running logs, which can be cleared by the following ways: 1. Create job:Create job links to previous job class. DBMS_SCHEDULER.cre

  2022-06-01 14:02:36 Views: 209
• 

  MYSQL Database Learning Series 5

  MYSQL database learning series 55. MySQL operation and maintenance practice 5.1-MySQL log system what is log log (log) is a kind of file that records events sequentially records what happens during the operation of computer programs? various uses of to help analyze program problems

  2022-06-01 14:02:35 Views: 217
• 

  Mysql Multi-instance launch brief memo

  Mysql multi-instance configuration scheme: solution 1 (multi-profile, multi-startup program): mkdir / data/3306/ {data,tmp,log} touch my.cnf service file mysql change port (1) security

  2022-06-01 14:02:35 Views: 228
• 

  Basic syntax of SQL statement

  First write the displayable Chinese code set character_set_client=gbk;set character_set_results=gbk; or type only one sentence set names gbk; to create the database create

  2022-06-01 14:02:33 Views: 264