Skip to main content

How do I know if I need Oracle ACO / ASO / RAC / RAT ?

By
   The Database Technology market is full of various products, even when we look at just Oracle's line of products - Advanced Security, Advanced Compression, Real Application Clusters (RAC), Real Application Testing (RAT), Exadata & so on ! However, we don't just go out and buy anything - we have to have a need to have certain helper software / features to make our lives easier. How do we assess whether I need one or another ? Here's my humble attempt today to make a checklist for these 4 products (To print-out or view the sheets fully, use the direct links) ... Exadata coming soon :-) :

(1) Assessing the need for Oracle Real Application Clusters (RAC) :


RAC checklist


(2) Assessing the need for Oracle Advanced Security Option (ASO) :


ASO checklist sheet1
ASO checklist sheet2


(3) Assessing the need for Oracle Advanced Compression Option (ACO)


ACO checklist


(4) Assessing the need for Oracle Real Application Testing (RAT)


RAT checklist sheet1
RAT checklist sheet2

   If you have any suggestions on improvement, please let me know. Ia appreciate your time spent here - I hope you get some useful information out of this. Have fun architect-ing :-) !


Labels:

Comments

  1. 0pefalFal_ki-1977Saturday, April 23, 2022 9:45:00 AM

    0pefalFal_ki-1977 Alejandro Cox https://wakelet.com/wake/n4IWwFMWyA-sQjpFrvs4V
    infelrabor

    ReplyDelete
  2. AnonymousSaturday, September 23, 2023 6:07:00 AM

    Determining if you need Oracle ACO or ASO depends on your specific business needs. This guide offers clear insights and considerations for making that decision. The Complete Guide It's a valuable resource for anyone navigating Oracle's offer.

    ReplyDelete

Post a Comment

Please add your comment here

Popular posts from this blog

Permitting a user on UNIX / Linux to use sqlplus

By
We encountered an interesting scenario worth mentioning. Scenario: Oracle is installed on a Linux server newly & another ftp user wants to just use sqlplus also. Just setting the ORACLE_HOME, LD_LIBRARY_PATH, ORACLE_SID, PATH in the user's profile did not let him run the "sqlplus" command at all. The error shown was : $ sqlplus ld.so.1: sqlplus: fatal: /app/oracle/product/10.2/lib/libsqlplus.so: Permission denied Killed The files under "lib" directory under home didn't have permission for anybody other than "oracle" user. -rwxr-x--- 1 oracle oinstall 1320016 Jun 28 2005 /app/oracle/product/10.2/lib/libsqlplus.so When we permit the other users (other than oracle) to read/exe
9 comments
Read more

HWM (high watermark) of a tablespace ?

By
How many times have you thought of calculating HWM (high watermark) of a tablespace as a DBA ? Have you ever found out that a tablespace is overallocated in a database, as compared to the data being used in it ? In such a case, you'd want to reduce the wasted space & resize the tablespace to a smaller size, although greater than the current usage. HWM is at the maximum blocks ever occupied by a SEGMENT (unless we perform a truncate on it). Segments span over datafiles however remain within a tablespace. All segments are physically allocated by way of extents, which are contiguous blocks of data. Now, when we talk about contiguous blocks, 2 datafiles (even from same tablespace) are highly unlikely to have contiguguos data blocks. Hence, theoretically, it's possible to calculate high watermark within a datafile, not a tablespace directly, as the latter is only a logical unit. Although, we can resize a tablespace, however the resize value needs to be based on exact calculati
7 comments
Read more

How to upgrade Oracle 9.2.0.1 to 9.2.0.5 or 9.2.0.6 (9i versions)

By
Applying Oracle upgrade to version 9.2.0.5 (patchset 3501955) or 9.2.0.6 (patchset 3948480) Applying Oracle 9i Patch (This can be used for the Oracle client and server both) 1. Log in to the database server machine as the oracle user (administrator role in case of windows) on Unix. 2. Make sure that your environment contains the correct values for the ORACLE_HOME and ORACLE_SID variables. 3. Stop the listener process (in case of Oracle server upgrade). As the oracle user: lsnrctl stop 4. Download the patchset Extract the 9.2.0.5 patchset (3501955) or 9.2.0.6 patch set (3948480) archive into a temporary directory. 5. Change to the directory that contains the 9.2.0.5 or 9.2.0.6 patch archive and execute the following: Unzip the patch archive, viz. p3948480_9206_***.zip (this example is for Linux. Windows & other Unix patch names would be different.) 6. Install the Oracle Universal Installer (setup.exe in case of Windows patch)
1 comment
Read more