Reputation
2,183
Top tag
Next privilege 2,500 Rep.
Create tag synonyms
Badges
8 29
Newest
 Yearling
Impact
~122k people reached

Apr
17
awarded  Yearling
Mar
1
comment Why is adding a NOT NULL column with a default constraint instantaneous?
+1: esp. for "Enterprise Edition". I have always wondered why it didn't work at some of my customer sites ...
Feb
29
accepted How to find Oracle's installed version and release from a program?
Feb
29
comment How to find Oracle's installed version and release from a program?
To whoever voted to close: I do not believe that this question is a) to broad, it is very specific. And b) nor would good answers be too long for this format, there are already two good potential answers that I will be checking out today. If you have an answer that is too long, please feel free to outline it instead. If you have reason to believe that there are no good solutions, you may post that as an answer also, along with your reasoning.
Feb
29
revised How to find Oracle's installed version and release from a program?
added 88 characters in body
Feb
29
comment How to find Oracle's installed version and release from a program?
@WernfriedDomscheit In my case they are all Windows servers. I will clarify that in my question.
Feb
29
comment How to find Oracle's installed version and release from a program?
This looks workable locally, is there any builtin way to invoke it remotely?
Feb
29
comment How to find Oracle's installed version and release from a program?
@WernfriedDomscheit First, I am not asking about Client version, but the server versions. Secondly, you can determine it, it is the last level one child under a Home (the individual components are lower level children). I do it manually with Universal Installer all the time. I just don't want to spend the time to do it manually all the time.
Feb
26
asked How to find Oracle's installed version and release from a program?
Jan
26
comment Shrinking a SQL Server Transaction Log
AFAIK, there is not point to being in full recovery mode if you are not doing log backups. If you are not planning to do log backups then just leave it in simple mode. Your full backups will still be restorable either way, you just won;t be able to do a recovery/roll-forward, but you cannot do that anyway without log backups.
Jan
25
comment Shrinking a SQL Server Transaction Log
The usual reason for out-of-control log files like this are 1) failure to take regular full backups, 2) failure to take regular transaction log backups, or 3) some setting in your full or log backups (such as copy-only) that is preventing the normal backup marks from being set.
Jan
25
comment Shrinking a SQL Server Transaction Log
As soon as you switch it to Simple mode, you can no longer do transaction log recovery past that point, until your next full backup. Even if you switch it back to Full Recovery Mode, transaction log backup/restore-recover won't start working again until you take another full backup. So be sure to take a full backup immediately after you switch it back to full recovery.
Jan
6
comment SQL Query is getting progressively slower
This sounds very much like a network problem. Specifically, I would look for things like "data shaping" and adaptive network scheduling parameters, that can perform pathologically for database connections.
Jan
6
comment Cities and States (a few data): single table or splitted?
It depends entirely on what you do with them. But in any event, you should not be doing DB design worrying about performance at this step. You design the DB first, according to the data relations. Do this right and the performance will take care of itself 90% of the time. Only later when you know if you have a performance problem, should you start worrying about it.
Dec
23
comment Why doesn't “As SYSDBA” work from SQL Developer?
@BalazsPapp So I have created a password file with ORAPWD FILE=../database/PWD<dbname>.ora ENTRIES=40 PASSWORD=<pasword> and that has fixed the problem, at least wrt explicit sys/<pwd> as sysdba logon with SQL Developer. If you want to post that as an answer, I will accept it.
Dec
23
revised Why doesn't “As SYSDBA” work from SQL Developer?
added 55 characters in body
Dec
23
revised Why doesn't “As SYSDBA” work from SQL Developer?
added 806 characters in body
Dec
23
revised Why doesn't “As SYSDBA” work from SQL Developer?
added 806 characters in body
Dec
23
revised Why doesn't “As SYSDBA” work from SQL Developer?
added 806 characters in body
Dec
23
revised Why doesn't “As SYSDBA” work from SQL Developer?
added 806 characters in body