Centurion
  • Member for 9 years, 3 months
  • Last seen more than 4 years ago
2 answers
27 votes
179k views
6 bookmarks
How is the default tablespace determined when creating a table?
1 answers
11 votes
6k views
Why am I NOT getting a mutating table error in trigger?
1 answers
8 votes
13k views
What is the difference between ON SCHEMA and ON DATABASE triggers?
3 answers
7 votes
48k views
4 bookmarks
Why I don't need to COMMIT in database trigger?
1 answers
5 votes
4k views
2 bookmarks
When dedicated server process model should be used instead of shared process model?
5 answers
4 votes
26k views
4 bookmarks
What are the real life cases for using Oracle advanced queuing?
1 answers
4 votes
3k views
Oracle High-water Mark: how relevant it is when using ASSM tablespace for tables?
3 answers
2 votes
5k views
Is it possible to monitor role and privilege grant/revoke using triggers?
1 answers
2 votes
6k views
2 bookmarks
How shared nothing and shared everything architectures look like in Oracle?
1 answers
2 votes
4k views
How many database licenses do we need for setting 2 servers (nodes) into a cluster?
1 answers
2 votes
455 views
What logical structure is used for storing rows in Oracle?
1 answers
1 votes
6k views
What is the difference between Oracle clusterware and Real Application Clusters?
2 answers
1 votes
608 views
What are the alternatives for prefixed indexes in Oracle?
1 answers
1 votes
944 views
2 bookmarks
DB stored procedures: how do they help increase security in web systems?
1 answers
0 votes
540 views
What structure is used for storing CONTEXT, CTXCAT and CTXRULE Oracle text indexes?
1 answers
0 votes
6k views
When hash indexes should be used in Oracle?
1 answers
-3 votes
11k views
1 bookmarks
What are performance benefits when using number type instead of using char/varchar?