How can you show the sql that is currently executing on an oracle db? What is the difference (if any) between a database, a user, and a schema? You can connect as the user you are trying to on the database.
The Beauty And Feminine Essence Of Modesty In Attire
My main skills are with sql server, but i have been asked to do some tuning of an oracle query. Some of these batch reports will try to access a database table. You can connect as sysdba on the database server itself.
I just need to buy some time on the production server until i can release the software update.
Are you actually setting values for the sga components and/ or the pga separately? What version of oracle are you using? 10 so i have an oracle database (standalone) running in rhel and i have scheduled rman for backups on daily and weekly basis. I know the reason for this and i know the fix.
Something along the same lines as this, which lists the current user's tables: 48 we've been using bi software and a repository database that are installed on oracle enterprise 11gr2. 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:
The title says it all, is there a way to quickly list all the current database links in oracle?
I have written the following sql: Declare @startdate int select @startdate =. I'm running 12.1.0 on windows server 2008 Sometimes my file system (archive.
If you're using a recent version of. Extra information that would be useful would include user, session id etc.
