Administration

How to Resolve ORA-01000: maximum open cursors exceeded

by Ed Chen
January 15, 2020January 17, 2020

ORA-01000 Saw an error ORA-01000: maximum open cursors exceeded when executing a lot of statements. It seemed that the number of open cursors has reached… Read More »

How to Resolve "Connected to an idle instance"

by Ed Chen
November 9, 2019January 14, 2020

Connected to an idle instance Actually, Connected to an idle instance is a message rather than an error, it indicates that the database you enter… Read More »

How to Stop Oracle Database

by Ed Chen
September 29, 2019November 6, 2019

Stop Oracle Database After knowing how to start an Oracle database, we may begin to learn something about stopping an Oracle database. Stopping a database… Read More »

How to Start Oracle Database

by Ed Chen
September 28, 2019January 9, 2020

Start Oracle Database To start an Oracle database, you have to know which database you want to start. This includes at least two things, Oracle… Read More »

How to Resolve Oracle SHUTDOWN IMMEDIATE Hangs

by Ed Chen
September 4, 2019November 6, 2019

SHUTDOWN IMMEDIATE Hangs Database shutdowns may not go smoothly as you thought, they could seem to be stuck in an infinite waiting. If you wait… Read More »

How to Check Oracle Database Size

by Ed Chen
August 30, 2019October 13, 2019

At least two scenarios that you may need to know the database size. Server upgrade or migration You have to plan the size of storage… Read More »

How to Move Oracle Database

by Ed Chen
January 23, 2019May 8, 2019

Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »

How to Find Biggest Segments in Oracle

by Ed Chen
January 14, 2019April 17, 2019

Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within… Read More »

How to Find Biggest Tables in Oracle

by Ed Chen
January 8, 2019September 26, 2019

Find Biggest Oracle Table Size Beside to calculate the size of a single table by some approaches, you can also list the most noticeable tables… Read More »

Scope of Views on DBA_TABLES, ALL_TABLES and USER_TABLES

Oracle Show Tables in a List

by Ed Chen
August 23, 2018July 4, 2019

In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Oracle Show Tables that… Read More »