NAV: SLTechnology News&Howtos > Database >

• 

  A summary of oracle 11g acs:

  Today we will talk about the impact of the following parameters on database performance and stability: cursor_sharing: cursor sharing _ optim_peek_user_binds: bind variable peep _ optimizer_adaptive_cursor_

  2022-06-01 06:32:54 Views: 292
• 

  Oracle database backup script

  Physical backup script #! / bin/shexport TMPDIR=$TMP;export ORACLE_SID=orcl;export ORACLE_BASE=/u01/app/oracle;export O

  2022-06-01 06:32:54 Views: 200
• 

  Mysql 8 cannot be started after modifying datadir under CentOS 7

  Try to modify the datadir parameter of mysql and copy the data file to the new directory / data, but when you start the mysql service, prompt: [root@mysql8-01 data] # systemctl status

  2022-06-01 06:32:54 Views: 238
• 

  Oracle hint posts with good principles of ordered and leading

  Question: please know how to write HINT I have a SQL to add the following hint, the purpose is to specify the hash_join mode. Select / * + ordered use_hash (a _) * / * From _

  2022-06-01 06:32:53 Views: 297
• 

  Oralce simple conditional query exercise

  Chapter 1 simple query and conditional query 01. Log in using the SQL PLUS tool and the user name is scott. 02. Query the name, department number and salary of all records in the emp table, and the column names should be displayed in Chinese. 03. In the emp table

  2022-06-01 06:32:49 Views: 288
• 

  National Marine big data Center-GBASE Integrated Database solution

  In order to achieve the construction goal of the National Marine big data Center, the Marine Integrated Database (Phase II) needs to be based on the marine environment comprehensive database platform of the marine special network built and completed by the marine environment comprehensive database (phase I) project. Expansion of secret network and Internet database platform and marine target and polar data construction

  2022-06-01 06:32:46 Views: 234
• 

  Physical storage structure and session lifecycle of MySQL

  Physical storage structure of MySQL (1). The organization of the data-index (2). Row storage of data compact storage of variable length fields: variable length columns also take into account the number of bytes of the actual length of the storage column when evaluating the field size. For example, VARCHAR (255) CH

  2022-06-01 06:32:41 Views: 211
• 

  Rowid High Speed pagination in oracle

  Step 1: get the physical address of the data step 2: get the maximum number of pages step 3: get the minimum number of pages step 4: because the number of pages obtained are physical addresses, and then query the specific data according to the physical address-rowid paging, the first step select rowid rid,OWNER

  2022-06-01 06:32:41 Views: 286
• 

  12C Common SQL statements of Multi-tenancy about CDB and PDB

  View the current container and current user show con_name userselect sys_context ('userenv',' con_name'), sys_context (' userenv','sessio)

  2022-06-01 06:32:40 Views: 272
• 

  Innodb_autoinc_lock_mode

  There are three values for innodb_autoinc_lock_mode: 0 1 2. Generally, the default is 1innodb_autoinc_lock_mode=0, which is the traditional mode. All insert-like statements hold tab.

  2022-06-01 06:32:40 Views: 271
• 

  Summary of matters needing attention in Oracle Reconstruction Table (rename)

  An overview of http://www.cnblogs.com/ljbguanli/p/6752029.html 1. Some time ago, there was a DBA friend who finished rebuilding the table (rename). The business could not be executed normally the next morning.

  2022-06-01 06:32:40 Views: 275
• 

  Talking about the distinct statement and group by,order by of Mysql

  Recently, when I was working on a project, I found that the data was quite different from what I had expected. After a careful study, I found that the problem lies in the distinct statement and the groupy by,order by statement. First, the distinct statement, which obtains non-repetitive (unique) line notes.

  2022-06-01 06:32:40 Views: 237
• 

  How to deal with the wrong ORA-39140 of importing ORACLE IMPDP into the Times

  Ora31940 impdpORA-39001: invalid argument valueORA-39000: bad dump file specificationORA-39140: dump

  2022-06-01 06:32:39 Views: 271
• 

  0705_oracle sequence

  -sequence sequneceuser_sequnecesincrement by 2-step size start with 2-starting value maxvalue 10-- maximum value 2 468 10nom

  2022-06-01 06:32:39 Views: 213
• 

  Some tests of tools for recovering ibd data from percona-data-recovery-tool

  I came across the tool percona-data-recovery-tool, which is used to recover data in innodb data files. It seems to suggest that row_format must be REDUNDANT or COMPACT. And

  2022-06-01 06:32:39 Views: 208
• 

  Redis cluster forces the repair process after kill a node and shutdown a node.

  Redis cluster command line. To execute the following command, you need to log in to cluster, which is unique to the cluster (cluster) CLUSTER INFO prints the information of the cluster CLUSTER NODES lists all the nodes currently known in the cluster

  2022-06-01 06:32:39 Views: 241
• 

  Sqlserver queries the size usage of all tables

  The first method: first query the source table data: select 'insert into @ tmp exec sp_spaceused' + name From sys.tables with (nolock) order

  2022-06-01 06:32:38 Views: 211
• 

  DM Custom data Type

  Custom types users can use CREATE TYPE statements to define record types, object types, named array types, collection types, and so on. If procedures or methods are declared in an object type, you can use CREATE TYPE BODY to define these procedures and methods. Create a class

  2022-06-01 06:32:36 Views: 274
• 

  Dm7-oracle deployment dblink test failed problem

  When we deploy dblink between dm7-oracle, we often encounter this error: [description] when we create an external link on the dm7 client and test it on the dm7 client after the dblink is deployed, the problem we will encounter is that no matter how we test it on the dm side. Encounter this kind of

  2022-06-01 06:32:36 Views: 265
• 

  Undo bad block

  1. Overview SQL > show parameter undoNAME TYPE VALUE

  2022-06-01 06:32:36 Views: 236