Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 11315

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

4
votes
1answer
I have several questions: 1) If Oracle manages both High-water Mark and Low High-water Mark in ASSM tablespace then do we have to think about that when thinking about performance? I mean, does … Oracle manages deleted blocks itself and does not scan those blocks during table full scan, or do we still have to shrink those tables (alter table mytable shrink space;) in order to clean those deleted …
asked Sep 2 '12 by Centurion
4
votes
5answers
What are the cases when Oracle advanced queuing is the preferred mechanism for implementing functional requirements? For example, money transfer from bank account A to bank account B might …
asked Sep 30 '12 by Centurion
5
votes
1answer
It looks like Oracle shared server process model is better than dedicated server process model. In a shared server configuration, client user processes connect to a dispatcher and it can support …
asked Sep 27 '12 by Centurion
27
votes
2answers
The Tablespace parameter is optional when creating tables. Upon execution of a CREATE TABLE statement, Oracle assigns the default one if it was not defined. In the default database there is a "USERS" tablespace. If there were several tablespaces defined, which one would be assigned? …
asked Oct 2 '12 by Centurion
7
votes
3answers
user logon. It smells like hidden Oracle functionality and I can't find any reference in Oracle docs about that. I'm using Oracle11g. …
asked Nov 25 '12 by Centurion
0
votes
1answer
would be to query text data by fragment and hash indexes are useless in such case. So, I'm curious do you use such hash indexes, and if so then when do you use? IMHO Oracle does not have native hash indexes, so that must be done manually. …
asked Dec 8 '12 by Centurion
1
vote
1answer
What is the difference between Oracle clusterware and Real Application Clusters? If we have 2 servers and want to join them into a cluster why there are two separate software products? …
asked Feb 14 '13 by Centurion
8
votes
1answer
SCHEMA might be done using ON DATABASE, so what's the difference? I can't find references in Oracle docs about that. …
asked Nov 25 '12 by Centurion
2
votes
1answer
From the logical data separation point, there are tablespaces that consist of segments that consist of extend that consist of oracle blocks that consist of OS blocks. What logical structure actually …
asked Sep 17 '12 by Centurion
0
votes
1answer
AFAIK there are three major structure types used for storing Oracle index data: B-tree, R-tree and Bitmap. All indexes use one of these structures. However, not sure about CONTEXT, CTXCAT and CTXRULE Oracle text indexes... …
asked Dec 8 '12 by Centurion
1
vote
1answer
The usage of Oracle PL/SQL procedures for controlling data access is often emphasized in PL/SQL books and other sources as being more secure approach. I'v seen several systems where all business … using thick client model and database procedures. I assume such design is mostly used when Oracle (and maybe MS SQL Server) databases are used. I do agree such approach improves security but only if …
asked Nov 11 '12 by Centurion
11
votes
1answer
It's (or at least was) known that you cannot use DML statements on a mutating table inside a trigger. An excerpt from the Oracle documentation: A mutating table is a table that is being modified … emp SET salary = 5000; END emp_bri; The insertion completes successfully with the next id value and updates all emp records. I'm using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0. I have read about compound triggers but the sample does not use them. …
asked Nov 25 '12 by Centurion
2
votes
1answer
Oracle has partitioning and clustering features. Partitioning enables to split table or indexes into multiple tablespaces and store on various servers. So it's done manually. Clustering enables …
asked Dec 4 '12 by Centurion
2
votes
1answer
Suppose we have a server that has only 1 CPU with 1 core, so we need 1 Oracle database license for installing a database into it. Now, if we would need to add a second server, combine them into … cluster and install database into it, then how many licenses do we need - 2 database licenses and 1 Clusterware licenses or 1 database license and 1 cluster license? I'm not sure, how Oracle treats joined …
asked Feb 12 '13 by Centurion
2
votes
3answers
Is it possible to monitor role and privilege grant/revoke using triggers? I' aware of doing that using Oracle audit tools however, it's interesting is it possible to do that using triggers. …
asked Nov 25 '12 by Centurion

15 30 50 per page