user avatar
user avatar
user avatar
Centurion
  • Member for 9 years, 10 months
  • Last seen more than 5 years ago
27 votes
2 answers
180k views

How is the default tablespace determined when creating a table?

11 votes
1 answer
6k views

Why am I NOT getting a mutating table error in trigger?

8 votes
1 answer
13k views

What is the difference between ON SCHEMA and ON DATABASE triggers?

7 votes
3 answers
49k views

Why I don't need to COMMIT in database trigger?

5 votes
1 answer
4k views

When dedicated server process model should be used instead of shared process model?

4 votes
5 answers
26k views

What are the real life cases for using Oracle advanced queuing?

4 votes
1 answer
3k views

Oracle High-water Mark: how relevant it is when using ASSM tablespace for tables?

2 votes
3 answers
5k views

Is it possible to monitor role and privilege grant/revoke using triggers?

2 votes
1 answer
6k views

How shared nothing and shared everything architectures look like in Oracle?

2 votes
1 answer
4k views

How many database licenses do we need for setting 2 servers (nodes) into a cluster?

2 votes
1 answer
457 views

What logical structure is used for storing rows in Oracle?

1 vote
1 answer
6k views

What is the difference between Oracle clusterware and Real Application Clusters?

1 vote
2 answers
635 views

What are the alternatives for prefixed indexes in Oracle?

1 vote
1 answer
1k views

DB stored procedures: how do they help increase security in web systems?

0 votes
1 answer
550 views

What structure is used for storing CONTEXT, CTXCAT and CTXRULE Oracle text indexes?

0 votes
1 answer
6k views

When hash indexes should be used in Oracle?

-3 votes
1 answer
11k views

What are performance benefits when using number type instead of using char/varchar?