NAV: SLTechnology News&Howtos > Database >

• 

  Oracle backup and recovery-flashback technology

  As soon as you enable flashback database 1. Enable the archive mode sql > shutdown immediate;sql > startup mount;sql > alter database archivelog;2. Create a flashback sql > a

  2022-06-01 08:58:25 Views: 295
• 

  Oracle View execution Plan issues

  1. Describe how to use dbms_xplan.display to view the execution plan in the process of viewing the execution plan test. It is found that it is because set autot on was opened in the process of testing, closed (set autot off), and executed.

  2022-06-01 08:58:25 Views: 267
• 

  Redis Master / Slave + keepalived High availability automatic switch

  One environment introduces master: 172.168.1.69slave: 172.168.1.57VIP 172.168.1.253 virtual IP II. Design idea: when both Master and Slave are working properly, M

  2022-06-01 08:58:24 Views: 279
• 

  Mysql8 modifies my.ini configuration and restarts service error

  Mysql8 modifies the my.in configuration and restarts the service with an error: the MySQL service on the local computer stops after it starts. Some services will automatically stop the solution when not used by other services or programs: 1. Back up the mysql data directory, the entire directory is backed up somewhere else, but

  2022-06-01 08:58:24 Views: 252
• 

  Oracle 12c common commands

  1. Check the number of pdb databases: SQL > show pdbs;2, switch to the specified container database: SQL > alter session set container=ORCLPDB;3, start the container database: SQL > al

  2022-06-01 08:58:24 Views: 245
• 

  Oplog of mongodb Learning

  Background: it turned out that a colleague asked me why there was a big data gap between the master and slave mongodb database. I asked him to take a look at the differences between the two sides. I found that the master local library had 13G slaves but was very small. After entering local, du found that a file with a collection prefix had 1.

  2022-06-01 08:58:23 Views: 278
• 

  Log Management of MySQL

  Log transaction log: transaction log error log: error log query log: query log slow query log: slow query log binary log: binary log relay log: reley log

  2022-06-01 08:58:20 Views: 302
• 

  Oajinit download path

  Ebs 11i version uses oajinit, usually between 1.3.1.18 and 1.3.1.26. Server file path: $OAD_TOP/../*ora/iAS/Apache/Apache/htdocs/discwb

  2022-06-01 08:58:20 Views: 261
• 

  The processing of starting error report in MySQL Database

  Today, when you start mysql in linux, you will be prompted by mysql Starting MySQL..The server quit without updating PID file. Let me introduce you to the solution from the Internet.

  2022-06-01 08:58:19 Views: 226
• 

  Generate AWR reports manually

  Sometimes in order to install EM in the database, it is impossible to generate AWR reports graphically, so you need to generate AWR reports manually. ORACLE provides a sql. You can generate AWR reports manually. First, create a directory to generate reports. Here is / home/oracle/AWR$.

  2022-06-01 08:58:19 Views: 263
• 

  The failure of the VC client to log in is all caused by the REDO log.

  Environment: VSPHERE5.5+ independent oracle 11G database phenomenon: open the vcenter server console, enter the password, the card does not respond in the welcome interface, and the client can not log in normally. Not even a normal restart. Cannot take a snapshot because the virtual machine where the VC is located is a stand-alone disk

  2022-06-01 08:58:10 Views: 211
• 

  Hbase coprocessor coprocessor

  The processing of each region makes up for the limited number of filters in scan. There are two types of observer observers, which are equivalent to triggers, Endpoint terminals, and observers under stored procedures, which replace the row key with the K of Jack before implementing the query.

  2022-06-01 08:58:09 Views: 202
• 

  Shrink tempdb database

  Customer demand: this is a production environment that finds that tempdb has exceeded 500GB in the dead of night. Requirements analysis: we know that if SQL Server,tempdb is restarted, it will be recreated automatically, thus bringing tempdb back to its original size.

  2022-06-01 08:58:09 Views: 292
• 

  [oracle performance Monitoring]-use Spotlight to monitor oracle and bottleneck analysis

  1 introduction to Spotlight Spotlight is a graphical tool produced by Quest for third-party performance monitoring. There are many Spotlight-related products, such as Spotight on Linux/Unix, Spotight o

  2022-06-01 08:57:49 Views: 249
• 

  Environment configuration of oracle-set Power on (Linux) to automatically start Oracle shutdown and automatically close Oracle

  Set power on (Linux) to automatically start Oracle shutdown automatically close Oracle1, switch to root users, and confirm that [oracle@oracle3 bin] $pwd/u01/oracle/pro exists for startup files and closed files.

  2022-06-01 08:57:48 Views: 247
• 

  Move window baseline

  Oracle Database automatically maintains a system-defined mobile window baseline. The default window size for the system-defined mobile window baseline is the current AWR retention period (default is eight days). If you plan to use adaptive thresholds, consider using a larger mobile window, such as 30

  2022-06-01 08:57:48 Views: 225
• 

  Secondary finishing of Linux_MySQL (2)

  Configuration file parameters server parameters / variables: set the running characteristics of MySQL; display: mysql > SHOW GLOBA | [SESSION] VARIABLES [LIKE clause]; LIKE filter status (statistics) parameters /

  2022-06-01 08:57:40 Views: 216
• 

  Java41: database five (Oracle)

  Database design: the value of the OLD column is unique, there can be no duplicate column value properties that are completely dependent on the primary key, the first normal form must have the primary key, the other columns must be completely dependent on the primary key attribute, and the other columns must be completely dependent on other non-primary attributes (second reinforcement) must satisfy the second normal form to remove the transitive dependency (in a specific

  2022-06-01 08:57:39 Views: 259
• 

  How to deal with ORA-27054 problems in EXPDP

  Phenomenon: [oracle@oracle1 ~] $expdp xian/xian schemas=xian directory=dumpdir dumpfile=xian.dmp LOGFILE=xian

  2022-06-01 08:57:39 Views: 232
• 

  MongoDB basic installation

  Overview of MongoDB basic installation MongoDB (1) MongoDB is a database based on distributed file storage. Written in C++ language. Designed to provide scalable high-performance data storage solutions for WEB applications. (2) MongoDB is an intermediate correlation coefficient.

  2022-06-01 08:57:39 Views: 219