NAV: SLTechnology News&Howtos > Database >

• 

  Debian wheezy install / uninstall Oracle Jre1.6.0.45

  1. Download jre-6u45-linux-x64.bin2 from the official website. Upload the jre-6u45-linux-x64.bin file to / usr/java and give it the right to execute # chmod aquix jre-6u45-linux-

  2022-06-01 07:27:47 Views: 212
• 

  Use the part above the neck to solve the problem (1): sqlplus login report has no permission error

  Due to various reasons, I haven't come here for a long time to publish my own article. I encountered an interesting question some time ago, which made it difficult for me all afternoon. I wrote it here to share with you. When using the sqlplus tool to log in to the Oracle database locally as sysdba, I suddenly encountered

  2022-06-01 07:27:46 Views: 234
• 

  Oracle11gR2 uses EXP export to report EXP-00011 error

  Since there is no record in the table, there is no record of segment space, so you can manually allocate a space to these tables: alter table USERS allocate extent (size 64k); for tables that have been created but do not have Segment yet

  2022-06-01 07:27:36 Views: 262
• 

  Essential for operation and maintenance-compile and install LAMP

  1. Compilation and installation introduction in the work, based on a variety of production environments, yum installation may not meet our needs. At this time, we have to compile and install the package ourselves. Of course, as long as we master the skills, the compilation and installation is also very simple. This article will introduce how to use CentOS 6.

  2022-06-01 07:27:36 Views: 299
• 

  Self-join query experiment of oracle rookie learning

  Oracle rookie learning self-join query experimental table creation table field description: id: employee number name: employee name ano: manager number create table admin (id varchar2 (4), name varc

  2022-06-01 07:27:35 Views: 243
• 

  Amazon Aurora: design considerations for High Throughput Cloud Native Relational Database

  Translator: Aceking, partner of extremely Yunzhou technology, database kernel R & D expert, responsible for enterprise-level cloud native database ArkDB and other core database products, graduate degree in database department of Huazhong University of Science and Technology, former Dameng database product development engineer, responsible for Dameng database kernel

  2022-06-01 07:27:22 Views: 216
• 

  New feature of MySQL8.0-- Group by

  The Group by statement is used in conjunction with aggregate functions such as count,sum,avg,max,min to group result sets according to one or more columns. (1) remove duplicate values: only one line of results is displayed according to the keywords after group by; (2) mys

  2022-06-01 07:27:21 Views: 217
• 

  The difference between on filtering and where filtering in sql join query

  Sql query this thing, to say it is simple, can be very simple, usually only need to use add, delete, query and change with the logical expression ability of the programming language, you can achieve all the functions. However, adding, deleting, checking and modifying does not represent all of the sql statements, and the complete sql function will be daunting.

  2022-06-01 07:26:58 Views: 300
• 

  Zabbix distributed Monitoring Application of Automated Operation and maintenance tools (5)

  An overview of distributed monitoring three common architectures of proxy and nodeZabbix-- > Server-agent-- > Server-Node-agent-- > Server-Proxy-agentZabbix can efficiently monitor

  2022-06-01 07:26:53 Views: 271
• 

  Database sql Optimization 1

  Why to optimize: with the start of the actual project, the database runs for a period of time, the initial database settings will be different from the actual database performance, then we need to make an optimization adjustment. Database optimization is a big topic, which can be divided into four categories: "host performance" memory makes

  2022-06-01 07:26:52 Views: 254
• 

  ORA-13516 / ORA-06512 DBCA build database, password special symbol error

  Oracle 11.2.0.4 uses DBCA to build the library, and the sys/system password uses special symbols, resulting in an error during installation. The following is the solution: APPLIES TO:Oracle Database-Standard E

  2022-06-01 07:26:52 Views: 209
• 

  SQL statements that capture unbound variables

  Previously, you have been using the following sql to view the sql of unbound variables, but select hash_value, substr (sql_text, 1,80) from v$sqlarea where substr (s) is not allowed.

  2022-06-01 07:26:52 Views: 237
• 

  MongoDB Python driver

  Install 1. 0 using pip install pymongo. Connect MongoDB instance In [60]: from pymongo import MongoClientIn [61]: client=MongoCli

  2022-06-01 07:26:52 Views: 299
• 

  Goldenagte uses expdp to synchronize the table according to scn.

  1: first stop the replicate process 2: make sure that the database scn,Scn on the source side is the scn number on the source side, that is, the current scn number of the current database formal library: select sysdate,dbms_flashback.get_sys

  2022-06-01 07:26:51 Views: 279
• 

  Oracle 11g R2 RAC delete a node process

  Experimental scenario: two-node RAC with hostnames of db1 and db2. Db2 needs to be deleted now. In this example, it is deleted in the normal state. 1. The db1,db2 node checks whether the CSS server is normal, as shown below. [root@db1 ~] # su-gr

  2022-06-01 07:26:40 Views: 246
• 

  EMC, Pure and NetApp launch new products, where is the NAS flash memory scene?

  The trend of All Flash/SSD storage is unstoppable, and it will be the same in NAS services in the future. At present, many startups support full-SSD NAS storage services, including EMC Isilion with all-flash nodes. High IOPS capability in Flash memory scenario

  2022-06-01 07:26:36 Views: 202
• 

  Performance Optimization of Oracle Learning (6) access path

  Access paths are the few ways Oracle can find the data users need, including the infamous full table scan-the (misinterpreted) access path that people avoid at all costs. Various types of index scans-this is the access path that people feel good about (in most cases it is crooked

  2022-06-01 07:26:32 Views: 201
• 

  Query table under oracle

  Query the tables under the user: if your user permission is not DBA:select * from user_tables;, you can query the tables owned by the current user. If it is a DBA user: select * from dba_tables

  2022-06-01 07:26:31 Views: 234
• 

  Some limitations of MariaDB ColumnStore and BUG summary

  Field property restrictions 1. CHARACTER SET syntax MariaDB [test] > create table T1 (id int,name varchar (10) CHARACTER SET utf8 is not supported

  2022-06-01 07:26:28 Views: 260
• 

  Configure the connection remote test library (other databases)

  1. First, the configuration file tool-"preferences in which some companies will operate environment variables to remove Oracle environment variables (online method). Second, because I can't configure E:\ Oracle\ produc with the above method."

  2022-06-01 07:26:28 Views: 283