Database Administrator

1> User temporary default tablespace Switching -- Query the user's default temporary tablespaceSQL> SelectUsername,Temporary_tablespaceFromDba_users;USERNAME

I was overwhelmed by ASM recently. Yesterday I met a customer who used WIN2008 + RAC + ASM. Due to the storage problem of emc, the ASM instance has a problem and the data cannot be read, which leads to RAC problems. After two hours, I finally

In many cases, when we were Oracle DBAs, we were notified by our administrators that they were using very slowly and databases very slowly, when we go to the database, we do a few examples of Select and find the same problem, sometimes we will not

Software to be installed in advance: svn, apache2.2.x, and mysql5.1 Objective: To implement apache mysql Authentication through the mod_auth_mysql Module Download Software: mod_auth_mysql,: http://www.heuer.org/mod_auth_mysql/ There is a compiled

Sometimes, you can view the attribute statements of objects such as tables, storage, and triggers in the following two ways: 1. query the all_source table 2. Use the DBMS_METADATA Package. 1. Use the all_source table First, let's check which types

The biggest possible cause is that the database locks the table if the changed data is not committed! Therefore, when updating a table, do not use statements such as select * from a for update to easily lock the table. select *, t. rowid from t is a

1. Script and test procedure -- 1. Create a test tableCreate table tab_default (id varchar2 (2), default_sysdate date, default_char_date varchar2 (8), default_guid varchar2 (100 ));-- 2. Add the default value ConstraintAlter table tab_default modify

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> svrmgrlSVRMGR> connect internalSVRMGR>

1. After successful Oracle Installation, you will be prompted to change the password of the supervisor. If you do not change the default password of the account: Internal/oracle Sys/change_on_install System/manager Scott/tiger Sysman/oem_temp 2

This article describesFedora 1464-bitInstallOracle Database 11g Release 2 (11.2) 64-bit. This article is based on2G swap partition and SELinux disabled. The installation should also include the following packages:  Gnome Desktop Environment

ORA-03111 error, causing system failure Symptom Description: The system reports a "java. SQL. SQLException: ORA-03111" error at runtime. Problem Analysis: Locate the fault code in metalink. Document No. [ID 1219453.1] is similar to the customer's

// Sometimes, the result set and// Merge other sorted result sets (union or union all)// For example:Select * from tb where length (id) = 5 order by id descUnion allSelect * from tb where length (id) = 10 order by id asc// In general, the preceding

############################ Error symptom: ###############################The following error occurs when exporting data with 9i exp: F: \ Oracle \ bin> exp wssw/foresee @ cradle203 file = d: \ sb_sbxx_zb.dmp tables = sb_sbxx_zb Export: Release 9.2.

A. Check the standby statusSQL> select name, database_role, OPEN_MODE, SWITCHOVER_STATUS from v $ database;NAME DATABASE_ROLE OPEN_MODE SWITCHOVER_STATUS-------------------------------------------------------ORCLDB PHYSICAL STANDBY MOUNTED NOT

Oracle bad block processing script Applies:Oracle Database-Enterprise Edition-Version 8.1.7.0 to 12.1.0.1.0 [Release 8.1.7 to 12.1]Information in this document applies to any platform. GoalThe purpose of this plsql script is to create a new table

The following CMDB is the name of the db2 database. This article has been verified by the test environment. 1. Online Database Backup Archive not included:Db2 backup db cmdb online to [path name] Include archive:Db2 backup db cmdb online to [path

1. Introduction to Xtrabackup 1. What is Xtrabackup? Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup.Xtrabackup has two

At the underlying layer of Hibernate, SQL statements are still used to perform database operations. Although all relational databases support standard SQL statements, all databases have extended standard SQL statements, therefore, there are some

1. Recently, one rgion of hbase often fails. the following error occurs when you view the node log: 2014-02-22 01:52:02, 194 ERROR org. apache. Hadoop. hbase. regionserver. HRegionServer: Close and delete failed Org. apache. hadoop. hdfs. server.

Archive log is fullORA-00257: How to Handle archiver error. Connect internal only, until freed error1. Log On with the sys userSqlplus sys/pass @ tt as sysdba2. Check the location of the archiv log.SQL> show parameter log_archive_dest;NAME TYPE