• Oracle

    SQL server Oracle difference concepts architecture-06

    SQL oracle difference concepts architecture In this post, I am just referring similar to the concept to understand better, but it is not exactly same as what I have referred. Oracle SQL Comments System Master SYSAUX Resource Model MSDB temporary TempDB More than one & User can have their own There is no TempDB and it doesn’t need to re-create DESCRIBE sp_help dba_views Identity Sequence Auto generate number DBA_SCHEDULER_JOBS Sys.sysjobs DBMS_SCHEDULER / OEM-Oracle Scheduler SQL Agent SMON Recovery PMON User kill/rollback show parameter sp_configure Pfile & Spfile SQL server property you can change system and session level Data file Data file ARCHIVELOG mode Full mode NOARCHIVELOG mode Simple mode Default…