Hello TomWe have a windows server with 40 CPU with 10 sockets and 96 GB RAM and this server CPU keeps hitting 100 perc whenever application team runs there load and the number is session also gets very high . When we check we find many of there queries showing... | 3 hours ago | 35 hours ago |
Hey Tom,While this isn't a technical question, I hope it finds its place in this forum.I'm looking to sit for the 170-071 (Oracle Database SQL Certified Associate) exam as a complete beginner. I have a broad understanding of what a database is and its use case... | 3 hours ago | 37 hours ago |
I want to validate the clob column from the source table using db link, but I am not able to fetch the clob column from the source table via db link. I am not having any permissions to the source db(create view/create table/PLSQL execution) other than read acc... | 3 hours ago | 2 days ago |
Tom,What is the difference between Checkpoint, incremental checkpoint & rolling checkpoints? I've read that an incremental checkpoint occurs every 3 seconds as opposed to a checkpoint which occurs based on fast_start_mttr_target, log switches, instance shutd... | 3 hours ago | 20 years ago |
Is it possible to use array as a procedure parameter? ... | 20 hours ago | 21 hours ago |
Hi,Can we create Composite sub-partitions on multiple columns using templateExampleCREATE TABLE sgs.part_test( order_date_time SYSTIMESTAMP, modulo_store_id NUMBER, recurring_flag CHAR (1))PARTITION BY RANGE (order_date_time) INTERVAL ( NUMTOYMI... | 20 hours ago | 6.8 years ago |
Hi Tom,When I was using 10g EM to clone an instance, it restricted me to creating database name and sid to be larger than 8 characters. The oracle is installed in NT. Is there a way to bypass the restriction? Thanks a lot.Regards,Keane... | 20 hours ago | 17.5 years ago |
We are using DB v19.0 with the latest patches. We are in Greece but our packages / procedures and client apps are designent to work on AMERICA NLS_TERRITORY, so everything works fine!But in some cases, some 3rd party apps, are connecting to our database using ... | 41 hours ago | 42 hours ago |
Hello, Ask TOM Team.Scenario:1. We have to deploy a feature in one app. The change consists of avoiding duplicates (mix of three database columns).2. In the database site I have to add one column to a table (200+ millions) and then update it so the app can val... | 41 hours ago | 2 days ago |
I learned from the documentation of 11g that “Oracle Database always enforces statement-level read consistency”, <b>which I think should mean that every query in a single statement (including subqueries, excluding queries in PL/SQL functions) is consistent to ... | 2 days ago | 2 days ago |
I have a scheduled job on Oracle which does counts before and after delete statements and spools the results to a log file on the Oracle server. The job is type SQL_SCRIPT. When I execute the job the SQL statements are also included in the spool file even th... | 2 days ago | 3.5 years ago |
Hi,I will be starting my development for an Archiving project. Aim is to move all the old data from Production database and make it lighter. It consist of 2 parts. One is to move all data except the latest 6 months into an Archiving database in Oracle from PRO... | 2 days ago | 2 days ago |
hi tomi have a databse with 125 tables. i can find the total number of tables of the database by the sql select * from tab; now i would like to know the number of rows in each table of my database with out executing select count(*) from...; each time.please... | 2 days ago | 22.7 years ago |
We have a UI based application where users come in and setup SQL's to get excel based reports back, there are multiple options to chose on the schedule of the SQL execution and other related parameters. It's a free text box, the expectation is that the users w... | 2 days ago | 8 days ago |
Hi Tom.I'm a great believer that a backup you haven't tested isn't a backup, so I'm trying to ensure that our RMAN backups get automatically verified, however I've come across some weird behaviour with rman backup validation.My aim is to run full verification ... | 2 days ago | 5 months ago |
Hi Tom,My first time asking a question here. Am querying a historical table which not only has START_DATE and END_DATE, it also has CURRENT_FLAG where CURRENT_FLAG = 1 corresponds to END_DATE is null.I assume that the CURRENT_FLAG column (all 0s and a 1) woul... | 2 days ago | 11 days ago |
dbms_output.put_line has limitation of 255 characters per line. How can I get out of this limitation, so that I can use dbms_output.put_line to have 480 character per line ... | 2 days ago | 24.1 years ago |
Hi TOM,Sorry for asking this basic question (After two hours of searching, I am unable to find the answer)Let's say I have run opatch in an ora19 home to patch the binaries.But then I "forgot" to run datapatch.Is there any dictionary view to tell me that I "fo... | 2 days ago | 12 days ago |
HiI have a query that is spooling results to a text file via an automated process Monday to Friday. Below are the variables that are used in the query. The queries returns data in Oracle SQL Developer, but returns only the headers with no data when I use Toa... | 2 days ago | 2 weeks ago |
I have an issue with the 19c data pump export and I'm wondering if there is a data pump export parameter or some other strategy for resolving it.When a table's primary key is created as part of the create table statement, a unique index is automatically create... | 2 days ago | 5 years ago |