13,664 reputation
12048
bio website google.com
location Manchester, United Kingdom
age 36
visits member for 2 years, 7 months
seen Aug 15 at 22:22

Oracle DBA, Unix admin.

Available for employment! ;)


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.
Jul
16
comment Oracle Export using EXPDP gives ORA-06512 SYS.UTL_FILE error on Windows 7
Does the Oracle service have permission to write to that directory?
Jul
2
comment How to model ski rental equipment
In rent_detail I'd have a date_due and date_returned - that way you can model late items.
Jul
2
comment Find out which client IP and Query using highest network Bandwidth from SQL Server
This question appears to be off-topic because it is about networking
Jul
1
comment Table income and expense is better to have it together or apart
They HAVE to be separate. Google for T-based accounting or accrual vs accounting
Jun
28
comment How i can solve “ORA-03113” error when i startup oracle 11G database?
It should be recover database;
Jun
27
comment Unable to create Central Inventory
oinstall usually owns the inventory, I think
Jun
27
comment ORA-12518: TNS:listener could not hand off client connection ORACLE XE 11.2 x64
Reboot, then restart everything. What OS are you running on (I realise Windows, but what version?)?
Jun
27
comment Oracle Enterprise Manage “CPU utilization” is confusing
Very well explained. +1
Jun
27
comment Trying to run a shell script from dbms_scheduler . Throws error no matter what the script is?
What Oracle version? Are you patched up to the latest patch set (11.2.0.4, for example)? If not, patch. The ORA 600 lookup tool on My Oracle Support should then be the next thing to use. If that's no help, open a support request with Oracle.
Jun
26
comment The best way to query a partitioned table in Oracle
The optimiser should automatically do partition pruning if your partitioning strategy is sound. Shouldn't need to code around it.