Sep
5
comment Copy DBF files from production to development environment
VCarstein your opening line is wrong: "Yes, copying DBF files is one way how you can make a copy of an existing database". I did not downvote but please try to be more precise in future.
Jul
2
answered Cannot export SELECT result as expected
May
12
awarded  Yearling
Feb
18
comment audit policy on a table does not log expected results
Does it work without that WHERE clause?
Feb
18
comment Oracle uses a lot of memory
How many people connect to this "server"? Seems way too under-powered to be a server, it's more like a stand-alone PC. Your user sessions consume anywhere above 10M per session, so make sure they are disconnecting once all their work is done.
Feb
15
revised Sqlplus not using NLS_LANG env variable
added 2 characters in body
Feb
15
answered Sqlplus not using NLS_LANG env variable
Feb
14
answered ORA-27102: out of memory
Jan
14
comment Is it possible to show DML that is locking some table?
Agree with Ed. You can look at V$ACTIVE_SESSION_HISTORY but even that can miss the offending statement. The only way to find it is in a trace of the session, and even then it might be hard to find the SQL that caused the lock. The good news is that it's usually obvious as a select for update runs for long enough to catch it.
2018
Dec
4
comment Creating an Oracle 11.2-Compatible Database in Oracle 12.2.0.1
Does it have to be dbca? Balazs' answer shows you how to create one with scripts, but he had to use UPGRADE mode eventually. Upgrading does the same thing, more or less.
Dec
3
answered Creating an Oracle 11.2-Compatible Database in Oracle 12.2.0.1
Nov
30
comment Measuring Character Set Conversion
No I never said I downgraded, did I? DMA will only tell you about what you want to migrate to, whether it is a superset or subset. DMA does not care what you choose and will not make suggestions.
Nov
28
answered Measuring Character Set Conversion
Nov
20
answered ORA-03113 when starting up an Oracle 11g database
Nov
16
comment Impdp 12c takes table original size
It will use the init and next segment sizes when creating the table. You will have to create it manually before you do the import.
Oct
23
comment Oracle Top CPU Consuming SQL is “select longdbcs from javasnm$ where short = :1”
Number of executions for this SQL is because it is running on Oracle's JVM. I am saying it should not run there. Whether you use connection pooling or not will not affect that SQL, but since you're using OEM I assume you are monitoring large databases. If that is the case, then you should be using connection pooling via clusters. This is necessary for oracle session management, as repetitive connection/disconnection is not scaleable for performance.
Oct
15
answered Oracle Top CPU Consuming SQL is “select longdbcs from javasnm$ where short = :1”
Oct
8
answered Time Difference Between Two Consecutive Rows
Aug
20
awarded  Scholar
Aug
20
accepted Oracle 12 Startup upgrade throws error 443