list_sequences
Lists Oracle sequences with range, increment, last number, cycle flag, and cache size from ALL_SEQUENCES; filter by schema and note cache gaps after crashes or rollbacks.
Instructions
List sequences with their range, increment, last number, cycle flag and cache size (queried from ALL_SEQUENCES, not DBA_SEQUENCES). cache_size > 0 means values are pre-allocated, so gaps can appear after a crash or rollback. For a single sequence's full metadata (including order_flag) use get_sequence_info. Optional schema filter.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema (owner) name. Omit to search all schemas. |