4,652 reputation
21428
bio website stackoverflow.com/users/…
location France
age 37
visits member for 3 years, 2 months
seen 11 mins ago

“Well!... That takes the biscuit!”

Joyce, James. The Dubliners

The best way to speed up something is to not do it in the first place.

Kyte, Thomas.


29m
comment Oracle PLSQL code recovery
TNS-12514 isn't usually a big problem. Can't you connect "/ as sysdba" from the server? Looks like you're trying to solve the wrong problem, your database probably isn't dead (unless there are thing you haven't mentioned).
1d
awarded  Nice Answer
1d
comment When is mariadb creating tmp tables?
I'm not familiar enough with MySQL, but I'd try the random limited select on pics in an inner query, and join on users outside - looks like it is materializing that "where-less" join.
1d
revised Using transactions in sqlplus
added 39 characters in body
1d
comment increasing disk space for mysql data volume
You can't have zero downtime and zero risk with a structural change to your database (even if there's a way to move the logs online - no idea if MySQL can do that - it's still a "risk" insofar as it deviates from standard operational conditions). If you're not in a hurry, use this time to prepare/plan a downtime properly, or thoroughly test alternatives.
1d
answered Using transactions in sqlplus
1d
comment increasing disk space for mysql data volume
Yes, I know, just haven't seen anyone use that filesystem in a while. What's your exact problem then, if you know you can resize your FS without downtime? Can't take the risk?
1d
comment increasing disk space for mysql data volume
LVs and filesystems can be resized online. (Although I haven't seen reiserfs in ages.)
2d
comment ASM configuration in linux
Oracle provides documentation for their install & upgrade procedures, as well as for migrating to ASM. Follow those. If you're stuck at some point, describe your exact problem.
2d
comment MySQL: #126 - Incorrect key file for table '/tmp/#sql_9dc_1.MYI'; try to repair it
Please edit your question to indicate what you did try and exactly how it didn't work. Otherwise you're likely to get the exact same advice again.
Oct
18
revised Unit of COST in an Oracle execution plan
added 5 characters in body; edited title
Oct
18
revised Unit of COST in an Oracle execution plan
added 4 characters in body
Oct
18
answered Unit of COST in an Oracle execution plan
Oct
18
comment Oracle Standby Database - Archivelog GAP
I'm sorry I don't understand your scenario. If the standby has logs from D->P and P->R, then looks like it has everything. What's the problem exactly?
Oct
18
comment Datastage job gets aborted after succesful compilation
You'll need to find the exact error that's causing your job to abort. We can potentially help if that error is database-related and you can show the exact error and the SQL that caused it. Without that though, we can't really help.
Oct
17
revised Why is MySQL Server software so huge?
deleted 5 characters in body; edited title
Oct
16
comment How to handle big table?
"BigData" is meaningless, "handling" it about just as much. There's no one way to deal with large amounts of data, it all depends on the situation.
Oct
13
comment ORA-03113: end-of-file on communication channel” on startup
Look at your alert log for errors, can't help you without more info. (And buy an UPS.)
Oct
12
comment reduce the cost of maintaining a materialized view?
Please edit your question to add a tag for the database system you're using (Oracle?) and include the version. What exactly do you mean by cost of maintenance? What issue are you trying to avoid?
Oct
11
comment Call to Function in Oracle says it's not declared
Did it compile without errors? Is your user authorized to call it? Did you try prefixing it with its owner's schema? What's the exact error message?