Oracle Database Internal Mechanism

Menu

Skip to content
  • Home
  • Authors
    • Nitish Anand Srivastava
  • Oracle 12c
    • Oracle 12c Architecture
    • Installing 12c Database on Oracle Linux 7
    • Managing a CDB & PDB [Basic DBA Commands]
    • Table PITR in Oracle 12c
    • 12c New Features – Database In-Memory
    • 12c New Features – Online DataFile Move
    • 12c New Features – Global Temporary Table Undo
    • 12c New Features – Partial Indexes
    • 12c New Features – Invisible Columns
    • Long Identifiers in Oracle Database 12c Release 2
    • Flashback PDB in Oracle 12cR2
    • Move Table Partition/Sub-Partition Online – 12cR1
    • Move Table Online – 12cR2
  • Oracle Backup & Recovery
    • Performing Block-Level Recovery
    • Performing Cancel-Based Recovery
    • Performing Database-Level Recovery
    • Performing Datafile-Level Recovery
    • Performing Log Sequence–Based Recovery
    • Performing SCN-Based Recovery
    • Performing Tablespace Point-in-Time Recovery
    • Performing Tablespace-Level Recovery
    • Performing Time-Based Recovery
    • Recovering from the LOSS of REDO log files
    • Recovering Read-Only Tablespaces
    • Restore database in case of dropped table
    • Restoring a Database (NoArchivelog mode)
    • Tips & Tricks
  • Oracle RAC
    • SCAN Internals
    • Split Brain Syndrome
    • GPNP Profile Internals
    • Voting Disk Internals
    • Network & Disk Heartbeats
    • OCR Internals
    • OLR Internals
    • Adding & Removing Voting Disk
    • Installing 12c RAC on Oracle Linux 6
    • Installing 12c RAC on Oracle Linux 7
  • Oracle Dataguard
    • How to Create Active DataGuard
    • How to Create Logical Standby in DataGuard
    • How to Create Physical Standby in DataGuard
    • How to Create Snapshot Standby in DataGuard
    • How to Perform Failover in DataGuard
    • How to Perform Switchover in DataGuard
  • Oracle GoldenGate
    • How to Install oracle Golden Gate on UNIX
    • How to setup GoldenGate Replication in Oracle
    • Oracle GoldenGate Architecture Internals
  • Oracle Performance Tuning
    • Oracle Wait Events
      • db file sequential reads – Oracle wait event
      • db file scattered read – oracle wait event
      • Direct Path Read/Direct Path Read Temp – Oracle Wait Event
      • Library Cache lock – Oracle Wait Event
      • Buffer busy waits – Oracle Wait Event
      • log file sync – Oracle Wait Event
      • log file switch – Oracle Wait Event
      • Library Cache Pin – Oracle Wait Event
      • row cache lock – Oracle Wait Event
      • enq: TM – contention – Oracle wait event
      • enq: TX – index contention – Oracle wait event
      • latch: cache buffers chains – Oracle wait event
    • Queries to Monitor Oracle Sessions
    • How to enable 10046 Trace (SQL_TRACE) to troubleshoot performance issues
    • Oracle TKProf Usage
    • Understanding TKProf output
    • Oracle Database Internals
      • Oracle Memory Architecture (SGA & PGA)
      • Oracle Process Architecture
      • Full Table Scan (FTS)
      • Index Lookup (Unique Scan,Range Scan, Full Scan, Fast Full Scan, Skip Scan)
      • Interpreting an Explain Plan
      • Joins
      • Direct Path Reads
      • Table Access by Rowid
      • Index Unique Scans
      • Index Range Scans
      • Index Skip Scans
      • Index Fast Full Scans
      • Index Full Scans
  • Oracle datapump Internals
    • Oracle datapump expdp & impdp internals
    • How to read Datapump Dumpfile Headers
    • Datapump Export (Everything you need to know)
    • Queries to Monitor Datapump Jobs
  • SQL Server
    • Install SQL Server 2017 on Linux
    • SQL Server on Linux – Directory Structure
  • Sybase ASE
    • Sybase ASE – Take backup for Cross-Platform Load in Quiescent State
    • Sybase ASE – Read a dumpfile with headeronly
    • Sybase ASE – Load Database from a Cross-Platform Dump File using sp_post_xpload
    • Sybase ASE – Dump/Load a database to/from multiple stripes
    • Sybase ASE – Changing Existing Database Device from ‘dsync’ to ‘directio’
    • Sybase ASE – Rename a Database
    • Sybase ASE – Extending an Existing Database Device
    • Sybase ASE – Create new Database & Device in Sybase ASE
    • Sybase ASE – Error while loading shared libraries: libkonavm.so: cannot open shared object file
    • Sybase ASE – Recover a lost or Unknown “sa” password
    • Sybase ASE – Kernel kistartup: could not create shared memory on Linux server
    • Sybase ASE – Exhausted “cpu grace time” when Loading Database Dump
  • MySQL
  • Miscellaneous Issues
    • Resolving tablespace issues (ORA-01650 / ORA-01652 / ORA-01653 / ORA-01654 and ORA-01658)
    • Troubleshooting Listener Startup or Connection Hang issues in 11g.
    • Listener Issues ORA-12505/TNS-12505 or ORA-12514/TNS-12514
    • Resizing Redo Log file
    • Install & Configure Oracle XE on Linux/CentOS
    • Resolving ORA-00845: MEMORY_TARGET not supported on this system
    • ORA-28040: No matching authentication protocol exception
    • Troubleshooting TNS-12519 TNS-12516 ORA-12519 ORA-12516
    • How to change the SID using DBNEWID utility
    • Dead Connection Detection
    • Installing Oracle Linux 6 on VirtualBox VM
    • Installing Linux 7 on Oracle VirtualBox VM
    • ORA-12547: TNS:lost contact
    • Oracle Auto-Startup Script for Linux
    • ORA-01792: maximum number of columns in a table or view is
    • Oracle Listener Tracing & network troubleshooting
    • ORA-12505 TNS-12505 TNS:listener does not currently know of SID given in connect descriptor
    • ORA-14452 attempt to create, alter or drop an index on temporary table already in use
    • ORA-12500 TNS-12500 TNS:listener failed to start a dedicated server process
    • ORA-12504 TNS-12504 – TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
    • ORA-12502 TNS-12502 TNS:listener received no CONNECT_DATA from client

Tag Archives: ORA-00057

ORA-00057 Maximum number of temporary table locks exceeded

Cause: The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts. Action: Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.

February 23, 2020 in Oracle.

Search this Blog

Popular Posts

  • Oracle database Internal Mechanism
    Oracle database Internal Mechanism
  • OLR Internals
    OLR Internals
  • Oracle Memory Architecture Internals(SGA & PGA)
    Oracle Memory Architecture Internals(SGA & PGA)
  • How to setup GoldenGate Replication in Oracle
    How to setup GoldenGate Replication in Oracle
  • GPNP Profile Internals
    GPNP Profile Internals
  • enq: TX - index contention - Oracle wait event
    enq: TX - index contention - Oracle wait event
  • Queries to Monitor Datapump Jobs
    Queries to Monitor Datapump Jobs
  • Oracle Database Internals
    Oracle Database Internals
  • Performing Datafile-Level Recovery
    Performing Datafile-Level Recovery
  • Performing Cancel-Based Recovery
    Performing Cancel-Based Recovery

All Pages

  • Authors
  • Miscellaneous Issues
    • Resizing Redo Log file
  • Nitish Anand Srivastava
  • Oracle 12c
    • 12c New Features – Database In-Memory
    • 12c New Features – Global Temporary Table Undo
    • 12c New Features – Online DataFile Move
    • 12c New Features – Partial Indexes
    • 12c New Features – Table PITR in Oracle 12c
    • Installing 12c Database on Oracle Linux 7
    • Managing a CDB & PDB [Basic DBA Commands]
    • Oracle 12c Architecture
  • Oracle Backup & Recovery
    • Performing Block-Level Recovery
    • Performing Cancel-Based Recovery
    • Performing Database-Level Recovery
    • Performing Datafile-Level Recovery
    • Performing Log Sequence–Based Recovery
    • Performing SCN-Based Recovery
    • Performing Tablespace Point-in-Time Recovery
    • Performing Tablespace-Level Recovery
    • Performing Time-Based Recovery
    • Recovering from the LOSS of REDO log files
    • Recovering Read-Only Tablespaces
    • Restore database in case of dropped table
    • Restoring a Database (NoArchivelog mode)
    • Tips & Tricks
  • Oracle database Internal Mechanism
  • Oracle Database Internals
    • How to Interpret an Explain Plan
    • Index Lookup (Unique Scan,Range Scan, Full Scan, Fast Full Scan, Skip Scan)
    • Oracle Memory Architecture Internals(SGA & PGA)
    • Oracle Process Architecture Internals
    • What are Joins in Oracle
    • What is a Full Table Scan (FTS) in Oracle
  • Oracle Dataguard
    • How to Create Active DataGuard
    • How to Create Logical Standby in DataGuard
    • How to Create Physical Standby in DataGuard
    • How to Create Snapshot Standby in DataGuard
    • How to Perform Failover in DataGuard
    • How to Perform Switchover in DataGuard
  • Oracle GoldenGate
    • How to Install oracle Golden Gate on UNIX
    • How to setup GoldenGate Replication in Oracle
    • Oracle GoldenGate Architecture Internals
  • Oracle Performance Tuning
  • Oracle RAC
    • GPNP Profile Internals
    • Network & Disk Heartbeats
    • OCR Internals
    • OLR Internals
    • SCAN Internals
    • Split Brain Syndrome
    • Voting Disk Internals

Recent Posts

  • How to shrink a datafile when getting ORA-03297 (Lowering High Watermark)
  • How to Apply Release Update 12.2.0.1.210420 (Patch 32507738 – April 2021 RU)
  • ./opatch: line 839: [: too many arguments Java (1.x) could not be located
  • How to Apply Release Update 19.11.0.0.0 (Patch 32545013)
  • How to Upgrade OPatch to Latest Version

Archives

  • August 2021
  • April 2021
  • February 2021
  • July 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2019
  • December 2018
  • November 2018
  • September 2017
  • August 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • March 2016
Website Powered by WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Oracle Database Internal Mechanism
      • Join 253 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Oracle Database Internal Mechanism
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar