Tag Info

Hot answers tagged

2

Bug 11872813 - V$PGA_TARGET_ADVICE VIEW IS EMPTY. After setting PGA_AGGREGATE_TARGET > approximately 12G the V$PGA_TARGET_ADVICE view is empty. This issue will be fixed in version 12.1 and a fix is expected to be included in patch set 11.2.0.4. Apply Patch 11872813


2

Try creating a temporary table to hold all of the IDs you want to search on then join in that temporary table. create table tmpIds(id int not null) insert into tmpIds (59156) insert into tmpIds (57045) etc... SELECT COUNT(*) FROM "VERSION" INNER JOIN tmpIds ON "VERSION"."VERSION_ID" = tmpIds.id drop table tmpIds


1

From the Oracle 11g Documentation: A datafile can be associated with only one tablespace and only one database. So you don't have to worry about losing data from another tablespace.


1

You could use multiple SELECT Statements, like this: SELECT CHT.ID, (SELECT SUM(TOTAL_E + TOTAL_F + TOTAL_STOC) FROM DEP_DEZ WHERE FK_ID_CHESTIONAR = cht.ID), (SELECT SUM(MASA_TOTALA) FROM CAR_EXP WHERE FK_ID_CHESTIONAR = CHT.ID) FROM CHEST cht GROUP BY CHT.ID



Only top voted, non community-wiki answers of a minimum length are eligible