random memo
one of the many differences between Oracle and SQL, to be continued.
Oracle uses REDO log roll forward and uses UNDO tablespace to rollback, though theoretically can use redo(transaction log)  log to rollback but not efficient.
SQL server uses transaction log to roll forward androll back.
Noticed a good summary of Differences between UNDO and REDO in oracle by Francisco Munoz Alvarez https://oraclenz.wordpress.com/2008/06/22/differences-between-undo-and-redo/

difference of Schema:
 Schema is collection of objects, in SQL, create user doesn't create schema, in oracle then it does
in oracle a user and a schema have the same name, but SQL doesn't have to

Comments

Post a Comment

Popular posts from this blog

Sysaux tablespace is too big

Image
 today I received my report alert regarding one of Oracle database tablespace SYSAUX is over 80% (I created automated job using SSIS package to check tablespace usage daily) following steps to resolve it:  /*  2021.07.08  Documentation steps for troubleshooting Sysaux tablespace is huge --85% full  */   ---1. see what uses the most select occupant_name,occupant_desc, space_usage_kbytes/1024 MB from v$sysaux_occupants where space_usage_kbytes > 0 order by space_usage_kbytes desc; ---find it is SM/Advisor Server Manageability - Advisor Framework 25GB --now look for top 10 big objects   select * from (                select bytes/1024/1024 MB, blocks, s.SEGMENT_NAME, s.partition_name, s.segment_type, s.tablespace_name                  from dba_segments s                 where owner='SYS'              order by bytes desc ) where rownum <=10 ; ---find it is WRI$_ADV_OBJECTS having 13GB and 1.7 million blocks --now check how many objects in dba_advisor_objects  select task_name
Read more

patching Oracle Database 12.2.0.1 Release Update & Release Update Revision January 2021 Critical Issues (Doc ID 2725763.1)

Image
 1 Determine current patch level D:\oracle\product\12.2.0\dbhome_1\OPatch>opatch lsinventory -patch -detail Oracle Interim Patch Installer version 12.2.0.1.6 Copyright (c) 2021, Oracle Corporation.  All rights reserved. Oracle Home       : D:\oracle\product\12.2.0\dbhome_1 Central Inventory : C:\Program Files\Oracle\Inventory    from           : OPatch version    : 12.2.0.1.6 OUI version       : 12.2.0.1.4 Log file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\opatch2021-07-09_12-46-58PM_1.log Lsinventory Output file location : D:\oracle\product\12.2.0\dbhome_1\cfgtoollogs\opatch\lsinv\lsinventory2021-07-09_12-46-58PM.txt -------------------------------------------------------------------------------- Local Machine Information:: Hostname: xxxx ARU platform id: 233 ARU platform description:: Microsoft Windows (64-bit AMD) There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPa
Read more
 Recently, moved most of my scripts to github, most for private repo for now, starting to extract general scripts and posted in    General DBA tips (zhoutransform.github.io)  https://zhoutransform.github.io/GeneralDBA/ 
Read more