Oracle - Restore Point & Flash Back
Sometimes, varity business data need create restore point for differ performance test. So how to manange restore point and how to flashback, see the below ->
Database OracleScript
← All posts
#Oracle
13 篇文章
Oracle - ILM
ILM is mean Information Lifecycle Management. It's practice of applying policies for effective management of information throughout its useful life. Implemen…
Database OracleKT
Oracle - Materialized View
A materialized view, or snapshot as they were previously known, is a table segment whose contents are periodically refreshed based on a query, either against…
Database OracleKT
Oracle - Advanced Queue & Job
Advanced Queueing Oracle Advanced Queueing (AQ), AQ provides a message queuing infrastructure as integral part of the Oracle server engine. It provides an AP…
Database OracleKT
Oracle - Instance - RAC, Memory - SGA, PGA
An Oracle database server consists of an Oracle database and an Oracle instance. Every time a database is started, a system global area (SGA) is allocated an…
Database OracleKT
Oracle - Trouble Shooting & performance monitor by OEM
The goals of Oracle troubleshooting include: Learn a troubleshooting methodology for use in analyzing any Oracle database Understand ratio-based and bottlene…
Database OracleKT
Oracle - What's the different between Traditional Export/Import and Datapump
Datapump Datapump is an ORACLE database external utility, which is used to transfer objects between databases. This utility is coming from ORACLE 10g databas…
Database OracleKT
Oracle - Database Structure
Total four parts, Tablespaces, Datafiles, Database Blocks, Extents, Segments, Database Schema Objects and Database Logs
Database OracleKT
Oracle - ASM(Automatic Storage Management)
Oracle ASM is a volume manager and a file system for Oracle database files that supports single-instance Oracle Database and Oracle Real Application Clusters…
Database OracleKT
Oracle - How to Read a Query Plan
Goal: know how to generate and read a basic query plan. Understand key phrases, such as Full Table Scan and Nested Loops should jump out as red flags. Be abl…
Database OracleKT
Oracle - Database Administrations
This part mainly talk about these points: Import and export of database Start and Stop database Starting and stopping Nodes in the RAC Manage available sessions
Database OracleKT
Oracle - Basic SQL, Store Procedures(Functions, Packages)
Goals: Have a grasp of both SQL DML (Data Manipulation Language) and DDL (Data Definition Language). DML covers items such as Select, Update, Insert and Dele…
Database OracleKT
Oracle Statements - DDL, DML, DCL, TCL
DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples: DML Data Manipulation Language (DML) statem…
Database Oracle