How to improve Oracle Standard Edition’s performance for testing?

There’s a great post on StackOverflow about improving Postgres performance for testing.

However, there aren’t any resources on doing the same for OracleDB. I don’t have a license for Enterprise Edition, that has features like ‘In-Memory’ columnar storage that would almost definitely improve performance.

I’m really limited in what I can try in Standard Edition. It’s running in a Docker container in a CI pipeline. I’ve tried putting the tablespace on a RAM disk, but that doesn’t improve performance at all. I’ve tried fiddling with FILESYSTEMIO_OPTION, but no performance change.

Would anyone know of some more obvious things I can do in OracleDB in a CI environment?

What are the differences between the various editions of GURPS?

What are the significant differences between GURPS 4th edition and earlier editions?

The recent spate of GURPS questions have piqued my curiosity, and the system looks like it would suit a campaign I’m planning that would start with a world-generation session using a game of Microscope. GURPS looks like it can handle anything the group could possibly create during the Microscope session.

I’m likely to use GURPS 4th edition since that’s the most recently-published edition, but I’m not shy about using older editions of games if they suit my tastes better. Having no prior experience with GURPS, I’d like to know a bit more about the history of the editions and the changes they’ve introduced before I invest in a particular edition’s books.

I’m hoping that this question will be generally useful for people wondering about the differences between editions, not just useful for my particular situation. I deliberately didn’t phrase this as a system-recommendation question for that reason (though recommendations are not an unwelcome bonus!).

Is there an overview of rules differences between various editions of Tunnels and Trolls?

There are several versions of Tunnels and Trolls available, with a good deal of variation in the format between them. Is there a good summary of the changes between the different versions?

(I’m especially interested in the more modern releases: 5.5, 7, The “alternate” system from 7, 7.5, 8, and Deluxe.)

Are there any examples in D&D lore (all editions) of metallic or chromatic dragons switching alignment?

In a previous question I asked about a dragon antagonist I am planning. I originally intended this to be a chromatic dragon because I believed they are always evil, but an answer to that question got me thinking.

In the Monster Manual it states that all chromatic dragons are driven by greed and selfishness and are feared by all people.

Likewise, all metallic dragons are good.

However, are there any examples in the lore of either of these being switched? I imagine it would be more likely that a metallic dragon becomes evil than a chromatic dragon becomes good, but are there any outliers at all?

I am willing to accept any examples from any of the editions of D&D or the broader fiction written around the setting.

How do I pronounce numbers in game editions?

Most game systems use regular English words for their names. If you don’t know how to pronounce "dungeon" or "dragon", or any other regular word, e.g. Cambridge dictionary is of great help.

Proper nouns are a different story, but, generally, some audio or video exists for popular settings where those words are pronounced as intended by the publisher.

What I am having problems with, though, are numbers. If you want to learn how to pronounce dates, prices, etc. in English, there are thousands of websites where you can do it, and it’s studied as part of all or almost English courses at some point. However, no course that I’ve taken has yet taught me how to pronounce numbers in game editions.

In Russian, the literal translation of how we read "D&D 3.5" is "D&D three point five", and I’ve heard this wording in English, too. But things like "3.5e" or "5e" etc. are ambiguous to me. Not even this rather thorough pronunciation guide has an answer to this problem.

So, how do I pronounce numbers in game system names&versions?

What editions of D&D are derived from the d20 system?

The tag wiki on this website says:

For questions about the d20 System, an RPG system originally published in 2000 by Wizards of the Coast. The d20 System was developed alongside D&D 3e and is a derivative of it, but it forms the mechanical backbone for a variety of RPGs entirely departed from the D&D system.

And the wiki page says:

The d20 System is a role-playing game system published in 2000 by Wizards of the Coast, originally developed for the third edition of Dungeons & Dragons.1 The system is named after the 20-sided dice which are central to the core mechanics of many actions in the game.

Much of the d20 System was released as the System Reference Document (SRD) under the Open Game License (OGL) as Open Game Content (OGC), which allows commercial and non-commercial publishers to release modifications or supplements to the system without paying for the use of the system’s associated intellectual property, which is owned by Wizards of the Coast.

It looks, at least to me, to be more of a trademark/legal matter.

But in any case, which roleplaying systems are covered by/derived from the d20 system?

It looks like D&D 4E is not covered by it, or at least the associated OGL, but I appreciate they are not the same thing.

How have the Shadar-kai changed over the editions and is there any consistency to be found in the lore between editions?

In D&D 5e, the Shadar-kai are a sub-race of elves. However, it seems that in 4e, the Shadar-kai were humans. In both cases, they lived in the Shadowfell and served the Raven Queen, so it doesn’t seem likely that they are two separate peoples; rather, they are supposed to be the same "race", despite being human in one edition and elven in the next.

I believe they were also in editions prior to 4e, but I’m only going by the Forgotten Realms wiki page, which seems to claim that they were a kind of neutral evil fey creature in 3.Xe (but generally the information on that page appears to be a mish-mash of conflicting lore from various editions, which is kinda the point of this question).

This is confusing to me; I’m not sure if it’s possible to extract any consistency out of this, but if it is possible, I want to ask:

  • For each edition of D&D that the Shadar-kai appeared in, what were they? Human? Elf? Something else?
  • I’d also be curious to know, briefly, what they were like, since in 4e/5e they live in the Shadowfell and serve the Raven Queen, but in previous editions the Shadowfell/Raven Queen didn’t exist, so what were they all about instead? Again, only very briefly, since this isn’t the main point of this question.
  • For each of these editions, is there any official lore justification for why the race changes? Or is it more like the previous lore was just disregarded and overwritten (such as in the case of 4e -> 5e, where 5e just seems to forget that they were ever human in 4e)? Again, I’m looking for in-universe lore, not designer-reasons.

Since the Forgotten Realms wiki has confused me, I would prefer people to cite from official source book and Dragon magazines and similar, rather than wiki websites like that one.