Oracle database

Oracle May 16, 2011 0

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…

Oracle April 13, 2011 0

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…

Oracle March 15, 2011 0

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…

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…

Oracle March 19, 2009 0

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…