Database Administrator

Syntax Overview Analytic-Function PARTITION clause of Analytic_Clause Order by clause of Analytic_Clause Analyze wing clause of Analytic_Clause Example: The following is an example of a simple Syntax: Example:Sum (sal) over (partition by

Two days ago, we briefly learned about a special stored procedure-trigger. Today we want to write some simple theoretical and practical knowledge about the stored procedure. First, we need to understand what is a stored procedure and its

1. LBS geospatial IndexLBS-related projects generally store coordinates of the longitude and latitude of each location. If you want to query nearby locations, you need to create an index to improve query efficiency. Mongodb has created a geospatial

Various MySQL indexes (because most of them do not deliberately distinguish between search engines) INDEX (Common INDEX): the most basic INDEX with no restrictions Alter table 'table _ name' add index index_name ('column ') UNIQUE (UNIQUE index):

Mysql is connected to the job for one day. Finally, I decided to start learning jsp from scratch, saving me the trouble. After a full night of work, I finally connected the database. However, it's so sad that I even have a database... "> My

1. the following error is reported: [Oracle @ rac1 ~] $ Srvctl add service-d rac-s test-r "rac1"/U01/app/oracle/product/dbhome_1/jdk/jre/bin/java: error while loading shared libraries: libpthread. so.0: cannot open shared object file: No such file

When using virtual Lan (Vlan) in Vmwareesx/esxi, it usually refers to the use of Vlan Trunk. There are three other Vlan configurations:Virtual Switch Tagging(Vswitch label, abbreviationVST),External SwitchTagging(External switch label,

Zookeeper SQL Server online consultantsCame guest SS an interesting scenario where one of our client was unable to restore a native SQL Server backup successfully saved from one instance running on Machine A on another instance of SQL Server running

Recently deleted the archive log of DG, [oracle@.local logs]crontab -l* 8 * * * sh /home/oracle/dbscripts/del_arc.sh This script calls the three scripts that generate the delete verification respectively. cat del_arc.sh#! /bin/bashsource

Oracle recommends that the OLTP (on-line TransactionProcessing) system accounts for 80% of the total system memory, and then allocates 80% to SGA and 20% to PGA. That isSGA = system_total_memory * 80% * 80%PGA = system_total_memory * 80% * 20%1.

Source: Huang zhaoji CSDN blog: Why database version control is necessary?Preface Version Control is very common in the development process, but in the database World, Version Control is second-class or even third-class citizens. When many people

After receiving an alarm, the load was too high, reached 800%, and the load was too high, with 11 errors. MySQL version 5.6.12-log After 1, mysqld processes occupy all resources. 2. View error logs without any exceptions. 3 show eninge innodb

When the Oracle database is started, it encounters bad blocks, especially some underlying tables in the SYSTEM tablespace, such as UNDO $ and OBJ $, which may cause the database to fail to open normally, of course, you can add some hidden parameters

Cold backup (off, slow, time point recovery)Cold backup occurs when the database is shut down normally. When the database is shut down normally, it will provide us with a complete database. Cold backup is a way to copy key files to another location.

MOSOracle E-Business Suite Release 11.5.10 introduced support for the Oracle Net security feature, tcp. validnode_checking, which is used to prevent unauthorized Oracle Net access (for example via SQL * Plus) to the Applications database. if a node

Delete an Oracle database in a Linux operating system in detail: 1. Disable oracle server and background processesPs-ef | grep oraTurn off the databaseShutdown immediate  2. Disable the listener.Lsnrctl statusIf it is enabled, execute lsnrctl stop

The new feature of user rename is provided from Oracle 11.2.0.2. in earlier versions, If you need rename username, we generally use imp's fromuser, touser, and Data Pump impdp's remap_schemas. If we want to import a schema data to replace the

After entering the CBO optimization pipeline, the cost calculation value determines the selection of execution plans. An execution plan with good performance is based on the "appropriate" statistics as much as possible. CBO has gone through two

Oracle Vault is a complete O & M Security System Framework launched by Oracle. Vault is a good option among many O & M organizations. The principle of Oracle Vault is the split protection of security responsibilities. From the assumption that the

Running Environment: Primary: 192.168.111.150Standby: 192.168.111.15119425111.152os: CentOS5.8PostgreSQL: 9.1.2 or later. Streaming Replication is supported. PostgreSQL cache details Compiling PostgreSQL on Windows Configuration and installation of