OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration

Please read the OraFAQ Forum Guide before posting.

Please contribute good answers to the wiki.

Show: Today's Messages :: Unanswered Messages :: Polls :: Message Navigator

Topic	Replies	Views	Last message
Defragmentation of partitioned indexes to reclaim space. Oracle 12C By: kurki on Mon, 04 April 2022	11	18938	Wed, 06 April 2022 09:09 By: EdStevens
tnsping sqlnet.ora not listing Oracle 12c, linux By: patdev on Thu, 31 March 2022	1	10050	Thu, 31 March 2022 14:37 By: Michel Cadot
Large SHARED_POOL_RESERVED_SIZE, inflated V$SQL Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production By: Andrey_R on Tue, 08 March 2022	8	18434	Thu, 10 March 2022 11:18 By: John Watson
ORA-01805 Timezone files error By: db_senior on Mon, 26 July 2021	5	30412	Thu, 10 March 2022 04:28 By: Andrey_R
Deviations in the databases Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core) By: BalajiDBA on Mon, 06 December 2021	11	20395	Thu, 10 March 2022 04:20 By: Andrey_R
upgrade database from 11G to 19C 11G (11.2.0.4.0) By: vaibhav8080 on Wed, 16 February 2022	3	10509	Thu, 17 February 2022 10:40 By: Michel Cadot
ORA-00308 ,ORA-27041 -ARCHIVELOG Missing By: Khader Hussain on Mon, 24 January 2022	1	9105	Mon, 24 January 2022 11:21 By: Michel Cadot
message XDB initialized appeared multiple time in alert log (merged) RAC 19 C on linux 7.6 By: janakors on Mon, 13 December 2021	1	10230	Mon, 13 December 2021 23:25 By: janakors
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 By: wtolentino on Wed, 01 December 2021	1	12611	Wed, 01 December 2021 12:39 By: Michel Cadot
ORA-30928: Connect by filtering phase runs out of temp tablespace Oracle,18.0.0.0.0, CentOS Linux release 7.6.1810 (Core) By: BalajiDBA on Thu, 25 November 2021	2	14220	Fri, 26 November 2021 00:25 By: BalajiDBA
Truncate SYS.AUD$ Using dbms_audit_mgmt Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production By: mushy_1983 on Sun, 17 October 2021	11	30964	Wed, 24 November 2021 03:47 By: John Watson
log_archive_dest truncate Oracle12.2 By: Mat44 on Fri, 01 October 2021	2	11242	Fri, 01 October 2021 04:47 By: Mat44
understanding user profile resource parameter CPU_PER_CALL Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 By: wtolentino on Fri, 24 September 2021	1	9376	Fri, 24 September 2021 10:27 By: Michel Cadot
RMAN backup hangs Oracle 18.3, OEL 7.7 By: ApnaDBA on Sun, 15 August 2021	4	21508	Tue, 14 September 2021 10:40 By: gazzag
Broken Job Oracle 12 Unix By: tractor_boy on Wed, 11 August 2021	1	13875	Wed, 11 August 2021 05:52 By: John Watson
Unified Auditing Trail to find grants of privileges on an object Oracle Database Version 19.11.0.0.0 By: wtolentino on Tue, 27 July 2021	6	24146	Tue, 27 July 2021 14:54 By: wtolentino
Too many parse error with error-12850 Oracle, 12.1.0.2, Windows By: patdev on Thu, 15 July 2021	3	19533	Fri, 16 July 2021 07:58 By: Michel Cadot
User process details (merged) By: unna on Wed, 02 June 2021	4	24401	Tue, 08 June 2021 15:04 By: unna
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 By: wtolentino on Wed, 26 May 2021	11	23141	Tue, 01 June 2021 12:09 By: Michel Cadot
DISK_ASYNCH_IO=TRUE, FILESYSTEMIO_OPTIONS=SETALL but v$iostat.file=ASYNC_OFF Oracle 19.3 By: burkinaone on Fri, 21 May 2021	7	18938	Tue, 25 May 2021 09:13 By: burkinaone
db_32k_cache_size RHEL RHEL 7.9, Oracle 19.3 By: burkinaone on Tue, 18 May 2021	6	15721	Fri, 21 May 2021 15:27 By: EdStevens
VARCHAR2 Stored in DB in Terms of Bytes Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit By: robh0502 on Sat, 08 May 2021	1	12778	Sat, 08 May 2021 00:45 By: Michel Cadot
Grant Select rights Oracle 12c Win 2008 By: Linou14 on Wed, 05 May 2021	2	14859	Wed, 05 May 2021 15:20 By: EdStevens
ORA-01918: user 'HR' does not exist By: dancko on Mon, 26 April 2021	4	18504	Mon, 26 April 2021 05:15 By: Michel Cadot
Export and Import of huge schemas 19c By: JackBauer on Fri, 16 April 2021	1	14160	Fri, 16 April 2021 04:02 By: Michel Cadot
ORA-01653: unable to extend table Oracle 11.2.0.4.0 By: ak1900 on Wed, 07 April 2021	1	8236	Wed, 07 April 2021 09:10 By: John Watson
Not able to hot clone remote pdb with same name 19.0.0, Windows 2016 By: juniordbanewbie on Thu, 25 March 2021	5	15393	Mon, 29 March 2021 12:52 By: John Watson
Database resources By: JackBauer on Fri, 26 March 2021	4	12147	Sat, 27 March 2021 08:23 By: BlackSwan
audit use of dynamic sql DB 19.x By: John Watson on Thu, 18 March 2021	3	15901	Fri, 19 March 2021 14:49 By: John Watson
SYS Account locked Oracle 18c Windows 10 By: grh_oracle on Tue, 16 March 2021	1	8830	Tue, 16 March 2021 12:30 By: Michel Cadot
Transactions are failing due to insufficient space in the undo tablespace Oracle 12.2.0.1, Linux 6 By: BalajiDBA on Thu, 11 March 2021	10	15128	Mon, 15 March 2021 10:56 By: EdStevens
Restrict email recipients Oracle Database Standard, 12.1.0.2, RHEL 7 By: jtaylor75 on Wed, 10 March 2021	5	13056	Wed, 10 March 2021 18:12 By: jtaylor75
Oracle Database Migration Oracle 11g,12c, Unix By: BalajiDBA on Sat, 06 March 2021	5	15093	Mon, 08 March 2021 00:32 By: BalajiDBA
ORACLE LICENSE ORACLE DATABASE 19c By: merouanballout on Tue, 23 February 2021	6	9565	Tue, 23 February 2021 09:33 By: merouanballout
how many oracle tools do we really need to install for SE2 edition 19.0.0 windows 2016 By: juniordbanewbie on Tue, 09 February 2021	0	6454	Tue, 09 February 2021 23:06 By: juniordbanewbie
Tablespace size By: JackBauer on Tue, 09 February 2021	9	9686	Tue, 09 February 2021 11:39 By: Michel Cadot
how to manually remove components in 12.1.0.2 CDB Oracle Linux 7.6 By: juniordbanewbie on Tue, 12 January 2021	2	9888	Mon, 08 February 2021 15:41 By: Olexandr Siroklyn
startup upgrade any oracle version By: Olexandr Siroklyn on Mon, 08 February 2021	1	6625	Mon, 08 February 2021 14:49 By: Andrey_R
ORA-04031: unable to allocate 4064 bytes of shared memory Oracle 11g XE, MS Windows 7 Enterprise, 8GB RAM By: Littlefoot on Fri, 25 December 2020	4	16446	Mon, 08 February 2021 13:23 By: Littlefoot
Trace non-invokers sessions of a different instance Oracle Database 19c By: Andrey_R on Sun, 07 February 2021	7	9655	Mon, 08 February 2021 08:32 By: Andrey_R