Database Architecture In Oracle, a database refers to the entire Oracle RDBMS environment and includes the following components: • Oracle database processes and buffers (instance). • SYSTEM tablespace containing one centralized system catalog, which is made up of one or more datafiles. • Other optional tablespaces as defined by the database administrator (DBA), each made … Continue reading Microsoft SQL Server for Oracle Professionals.
SQL 2000
Trucate Transaction Log in SQL Server 2000/2005
In SQL Server, it is important to keep the size of the transaction log at a decent size. If the transaction log fills up your disk drive. It can hang up the database. T-log is like archived redo log files in oracle database. Instead of storing multiple files, SQL server stores the t-log as a … Continue reading Trucate Transaction Log in SQL Server 2000/2005
