Database Administrator

Oracle view the lock held by the object My colleague added a field to a table in the test database, prompting ORA-00054, resource busy. The table object lock is not released. Use the following SQL statement to check the locking status of related

Disable and uninstall Oracle AWR features Need to disable AWR? Such a good stuff. By default, AWR is usable and requires a certain amount of sysaux tablespace. However, when debugging packages related to AWR (license is required) access the AWR view

Oracle rman recovery to remote and remote The original Oracle database server uses rman to back up the entire database, and then restores the same database on the remote server. 1.1 original server backup database Step 1: view the database instance

ORA-00942 tables or views encountered during storage do not exist Solution: Grant select, insert, update, delete on bookmarks. * to bm_user @ localhost identified by 'Password' Authorization statement: Grants the XXX select, insert, update, and

Summary of Oracle component seriesThe Oracle component information can be viewed through v $ option and dba_registry: -- View v $ option: V $ OPTION displaysOracle Database options and features. typically, although not always, optionsmust be

Oracle deferred_segment_creation usage and exp solution, oraclesegment SYS @ ORCL> show parameter segment NAME TYPE VALUE-----------------------------------------------------------------------------Deferred_segment_creation boolean

MySQL stored procedure: Batch authorization for users, mysql Stored Procedure To write these scripts, you need to write slow query logs into the database for ease of viewing. 1. because of the default mysql. the slow_log table uses the csv Data

Clear, delete, and modify mysql tables. Individual Original: http://www.phpthinking.com/archives/365 I. Clear mysql table data Delete from table name;Truncate table name;The delete statement without the where parameter can delete all content in the

Basic MySQL-basic database operations and basic mysql operations 1. Delete the database drop database name; Mysql> drop database test; Delete database mode 2. create DATABASE name; Mysql> create database test; In Windows and Linux, database names

SQLPLUS feedback settings, sqlplusfeedback When SQL plus is used to execute an SQL statement, a prompt such as "XX rows have been returned" may be returned for the result returned by a SELECT statement, but this prompt is not found when a database

DYNAMICRESOLUTION | NODYNAMICRESOLUTION, dynamicresolution Sometimes it is slow to start the OGG process. It may be because too many tables need to be synchronized. Before enabling the process, OGG creates a record for the table to be synchronized

Take kettle's Excel Writer as an example. kettlewriter Step for learning kettle in ExcelWriter   In the ExcelWriter step, you can enter content in an excel template file and write content to different sheets of the same file. This article provides

MySQL Data Types Note: The following content is applicable to MySQL and later versions. MySQL has many data types. Selecting the correct data type is crucial for achieving high performance. This article is based on some blogs I have seen on the

SQL server implements the basic paging function, and SQL SERVER implements PagingSQL SERVER implements basic paging functions using NOT IN and SELECT TOP for paging Use WH_WorkshopInforSys -- create a temporary table select IDENTITY (int, 1, 1) as

Fine-grained audit using DBMS_FGA and fine-grained audit using dbms_fga Experiment: fine-grained audit using DBMS_FGA 1. Create a test tableTEST_USR1 @ PROD1> create table audit_test (x number ); Table created. 2. Create an Audit PolicyTEST_USR1 @

WARNING OGG-00952 Purging log history from OGG. GGS_DDL_HIST, ogg-00952purging The following warning is often found during OGG log inspection:16:52:56 WARNING OGG-00952 Oracle GoldenGate Manager for Oracle, mgr. prm: Purging log history from OGG.

[Database Study Notes] (2) JDBC load and register the database driver and connect to the database, learning notes jdbc There are several methods for jdbc to load database drivers: Type 4: Local protocol driver Type 1: jdbc-odbc bridge

Oracle SQL not in Multi-field comparison example, oraclesqlSelect * from (select t2.cadastralno parcelid, t1.pkid taxpayerid, t2.taxtype taxtype, t1.booktype taxpayertype,T2.cadastralno parcelCadastralno, t2.landuser parcelLanduser, t1.payername

Zoj 2027 Travelling deformation, zoj2027 All 6 sides of a cube are to becoated with paint. Each side is coated uniformly with one color. When a selectionof n different colors of paint is available, how many different cubes can youmake?   Note that

IT Ninja Turtles quota insufficient solution ORA-01536: space quota exceeded for tablespace, tablespaceToday, some colleagues reported that data in the past few days could not be found in oracle. Check TT error Log display: TT5211: TT5211: Oracle