ORACLE DBA

CONTENTS page 1. Steps to be performed in Production Database 1 2 Steps to be performed in Test/Dev Database 3 3. Exercises 5 1. Steps to be performed in Production Database • Check the size of the schema select sum(BYTES)/1024/1024 from dba_segments where owner='SLADMIN'; • Check type of objects and status of the objects the schema. col OBJECT_TYPE for a18 set pages 100 col owner for a10 select owner ,object_type,status, count(*) from dba_objects where owner='DSADMIN' group by owner, object_type, status; • Check the total number of objects in the schema. select count(*) from dba_objects where owner like 'DSADMIN'; • Check for constraints validity in the schema. Select constraint_type,count(*) from dba_constraints where...

C:\Documents and Settings\201910>sqlplus sys/mysecretpassword as sysdba SQL*Plus: Release 10.1.0.2.0 - Production on Wed Nov 12 14:32:28 2008 Copyright (c) 1982, 2004, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production With the Partitioning, OLAP and Data Mining options SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- C:\AUG\SYSTEM.DBF C:\AUG\UNDOTBS1.DBF C:\AUG\SYSAUX.DBF C:\AUG\USERS.DBF SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> create spfile from pfile; File created. SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string...