Oracle object-oriented and set

Oracle object-oriented and set This is a summary of my recent learning experience. 1. Oracle object-oriented We all know that SQL is set-oriented, but it is undeniable that there are many places in oracle that reflect the object-oriented thinking.

Simple installation steps for Oracle 10gR2 Clusterware

Simple installation steps for Oracle 10gR2 Clusterware 1. Install the Operating System (omitted)Note: I use the OEL 5u5 version here. Because it comes with the environment variable installation package provided by Oracle, It is very convenient to

Oracle Database Connection detection (Shell)

Oracle Database Connection detection (Shell) Version 1 Oracle Database Version: Oracle Release 10.2.0.1.0 System Version: Red Hat guest iselinux 5.4 2 detection steps 2.1 write Shell scripts Edit the check_oracle_connection.sh script for a user with

Use PL/SQL to connect to Oracle without installing the Oracle client

Use PL/SQL to connect to Oracle without installing the Oracle client Want to connect to the Oracle database? Install the client. OH ~ NO !, A few hundred megabytes are missing. Now you only need to download a software named Instant Client Package

Parameter configuration for MySQL Performance Optimization

Parameter configuration for MySQL Performance Optimization 1. Purpose: Modify the MySQL System Parameters Based on the current status of the server to reasonably utilize the existing resources of the server and improve the MySQL performance. 2.

Compile and install MySQL 5.6.22 in CentOS 6.5

Compile and install MySQL 5.6.22 in CentOS 6.5 Compile and install MySQL 5.6.22 in CentOS 6.5. I. Preparations before MySQL compilation and Installation Install the tools and libraries required for compiling the source code. (do not make any

Basic tutorial on getting started with Redis

Basic tutorial on getting started with Redis Redis is an open-source, advanced key-value storage perfect solution for building high-performance, scalable Web applications. Redis inherits three main features from its many competitions: The Redis

Connect to the Oracle database without installing the Oracle client in Linux

Connect to the Oracle database without installing the Oracle client in Linux Connect to the Oracle database without installing the Oracle client in Linux 1. mkdir-p/opt/oracle2. cd/opt/oracle3. Go to the oracle official website to download the

Overview of Oracle DB partition features Overview of Partitions

Overview of Oracle DB partition features Overview of Partitions Overview: in Oracle databases, partitions can break into very large tables or indexes into small, manageable blocks ), these blocks are called partitions ). each partition must have

MySQL import data load data infile usage

MySQL import data load data infile usageMySQL import data load data infile usage basic syntax: load data [low_priority] [local] infile 'file _ name txt '[replace | ignore]Into table tbl_name[Fields[Terminated by 'T'][OPTIONALLY] enclosed by

Oracle Database Upgrade (10gR2 to 11gR2)

Oracle Database Upgrade (10gR2 to 11gR2) I have a general understanding of Oracle Database Upgrade today, but there are still many things worth considering. First, preparations before the upgrade require a lot of work: 1. Testing and preparation,

Oracle 11.2.0.4 the time when RAC logs are recorded is inconsistent with the operating system time.

Oracle 11.2.0.4 the time when RAC logs are recorded is inconsistent with the operating system time. After Oracle 11.2.0.4 RAC is set up and the time zone is changed at the system level, it is found that the RAC log records are inconsistent with the

MySQL master-slave replication configuration based on binlog

MySQL master-slave replication configuration based on binlog The last time I configured the master-slave replication for MySQL was at the beginning of the year, I did not expect to start using MySQL again. If you don't talk much about it, go to the

Oracle 11g RAC remote database login time and OS time difference 16 hours solution

Oracle 11g RAC remote database login time and OS time difference 16 hours solution Help colleagues install the RAC database of Oracle 11.2.0.4 for project stress testing. The operating system is red flag server 3. Today, my colleague suddenly called

Monitor and manage the use of Oracle UNDO tablespace

Monitor and manage the use of Oracle UNDO tablespace The monitoring and management of Oracle Database UNDO tablespaces is one of our most important tasks in daily life. The UNDO tablespaces are usually managed automatically by Oracle (determined by

MySQL innoDB redo log file

MySQL innoDB redo log file I have been confused about the difference between bin log and innodb log files in mysql. I have been wondering in my mind that the binlog log file can be used for Database log backup and recovery, why is there an

Oracle uses a cursor to delete all record scripts in all user data tables

Oracle uses a cursor to delete all record scripts in all user data tables Application Scenario: because the data in the Oracle database involves confidential information, we hope to delete all the data at a time and only keep the data table

Linux installation setup VNC Remote Desktop Connection to install Oracle 11g

Linux installation setup VNC Remote Desktop Connection to install Oracle 11g Preface:To install Oracle in Linux, you need to start the swing interface of Java. Therefore, the x-window is required. Therefore, it is difficult to directly go to the

ORA-21561: OID generation failed

ORA-21561: OID generation failed A very strange problem occurs: Linux5.8 + Oracle 11.2.0.3 When starting the database, an error is reported: [Oracle @ tivoli02 ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.3.0 Production on Thu Oct 23 21:23:16 20

Oracle 11gR2 Database UNDO tablespace usage remains high

Oracle 11gR2 Database UNDO tablespace usage remains high The customer's Database is a standalone Database of Oracle Database 11.2.0.3.0 for AIX 6.1 64bit. The customer queries DBA_FREE_SPACE and finds that the UNDO tablespace usage is as high as 98%

Total Pages: 1013 1 .... 278 279 280 281 282 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.