For sequence limit if you have prefix table name, (like TDT for Table Technical Data, or TPA for Table Param ...) u can use a sequence by prefix also ...
So we use it on create trigger. The idea is good for "write trigger" so it depend of the use. We use sequence for technical key and we store other critical number on a specific table, like Sebastian SITC said.