Database Administrator

The recent customer email description failed to connect to the database from the client with the error code ORA-12537: TNS: connection closed, and the connection was closed. Directly through tnsping, there is no problem. The TNS-12518: TNS: listener

  Principle: (1) Use database link to establish a connection between the two databases. (2) create a stored procedure: delete all data tables, and insert the data table content of the production database to the test database. (Commit) (3) Use Jobs

A few times ago, the alert Log obtained the prompt that the Heap size exceeds the specified threshold, that is, Heap size 80869 K exceeds notification threshold (51200 K ). The threshold value has increased to 50 MB since Oracle 10.2.0.2.

Java Redis Jedis -- learning note code snippets -- serialization Wikipedia: Redis is an open-source, network-supported, memory-based,Key-Value Pair storage database, Which is written in ansi c. Its development is hosted by VMware. Redis is the most

Datastage jobs can use dsjob commands to call jobs or obtain job information, as well as running reports and logs.Under the directory where DataStage is installed, for example, C: \ Ascential \ DataStage \ Engine \ bin>The dsjob syntax is as follows:

1. JDBC connection to DB2 Copy codeThe Code is as follows:Class. forName ("Com.ibm.db2.jdbc.net. DB2Driver ");String url = "jdbc: db2: // dburl: port/DBname"Cn = DriverManager. getConnection (url, sUsr, sPwd ); 2. JDBC connection to Microsoft

This problem was encountered by a friend who made an SSIS program to import data to txt. Then, use Oracle tools to import data to Oracle. However, when executing the variable step in SSIS, it is found that the output column name is completely

Oracle users have relatively large permissions. Therefore, you may need to use non-oracle users to manage related databases. In particular, it is necessary for multiple individuals to add different users to the system or database, and then add these

Oracle databases can run in two modes: archivelog and noarchivelog ). The archive mode can improve the recoverability of Oracle databases. Production Databases should all run in this mode. The Archive mode should be combined with the corresponding

Data Files in Oracle databases have a feature that allows you to set whether to go offline. If you set the data file to offline, the database cannot read the data file. The database can read contents only when files are online. Therefore, changing

Recently, I have been asked questions about MySQL Query Cache. I just want to sort out some MySQL Query Cache content for your reference. As the name suggests, MySQL Query Cache is used to Cache Query-related data. Specifically, the Query Cache

In my previous work, I needed a brand new Access database. I could copy the database, or put the new database into the resource. I felt uncomfortable when I released the new database, or dynamic generation. To generate a database, you must use ADO

Recently, some netizens have been paying attention to CYQ. Data performance issues. Although they have been paying attention to, they have not found anyone who has actively Written Performance Evaluation articles with other frameworks. I am usually

When querying data, we usually need to specify the rows of data to be returned. For example, if there is a B/S architecture application, each page may display only 30 records. To improve the display efficiency, the database is generally required to

1. In the mysql compression directory, there is a bunch of parameter configuration files, such as: my-innodb-heavy-4G.ini, copy this file, change the name, such as: my. ini 2. Open the my. ini file and add the following parameter: [client]: add the

1) Prepare test data If you have less time to talk, go straight to the subject. Create a simple employee table t_hierarchical: Emp employee ID Direct superior of Mgr employees (Mgr itself is also an employee) Emp_name employee name Insert

BKJIA exclusive feature] MySQL Proxy is such a middle layer Proxy. Simply put, MySQL Proxy is a connection pool that forwards connection requests from foreground applications to the background database, by using the lua script, you can implement

This article introduces two stored procedures that are very useful in the master database but not mentioned in SQL Server online textbooks. These system processes are very convenient for processing the following tasks, such as determining the

If someone asks you to provide such data-How long does it take for volunteers who join the Organization to perform voluntary services within the year to answer this question? Also, how many activists do your organization have in a particular country?

The unique value insertion solution for unique columns in this article is mainly based on the MySQL platform. Through this, you can achieve some new functions and applications. I hope this article will help you. When a unique column inserts records