New answers tagged

0

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 ...


2

"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 ...


0

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, smi.host AS Master_Host, smi.user_name AS Master_User, smi....


0

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