Database Administrator

When to use Oracle partitioning:1. Large Data Tables, such as tables larger than 2 GB. On the one hand, a 2 GB file is an upper limit for 32-bit OS, and the backup time is long.2. tables that contain historical data, such as the latest data, are

Installation environment:System: RHEL 5. Select Chinese during installationHardware environment: P4 3.4G, 2G memoryDisk Partition: boot: 100 M; swap: 1998 M; all others are/partition;Oracle uses 10201_database_linux32, 1. RHEL Environment1. Install

Objects in sys users cannot be exported. SQL> select owner, segment_name, tablespace_name from dba_segments where tablespacE_name = 'users '; OWNER SEGMENT_NAME TABLESPACE_NAME------------------------------------------------------------SYS

1. Exceptions. When Hibernate is used as the project persistence layer, an extension is required for a table. The extension operation is to create a trigger for the table. Read data from a table into other tables. The SQL statement is as

1. Install the make Compiler (default system) : Http://www.gnu.org/software/make/ Tar zxvf make-3.82.tar.gzCd make-3.82./ConfigureMakeMake install 2. Install bison : Http://www.gnu.org/software/bison/ Tar zxvf bison-2.5.tar.gzCd

Modifying db_recovery_file_dest causes flashback off. Error reported during startup [Oracle @ node3 dbs] $ srvctl start instance-d momorac-I momo1 PRCR-1013: Failed to start resource ora. momorac. db PRCR-1064: Failed to start resource ora. momorac.

RHEL6.4 _ 64 install a single instance Oracle 12cR1 Pre-Installation Install dependency packages Yum-y install libXp. x86_64 libXp. i686 elfutils-libelf.x86_64 elfutils-libelf-devel.x86_64 compat-db.i686 compat-db.x86_64 libstdc ++-devel. i686

1. How Does Oracle determine the new and old control files?1. Under normal circumstances, the control file seq # (controlfile_sequence #) is greater than or equal to the control file seq recorded in the data file header # (fhcsq) the control file

In actual programming and development, we often need to process the storage of large-capacity binary data, such as slices or music. For these binary data (blob fields), we cannot simply insert or query the data as if we were dealing with common text.

We need to install 64-bit weblogic to improve performance on 64-bit servers. I often see someone asking on the Internet: Is weblogic 64-bit? Does weblogic need to be cracked? Weblogic has a dedicated 64-bit version. Here, weblogic11g is installed,

RMAN is a backup recovery tool provided by Oracle. In fact, using SQL combined with OS commands can also execute Backup recovery, which is more flexible, but it is better for beginners to use rman; Rman manages backup, dumping, and recovery

1. More processes than single-instance databases in RAC: LMS-Gobal Cache Service Process global Cache Service ProcessLMD-Global Enqueue Service Daemon Global query Service DaemonLMON-Global Enqueue Service Monitor Global query Service monitoring

Sometimes it is a big mistake to study seriously. As long as you learn to treat one thing with impetuousness, this will treat you the same way.Let's take a look at my miserable 1 hour.The problem is that I create a table:SQL> create table

If statement for Oracle process control: DeclareStr varchar2 (3): = 'abc ';BeginIf (str = 'abc') thenDbms_output.put_line ('abc ');Elsif (str = 'bc') thenDbms_output.put_line ('bc ');ElseDbms_output.put_line ('others ');End if;End; Loop Statement of

Full-link initialization standardization process: 1) Verify synchronization link connectivity Run the info extract/pump/replicat and detail commands to check whether the trail files and checkpoints of each process in the synchronization link are

1. Enable event tracking 10046Alter session set events '2017 trace name context forever, level 12 '; 2. Execute an SQL statement at Will (we will find the execution of this SQL statement in the trace file)Select * from dba_users where username = 'hr

In the Innodb deadlock case, paste the case information first: * ** (1) TRANSACTION:TRANSACTION 52ed1_61, ACTIVE 0 sec insertingMysql tables in use 1, locked 1Lock wait 3 lock struct (s), heap size 1248, 2 row lock (s)MySQL thread id 34815573, OS

How to view the definition of tables, views, indexes, stored procedures, and triggers in Oracle View table definitions: Sets long 999999 Select dbms_metadata.get_ddl ('table', upper ('& table_name') from dual; View the view definition: Select

Arraysize defines the number of rows returned to the SQLPLUS client at a time. After scanning the arraysize row, stop scanning, return data, and continue scanning. This process is the SQL * Net roundtrips to/from client in the statistics. Because

Timer settings for Oracle users [Oracle @ SHARKDB dbscripts] $ crontab-l# Minute hour day month week15 1 ** 0 sh/home/oracle/dbscripts/backup_full.sh05 3 *** sh/home/oracle/dbscripts/del_arc.sh The full backup script first configures the retention