@JohnK.N. Thanks for replying, what do you mean, when you said it will tell me what it prefers?? based on my understanding this is where i setup the connection manually and it can be anything I want as long as it exists. here's the content of the file
i understand from this file that i can connect to orcl or orclpdb using the localhost:1521 and the only difference i noticed is that orcl is dedicated server but i dont understand what it means
Basically your TNSnams.ora is the configuration file which defines how you connect to an Oracle Database (instance).
SERVER = DEDICATED will connect you to your instance directly via a dedicated connection. Your connection doesn't have to be given to you by a Dispatcher process and you will have a certain amount of memory allocated to you connection (vs. a lower amount of memory in a SHARED connection, where a DISPATCHER will assign you a connection).
There are certain processes which have to be DEDICATED, because of certain constraints. One of them being RMAN (Recovery Manager) which performs backups. So I guess that the RMAN process will be using the ORCL connection string to connect to your instance and normal users would use ORCLPDB.
The advantage of SHARED over DEDICATED is that you can have more connections when you set up a SHARED Server connection. The advantage of a DEDICATED connection is you have the process all to yourself.
OINC™
The IPC protocol is a kind of in-process-memory protocol that allow you to connect to your local instance without using the network stack. Your connection is direct. A bit like SQL Server's shared memory protocol when you connect to a local instance of SQL Server. Creating a Valid Connection String Using Shared Memory Protocol
If you add TAB to you configuration then you might be able to understand it better. I added Comment lines to separate the individual configuration "sections".
I'm using Azure SQL DB and noticed that one of my largest databases appears to have a primary key index with a total size of 6Gb. However, the total rows in the table only amount to around 78k rows at any given point in time.
This table stores outbound email and sms messages, so it fills up and g...
i suppose it could be something interesting but the overwhelming impression i got was of someone who just doesn't have a handle on what their dataset is 🤷♂️
probably you and i have different jobs so we expect different things 😜
> With my own local testing, it seems removing rows from this table does reduce the size of the PK, but this does not appear to be happening on the production database.
I wonder how well-matched their local testing is to the production environment
you know what bugs me, using reserved keywords as table or column names. Like [Case] for instance. Also, table names should be damn plural, like [Cases], if the table contains more than one case.
I know that last bit is like the commas-vs-tabs thing, or the commas at the start of the line vs the end of the line. But adding an s to the table name means it's no longer a reserved keyword.
@HannahVernon I'm more annoyed that so many reserved keywords are for real-world concepts. Name, User, etc.
But even if I'm using something that is a reserved keyword (except columns like name, description, etc) usually there's some other context that is missing from the entry. "This table is LOG" "...okay, LOG for what?"
And you can take my singular entity names from my cold, dead hands.
@mustaccio The table is Appendage, AppendageType = 'H', Temperature = 0K
You have to go to the Individual table to determine pulse from the date of death.
Am I really going to use Python to do dumb text file processing for ad hoc stuff sent to me in Excel files? Or just return to the rusty swiss army knife that is SAS?
I use Powershell and I find it's just generally a lot more flexible for everything.
Begin able to do everything in one environment is pretty amazing. Like SQL to get a collection of something, then do something in the Windows Scheduler, put up a window for input, and execute any other command line and then also bring in someone's .NET DLL and call the methods.
Last week, as part of our Outdated Answers project, we ran a test on Stack Overflow to see what would happen if we stopped pinning the accepted answer to the top of the list of answers. As expected, there were no negative repercussions when we made this change. So, as promised, today we are makin...
This sounds like a great change. It'll be nice when our votes matter on other parts of this site too, like moderating moderators. I'd like to downvote the racist ones StackOverflow habitually ignores. Like chosen answers, just because they were picked once and often with insufficient information doesn't mean they should linger forever. — Evan Carroll38 secs ago
