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 ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.