13,806 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 9 months
seen 12 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


12h
comment Mysterious LOAD DATA LOCAL INFILE
Obviously there's something else going on - I'll summon @RolandoMYSQLDBA - he can tell you how to work out what else is going on at the time. It could be due to disk IO or CPU issues at the slow times though
1d
comment Unit of COST in an Oracle execution plan
Go and read Cost Based Oracle Fundamentals by Jonathan Lewis. Amazing book
2d
comment Oracle SGA memory areas
It's just the way it's displayed, nothing more. Probably been like that for 30 years.
2d
comment Configuring sqlnet.ora and tnsnames.ora on the client side
Those settings are meant for disabling OCI signal handlers, by the looks of things - nothing to do with logging. Don't really see how it'll help troubleshooting a problem with a java app. What's the actual problem you're trying to diagnose? (Ignore everything you've been told to do, tell us the original problem)
Oct
17
comment ORA-27100: shared memory realm already exists oracle
Edit your question with the output of ipcs -a|grep oracle and ps auxww| grep pmon
Oct
15
comment How to aggregate related rows
There's no 12:10:00 in your data. Where does it come from? Explain how trips are derived from points. Looks like 1,2,3,2,1 then 1,2,3,2,1 but, explain
Oct
15
comment Oracle 11 express vs Oracle 11 enterprise performance
Crappy comments so far. You need to compare the query plans on both instances
Oct
10
comment Oracle estimate cardinality on partitioned table
Your question makes no sense. Everything depends on how the table is partitioned and whether the indexes are local are global.
Oct
6
comment What is the use of Archivelogs?
You've completely ignored the question. The user wants to know how to do a point-in-time restore.
Oct
6
comment What is the use of Archivelogs?
Are you using rman to do your backups?
Aug
10
comment Is this SQL schema normalized according to 3NF?
Why is it important that it is specifically 3NF? If it's a design for an actual live database, performance etc is paramount, not being textbook compliant.
Aug
8
comment Order by for 2 row result causes 800% performance hit
Ordering a large set is computationally expensive.
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
since when were facts and technicalities involved in this question? :)
Aug
8
comment Is it Possible to Recover Data from a BLACKHOLE table?
Are you running on Unix? The data might be in /dev/null
Aug
7
comment What is this view being used in my query?
Jonathan Lewis to the rescue: jonathanlewis.wordpress.com/2011/02/27/internal-views
Aug
7
comment What is this view being used in my query?
Edit your question with the full query plan.
Aug
6
comment Last few rows from a non-indexed table in Oracle
There's no silver bullet here. The Oracle end will have to submit, plain and simple (the DBAs/business owners, whatever). You need to engage with them and talk some sense. We can't really solve business issues on this site
Aug
6
comment Last few rows from a non-indexed table in Oracle
@Jon true, but that would become stale. He'd still have to tablescan many gigabytes.
Aug
6
comment Last few rows from a non-indexed table in Oracle
Not much you can do without an index. Are you allowed to put an AFTER INSERT trigger on the big table? You could use that to populate a smaller indexed table.
Aug
6
comment Last few rows from a non-indexed table in Oracle
What does "last few rows" mean? There is no ordering in your query, which makes the question meaningless.