You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for DBA_TABLESPACES


1 to 20 of 34 results. Previous page Prev  Next next page


Database Reference, 12c Release 1 (12.1)

DBA_TABLESPACES

VARCHAR215   Indicates how the IM column store is distributed by default for this tablespace in an Oracle…DEF_INMEMORY_COMPRESSION Footref 2

Database Reference, 12c Release 1 (12.1)

DBA_TABLESPACES

VARCHAR28   Indicates the default priority for In-Memory Column Store IM column store population for…DEF_INMEMORY_DISTRIBUTE Footref 2

Database Reference, 12c Release 1 (12.1)

DBA_TABLESPACES

VARCHAR213   Indicates the duplicate setting for the IM column store in an Oracle RAC environment: NO…Hybrid Columnar Compression is a feature of the Enterprise Edition of Oracle Database that is dependent on the underlying storage system. See Oracle Database Concepts for more information. This column is available starting with Oracle Database 12 c Release 1 (12.1.0.2). See Also: \" USER_TABLESPACES \"

Database Reference, 12c Release 1 (12.1)

DBA_TABLESPACES

DEF_INMEMORY Foot 2 VARCHAR28   Indicates whether the In-Memory Column Store IM column store is by default…ARCHIVE HIGH Footref 1 NULL DEF_INMEMORY Foot 2 VARCHAR2(8)   Indicates whether the In-Memory Column Store (IM column store) is by default enabled ( ENABLED ) or disabled ( DISABLED ) for tables in this tablespace DEF_INMEMORY_PRIORITY Footref 2

Database Reference, 12c Release 1 (12.1)

DBA_TABLESPACES

6.59 DBA_TABLESPACESDBA_TABLESPACES describes all tablespaces in the database. Related View USER_TABLESPACES describes

Database Reference, 12c Release 1 (12.1)

DBA_TABLESPACES

VARCHAR217   Indicates the default compression level for the IM column store for this tablespace: NO…DEF_INMEMORY_DUPLICATE Footref 2

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.14.2 Example 1: Listing Tablespaces and Default Storage ParametersYou can query the DBA_TABLESPACES view to list the names and default storage parameters. To list … the DBA_TABLESPACES view: SELECT TABLESPACE_NAME \"TABLESPACE\", INITIAL_EXTENT \"INITIAL_EXT … DBA_TABLESPACES; TABLESPACE INITIAL_EXT NEXT_EXT MIN_EXT MAX_EXT PCT_INCREASE

Database Reference, 12c Release 1 (12.1)

USER_TABLESPACES

6.586 USER_TABLESPACESPLUGGED_IN ) are the same as those in DBA_TABLESPACES. See Also: \" DBA_TABLESPACES \"

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.2.4 Compressed Tablespacestablespace as a bigfile tablespace: DBA_TABLESPACES USER_TABLESPACES V$TABLESPACE Query these views for

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Data Files and Temp Files

14.9 Mapping Files to Physical Devicesas DBA_TABLESPACES, DBA_DATA_FILES, and V$DATAFILE, that provide a mapping of files onto devices

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Undo

Two alert thresholds are defined by default: warning and critical. The warning threshold is the limit…can use the DBA_TABLESPACES view to determine the retention guarantee setting for the undo tablespace

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

13.14.1 Tablespace Data Dictionary ViewsDBA_TABLESPACES, USER_TABLESPACES Descriptions of all (or user accessible) tablespaces

Database Administrator's Guide, 12c Release 1 (12.1)

Managing Tablespaces

There are general limitations on transporting data. There are also limitations that are specific to…); 13.2.5.3 Viewing Information About Encrypted Tablespaces You can query the DBA_TABLESPACES and … USER_TABLESPACES data dictionary views for information about encrypted tablespaces. The DBA_TABLESPACES

Database Reference, 12c Release 1 (12.1)

DBA_HIST_TABLESPACE_STAT

5.72 DBA_HIST_TABLESPACE_STATsnapshots of V$TABLESPACE and DBA_TABLESPACES. Column Datatype NULL Description SNAP_ID NUMBER NOT … : Where n is the applicable container ID for the rows containing data See Also: \" V$TABLESPACE \" \" DBA_TABLESPACES \"

Database Administrator's Guide, 12c Release 1 (12.1)

Transporting Data

15.1.4 General Limitations on Transporting Datap.tablespace_name from dba_tablespaces p, dba_xml_tables x, dba_users u, all_all_tables t where t.table_name

Database SQL Language Reference, 12c Release 1 (12.1)

storage_clause

storage_clausetablespace, unless the value of ALLOCATION_TYPE is USER for the tablespace in the DBA_TABLESPACES data … dictionary view. See Also: Oracle Database Reference for more information on the DBA_TABLESPACES

Database SQL Language Reference, 12c Release 1 (12.1)

CREATE TABLESPACE

CREATE TABLESPACEunavailable immediately after creation. The data dictionary view DBA_TABLESPACES indicates whether each … the SEGMENT_SPACE_MANAGEMENT column of the DBA_TABLESPACES or USER_TABLESPACES data dictionary view

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Making User-Managed Database Backups

Making User-Managed Backups of Tablespaces in CDBsDBA_TABLESPACES view to determine which tablespaces are read-only. For example, run this query … : SELECT TABLESPACE_NAME, STATUS FROM DBA_TABLESPACES WHERE STATUS = 'READ ONLY'; Before beginning a … for more information about the DBA_DATA_FILES and DBA_TABLESPACES views Making User-Managed Backups

Database Backup and Recovery User's Guide, 12c Release 1 (12.1)

Transporting Data Across Platforms

Performing Cross-Platform Transport of Tablespaces in a PDBdetermines the status of the tablespace sales_tbs. SQL> SELECT status FROM dba_tablespaces WHERE

Database 2 Day DBA, 12c Release 1 (12.1)

About Views

8.6.1 About Viewsonly for administrators. An example of a DBA_ view is DBA_TABLESPACES, which contains one row for