Database Administrator

First, there is an info.txt file, one of which is as follows: FFF_GGG_FF | GOD | 254 | 254 | 16384 | 16384 | 254 | 254 | Next, create a table in Oracle with the following structure: SQL> desc info;TABLENAME VARCHAR2 (200)OWNUSER VARCHAR2

1. Download the Oracle 11g for Linux zip package from the 0 racle website and decompress it. 2. run. /runInstaller-jreLoc/usr/lib/jvm/java-6-sun/jre) To be continued ...... 3. The next step is all the way, but some of the dependent items must be

It has been a month since Oracle was installed on Linux. after hitting the wall several times, I finally successfully installed Oracle11g and Oracle10g. There is no time to write step by step. For those steps, see the ORACLE Installation Guide.

1. Replace DISTINCT with EXISTS to eliminate sort operation 2. If you filter data in group by, specifying conditions in the WHERE clause has better performance than HAVING clause. Because data has been filtered out before the GROUP, fewer rows are

To speed up transaction processing, Oracle adopts the read consistency mechanism. When data is not submitted after a session is updated, other sessions read the results before the update. This greatly improves the efficiency of data concurrency, but

Some want to run database operations at a specified time. If these operations are performed on the WEB Front-end, server resources will be wasted, because the web page needs to be refreshed constantly and then determined to execute the operation...

This article mainly refers to the installation tutorial of Oracle-base for translation. However, due to the awkward translation of the English language into Chinese, his article also contains imperfections, I will adjust it slowly. Now this article

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

Purpose of a crosscheck command If the backup is damaged or does not exist on the disk and the backup set is still recorded in the rman database or the archive is available, you need to run crosscheck to perform cross-validation to update outdated

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.

I. Weblogic planning: Server Name Port Ip Remarks Xyyadmin 7001 10.10.54.74 Manage servers App01 8001 10.10.54.74 Application server belongs to node Management 2. For weblogic installation,

1. MySql + Memcached architecture Problems MySQL is suitable for storing massive data. Many companies have used this architecture to load hotspot data to the cache through Memcached to accelerate access. However, as the business data volume

Note: The database should be supported in the archive mode. 1. Back up the SYSTEMG tablespace.[Oracle @ bys001 ~] $ Rman target/Recovery Manager: Release 11.2.0.1.0-Production on Tue Sep 17 10:42:18 2013Copyright (c) 1982,200 9, Oracle and/or its

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

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

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

Abstract: This article summarizes some common MySQL problems, solutions, and suitable use cases and optimization solutions. Directory: Storage engine Selection: MyISAM vs InnoDBUse and OptimizationDatabase OptimizationSQL OptimizationApplication

Required dependent LibrariesConfig: IniFilesMIME: LiteDBD: mysqlDBISys: SyslogWe recommend that you use CPAN for installation. First, obtain the global read lock, write the data in the cache to the disk, then execute the LVM snapshot, and finally

Redis list-type operations 1> stack features: first-in-first-out, and later-in-first-out2> queue features: FIFO and FIFOA List is a linked List structure that can be used as a stack or as a queue to process data.Lpush mylist "world" // put world to