Database Administrator

A buddy in Shanghai asked me that I had not finished running an SQL statement for four hours. I was so sorry, I was asked to optimize it. I really admire him. If I ran for a few minutes, I wouldn't be able to stand it anymore. The SQL statement and

There is no formal Sleep for calling after a good batch processing. Sometimes, it is really boring. 1. Method 1: Ping 1.1.1.1 to simulateIt is difficult to find an answer (called an answer because it is labeled as answer) from stackoverflow: Ping 1.1

1. Before designing the database (demand analysis stage)1) understand customer requirements and ask users how to view future demand changes. Ask the customer to explain their needs, and as the development continues, ask the customer frequently to

1. SQL server 2000 database connection method:Copy codeThe Code is as follows:Connection con;Public Connection getCon (){Try {Class. forName ("com. microsoft. jdbc. sqlserver. SQLServerDriver"); // load the driverCon = DriverManger. getConnection

However, in the projects I have experienced, some database design problems may exist, especially the two points that will be described below. I personally think this should be avoided, summarize and discuss with you. Alternative Field Symptom

Different from MYSQL, POSTGRESQL has a dedicated partition table, while POSTGRESQL uses its object-oriented features for partitioning. Next we will give you a simple experience. Create a parent table first. Remember, all partition tables must

When the Replicat process reports errors during DML operations, GoldenGate provides a parameter to control how to handle errors of the Replicat process. This is the reperror parameter to be introduced in this section. This parameter can control most

Merge is a very useful function, similar to the insert into on duplicate key in Mysql.Oracle introduced the merge command in 9i,With this merge, You can execute the inserts and updates operations on a table in an SQL statement at the same time. of

Error description: 13/09/12 17:59:00 ERROR security. userGroupInformation: PriviledgedActionException as: leo cause: java. io. IOException: Failed to set permissions of path: \ tmp \ hadoop-leo \ mapred \ staging \ leo480143202 \. staging to

SQL> select process, status from v $ managed_standby; PROCESS STATUS---------------------ARCH CONNECTEDARCH ERRORRFS IDLERFS IDLE Check parameter and find log_archive_dest_state_2 sets ENABLE. Because no switch over is performed, this parameter is

--********************** -- Use of DBVERIFY --********************** Oracle cannot be identified in Oracle format or its contents are damaged due to hardware faults or operating system faults during Oracle database operation. Fault, which can be

1. System Directory 650) this. width = 650; "src =" http://www.bkjia.com/uploads/allimg/131229/212S43161-0.jpg "title =" 201303281601320.6.jpg" alt = "093838365.jpg"/> 2. logical volume Management Before learning how AIX processes the file system,

2.3 use basic commands 12. cat command It is used to display the file content on the standard output, but does not update the file. The syntax is cat + file name. For example, to display the content of the/home/long/example.txt file, run the

I. Overview 1. Why Data Compression? The performance of SQL Server depends mainly on the disk I/O efficiency. Improving the I/O efficiency means improving the performance of a program. SQL Server 2008 provides the data compression function to

This installation of RAC is a little rough ..... Prerequisites for installing a RAC Add NIC: Connection Method host-only Configure the ip Address: Node1Eth0: 192.168.0.2Eth1: 192.168.1.3Vip: 192.168.0.10Node2Eth0: 192.168.0.3Eth1: 192.168.1.4Vip: 192

Recent learning highlights: 1. oracle performance optimization, especially waiting for the publication of Cui Hua's book. It is estimated that this month's renewal will be available next month. Statistics, execution plans, SQL profile, index

I have been on vacation recently. I have not written a blog, but I still have the last day in my eye. The time is really fast. Today I want to talk about database security. For database security issues, first of all, important generated databases

I recently carefully read the Clean Code Clean path when I was busy with public transportation. I once again admire Uncle Bob's humorous essays and his unique views and perspectives. What impressed me most was Uncle Bob's explanation of the data

I. queue and shared resourcesShared resources can be accessed by multiple sessions and processes at the same time. Therefore, its access needs to be protected. In Oracle, everything except PGA includes memory, disk, CPU, table, index, and

Chapter 3Create, update, and delete documentsInsert new document: Db. foo. insert ({"bar": "baz "}) My understanding: database. Set. insert ({key: value })Note: The insert speed is faster than that of data inserted at a time,