Database and Instance

The physical database structures of an Oracle database, including data files(grouped into tablespaces) ,redo log files, and control files. An Oracle user(login id) and the objects the user owns (tables ,indexes, stored procedures, triggers, packages, cursors etc) collectively known as a schema, an instance is the combination of background processes and memory buffers. Will get into detail of an Oracle instance in next session.