Skip to Main Content

Questions

QuestionUpdatedAsked

Dear AskTom Team,I'm getting crazy wondering why a query with a FIXED baseline runs only sometimes with plan fixed by the baseline.<code>SQL_HANDLE LAST_EXEC FIX REP CREATED------------------------------ -------- --- --- --------SQL_1a03d3b...
33 hours ago7 days ago

I've installed Microsoft's ODBC driver and configured various files in an attempt to create an ODBC connection from my Oracle database to SQL server, but I'm having trouble connecting from SQL Developer. Using the terminal, I can connect to the SQL Server succ...
39 hours ago2 days ago

Hello, I am trying to figure out why this answer is correct regarding a LONG data type.Here is the questionEMP_DETAILS table<code>Name NULL TYPEEMP_ID NOT NULL NUMBEREMP_NAME NOT NULL VARCHAR2(40)EMP_IMAGE LONG</code>...
2 days ago3 days ago

Hi Chirs/Connor,Couple of question related to Table data movement from Primary DB to Archival DB.We are having Two DB's - Primary (holding current 2 years of data) Archival (Primary data + historical)We have separate Archival DB using IMP/EXP from Primar...
2 days ago7.4 years ago

I have a huge partitioned table(about 3TB) that has a constraint(PK) in "enable novalidate" state.I have to alter the state to "enable validate" state.<code>alter table TEST enable validate constraint PK_TEST;</code>The table belongs to the database(exa) in pr...
2 days ago6 days ago

Hi Tom,Need your kind help to check and advise. i need to find number of hours employee worked between 10:00 PM to next day 06:00 AM between two days.Ex: 1. employee work schedule is 11-MAY-2012 16:00:00 to 12-MAY-2012 09:00:00 Ans: Night hours would be 8 hour...
2 days ago9 days ago

Hi Tom,I have a requirement to update/Delete(permanent) the archived(Data deleted. But present in flashback archive) data.Can we update/delete(permanently) a record/set of records present in flashback archive?...
2 days ago7.1 years ago

I have a case where RR date format is not returning expected result... to_date('960504','rrmmdd') returns 2096, not 1996.I seem to recall back in Y2k an inti parm that influenced the action of the RR format.... but I can't find it. Am I imagining this?...
6 days ago6.8 years 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...
7 days ago6.8 years ago

Hi Tom,We are creating a table that will be loaded daily. We want to partition the table by as of date. Is the best practice to create the partition using the partition by list automatic or partition by range using 1 day interval? Does one option give better p...
7 days ago2.2 years ago

I have been using AQ, and now I am trying to utilize Sharded queues in 19c. I am trying to understand some basics. I want to have single-consumer queues, and upon dequeue the record should be removed from the queue table. In the AQ (classic queues) it used to ...
7 days ago9 days ago

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...
7 days ago9 days 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...
7 days ago9 days 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...
7 days ago10 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...
7 days ago20 years ago

Is it possible to use array as a procedure parameter? ...
8 days ago8 days 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...
8 days ago17.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 ...
9 days ago9 days 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...
9 days ago10 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 ...
9 days ago10 days ago