Oracle Session Control Shell Script (BASH)
session_control.sh
目前分類：Oracle in General (111)
- Aug 02 Wed 2017 18:20
Oracle Session Control Shell Script (BASH)
- Feb 18 Sat 2017 15:28
Oracle 12c “In-Database Archiving” Practice
Oracle 12c “In-Database Archiving” Practice
“In-Database Archiving” in Oracle 12c allows particular rows to be marked for deletion instead of physically deleting the rows.
- Dec 19 Mon 2016 18:11
Oracle 12c Data Redaction Example
Oracle 12c Data Redaction Example
Create a test sample data as follows:
SQL> conn sys@pdb1 as sysdba
- Jan 27 Wed 2016 14:56
Manual Installation of Oracle 12c (12.1.0.2) Sample Schemas
Manual Installation of Oracle 12c (12.1.0.2) Sample Schemas
Download linuxamd64_12c_examples.zip from:
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/database12c-linux-download-2240591.html
- Jan 13 Wed 2016 17:36
Oracle 12c In-Memory Table Practice
Oracle 12c In-Memory Table Practice
[oracle@testsvr admin]$ . oraenv
ORACLE_SID = [my12c] ?
- Jan 12 Tue 2016 15:44
Plugin an Oracle 12c non-CDB database to an Oracle 12c Container Database (CDB)
Plugin an Oracle 12c non-CDB database to an Oracle 12c Container Database (CDB)
PS. This non-CDB database is an Oracle 12g database upgraded from Oracle 11gR2 using DBUA (Database Upgrade Assistant) in the same machine.
PS. This non-CDB database is an Oracle 12g database upgraded from Oracle 11gR2 using DBUA (Database Upgrade Assistant) in the same machine.
- Jun 17 Tue 2014 11:46
How to stop the Gather Stats Job in Oracle?
How to stop the Gather Stats Job in Oracle?
Answer:
- Jun 11 Wed 2014 15:24
Create Oracle Jobs using DBMS_SCHEDULER Package
Create Oracle Jobs using DBMS_SCHEDULER Package
Privileges required for creating or managing job schedulers:
- Apr 23 Wed 2014 11:56
Solving Number Data Type Display Issue (Scientific Notation) in PL/SQL Developer
Solving Number Data Type Display Issue (Scientific Notation) in PL/SQL Developer:
Issue:
- Feb 17 Mon 2014 12:22
Oracle Useful Views for identifying Blocking Sessions
Oracle Useful Views for identifying Blocking Sessions
DBA_BLOCKERS display a session if it is not waiting for a locked object but is holding on an object for which another session is waiting.
In an Oracle RAC environment, this only applies if the blocker is on the same instance.
- Jan 13 Mon 2014 18:20
Oracle 11g Flashback Data Archive (FDA) Know-how
- Jan 08 Wed 2014 14:46
How to get last nanosecond of yesterday in Oracle?
How to get last nanosecond of yesterday in Oracle?
Answer:
- Jan 06 Mon 2014 17:11
Oracle Online Table Redefinition with DBMS_REDEFINITION package
Oracle Online Table Redefinition with DBMS_REDEFINITION package
Oracle Database allows to modify table structure online without affecting the table usages.
- Dec 26 Thu 2013 15:31
Oracle Standard Index vs Reverse-key Index Comparison Testing
- Dec 18 Wed 2013 17:07
Comparison between different methods of conversion from TIMESTAMP to DATE
Comparison between different methods of conversion from TIMESTAMP to DATE
------------------------------
-- Implicit Conversion
- Dec 03 Tue 2013 12:20
Command to create an OCM response file
Command to create an OCM (Oracle Configuration Manager) response file:
$ORACLE_HOME/OPatch/ocm/bin/emocmrsp -no_banner -output /backup/ocm.rsp
- Nov 21 Thu 2013 13:46
Oracle Easy Connect Examples
Oracle Easy Connect Examples:
sqlnet.ora settings: (On Client Site)
- Sep 26 Thu 2013 10:50
What are the differences betwen SQL Profile and SPM Baseline?
A very good article explaining the differences between SQL Profile and SPM Baseline :
http://intermediatesql.com/oracle/what-is-the-difference-between-sql-profile-and-spm-baseline/
- Sep 24 Tue 2013 16:59
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
Issue:
Dropping a table encountered ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
- Sep 04 Wed 2013 16:18
ASP OraParameters cause sessions to remain in Oracle database
Cause:
OraParameters are connected objects, and will cause sessions to remain in the database if not cleaned up properly.
{{ article.title }}