Oracle DBA, Unix admin.
Available for employment! ;)
|
1h
|
|
comment |
Does Logical Fragmentation Meaningful in the age of huge SANs? I'll add that this is something that frustrates me these days - 10 years ago I'd dictate tablespace mappings (I'm an Oracle DBA) to clients and tell them what storage to buy for a hybrid OLTP/reporting system. I knew what disks they had and what configurations (RAID 5 for boring stuff, 0+1 for perf etc). Now, you're lucky if the "storage admin" even knows what has been presented to your DB host. Don't even get me started on thin provisioning! Anyway, SQL Server Question, so I'll leave it to the SQL Server people :) |
|
1h
|
|
comment |
Does Logical Fragmentation Meaningful in the age of huge SANs? Best question I've seen on the site recently. Welcome, and +1. Looking forward to some quality answers. |
|
1h
|
|
comment |
Postgresql - how to drop a trigger drop trigger triggername on tablename; should work... How odd. |
|
1h
|
|
answered | Oracle 11g install on Debian Wheezy does not start |
|
8h
|
|
comment |
Oracle 11g install on Debian Wheezy does not start Seems strange that the ORACLE_SID is AL32UTF8 - that is the character set... Is there an /etc/oratab file on your system? If so, edit your question with its contents.
|
|
8h
|
|
accepted | Migrated questions, quality, and frequency of returning users |
|
9h
|
|
reviewed | Reject suggested edit on mysql import - database not found error |
|
9h
|
|
reviewed | Close change data directory postgres with database cluster |
|
9h
|
|
reviewed | Close What is causing the Periodic High Disk IO writes on MySQL Apache Server |
|
9h
|
|
reviewed | Close Query for Oracle database |
|
9h
|
|
reviewed | Close How to Change location of postgres cluster and database within the same machine? |
|
20h
|
|
comment |
Query for Oracle database I hate to say it, but have you tried writing a query? How is your SQL knowledge? Edit your question with your attempts. |
|
May
16 |
|
comment |
DELETE vs TRUNCATE (Oracle) RE truncates - Though if you have FLASHBACK DATABASE setup you can recover the DB to a previous SCN and get the data, but it requires a database bounce. See gavinsoorma.com/2009/08/using-flashback-to-rollback-a-truncate as an example |
|
May
16 |
|
comment |
Oracle PL SQL EXTREMEMLY slow FETCH performance What else are you doing in the loop? If you're doing an update, delete or insert it will be relevant, so edit your question with exact details. |
|
May
16 |
|
comment |
skip columns while using LOAD command mysqlLOAD DATA INFILE 'file.txt'
INTO TABLE t1
(column1, column2, @discard3, column4);
|
|
May
15 |
|
answered | skip columns while using LOAD command mysql |
|
May
15 |
|
reviewed | Approve suggested edit on What's the difference between functions and stored procedures? |
|
May
14 |
|
awarded | Caucus |
|
May
13 |
|
comment |
How to merge data from 2 databases Before it got edited.... Sigh. |
|
May
13 |
|
comment |
How to merge data from 2 databases Assuming SQL Server? |
