NAV: SLTechnology News&Howtos > Database >

• 

  Oracle12C multi-tenant management users, roles, permissions

  In Oracle12C, the management of user rights is slightly different from the traditional Oracle single database environment. There are two types of users in a multi-tenant environment. ①: common user (Common User): this user has all containers (root and all Pdb)

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

  Query HBase through Hive

  The storage of online zipkin is using HBase0.94.6. At first, Dev wants to write MR directly to do offline analysis. Later, we talked and found that using Hive will improve the efficiency of development. (of course, here you can query the SQL interface of HBase and phoenix,Impa.

  2022-06-01 09:51:43 Views: 279
• 

  Getting started with SQLServer

  Knowledge points related to SQLServer database 1. Why use a database? Database technology is one of the core technologies of computer science. The use of database can store data efficiently and clearly, so that people can manage data more quickly and conveniently. The database has the following characteristics: it can knot.

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

  Openstack database management tool alembic updates the Enum type

  When using alembic to develop and manage the database, you will encounter a troublesome problem, that is, to change the enumeration type of a column. In fact, it is quite simple to use the sql command to change. An alter can be executed: ALTER TYPE status ADD val.

  2022-06-01 09:51:42 Views: 232
• 

  Use exp to export error EXP-00091

  The following error message appears when exporting data with exp: 1) query the character set of the database select userenv ('language') from dual;2) option 1: set the NLS_LANG environment variable of the Linux operating system [ora

  2022-06-01 09:51:36 Views: 214
• 

  Oracle instance crash, error message ORA-00600, ORA-27091, ORA-27072

  [failure phenomenon] on Feb. 8, 2015, oracle10.2.0.4 single instance database suddenly CRASH, but it was restarted and resumed. Check the alert.log log and find the following "ORA-00600, ORA-27091, ORA-270"

  2022-06-01 09:51:36 Views: 282
• 

  Optimized configuration of tomcat6 (refer to network resource arrangement)

  The optimization of Tomcat is divided into two parts: the optimization parameters in the command line of Tomcat startup, that is, the optimization of JVM optimization of Tomcat container parameters (this piece is very similar to ApacheHttp Server). The optimization of JVM first runs above JVM.

  2022-06-01 09:51:36 Views: 222
• 

  MySQL query optimization

  Query optimization common strategy 1, optimize data access: the application should reduce the data access to the database, the database should reduce the number of records actually scanned, for example, Redis cache, avoid "select * from table" 2, rewrite SQL for the need for a large number of

  2022-06-01 09:51:35 Views: 225
• 

  RMAN and EXP

  RMAN is a backup based on physical structure and a backup based on data blocks. It supports recovery operations with online redolog and archive redolog. It is a backup and recovery tool recommended by Oracle. DataDump (IMP/EXP,

  2022-06-01 09:51:35 Views: 252
• 

  Xtrabackup use case

  Backup users create CREATE USER 'bkpuser'@'localhost' IDENTIFIED BY' bkpuser';GRANT RELOAD, LOCK TABLES, PROCESS

  2022-06-01 09:51:35 Views: 236
• 

  Oracle internal and external connections

  First, Oracle connection type ☆ description: according to their own understanding of the type, is not the official definition. 1. Inner connection ① equivalent connection ② non-equivalent connection ③ natural connection 2, outer connection ① left outer connection ② right outer connection ③ full external connection 2, table data preparation t table field a field b1182283

  2022-06-01 09:51:29 Views: 261
• 

  The sql server key column information is insufficient or incorrect. Updates affect multiple lines. "

  Environment: windows server 2003 sp2,sql server 2000, software for managing fixed assets. Failure phenomenon: to add fixed asset information for two Cisco switches at the same time, because everything is the same model, but the serial number is different. In

  2022-06-01 09:51:25 Views: 239
• 

  Big data MongoDB 3.2.1 fragment

  There is another cluster of MongoDB sharding in Mongodb, that is, sharding technology, which can meet the needs of the massive growth of MongoDB data. When MongoDB stores large amounts of data, one machine may not be enough to store data, or it may not be enough to provide acceptable

  2022-06-01 09:51:18 Views: 202
• 

  Oracle data guard 11.0.2.4

  Oracle DataGuard is a data synchronization function that comes with Oracle. The basic principle is to transfer log files from the original database to the target database, and then apply these log files to the target database, so as to keep the target database synchronized with the source database.

  2022-06-01 09:51:18 Views: 274
• 

  Oracle adaptive cursor

  1 Adaptive cursor sharing Adaptive Cursor Sharing or extended cursor sharing (Extended Cursor Sharing) is one of the new features of Oracle 11g, which is mainly used to solve the previous version due to binding variable snooping.

  2022-06-01 09:51:18 Views: 298
• 

  Jeesz distributed Architecture-distributed High availability

  Copyright notice: this article is originally created by the blogger and may not be reproduced without the permission of the blogger. What is high availability HA (High Availability) is one of the factors that must be considered in the design of distributed system architecture. It usually refers to reducing the time when the system cannot provide services through design.

  2022-06-01 09:51:18 Views: 285
• 

  UniDAC usage tutorial (5): working in an unstable Network

  Download the latest version of UniDAC Universal Data Access Components (UniDAC) is a general database access component that provides direct access to multiple databases, such as Delphi for Windows, C

  2022-06-01 09:51:17 Views: 254
• 

  Introduction to Optimizer Statistics

  The optimizer cost model relies on statistics collected about the objects involved in a query, and t

  2022-06-01 09:51:14 Views: 259
• 

  Mongodb common commands

  1. Create database: use report delete database: use report, db.dropDatabase () 2. View the database: show dbs3. View table: show collections delete table:

  2022-06-01 09:51:05 Views: 292
• 

  The sql statement of the sqlserver database uses the

  T-SQL query statement 1. Tansact-SQL programming language American National Standards Institute (ANSI) and International Standards Organization (ISO) define standards for SQL. Microsoft uses Transact-SQL and ANSI-SQL compatibility, Transac

  2022-06-01 09:51:05 Views: 253