Reputation
15,464
Top tag
Next privilege 20,000 Rep.
Access 'trusted user' tools
Badges
2 28 53
Newest
 Electorate
Impact
~1.1m people reached

May
14
comment oracle bulk loader processing columns with newline characters
Tom knows: asktom.oracle.com/pls/apex/…
May
14
comment Oracle 12c database cannot log in as a local user
Edit your post with the output of lsnrctl services. Have you edited your tnsnames.ora and added an entry for PDBORCL? If not, you can use netca to add one for you.
May
13
comment How to capture a manager highest level from bottom in mysql?
Wow, a company with 100k employees using MySQL to store personal data :P
May
13
comment TAF vs SCAN in Oracle 11gR2
As far as I'm aware, TAF requires your app to be TAF-aware. It's not just a magic silver bullet.
May
13
comment Is there a way to check which views have data? Oracle 11g
No, there isn't. You'd have to write a little script to automatically either explain plan them all, or something similar. DBA_TABLES etc exposes the approx number of rows in a given table (depending on stat freshness), but there's no equivalent for views because they're essentially just a result set that's unknown until runtime
May
13
comment ORA-01461 in a msaccess linked table
Is the resulting data in your access app greater than 4000 bytes?
May
12
comment How to load .dat files to oracle database
If they're CDRs, they're more than likely to be in ASN.1 format. Try opening in an ASN.1 viewer
May
11
comment Oracle RAC, unable to connect to node vip
Almost certainly a firewall problem
May
10
comment MySQL JOIN query produces wrong result
mysql really needs to up its game in this regard.
May
8
comment Oracle 11gR2 RAC unable to connect to SCAN address
Can you ping the SCAN address.
May
8
comment ORA-00600 argument description
Use the ORA-600 lookup tool on the Oracle support site.
May
7
comment Challenged with modeling a big DB
Any RDBMS, given a correctly designed data model, can do this these days. The volumes you're talking about are not by any means gigantic. Oracle, Postgres, SQL Server would all do what you require with ease. I can't comment on NoSQL approaches.
May
7
comment Critical tablespace usage UNDOTBS (96%)
Yes, you can do it while the DB is up
May
7
comment Selecting different values from different columns
Why isn't the first queues='ACS' row selected (24-02-2014) instead of the 2nd one? Do you mean you want the newest ACS row as min and newest GHK as Max timestamp, for the same group name? You're going to have to explain the logic better, as it stands it isn't answerable
May
5
comment unable to add index to column, duplicate entry
What is the definition of the index you are trying to add? Seems a bit odd that you'd have a timestamp as a PK.
May
4
comment Maxing out the shared pool's memory by executing many UPDATE statements (ORA-04031)
Are you using bind variables (prepared statements)? I'm guessing not, as that's more than likely the cause of the problem (many identical statements, apart from the liberals, filling up the shared pool).
Apr
29
comment Is using ASM a pre-requisite for RAC?
@a_horse_with_no_name SE1 single node is the cheapest way to do it due to pricing per socket, rather than core. Made it quite popular.
Apr
28
comment Using SESSION sql_mode = 'NO_BACKSLASH_ESCAPES' before running query to remove backslashes in database
Test it with a simple test case?
Apr
27
comment Why can an Oracle SET UNUSED COLUMN cause internal UPDATE SET X=X and huge log generation?
All it is supposed to do is set an internal flag.... I'd open an SR with Oracle on this one. As an aside, is it actually doing any harm? It might cause you problems in the future if you do any partition exchange operations. Might be doing it just to make sure there's no NULL rows (seeing as it is defined as NOT NULL), for some odd reason. Sorry, just thinking aloud :)
Apr
26
comment Mysql slow query log always include “# Time:”
Not hard to keep a running variable in your parser with the current value of time. I guess it depends on what your parser is written in.