...
Option | Setting |
Oracle Edition | PhixFlow runs on all Oracle Database editions. PhixFlow partitioned streams (optional) require the Enterprise Edition Partitioning option. |
Version | 11.2 (Support for earlier versions is available on request), or 12c (12.1) Patches should be applied as advised by Oracle. |
NLS_CHARACTERSET | AL32UTF8 |
NLS_LANG | american_america. AL32UTF8 (Not used by PhixFlow. For support purposes only) |
NLS_SORT | BINARY |
NLS_COMP | BINARY |
NLS_NCHAR_CHARACTERSET | NCHARS are not used by PhixFlow however set to AL32UTF8 |
sga_max_size | At least 2 GB For larger systems, this should be provided by the sizing process. |
SID | cviewphixflow |
Connection Type | Dedicated |
Max Number of Connections | Variable, depending on system size and workload. Typically >100. For larger systems, this should be provided by the sizing process. |
Storage Type | Any, subject to throughput requirements. |
...
To support maintenance backups, the following datapump directory is required configured as:
CREATE DIRECTORY dpump_cview phixflow AS ‘/u02/phixflow/dbexport’;
...
The following Oracle user should be set up:
User | SQL Script |
cviewphixflow | CREATE USER cview phixflow PROFILE DEFAULT IDENTIFIED BY <password> DEFAULT TABLESPACE CONFIG_DATA_01 QUOTA UNLIMITED ON CONFIG_DATA_01 QUOTA UNLIMITED ON ANALYSIS_DATA_01 ACCOUNT UNLOCK;
GRANT CREATE SESSION TO cviewphixflow; GRANT CREATE TABLE TO cviewphixflow; GRANT CREATE VIEW TO cviewphixflow; GRANT READ,WRITE ON DIRECTORY cviewphixflow_dpump TO cviewphixflow; |
Microsoft SQL Server
When using SQL Server, the following initial database configuration is recommended. However, some of the options below may need to change over time as the work carried out by PhixFlow increases.
...
Parameter | Setting |
Login Name | cviewphixflow |
Authentication | SQL Server |
Password | Please provide to the PhixFlow installation consultant |
Enforce password policy | No |
Default database | Set to cview phixflow once the cview phixflow database has been created (below) |
Default language | As appropriate |
...
Create a new database as follows:
Parameter | Setting |
Name | cviewphixflow |
Owner | cviewphixflow |
Collation | Latin1_General_CI_AS |
READ_COMMITTED_SNAPSHOT | ON |
...
Database Files
Logical Name | Setting |
cviewphixflow | Type: Rows Data Filegroup: PRIMARY Initial Size: 2000 MB Autogrowth: 10% Unrestricted (or as per management policy) Path: (As per management policy) |
cviewphixflow_data_01 | Type: Rows Data Filegroup: ANALYSIS_DATA Initial Size: 100,000 MB Autogrowth: 10% Unrestricted (or as per management policy) Path: (As per management policy) |
cviewphixflow_log | Type: Log Initial Size: 1000 MB Autogrowth: 10% Unrestricted (or as per management policy) Path: (As per management policy) |
...
Parameter | Setting |
Login Name | cviewphixflow |
Password | Please provide to the PhixFlow installation consultant |
...
Create a new database as follows:
Parameter | Setting |
Name | cviewphixflow |
Notes
Windows / Antivirus
MariaDB is not compatible with on-access anti-virus software so this must be disabled for the MariaDB data folder(s).