Oracle Database, Fusion Middleware, Linux

Oracle database

Oracle DBA Interview Questions Answered: Technical

View Also: Oracle DBA Interview Questions Answered: UNIX 60 Oracle Database Administration (DBA) Interview Questions (Technical) 1. What is an Oracle Instance? An Oracle database server consists of an Oracle database and an Oracle instance. Every time a database is started, a system global area (SGA) is allocated and Oracle background processes are started. The combination of […]

, ,

Copy SQL Profiles to another Oracle database

Copying SQL Profiles from one database to another involves the following steps: Creating a staging table to store the SQL Profiles Packing the SQL Profiles to the staging table Export the table using Datapump or Export/Import Importing the SQL Profiles to the target database Unpack the SQL Profiles in the target database  1. Creating a staging […]


Physical Logical Oracle Database Limits

Physical Oracle Database Limits Item Type of Limit Limit Value Database Block Size Minimum 2048 bytes; must be a multiple of operating system physical block size Maximum Operating system dependent; never more than 32 KB Database Blocks Minimum in initial extent of a segment. 2 blocks Maximum per datafile Platform dependent; typically 222-1 blocks Controlfiles Number of control files 1 minimum; 2 or more […]

Oracle database startup shutdown script

Automate Oracle Database startup shutdown script orarun – script automates database start, stop, status query tasks, also allows user to manage isqlplus console and em database control Usage: orarun {start|stop|status|isqlstart|isqlstop|emstart|emstop} orarun start|stop|status  – starts/stops database, query for database status orarun isqlstart/isqlstop – starts/stops isqlplus console orarun emstart/emstop  – starts/stops enterprise manager database control Requirements: configured […]

, , , , ,

Data Files: moving renaming deleting

Let’s have a look at what do we have after default database installation: SQL> SELECT name FROM v$datafile; NAME ——————————————————— /u01/app/oracle/product/10.2.0/oradata/DBSID/SYSTEM01.DBF /u01/app/oracle/product/10.2.0/oradata/DBSID/UNDOTBS01.DBF /u01/app/oracle/product/10.2.0/oradata/DBSID/SYSAUX01.DBF /u01/app/oracle/product/10.2.0/oradata/DBSID/USERS01.DBF /u01/app/oracle/product/10.2.0/oradata/DBSID/EXAMPLE01.DBF   Shutdown the database first: SQL> SHUTDOWN IMMEDIATE;   Rename a datafile:

, , ,

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.