Home » RDBMS Server » Server Administration
Please read the OraFAQ Forum Guide before posting.
Please contribute good answers to the wiki.

    Replies Views Last message
  How to get size in MB of all objects in a Schema in Oracle?
Oracle database, sql
By: Vinish on Mon, 19 October 2020
4 4225 Mon, 19 October 2020 16:12
By: EdStevens
  SGA used
Oracle 12.2
By: deepakdot on Thu, 15 October 2020
17 5909 Thu, 15 October 2020 09:22
By: John Watson
  How to deal with statistics during migration
By: burkinaone on Fri, 02 October 2020
3 6216 Wed, 07 October 2020 09:35
By: John Watson
  Oracle12c Blocking Session Information
Oracle 12c
By: rohitmathur11@gmail.com on Tue, 06 October 2020
15 5902 Wed, 07 October 2020 02:59
By: rohitmathur11@gmail.com
  TEMPORARY TABLESPACE UTILIZATION TREND
Oracle Enterprise, 11.2.0.3, AIX 6.1
By: jesuisantony on Mon, 07 September 2020
3 6145 Mon, 07 September 2020 14:46
By: Michel Cadot
  Temp Tablespace Issue somehow fixed SQL advisor
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 02 September 2020
4 4992 Thu, 03 September 2020 12:22
By: wtolentino
  Empty Datafile
ORACLE 12.1.0.2.0 Standard Edition
By: wintert on Thu, 27 August 2020
7 7274 Thu, 03 September 2020 11:13
By: EdStevens
  UPDATE taking a long time, indication disappeared
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
By: Andrey_R on Mon, 31 August 2020
5 5209 Mon, 31 August 2020 12:38
By: Andrey_R
  histograms in dbms_stats.gather_table_stats
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Fri, 14 August 2020
1 5384 Fri, 14 August 2020 23:25
By: Michel Cadot
  no listener
By: oracle@learner on Sat, 25 July 2020
5 8695 Mon, 27 July 2020 06:21
By: EdStevens
  Oracle Data Mining component in 19c
Oracle 19c Linux
By: mar20 on Mon, 06 July 2020
4 8445 Tue, 07 July 2020 02:34
By: Michel Cadot
  Wrongly compile function in SYS user now problem
Oracle Forms 6i
By: somu4 on Thu, 02 July 2020
10 12251 Fri, 03 July 2020 10:08
By: EdStevens
  DBA practice on cloud
By: Mark70 on Fri, 26 June 2020
3 7197 Fri, 26 June 2020 09:14
By: EdStevens
  Datafile cannot be open by either non cdb or cdb instance
19.0.0, windows 2016 64 bit
By: juniordbanewbie on Tue, 16 June 2020
4 9323 Wed, 17 June 2020 04:16
By: juniordbanewbie
  How to determine the size of backup increased in last one month
oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM
By: janakors on Tue, 02 June 2020
12 15425 Wed, 10 June 2020 10:41
By: janakors
  SQL text history
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Mon, 08 June 2020
3 7222 Tue, 09 June 2020 00:06
By: Michel Cadot
  Ora-48181. no space left on the device
oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM
By: janakors on Tue, 19 May 2020
13 15260 Thu, 04 June 2020 06:59
By: janakors
  how to verify gather schema statistics
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Fri, 15 May 2020
4 7764 Fri, 15 May 2020 14:18
By: wtolentino
  Oracle DB Upgrade Clarification
Oracle 11.1.0.7 Enterprise Edition, AIX 6.1
By: jesuisantony on Fri, 01 May 2020
4 8162 Fri, 08 May 2020 03:10
By: jesuisantony
  open cursor parameter exceeds but no alarm have been raised
oracle 11g
By: nill on Sat, 25 April 2020
4 6790 Wed, 29 April 2020 07:37
By: Michel Cadot
  Basic Partition compression while run DML statement
By: dancko on Mon, 20 April 2020
8 6312 Mon, 20 April 2020 08:32
By: dancko
  Relink Oracle after OS upgrade
DB19c OL 7.7
By: John Watson on Wed, 25 March 2020
3 9501 Wed, 25 March 2020 10:03
By: John Watson
  Cannot see DBA_USERS with SYS in a new database
Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
By: Andrey_R on Mon, 23 March 2020
2 7108 Mon, 23 March 2020 05:19
By: Andrey_R
  Actualizar vista v$database_block_corruption; (merged)
Oracle 11g
By: fmonjes on Tue, 11 February 2020
7 7477 Wed, 18 March 2020 09:11
By: fmonjes
  how to use catcon with username parameters
19.0.0 windows 2016
By: juniordbanewbie on Mon, 16 March 2020
2 6574 Tue, 17 March 2020 20:55
By: juniordbanewbie
  How many transaction taken place in given time
oracle 12c Windows 2012
By: muthukrish104 on Thu, 12 March 2020
6 8843 Tue, 17 March 2020 08:20
By: EdStevens
  Calculating the size of the depending on the AUTOEXTENSIBALE
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: revathitirun on Mon, 02 March 2020
4 6385 Mon, 02 March 2020 13:57
By: John Watson
  USERS tablespace is filling fast
oracle 11 g r2 RAC of 2 nodes, solaris 10 and ASM
By: janakors on Fri, 28 February 2020
3 6180 Fri, 28 February 2020 05:33
By: cookiemonster
  Oracle Server 11g times out after only a few min online
11g
By: Deaf Smith on Thu, 20 February 2020
3 6292 Mon, 24 February 2020 10:25
By: cookiemonster
  Export Import Issue (Table's count mismatch)
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
By: vippysharma on Wed, 12 February 2020
12 9029 Mon, 17 February 2020 01:44
By: vippysharma
  ERROR - START ORCLE SERVICE IRCL
ORACLE 11G AND WINDOWS
By: ELOISA on Tue, 04 February 2020
4 7501 Fri, 07 February 2020 10:17
By: Michel Cadot
  SPU Patching doubt
Oracle 11.2.0.4
By: jordixmm on Thu, 30 January 2020
4 4857 Thu, 30 January 2020 07:40
By: EdStevens
  how long does the SQL stays in the v$sqlarea or dba_hist_sqltext
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
By: wtolentino on Wed, 22 January 2020
5 7027 Thu, 23 January 2020 10:50
By: wtolentino
  Out of Memory - Runaway Memory, not releasing ORA-04036: PGA memory used by the instance exceeds
12c Release 2, Linux 7, Peoplesoft Tool 8.56
By: oraclefan12345 on Wed, 20 November 2019
3 10301 Wed, 15 January 2020 01:22
By: aladanh
  How to check what takes the most disk space ?
Oracle 12.2
By: a100 on Fri, 27 December 2019
11 11555 Sat, 28 December 2019 13:55
By: a100
  File I/O error
11.2
By: rmestre on Mon, 23 December 2019
4 8740 Mon, 23 December 2019 09:34
By: BlackSwan
  DB Creation process stuck to 85%
12.2.0.1.0
By: vippysharma on Thu, 19 December 2019
2 7647 Sun, 22 December 2019 22:25
By: vippysharma
  Schema Undo
12.2
By: deepakdot on Wed, 11 December 2019
15 13175 Tue, 17 December 2019 07:40
By: JPBoileau
  Oracle TimesTen In-Memory Database
Oracle TimesTen 18.1
By: fabi88 on Tue, 17 December 2019
0 5111 Tue, 17 December 2019 00:14
By: fabi88
  Database upgrades - with No downtime
12c
By: deepakdot on Thu, 14 November 2019
12 14311 Sat, 14 December 2019 12:22
By: deepakdot
Goto Forum:
  
Legend New Messages New Messages   No New messages No New messages   Locked (w/ unread messages) Locked (w/ unread messages)   Locked Locked   Moved to another forum Moved to another forum

Current Time: Sat Oct 16 00:37:00 CDT 2021