New answers tagged


I don't know if it answers your question, but I'd like to point out a couple of things. You need to get your terminology straight for a meaningful discussion. Speaking of "disk drives" in the context of a SAN is a bit misleading. What you see as "drive D:", for example, on Windows, if that's what you mean by a "disk drive", is ...


"could this potentially affect SQL Server's read/write performance?" yes. Here are some things to consider: 1 - The type of file(s) matters in context of performance. Files which are often read/written to will of course share the resources with the SQL Server files. Files which aren't being accessed when SQL Server files are being accessed won't ...


You can delete the single channel by deleting the entry from the table mysql.slave_master_info. For example: delete from slave_master_info where channel_name=''; And then use the query to show slave status running status something like below: SELECT channel_name AS Channel_Name, AS Master_Host, smi.user_name AS Master_User, smi....


According to our database admins, this is a known ORACLE error since version 12. We have been advised to set pga_aggregate_limit to 0 in order to work around this problem. I haven't been able to test this thoroughly, but we haven't seen errors since changing this setting (using alter system, we haven't set the parameter in our database's [s]pfile).

Top 50 recent answers are included