Skip to content

Instantly share code, notes, and snippets.

@dincosman

dincosman/index_on_smon_scn.sql

Created January 22, 2023 21:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dincosman/a03a6d6bae045b92283c4af4e646df64 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dincosman/a03a6d6bae045b92283c4af4e646df64 to your computer and use it in GitHub Desktop.
Download ZIP
create index on smon_scn_time table
Raw
index_on_smon_scn.sql
SQL> CREATE INDEX SYS.SMON_SCN_TIME_TIM_IDX_TEMP ON SYS.SMON_SCN_TIME
(SCN_WRP * 4294967296 + SCN_BAS)
LOGGING
TABLESPACE SYSAUX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
NEXT 1M
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
BUFFER_POOL DEFAULT
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment