oracleops-support

Quick reference for database operation support !

Wikipedia

Search results

Oracle Database 12c: INTERACTIVE QUICK REFERENCE

Oracle Database 12c: INTERACTIVE QUICK REFERENCE

Posted by Akbar at 12:34

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels Oracle Database 12c: INTERACTIVE QUICK REFERENCE

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Total Pageviews

About Me

Akbar

View my complete profile

Followers

Tags

DBMS_XPLAN (2)
Expdp Impdp Tutorial (2)
ORA-00020 (2)
SQL Trace (2)
(MRP) terminates (1)
10046 (1)
12.2 banner (1)
12c Last Login Time (1)
3+Years Oracle DBA Interview Questions (1)
ALTER SYSTEM CANCEL SQL : Cancel a SQL Statement in a Session in Oracle Database 18c (1)
ASM (1)
ASM Interview Questions (1)
AWM and Admin Tools (1)
Architecture of Exadata Database Machine (1)
Archive/redo llog generation (1)
Auditing DDL changes (1)
Auditing in Oracle (1)
Avoid Snapshot too old error for LOB Segments by RETENTION or PCTVERSION (1)
Background Processes (1)
Big Data Tutorial For Beginners (1)
CONTROL_FILE_RECORD_KEEP_TIME parameter (1)
CORRUPTED LOBS (1)
Can I Login AS SYSDBA With any Username and Password? (1)
Changing the Oracle database default maintenance window time (1)
Copy_vs_Backup_controlfile (1)
Creating a physical standby database (1)
DATAPUMP “INCLUDE” LIMIT OF 4000 CHARS (1)
DBMS_OPTIM_BUNDLE (1)
DST (1)
Data Guard Physical Standby - Managing temporary tablespace tempfiles (1)
Data Pump IMPDP REMAP_TABLESPACE Parameter Syntax and Examples (1)
Database Hangs Because SMON (1)
Database admin: the path to the cloud (1)
Datapump exclude/include object types. (1)
Deciding “PROCESSES” parameter value (1)
Difference between SQL and NoSQL | SQL vs NoSQL | SQL Vs NoSQL with Examples (1)
Differences between PSU/BP and RU/RUR (1)
Don't Know Java? You can still learn Hadoop! (1)
Drop UNDO Tablespace (1)
EXCLUDE / INCLUDE TABLE IMPORT (1)
EXPDP failed with ORA-39125: Worker unexpected fatal error in KUPW$WORKER.UNLOAD_METADATA ... (1)
EXPLAIN PLAN (1)
Enable/Disable job (1)
Exadata Interview Questions (1)
Expdp Table Multiple Directories In Oracle (1)
Find running sql (1)
Fixed Object (1)
GATHER_STATS_JOB (1)
GATHER_STATS_JOB job log history (1)
GG & RMAN Interview question with Answer: (1)
GPnP ( Grid plug n play ) profile in Oracle 11g R2/12c RAC (1)
Gathering Fixed Objects Statistics (1)
Generic Oracle DBA Interview questions (1)
Goldengate Interview (1)
Goldengate concept (1)
Hadoop FAQ – But What About The DBAs? Big data (1)
Hidden parameter _db_block_cache_protect (1)
How About Oracle Database 12c Threaded_Execution (1)
How To Import Data With Nologgin Option In Oracle 12c (1)
How does Oracle reuse the Expired and Unexpired undo extents? (1)
How to Backup and Restore Statistics (1)
How to Format Corrupted Block Not Part of Any Segment (1)
How to check if listener port is in use on Linux or Unix (1)
Index Fragmentation / Rebuild (1)
JOB Broken (1)
Java Tutorial for Hadoop Beginner | Java tutorial |EasyLearning (1)
MRP stuck (1)
Managing the UNDO TABLESPACE (1)
Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2) (1)
Materialized view privileges+ "ORA-01031: insufficient privileges while create Mview" (1)
Migrating from oracle to postgresql with ora2pg (1)
Moving/Renaming Datafiles While the Database is Online (1)
My Oracle 12c RAC on Oracle VirtualBox (1)
NID Utility in Oracle (1)
New features in Oracle 9i/10g/11g RAC (1)
Nologging (1)
ORA-00354 – (Oracle Hidden Parameter : _allow_resetlogs_corruption) (1)
ORA-00600 (1)
ORA-00942 (1)
ORA-01552 (1)
ORA-01591 (1)
ORA-01628 (1)
ORA-02297: cannot disable constraint ( .. ) - dependencies exist (1)
ORA-04021 (1)
ORA-04031 Unable to Allocate Shared Memory (1)
ORA-04067: Not Executed (1)
ORA-12154: TNS:could not resolve the connect identifier specified (1)
ORA-12545 (1)
ORA-12560:TNS:protocol adapter (1)
ORA-1555: SNAPSHOT TOO OLD (1)
ORA-1628 (1)
ORA-28040 (1)
ORA-30036 (1)
ORA-31623: a job is not attached to this session via the specified handle (1)
ORA-39346 (1)
ORA-600 (1)
ORA-603 ORA-20 is Raised Even When Maximum Number of Processes Has Not Exceeded (1)
ORA-7445 (1)
Online reorganization (1)
Optimize Oracle UNDO Parameters (1)
Oracle 11g database datafile addition to ASM without '+' sign (1)
Oracle 18c advantages and disadvantages (1)
Oracle 18c | Oracle 18c Features | Oracle 18c Advantages (1)
Oracle Automatic Shared Memory Management (1)
Oracle Autonomous Database: The Role of the DBA and can AWS beat Oracle Cloud ? (1)
Oracle Cloud vs Amazon Cloud – (1)
Oracle DBA Interview Questions and Answers - RAC (1)
Oracle DBA interview - FAQ (1)
Oracle DBMS_SHARED_POOL (1)
Oracle Database 12c: INTERACTIVE QUICK REFERENCE (1)
Oracle Database Cloud Service (1)
Oracle Database Corruption; Identify and Correct (1)
Oracle Datapump – Schema (1)
Oracle GoldenGate (OGG) (1)
Oracle GoldenGate - Supplemental Logging (1)
Oracle Interview Questions (1)
Oracle Processes (1)
Oracle RAC 10g (1)
Oracle Real time Interview Questions with Answer (1)
Oracle Release Roadmap (1)
Oracle Statistics (1)
Oracle XML Database (XDB) Install / Deinstall (1)
Oracle query to get session pga & uga memory usage for inactive sessions (1)
Oracle release Update (1)
Oracle trace event (1)
Oracle's biggest database foe: Could it be Postgres? (1)
PMON Terminating the Instance Due To Error 822 (1)
PSU (1)
Package Body "Sys.Dbms_metadata" Does Not Exist (1)
Patching Changes (1)
Postgres 12: DBA Life Just Got Better! (1)
Procedure to ROLLBACK FORCE pending in-doubt transaction (1)
Purging statistics from the SYSAUX tablespace (1)
Query sessions and locks (1)
RAC Architecture (1)
RAC Interview Q/A (1)
RAC Interview Questions (1)
RAC Interview question and answer. (1)
RAC STOP/START SEQUENCE (1)
RMAN Backup status (1)
RMAN-06059 (1)
RMAN-08137 (1)
RMAN-Backup and Recovery (1)
RMAN-Backup and Recovery : part - 2 (Control File) (1)
RMAN-Backup and Recovery : part - 3 (Loss of Redo Log Files) (1)
RU (1)
Recovery after killing a large transaction (1)
Remove unused components from database (1)
Removing Semaphore and Shared Memory (1)
Renaming or Moving Oracle Files (1)
Reorganizing (1)
Requirements for Installing Oracle Database 12.2 on OL6 or RHEL6 64-bit (x86-64) (1)
Resizing datafiles and understanding the High Water Mark (1)
Restoring Control Files (1)
SHM_EXT (1)
SSH Login Without Password (1)
SYSAUX – removing old snapshots (1)
SYS_CONTEXT Function (1)
Scripts (1)
Semaphores and Shared Memory - An Overview (1)
Sessions and Processes Parameters (1)
Sharing Memory—Automatically (1)
Statistics - User Object (1)
Statistics In Oracle (1)
Steps to Shutdown/Start RAC Database (1)
Structured Query Language/COMMIT and ROLLBACK + SAVEPOINT (1)
Supplemental logging for Golden Gate (1)
System (1)
TEMP Tablespace (1)
TKProf (1)
TRANSACTION RECOVERY (1)
TZ (1)
Table and Data Remapping (1)
Temporary Tablespaces created in Primary is missing in the Standby Database (1)
The Hadoop FAQ for Oracle DBAs (1)
To Monitor Tablespaces/datafiles (1)
Tracking DDL changes in 11g (1)
Troubleshooting Assistant: Resolve Issues with Oracle Undo Management (ORA-01555 (1)
Troubleshooting ORA-3137 (1)
Troubleshooting Session Administration (1)
UNDO Tablespace (1)
UNDO Usage (1)
UPDATE To USER$.SPARE6 Performs Poorly (2-Second Execution Time) and Consumes CPU (1)
Upgrade interview questions oracle database (1)
V$LOCK (1)
Verify standby environment (1)
Views_as_tables Parameter In Datapump Of Oracle 12c (1)
and Dictionary Statistics Topics (1)
asmcmd utility in Oracle (1)
blocking session and lock (1)
bug (1)
calculate Undo tablespace size + Undo Retention (1)
change Database Directory Path (1)
configure HugePages (1)
crontab command (1)
currently running SQL (1)
db health check script (1)
delete archivelogs (1)
disable (1)
enable (1)
etc.) (1)
fixed (1)
function-based indexes (1)
job remove (1)
kill all processes (1)
limits.conf (1)
mmon (1)
patch download (1)
rac (1)
recreate views in a table after performing an table reorg (1)
redefinition (1)
rollback segment (1)
stop (1)
sys password cannot change (1)
table reorganization: (1)
trcsess and tkprof in Oracle (1)
undo size (1)
undo_retention (1)
unlock and gather index stats (1)
what does "2>&1" do in crontab? (1)
which instance owns which shared memory & semaphore segments (1)

Blog Archive

► 2022 (1)
- ► Apr 2022 (1)
  - ► Apr 26 (1)

► 2021 (3)
- ► Nov 2021 (1)
  - ► Nov 10 (1)
- ► Jul 2021 (1)
  - ► Jul 17 (1)
- ► May 2021 (1)
  - ► May 12 (1)

► 2020 (6)
- ► Sept 2020 (3)
  - ► Sept 19 (3)
- ► Jun 2020 (1)
  - ► Jun 08 (1)
- ► Feb 2020 (1)
  - ► Feb 21 (1)
- ► Jan 2020 (1)
  - ► Jan 13 (1)

► 2019 (8)
- ► Oct 2019 (1)
  - ► Oct 05 (1)
- ► Sept 2019 (1)
  - ► Sept 21 (1)
- ► Jun 2019 (3)
  - ► Jun 29 (1)
  - ► Jun 08 (1)
  - ► Jun 04 (1)
- ► May 2019 (2)
  - ► May 17 (1)
  - ► May 08 (1)
- ► Apr 2019 (1)
  - ► Apr 06 (1)

► 2018 (19)
- ► Nov 2018 (1)
  - ► Nov 23 (1)
- ► Mar 2018 (1)
  - ► Mar 24 (1)
- ► Feb 2018 (1)
  - ► Feb 08 (1)
- ► Jan 2018 (16)
  - ► Jan 24 (2)
  - ► Jan 11 (1)
  - ► Jan 10 (2)
  - ► Jan 09 (2)
  - ► Jan 08 (1)
  - ► Jan 07 (2)
  - ► Jan 06 (4)
  - ► Jan 02 (2)

▼ 2017 (163)
- ▼ Dec 2017 (163)
  - ► Dec 31 (2)
  - ► Dec 30 (2)
  - ► Dec 28 (2)
  - ► Dec 22 (1)
  - ► Dec 21 (1)
  - ► Dec 19 (5)
  - ► Dec 18 (12)
  - ► Dec 17 (2)
  - ► Dec 16 (9)
  - ► Dec 15 (1)
  - ► Dec 14 (1)
  - ► Dec 13 (22)
  - ► Dec 12 (14)
  - ► Dec 11 (2)
  - ► Dec 10 (6)
  - ► Dec 09 (17)
  - ► Dec 08 (14)
  - ▼ Dec 07 (27)
  - ► Dec 06 (18)
  - ► Dec 05 (4)
  - ► Dec 04 (1)

► 2015 (1)
- ► May 2015 (1)
  - ► May 16 (1)

Copyright - 2017, www.oracleops-support.com. Simple theme. Powered by Blogger.