Reputation
15,413
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
1 28 42
Newest
 Nice Answer
Impact
~1.0m people reached

Apr
12
comment Why switch execution plan for consecutive, identical queries?
@NetScr1be - You may know that the query is going to return 20 rows. It is unlikely that the database optimizer is going to guess that number correctly every time. It is entirely possible that it will be close most of the time but occasionally it's going to guess way too high or way too low (cardinality estimates with multiple predicates that have different levels of correlation are tricky). It is also possible that it is just flipping between different indexes.
Apr
11
answered Why switch execution plan for consecutive, identical queries?
Apr
11
revised Virtual Private Database: Create Policy function/s so that a user can view his own records or records inserted by other users with the same company ID
added 75 characters in body
Apr
11
answered PUBLIC privilege potential security threat - Oracle database
Apr
7
comment Read from SQL Server into Oracle
You can still create a database link in Oracle that points to server. That requires using Generic Connectivity and the Transparent Gateway (the Transparent Gateway for ODBC is free and reasonably easy if your Oracle database is running on Windows). If you're trying to do real-time replication, that's going to be a challenge because all the replication technologies that are built on the database link won't work for heterogenous connections.
Apr
6
awarded  Nice Answer
Apr
5
comment Oracle 11G, Move indexes from one datafile to another
Why do you assume that a single index exists in a single data file? Normally, you'd expect that indexes in the same tablespace would likely have extents in each of the data files.
Mar
30
answered Why is installing ORACLE ODBC client a complex task?
Mar
30
awarded  Enlightened
Mar
30
awarded  Nice Answer
Mar
18
comment How to create a function(table_name) that return a collection in Oracle?
Assuming that returning a cursor is an option rather than using a table function, I'm not sure why you bother to query all_tab_columns rather than just dynamically generating the statement 'select * from ' || table_name_in
Mar
17
answered ORACLE: Can I get results of “SHOW PARAMETER” into a variable or table?
Mar
17
comment ORACLE: Can I get results of “SHOW PARAMETER” into a variable or table?
Can you query v$parameter instead? show parameter is just SQL*Plus syntactic sugar for a query against that.
Mar
14
comment Why Does Oracle kill a session at the specific time?
It is incredibly unlikely that Oracle is killing the session. Something else is causing the session to be dropped. I would wager that something at the networking level is causing the issue.
Mar
11
comment What is the name of the default schema in Oracle?
The object will be created in the schema of whatever user you are logged in as at the time. Oracle's concept of "schema" is a bit different than other databases like, say, SQL Server. A database user has exactly 1 schema that has the same name as the user.
Mar
4
comment Inheritance between table and type in Oracle
So you have three object types, a parent object type and two child object types. And you have a two child object types that inherit from that parent? And then you create three separate tables one table per object. Is that correct? If you are trying to model "an entity must be exactly one of A or B" relationally, that would normally involve a different approach.
Mar
4
comment oracle : Effect of inserting new rows when row movement is enabled
As long as you and all the frameworks that you are using either ignore the rowid or use it correctly (with the understanding that it might have changed), I'd enable row movement permanently and be done with it. Obviously after first doing a thorough test to ensure that you don't have some hidden dependency in some random library. Row movement has no impact on rows that are inserted.
Mar
4
comment oracle : Effect of inserting new rows when row movement is enabled
Does your application depend on the rowid of a row being unchanged for the life of the row? Most applications do not so it's perfectly safe in most environments to enable row movement and keep it on (which, among other things lets you shrink and compact segments). If your application depends on the rowid being unchanged, then enabling row movement for 10 minutes may be problematic. I don't quite understand what your impression is but whatever it is, it sounds incorrect.
Mar
4
comment Inheritance between table and type in Oracle
Any chance you could edit your question and include the additional information as plain text? Links to images on random, unknown sites are going to be blocked by lots of firewalls and will drastically reduce the number of people able and willing to reply.
Mar
3
comment Inheritance between table and type in Oracle
Is client_prive the same as client_publics? That doesn't seem likely. But your create table statement in the question is apparently trying to create a client_publics table while your comment is talking about a table with a different name. Is clients an object type that already exists? Is clients_public an object type that already exists? What is the difference between a clients object and a clients_public object? Maybe you want to define a clients_public object type and then a table of those objects?