# oceanbase-config

Part of **OCEANBASE**

# OceanBase Database Configuration Console Guide

## Operations Overview

| Operation | Console Entry Path | Prerequisites | Description |
|----------|-------------------|---------------|-------------|
| View NLS Parameters | Documentation > OceanBase Database > SQL Reference > System Views > nls_database_parameters, nls_session_parameters | Access to OceanBase database instance with appropriate privileges; familiarity with obclient command-line tool | View database-level and session-level National Language Support (NLS) configuration parameters using system views or SQL statements |

## Operation Steps

### View NLS Parameters

**Navigation**: Documentation > OceanBase Database > SQL Reference > System Views > nls_database_parameters, nls_session_parameters

**Prerequisites**:
- Access to an OceanBase database instance with appropriate privileges
- Familiarity with obclient command-line tool

1. Navigate to the OceanBase official documentation portal.
   - Element: **Documentation** (link) — top navigation bar
   - Notes: Ensure you are viewing the English version of the documentation

2. In the left-side navigation panel, expand **OceanBase Database**, then **SQL Reference**, then **System Views**.
   - Element: **System Views** (menu) — left navigation panel

3. Click on the entry for **nls_database_parameters, nls_session_parameters**.
   - Element: **nls_database_parameters, nls_session_parameters** (link) — within System Views section
   - Notes: A new documentation page loads showing details about NLS parameter views

4. Review the example SQL queries provided in the documentation.
   - Element: **Code Example Block** (section) — main content area
   - Notes: These examples use `SELECT * FROM sys.nls_database_parameters;` and similar statements

5. To apply this in the actual database console, open your SQL client (e.g., obclient) connected to your OceanBase instance.
   - Element: **obclient terminal** (link) — external to web console
   - Notes: The web console itself does not provide a built-in SQL editor for this operation; it is documented for reference

6. Execute one of the documented queries, such as:
   ```sql
   SELECT * FROM sys.nls_database_parameters;
   ```
   - Element: **SQL Query Input** (text_input) — in your SQL client
   - Notes: Results will display a table with columns **PARAMETER** and **VALUE**

7. Observe the returned NLS parameters, such as **NLS_DATE_FORMAT**, **NLS_TIMESTAMP_FORMAT**, etc.
   - Element: **Query Result Table** (table_row) — output in SQL client
   - Notes: Parameter names and values appear exactly as defined in the system views

**Form Fields**: None — this operation involves querying read-only system views, not filling out forms.

## FAQ

Q: Can I modify NLS parameters directly through the OceanBase web console?
A: No. NLS parameters like those in `sys.nls_database_parameters` are read-only and reflect database defaults. Session-level parameters can be changed via SQL (e.g., `ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD'`), but not through a GUI form in the current console.

Q: Where can I find the list of all supported NLS parameters?
A: The full list is available by querying `sys.nls_database_parameters` (for database defaults) or `sys.nls_session_parameters` (for current session settings) using a SQL client connected to your OceanBase Oracle tenant.

Q: Does changing session-level NLS parameters affect other users?
A: No. Session-level changes (e.g., via `ALTER SESSION`) only apply to your current connection and do not impact other sessions or the global database configuration.

Q: Are character set parameters like character_set_client part of NLS settings?
A: Yes. Parameters such as **character_set_client**, **character_set_results**, and **character_set_server** are related to internationalization and are often grouped with NLS concepts, though they may appear under different system views or `SHOW VARIABLES` output.

Q: Do I need special permissions to view NLS parameters?
A: You need at least read access to the `sys` schema. Typically, users with basic query privileges on system views can execute `SELECT` on `nls_database_parameters` and `nls_session_parameters`.

## Pricing & Billing

### Billing Model
free

### Free Tier
No explicit free tier mentioned; usage depends on underlying infrastructure.

### Billing Notes
NLS parameter viewing is a metadata operation and does not incur additional costs.