I'm running Sinusbot (the only decent music bot for teamspeak) on an on-demand instance. I have never had this issue with anything (TeamSpeak server, a bunch of scripts, other open source servers etc. etc.), even with other ytdl music bots. But specifically Sinusbot spikes CPU usage (to about 20-30% from almost nothing), which causes a lot of stuttering, due to CPU not being available instantly and it nor prioritizing playback, over fetching other music (at least that's what I assume it is). Is there anything I can do? Like something, that would temporarily increase CPU base-load when needed ..read more

Hi All. I am trying to figure out how to query a value that contains certain strings and ONLY those strings. For example: Row 1: a;b;c;d Row 2: a;b;c Row 3: a;b;c;s;k Row 4: d;e;f Each row must contain a, b, and c but nothing else. Does anyone have any ideas about how to write the query? Thank you! submitted by /u/FixItFlyers [visit reddit] [comments ..read more

Hi guys, we need to reclaim unused space from datafiles as this specific database has almost 50% fragmentation now . The reason to reclaim space is, there won't be any new data going into this DB anymore , also we need the space at disk level as soon as possible . Since we don't have space left at disk level we cannot perform tablespace reorganization by moving objects . We cannot perform datapumo as well , don't wanna drop and reimport schema. What we are trying to do is reorg tablespace in place . Enable row movement,Truncate and delete specific tables , then run shrink space cascase , move ..read more

at the beginning of the backup, I do this configuration: CONFIGURE RETENTION POLICY TO REDUNDANCY 2; CONFIGURE BACKUP OPTIMIZATION ON; CONFIGURE DEFAULT DEVICE TYPE TO DISK; CONFIGURE CONTROLFILE AUTOBACKUP ON; CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '$BACKUP_DIR/autobackup/CONTROLFILE_%F.ctl'; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; CONFIGURE MAXSETSIZE TO UNLIMITED; SHOW ALL; alter system archive log current;" for a full backup I do this: $R ..read more

In an ERD, I have a non-transferable relationship between 2 entities. How do I handle or code this when creating the tables? submitted by /u/obnoxus [visit reddit] [comments ..read more

Hello All, So I'm NOT AT ALL working on Oracle but need some help in understanding certain fundamentals for my research work ( For a client) His ask was to show the footprint of Oracle applications and technologies. I DO NOT understand the difference between oracle applications, Oracle technologies and Oracle systems. Can someone please please explain the difference with examples? Please? submitted by /u/Mxo7746 [visit reddit] [comments ..read more

Hi, I followed Oracle's installation steps for 19c on Oracle Linux 9.3, but I've been receiving the follow error while trying to run DBCA: UnsatisfiedLinkError exception loading native library: njni19 java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/19.0.0/dbhome_1/lib/libnjni19.so: /u01/app/oracle/product/19.0.0/dbhome_1/lib/libclntshcore.so.19.1: file too short I'm not sure how to fix this error. submitted by /u/j_relic [visit reddit] [comments ..read more

A buddy accidently deleted the local policies in his SBC. Is there a way to recover them without a current backup? He has a download of the policies, which he pulled before they were deleted, but isn't sure if he can format them into a .csv file and upload them or if there is a magical "undo" type command. Thanks in advance. submitted by /u/Chazlupa [visit reddit] [comments ..read more

Did anyone else get the Executive Update invite for Monday morning (4/15)? Seems cryptic. Can't be forwarded and the attendees list is hidden. What's the tea sis? submitted by /u/joyful-wombat [visit reddit] [comments ..read more

Can anyone clarify for me that the Host Ip Address in the Debugger settings in vs code, refer to the Ip address of your current computer, IE the computer that is running VS Code, I put in my own address and try to debug and just get Could not start PL/SQL Debugger. <myip adddress> is not a valid IP Address. Please specify a valid IP Address using PL/SQL Compiler and Debugger Settings. If I put in like 127.0.0.1 it starts, but that is obviously incorrect, the database wherever it lives at needs to know the IP of my computer to connect back. Unless I'm completely misunderstanding how this ..read more