13,956 reputation
12150
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 2 years, 10 months
seen yesterday

Oracle DBA, Unix admin.

Available for employment! ;)


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?
Are you using rman to do your backups?
Oct
1
answered Can I perform a MAX over a pair of columns?
Oct
1
reviewed No Action Needed How do you capture the output message from a successful MERGE statement when using it in a procedure?
Oct
1
answered Problem with Oracle Rollback Segment Session
Oct
1
reviewed Close How Can I restore a database to a point of time without Old backup?
Oct
1
reviewed Close Which is faster Select Column names or Select *?
Oct
1
reviewed Close Is it possible to create this type of database for a massive forum?
Oct
1
reviewed Close 1000 visitors per day have my web page and MySQL scratching at certain times and my.cnf
Oct
1
reviewed Close MySQL configuration to connect to multiple local applications
Oct
1
reviewed Close How to count this table
Oct
1
reviewed Close MySQL lost connection
Oct
1
reviewed Close Total Fragments 99% and I cant get it to stay down
Oct
1
reviewed Close How to create a view joining 2 tables?
Oct
1
reviewed Close Monthly report by time
Oct
1
reviewed Close Group by + Order by Behavior Explanation?
Oct
1
answered ORA-00257: archiver error