4
votes
Accepted
How to terminate user's sessions in Oracle DB exactly 8 hours after user connected?
CREATE PROFILE
To specify resource limits for a user, you must:
Enable resource limits dynamically with the ALTER SYSTEM statement or with the initialization parameter RESOURCE_LIMIT. This parameter
...
1
vote
oracle - Calculate sum or avg in one query based on the their value
See if this (conditional aggregate) helps.
Sample data:
SQL> with test (datum, customer, amount, percentage, category) as
2 (select 20220330, 'customer1', 10, 93, '01' from dual union all
3 ...
1
vote
Manually change datafile size or let oracle do the job during schema duplication
it depends.
If you absolutely want to make sure your import does not fail on space problems -> pre-alloc the space.
If your import is part of a reorganisation job where you would try to win back ...
1
vote
Remove third ordinate from string of 3 ordinates
There is a far easier way of doing this than the answer here suggests. A single regular expression (regex) can do it all and replace ~ 20 lines of complicated non-standard SQL in a single line with a (...
Only top scored, non community-wiki answers of a minimum length are eligible
Related Tags
oracle × 7511oracle-11g-r2 × 1027
oracle-12c × 713
oracle-11g × 528
plsql × 474
performance × 299
oracle-10g × 274
rman × 257
sql-server × 246
sqlplus × 220
oracle-sql-developer × 175
linux × 165
index × 163
backup × 150
database-design × 140
trigger × 136
installation × 129
permissions × 128
join × 112
mysql × 110
query-performance × 108
stored-procedures × 107
migration × 102
restore × 92
tablespaces × 92