Database Administrator

I. Oracle Database default tablespace settings DBAs often encounter such a headache: they do not know who created a user in Oracle and did not specify the default tablespace for this user, therefore, this user will use the default tablespace-system

Oracle has db_block_size and the operating system also has block size. The following is a brief introduction. AIX: View the size of each block in the AIX operating system: # Lsfs-q/u01 Name Nodename Mount Pt VFS Size Options Auto

Jcq0> show userUSER is "SYS"Jcq0> create tablespace dictionary_t2 datafile 'd: \ Oracle \ ORADATA \ DB_NAMEX \ dict. dbf' size 50 M3 extent management dictionary4 default storage (initial 100 k next 100 k );Create tablespace dictionary_t*ERROR is

Guidance: MySQL has four transaction isolation levels: Read-uncommitted, Read-committed, Repeatable-read, and Seriailizable. I believe everyone knows their similarities and differences, if you are not clear, you can refer to another technical

Audit FunctionThe database is in the mount status.SQL> alter system set audit_file_dest = '/u01/gdrz/' scope = spfile;(Set the Audit Directory)System altered.SQL> alter system set audit_trail = db, extended scope = spfile;System altered.[Oracle @ bw

Create or replace procedure PD_GENERATE_HELP_LAST_TABLES IS-- Generate a local data table for the view vw_last_xxx generated from sqlserverTabNocount NUMBER;V_ SQL VARCHAR2 (200 ); BEGIN-- Judge the table dat_help_last_scqy1)SELECT count (*) INTO

After mysql is installed in Linux, mysql is generally added to the Automatic startup list: Add/usr/local/mysql/bin/mysqld_safe -- user = mysql & This usually brings a lot of convenience to users, but my Linux system suddenly gets stuck when the

A ORA-01555 error was found during database security check: This SQL statement is obviously not completed after running for a long time. In the Statspack report, this SQL statement is also on top.SQL occupies a large amount of db cache. Large

---- Query table space usage --- SELECT UPPER(F. TABLESPACE_NAME)"Tablespace name", D. TOT_GROOTTE_MB"Tablespace size (MB )", D. TOT_GROOTTE_MB-F. TOTAL_BYTES"Used space (M )", TO_CHAR (ROUND (D. TOT_GROOTTE_MB-F. TOTAL_BYTES)/D.

In Oracle, if the table data volume is large (M-level or larger), updating a field is very slow (for example, updating the historical business process table in my HIS project, 1.6 million records, use CURSOR to update, 1000 COMMIT once, it took four

OraToolKit is a tool used to support and quickly deploy various Oracle software environments and support different versions of databases and operating systems. This toolkit also contains a more practical rlwrap. Everyone knows that sqlplus in linux

WHEN handling exceptions, pay special attention to the use of when others then, because when others then will eat all the exceptions. If no information is thrown after when others then, that is, when others then null, this may greatly increase the

How does one install the MongoDB database in Linux? Follow these three steps to install MongoDB in Linux. Read more: Install and start MongoDB in LinuxStep 1: download an object For 32-bit linux $ Curl

Test Code: DECLARE BEGIN -- Most normal way to handle exception. DECLARE Except_test0 EXCEPTION; BEGIN RAISE effect_test0; EXCEPTION WHEN effect_test0 THEN Dbms_output.put_line ('Test0 effect_test0: SQLCODE ='| SQLCODE | ', SQLERRM ='

Obtaining execution plans and execution costs and writing the optimal SQL statements are required by each Oracle Developer and dba. After Oracle 11g is passed, auto trace is automatically enabled for dba role by default? Configure autotrace: Enter $

Problem: A Streams exception is found in the source database, for example: Check: select * from dba_capture. An error is returned. ORA-26744: STREAMS capture process "CAPTURE_STREAM" does not support "BHOMSWAS". "DBMS_TABCOMP_TEMP_UNCMP" because of

By default, the Oracle view does not have a primary key. Therefore, when a java class is generated in reverse direction using hibernate, a composite primary key is automatically used to generate a class name + ID, Which is troublesome for later

An error occurred while backing up CentOS 5.6x64: RMAN> backup archivelog all format = '/opt/Oracle/backup/arch _ % T _ % s _ % p. Bak ';Starting backup at 31-AUG-11 Using target database control file instead of recovery catalog Allocated channel:

Like other programming languages, Oracle also has data types. Oracle has two main application scenarios: one is to specify the type of columns in a data table, and the other is to declare variables in PL/SQL programming. Oracle data types include

Flashback is based on the content in the undo segment. Therefore, due to the undo_retenton parameter, to use the flashback feature, you must enable automatic tablespace revocation. Oracle flashback data archive (FDA) is a new feature in Oracle11g.