Database Administrator

Create partitions on the 11g virtual column of Oracle On Oracle 11g, partitions can be performed on virtual columns. This feature is useful. Let's perform a test: SQL> select * from v $ version; BANNER-------------------------------------------------

Oracle index management After the database has been running for a period of time, due to frequent addition, deletion, and modification, the index will produce fragments, and the query efficiency will naturally be affected when the fragmentation

The display of MySQL execution plan does not match the execution process The process of creating a table and phenomena is as follows: Create table t1 (id1 INT, a1 INT, b1 INT, primary key (id1 ));Create table t3 (id3 int unique, a3 INT, b3 INT

Considerations for MySQL memory usage and Optimization1. read data from memory in microseconds. Read data from a disk in milliseconds. They differ by an order of magnitude. So to optimize the database, the first thing to do is to optimize io.2. The

[DataGuard] DG Series I. New Features of the physical standby Database 1. The physical standby database can be queried in real time. In the physical standby database before the Oracle 11g, the Standby database can be opened in read-only mode, but

Deleting temporary tablespace ORA-25152 Error Deleting temporary Oracle tablespaces or shrinking temporary tablespaces often results in table space occupation. Next we will handle this situation, First, find the locked sid: SELECT a. INST_ID, B.

Mysql development practice 8 Q: How many can you hold ?, MysqlholdRecently, the project has been heavily reliant on databases. I sorted out the eight representative questions that Mysql encountered during this period. The answers are also biased

Oracle creates a tablespace and users to test it. oracle creates a tablespace. First, describe the table space as follows: Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed

User 'nt AUTHORITY \ NETWORK service' Login Failed ., Authoritynetwork Step 1: Add 'nt AUTHORITY \ NETWORK Service' to the Administrator GroupMy computer --> right-click --> Manage --> local users and groupsSelect "group" --> double-click

Kettle and kettleZookeeper Access the previous row of data in kettle In kettle, many users use the features of javascript steps when they need to access the first row of data in the data stream. In fact, it is not necessary to say that the

Oracle Database optimization and optimization steps Identify the current status of the system System server model CPU speed and quantity Memory size I/O device status Network Conditions Number of system users and number of concurrent

Basic commands for oracle tablespace, basic commands for modifying the data table structure, and oracle Data Basic table space commands -- Create a tablespace. The initial size is 10 MB, and the maximum size is 5 MB. the maximum size is 50 MB.Create

Atitit. Concurrency test solution (2), atitit Solution Atitit. Concurrent Test Solution (2) ----- obtain random database records and randomly extract data for random sorting   1. Application Scenario 1 2. Principles of random data extraction 1 3.

Use PRODUCT_USER_PROFILE To Limit User, productprofileThe PRODUCT_USER_PROFILE (PUP) table provides product-level security that supplements the user-level security provided by the SQL GRANT and REVOKE commands and user roles. to create the PUP table,

Summary of SQL video and summary of SQL I still like short videos in English for 7 to 8 minutes. The VB videos of Mr Chen Wei and the SQL videos of Mr Yan jianling are all between 30 and 40 minutes. One tomato is not enough and two tomatoes are not

, 201424Beginner Stored Procedure DELIMITER // defines the terminator in the write stored procedure // Create a stored procedure 1: Create procedure proce_userinfo (in name varchar (10), int pwd varchar (10), out flag int) Begin Select power from

PHP operations on memcache and phpmemcache class myMemcache {private $ memcache; /*** it is generally recommended that these two values be made into constants */public function _ construct ($ host = '2017. 102.1.8 ', $ port = 6379) {$ this->

Write hive udfs and hiveudfs1. Configure the environment 1. Introduce the jar package: hive-exec-0.8.0.jar and hadoop-core-0.20.2.jar2. Compile udf function 1. extends UDF2. redefine UDF evaluate function. Package com. qunar. hiveudf; import java.

Alter constaints, alterconstaints 1. Create a federated primary key Alter table name add constraints end name primary key (column name, column name ..); 2. New Characters Alter table name ADD (column datatype [default value] [NULL/not null]);

Select to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss'), to_char (trunc (sysdate), 'yyyy-mm-dd hh24: mi: ss ') from dual t; -- sysdate and trunc (sysdate) are different. sysdate at 00:00:00 of the current day is equal to trunc (sysdate) select trunc