All present processes are consistent to alive sessions. Extra information that would be useful would include user, session id etc. Declare @startdate int select @startdate =.
We have a customer who wishes to switch from an oracle backend to microsoft sql server, which isn't a. I'm trying to find my listener.ora file to edit it, but the docs say it's in the oracle_home directory, but where is that? Your sqlplus line looks correct, verify the following:
What is the difference (if any) between a database, a user, and a schema? I've also checked all linux processes related to oracle and found no zombies: How can you show the sql that is currently executing on an oracle db? I have written the following sql:
My main skills are with sql server, but i have been asked to do some tuning of an oracle query. 15 one of our products supports both oracle and sql server as database backend. You can connect as the user you are trying to on the database. For example, if i create this acl, how can i view what settings have been applied to it?.
For our application we have a configuration file for connecting to the oracle database (url, username, password). 10 so i have an oracle database (standalone) running in rhel and i have scheduled rman for backups on daily and weekly basis. This happens not for all the killed. You can connect as sysdba on the database server itself.
I'm running 12.1.0 on windows server 2008