NAV: SLTechnology News&Howtos > Database >

• 

  Create user Oracle 10g Learning Series (1)

  Recently there is time to learn oracle, sort out the learning process, a long way to learn, and now it is just the beginning. 1.#su-oracle2. Start snooping $lsnrctl start3. Start em$ emctl start dbcon

  2022-06-01 09:57:49 Views: 244
• 

  Source code installation mysql-5.5.53.tar.gz

  Operating system: CentOSrelease 6.8 (Final) virtual machine: VMware database: mysql-5.5.53.tar.gz Note: source code installation package mysql-5.5.32.tar.gz version installer

  2022-06-01 09:57:43 Views: 289
• 

  Several ways to change password in mysql Database and how to forget password

  1. Mysql password modification method: 1. Use mysqladmin to modify # mysqladmin-uroot-p password 'newpass'Enter password: note: if this is the first time to change the password, mention

  2022-06-01 09:57:43 Views: 220
• 

  Data compression: brief

  1. Decide which objects are compressed by sp_estimate_data_compression_savings to evaluate the amount of space saved during ROW and PAGE compression, respectively. The table has a better compression effect when it contains the following data schema: columns of numeric type

  2022-06-01 09:57:43 Views: 300
• 

  The solution to the error report of deleting table in hbase

  When hbase builds a table, if snappy or other compression is not installed, it will hang when creating the table, and the table cannot be deleted, and it will also have an impact on the cluster. The most obvious impact is that it cannot be balanced. The following is the current situation of error reporting and the solution: for more information, please refer to: ht

  2022-06-01 09:57:42 Views: 256
• 

  Failed to start the oracle service OracleDBConsoleorcl

  Today, I want to access oracle's em service, but I can't get in. Baidu told me that it didn't start the OracleDBConsoleorcl service, entered the service, right-click to start it, and prompted an error. Baidu has been working for a long time. The final solution is as follows: 1:cmd command line runs emct.

  2022-06-01 09:57:42 Views: 253
• 

  MongoDB Database-basic Syntax

  First, the characteristics of MongoDB database and the characteristics of installing MongoDB database are document-oriented, mode free json data model (bson) (can be understood as a dictionary) multi-level index high availability replication set horizontal expansion cross-platform, multi-language interface weak transaction type big data,

  2022-06-01 09:57:41 Views: 267
• 

  Oracle linux 4.8 build local source

  Installing oracle 10g rac with oracle linux 4.8requires a lot of dependent packages, one of which is troublesome. Building a local source is relatively simple and a little more complex than previous oracle linux 5 and 6. Download and install c

  2022-06-01 09:57:41 Views: 218
• 

  Sysbench0.5 notes

  Installation method: download address: https://github.com/akopytov/sysbenchyum install automake libtool-yunzip sysbench-0.5.zip

  2022-06-01 09:57:35 Views: 259
• 

  Redis master-slave replication

  one。 What is master-slave replication? There are some problems in redis stand-alone: 1. Stand-alone machine failure, can not quickly recover 2. Single machine capacity memory limit 3. The problem of stand-alone QPS is simply slave replicating master data. The role of master-slave replication: 1. Provide data copy (backup) 2. Expansion

  2022-06-01 09:57:34 Views: 287
• 

  Stand-alone ASM replaces storage and host

  Oracle ASM replacement storage and host: 1. When installing stand-alone GRID and database software on a new host, you can copy it from the source host, and then clone operation 2. Hang the new storage on the old host, create a new disk group, and prepare the database with back as copy

  2022-06-01 09:57:07 Views: 234
• 

  Anemometer visualizes MySQL slow query based on pt-query-digest

  Reference article: http://ourmysql.com/archives/1359?utm_source=tuicool&utm_medium=referral official: https://github.com/b

  2022-06-01 09:57:07 Views: 273
• 

  Lsnrctl start starts snooping very slowly (AIX platform)

  Today, I logged in to the ORACLE test server on the company's AIX platform, and there was no configuration listening. After manually configuring the listening, I started the listening and found that it was very slow to start. The log is as follows: welcome to join the ORACLE Super Group: 17115662 solve all kinds of ORACL for free.

  2022-06-01 09:57:06 Views: 266
• 

  Oracle database startup and shutdown

  To understand the startup and stop of Oracle databases, you need to understand the definitions of the terms "instance" and "database": database (database): a collection of physical operating system files or disks (disk). Example (

  2022-06-01 09:56:52 Views: 281
• 

  CentOS 7, apm+xcache, rpm package, php module

  Experimental requirements: 1. CentOS 7, apm+xcache, rpm package, php module;a) one virtual host provides phpMyAdmin, another virtual host provides wordpress;b) for phpMyAdmi

  2022-06-01 09:56:51 Views: 249
• 

  Db2 defines partition tables and partition keys

  Next, in order to improve database performance, we put different partitions under different table spaces. First create 6 table spaces, 3 data table spaces, and 3 index table spaces: db2 "create tablespace ts_dat managed by da

  2022-06-01 09:56:51 Views: 260
• 

  Oracle 11g duplicate active database to establish physical DG

  Environment: primary:OS: Red Hat Enterprise5.8IP: 10.131.119.118DBVersion: 11.2.0.3.0db_name: orcldb_unique_na

  2022-06-01 09:56:51 Views: 207
• 

  SQLserver statement command

  Create database db001;-- create table Create table job (id char (10) not null,name char (30) not null,address char (1)

  2022-06-01 09:56:51 Views: 240
• 

  Navicat usage tutorial: optimizing query performance using Navicat Query Analyzer (part 2)

  Download the latest version of Navicat Monitor Navicat Monitor is a secure, simple and agentless remote server monitoring tool. It has a powerful function to maximize the effectiveness of your monitoring. Monitored servers include MySQL and Mar

  2022-06-01 09:56:41 Views: 286
• 

  RedHat compilation and installation of MySQL

  1. Download the mysql source code package and cmake's rpm package: boost_1_59_0.tar.gzmysql-5.7.19.tar.gzcmake-2.8.12.2-4.el6.x86_64.rpm2, solution

  2022-06-01 09:56:40 Views: 256