I need to know why example table space is created by Oracle 11g ? Does it effects the performance if it is full ? if yes how can we stop it being used ?
Thanks
8
-
Welcome to the DBA.SE community. Could you please be a bit more specific? What is the name of this example tablespace? Click on the edit link and add more details to your question. Refrain from using screen shots if possible and instead script out the DDL for the tablespaces in question. Thanks.– John K. N.Dec 30, 2021 at 7:05
-
/opt/oracle/product/12.2.0/srvm/admin/clustdb.sql:CREATE TABLESPACE "EXAMPLE" LOGGING DATAFILE '/dev/vx/rdsk/oracle_dg/clustdb_raw_example_160m' SIZE 140M REUSE AUTOEXTEND ON NEXT 640K MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;– Gerard H. PilleDec 30, 2021 at 10:09
-
Why did you install an old version of Oracle? I've never heard of the EXAMPLES tablespace on 11g. 21c ATP? Yes. But not 11g.– Michael KutzDec 30, 2021 at 11:31
-
@GerardH.Pille - the DDL you posted in a comment would be much easier to read if you had edited your question and posted it there as formatted text. That said - first, the size or utilization of a TS does not affect performance. Are you seeing performance issues? Second, you could always query DBA_SEGMENTS to see what is in the TS. If it is nothing but examples that you don't need, you could DROP the objects and the TS.– EdStevensDec 30, 2021 at 13:30
-
@EdStevens, I think you're barking up the wrong tree.– Gerard H. PilleDec 30, 2021 at 14:18
|
Show 3 more comments
1 Answer
A tablespace is just a logical set of data files. It is ok for data files to be full; this will not affect performance unless you add data to a full tablespace. At that point you may have to wait for a data file to grow according to its autoextend settings, or if it is already at its maximum allowed size you may encounter an error stating that more space was not available and the tablespace could not be extended.
Since "EXAMPLES" should contain nothing but sample data such as the "SCOTT" schema and should not be expected to grow, it should not directly affect the performance of your database. If you are running backups, it will affect the size of your backup sets, but that is all.
