Reputation
12,956
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 22 36
Newest
 Yearling
Impact
~610k people reached

2d
comment Multi Tenant Identity
Why would you want to? If you're using an auto_increment, you're generating a synthetic primary key. By definition, that means that the key isn't meaningful for anything other than identifying the row. Why would you care if one tenant sees more than the expected number of gaps in the record_id for a single tenant if the record_id isn't meaningful?
Apr
13
comment creating BTREE index in oracle with clause
I'm not sure that I understand he question. Are you stating that table1 is a physical table, not a CTE, that it has 190,000 rows (I believe a lakh is 100,000), that there are three distinct values of col1 that are equally distributed so this query would return roughly a third of the data (~60,000 rows)? And then asking whether a single column index on col1 would improve the performance of this query?
Apr
13
revised creating BTREE index in oracle with clause
added 36 characters in body
Apr
11
answered is high cpu a bad thing
Mar
19
comment SQL - Optimize table population with dynamic queries
Are you saying that it will loop 1 million times each time inserting 10,000 rows so that it inserts a total of 10 billion rows? Or are you saying that it inserts a total of 1 million rows? Is there a reason that you're looping in the first place rather than simply dynamically constructing the entire INSERT SELECT statement? Do you need the interim commits?
Mar
12
comment Continuous replication between Oracle Database and Microsoft Azure SQL
Why do you believe that GoldenGate is deprecated? Oracle purchased the company and its direction in the future is based on GoldenGate technology (plus bits from Streams).
Mar
11
comment Stored Procedure result is not showing in Datagrid pane in Toad for Oracle
p_recordset is a local variable that goes out of scope as soon as the procedure returns. If you want an object that executes a query and returns a sys_refcursor you probably want a function not a procedure. If you really want to use a procedure, you'd need to add an OUT parameter of type sys_refcursor (or types.cursor_type if that is something meaningfully different).
Mar
9
reviewed Approve Concept of Cardinalilty in Oracle
Mar
6
comment Improve sql server lookup table performance
What does the query plan look like? What does "very slow" mean (minutes? hours?)? What sort of performance are you hoping to achieve? A single-table query using a single IN list predicate with 1000 values should just do 1000 index seeks using the primary key index which should be pretty efficient (though that's relative-- if you're counting milliseconds, efficiency is relative).
Mar
3
answered Why does Oracle indicate my table is using so little space?
Mar
2
revised ON DELETE CASCADE not deleting entry for foreign key
added 56 characters in body
Feb
28
comment How to perform same DML statements on two different servers (Oracle and SQL-Server) simultaneously
Do you really mean simultaneously? So every transaction will incur the overhead of a two-phase commit and the system will be unusable if either database is unavailable? Generally, that's not what you want. Generally, you want to replicate data from one system to the other asynchronously which brings up the question of what sort of lag you can tolerate and whether the replication needs to be bidirectional.
Feb
26
comment How to Load Special characters in Database 11.2 & Client Character Set is US7ASCII through SQL * Loader
Are you trying to load the characters into a varchar2 column? Or an nvarchar2 column? If the database character set is US7ASCII and the "special characters" are not part of the 7-bit ASCII character set, they cannot be validly encoded in a varchar2 column.
Feb
19
answered How to prevent users other than DBAs from creating database links
Feb
17
comment Oracle: Inserting data using a database link
@KellyCook - The error you are getting cannot possibly be the result of something being wrong on the client machine (assuming that it is actually the INSERT statement that throws the error). The error you're getting indicates that the database link is set up incorrectly.
Feb
17
answered Oracle: Inserting data using a database link
Feb
17
comment Oracle: Inserting data using a database link
Are there three machines involved here? A client machine, a machine for DB1, and a machine for DB2? Do you have one machine with three Oracle Homes (one for the client, one for the DB1 database, and one for the DB2 database)? It seems unlikely that you'd do an Instant Client install on a machine that is already running the database so I'm guessing multiple machines are involved. If so, the tnsnames.ora file that needs to have DB2's connection information would need to exist on the machine (and Oracle Home) running DB1. Your client's TNS settings are irrelevant.
Feb
17
comment Oracle alter column if exists
dba_tab_columns has data for every table in the database. all_tab_columns has data for whatever tables the user you're logged in as has access to. Every user has access to all_tab_columns (though each will see different data), not every user has access to dba_tab_columns. I would expect, though, that a user that is installing an application would have full access to the data dictionary.
Feb
17
answered Oracle alter column if exists
Feb
17
comment How to know when a query was executed?
Are you licensed to use the AWR? Is it reasonable to expect that the query that was executed was one of the top resource consumers in the window during which it was executed? How long (roughly) did the query take to run?