Database Administrator

Use of the Oracle 11g show spparameter command When we want to obtain the current parameter value of the Oracle database, we can query the dynamic performance view of v $ parameter. Of course, we can also use the show parameter p_name method.

PostgreSQL9 connection information to the database To connect to the database, sql9 must provide the following parameters: Host or host address, port number, database instance name, user name, and user password. When you log on to the server, you

Error handling during Oracle database installation [INS-35172] The following error is reported when Oracle is installed on the desktop when SGA is assigned:[INS-35172] Target database memory (XXMB) exceeds the systems available shared memory ({0}

SQL Server database user permission settings In SQL Server 2005 databases, we can set permissions for each user to improve database security. This type of user permission settings are widely used. For example, you can set a user's permission to

Database performance exception and slowness caused by full archiving of Oracle logs When the database performance is abnormal and slow due to full archiving of Oracle logs, I did not view the alarm log and thought it was because the lock blocking of

MongoDB common optimization settings in Linux Below are some common optimization settings recommended by MongoDB. Selecting an appropriate parameter value in the production environment, such as the preread value and the number of default file

Summary of the hit rate query statements of the Oracle database 1) hit rate of Library CacheFormula: Library Cache Hit Ratio = SUM (PINHITS)/SUM (PINS)Select sum (PINHITS)/SUM (PINS) from v $ LIBRARYCACHE; The hit rate cannot be lower than 99%.

Oracle client simple connection error ORA-12154, TNS-03505 Environment:Server: RHEL6.5 + Oracle Server 11.2.0.4Client: Win2003 + Oracle Client 10.2.0.11. symptom 2. Troubleshooting 3. Solve the Problem 1. symptom The Oracle database is installed on

ORA-06502 appears when an AWR report is generated The following error occurred recently when generating an AWR report for a system: ORA-06502: PL/SQL: numeric or value error: character string buffer too small, then the process of generating the AWR

The "pitfalls" and key points encountered during Oracle RAC installation (I), oraclerac When using virtual machines to build the RAC environment on a physical machine, many "pitfalls" and key points are encountered.   Physical Machine: Intel (R)

SQL Server multi-point timely backup techniques, SQL Server multi-point backup To ensure database security, we plan database disaster recovery policies, includingLocal backup, remote backup, raid, Or useHigh Availability(Such as log transmission,

Beckham _ mysql table optimization and Beckham _ mysql OptimizationMysql table OptimizationBrief:I. analysis tableIi. ChecklistIii. Optimization tableIv. Table Data Import5. Table lock operationsI. analysis table 1.1. command: ANALYZE

What is Spark ?, Spark? What is Spark? Spark is an open-source cluster computing system based on memory computing. It aims to make data analysis faster. Spark is very small and exquisite. It is developed by a small team dominated by Matei at the

Beckham _ mysql partition instance and Beckham _ mysql instanceMysql partition ExperimentBrief: 1. Create partitions Based on the partition type 2. Manage partitions 3. Examples of partitions and unpartitioned tables   1. Create a partition. Use

Windows operating system logs when a hard disk suddenly drops out of the disk in windows 7, and Windows 7Environment: three desktop hard disks (sata3 Interface) are connected to the same desktop without raid, one of which is hard disk (Note: Not a

ORA-16014 and ORA-00312, ora-16014ora-00312 Scenario: SQL> alter system archive log current;Alter system archive log current*Row 3 has an error:ORA-16014: log 2 sequence #34 Unarchived, no available destinationORA-00312: Online log 2 thread 1: '+

Powerdesigner 16.5 View display, powerdesigner16.5 At noon today, in order to explain the drawing, we turned off toolbox and object brower. It took us one hour to find toolbox. 1. object brower display Use the shortcut key ALT + 0 2. toolbox

For Mysql Enterprise Audit plugin, auditplugin As in the previous article, if you want to know who has logged on to your database server and what has been done, you need to use Mysql Enterprise Audit plugin. The following describes how to use Mysql

ORACLE management-view users with DBA roles, oracledba 1. view All users: select * from dba_users; select * from all_users; select * from user_users; 2. view system permissions of users or roles (system permissions assigned to users or roles):

MongoDB sharding algorithm, mongodbsharding There are two main types: range division by numerical values and hash, which are somewhat similar to the memcached cluster mechanism. The following table compares the advantages and disadvantages