Oracle DENSE_RANKOracle DENSE_RANK
Introduction to Oracle DENSE_RANK() function The DENSE_ […]
分类： Oracle
分享Oracle数据库相关教程，文章，知识以及技巧
Recover Database until cancelRecover Database until cancel
Is it necessary to perform “recover database unti […]
How to Enable RMAN block change tracking for a physical standby databaseHow to Enable RMAN block change tracking for a physical standby database
Enabling Block Change Tracking on a Physical Standby Da […]
Check long running DML progressCheck long running DML progress
select SQL_ID, OPNAME, SOFAR, TOTALWORK, START_TIME, EL […]
datapump with querydatapump with query
Create DIR: CREATE [OR REPLACE] DIRECTORY directory_nam […]
How to create db-linkHow to create db-link
Task: In Database A, create a db-link connected to Data […]
What is the difference between SQL Profiles and SQL Plan Baselines?What is the difference between SQL Profiles and SQL Plan Baselines?
By: Maria Colgan Distinguished Product Manager I’ […]
How do I calculate tables size in OracleHow do I calculate tables size in Oracle
This query tells you how much space is allocated for ea […]
Steps to Create and Transfer Profile from One Database to AnotherSteps to Create and Transfer Profile from One Database to Another
1. Create SQL Profile in SCOTT schema The SQL Profile i […]
Save user passwordSave user password
select 'alter user "'||username||'" identified by value […]