On sql server 2008 r2 how do I check that tempdb files are configured for one data file per physical processor core? I have been looking on SQL Server Studio screens, but I haven't been able to find where can I find that information. Is this one of those situations where you need to run a script to find out the configuration, or can I find the data on SQL Server Studio?
When you install an Oracle database in a Unix server, the Unix user id you use for the installation becomes the OWNER of the database. What is the most reliable and general way of determining in a shell script which Unix user is the owner of an Oracle installation? I mean, can you perform a grep on a file created by the installation to find this information or shall I resort to use the ls command on a specific file on a specific directory. If the name of the file to be checked is also variable, I would need to have a way of determining the name and path to the file.