StarQuest Technical Documents

SQDR Plus: Oracle XStream Licensing

Last Update:31 May 2022
Product: SQDR & SQDR Plus
Version: 5.30 and later
Article ID: SQV00PL071

Special licensing considerations apply when using XStream technology with an Oracle source.

Run the following SQL on the Oracle host system to obtain a CPU count and processor type and provide the output to StarQuest sales. In the case of a RAC environment, please run it each of your RAC instances:

SQL> select STAT_NAME,to_char(VALUE) as VALUE ,COMMENTS from v$osstat where stat_name IN ('NUM_CPUS','NUM_CPU_CORES','NUM_CPU_SOCKETS');

SQL> select PLATFORM_NAME from v$database;

Alternatively, run the following UNIX command on each system:

$ cat /proc/cpuinfo

If you are running AIX on IBM Power Servers, we would also like this information from your source server:

lparstat -i






The information in technical documents comes without any warranty or applicability for a specific purpose. The author(s) or distributor(s) will not accept responsibility for any damage incurred directly or indirectly through use of the information contained in these documents. The instructions may need to be modified to be appropriate for the hardware and software that has been installed and configured within a particular organization.  The information in technical documents should be considered only as an example and may include information from various sources, including IBM, Microsoft, and other organizations.