NAV: SLTechnology News&Howtos > Database >

• 

  The environment variable causes the connection ASM to report to Connected to an idle instance

  [grid@huntdb02 ~] $export ORACLE_SID= txzldb2 [grid @ huntdb02 ~] $sqlplus "/ as sysasm" SQL*Plus: Release11

  2022-06-01 16:36:29 Views: 272
• 

  OVER of Oracle advanced query (PARTITION BY.)

  In order to make it easy for you to learn and test, all the examples are set up under Oracle's own user Scott. Note: the red order by in the title indicates that you must bring order by when using this method. 1. Rank () / dense_ran

  2022-06-01 16:36:29 Views: 274
• 

  OGG maintenance Optimization script (1)-requirements Analysis

  This set of maintenance optimization scripts, which I wrote in my spare time, are specially designed for goldengate data synchronization tools. The main reason is that I am a little lazy and don't like tedious manual operations. So with the help of the shell script to reduce your workload, I refer to some of the network's s.

  2022-06-01 16:36:16 Views: 306
• 

  The basis of SQL using set operators for multi-table queries (XII)

  Set operations: types and considerations set actions column names and expressions in the SELECT list must match the data type of each column in the second query must match the data type of the corresponding column of the first query that can be changed with parentheses. ORD

  2022-06-01 16:36:08 Views: 269
• 

  Some views on the use of shopnc system, static rules

  On the use of the shopnc system, since the use of this system, the system bug constantly, so far the official circle of static problems have not been properly dealt with, this problem, I Baidu for a long time, almost no one can solve, want to change to discuz programs, but also need to do database connection

  2022-06-01 16:36:07 Views: 297
• 

  MySQL performance Doctor: OrzDBA

  Svn co http://code.taobao.org/svn/orzdba/trunkwget http://github.com/downloads/Lowercases/tcprstat/t

  2022-06-01 16:36:07 Views: 263
• 

  Error log monitoring alarm script

  Write in front: in practice, checking the database error log regularly is an essential work item. But the check does not necessarily produce a new error message, or we prefer never to have an error message, because it means that our database is robust. In this case, it is impossible to predict

  2022-06-01 16:36:07 Views: 265
• 

  Java40: database IV (Oracle)

  JDBC provides a standard for accessing the database is a series of interfaces that define a common way to access the database. The various database vendors provide the definition of the JDBC interface to the JDBC. The database vendor establishes the connection to the jdbc implementation jar-sends the sql- to execute the sql- return.

  2022-06-01 16:36:07 Views: 250
• 

  Use Debug Diagnostic Tool to troubleshoot memory leaks

  Use Debug Diagnostic Tool to troubleshoot memory leaks translated from: https://mssqlwiki.com/2012/12/06/debugging-memory-leaks-using-deb

  2022-06-01 16:36:05 Views: 205
• 

  InnoDB redo log format-physical log

  Modifying N bytes on the page can be regarded as a physical log. It includes the following types: MLOG_WRITE_STRING, MLOG_8BYTES, MLOG_2BYTES, MLOG_1BYTES, MLOG_4BYTES. Various page chains

  2022-06-01 16:35:57 Views: 248
• 

  Buffer busy waits of Oracle waiting for event

  Buffer busy waits (hot block contention) official website explains: This wait indicates that there are some buffers in the buffer cache th

  2022-06-01 16:35:57 Views: 277
• 

  Powershell create a new database

  New-mailboxdatabase-Server 'EXCHANGE02'-Name' dataabase04'-EdbFilePath'd:\ Mailbox\ dataabase04\ da

  2022-06-01 16:35:56 Views: 218
• 

  PHPl link database

  PHP connects to database 1. The return value of the connection database function mysqli_connect (hostname, user name, password) is one of our connection objects. If the connection fails, it returns false2. Judgment error function mysqli_connect

  2022-06-01 16:35:56 Views: 250
• 

  Xtarbakcup realizes "hot" backup of MySQL

  Introduction to xtarbackup backup Xtrabackup mainly contains two tools: xtrabackup: it is a tool for hot backup of data in innodb,xtradb tables, which cannot back up other types of tables or data table structures; innoba

  2022-06-01 16:35:50 Views: 230
• 

  Changes to oracle's global_names

  After the oracle10g installation is complete, the value of global_name is not only orcl, but also the domain name, and it is very long and difficult to remember. So I thought of a way to change the value of global_name. Conn / as sysdbashow paramete

  2022-06-01 16:35:50 Views: 294
• 

  MySQL5.6 master-slave replication (simple version)

  Several common Replication topologies: 1. Single master---- and multiple slaveslave do not communicate with each other, and only communication with master is suitable for application scenarios with high read pressure. Distribute read operations to different slave to reduce mast.

  2022-06-01 16:35:49 Views: 210
• 

  Summary of MySQL Import and Export methods

  The advantage of using into outfile and load data infile to import and export data is that the exported data can be formatted on its own, and the exported data is pure data, and there is no table-building information, so you can directly import it into a different table from the same database.

  2022-06-01 16:35:49 Views: 313
• 

  DISQL, the "disql pagesize" setting of the little secret you don't know.

  The set command is used to set disql system environment variables. By using the show command, users can quickly and easily understand the current environment variable settings of the disql environment. Test environment: won the bid Kirin 664 bit, Dameng database version 7 referred to as DM7 launch disql tool

  2022-06-01 16:35:49 Views: 273
• 

  HBase Learning Section v1.2

  1. HBase is a highly reliable, high-performance, column-oriented, scalable, distributed column storage open source database built on HDFS, which is mainly used to store massive data. At the same time, mapreduce is used to process data in HBase, and zookeeper is used as a collaborative service.

  2022-06-01 16:35:49 Views: 241
• 

  Catalog start with

  337.You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately, you have ana

  2022-06-01 16:35:43 Views: 244