Database Administrator

Today I received a strange fault and found that some packets are running normally on NODE1, and then the execution on NODE2 reported a ORA-04068 error. however, check whether the STATUS of DBA_INVALIED_OBJECTS is normal. (because some packages in

Introduction: the parallel technology belongs to the big data field and is suitable for OLAP systems. It is widely used in scenarios such as task division, data block division, and abundant resources, this article focuses on six points, including

Oracle Database Connection and calling of Stored ProceduresCreate table chengji (id number, xing_ming varchar2 (25), yu_wen number, shu_xue number)-- Query All Information select * from chengji-- Stored procedure with no return value typeCreate

When I first came into contact with SQL Server, I thought that SQL Server would update statistics while changing data. In fact, SQL Server did not. based on performance considerations, SQL Server uses the following algorithm to update

0. Preparations-- Create the transferred tablespaceSQL> create tablespace tbs_singleDatafile 'C: \ Oracle \ oradata \ ora9i \ tbs_single01.dbf' size 100 MExtent management local;-- Create a user and use the tablespace as the default tablespaceSQL>

The group by Statement supports basic having conditions and provides information aggregation functions for rollup and cube, similar to subtotal. Rollup: vertical subtotal, which summarizes each column one by one from right to left and generates an

In the previous article, Understanding the basic concepts of redo log (1) Media recovery and instance recoveryUnderstanding redo (2) redo content: change vector and redo entriesUnderstanding redo (3) explain an update processUnderstanding redo (4)

// The extract () function in Oracle is introduced from oracle 9i to extract specific parts from a date or interval Type// Syntax:EXTRACT ({YEAR | MONTH | DAY | HOUR | MINUTE | SECOND}| {TIMEZONE_HOUR | TIMEZONE_MINUTE}| {TIMEZONE_REGION |

Oracle system cannot log on. My own problems are summarized as follows: First, access sqlpuls as SYS DBA Enable sqlpuls SQL-> enter the User name: sys as sysdba SQL-> password (old password ): Query the DBA user status after successful logon.

[Oracle @ www.bkjia.com ~] $ Export ORACLE_SID = + ASM2[Oracle @ www.bkjia.com ~] $ AsmcmdConnected to an idle instance.Sh:/u01/app/oracle/product/11.2.0/db_1/bin/clsecho: No such file or directory This error is caused by an incorrect environment

When a customer updates data, the database content is deleted by mistake, because the database is master-slave, but not backup (backup is very important !) Fortunately, the bin-log is enabled, and the entire log record has to be taken back to the

A. Use impdp and network_link 1. Create a db link in the target databaseCreate public database link hrtestdb connect to system identified by 1234 using 'hrtestdb '; Impdp system/1234 network_link = hrtestdb schemas = BMCCZHPUSR; 2. Create a

1. Description of mysql_install_dbWhen the MySQL System Database (mysql System Database) fails or a new mysql instance needs to be added, You need to initialize the mysql

1. Consistentgets description When we use autotrace to view execution plans and statistics, the following information is displayed: 0 recursive cballs: recursive call. General cause: dictionary cache miss; dynamic storage expansion; PL/SQL statement

When Oracle 11gR2 11.2.0.2 RAC is installed on Linux today, the following error is reported. By querying the log file content, the following prompt is displayed: INFO:   11rac2,11rac1 

After Postgresql is installed using the Fedora package management tool, it cannot be automatically started by the random device. Today, I spent some time reading some related documents and finally found a solution. In fact, it is also very simple.

MySQL 5.0.37 and later versions support PROFILING debugging, allowing you to learn more about resource consumption of SQL statements. Because it needs to call the system's getrusage () function, it can only be used on Linux/Unix platforms, rather

SQL Server provides the sp_monitor stored procedure for you to view SQL Server performance statistics, including CPU, Network, and IO. With this information, you can have a general understanding of your database performance. The following example

As shown below, 1. Restore the database test to the data volume first.2. Then shudown test. copy all datafiles, tempfile, and redofile to the yldata volume.3. Use pfile, open test Library, copy pfile --> ylpfile to change the ylpfile of the

1. Problem description: Open sqlplus and log on with the system role Switch to scott user and switch to sys D:/> sqlplus sys/admin @ orcl as sysdba Next, the following error occurs: "TNS: The Listener cannot distribute client connections" 2.