FreeVariable

u/FreeVariable





r/oracle•

I need to inspect th exact queries sent against our Oracle database by various clients, all of which are using Oracle native client (OIDBC) 19.0.0. Is there a way to do that from the database itself?

65

r/dotnet•

I'd like to write a few a Windows services that will probably call into .NET API mostly for the purpose of validating software (checking registry keys, COM objects, environment variables) to assist our deployment team. I thought doing everything using PowerShell but perhaps it lacks some of the capabilities of C# as far as defining services?

1314

r/oracle•

I've got a small Oracle-based application on my hands with about 2000 concurrent connections at any time doing mostly simple CRUD things. Should it in theory benefit from connection pooling? If so, does it suffice to turn server-side DRPC? Does it need a change in tnsnames.ora for clients to make use of it, or does setting dbms_connection_pool.start_pool() is enough? I am not sure how to persist this config...

11

r/oracle•

I started recently writing PL/SQL for my employer and I am a bit surprised that there is no simple way to do something as trivial as changing a user's password on a database B from a database A using APEX. I looked it up and I understand that only non-DDL queries are designed to work over database links. Instead I see the recommendation to create a package / procedure on the destination database (B) and to call it over the DB links (A).

Hence this question: is there a way to do that (change a user's password on B) from A without storing a procedure on B? I guess all I am trying to do is to useA as a client relative to B, to open a session on B with it and to run the query inside the s

35

r/Kotlin•

Hello, picked up Kotlin a few hours ago. Consider:

build.gradle
---
plugins {
    id "org.jetbrains.kotlin.jvm" version "1.8.0"
}

repositories {
    mavenCentral()
}

dependencies {
    implementation "org.jetbrains.kotlin:kotlin-stdlib:1.8.0"
}

I know that Kotlin 1.8 targets Java version down to Java 8. So if my project uses the above gradle.build, will it compile into Java-8 compatible bytecode?

69

r/DotA2•

I am trying to run Dota 2 on Vulkan but it always runs on windowed mode (at a non-native resolution to top it all, which I cannot modify from the game settings).

In a nutshell it's not working at all as it's supposed to. Any clue?

10