Reputation
653
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 18
Impact
~51k people reached

  • 0 posts edited
  • 1 helpful flag
  • 44 votes cast
2d
comment Why set Auto Update Statistics to False?
I was trying to think of an example where auto_update_stats would actually cause problems and this is a great one - I'd upvote it twice (if I could) for the excellent work-around as well, avoiding the normal stats delay that would accompany a query
Mar
17
accepted 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?
I didn't realize this was a syntax issue - thanks for pointing me to the correct system view!
Mar
17
comment ORACLE: Can I get results of “SHOW PARAMETER” into a variable or table?
@JustinCave Hmm, I sure can - I didn't realize those were synonymous (betraying my primary focus of MSSQL, not Oracle). If this were an answer, I'd accept it :)
Mar
17
asked ORACLE: Can I get results of “SHOW PARAMETER” into a variable or table?
Feb
6
awarded  Famous Question
Nov
18
awarded  Nice Question
Aug
31
awarded  Popular Question
Aug
19
comment Add an additional listener to Oracle Database Appliance
The link you've provided for the walk-through isn't valid any longer (the domain doesn't appear to be online). Is there an updated link that you can provide? I'd like to configure our ODA to have a second SCAN name on a separate subnet and enable client connections from both sources, but I'm being told this isn't possible by somebody who has worked with the ODA before (but it may be the case of not being possible through the wizard, but possible through manual config). Thanks!
Jun
25
awarded  Taxonomist
Jun
15
accepted Does SA account need to be called “SA” or can I rename it safely?
Jun
15
comment Does SA account need to be called “SA” or can I rename it safely?
@AaronBertrand Agreed that's what's best, but the code isn't under my control and the team responsible is dragging their feet on fixing it (from their perspective, nothing is wrong and it works now). I'm trying to ensure that things don't break when we move to a new server, but that I gain the control of security and stability that I've been wanting for a while.
Jun
12
comment Does SA account need to be called “SA” or can I rename it safely?
@AaronBertrand Normally it wouldn't gain anything, but in this case there are applications that run using the SA account but which don't need SA rights (previous bad habits from developers) and I'd like to give them an "SA" account with the password they expect but limied rights, and move the actual sysadmin account to a new name where I can disable it. I just can't disable the account called SA because then their deployed applications break (getting this to fix this is another fight, but looking for what's under my control).
Jun
12
awarded  Yearling
Jun
11
revised Does SA account need to be called “SA” or can I rename it safely?
changed title to clarify a bit
Jun
11
asked Does SA account need to be called “SA” or can I rename it safely?
Feb
11
awarded  Nice Question
Jan
29
awarded  Citizen Patrol
Jan
21
awarded  Popular Question
Dec
10
awarded  Notable Question