Database Administrator

Check Oracle ASM disk groups In Oracle 11gR2, a new command is added to check the normally mounted disk groups. This facilitates the maintenance of the database in the asm mode. Applicable in the following scenarios: 1: The host server is routinely

SHMMAX Max in Linux x86 and x86-64 Systems SHMMAX Max in Linux x86 and x86-64 Systems Reference Original:Maximum SHMMAX values for Linux x86 and x86-64 (Document ID 567506.1) Objectives: Question:-bit (x86) maximum value in Linux system?Question 2:

Oracle ASM errors-ORA-15033 Oracle ASM errors-ORA-15033 System Environment: Operating System: AIX 5.3.8 Oracle: Oracle 10gR2 Fault symptom: SQL> create diskgroup datafile 2 normal redundancy Failgroup fg1 disk '/dev/rlv_data1' 3 4 failgroup fg2 disk

Oracle Database listening is very slow, and hang basically handles faults Tester email feedback:The connection to the database to be ordered is very slow, or even cannot be connected. I want to check it. View:Oracle @ wdatest11 :~

Oracle Data Pump details Comparison Between Data Pump and conventional method: Oracle introduces Data Pump at 10 Gb. Compared with traditional exp/imp, data pump can separate jobs, and can suspend and resume Import and Export tasks, you can restart

DBCP and C3P0 database connection pool, What is the database connection pool? All those who have learned about computer networks know that in an internal LAN, most of them use private addresses. To deal with external networks, they must have

[ThinkPHP learning] ThinkPHP automatically escapes and stores Rich Text Editor content, leading to read errors, RT. Convention. php In the conf file of ThinkPHP has a configuration option. 'Default _ filter' => 'htmlspecialchars', // The DEFAULT

Rman configure command, rmanconfigure command Record rman commands. Connect to the target database: BACK (DBID = 4048592102)Connect to recover directory database RMAN> 2> show all;         -- View ParametersRMAN configuration parameters:Configure

Common ORACLE commands and oracle commands 1. ORACLE startup and Shutdown1. In a single-host environmentTo start or shut down the ORACLE system, you must first switch to the ORACLE user, as shown below:Su-oracle A. Start the ORACLE SystemOracle>

ORA-00265: requires instance recovery and cannot set ARCHIVELOG mode work, restorearchivelogThe solution is as follows:From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProductionWith the Partitioning, OLAP and Data Mining options

[MySQL Case] ERROR 1418, mysqlerror1418 1.1.1. ERROR 1418 [Environment description] Mysql5.0.67 [Problem description] When creating a stored procedure, an ERROR 1418 is reported. # Create an SQL statement for a function Create function 'xxx' (num01

Full MySQl installation solution, MySQl Installation This is the second installation of MySql. It took several hours for the first installation to understand every page of the installation. This time, I found a few installation packages, so I felt

Blue growth notes-Chase DBA (3): antique operations, data import and export problems, dba Import and ExportBlue growth note-chasing DBA (3): importing and exporting data on antiques becomes a problem ************************************ Statement ***

Create different representation methods and operations for a single Linear Linked List, and create a linear representation Create a single Linear Linked List. Common Operations include the head insertion method and the tail insertion method to

The first introduction to Data Structures Based on previous experience, I found that reading a book, if I read a book a day or a day, I read a little at the end, so these days I decided to take a shot and read the book "Introduction to Data

Use the SSIS Slow Changing Transformation component to manage slowly Changing dimensions and ssistransformation Recently, I tried to use the Slow Changing Transformation component that comes with SSIS to process the Slow change dimension. As you can

[Translated from mos] When will the OGG extraction process obtain data from the database ?, MosdatabaseFor oracle databases, when will the OGG extraction process obtain data from the database?Reference Original:When GoldenGate Fetches Data From The

ORA-00911: Invalid character, invalid ora-00911 character An error is returned for a simple select statement! Solution: remove the semicolon ...... Why does this happen? Because I chose Test Window and selected the SQL Window below, there

ADO. NET 6-use Command to modify data in the database --- ShinePans, Source code: Using System; using System. collections. generic; using System. data; using System. data. sqlClient; using System. linq; using System. text; using System. threading.

[Database] basic usage of the ROW_NUMBER () OVER function, row_numberover (1) ROW_NUMBER () OVER (order by column) Generally, developers and administrators use temporary table and column-related subqueries in a query to calculate and generate row