Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE timeDate (
- id INT,
- ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- );
- CREATE TABLE add_data_growth AS
- SELECT DATE(`ts`) FROM timedate WHERE id =someId
- SELECT segment_name, bytes/1024/1024 AS MB FROM dba_segments;
- CREATE PROCEDURE collect_sizes
- AS
- BEGIN
- INSERT INTO data_growth select trunc(sysdate), dba_segments.*
- from dba_segments;
- insert into data_growth
- end add_data_growth;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement