NAV: SLTechnology News&Howtos > Database >

• 

  Index Series 10-- ordered Optimization of Index characteristics order by

  -- Index and sort drop table t purge;create table t as select * from dba_objects; set autotrace traceonly--orac

  2022-06-01 06:23:05 Views: 256
• 

  Oracle DBlink

  A way for DBlink to remotely access data, which can be used to remotely retrieve tables from data, perform operations, and so on. Language format: create public datebase link ts (dblink name) connect to scott (

  2022-06-01 06:23:05 Views: 234
• 

  DB insertion performance chaos-postgresql vs mysql vs mongodb vs oracle

  Because I saw a comparison between Dege's postgresql and mongodb inserting 1 million records, I wanted to verify it, but I couldn't understand the conclusion anyway! First of all, I tested it on a virtual machine, 4-core 8G + storage, centos7.2,mongo3.2.9

  2022-06-01 06:23:04 Views: 293
• 

  Parsing MYSQL BINLOG binary format (2)-- FORMAT_DESCRIPTION_EVENT

  Original: reprint please state the origin thank you! Connect to http://blog.itpub.net/7728585/viewspace-2133188/ reference source: 1. Source code log_event.h log_event.cc2, int

  2022-06-01 06:23:04 Views: 268
• 

  MYSQL: & quot;Can't get hostname for your address"

  When working on the Docker integration WEB project, the tomcat container starts normally and the MySQL container starts normally, but when the external access tomcat is used to operate the database, the application reports an error as follows: Last packet sent to the server

  2022-06-01 06:22:58 Views: 281
• 

  "Oracle 12c operation and maintenance practice treasure book"-parameter file management and no backup bad block processing sharing

  "Oracle 12c operation and maintenance practice treasure book"-parameter file management and bad block handling sharing link: https://pan.baidu.com/s/1gbuLk8wLX4pk68mDylxGEg password: ohtl

  2022-06-01 06:22:57 Views: 248
• 

  Redis Cluster acquires master-slave relationship

  Redis-cli-h 192.168.11.111-p 6380-c cluster slots | xargs-N8 | awk'{print $3 ":" $4 "- >" $6 ":" $7}'

  2022-06-01 06:22:57 Views: 274
• 

  PostgreSQL DBA (95)-PG 12 Partition (out of shared memory)

  PostgreSQL 12 Beta3, creating a partition table with 8192 subpartitions, executing the query, sorting on the partition key, error. Database version: [local]: 5432 pg12@testdb=# select versi

  2022-06-01 06:22:57 Views: 229
• 

  Linux7 suddenly stuck when installing 11g rac.

  Linux7 suddenly stuck when installing 11grac [root@hx-ractest-1 ~] # / u01/11.2.0/grid/root.shPerforming root user operati

  2022-06-01 06:22:57 Views: 271
• 

  Quick installation of MongoDB 3.2.1 under CentOS 6.3

  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. It is a product between relational database and non-relational database, which is the most functional and similar in non-relational database.

  2022-06-01 06:22:56 Views: 249
• 

  Oracle11g11.2.0.1.0 install patch ask seniors to borrow Oracle support account.

  As the project security scan failed, almost all of them are Oracle database security vulnerabilities. The solution is to install the patch, but the Oracle support account is required to install the patch. This is the problem. We are a small business and did not buy a genuine Oracle.

  2022-06-01 06:22:56 Views: 212
• 

  Oracle Tablespace Management (tablespace managment)

  one。 The official website explains that Logical Storage Structures contains the following contents about ASSM: Logical Space Management < / h4 > Oracl

  2022-06-01 06:22:56 Views: 225
• 

  Micro-class sql optimization (4), help "cousin" optimize the report

  1. The SQL problem of "cousin" Today, "cousin" has a more urgent job. There is a historical expense report that must be queried before leaving work. It has been upside down for 2 hours, and the number of concurrent queries has increased to 40, but the report still cannot be queried. Moreover, this report will torture my cousin every month.

  2022-06-01 06:22:48 Views: 239
• 

  Db basic Command 1

  1. Create Table 2. Query, delete, update, insert data operation query: delete: drop table ruozedata update: insert data: 3. Set the constraint to create a new constraint in it, and the code can be found in it (you can find the code when you save the execution). 4. Number of deletion

  2022-06-01 06:22:48 Views: 213
• 

  Oralce 12c tablespace query (including pdb)

  SELECT DB_NAME,con_id,RES_NAME,TABLE_SIZE,USED_SIZE,USE_PERCENT,AVA_SIZE,AUTOEXTENSIBLE,CONTENTSFROM

  2022-06-01 06:22:47 Views: 237
• 

  Determining the optimal revocation retention time of undo_retention

  Undo_retention: determine the optimal undo retention time using the following formula to calculate the value of the undo_retention parameter: undo_retention=undo size/ (db_block_size * und

  2022-06-01 06:22:47 Views: 262
• 

  Shell scripts that display the size of key in redis

  Key-sized shell scripts can be displayed in redis, making it easy to locate the big key in redis. The content of the script is as follows: # cat rediscopyright printcopyright keysize.shemaking Universe UsrUnix binexorenv bashhu

  2022-06-01 06:22:47 Views: 204
• 

  Upgrade the new bugORACLE ORA-07445 caused by psu

  Recently, the customer has been patching 10.2.0.5.19 PSU, running @ catbundle.sql psuapply and reporting to ORA-07445:exception encountered: core dump [Joet _ c]

  2022-06-01 06:22:45 Views: 286
• 

  MySQL 5.7Group Replication error summary (R11 note day 84)

  Today, I would like to summarize some of the problem handling in MySQL 5.7. it is relatively conventional. I don't need to say much about the construction process. I can see a basic way in yesterday's article, which is easy to simulate in the test environment. Is it the same if it is built in a multi-physical machine environment? the answer is

  2022-06-01 06:22:42 Views: 209
• 

  AnyDesk 5.5.3 Free Edition-remote Control Software

  Click to download: http://www.chaoxz.com/anydesk-553/ Software introduction AnyDesk is a powerful remote control software, similar to teamviewer, it can provide users with an alternative way to access PC remotely.

  2022-06-01 06:22:41 Views: 243