Reputation
787
Top tag
Next privilege 1,000 Rep.
See vote count; VIP usercard
Badges
2 7
Newest
 Yearling
Impact
~32k people reached

  • 0 posts edited
  • 0 helpful flags
  • 28 votes cast
Apr
23
revised How to check if restored database is the same as original
edited body
Apr
22
answered How to check if restored database is the same as original
Apr
18
comment Oracle 11g hash join vs nested loops question
Then the problem is somewhere else. You can try to use the cardinality hint to advice the expected number of rows used, but if the factor is only 2 it will not help probably.
Apr
17
answered Oracle 11g hash join vs nested loops question
Apr
16
comment cluster_database TRUE/FALSE what does it mean in Oracle RAC?
check that docs. If configured properly the clusterware should assing virtual IP from one node onto another, than start the listener and the database on another cluster node.
Apr
16
revised cluster_database TRUE/FALSE what does it mean in Oracle RAC?
added 552 characters in body
Apr
16
comment cluster_database TRUE/FALSE what does it mean in Oracle RAC?
Of course they are different. But when you have SIDs: A1, A2 and B. Then A1 and A2 belong to a database "A" and "B" is standalone database. You can also execute select * from gv$instance and you will get status of all your instances within the database.
Apr
16
answered cluster_database TRUE/FALSE what does it mean in Oracle RAC?
Apr
8
comment jdbc connection string ORACLE , integrated security
PS: there is also possibility to use tnsnames.ora. Then these vendor specific properties can be put into config file, which is under DBAs control.
Apr
3
comment When a record is locked in Oracle, can we know which record is locked?
Oracle (on contrary from other databases) does not have any shared structure for locks. This makes the database scalable, but in the other hand you can not see all locks. Locks are stored in database blocks directly. In the moment when somebody gets blocked a structure "holder-waiter" is created. Then you will see this pair in V$LOCK.
Apr
1
revised Oracle Database Migration using Oracle SQL Developer
added 193 characters in body
Apr
1
comment Can Oracle have too much RAM?
You have quite mature version, so you should not be afraid. There were bug related to HUGE_PAGES, or when using MEMORY_TARGET Oracle won't start if more than 2GB of RAM were used. But it should be over. 25GB is not very much.
Apr
1
answered Oracle Database Migration using Oracle SQL Developer
Apr
1
revised Why is Oracle's number datatype so HUGE? and why do I seem to have no alternatives?
added 175 characters in body
Apr
1
answered Why is Oracle's number datatype so HUGE? and why do I seem to have no alternatives?
Mar
27
comment How to disable flashback query logging for a specific table (Oracle)?
I'm afraid this question is not well defined. redo, undo, flashback-logs are different things, although they are strictly connected. Do you have problems with redologs generated, flashback logs generated, undo space usage or disk i/o in general?
Mar
27
revised Compressing partition - what about index?
added 709 characters in body
Mar
27
comment Compressing partition - what about index?
yes you're right. the SQL was wrong. I fixed it - only one partition should be used.
Mar
27
revised Compressing partition - what about index?
added 24 characters in body
Mar
26
answered Compressing partition - what about index?