New answers tagged

0

I have finally found a solution to my problem and I will explain to help other users in same case. I have no problem to connect to XE instance of Oracle Database using following sqlplus command sqlplus SYSTEM/password@XE My first problem is that PDB is not always open and every time that I stop and start DB services, I must restart PDB. To avoid this, I ...


0

Your listener listens on 192.168.0.14 while you are trying to connect with a TNS entry that uses localhost as the address. This would work on Linux with default settings, but it will not work on Windows like that, so it is expected behaviour. C:\Windows\system32>lsnrctl status LSNRCTL for 64-bit Windows: Version 18.0.0.0.0 - Production on 10-JAN-2020 22:...


2

Anything that you do here will impact performance somewhere. But if it's a requirement then it's a requirement. The methods you've laid out in your question are the accepted, low impact methods of getting that. You can mitigate the large log files by rolling over to a new file more frequently. By default it does that on every server restart, but you ...


2

The clue here is that those connections each share a "parent_connection_id," which per the docs: Identifies the primary connection that the MARS session is using I noticed the aliases used in those queries heavily implies your app is using Entity Framework. Default connection settings (scaffolded out by the Visual Studio project templates) will enable ...


1

View affect of Script before COMMIT in another Window You can use Table Hints such as WITH (NOLOCK) or WITH (READUNCOMMITTED) to perform dirty reads of uncommitted data between two windows in SSMS. View data stored in #TempTable from another Window You can use global temporary tables (##Table instead of #Table) to query temporary tables across sessions. ...


3

If I'm doing something wrong or missing some Point please let me know. You're not missing anything. SSMS always has a separate session per tab. it's SUCH a pain to run a script... and then from that same tab have to then write in other code when I don't want to edit/add any other code to the page that contains the script I ran. In SSMS the Execute ...


Top 50 recent answers are included