|
|
Topic |
Replies |
Views |
Last message |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Patch conflict DB12.2.0.1, SPARC |
0 |
13482 |
Thu, 14 April 2022 08:53 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SGA/PGA history Oracle 19c EE on Linux |
3 |
14772 |
Sat, 09 April 2022 12:38 By: piripicchio ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Defragmentation of partitioned indexes to reclaim space. Oracle 12C By: kurki on Mon, 04 April 2022 |
11 |
19579 |
Wed, 06 April 2022 09:09 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
tnsping sqlnet.ora not listing Oracle 12c, linux By: patdev on Thu, 31 March 2022 |
1 |
10601 |
Thu, 31 March 2022 14:37 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Large SHARED_POOL_RESERVED_SIZE, inflated V$SQL Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production |
8 |
19191 |
Thu, 10 March 2022 11:18 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-01805 Timezone files error |
5 |
31110 |
Thu, 10 March 2022 04:28 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Deviations in the databases Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core) |
11 |
20947 |
Thu, 10 March 2022 04:20 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
upgrade database from 11G to 19C 11G (11.2.0.4.0) |
3 |
11048 |
Thu, 17 February 2022 10:40 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-00308 ,ORA-27041 -ARCHIVELOG Missing |
1 |
9718 |
Mon, 24 January 2022 11:21 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
message XDB initialized appeared multiple time in alert log (merged) RAC 19 C on linux 7.6 |
1 |
10909 |
Mon, 13 December 2021 23:25 By: janakors ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
creating a sql plan baseline throws ORA-13846: Cannot create SQL plan baseline on the given plan Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
1 |
13393 |
Wed, 01 December 2021 12:39 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-30928: Connect by filtering phase runs out of temp tablespace Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core) |
2 |
14803 |
Fri, 26 November 2021 00:25 By: BalajiDBA ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Truncate SYS.AUD$ Using dbms_audit_mgmt Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production |
11 |
32087 |
Wed, 24 November 2021 03:47 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
log_archive_dest truncate Oracle12.2 By: Mat44 on Fri, 01 October 2021 |
2 |
11804 |
Fri, 01 October 2021 04:47 By: Mat44 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
understanding user profile resource parameter CPU_PER_CALL Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 |
1 |
9975 |
Fri, 24 September 2021 10:27 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
RMAN backup hangs Oracle 18.3, OEL 7.7 |
4 |
22519 |
Tue, 14 September 2021 10:40 By: gazzag ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Broken Job Oracle 12 Unix |
1 |
14391 |
Wed, 11 August 2021 05:52 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Unified Auditing Trail to find grants of privileges on an object Oracle Database Version 19.11.0.0.0 |
6 |
24853 |
Tue, 27 July 2021 14:54 By: wtolentino ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Too many parse error with error-12850 Oracle, 12.1.0.2, Windows By: patdev on Thu, 15 July 2021 |
3 |
20667 |
Fri, 16 July 2021 07:58 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
User process details (merged) By: unna on Wed, 02 June 2021 |
4 |
24971 |
Tue, 08 June 2021 15:04 By: unna ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
can select on dba_segments view but throwing error when using on a package Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production |
11 |
23789 |
Tue, 01 June 2021 12:09 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
DISK_ASYNCH_IO=TRUE, FILESYSTEMIO_OPTIONS=SETALL but v$iostat.file=ASYNC_OFF Oracle 19.3 |
7 |
19488 |
Tue, 25 May 2021 09:13 By: burkinaone ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
db_32k_cache_size RHEL RHEL 7.9, Oracle 19.3 |
6 |
16276 |
Fri, 21 May 2021 15:27 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
VARCHAR2 Stored in DB in Terms of Bytes Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit |
1 |
13306 |
Sat, 08 May 2021 00:45 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Grant Select rights Oracle 12c Win 2008 |
2 |
15382 |
Wed, 05 May 2021 15:20 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORA-01918: user 'HR' does not exist By: dancko on Mon, 26 April 2021 |
4 |
19349 |
Mon, 26 April 2021 05:15 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Export and Import of huge schemas 19c |
1 |
14697 |
Fri, 16 April 2021 04:02 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon5.gif](/forum/images/message_icons/icon5.gif) |
ORA-01653: unable to extend table Oracle 11.2.0.4.0 By: ak1900 on Wed, 07 April 2021 |
1 |
8850 |
Wed, 07 April 2021 09:10 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Not able to hot clone remote pdb with same name 19.0.0, Windows 2016 |
5 |
15991 |
Mon, 29 March 2021 12:52 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Database resources |
4 |
12718 |
Sat, 27 March 2021 08:23 By: BlackSwan ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
audit use of dynamic sql DB 19.x |
3 |
16429 |
Fri, 19 March 2021 14:49 By: John Watson ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
SYS Account locked Oracle 18c Windows 10 |
1 |
9341 |
Tue, 16 March 2021 12:30 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Transactions are failing due to insufficient space in the undo tablespace Oracle 12.2.0.1, Linux 6 |
10 |
15665 |
Mon, 15 March 2021 10:56 By: EdStevens ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
![icon1.gif](/forum/images/message_icons/icon1.gif) |
Restrict email recipients Oracle Database Standard, 12.1.0.2, RHEL 7 |
5 |
13560 |
Wed, 10 March 2021 18:12 By: jtaylor75 ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Oracle Database Migration Oracle 11g,12c, Unix |
5 |
15645 |
Mon, 08 March 2021 00:32 By: BalajiDBA ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
ORACLE LICENSE ORACLE DATABASE 19c |
6 |
10101 |
Tue, 23 February 2021 09:33 By: merouanballout ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how many oracle tools do we really need to install for SE2 edition 19.0.0 windows 2016 |
0 |
6944 |
Tue, 09 February 2021 23:06 By: juniordbanewbie ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
Tablespace size |
9 |
10242 |
Tue, 09 February 2021 11:39 By: Michel Cadot ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
how to manually remove components in 12.1.0.2 CDB Oracle Linux 7.6 |
2 |
10417 |
Mon, 08 February 2021 15:41 By: Olexandr Siroklyn ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |
![The read & unread messages are only tracked for registered users](/forum/theme/orafaq/images/read.png) |
|
startup upgrade any oracle version |
1 |
7115 |
Mon, 08 February 2021 14:49 By: Andrey_R ![Go to the last message in this topic](/forum/theme/orafaq/images/goto.gif) |