meta user
network profile
| bio | website | didziakalnis.lt |
|---|---|---|
| location | Lithuania | |
| age | 31 | |
| visits | member for | 8 months |
| seen | Mar 2 at 16:37 | |
| stats | profile views | 15 |
|
Feb 27 |
accepted | What is the difference between Oracle clusterware and Real Application Clusters? |
|
Feb 18 |
accepted | How many database licenses do we need for setting 2 servers (nodes) into a cluster? |
|
Feb 14 |
asked | What is the difference between Oracle clusterware and Real Application Clusters? |
|
Feb 13 |
comment |
How many database licenses do we need for setting 2 servers (nodes) into a cluster? @LeighRiffel Don't we need Oracle clusterware 3rd party solution if we would use Oracle SE + included RAC? Oracle docs says "...When used with Oracle Real Application Clusters in a clustered server environment, Oracle Database Standard Edition requires the use of Oracle Clusterware. Third-party clusterware management solutions are not supported...". It appears RAC and clusterware are different products docs.oracle.com/cd/B19306_01/license.102/b14199/editions.htm So we still need to spend additional dime for that cluster ware |
|
Feb 12 |
comment |
How many database licenses do we need for setting 2 servers (nodes) into a cluster? Yes, I'm aware of licensing per processor, just wrote that for the sake of simplicity. In our case, we are thinking about Enterprise database licenses. I assume from your answer, we would still need 2 database licenses and 1 RAC license? |
|
Feb 12 |
asked | How many database licenses do we need for setting 2 servers (nodes) into a cluster? |
|
Dec 12 |
accepted | What structure is used for storing CONTEXT, CTXCAT and CTXRULE Oracle text indexes? |
|
Dec 12 |
accepted | What are the alternatives for prefixed indexes in Oracle? |
|
Dec 12 |
comment |
What are the alternatives for prefixed indexes in Oracle? @Mat Why different? Both ways we try to get better performance for wildcard queries. The only thing I not sure in is index size. |
|
Dec 12 |
answered | What are the alternatives for prefixed indexes in Oracle? |
|
Dec 8 |
accepted | When hash indexes should be used in Oracle? |
|
Dec 8 |
asked | What structure is used for storing CONTEXT, CTXCAT and CTXRULE Oracle text indexes? |
|
Dec 8 |
comment |
What are the alternatives for prefixed indexes in Oracle? There might be cases where we use varchar2 type columns with descriptions. If descriptions are long and if each description has some more or lest unique start then it would be convenient to have smaller index that might work faster than full-length index. |
|
Dec 8 |
revised |
When hash indexes should be used in Oracle? deleted 4 characters in body |
|
Dec 8 |
asked | What are the alternatives for prefixed indexes in Oracle? |
|
Dec 8 |
asked | When hash indexes should be used in Oracle? |
|
Dec 5 |
accepted | Is it possible to monitor role and privilege grant/revoke using triggers? |
|
Dec 5 |
comment |
How shared nothing and shared everything architectures look like in Oracle? @Mat I'm mostly interested in Oracle, and from your 1st comment, I understood everything is shared. AFAIK, the most frequent Oracle horizontal scaling solutions are 1) to set Oracle instances on different servers and create a cluster from those servers 2) use table and index partitioning by using a large disk array rack where each table/index partition is stored in different tablespace. Partitioning is frequently used in single server db solutions, however it has limits. Otherwise we can use clusters but it costs additional dime :) What is your opinion on Oracle horizontal scaling? |
|
Dec 4 |
comment |
How shared nothing and shared everything architectures look like in Oracle? I'm not talking about exact product, just have some understanding gaps about these two types of architectures, about sharding, and how exactly works partitioning and clustering using different servers and data storages. |
|
Dec 4 |
asked | How shared nothing and shared everything architectures look like in Oracle? |
