Database Administrator

1.1 symptom description Abnormal power failure: the database data file status changes from ONLINE to RECOVER. The system displays the following information: SQL> select file_name, tablespace_name, online_status from dba_data_files; FILE_NAME --------

Yesterday I explained how to set scheduler parameters. Today I want to explain how to set scheduler jobs. First, let's take a look at the basic creation script: Sys. dbms_scheduler.create_job ( Job_name => '"SYS". "REBUILD_JOB1 "', Program_name => '"

The foothold of this article is not a data mining-based algorithm or some detailed algorithm implementation. I have already written a lot of details about this in some blog posts, but at first we saw this pure technology blog, some formulas and some

This section describes free lists and shared pool lru list.1. The chunk size in the shared pool is different, but it is continuous.2. Because the chunk is the smallest unit for allocation, the session will apply in chunk units when it needs to

Inadvertently found this good tool from a blog abroad, can't wait to recommend to everyone this completely free SQL intelliisense Prompt tool (http://www.red-gate.com/products/ SQL _prompt/index.htm), preliminary use, it can indeed improve

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:

I. PL/SQL programming specification in case Just like in SQL, PL/SQL is case-insensitive. The general principles are as follows: Keywords (BEGIN, EXCEPTION, END, if then else, LOOP, end loop), data type (VARCHAR2, NUMBER), internal function (LEAST,

Flowdock is a Web-based team communication tool. all software developers should use it for communication, rather than using tools such as Campfires, Skype Chats, or IRC. because it can better support their real workflows. Last week, we made a

This article describes how to bind data in batches through DataBinder and how to solve common data binding problems, such as data formatting. Next, let's talk about the design of DataBinder to see how it binds the attribute values of the data source

Basic concepts of database computers: Database computerDatabasecomputer) is a dedicated computer system that stores, manages, and controls databases. It can quickly and effectively complete various database operations and adapt to the management of

Overview Like other advanced languages, the T-SQL also has statements used to control the flow. The flow control statement in the T-SQL further extends the power of the T-SQL ...... This allows most of the business logic to be performed at the

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

Best practices and technologies involved in data loss Protection (DLP) on mobile devices are designed to protect data that leaves the corporate security barrier. Data may be damaged or leaked in various ways: the device is stolen, the authorized

Many of my friends only use oracle to delete the system. However, in many cases, he may find that the next installation page disappears when the system is re-installed, and he may have to reinstall the system, in fact, this is not the case if your

This article discusses how to improve the performance of MySQL databases, and provides specific solutions from eight aspects. 1. select the most suitable field attribute MySQL can support access to large data volumes, but generally, the smaller the

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?

Currently, the following technologies or solutions are available for remote replication and Disaster Tolerance of oracle databases: 1. Storage-layer-based disaster recovery replication Solution The replication mechanism of this technology is based

Specifically, you can monitor the image database: Verify that the image is running. The basic status includes checking whether the two server instances are running normally, whether the servers are connected, and whether logs are migrated from the

Although SQL Server 2008 is now a new database system. However, it will be updated in the future. Therefore, when deploying SQL Server 2008, the database administrator still needs to consider backward compatibility issues. To reduce the trouble of