database

ARCHITECTURE OF ORACLE DATABASE Flow of Select statement STEP 1: When a user clicks on a software or terminal a user process is allocated. STEP 2: When user enters a user id and password it requests for a server process and aserver process is allocated for that user. STEP 3: Now the server process will […]

Script for Tablespace current utilization. Script to add datafiles in tablespace. Script to resize datafiles. Script to Create tablespace Script to check temp tablespace utilization Script to add tempfile space in temp tablespace. Auto Extend DATAFILE Alter datafile auto extend on Disable autoextend of datafile. Create tabelspace with Autoextend on Create Big file tablespace. Check […]

Oracle 12c is a multi tenant architecture Oracle 12c database is having the root container database and it includes a pluggable database. following are the different ways to drop the Oracle 12c database. 1. DBCA (Silent Method or GUI) 2. Command Line Interface (startup mount restrict and then issue drop database) 3. Manually cleaning up […]