reader
A reader, December 31, 2004 - 5:43 pm UTC
THANKS a lot...and may i know what is this cp and pm you have written above
Regards
sachin
RE: oemapp cp and pm
Mark A. Williams, December 31, 2004 - 7:02 pm UTC
Not Tom here, but "cp" is the capacity planner and "pm" is the performance manager.
HTH,
Mark
graphical linux tool for oracle
Antonie Kriek, January 03, 2005 - 2:29 am UTC
January 03, 2005 - 8:37 am UTC
$ sqlplus /
it is brilliant for oracle on any platform :)
question
A reader, September 16, 2005 - 12:06 pm UTC
Hi,
I have Oracle 9.0.4 installed on rh linux 9.
I was trying to use TOra. The "Oracle" connection provider is not available in TOra.
I am able to connect MySql from TOra. but not Oracle.
How can I configure TOra, ODBC or any other configuration related this in Linux.
please help.
Thanks.
September 16, 2005 - 2:00 pm UTC
no idea, never used tora
To get TORA working ...
David Woodard, September 16, 2005 - 3:52 pm UTC
on Linux, you need both the tora*.rpm AND the tora-oracle*.rpm
You can still get the free version of TORA from SourceForge:
</code>
http://sourceforge.net/project/showfiles.php?group_id=16636
If you are running RH 9, looks like you will need the 1.3.15 version, as they only have 1.3.16 for RHEL 4.
When installing the tora-oracle*.rpm, you may get an error stating that "libclntsh.so" is missing as a prereq. If you are planning to just point your environment to an installed ORACLE_HOME, you can tell RPM to skip the dependency check with the "--nodeps" flag (that is assuming libclntsh.so was the ONLY prereq that was missing)
By the way, if you are doing PL/SQL development and need an IDE & PL/SQL debugger, JDeveloper from Oracle does that, and it's now free. See the announcement here:
http://www.oracle.com/technology/products/jdev/htdocs/jdevpricefaq.html#1 <code>
I've been playing with it, and it has a small learning curve like anything else that's new to you, but it looks good.
Hope that helps
September 16, 2005 - 3:54 pm UTC
Thanks David.
THANKS
A reader, September 16, 2005 - 4:33 pm UTC
thanks a lot David and Tom...will try that ....:)
reader
A reader, January 23, 2006 - 5:16 pm UTC
Hi
i have linux 9 rh and oracle 9.2
i start up windowz and directly launch sql*plus tool... it just asks for the username and password..and then i am good to go ,because the database is running as a service at the back end.
but on linux I log on as oracle user,do the following:
>sqlplus /nolog
>connect / as sysdba
>startup
then it starts up and i am good to go.....
question--is there a way to work on linux as i am doing in windowz like just entering the username and password and not to "start up the database" every time i start system...
January 23, 2006 - 11:08 pm UTC
do you know about /etc/init.d and how to configure that sort of stuff?
A reader, January 11, 2010 - 7:26 pm UTC
Sir;
Even Im the only active session in the database.
When I check the user datafile, I see that it is being used by some other process.
How can this happen?
fuser /oracle/u01/oradata/orcl/users01.dbf
/oracle/u01/oradata/orcl/users01.dbf: 1388o 1382o 1380o 1378o 1376o
January 18, 2010 - 12:31 pm UTC
you are never the only session in the database. Look at v$session, you'll find many others.
We have our own sessions, smon, pmon, etc - they all do things in the background, smon regularly queries and modifies data - constantly.
A reader, January 18, 2010 - 6:10 pm UTC
But sir, this is not a datafile of the system tablespace.
I was thinking that there is always activity in system datafiles which are managed by oracle background processes.
January 19, 2010 - 4:12 pm UTC
there is always activity in the database.
You are never alone - never.
They can be doing things in many tablespace (think of statistics gathering, think of AWR data collection/preservation, etc etc etc)
and even if you are the only ACTIVE session, there could be (you don't say) dozens of currently inactive sessions that have files open. It is normal.
If you are curious as to what has that file open - read about lsof, ls open files. You can see who has it open.
A reader, February 02, 2010 - 4:29 pm UTC
Thanks for enlightening me sir;
There is always activity in oracle therefore SCN increments every commit.
What kind of actions does oracle do in background so SCN is
increasing every second? It never hangs or stops.
Therefore somethings should be done every seconds..
I am just wondering what kind of things oracle is doing every second.
(AWR is generally taken once an hour, so this is not the case)
February 03, 2010 - 9:32 am UTC
smon does lots of cleanup work, coalesce tablespaces, recover failed operations, etc - all of which update the dictionary. The job queues run and update themselves. AQ is going. etc etc etc.
AWR is going too - as well as things like table monitoring and many other bits of monitoring.
A reader, February 11, 2010 - 4:57 pm UTC
Does smon also do coalesce for LMT tablespaces periodically?
February 16, 2010 - 11:05 am UTC
does not need to, one of the attributes of a locally managed tablespace is that they never need coalescing - they are managed by bitmaps. If you have a series of "zeroes" we know that is free space. There is no need to combine rows like there used to be with UET$ and FET$ (used extent/free extent) tables.
A reader, February 21, 2010 - 5:44 pm UTC
Thanks sir;
Since contigues extents are not coalesced automically.
When I look dba_free_space to find wheter there is big enough contigues blocks to satisfy next extent size of my table,
I notice that the information may mislead me since extents in dba_free_space may be contigues.
Am I right?
March 01, 2010 - 5:43 am UTC
I feel like I'm going around in circles on this one
In a locally managed tablespace, extents are - by the very method we organized them in the bitmap file header - ALWAYS coalesced, there is no manual or 'psuedo automagic' coalescing necessary. They are ALWAYS coalesced.
In legacy dictionary managed tablespaces, we DO automagicially coalesce them (smon does- as does the process of attempting to allocate space).
Rucksana, October 11, 2017 - 6:50 am UTC
Hey,
I want to create a report in oracle apex which attribute will be comments.
and i also want to a inner comments box . So how can i create it?
October 11, 2017 - 1:01 pm UTC
I've no idea what you're trying to do.
I also don't know how this relates to the original question...